Actual data needed for. FAGLGVTR creates documents in Period 0 of the newly opened fiscal year, representing the cumulative balances as of the. b. Fortunately, SAP has provided an easy solution to include almost any field from the FI document tables ACDOCA,. I want to use the RFC options of the SAP table connector in Azure Data Factory. ACDOCU is a standard Consolidation Transparent Table in SAP EC application, which stores SAP Universal Consolidation Journal Entries data. Summarization of the Universal Journal (table ACDOCA ) is intended only for exceptionally large data volumes, which cause critical performance and data storage issues. With introduction of 1909 FPS01 Group Reporting, SAP came up with an approach for creation of custom fields. rbukrs, //Company Code key acdoca. If PAOBJ Relevant indicator (table ACDOCA- Field XPAOBJNR_CO_REL) has a value X, this means it is a real posting instead of a derived one. Actual statistical data of COEP (WRTTP = ‘11’) is stored in ACDOCA using additional columns for the statistical account assignments and in COEP for compatibility access. ACDOCU. rldnr, //Ledger in General Ledger Accounting key acdoca. Review terms and definitions. According to this general approach, the UJE contains all JVA-relevant data and is the source of all JVA processes and reporting. Document got posted with all the currency types defined in the operating concern currency type set up. Click more to access the full version on SAP for Me (Login required). ACDOCA & ACDOCP (the Planning table) forms the basis. You can determine the scope of the PoC. FAAT_DOC_IT FAAT_PLAN_VALUES. Once our partitions are created and data aging object is activated we can execute the actual Data Aging. Hi SAP, If any one have ACDOCA s/4 HANA. ACDOCA removes many aggregate and index tables, which greatly reduces your. The system indicates any unmapped items as a means of pre validation. It flow in on only ACDOCA table in SAP S4 HANA. Migration. During S/4 Hana conversion questions often arise related to how to validate the conversion data and the line items that were posted into ACDOCA. This means that all data within a. In pop-up provide the relevant semantic type. As of S/4HANA 1610, the Realignment functionality comes to Account Based CO-PA. MATDOC_EXTRACT. Migration means coming from an ERP system and going to an SAP S/4HANA system with JVA on ACDOCA. g. g. Consolidation ledger. Select archiving object CO_ML_AEXT and double-click on it or choose Goto Detail. This plan values will be stored in table. 2. ACDOCA Table. need to understand from base source how to take in ACDOCA field for update and journal & reports. In this document I will cover how a COPA Assessment works when using the Record Type as the Receiver Tracing Factor. Solution. the universality of the SAP universal journal. About this page This is a preview of a SAP Knowledge Base Article. +ACDOCA AS ( SELECT FROM ACDOCA FIELDS ACDOCA~RLDNR, "Ledger in General Ledger Accounting ACDOCA~RBUKRS, "Company Code ACDOCA~PERIV, "Fiscal Year Variant ACDOCA~GJAHR, "Fiscal Year ACDOCA~POPER, "Posting period ACDOCA~KTOPL, "Chart of Accounts ACDOCA~RACCT, "Account Number ACDOCA~RCNTR, "Cost Center ACDOCA~PRCTR, "Profit Center ACDOCA~RFAREA. 2884019 - Missing data after delta extraction for datasources 1_CO_PA*, 0FI_GL_*, 0CO_OM* due to delays of the update task. Similarly, you may notice the data of period 000 of table ACDOCP is not retrieved in HANA foundation view RTC _C_FOUNDATIONP. In case of replenishment needs, purchasing department formalize its requirement by creating purchase requisition or directly purchase orders (MM module). Once Gateway project is created, Right click on the Data Model and select ‘Import’ and DDIC Structure. D. The human first asks: What is the difference between ACDOCA and ACDOCU?. d. but in reality its the only stand alone product. New GL reports based on ACDOCA table can be used to view transactions posted in branch currency. RACCT is a standard field within SAP Table ACDOCA that stores Account Number information. Select archiving object CO_ML_AEXT and double-click on it or choose Goto Detail. 3. It encompasses all Margin Analysis characteristics and enables multi-dimensional reporting by market segment. 2. RKCUR Global Currency. Also, field OBJNR in table ACDOCA shows the object type of the postings, whereas the real postings in COPA have the object number starting “EOA”. Just like the fancy texts mentioned above, our Fancy Text Generator offers over 30+ fancy text styles for the name "Apaddoca". Above blog focus on SAP S4 HANA Fiori applications in Asset accounting on Prem 1909 or above. In S/4 HANA SAP has provided ACDOCT view for totals. BSEG . ACDOCA step by step document required. 17. # COPA – Plan Data. 0% 0% found this document useful, Mark this document as useful. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system. Number of ACDOCA entries for 2018-2019 is approximately 120 million. Material ledger document ACDOCA numbers have not been dependent from the DOCLN organizational unit (e. Exceptions to Header and Line Items Record. The differences occur in append structure APPEND_EEW_ACDOC_COPA or APPEND_COPACRIT_DB (other generated structures are mentioned in note 353257) Example: A remote client copy is performed. e. ACDOCA is the name of the Finance module’s important new S/4HANA table, which is based on the Universal Journal line items, containing all of the financial fields, as well as a lot of information from other modules. Some of you will already be familiar with Realignment in CO-PA (KEND), since this is an already existing functionality in SAP. What makes this solution universal, as its name denotes, is its versatility and unity. The title references the certification that is required by most states in order to work as a nursing assistant. 1 Answer. SAP enhancement package 6 for SAP ERP 6. Since, for a long time, SAP customers have only used the costing-based method. Document Summarization BSEG summarization is still in place and can be used as usual. Or 2. This will benefit for creating reports and any ABAP developments. The Profile Parameter abap/data_aging is set to ‘on’. Summarization of the Universal Journal (table ACDOCA ) is intended only for exceptionally large data volumes, which cause critical performance and data storage issues. 2. 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. Since in my example migration class CL_SDM_ACR_ACDOCA_ACRVALDAT does not have any records to process, I took another migration class CL_NGC_CORE_SDM_CLF_HDR as an example. Follow. Select change in the context menu of the. status/BSTAT <> ‘C’ to. Hi Gurus: Working in GR 1909 SP2. g. 2 Table of contents Executive summary 03 Introduction 04 Chapter 1: General SAP ECC system preparation for a finance migration to SAP S/4HANA 05 Chapter 2: Data preparation for a finance migration from SAP ECC to SAP S/4HANA 10 Chapter 3: Financial master data preparation and changes 17 Chapter 4: Preparing for the Universal Journal – ACDOCA. 26785 Views Last edit Sep 13, 2021 at 06:34 AM 2 rev. 0, version for SAP HANA. The Universal Journal (= database table ACDOCA) is the “single source of truth” for all accounting data. Go to the update tab and select Initialize the delta process. 2 Text CDS view. The universal journal includes columns for the standard characteristics and. We are on BPC standard 11. Examples: Retrieve additional ACDOCA data for statistical information (e. The fiscal year variant of the G/L ledgers are supported. But since both of these fields refer to the same Data element, the system disallows different values to be. 5. Creation of custom fields in ACDOCA and ACODCU. SAP S/4HANA. dataCategory: #FACT @Analytics. In this technical blog, I will explain the scenario briefly. I didn't think it was possible, because I had thought that an alias as just a renamed of my column, but with the right syntax the box works fine here is the code I rendered thanks for your help. Partitioning Key. header record (Table BKPF) and the respective line items record (Table. It will bring consolidated Actual data coming from ACDOCA and Plan data from ACDOCP together in one table (‘one version of the truth’). This view will be useful to find out totals per period and with some standard fields. ACDOCA is updated with profitability document number and reporting on PA can be achieved in central finance system. Group Reporting seamlessly integrates with S4 accounting. 5. S/4 Hana finance add-on architecture is based on new GL and comprises of new asset accounting module. Custom fields and logic App. Did you try checking the values before and after depreciation? Best part is that now universal journal also have the characteristics (like product group, segment etc) as columns in table ACDOCA which can be brought in to P/L at any time. ACDOCA is a standard General Ledger Accounting Transparent Table in SAP FI application, which stores Universal Journal Entry Line Items data. C. In short, the SAP Universal Journal serves as a “primary source of truth. You can extend the fields in the CDS view using eclipse. belnr = acdoca. Migration of Period Totals Records – Balance Carryforward. For this, SAP at year end writes initial Balance postings in the Universal Journal Table ACDOCA but with “Period 0 – zero (ACDOCA-POPER = 0)”. Margin Analysis is an available instrument in S/4HANA, but not needed to maintain consistency. Commitments can be activated for a follow. Impact on cPA. RFC SAP table connector (Azure Data Factory): TIMESTAMP column ACDOCA. RHCUR Company Code Currency. Actual data (ACDOCA) and plan data (ACDOCP) of integrated companies (i. This means that all data within a consolidated report originated from SAP S/4HANA Group Reporting are based on the table ACDOCU. And the corresponding fields are: 00 : ACDOCA-TSL (basic currency type) 10 : ACDOCA-HSL (Free defined Currency 1) 30 : ACDOCA-KSL (Free defined Currency 2) 50: ACDOCA-OSL (Free defined Currency 3) The code is as below: METHOD. System posts the revaluation results in freely definable currency Z3 (EUR) only. If the currency type of the controlling area is defined as second or third local currency in FI, this currency type is filled not only in the general ledger view of the FI postings (table ACDOCA, field KSL) but also in the entry view (table BSEG, fields DMBE2 etc. Oxford Capacity Analysis (aka American Personality Analysis; Church of Scientology) OCA. The Financial Planning & Analysis content for SAP S/4HANA shows you how to do this. Please find an example setup of the InfoProvider for the actuals data below. transaction data like sales orders or similar, the application needs to provide delta records. We tried using RFC option but unable to attach PaPM Model Table with any table available in S/4HANA even though remote connection is working for S/4HANA system RFC in BW. The Use of SAP Universal Journal Let’s see how the Values get stored for a PO created against a WBS in ACDOCA. Shift of customer was not easy as costing based COPA was offering a lot but Margin Analysis is improved to a level where it can make customer seeing their. One of the simplest ways to enjoy the value in S/4HANA should be Analytics on the Universal Journal because: Universal Journal is the heart of S/4HANA, Single one truth. The ACDOCA table, on the other hand, is a universal journal entry table that can consolidate financial data from various sources. Actual data needed for long-term orders/projects from COSP_BAK, COSS_BAK is stored in table ACDOCA. Hi SAP, If. COPA is a very useful tool in SAP for monitoring financial performance. As we discussed in a previous blog. Diese Tabelle umfasst Felder der Hauptbuchhaltung (FI-GL), der Anlagenbuchhaltung (FI-AA), der Ergebnis- und Marksegmentrechnung (CO-PA) und des Material-Ledgers (CO-PC-ACT). FINS_ML_ACDOCA_UTIL008 Pre-compacted inventory data inconsistent for material &1. I put break point in class method CL_FINS_ACDOC_POSTING_EVENTS=>UPDATE_CLEARING_INFO and then run F-32. ACDOCA-RHOART SAP table Field - Type of origin object (EC-PCA) values. bukrs and bseg. BAdI Implementation Logic. But control did not stopped there. In the above example, the data objects are split into 43 packages by Parallelization Framework (PFW) for the Migration Class. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Step1: Append the Structure of Datasource 0FI_ACDOCA_10. Select the CDS View entity name (“ZI_ACODCA_F”). The enhanced business place framework is delivered with a public API, which can be used to exchange business partner master data with other applications or web. Learn. In order to do that enter transaction DAGRUN. Even using an S/4 Hana system you can still view further. If your alerting is working correct you will receive an alert (ID 27). RSS Feed. There is no connecting point to manipulate. Save Save ACDOCA. r. We are loading Actuals from S4 HANA via the Extractor 0FI_ACDOCA_10. Profit Center Accounting. racct, //Account Number key. But which is the best or have added the Maximum. , KBA , CO-OM-OPA , Overhead Orders , Problem . Go and check out all the styles for more fun!. Search for additional results. Don't:RSS Feed. SAP Database Tables. Actual data of COEP (WRTTP = ‘04’) is now stored in ACDOCA. In the following case, so many entries are there, but it does not mean manual operations are needed for all. Fig. ACDOCA V/s BSEG currency settings. Here SELECT on BSEG table can be replaced by API call as below. ACDOCA-ACCASTY is called Account assignment type on the UI. ). 1 Answer. FAAT_YDDA. Vote up 4 Vote down. 18) 51: Debit: ACDOCA-HSL: From Opening Balances Logic (Raw No. Actual data needed for long-term orders/projects from COSP_BAK, COSS_BAK is stored in table. This blog provides some background information about the postings made during conversion and references additional notes for more detailed information. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. You could also view this information on your SAP system if you enter the table name ACDOCA or data type. Note: There are 2 correct answers to this question. Sri P. The Universal Journal (= database table ACDOCA) is the “single source of truth” for all accounting data. As mentioned before, SAP S/4HANA combines several data modules into a single table called ACDOCA (the Universal Journal). Actual statistical data of COEP (WRTTP = ‘11’) is stored in ACDOCA using additional columns for the statistical account assignments and in COEP for compatibility access. This is a big change from the single annual figure we had previously in. ) If you are using an RFC. It has a similar set of fields and common append structures. If needed, a workflow validation can be applied to purchase orders. SAP H/4 , We tested P2P cycle is reflecting in BSEG, BSIK, BSIS and also in ACDOCA table . Sri P. ii. ACDOCA-ACCASTY defines the CO Object type of the real account assignment. 80 is supported. 01 in ACDOCU table, the expectation is that the release GL. ACDOCA stores the full detail that is needed for all components that base on ACDOCA (G/L, AA, ML, CO, PA). 1. SELECT (lt_columns_secure) ##DB_FEATURE_MODE[TABLE_LEN_MAX1] FROM acdoca. Actual data of COEP (WRTTP = ‘04’) is now stored in ACDOCA. 0. Legal. ACDOCA Data Model . All the postings to these applications are written in single ACDOCA table (so it’s a replacement table for existing traditional tables like BKPF,BSEG etc). Material ledger is used for a multi-currency and or multi- valuation of inventory. The parade will be broadcast live on NBC and can also be. However, it does not contribute to the preparation of financial statements. In SAP ERP, these values will normally be viewed in the material valuation table MBEW , but in SAP S/4HANA , these values are shown in the Universal. Both tables are within the same SAP S/4HANA system. Source System of BW system. 1. Standard FI reversal, e. The CO totals will be corrected by the migration of balances (step DLT), so there should not be an impact on reporting and operations by the missing items. Actual data of COEP (WRTTP = ‘04’) is now stored in ACDOCA. You could also view this information on your SAP system if you enter the table name ACDOCA or data. Office of Cultural Affairs (New Mexico, USA) OCA. 07) and saving as 2021. (ACDOCT_BCK is a table). Embedded BPC inherently means using the Embedded BW system that exist in any Netweaver box. Implementing Fiori apps is to get more value out of SAP S/4HANA business innovations and analytics. So it’s easier to understand and use. Does SAP recommend doing this mass update directly in ACDOCA using a custom program? We have a custom program that updates ACDOCA for our custom Z. Do: This CDS view provides access to year-to-date (moving) balances. However, on clicking the Line (Posting) Item both the Document Number and Line (Posting) Item are passed to the target. MATDOC. Journal Entry Extension "Classic" Coding Block extensions using the OXK3 transaction and the CI_COBL structure. We have a COPA characteristic where the receiver of the goods of a delivery is stored. Here is my brief synopsis of each of the Browsers within S/4 HANA. SAP enhancement package 6 for SAP ERP 6. Thus, this change is a major shift in the process, design, configuration and management side. All Universal Journal entries are written to a new table - ACDOCA and no entries are made to the old tables. Extension Leger stores data in ACDOCA Table only. If you post a document to “0L”, The system will update ACDOCA with Leading Ledger posting to “0L” only. The Release from Universal Journal task helps to release the reported financial data from the universal journal for consolidation purposes. You can see that the company code and group currencies are shown in table ACDOCA for this material. Many additional tables are also extended, including BSEG, MSEG, EBKN, and EKKN, which may be. With the real time consolidation only the conversion of that data happens from group reporting perspective. I was under the impression that BSEG does not exist anymore. No valuation takes place (This principle. Sort by: Best Answer. Check out for more: Run a Mapping Job with an ACDOCA Table as Source. Actual statistical data of COEP (WRTTP = ‘11’) is stored in ACDOCA using additional columns for the statistical account assignments and in COEP for compatibility access. This blog post provides key technical details of SAP table ACDOCA, including its availability across SAP S/4HANA versions and the list of CDS views for ACDOCA table in SAP. The problem that we are running into is that we cannot call the function with parameters that are modified in the call. I would like to articulate some of the potential benefits of SAP S/4HANA in this article. What does an administrator need to do in the SAP Fiori Gateway server in order to launch a native SAP Fiori application from the SAP Fiori Launchpad? Note: There are 2 correct answers to. 2. It is a prerequisite to have New G/L active with G/L splitter and New G/L-JVA integration. This can be used in Report writer/painter also. Custom fields and logic App. In cases, in which big data volumes with a frequent changes are expected, e. Asset creation, Acquisition and Inter& Intra Co transfer. You have created a library using ACDOCT table in GR21. The segment is an account assignment object in the New General Ledger that enables you to create a Full P & L and balance sheet on the segment level. Computation is given below: "Cash at beginning (Hslvt in ACDOCT table) - Cash at the end of period. The others are postings resulting from the settlement of service order (settlement cost elements). gjahr, //Fiscal Year key acdoca. 0% 0% found this document not useful, Mark this document as not useful. S/4HANA Finance Technical Changes. We want runtime object to reflect this): 4. Relevancy Factor: 170. ACDOCA. At this stage of the process, no accounting document is created. If I could associate a word with each of the letters S and H, it would make it easier for me to remember which is which. You notice differences in tables (e. The checksum comparison is the fastest method for comparing two objects, but it does not offer any possibility to compare the data. Enterprise Controlling. Because of these empty values, these two tables produce a lot of data (In Billions). When looking at the Cloud proposed Financial Statement Version the Secondary cost elements being classified as Noted Items. 26785 Views Last edit Sep 13, 2021 at 06:34 AM 2 rev. m. Every S/4HANA implementation is unique and have business. I Have to do a Z Report. Most recently, she spearheaded. if data flow Index tables and ACDOCA table it will be heavy data on server. Reversal Posting . Hi Experts, I was referring to WRTTP(Value Type) , VERSN (Version) Fields are taken from COEP table in ECC. Results – ACDOCA. You can get a default ledger to read ACDOCA by. What is ACDOCA Table? ACDOCA stands for Accounting Document Actuals, it is called as a Universal Journal entry table. We can view GL line-item reports from t-codes FBL3N & FBL3H as these t-codes read data from BSEG but not from ACDOCA table. There has been a lot of buzz around the term ‘Universal Journal’ and the concept of the single source of truth with the S/4 HANA Finance ERP. Segment. It combines the flexibility of the costing-based approach with the feature of the account-based type by updating the G/L posting lines that are relevant for. In this example I have my COPA characteristic. ET and end by 12:00 p. 5 Browsing SAP Asset ACDOCA on Microsoft Purview Data Catalog . All you need to know about Universal Journal (ACDOCA) – SAP S/4 HANA (2020) Finance & Controlling : PART 1 13 63 26,045 If you are already working in S4. pass ACDOCA_WERKS into T001W-WERKS and fetch T001W-NAME1: From Opening Balances Logic (Raw No. The enhanced business place framework provides additional extensibility options so that organizations can extend the standard logic in their SAP S/4HANA systems. ) is only interpreted at ABAP side, there is absolutely no interaction with the database server, the expression is evaluated and the SQL statement is updated with the result before it is sent to the database. With the new ACDOCA table, secondary cost elements is now part of the Financial Statement. A Host Expression @(. Navigate to SAP Easy Access → Accounting → Controlling → Profitability Analysis → Planning → Integrated Planning → Transfer Plan Values to FI-GL (New). Crosswalk of one ICS account coding to SAP. You may choose to manage your own preferences. 2) if above is correct, that means that ACDOCU table will physically contain only entries for: top-side entries, retained. Dummy Plants!ACDOCA – The Universal Journal is THE SINGLE Source of TRUTH which forms the basis of many innovation in Finance Line-of-business in S/4HANA world. According to this general approach, the UJE contains all JVA-relevant data and is the source of all JVA processes and reporting. It is ideally S1, which is configured in Billing Type (VOFA). It does not need to store balanced and open items separately. This consists of a. This data source extracts data records for universal journal entries. As mentioned before, SAP S/4HANA combines several data modules into a single table called ACDOCA (the Universal Journal). Follow. 3 Answers. Steps 1- Run SCFD_EUI to enable fields for custom fields and logic. We are needing to add few fields to ACDOCA and ACDOCU after golive since we planning to automate elimination of intercompany elimination of profit in inventory in GR. 50 F Street NW, Ste. The Field Status is “Preparation Required”. Performance memory challenges were reoccurring with RTC due to the fact that the number of records could increase dramatically given the ability to map any field from table ACDOCA to table ACDOCC (the consolidation table). Actual statistical data of COEP (WRTTP = ‘11’) is stored in ACDOCA using additional columns for the statistical account assignments and in COEP for compatibility access. Invoice postings program. Actual data of COEP (WRTTP = ‘04’) is now stored in ACDOCA. Push “Prepare” to find the steps. 1. Follow. The valuated inventory accountings are stored in Universal journal (ACDOCA). Next series of blogs will cover SAP S/4 HANA Fiori applications in Finance in GL / AR / AP . However, since partner attributes of the original postings are missing in the totals records, reporting is limited to FI data when expanding such attributes (for example, partner cost center, sales order. Click on the package > Core data Services > Data Definitions > New data definition. Ledger Specific Posting. We can see that the view apparently recursively accesses the COEP table and other tables like the ACDOCA. Billing Document Type must not be RV. sqlViewName: ‘V_MLHD_UNION’. ACDOCT is a CDS view and not a table but it can be used in report painter for fetching totals with standard fields. the introduction of ACDOCA or Universal Journal) ensures consistency in S/4HANA - compared to ECC versions of our Business Suite. 1. ACDOCT is a CDS view not a table. Further currencies can be added by making the appropriate ledger settings. Best way to start S4 Hana implementation is define. Revaluation Posting. 5* and 7. And the corresponding fields are: 00 : ACDOCA-TSL (basic currency type) 10 : ACDOCA-HSL (Free defined Currency 1) 30 : ACDOCA-KSL (Free defined Currency 2) 50: ACDOCA-OSL (Free defined Currency 3) The code is as below: METHOD GET_CURTP_TAB_FOR_RLDNR. The appropriate movement type for a forward (stock gain) or reversal (loss) movement is determined based on the difference between what is already recorded in stock and what is posted as the quantity counted in the physical inventory. There is no redundant storage of the postings as original document. As it turns out, Universal Journal table ACDOCA does contain G/L carryforward balances for balance sheet accounts, but they are represented in the table as Period 0 documents. Define threshold with reports / transaction named in the notes / SPRO. ” It was brought on by SAP’s exclusive HANA technology. 2. Oct 17, 2013 at 05:31 AM. This Indicates that balances are updated only in local currency when users post items to this account. Go to the Eclipse ABAP Perspective and find extract structure for the datasource 0FI_ACDOCA_10. Specifically, data that was spread and stored across multiple tables including sub-ledgers and totals tables has now converged. As it turns out, Universal Journal table ACDOCA does contain G/L carryforward balances for balance sheet accounts, but they are represented in the table as Period 0 documents. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. Actual statistical data of COEP (WRTTP = ‘11’) is filed into ACDOCA uses optional columns for the statistical user assignments and in COEP since compatibility access. 2. Actual data needed for long-term orders/projects from COSP_BAK, COSS_BAK is stored in table. Hi SAP, If any one have ACDOCA. But the manipulation is done only for BSEG table in enhancement. Business. ACDOCA table has 23 digits for currency fields. Vote up 4 Vote down. Type Manage Bank in search box and below APPs will appear. All new features like Business Partner, Fiori, LTMC, ACDOCA, Account based Costing, etc. It refers to a set of strategies and tactics that focus on driving more traffic from Search Engines to your pages along with improvements that help your website rank higher in Search Engine Result Pages. In order to fix this error, I had got 2 options. All documents are entered against company code currency (currency type 10) and group currency (currency type 30). How do you want to study today? Flashcards. Universal Journal – ACDOCA Table The ACDOCA Table helps to keep Reports and tables in one database itself. With introduction of 1909 FPS01 Group Reporting, SAP came up with an approach for creation of custom fields. The difference is posted as either a stock gain or a loss in PMMO. A sub-ledger is an intermediary financial record that links with the general ledger. Add a Comment. This Extractor loads the balances into B4/BPC on a periodic basis as opposed to 0FI_ACDOCA_20 extractor which helps you get the YTD balances. 2. It was a way for people to have account based and cost based data in one table for reporting. 1. The archiving object CO_ML_AEXT creates archive files for ML extract records ( ACDOCA_M_EXTRACT ). You are on page 1 of 1. Please suggest how could i insert line items in ACDOCA. If you will not stand for something, you will not accept a situation or a particular type of…. ACDOCA-MIG_SOURCE table field - Source of a migrated journal entry item . The query related to selected workbook can be found under the "Query Technical. 5. Diese Data Source extrahiert Datensätze zu umfassender Buchungsbelegen. It contains all documents posted with the components FI, CO, MM, SD. Figure 2 shows an extract of the ACDOCA table showing some of the asset and material ledger fields available. We got the existing Interface view “I_GLAccountLineItemRawData” consuming data from ACDOCA which satisfied our requirement. Please find an example setup of the InfoProvider for the actuals data below. We will use S4Hana and BW4Hana.