Sap acdoca report. Sep 22, 2024 · In SAP S/4HANA, the ACDOCA table, known as the Universal Journal, serves as a centralized repository for financial and controlling data. Use the Release Universal Journals task in the data monitor to copy the data to table ACDOCU of Group Reporting. ) & ACDOCA-AWITEM (Ref. Is there any report that can update the filed LOKKT in ACDOCA retroactively? Your help with this matt ACDOCT, ACDOCP, ACDOCA, report painter, F1711, Import Financial Plan Data, V_ACDOCT_DDL, empty, no data , KBA , FI-SL-IS-A , Report Writer / Report Painter , Problem Feb 5, 2021 · SAP Note 2297729 has additional info on the BSEG / ACDOCA usage. How to extend Display Line items in General Ledger or any other 'ACDOCA'-based application with a field, where the main datasource is 'BSEG' database table. Nov 28, 2023 · Click here to learn how the ACDOCA table in SAP can help consolidate financial data from multiple sources and provide a single source of truth for data. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system Even using an S/4 Hana system you can still view further information about the SAP Jan 6, 2016 · As the library has the table ACDOCT already listed, I tested the functionality by creating a report group and report. Select Reports > List view Find the report Accounts Receivable - Open Items and click it. ) field in the FB03 screen? I know where is BKPF-XBLNR is and where is XREF1. 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. One such planning method is SAP Business Planning and Consolidation (BPC) for SAP S/4HANA. This budget relevance setting can be used in several different areas, but it is interpreted differently in each case As postings occur in the general ledger for integrated companies, they're captured in the ACDOCA (Accounting Document for Actual) table. Found some threads but they're inconclusive. It's about what, why, and how to go to Feb 21, 2020 · Hi, We are migrating our ECC system to S/4 HANA. Why when posting to a PA segment both ACDOCA-MSL and ACDOCA-VMSL are populated while posting without a PA segment only ACDOCA-MSL is populated ? What additional quantities are available ? How are parallel ledgers processed during transactions KE28 and KEU5 ? Is it possible to get Price Difference Split in group valuation ? Mar 2, 2018 · Hi, Where can I see the ACDOCA-AWREF (Reference doc. ACDOCA Use-Cases ACDOCA (Universal Journal Entry Table) consolidates financial and management accounting data into a single table. Sep 5, 2022 · The extractor 0FI_ACDOCA_10 is built on table ACDOCA (Universal Journal Entry Line Items) so we had to look for existing CDS views that can be used to consume the data. When we try to build a report, we face issues with entries in ACDOCA (New universal ledger table in S4HANA). How can we create the new report fo Symptom Following the procedure of help document Custom Field Extensibility for Group Journal | SAP Help Portal , a new coding block and a journal entry item for a custom text field were created. Click more to access the full version on SAP for Me (Login required). However I now . 1. You can also view group reporting data in the accounting journal entry. It means the sales order is not make-to-order scenario. Why when posting to a PA segment both ACDOCA-MSL and ACDOCA-VMSL are populated while posting without a PA segment only ACDOCA-MSL is populated ? What additional quantities are available ? How are parallel ledgers processed during transactions KE28 and KEU5 ? Is it possible to get Price Difference Split in group valuation ? May 31, 2016 · In the latest version of S/4 HANA 1511, most processes was relocated into the Universal Journal table "ACDOCA ", not the table "BSEG" anymore. The report works fine but when recon my customized report with standard FBL3N report, one particular line item it is showing as reversed but in ACDOC table At ABC Corporation, there’s a request from business users to create a custom field for Brand and integrate it into accounting and group reporting. How to create such a report 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. This document explains the various options that are available for creation of custom fields, how to enable them in various business transactions, what are the o Nov 9, 2023 · For PS, I want to create a report within the report painter like: 12KST1C (CJE5) but based on ACDOCA / ACDOCP displayed within an hierarchy: Project | WBS | Network Activity A slight adjustment: ACDOCA doesn't hold the original postings, but the settled postings. Where do I get units sold? I considered going using DFKKOP instead of ACDOCA to start but not su 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. We currently need to develop a report to show a column of past due balances of 30,60,90 and over 100 days. Document header text is a field in accounting document entry view tables (BKPF-BKTXT). Thanks, Vijay Jan 6, 2016 · As the library has the table ACDOCT already listed, I tested the functionality by creating a report group and report. About this page This is a preview of a SAP Knowledge Base Article. Therefore the appendix ledgers are not allowed in Report painter because the data is stored in ACDOCA table. 3keh will be substituted on fagl3keh) . Apr 23, 2024 · As a finance professional or SAP user, understanding the ACDOCA table is essential to effectively manage financial transactions and reporting in the system. if so let us know the setups we have to do and the process. But, our FI team had maintained the new field in ACDOCA table using the COPA function module A discrepancy is observed in the Recovery indicator (field RECID) between the ACDOCA table and BSEG table in the FI documents. You must create your mapping file in Microsoft Excel, as described in the chapter Structure of the Mapping File. It servers as a single source of truth and common line item table. Symptom A library has been created using the ACDOCT table in GR21. Jan 28, 2021 · Use the new open SQL to get company, account, and - SAP Community Application Development and Automation Blog Posts Feb 28, 2018 · Now, considering this we're supposed to be using ACDOCA in our report libraries which are conventionally pointing to FAGLFLEXT. How several modules have been integrated into single table and reconciled on real time? If you want to read the technical aspects, here is the link to the blog. , in table ACDOCA. Create Bex queries on the top this BW standard infocube /ERP/SFIN_V The business requirement is to restrict the user authorizations based on a selected range of cost centers for "Cost Center Budget Report" F3871 and "Cost Centers Actuals" F0940 Fiori Apps. Is there a standard CDS view or API that can be used to load cumulative balances into the Import Model? I've tried to create a custom CDS view using Mar 11, 2022 · How did you add those fields (Z-append to ACDOCA, in CI_COBL, in INCL_EEW_ACDOC, or?) How did you fill those fields, you didn't expect SAP would fill those (retrospectively and on new postings) What was your actual requirement. This video explains you all you need to know about the ACDOCA Table in SAP S/4HANA Finance. Plan data are stored in the summary table GLPCT. 2. Item). For more information, see Configure Destinations for ACDOCA or ACDOCU as Source Instances. The table below shows an extract of the ACDOCA This means that all data within a consolidated report originated from SAP S/4HANA Group Reporting are based on the table ACDOCU. At the heart of this advanced enterprise resource planning (ERP) solution lies ACDOCA, the Universal Journal. It can be used to control whether and how a budget is consumed for various transactions and types of postings. 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. Before the data is released into group reporting, the general ledger trial balance report can be used to view the group reporting related data in ACDOCA. We deactivated old planning functions according recommended notes. Aug 19, 2023 · Universal Journal in SAP S/4HANA is single line item table (ACDOCA) with full detail for all applications, including Ledger, Market Segment & Coding Block. Oct 7, 2021 · Hello All, We have a below scenario where we are trying to bring a custom field from ACDOCA table to ACDOCU. Oct 31, 2023 · For PS, I want to create a report within the report painter like: 12KST1C (CJE5) but based on ACDOCA / ACDOCP displayed within an hierarchy: Project | WBS | Network Activity A slight adjustment: ACDOCA doesn't hold the original postings, but the settled postings. The blog explains for which business proc The CDS database view ACDOCT shown in transaction SE12 or SE16N is deprecated and cannot be used for future operations. Appreciate your help. Mar 28, 2018 · Hi experts, the customer wants use in SAP S/4Hana 1709 old profit center planning functions. For a simple report enhancement, don't mess with the table, join tables such as ANLH or SKAT to your quick view (as suggested by tammy. 1 Business Scenario This scenario explains how to create a custom report on the SAP S/4HANA Cloud account retrievable line items, which refers to the projects within its work packages. Doc. In this blog post you will get a holistic view of Universal Journal in SAP S/4HANA Finance. cost center providing: columns: plan, actual, diff (plan vs. Mar 4, 2021 · Solved: Hi All, Is it possible to do GR/IR reporting using the ACDOCA table for open items? Do I have to combine any other tables. But Ledger is also part of key of the table, so we can have more than one entry. The new fields are visible under ACDOCA and ACDOCU. e. The standard SAP S/4HANA account retrievable line items can only relate to the customers by default. It's about what, why, and how to go to Jan 8, 2021 · Nowadays there is a tremendous interest in S/4 HANA, especially from current SAP customers. My question is about Currencies in ACDOCA in ACDOCA table the following fields corresponding CURRENCIES. ACDOCA storing entries i 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. Custom fields can be created by using the Custom Fields app. actual) row 1: account "revenue" 8xxxxxxxxx row 2: account "personal costs" 41xxxxxxxx row 3: calculation: (row 1 - row 2) row 4: account "service costs 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. You will find that already cleared invoice is appearing in this report. But ACDOCA-AWREF is different from these two. Find comprehensive SAP help and resources for SAP S/4HANA, including guides, tutorials, and documentation to optimize your enterprise resource planning processes. The specific UI and report for group journal and consolidation were activated. Archiving explorer shows archived documents, however, nothing got cleared from ACDOCA. As a reminder, the FAGLL03H transaction is the main report based on the new universal journal ACDOCA on SAP S/4 Hana. On the other hand, I feel that there are a minority of developers who can imagine the concrete source code of CodePushdown. Sep 1, 2017 · Limitations: In Simple finance SAP introduces the Appendix ledger (extension ledger) this is mainly for posting adjustment entries in ACDOCA table. 2 Overview 2. This time, we w Jul 9, 2020 · Accounts Receivable: Detail Aged Trial Balance SAP4HANA Hi, I am new to the SAP community. 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". balances for SAP S/4HANA companies) is captured within the table called ACDOCA (figure 1). However, we do not know from which table we are going to obtain. A custom field created in the General Ledger (GL) ACDOCA is not fetching any transaction data when extended to Group Reporting in ACDOCU. Within SAP S/4HANA actual data (e. We are uploading WBS Plan via the Standard Fiori App "Import Financial Plan Data" which includes a Templ May 11, 2018 · Dear All, We are in the process of developing a report for which we need to get the cleared and open items as on key date in S/4 HANA (1709) Earlier we use to refer BSIS,BSAS table for the same. A real data record reduction from ACDOCA will take place by executing compression run. The Object Type (ACDOCA-ACCASTY) should be "PSG (EO)" for the relevant journal entry. Item) linked to EKBZ-BELNR (Document Number) & EKBZ-BUZEI (Mat. The article explains the significance of the Universal Journal (ACDOCA) in SAP S/4HANA Finance, detailing its integration of financial data, its role in eliminating reconciliation between Financial Accounting and Controlling, and its impact on profitability analysis and segment reporting, while providing practical guidance on configuration and diagnostic practices. I applied the correction mentionned in the Note 2472406. Jul 17, 2025 · 本文深入解析SAP S/4HANA的核心财务表ACDOCA（通用分录表），探讨其作为“单一事实来源”的优势、关键组成部分、扩展性、报告应用、迁移注意事项及管理最佳实践。 If the consolidation unit is a S/4HANA company, their reported financial data resides in the same SAP S/4HANA system as Group Reporting, i. powlas3) The ACDOCA table was first introduced with the Finance tool of SAP S/4HANA. Mar 6, 2021 · I Have to do a Z Report. The Document Header Text Field is not present in the ACDOCA ledger view table (Universal Journal Entry Line Items). Cheers. My doubts relates to this fundamental contradiction that on one hand we're supposed to use ACDOCA across in S/4 HANA whereas on the other hand, SAP itself has restricted this use and not added ACDOCA to report library. I mainly understand it as a change to accommodate reporting. After migration classic GL -> S4 PC will updates in acdoca and bseg (let's say New GL concept will be applied), and new posting logic for PC will be applied (e. Apr 26, 2019 · Hello S4HC-experts, I´m wondering does S4HC provide a tool which is (fully) equivalent to the old Report Painter or not? I want to set up a report (App AnalyticQuery) for e. As a result of this simplification, the table covers fields in GL accounting, asset accounting, profitability analysis and the material ledger. A report was build using ACDOCA to monitor the carryforward balances of the reserves account. Mar 3, 2023 · Hi we are using S/4 hana and importing data to SAC from ACDOCA and writeback back plandata to ACCDOCP. Actual data are stored in the Universal Journal ACDOCA. The business context is FINCS_JOURNAL_ENTRY_ITEM. Below is the full ACDOCA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field This scenario explains how to create a custom report on the SAP S/4HANA Cloud account retrievable line items, which refers to the projects within its work packages. My initial idea was to use ACDOCA-AWREF (Reference doc. Together, they deliver a single, reconciled version of the truth instantly. However, while adding characteristics, the cost element cannot be found. g. This feature is related to the In order to analyze planned costs in the Project Cost Report app, the planned project costs need to be stored in the ACDOCP table. Nov 10, 2020 · Hi, I need to link table EKBZ to ADOCA in order to include field KSCHL (condition type) related to delivery cost in my report. In this blog post, we will delve into the details of the ACDOCA table, its significance, structure, and how it functions within SAP S/4HANA. ACODCA is the new and major data model change in SAP S/4HANA compared to SAP ECC. Data from all modules in FI & CO is now collected in ACDOCA, and so it is called Universal Journal. BKPF (Accounting Document Header): While not fully replaced, some data that Aug 6, 2023 · Co-authored by Birgit Oettinger and Stefan Walz Welcome to this blog, in which we will provide insights into the new options of multiple CO account assignments and market segment attribution – innovations made possible with the Universal Journal in S/4HANA. In S4HANA on Prime we can look at the tables using SE16N but in this version, I do not know, where we You are performing archiving for aging object FI_DOCUMENT. Jan 13, 2022 · SAP removed all total & index tables, hence removed duplicate data from the DB. Mar 17, 2024 · This article is part of a series on data modeling with SAP data: Data modeling with SAP data: An introduction We are lucky, from a data modeling point of view, to be living in the era of ACDOCA Mar 7, 2018 · Just wanted to know like how we can develop report painter reports using KE30 in Costing based copa, do we such provisions for account based COPA as well? Or we have only develop report using abap code from ACDOCA table. The custom field is visible in the ACDOCU table but does not display any transaction data. We understand the S/4 HANA does support the report painter/writer reports though they have some limitations e. When I execute the report I do not see any values on the rows even if the accounts are populated in ACDOCA (for example coming from FB01 posting or Billing Document). (So ACDOCA-OBJNR should be joined with AFVC~OBJNR to retrieve the original WBS element (AFVC~PROJN). Sep 26, 2019 · Learn What is SAP Universal Journal. Explore the Universal Journal in SAP S/4HANA Finance, including its structure, advantages over SAP ERP, and potential reports. Custom fields are added to the ACDOCA and ACDOCU at the same time. How do we fetch the correct entry in such case ? Any pointers would be helpful. 0 to SAP S / 4, the standard table structure has changed significantly. ACDOCA unifies Financial Accounting (FI), Controlling (CO), Asset Accounting (AA) , Material Ledger (ML), Profitability Analysis (COPA). The compression run replaces all entries of ACDOCA fulfilling above criteria with aggregated entries. RTCUR Balance Transaction Currency RWCUR Transaction Currency RHCUR Company Code Currency RKCUR Global Currency ROCUR Freely Defined Currency 1 RVCUR Freely Defined Curre Jan 8, 2021 · Nowadays there is a tremendous interest in S/4 HANA, especially from current SAP customers. However, the Plan Data reads from the old PS Planning Tables. The Composite view of type Cube and Consumption view (with composite view as source) was built to After S/4 HANA migration in ACDOCA there are several technical documents, the document number starting with DG** or DC*** or DU**. These products include the new Embedded BW Reporting and various Fiori apps that can dynamica Oct 11, 2023 · Hello, I found that there are some inconsistencies between BSEG and ACDOCA for the field ACDOCA-LOKKT. Create a CDS view for each AO report I need. Aug 3, 2020 · However, ACDOCA table entries are not archived immediately and instead an entry with inverted sign is inserted into ACDOCA to set the resulting balance to zero. It consolidates information from various modules, streamlining data management and enabling real-time reporting. May 16, 2019 · In a scenario for S4HANA 1709 with FI-CA also enabled, I can get revenue using the GL account hierarchy and ACDOCA but I need to combine it with units sold information to calculate Revenue per unit sold. Jul 31, 2024 · Click on Action Log à Program FCO_ADD_COPA_FIELD_TO_ACDOCA needs to be run in background to generate the structures in ACDOCA **please note that the system in use is S4HANA Once the Program is executed you should see it is successful. This table is extremely important in SAP. How to create such a report Universal Journal Table ACDOCA The actual financial accounting and controlling data is recorded in one single table: the universal journal (technical name: ACDOCA), this table acts as the single source of truth for all actual financial transaction data. It is also called the Universal Journal. Aug 7, 2018 · Background Since the introduction of S/4 HANA, there has been a lot of information written on the new analytics products available for S/4 HANA Finance that leverage the new Universal Journal table ACDOCA. During the work based on S/4 these days, this change may have cause the following problem: For some official ALV report programs, like "FBL3N" and "IDCNCASH FAGLL03 displays all the different currencies in the field amount in document currency for each line item and display a summary total per each currency however in report S_PL0_860000028 if you set to display "currency type = 00 - document currency" in select 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. Search S4 HANA tables 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. Jun 8, 2023 · Hello, how do we link ACDOCA custom fields with Group Reporting's custom fields? We are aware that we can create custom fields in Group Reporting through "Custom Fields and Logic" App, but we would need to understand how to set an already-existing ACDOCA field as the value source for them, for insta In Simple finance SAP introduces the Appendix ledger (extension ledger) this is mainly for posting adjustment entries in ACDOCA table. May 14, 2018 · Hi, I have done customized report in which the logic is given as, if the document is revered the line item should not be brought into my report. And where we can easely show on a current year or a previous year. Plans are being made to create report writer reports using this library. The Budget-Relevant indicator is an important setting in the general ledger/budget account and is updated as part of a journal entry in the Universal Journal (ACDOCA). Enter mandatory details like Company, Set of Books, Key Date and Customer details. they can not benefit from the new extensiblity concept etc. From Complexity to Clarity In previous SAP environments, inventory and finance relied on different sets of tables. Apparently BSEG is used for the “entry view” of documents, as well as open item management. But it didn't solve it retroactively. So you can use it to store management and financial accounting information without any problem. Oct 31, 2023 · We'd like to still use the report painter where we can add / substract columns with eachother. Although it is present in the ACDOCT table (SE16), it is not appearing in the characteristics. For Leading Ledger 0L the data seems to work well and the summarized values are very much in sync with ACDOCA (Universal Journal Line items) table. For reconcelation purpose is there any way where we can dircetly do report on ACDOCA and ACDOCP from SAC. Jan 21, 2022 · In this blog, we are going to discuss about the functional impact of ACDOCA in Finance business processes. Nov 6, 2020 · Hi, we are having a custom report, where we need to fetch data from ACDOCA table based on Comp code, Year and Document number. or is it sti May 22, 2020 · Let's consider the SAP GUI report FAGLL03H - G/L Account Line item browser. This has many advantages compared to the traditional silo approach of separated subsystems. Congratulations your field is now activated and added to the structure. However, BWTAR and BWKEY have initial values in ACDOCA when MIG_SOURCE=G. I am aware that we can extend field using the fiori app "Custom Fields and Logic" or t-code OXK3. Regards, Adi Apr 24, 2025 · Hi Team, Our new Chinese company code has a legal requirement to store all the financial data posted in SAP, maintained in Kingdee system (Chinese government system). Profit Center Accounting with SAP S/4HANA How does profit center accounting work in SAP S/4HANA—and how do you use it? With this E-Bite, get step-by-step instructions for running profit center accounting alongside a detailed look at how each step fits into the greater financial picture. Now in S/4 hana, how to fetch the open items and cleared items for a key date in ACDOCA. Does the system migration takes care of migrating these reports to S4 HANA or May 12, 2020 · Purpose: Purpose of this document is to explain the process of custom Field creation in group reporting and universal journal entry table. Alternatively, you also have the option to set up the system in such a way to write the costing planning data back to this Aug 15, 2024 · After we have created a report for Account Based COPA in KE30, linking all report rows to different Accounts or Group Accounts. At the center of this breakthrough are two game-changers: MATDOC and the Universal Journal (ACDOCA). Has anyone carried out this develo It is required to add a field from table ACDOCA as special fields in FAGLL03/FBL*N transactions. Apr 23, 2025 · In SAP S/4HANA Finance, the Universal Journal (ACDOCA) forms the core of financial and controlling data. With SAP S/4HANA, that barrier is gone. Mar 15, 2024 · I can not see any data in the reports, for that I want to look at the table ACDOCU and look the data was upload, but I do not know, how to look at the table like ACDOCU and ACDOCA for compare data. You can check this via Display Sales Order - Procurement tab - Requirement Type. Apr 7, 2022 · Hi I need to write a Balance Sheet report with cumulative balances (each month) using data from ACDOCA. Find insight into all your critical processes: planning, actual postings, transfer pricing, reporting, and 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. Search for additional results Visit SAP Support Portal's SAP Notes and KBA Search. Part three in a series. We got the existing Interface view “I_GLAccountLineItemRawData” consuming data from ACDOCA which satisfied our requirement. During migration PC in acdoca should be updated based on bseg/coep tables Aug 22, 2023 · Understanding S/4HANA ACDOCA Extensibility In the realm of modern enterprise management, SAP S/4HANA has emerged as a transformative force, propelling organizations toward more efficient, agile, and data-driven operations. It replaces or supplements several tables used in SAP ECC: FI (Financial Accounting) Tables: BSEG (Accounting Document Segment): Line item details of FI postings are now stored in ACDOCA. Full Guide on ACDOCA Table Architecture, Functionality & Benefits of Universal Journal in SAP S4 HANA. Sep 18, 2025 · ACDOCA is more than just a technical innovation—it’s a paradigm shift in how SAP handles financial data. Feb 24, 2021 · Introduction From SAP ERP 6. Aug 11, 2016 · You can use it as before (if it was activated). Jul 6, 2017 · hi gurus, I m working in S4H 1610 FPS02 and I need to create some Analysis for Office (AO) reports using data from ACDOCA table so I was making my research and I have these options: 1. Feb 6, 2020 · We're implementing S/4 with old-style PS functionality (No EPPM at this stage) Standard Project Reports now show Actuals from ACDOCA. mzzw rvso vp rktr lj fgwv kdnrckv okl mjoecb tq