Acdoca fields in sap Could someone please share insights on how to get the same field extended to As the world’s leading SAP publisher, SAP PRESS’ goal is to create resources that will help you accelerate your SAP journey. SAP provides 5 different extensibility options to extend ACDOCA and ACDOCP table. May 21, 2024 · ACDOCA: Serves as the backbone for all financial applications in SAP S/4HANA, from financial planning and analysis to period-end closing activities. Custom fields using the Custom Fields app It is required to add a field from table ACDOCA as special fields in FAGLL03/FBL*N transactions. Jul 4, 2020 · Let's see how the Values get stored for a PO created against a WBS in ACDOCA. SAP Knowledge Base Article - Preview 3301094 - Display fields from table ACDOCA in transaction FAGLL03 Jun 8, 2023 · It may depend on how you created the ACDOCA field. Relvant answers will be awarded accordingly. As postings occur in the general ledger, group reporting fields are recorded along with the rest of the accounting data. Jan 27, 2020 · In the input screen when we give the value of document type which takes the value from acdoca table after we get the output in the document type field doesnt work well with the filtering. Kindly help me on how to add Business Place field in transactions FAGLB03 & F. I believe we can manage to Oct 25, 2018 · I checked the notes you cited. However the BSEG table for these fields are filled. What are the corresponding Fields in S4 System? Could not find a matching field for WRTTP in ACDOCA. It is easy to implement a similar design with the following technologies. I would like to know how they are used, purpose and from which release they are active. SAP Knowledge Base Article - Preview Jan 15, 2018 · With this you can get any field from ACDOCA table or whatever you want. FAGLFLXA (Along with BSIS, BSAS, BSID, BSAD, BSAK, BSIK, Asset tables, CO Tables and ML tables) and FAGLFLEXT gets migrated to ACDOCA and ACDOCT respectively. Currently based on BDC category setting, TSL field from ACDOCA is updating TSL filed in ACDOCU for transaction currency . Aug 22, 2016 · Hi, I would like to know the specific field that you are looking for in ACDOCA which is in BSEG. Note 2431747 mentions BADI BADI_FINS_ACDOC_POSTING_EVENTS that cannot be used because it is intended for customer-specific fields in ACDOCA (and not standard ones like BLART). It added in CL_COBL, ACDOCA, CL_COBL_BI, FB50. These fields are also generated in journal entries in the ACDOCA table. But, our FI team had maintained the new field in ACDOCA table using the COPA function module FCO_ACDOCA_COPA_FIELDS_GEN. FB01, FB60 etc structures, transaction and tables but it didnt added the customer fields in BSEG table. While testing the extended code block in both ACDOCA and ACDOCU, iam facing some issues. Different options in the design of the work areas, for example, customer fields and process enhancements, parallel currencies, multiple accounting principles, and so on. The fields include identifiers like client, ledger, company code and fiscal year. I am able to post docs and see them in ACDOCA table. fields with identical name in BSEG/COEP, and in the append to INCL_EEW_ACDOC will be migrated from BSEG/COEP to ACDOCA automatically. Thanks, Abin Work area-specific object types that have different data fields. For more details information, please check ACDOCA technical details. CO= much detail, Fi= less detail I know the BKPF (Account Header) table will provide further details to each BSEG and ACDOCA. Feb 4, 2018 · # Purpose of this Blog SAP has started recommending Account Based CO-PA in S/4HANA products (S/4HANA and S/4HANA Finance) based on three main innovations (COGS split, variance posting Categories wise, and additional quantity fields) in Account Based CO-PA. RTCUR Balance Transaction Currency RWCUR Transaction Currency RHCUR Company Code Currency RKCUR Global Currency ROCUR Freely Defined Currency 1 RVCUR Freely Defined Curre Jul 29, 2019 · Although this Business Place field is available in FAGLL03H-Line item browser, we want to see the net monthly balances by this field in FAGLB03. Currency Fields & Corresponding Amount fields in ACDOCA; Situation in ECC There are total 511 fields in ACDOCA table. Account based COPA). Apr 1, 2021 · end of ls_acdoca. Below are the recommended ACDOCA extensibility options available in SAP S/4HANA on-premise and SAP S/4HANA Cloud. I receive message: "S/4HANA - large table ACDOCA: WHERE condition does not contain any fields of an HDB table index" Dec 5, 2017 · Hi, We have implemented workflows for approval of accounting documents (Customer). Can we use Substitutions Rules in GR to ad Oct 22, 2020 · Hi, We are on S/4 HANA Group Reporting 1909, SP2 On-Prem. Tried appending the z fields in CI_COBL custom include. The note refers to InfoObjects 0* however, in S/4HANA those infoobjects doesn't exist anymore, instead we have /ERP/* infoobjects. Tried to delete the custom field from CI_COBL but couldn't do so either. Search SAP Tables. FIELD-SYMBOLS: <fs_acdoca> type ls_acdoca, <l_s_data> TYPE FINS_ACDOCA_BW. App ID F1596, Carry Forward Balances, FIORI, CLOUD, fin. . They’re also used to group or categorize different areas that can be accessed frequently. Tables in SAP. Nov 28, 2023 · The ACDOCA table provides a centralized hub for financial data management, integrating information from various applications and streamlining processes. How can we configure Group Reporting in order to release these information from Universal Journal task in Data Monitor? Thank you for your It is impossible to add the three quantity fields (QUANT1, QUANT2, and QUANT3) into the table ACDOCP. The data in the output is not getting filtered according to what value we are giving in the input. Try both, second option is recommended one. Aug 3, 2020 · Custom fields in coding block – Integration to ACDOCA: When you add a custom field in the coding block structure, then will also get added to ACDOCA as integrated. Additionally we provide an overview of the structure and fields of ACDOCA table. BSEG- SGTXT = 'Direct sales' But the issue is : I don't find the field VTWEG (distribution chanel ) for the table BKPF or BSEG but only with the table ACDOCA. 0 ; SAP S Sep 19, 2018 · With the new account-based CO-PA in S/4 HANA Finance, Operating Concern characteristics are included in the Universal Journal table ACDOCA. But the field is not available in the standard list displayed by the match-code. Once the custom fields are created , we will be able to use them as a part of upload file for upload the data using the app” Upload General Journal entries” . 01. I think coding block (OXK3) is for custom fields? Thx for any help! regards, Gerald. Extend the already created field in ACDOCA/ACDOCP The Fiori App Custom Fields and Logic cannot offer you an extension based on fields which are already present in the ACDOCA/ACDOCP table. Below is a PO created against a WBS element. How can we add standard ACDOCA fields in the list ? Thanks Julien Oct 30, 2023 · Dear Experts, we would like to release from Universal Journal the Market information. Understanding Purchase Order Tables in SAP Jun 1, 2022 · Before you try to find the hint somewhere hidden in the application log, the solution is to run report FCO_ADD_COPA_FIELD_TO_ACDOCA for your operating concern in the background. you want to have shown. For a scenario of fields of Appends to COEP and BSEG missing in table ACDOCA for more details, you may refer snote- 2160045 Dec 14, 2018 · As the purpose is to get the ACDOCA data to the virtual BW cube, I could create a HANA view joining ACDOCA and required fields of BSEG, but I cannot think there is no standard way to enhance ACDOCA with BSEG fields. May 14, 2020 · Data volume problems during an SAP S/4HANA Conversion in Enterprise Resource Planning Blog Posts by SAP Wednesday; Dynamic Table Reading in SAP ABAP & Pricing Integration in Enterprise Resource Planning Q&A 2 weeks ago; Asset Accounting (FI-AA) – Insurance values in SAP S/4HANA in Enterprise Resource Planning Blog Posts by Members 3 weeks ago Nov 14, 2023 · Hi, all! We want to create a Custom-Defined Substitution Rule for the Group Reporting Field Derivation in the context of GRPL. 08/F. Aug 4, 2018 · I'm trying to use 0FI_ACDOCA_10 data source to extract data from ACDOCA table. KNA1_NAME1. "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. We need to understand first if these three Oct 22, 2015 · Hello, I added two customer fields in OXK3 - Coding block using Basic Mode. from the Service Order Header into the Query “Service Orders Oct 23, 2017 · Hi, Can anyone help me on below replacement fields for BSEG in ACDOCA. Regards May 16, 2018 · Hi Experts, I was referring to WRTTP(Value Type) , VERSN (Version) Fields are taken from COEP table in ECC. Key Concept: SAP S/4HANA Finance allows the transfer of u Jan 8, 2021 · In the ACDOCA we have multidemsional GL, parallel ledgers, parallel currencies, 999,999 line items, and custom-defined fields. Then you have to consider field ACDOCA-VMSL which corresponds to field COEP-MEGBTR in the classical ERP world. Points to Jan 17, 2023 · ACDOCA-VTWEG = 30 . I searched for the place where i have to create implicit enhncement so that i could write code to update,modify,or insert ACDOCA and FAGL_SPLINFO with the entries from BSEG table. Sep 20, 2021 · Learning Objective: Define Additional Quantity Field in Account-based COPA Implement the logic to fill additional Quantity fields through BAdI (FCO_COEP_QUANTITY) Display Additional Quantity in COPA/Margin Analysis reports (KE24N). Jan 26, 2019 · This is always transferred to table ACDOCA, if entered in the sender document. Our S/4 GR Version is: 2020 (On Premise) FPS02. All customer enhancement fields of the journal entry table (ACDOCA) are available, in addition to the fields of the extract structure listed below. Mar 6, 2021 · I Have to do a Z Report. I do not want to look back to BSEG table to get that data. bseg-txbfw -> Original Tax Base Amount in Document Apr 15, 2020 · sapのerpに携わる人であれば、標準の会計伝票明細データが保存されるbsegテーブルはご存知ですよね。取引データが全てここに登録されてくるテーブルとして標準機能はもちろん、アドオン開発でも頻繁に使用するテーブルです。 May 14, 2019 · Hi. SAP R/3; SAP ERP; May 14, 2020 · Data volume problems during an SAP S/4HANA Conversion in Enterprise Resource Planning Blog Posts by SAP Wednesday; Dynamic Table Reading in SAP ABAP & Pricing Integration in Enterprise Resource Planning Q&A 2 weeks ago; Asset Accounting (FI-AA) – Insurance values in SAP S/4HANA in Enterprise Resource Planning Blog Posts by Members 3 weeks ago Feb 9, 2023 · It's recommended to select a subset of fields of 0FI_ACDOCA_20 to be transferred to BW. My understanding was ACDOCA will have all the fields available 2942067-ACDOCA key fields and primary index not existing on HANA database layer. It consolidates financial and managerial accounting data into a single source of truth, enhancing the efficiency and accuracy of financial reporting and analysis. Technical/Functional Utility. If the technical name is shown for the fields, the special fields are all starting with '1-U_'. Every S/4HANA implementation is unique and have business requirements to add custom fields in ACDOCA table. If we give ZI Apr 30, 2020 · I realized there is a field named "Offsetting Account" in table ACDOCA. I mean which filed in ACDOCA is replacing the below fields from BSEG. My understanding was that I can enter the legacy invoice value in this field (screenshot below) and standard SAP would copy the same value to ACDOCA-AWREF. If not, the field isn't read and the rows are aggregated. Below is the list of attribute values for the ZUONR field including its length, data type, description text, associated data element, search help etc You could also view this information on your SAP system if you enter the Jan 5, 2007 · Universal Parallel Accounting in SAP S/4HANA in Enterprise Resource Planning Blog Posts by SAP 2022 Oct 21; SAP Document Compliance solution for Greek myDATA e-books, Part 2 – central objects in customization in Enterprise Resource Planning Blog Posts by Members 2021 Sep 27 Oct 5, 2023 · By adding the “Origin” field via the settings, you can see, that your field origin is “ABAP Development”. This leads to system dumps since ACDOCA is in partially active status. SAP table ACDOCA (Universal Journal Entry Line Items) The ACDOCA table, also known as the Universal Journal Entry Line Items Table, is a central component in SAP's S/4HANA system. Use the ACDOCA template if the data in ACDOCA does not have the correct granularity for ACDOCU. Fields created directly in the app will display “Custom Fields” as origin. To add additional custom fields in ACDOCA table in SAP S/4HANA, SAP recommends to use these extensibility options, which Keep one ACDOCA field that has to be added as a custom field in Group Reporting. You can pass 'Material Document (4900000001) & Fiscal Year (2018) in ACDOCA directly and would be able to get the accounting document. Is this possible? And if not, is it possible to create a custom field in group reporting that is populated by an existing field from the acdoca during data release? Kind regards, Robert Jan FINS_ACDOCA_BW is a standard Information System Structure in SAP FI application. ACDOCA is one source of “finance single source of true” for actual data, but how univer The list of fields to be processed by data mapping depends on the columns selected in your mapping file. bseg-txbhw -> Original Tax Base Amount in Local Currency 2. As we all know that now ACDOCA would be the going forward for all the reporting so its include all the required information. We have a CoA G/L accounts with a lot of datas without Functionnal Aera and partner in ACDOCA table (on G/L account for G/Account - Partner companie - Functionnal Aera), and we need there informations in ACDOCU in each fields. SAP Knowledge Base Article - Preview After posting a document, it is observed that the internal order or cost center or profit center fields etc are populated in table ACDOCA but is blank in table BSEG. I've checked SAP Note 2156822 which has a pdf attached for field mapping but it doesn't have all fields mapping. gl. Visit SAP Support Portal's SAP Notes and KBA Search. Bastien SAP S/4HANA Finance all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions Keywords ACDOCT, ACDOCA, CI_COBL, Custom fields, HANA, Universal journal , KBA , FI-SL-SL-L , Table definition / Installation , Problem Jan 29, 2024 · The same applies when the field is present in the Cube but not in the query itself, as the query contains only some basic characteristics but not all of them. Jan 27, 2020 · Hi All, What fields can I use to identify delta records in ACDOCA to identify changed/deleted/new records? Is there a timestamp or date/time field I can rely on? I need to use BODS to pick up data from this table on a daily basis and need this detail. Jun 10, 2024 · For the techies: you can identify those accounting documents without BSEG update using the BKPF-BSTAT (or ACDOCA-BSTAT) field; they have the value ‘U’ in the BSTAT field. SAP Knowledge Base Article - Preview. SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S Aug 24, 2018 · If the same field exists on BKPF and ACDOCA or BSEG, the field can be expected to contain the same value in all tables. Associated to them we have the fields storing the actual currency used: RKCUR, RHCUR, RWCUR (note the K, H, W letter Mar 2, 2018 · To give you a bit of background: Basically, I am using a program logic to find open invoice (legacy) amounts by passing the legacy invoice number in this field ACDOCA-AWREF. However, for some analytical applications which are based on CDS queries, CO-PA (WW) fi Jun 6, 2019 · Hi. PO Against WBS. Need go custom development. However, these fields cannot be used to extend customer or supplier line items (account type D or K in the ACDOCA table). 0, platform edition ; SAP HANA, platform edition 2. You can recognize CO-PA characteristics, that were added to ACDOCA/P using KEA5 from the fact, that the technical field names in ACDOCA end on "_PA". It also includes transaction details like document number, amounts in different currencies Dec 19, 2023 · The migration program will then consider these fields in the line-item migration, i. 4 in the note 2341038. WHEN '0FI_ACDOCA_10'. - Able to create a custom field using "Custom Fields and Logic" App in both ACDOCA and ACDOCU [ assume "ABC" is custom field - Posted some data in ACDOCA May 4, 2012 · Hello Experts, I am using bapi 'BAPI_ACC_DOCUMENT_POST' to post document for FB60. Substitutions. However, while adding characteristics, the cost element cannot be found. Now , lets search for this PO commitment value in ACDOCA table by giving the WBS element number in the field PS_ POSID or the PO number in the field SRC_AWFREF. Aug 11, 2010 · variant -> Current. Jun 6, 2019 · But in that part of code there is no trace of ACDOCA or FAGL_SPLINFO to slipt or add multiple items with LINE ITEM,BELNR,AMOUNT etc as per BSEG entries. Feb 24, 2021 · This sample program is created by accessing the ACDOCA of the SAP standard table and using the Code Pushdown design method. Jan 11, 2018 · Business Background: Extensibility for CO-PA (WW) Fields The operating concern can be extended with custom characteristics created in KEA5. I have created a SAP quickviewer using T. The Special fields are shown in the bottom of the Hidden list. Click more to access the full version on SAP for Me (Login required). Aug 6, 2023 · The fields ACDOCA-ACCASTY_N1 to N3 are used to distinguish statistical account assignments from real account assignments. and they had to keep BSEG because the of the summarization requirement for the document coming from sub-ledger like MM, SD, PM, PP, etc. Jan 13, 2022 · Amount Fields length extension; In SAP S/4HANA, currency amount fields with a field length between 9-22 including 2 decimals have been extended to 23 digits including 2 decimals. I can view the data in ke* transactions too and was able to add them to the line item browsers too. Thank you Apr 25, 2018 · Hi all, I am running the Code Inspector on a slow performing piece of standard code. COEP records of value type 04 are read from ACDOCA by the compatibility view V_COEP, other value types are still read from physical table COEP. Your question is quite interesting since the data is all available in ACDOCA and that was the expectation of S/4HANA. Here are the steps: If you are using custom fields, please extend table ACDOCP for usage in SAC by using the app "Custom Fields and Logic" Feb 10, 2020 · All the fields mentioned by you are Z or custom fields and will not be availble in ACODCA unless created. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system. We bypassed the BTE's incompleteness by defining a substitution in GGB1. ACDOCA Table. Thanks, Shyam Custom fields created using this method can be used for many SAP Fiori apps that post journal entries. I noticed XREF1 to XREF3 are not available in ACDOCA. Aug 22, 2023 · Add Custom Fields in ACDOCA. When you display such a document, you will be immediately routed to the “General Ledger View”, there will be no “Entry View”, this is all. FAGLB03, free selection, dynamic, custom fields, FINSV_ACDOC_FCT, ACDOCA, FAGLFLEXT , KBA , FI-GL-GL-D , Reporting/Analysis/Display , Problem About this page This is a preview of a SAP Knowledge Base Article. Couldn't activate CI_COBL and ACDOCA also. Case i_datasource. Could you please explain about fields - "ACDOC_EEW_DUMMY" and "DUMMY_INCL_EEW_COBL" in table ACDOCA. Now, as I am working on my enhancement, I have used ACDOCA table for my Logic. for these fields as above, you can also use the Customizing activity Define Additional Settings for Matching Methods (or transaction ICAAS) to enable the synchronization. How can we configure Group Reporting in order to release these information from Universal Journal task in Data Monitor? Thank you for your Jan 17, 2017 · Our requirement was to append few custom fields in ACDOCA. Its comprehensive nature allows for broader, more strategic financial reporting and analysis. SAP delivered data sources for consolidation include: SC_JOURNAL_ENTRIES_01 - Consolidation Journal Entry View (ACDOCU & ACDOCA): For journal entry data from the Universal Journal Entry Line Items (table ACDOCA) and Consolidation Journal Entries (table ACDOCU) for entity pairs of consolidation units and partner units. Result: real account assignment = ACCASTY = OR, statistical account assignment = ACCASTY_N1 = PR and; the IDs of the Nov 10, 2020 · When debugging I noted the standard code fetches data from ACDOCA in join with BKPF and finsc_ledger_rep tables. This document provides a summary of field names and descriptions for different SAP modules including FAGLFLEXA, COEP, BSEG, BKPF and others. Oct 7, 2021 · I am aware that we can extend field using the fiori app "Custom Fields and Logic" or t-code OXK3. At BSEG table I can see the text and Assignment fields and they have contents (and this table have less line items than ACDOCA) and info is same than FB03 transaction (bseg-zuonr, bseg-sgtxt). From here on out, you can treat your characteristic like any other field created through the regular way and activate it for use in several Fiori . g trading partner) in a callup point. Mar 17, 2024 · The name of the amount fields follow this pattern: KSL, HSL, WSL etc. A library has been created using the ACDOCT table in GR21. BKPF, on the contrary, remains valid also in S/4. However, you still need to granulate your data available in ACDCOA to put together P&L based on a brand, product, product group, customer etc, which is not possible in traditional P&L through F. We have posting to different GL accounts in a single document. Instead of setting Key Field and Update from Original Doc. Shakeel Oct 28, 2022 · Hi experts, Hope you are fine. It's important, that. Now, due to special requirements we aim to also write Ship-to Party information into target ACDOCA-KUNWE field, with the objective of later on sending data records via outbound interface. Oct 30, 2023 · Dear Experts, we would like to release from Universal Journal the Market information. SAP HANA 1. Jan 22, 2009 · I wanted to understand what exactly is the significance of the field: Table - DFKKKO XBLNR XBLNR_KK CHAR 16 0 Reference document number The field value is used in the transaction FPE3 - Display document item "REFERENCE". Is there a BADI or User exit available in SAP so that we could write code based on some condition and provide err SAP on Instagram Share This site uses cookies and related technologies, as described in our Cookie Statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. SAP enhancement package for SAP ERP, version for SAP HANA FB02; change document; TRANSFER_CHG_TO_ACDOCA; SE37; transferred to ACDOCA; text field; BKPF. Seems master data fields not possible to assign in ACDOCA. Negative postings allowed indicator is activated for the relevant company code and document type. But you still need to create the field in Custom Fields in the Group Reporting For more information on the universal journal entry, see SAP Simple Finance, On-Premise-Edition. There many movement type (example 101 , 261 , 301 , custom movements . Only BSEG fields are available for selection and you cannot substitute ACDOCA fields. Sridhar The debit/credit indicator (field DRCRK) in ACDOCA table differs from the value in BSEG table (BSEG-SHKZG). Sales order ACDOCA-KDAUF field and Sales order item field ACDOCA-KDPOS are not filled when the sales order item is assigned to a WBS in the account assignment. Symptom. This time, I implemented the same logic in the ABAP CDS view. Add the group reporting fields to the line item display. Fields from the master data tables SKA1, SKB1, LFA1 or KNA1 are identified as such by a prefix on the field Technical Name, e. Sep 26, 2019 · ACDOCA contains all fields (360+) Table ACDOCA contains all fields (360+) required for G/L, CO, FI-AA, ML, and CO-PA; Table ACDOCA has fields from CO, ML, and FI-AA that aren’t in table BSEG. It lists over 50 field names, the module they apply to, and a brief description. g. For example the original document of the accrual postings is now contained in the Universal Journal Entry, table ACDOCA. Apr 23, 2025 · In SAP S/4HANA Finance, the Universal Journal (ACDOCA) forms the core of financial and controlling data. Custom Fields in ACDOCA table. Regards, Eli About this page This is a preview of a SAP Knowledge Base Article. You can view the group reporting fields in the Manage Journal Entries app with these steps: Switch from entry view to ledger view. Jan 21, 2022 · The S/4HANA Accrual Engine is seamlessly integrated with the General Ledger. Explore ABAP, FICO, SAP HANA, and more! Jul 28, 2018 · The pre-S/4HANA customer and vendor balance tables KNC1 and LFC1 have been converted to Compatibility Views on ACDOCA in S/4HANA, and in the same manner as FAGLFLEXT/GLT0, the Period 0 postings populate the Balance Carryforward fields on the KNC1 and LFC1 Views, and the Balance Carryforward rows on the Vendor and Customer Balance Display Mar 27, 2021 · We have a requirement to add Batch Number (MSEG-CHARG_D) and Movement type (MSEG-BWART) in ACDOCA table, such that they can be leveraged for detailed analysis of cost in Margin Analysis (i. Other But there is no such field in table ACDOCA. 1. Any input on how to leverage the feature of Coding Block for Universal Journal will be Jan 7, 2022 · In BSEG we have XREF1 to XREF3 (Ref Key 1 to Ref Key 3) fields. If a field is selected as an input column, then the field is read from the source. DATA: it_acdoca TYPE STANDARD TABLE OF ls_acdoca, SOURCE_DATA TYPE STANDARD TABLE OF FINS_ACDOCA_BW, wa_data TYPE FINS_ACDOCA_BW. Then I was looking to use Expert Mode in OXK3 to add customer fields but As postings occur in the general ledger, group reporting fields are recorded along with the rest of the accounting data. The most common used fields are listed under 2. I tried to follow steps included in SAP Note 2341038, however, I'm having some issues to create the aDSO to receive data. I was able to turn it on and do the config. IF C_T_DATA is not initial. This blog breaks down the key things every consultant needs to know — from Margin Analysis and document splitting to embedded analytics and custom field extensions. Jan 3, 2023 · We have issue with getting transaction currency update in group reporting. Plans are being made to create report writer reports using this library. But how that field will be used in various unified journal entry process, will be depending on the settings for such custom fields. 2. In addition to currency amount fields, selected data elements of DDIC type DEC, CHAR, and NUMC with varying lengths and decimal places that may hold amounts have been ACDOCA is a standard General Ledger Accounting Transparent Table in SAP FI application, which stores Universal Journal Entry Line Items data. e. ACDOCA records are rather selected by fields CO_BUZEI, ACCASTY and OBJNR. Please suggest. Sep 28, 2022 · The finance universal journal, so ACDOCA in S/4HANA covers data from all modules in FI & CO, so contains such dimensions like general ledger, profit center accounting, fixed asset accounting, material ledger etc. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. Also we can to take the whole trial balance of all GL accounts by this field. No Limitation of 999 Document Line Item: Due to the 999-document line item posting limitation, table BSEG is usually Apr 23, 2024 · ACDOCA in SAP S/4HANA have more than 500 fields and number of standard ABAP CDS views available in to use in custom code. balancecarryforward, trial balance, ACDOCA, carryforward, FAGLGVTR, coding block, ACDOCA, FINSV_ACDOC_FCT Compared to the classic JVA, JVA on ACDOCA keeps the same business logic. Read the SAP note. All the custom fields will need to be seperately activated and will not be in ACODCA. Can I Extend the ACDOCA Table with Custom Fields? Yes, ACDOCA. Since 0FI_ACDOCA_20 has much more fields than 0FI_GL_10, please deactivate some not needed fields by note 2534522. SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP S/4HANA 1610 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022 ; SAP S/4HANA 2023 ; SAP S/4HANA, on-premise edition 1511 ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP After posting a document, it is observed that the internal order or cost center or profit center fields etc are populated in table ACDOCA but is blank in table BSEG. Enhance the "Service Order Acatuls" Query with the custom field (Data Source: Service Order Actuals) With that appraoch you can get a custom field e. Dec 5, 2024 · The ACDOCA table was introduced with SAP S/4HANA to unify financial data into a single line item table. Refer to attached file on LnItm 000001 and 000002, both posted to GL 11114012 for Offsetting account 62950600. The examples are KSL,VSL,HSL,TSL,OSL,CO_OSL etc. Last time, I introduced a program that uses New open SQL. Impact of SAP S/4HANA Migration Jan 28, 2021 · This sample program is created by accessing the ACDOCA of the SAP standard table and using the Code Pushdown design method. ACDOCA "is settled" and "is settling" fields didn't get updated after AUC has been fully capitalized to Fixed Asset. There is no filter on ACDOCA-MIG_SOURCE as the compatibility view has to provide migrated and newly created line items. May 5, 2021 · In SAP S/4HANA, the universal journal heralds a new data model in finance where the ACDOCA table replaces COEP, COBK, ANEK, ANEP, ANEA and a few other tables. Search for additional results. Eliminate BELNR, BUZEI, DOCLN to reduce the data volume by compression. E. The number of database tables has been reduced. Regards. As a result of this simplification, the table covers fields in GL accounting, asset accounting, profitability analysis and the material ledger. The Universal Journal Entry Line Items table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. sort SOURCE_DATA BY rldnr rbukrs gjahr belnr docln. But is there any way to update/map the WSL field from ACDOCA to TSL field in ACDOCU for transaction cur Post Currency Adjustments, F1606, FBB1, BSEG, ACDOCA, S/4 HANA, XREF1, XREF2, XREF3, Reference Key , KBA , FI-FIO-GL-TRA , Transaction Apps , FI-GL-GL-A , Posting/Clearing , Problem About this page This is a preview of a SAP Knowledge Base Article. For more information, see Configure Destinations for ACDOCA or ACDOCU as Source Instances . You require information about adding customer fields to the Universal Journal Prior to sFin in New GL, Transactions OXK3 and FAGL_GINS were used to add customer You want to create a FI substitution in transaction OBBH to substitute fields (e. Merging the individual results of the application areas of accounting and controlling in an external data Sep 18, 2015 · Hi We have migrated a customer system to sFin on premise 1503 - SPS 1508 and are testing all scenarios to understand the new table structure and how table ACDOCA is populated. The sample program uses New open SQL. Oct 31, 2017 · Unfortunately, WBS element field is available in ACDOCA table but vale is not being populated. Question : how to manage the subtitution with the table ACDOCA inn order to manage the field VTWEG for finance part ? Thanks. ZFBDT Baseline Date for Due Date Calculation ZTERM Terms of Payment Key ZBD1T Cash discount days 1 ZBD2T Cash discount days 2 ZBD3T Net Payment Terms Period MA May 12, 2020 · In ACDOCA When customer wants to upload data to ACDOCA containing custom fields, then we will create the custom fields in ACDOCA as explained above. With that, value changes of the following fields are synchronized from the source documents to ICMR in real time: Aug 4, 2018 · I'm trying to use 0FI_ACDOCA_10 data source to extract data from ACDOCA table. However,BSEG has a limit of 13 digits with 2 decimal places for currencies (DMBTR,WRBTR,KZBTR,PSWBT) which implies that eve Mar 27, 2018 · ACDOCP is an ABAP table and its fields will have master data validation checks when saving data. If you're running multiple SAP S/4HANA instances or different S/4HANA systems, use Data Mapping to import ACDOCA data from a remote SAP S/4HANA system into your leading Dec 5, 2024 · While BSEG is a traditional line item table in SAP ERP, ACDOCA in S/4HANA serves as a unified repository, integrating data across various modules and eliminating redundancies present in BSEG. Regards, Sarath. The SAP PRESS Blog is designed to provide helpful, actionable information on a variety of SAP topics, from SAP ERP to SAP S/4HANA. I need to know which is the field (in customizing or in a specific table) where I can identify that a movement type is a transfer posting movement or a receipt movement or a consumption movement and so on. Do a Data Soruce Extension for the Data Source "Journal Entry Item - Cube" (add custom field) 3. Jan 13, 2020 · Hello, I have just turned ON Account Based CO-PA in S/4 1709. Results - ACDOCA. Dec 5, 2017 · In this query all the fields are selected from BSEG, or even if we consider a case where few fields are selected , still we need exact field mappings with corresponding fields in ACDOCA which i'm not able to find . (1) Any idea why this is happening. The challenges of gathering combined content of several tables to represents the truth and reconcile the different levels of detail stored in the different components/tables of SAP (e. 2297729 - No Entry View for some posting documents. Nov 10, 2011 · Dear. Example: a journal entry item is account assigned to an internal order and a statistical WBS element. ACDOCA is a standard SAP Table which is used to store Universal Journal Entry Line Items data and is available within S/4 HANA SAP systems depending on the version and release level. Mar 9, 2016 · Hi, We have observed that the length for currency fields (FI/CO/MM/SD or any other module) is 23 in universal Journal ACDOCA . "Market" is a custom COPA characteristic, automatically exposed in ACDOCA. It offers an overview of fields, currency configuration options, and account assignments to provide efficient data retrieval and analysis. Create Custom Field. ). However, I am stuck with the FB03/FB03L t Jun 18, 2018 · Appends of BSEG should be recreated in ACDOCA; they are irrelevant in BSEG after migration to S/4. Mar 26, 2021 · 1. The most important transactions are available as apps via SAP Fiori launchpad. Example, if you require a planning customer, this planning customer needs to exist in your customer master - KNA1. Should I also be joining the BSEG (Account Doc Seg) and ACDOCA (Universal Journal) tables? For reporting on accounts rec and other line item reporting. In S/4HANA and S/4HANA Finance table ACDOCA contains all relevant fields for document display, therefore BSEG/BSEG_ADD are no longer needed for GL view of document display. you add the Special field, if the field also exist as Standard field. These rules and variants can be configured to enforce specific data entry guidelines, validations, and restrictions, ensuring data accuracy and integrity. My question is about Currencies in ACDOCA in ACDOCA table the following fields corresponding CURRENCIES. Additional Features of ACDOCA. Was it through 'Custom Fields' (or 'Custom Fields & Logic' in earlier releases)? Or through the GUI? There is a t-code SCFD_EUI that can be used to enable custom fields created in the GUI in the Custom Fields app. I want to create a Custom-Defined Substitution Rule using ACDOCA standard fields as Precondition, but can't find them in Manage Subs Jun 27, 2018 · Coding block fields will treated as account assignment objects and possible to maintain in field status also, thus these fields will appear in ACDOCA if there is transaction is posed. However, as described in SAP Note 2435383, SAP made a change so that CO-PA and other fields on ACDOCA are not automatically made available on the Line Item Browsers because there is a field limit on the Mar 31, 2023 · Dear all, I want to substitute the value of field Supplier (I guess ACDOCA-LIFNR) . Feb 5, 2021 · ACDOCA is not made out of BSEG, BSEG is still a proper table and it stores entry view line items of the accounting document. Jan 9, 2023 · Here, you need to map the source custom dimension in SAP Analytics Cloud to the target custom field in SAP S/4HANA Cloud or SAP S/4HANA . code SQVI and used table acdoca, all other fields are showing data, however GL Longtext and Asset description is not showing any data or output. This integration eliminates redundancies and enhances data consistency across modules such as General Ledger (GL), Asset Accounting (AA), Controlling (CO), and Material Ledger (ML). For missing fields of appends after upgrade, consult this note: 2160045 - S/4HANA Finance: Fields of Appends to COEP and BSEG missing in table ACDOCA. Mar 11, 2022 · In table ACDOCA, I have included fields ANLHTXT (Asset Main Number Text) and TXT50(G/L Account Long Text). Aug 12, 2023 · Business Partner Sold-to Customer from SD-Invoice is being written into ACDOCA-KUNNR (Debitor), at time of Finance Document Entry. ZUONR is a standard field within SAP Table ACDOCA that stores Assignment number information. Field groups, in essence, are a collective of related fields available within the ACDOCA table. For logistic material document has been posted in alternate unit of measurement but FI document (ACDOCA) shows the quantity information in base unit of measurement. So the benefits that you have table unique, it is because you have all the fields in only one table and you do not have to do a query in more than one table because all the fields is allocated in the same table added with high speed HANA. , KBA , FI sap s/4hana 1610 ; sap s/4hana 1709 ; sap s/4hana 1809 ; sap s/4hana 1909 ; sap s/4hana 2020 ; sap s/4hana 2021 ; sap s/4hana 2022 ; sap s/4hana 2023 Keywords f2217, extensibility, extend, acdoca, bseg, 2453614, custom fields and logic, ACDOCA, BSEG, posting, view , KBA , FI-FIO-GL-IS , Reporting Apps , How To 4: Field Groups. Thanks To use the ACDOCA table as source, you must first create a dedicated destination in the SAP BTP Cockpit, to let the application know the location of the ACDOCA table you want to use. May 8, 2016 · I am from FI and there we have ACDOCA table that it is a join with many tables too. I need populate some data in this fields. I need fields within the BSEG table that are not in the ACDOCA. May 16, 2023 · In addition to the enhancement, you can also establish FI-Subsidiary Rules and define a Field Status Variant to further refine the behavior and validation of the trading partner field. I struggle to understand why field MATKL (material group) is not filled in any material document related postings. Apr 20, 2022 · Hello all, I have a requirement to make the fields HBKID and HKTID availeble in group reporting. Oct 27, 2020 · Hello pietstrydom. This, sequentially, can improve your system massively and ensure that you are taking care of how you work perfectly. From the hidden list you can now choose the fields. 3373938-Fields like XREF1~3 for ACDOCA are not available. While the accounting document is in approval status, it should not be allowed for a change by the user. The other question is, if the quantity shall also be recorded and displayed in the CO sums which are built from the ACDOCA line items in S/4 HANA (Finance). Does anyone has any clue why SAP added WBS Element field but have not populated the value in that field in ACDOCA table? Any other suggestion/approaches are appreciated. Almost all works fine, except two fields get passed by FB60, but are not set when using the BAPI: 1. jufkejdsdgxcmjtrpdpgqmqpuqncyochywdssebwfjaeqyjvxe