ACDOCA provides real-time financial reporting and analysis capabilities, while ACDOCU requires additional steps to reconcile data from multiple tables to generate reports. Do: This CDS view provides access to year-to-date (moving) balances. This blog is about how to add a field in standard Fiori apps and other objects by using “Custom Fields” menu in Key User Extensibility Tools “Custom Fields and Logic”. With the introduction of ACDOCA, SAP has chosen this opportunity to enforce that the legacy asset values are maintained via a common posting process. The archiving object CO_ML_AEXT creates archive files for ML extract records ( ACDOCA_M_EXTRACT ). In SAP S/4 HANA’s new asset accounting, the different accounting principles, methods of depreciation, legal requirements, etc. SAP Database Tables. but in reality its the only stand alone product. b. 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. It is ideally S1, which is configured in Billing Type (VOFA). Integration. In case the repartitioning is needed in the Q1, could we control the duration or timing of the repartitioning operation? Q3. Assets go on one side, liabilities plus equity go on the other. During our testing. 1 day Analytics 1-3 days PoC At a fixed price, you will receive a solution for identifying the improvement potential. Question on view table ACDOCT - SAP Q&A. DataSource 0FI_ACDOCA_10 did not extract some documents from ACDOCA table during the initialization. What Does CUV Stand For? While capable off-road, those original SUVs were more ungainly than a typical passenger car to drive on the street, and automakers. 10 hours ago · What does Wilders stand for? Anti-Islam and anti-EU rhetoric are historically the main elements in Wilders’s agenda. Invoice postings program. 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. The transformation of ACDOCA data into ACDOCU can be useful for example if you need to harmonize your local accounting directly into your consolidation. Fig 5. The Composite view of type Cube and. What makes this solution universal, as its name denotes, is its versatility and unity. Use the Adobe Lifecycle Designer tool to edit a standard template. Learn more. You notice differences in tables (e. This blog provides some background information about the postings made during conversion and references additional notes for more detailed information. Create a new new CDS View (Data Definition) in Eclipse. You can see that the company code and group currencies are shown in table ACDOCA for this material. Below documents are only updated in ACDOCA table as the freely definable currency exist in ACDOCA table. ACDOCA, FAGLFLEXT , KBA , BW-BCT-FI-GL , BW only - General Ledger , How To . Posting to an asset with different values in freely defined currency during document posting is possible. for a particular country continue to be grouped under the umbrella of one chart of depreciation. ACDOCA_M_EXTRACT is a standard Actual Costing/Material Ledger Transparent Table in SAP CO application, which stores ACDOCA Extract Table for Material Ledger data. Just like the fancy texts mentioned above, our Fancy Text Generator offers over 30+ fancy text styles for the name "Apaddoca". click on "Analysis" tab and select "Display" option from tool bar. Migration of Period Totals Records – Balance Carryforward. Note. You can extend the fields in the CDS view using eclipse. Step 1. 2. So the view for the FAGLL03H has KNA1 data linked, but from the KUNNR field. ) 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. Journal Entry Extension "Classic" Coding Block extensions using the OXK3 transaction and the CI_COBL structure. FAAT_YDDA. It will bring consolidated Actual data coming from ACDOCA and Plan data from ACDOCP together in one table (‘one version of the truth’). ACDOCA. Please suggest how could i insert line items in ACDOCA. First, you can now easily pre-view the data in the Test mode for the data to be released from SAP S/4HANA General Accounting (ACDOCA) to SAP S/4HANA for group reporting (ACDOCU). There are total 511 fields in ACDOCA table. Create another CDS view on top of it, to use the field in the select query. Loaded 0%. "Invoice Cancellation type " proposal comes from the Billing document type. The field is found. The Profitability Characteristics were tightly integrated in the General Ledger posting in the Universal Journal (ACDOCA). The Release from Universal Journal task helps to release the reported financial data from the universal journal for consolidation purposes. Select archiving object CO_ML_AEXT and double-click on it or choose Goto Detail. COPA is a very useful tool in SAP for monitoring financial performance. e. RKCUR Global Currency. Activate the SAP Screen Personas flavor for the app. It is a prerequisite to have New G/L active with G/L splitter and New G/L-JVA integration. Actual data (ACDOCA) and plan data (ACDOCP) of integrated companies (i. Back bone of S4H’s design is with HANA’s in memory capability and below design principles. 5* and 7. FINS_ACDOCA_BW — Meta Data. Once our partitions are created and data aging object is activated we can execute the actual Data Aging. This feature has been implemented in the following ways: The SAP standard method of deriving business transaction types has been enhanced to provide more details for Financial Accounting transactions that have used business transaction type RFBU ( FI Postings) in the past. The question in which CE4 table the ACDOCA-PAOBJNR and ACDOCA-OBJNR segment numbers are stored mainly depends on the release (and in some cases also on the business process) because the logic has changed a few times in the course of time. Chandrasekhar Ija. About this page This is a preview of a SAP Knowledge Base Article. 2 Text CDS view. Select archiving object CO_ML_AEXT and double-click on it or choose Goto Detail. Actual data of COEP (WRTTP = ‘04’) is now stored in ACDOCA. I am working on Migration project from R3 to S4, so i am the responsible for few of t. ACDOCA removes many aggregate and index tables, which greatly reduces your. Definition. 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. Project Business Automation (PBA) is the first vertically integrated business system for projects designed to provide the financial and operational tools, controls, and insight that you need. The Accrual Engine postings are stored only as line items of the universal journal entry, in table ACDOCA. With SAP S/4HANA Finance, when you post a journal entry, the header. ACDOCA Data Model . RSS Feed. Learn vocabulary, terms, and more with flashcards, games, and other study tools. 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. Hi SAP, If. This is a conversation between a human and a GPT-3 chatbot. S/4 Hana finance add-on architecture is based on new GL and comprises of new asset accounting module. 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. Impact on cPA. It is a browser-based application offered as software-as-a-service (SaaS) to model planning scenarios, capture plan data and perform (basic) planning functions with a modern user interface. ROCUR Freely Defined Currency 1. 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. privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. ACDOCA is updated with profitability document number and reporting on PA can be achieved in central finance system. We can see that the view apparently recursively accesses the COEP table and other tables like the ACDOCA. Vote up 4 Vote down. 3. Reconstruct Runtime Object (because, there is a missing DB Column. aging information of AR/AP). companies managed in accounting) can be released to group reporting (ACDOCU) for consolidations. ACDOCA does keep track of what kind of posting it is -She is the author of Controlling with SAP – Practical Guide, Accelerated Financial Closing with SAP, SAP HANA for ERP Financials 2nd Edition, and First Steps in SAP S/4HANA Finance. reading table FINSC_VERSN_LD for RLDNR where VERSN = '000' (for CoArea) Also you could add this field to the initial/selection screen of the program/report. Define threshold with reports / transaction named in the notes / SPRO. If that is the case then which all cases are excluded from BSEG. My question is about Currencies in ACDOCA. To use the ACDOCA or ACDOCU table as a source instance, you must then create a dedicated destination in the SAP BTP Cockpit which will let the application know the. In each company code, the leading ledger receives exactly the same settings that apply to that company code: the currencies, the fiscal year variant, and the variant of the posting periods. 80 is supported. Here is my brief synopsis of each of the Browsers within S/4 HANA. Actual data needed for long-term orders/projects from COSP_BAK, COSS_BAK is stored in table. The title references the certification that is required by most states in order to work as a nursing assistant. 2839178 - Program changes for optional suppression of period 000 for delta extraction with 0FI_ACDOCA_10, 0FI_ACDOCA_20, 0FI_GL_12. 5. In this example I have my COPA characteristic. You may choose to manage your own preferences. g. Output. 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. Intercompany Reconciliation with Central Finance: AR and AP are replicated into Central Finance, intercompany reconciliation (ICR) can access these receivables and payables directly in the Central Finance system. S/4 RTC Currency Translation. OK, sounds clear, but, what does it really means? Let’s explain step by step in this simple Scenario: 1) In the system I create 2 plants COL1 and COL2. C. 0% 0% found this document useful, Mark this document as useful. This has given a proper summary of Simple Finance which was must needed for starters like me. All new features like Business Partner, Fiori, LTMC, ACDOCA, Account based Costing, etc. Consolidation. When we add partitions on ACDOCA, will the repartitioning be executed? Q2. 1. Stock Differences. I am running the Code Inspector on a slow performing piece of standard code. The level of granularity coming from Universal Journal. BPC optimized for HANA or BPC for S4HANA seems to lean to only s4HANA systems where BPC and ECC co exist in one box . You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. Make sure that the data from separate tables in the ERP system is converted and combined in the ACDOCA table. The overall footprint of the JV. 4. MATDOC_EXTRACT. com Gaurav Agarwal Yes, universal journal is the biggest innovation in the area of Finance in S/4HANA which is clubbing various SAP components into a single accounting document as a true integrated information system. 2. Posting in Fixed Assets. ACDOCA-FUP_ACTION table field - Follow-up action for this Universal Journal Entry Line Item . , the asset values, whether it’s a transactional line item for a mid-year takeover or a balance value for an end-of-year takeover, must be maintained with a posting to ACDOCA. And the general advice on that feature is it was created by the support people at SAP not by the developers. Summarizing BSEG “aggressively” will bring relief with respect to the 999 line item limitation (BSEG-BELNR has only 3 digits). " Listen how Frank Warmerdam prounounces it and. In the first step of the wizard provide: In the field Name, enter JournalEntry. the universality of the SAP universal journal. For this scenario, as requirement needs an F4 help for the custom field, semantic type is assigned as ‘Code List’. List of supported. Now the CDS View entity is added as ODP Data Source. Commitments are reduced by various business transactions such as goods receipt, service entry sheet etc. The following image captures a basic CDS view created with few fields from the central Simple Finance table ACDOCA. Similarly, you may notice the data of period 000 of table ACDOCP is not retrieved in HANA foundation view RTC _C_FOUNDATIONP. ACDOCA includes all actual cost postings, both primary and secondary. Summarization of the Universal Journal (table ACDOCA ) is intended only for exceptionally large data volumes, which cause critical performance and data storage issues. but while adding characteristics you are not able to find cost element. It has been converted to transparent table in S4, as there is no need of pooled & cluster tables on HANA DB. g. PBA is built from the ground up for the enterprise to reduce complexity and seamlessly connect all your project business processes in one system. Solution. Summarization of the Universal Journal (table ACDOCA ) is intended only for exceptionally large data volumes, which cause critical performance and data storage. 0, a large amount of information material has been available that describes the architecture as a whole or different aspects of it. In the current area of the database (until moved by aging object FI_DOCUMENT) the information persisted in ACDOCA remains when archiving the corresponding objects of the different applications. The Integrated Business Planning (IBP) for SAP Simple Finance applications provide a consistent view of the planning process. stand for something definition: 1. When we convert to S/4 HANA we need to. 1. ACDOCA), all the pre-delivered Virtual Data Models (VDM’s), the performance of HANA and the modern and state of the art. 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. Right-click on Data Model and select Import –> DDIC Structure. B. and how it will work. Table: ACDOCA. — Transaction figures can be archived regardless of whether documents exist for that fiscal year or company code. Architecture Overview: Financial Planning | SAP Help Portal. According to this general approach, the UJE contains all JVA-relevant data and is the source of all JVA processes and reporting. Migration. In the field ABAP Structure, enter ZSACDOCA. Note: Actual top-down distribution cannot be performed across business areas. ACDOCA removes many aggregate and index tables, which greatly reduces your data footprint. There are 2 correct answers to this question. Universal Journal ACDOCA in Simple Finance is a table that includes all line items of business transactions posted to FI & CO. The Universal Journal (= database table ACDOCA) is the “single source of truth” for all accounting data. Search for additional results. I have fetched two SAP ERP tables into Azure Synapse: ACDOCA and JVSO1. GoTo Schedule tab and start the extraction. I have the following queries:The level of granularity coming from Universal Journal (ACDOCA) via the Release Task has a major impact on the performance/runtime of the Release task itself and on the data-volume being posted into ACDOCU table. You could also view this information on your SAP system if you enter the table name ACDOCA or data. To use the ACDOCA or ACDOCU table as a source instance, you must then create a dedicated destination in the SAP BTP Cockpit which will let the application know the location of the SAP S/4 HANA system of the ACDOCA or ACDOCU table you want to use. FINS_ML_ACDOCA_UTIL005 No entries exist for company code &1 to be compressed. Define the tolerance groups for cash flow reconciliation. company code). +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. What does no direct quotation mean? In writing, an. Computation is given below: "Cash at beginning (Hslvt in ACDOCT table) - Cash at the end of period. Assets = Liabilities + Owner’s Equity. Go to the update tab and select Initialize the delta process. Relevant authorizations for Data Aging activities are provided. With introduction of 1909 FPS01 Group Reporting, SAP came up with an approach for creation of custom fields. CO-PA (Profitability Analisys) allocations it is also an old request from most clients I had. This can be used in Report writer/painter also. Fortunately, SAP has provided an easy solution to include almost any field from the FI document tables ACDOCA,. Mention below are the usage of both applications, Profit Center Accounting (EC-PCA) Profitability Analysis (COPA) If an organization wants to analyze its internal Profits and loss department. With the start of the SUM, you are entering the Realization phase, and it also the start of downtime. We're implementing S/4 with old-style PS functionality (No EPPM at this stage) Standard Project Reports now show Actuals from ACDOCA. Creation of custom fields in ACDOCA and ACODCU. Creation of custom fields in ACDOCA and ACODCU. Note. It is in ACDOCT table (SE16) but not showing in characteristics. RFC SAP table connector (Azure Data Factory): TIMESTAMP column ACDOCA. We are on BPC standard 11. The ideal approach is to run the CO allocations reading and posting data straight from/to ACDOCP, similar to what has been done for ACDOCA for actuals. BKPF, BSEG and ACDOCA don’t store completely identical dimensions. Stock Differences. It looks like this: “Record count of column-store table partitions ( ID 27 ) Determines the number of records in the partitions of column-store tables. 1000. There are total 511 fields in ACDOCA table. sqlViewName: ‘V_MLHD_UNION’. RHOART is a standard field within SAP Table ACDOCA that stores Type of origin object (EC-PCA) information. Visit SAP Support Portal's SAP Notes and KBA Search. increasing your liabilities) or getting money from the owners (equity). ACDOCA-ACCASTY defines the CO Object type of the real account assignment. Since the introduction of the Universal Journal with SAP S/4HANA Finance 2. In order. +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. So it’s easier to understand and use. Ledger Specific Posting. FINS_RECON 766 ”MISMATCHED BALANCE FOR ANLP”. g. If new GL JVA integration is active, the JVA attributes are updated in Universal Journal Entry and reporting is possible using the new Universal Journal Entry table ACDOCA. Migration means coming from an ERP system and going to an SAP S/4HANA system with JVA on ACDOCA. RSS Feed. So, I found out some improvements to be done to enlarge the use of the BAPI_ACC_DOCUMENT_POST that I would like to share to you. CCA. Migration means coming from an ERP system and going to an SAP S/4HANA system with JVA on ACDOCA. It enables material inventories to be valuated in multiple currencies and allows the use of. We are uploading WBS Plan via the Standard Fiori App "Import Financial Plan Data" which includes a Template for uploading Plan to WBS. Description: Fields for Universal Journal Entry Document Extractor:We have a situation where SAP PaPM (On-Premise version) is deployed on BW/4HANA but for financial data, we need to fetch ACDOCA records from S/4HANA. Every state ballot measure on abortion rights since Dobbs has come out in favor of abortion rights, even in red states like Kansas, Kentucky and Ohio. Review terms and definitions. The human first asks: What is the difference between ACDOCA and ACDOCU?. Office of Cultural Affairs (New Mexico, USA) OCA. Repartitioning#1. ACDOCA-SDM_VERSION table field - SDM: Version field for ACDOCA . It will bring consolidated Actual data coming from ACDOCA and Plan data from ACDOCP together in one table (‘one version of the truth’). ). FINS_ML_ACDOCA_UTIL008 Pre-compacted inventory data inconsistent for material &1. Now that reporting is poised to be faster than ever, with several modules integrated into a single table and reconciled in real time. In the above example, the data objects are split into 43 packages by Parallelization Framework (PFW) for the Migration Class. It stores all details needed for Controlling (CO), Material Ledger (ML) and Asset. Reports in AP,FA. g. Enter the Entity Type Name and ABAP Structure and click on ‘Next’. Billing Document Type must not be RV. Post-Clearance Audit. We want to use ACDOCA because we have needed informations that we we are unable to find using BSEG. 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 centerMissing document using 0FI_ACDOCA_10. 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. waers, exchange_rate_date => dats_add_days. We got the existing Interface view “I_GLAccountLineItemRawData” consuming data from ACDOCA which satisfied our requirement. Both tables are within the same SAP S/4HANA system. Material Ledger, and Controlling. You will extend. Or 2. However, in Account based CO-PA, the posting of COGS happens alongside the Goods issue. e. reading table FINSC_LEDGER for RLDNR where XLEADING = 'X'. ACDOCA update for Invoice document: – Incoming Payment Document Posting using F-28 for Invoice 1800000022: – As we can clearly see that Cash Discount expense line item get split into two different line of 20 USD and 10 USD total to 30 USD because of two different Prof. I would suggest using the Document number as Delta pointer as ACDOCA or ACDOCU table entries doesn't get modified at all, always new document number gets added when there is new posting happens Share Improve this answer ACDOCA is a standard SAP table in SAP ECC (or) S/4HANA which stores Universal Journal Entry Line Items data. In the future, more and more data migrations will be shifted from XPRA processing to SDMI. DATA: et_bseg1 TYPE. Understand. ” It was brought on by SAP’s exclusive HANA. The universal journal includes columns for the standard characteristics and all additional characteristics included in an organization’s operating concern (up to sixty. Mention below are the usage of both applications,. The material ledger uses this data to calculate prices to valuate these materials. On this page. The universal journal includes columns for the standard characteristics and. Previously, data was read using a join between profitability segment table CE4XXXX and CO actual line item table COEP compatibility view in S4H that redirects the select to table ACDOCA internally. You are on page 1 of 1. ii. C. Our target is to add a field at the end of this view from ACDOCA table and field name is BLDAT. docx For Later. The Profile Parameter abap/data_aging is set to ‘on’. Yes, it is a period that does not exists from an Accounting point of view, but S/4 HANA Finance uses this Period Zero as the starting point to have a “marker” to know where those balances. It combines transactional line items from different functional subdomains: •. PO Against WBS. e. Step 6. At the begining I thought that we had the same number of items for one FI document in. D. The ACDOCA table, on the other hand, is a universal journal entry table that can consolidate financial data from various sources. You may choose to manage your own preferences. SAP Knowledge Base Article - Preview. First 2 Currency fields are derived from local currency i. FINS_FI_MIG720 ACDOCA does not have enough datasets, migration is not yet finished. If you post a document to “0L”, The system will update ACDOCA with Leading Ledger posting to “0L” only. 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. Relevancy Factor: 170. Debit / Credit indicator incorrectly updated in ACDOCA table. 26785 Views Last edit Sep 13, 2021 at 06:34 AM 2 rev. Open The Update Tab and select the Full Load Radio Button and start the extraction from schedule tab. 2. In the following case, so many entries are there, but it does not mean manual operations are needed for all. At this stage of the process, no accounting document is created. It is the business department and its users’ needs that are most relevant here. Document type : Excluding “AF”. We use external function type because we have a number of custom fields in universal journal that we need to post to. , KBA , CO-OM-OPA , Overhead Orders , Problem . When doing external reporting would you include this into the reporting? Alternative please if someone can explain to be. FAGLGVTR creates documents in Period 0 of the newly opened fiscal year, representing the cumulative balances as of the. There is a strange behavior in the release GL data task from data monitor, while triggering this step for 2021. 2. dataExtraction. PCA. Combined COPA will not be in. They are enriched by attributes that can be derived from the material assignment: G/L Account, Profit Center, and Segment. ACDOCA table contains all ACDOCA table has 6 digit field for line item numbering f. Any FI posted documents cannot be found in. But which is the best or have added the Maximum. Input Parameters. It contains all documents posted with the components FI, CO, MM, SD. ACDOCA). For example, if you need to retrieve additional ACDOCA data for statistical information (e. Table ACDOCA (Transaction SE11) Transaction SCFD_EUI. It provides a detailed analysis of the balances existing for each account. But control did not stopped there. This consists of a. Share. There is a custom implicit enhancement in FM FI_DOCUMENT_POST, which split BSEG entries into multiple entries with the Amount. Use the corresponding configuration items to modify elements of the form template. A. Make sure that the data from separate tables in the ERP system is converted and combined in the ACDOCA table. With introduction of 1909 FPS01 Group Reporting, SAP came up with an approach for creation of custom fields. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. 0% 0% found this document not useful, Mark this document as not useful. One component that can help an entity properly assign results is the Assessment Cycle. The Structure ZAFINS_ACDOCA_BW is created for single field ZZNETDT. RACCT is a standard field within SAP Table ACDOCA that stores Account Number information. The fiscal year variant of the G/L ledgers are supported. However, it does not contribute to the preparation of financial statements. The replication of data can result in duplicate records in the target system if no primary key (including a unique constraint) has been defined in the database for the target table. Universal Journal – ACDOCA Table The ACDOCA Table helps to keep Reports and tables in one database itself. The sport has grown drastically over the years and is viewed as one of the top motorsports organizations in the world. g. ACDOCA vs BSEG in ABAP. the introduction of ACDOCA or Universal Journal) ensures consistency in S/4HANA - compared to ECC versions of our Business Suite. FINS_FI_MIG722 Migration activity &1 aborted. Fig. 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. The S/4 RTC CT will read the data from ACDOCA and post the unconsolidated translated result to ACDOCC. Click more to access the full version on SAP for Me (Login required). 3. Its data granularity is the same as the granularity of the year-end balance carry-over, and does not affect the balance. Segment. Rap is a rhythmic vocal style that is commonly associated with. Below is a PO created against a WBS element. Extend the CDS views – Eclipse. The reported financial data is then the basis for all subsequent consolidation tasks (like currency translation, validation. What does Acdoca stand for? In a direct quote, the foreign currency is the base currency, whereas the domestic currency represents the counter currency. Custom fields and logic App. The Universal Journal (= database table ACDOCA) is the “single source of truth” for all accounting data. 3. if data flow Index tables and ACDOCA table it will be heavy data on server. Source System of BW system. r. Sri P. Don't:RSS Feed. If I understand well what you want to achieve, this should work: SELECT * FROM acdoca WHERE ( blart = 'DY' and koart =. Appreciate input. ACDOCT is a CDS view and not a table but it can be used in report painter for fetching totals with standard fields. Material ledger document ACDOCA numbers have not been dependent from the DOCLN organizational unit (e. ACDOCA structure got updated with freely definable currency & amount in freely definable currency. This can be done, since ACDOCA stores the full detail and ACDOCA has a 6 digit field for line item. To find this archiving object, start transaction AOBJ . Revaluation Posting. Actual data of COEP (WRTTP = ‘04’) is now stored in ACDOCA.