0fi_acdoca_20. Entered On - CPUDT. 0fi_acdoca_20

 
 Entered On - CPUDT0fi_acdoca_20 SAP S4HANA MOOC Series Session 10 S4HANA Embedded BW Sesion

0. Journal Entry Extension "Classic" Coding Block extensions using the OXK3 transaction and the CI_COBL structure. How several modules have been integrated into single. Then create an Append structure and provide the field details. DataStore Objects. SAP ERP Central Component. Search for additional results. Search for additional results. Can this be used which will satisfy my Account Receivables? BW Inventory Management Impact by MATDOC Table. Data Hub is the new SAP solution to build big data warehousing scenarios. Replacement of the Legacy Extractor 0FI_ACDOCA_10 with which CDS View possible ? I want to replace the legacy Extractor 0FI_ACDOCA_10 with a CDS View. SAP_FIN. In cases, in which big data volumes with a frequent changes are expected, e. Besides for the basis currency type 00, this company has 3 other currency types: 10, 30, 50. F, G, C, M, A: Line items or balance information originating from classic GL, New GL, CO, ML or AA. Data Extraction from ACDOCA and ACDOCP - missing field "Planning VERSION". I have a question. Create a BAdI Implementation for Flow Builder Plus. BW请求数据,在R3端执行对应的FM操作,获取数据. I have datasource 0FI_ACDOCA_10 and an ADSO already available in BW. Click to access the full version on SAP for Me (Login required). The content was built around the Layered Scalable Architecture (LSA) approach. We will create Global Class and handle method to get data from CDS View which was created in step 1. 5 Table ACDOCA and Finance DataSources Unlike logistics DataSources, there is no need for a setup table to do a historical data load here. From SAP ERP 6. The extractor does not transfer any redundant fields to BW. Can this be used which will satisfy my Account Receivables?Stocks used to get stored in multiple tables like MARD, MARC, MBEW for different ECC reports like MB5B, MMBE etc. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the. If a data inbound layer persistence and/or a corporate memory persistence is used, the transformation from this DataStore object (advanced) to the InfoSource directly assigns the fields of the DataStore object to the InfoSource. Hi All, I need to find Table & Field level mapping with ACDOCA compare to ERP Tables? Anybody have any thoughts & any link to proceed further. TRF doesn't contain master data lookup rule. Pratyaksh Jeet. SAP enhancement package for SAP ERP, version for SAP HANA. Document Date field not editable during clearing. It can store all the metadata about the tables, such as partitions, columns, column types, etc. Can we use same functionality in customized real time infocube in S/4 premise. Also, evaluated Pros and Cons of 0FI_ACDOCA_10 vs 0FI_ACDOCA_20. Characteristics. This CDS view provides access to all details of a G/L account line item including the most important business entities, such as G/L account, company code, cost center or profit center (without the ledger). 0 1. SAP recommends to activate the BAdI FIAA_BW_DELTA_UPDATE and to run the extractors 0ASSET_ATTR_TEXT and 0ASSET_AFAB_ATTR before the data extraction from 0FI_AA_12. Config Tables. This DataSource provides Accounts Receivable Accounting line items from tables BSID (open items) and BSAD (cleared items) in the R/3 source system. Our operation to stop the processing chain caused the 0FI_ACDOCA_10 extraction request was be terminated After changing the status of this request to green, but the next data source extraction we found that some accounting document delta were missing. Which CDS Views (of any ) are best suited ? Thank You ! Hello, I want to replace the legacy Extractor 0FI_ACDOCA_10 with a CDS View. A few months ago, I implemented the 0FI_GL_20 data source and went with a layer 1 DSO in between the data source and 0FIGL_C20. It contains all documents posted with the components FI, CO, MM, SD. SAP enhancement package for SAP ERP. Finally,go back to table ACDOCP, and we can check the same planned values with ERP tables now. NUMC 4 is from 0000 to 9999. 1)First delete the request from data target. SAP Help Portal | SAP Help Portal. For creation a new KeyFigure InfoObject you need to use BW Modeling Tools in Eclipse app. ODQMON stores data in compressed format and is also a replacement of traditional PSA. As part of it, the financial related data is extracted (e. There is a high-level list of all CDS extractors in each SAP S/4HANA system starting from releases in 2020. 5/BW4) we are using S4/HANA 1809 and BW7. Hello Jian Bai, Replicate the DataSource in BW and Run this Program RS_TRANSTRU_ACTIVATE_ALL . Any resemblance to real data is purely coincidental. I need to build a data model on top of 0FI_AR_30 which is Account Receivables. I am having an issue where Hudi does not update the hive metastore with new schema changes in AWS Glue Catalog. But control did not stopped there. In the System SAP S/4HANA after the posting depreciation, we do not find the value Ordinary Depreciation in the table ANEP, for the corresponding field NAFAB. InfoProvider. RSC1_INIT_BIW_GET is a function module in SAP Basis application with the description — Extraktor f. Once (and as long as) this Streaming Process Chain is scheduled, you will find one request in ODQMON which has status “Extraction Running”; as soon as the Streaming Process Chain is out of scheduling this request receives the status “Confirmed”. 0, version for SAP HANA. how to update acdoca table. In Note 1651740, we can see 0FI_GL_30 is sub content bundle FIN_REP_ODP_FIGL. 0FIS_GL_LINEITEM. We have migrated to S/4 HANA-1610 and trying to find related fields in ACDOCA because BSEG entries are now moving into ACDOCA and we have to convert our select queries from BSEG to ACDOCA. According to this general approach, the UJE contains all JVA-relevant data and is the source of all JVA processes and reporting. BALANCE. The integrity and authenticity of the financial. This InfoSource contains the structure to provide GL Account line item data into the Integrated DWH Layer. However, the key field Ref. Environment. As a consequence the extracted records have all key figures multiplied. So questions as below Using 0FI_ACDOCA_10/20 vs 0F_GL_10/14. Of course, we can do it, but the question is - is the extra step worth the effort. Arkadiusz Drużynin. Please save your work. Group currency is the currency that is set up for the client. SAP Data Warehouse Cloud - First Guidance_ Data Integration for ABAP Source Systems - Free download as PDF File (. Run report RFINDEX on a regular basis to check inconsistency in your systems. Master Data. ACDOCA is a standard General Ledger Accounting Transparent Table in SAP FI application, which stores Universal Journal Entry Line Items data. 2341038 - Usage of datasources 0FI_ACDOCA_10 and 0FI_ACDOCA_20 in sFIN / S4HANA 2743475 - Delta-Extraction doesn't work for 0FI_GL_12, 0FI_ACDOCA_10,. Scenario 3: Extracting from FI (Financial) DataSources. ACDOCA & FAGLFLEXA Comparison. Execute Program BS_ANLY_DS_RELEASE_ODP. 0FI_ACDOCA_20, MIG_SOURCE , KBA , BW-BCT. our ECC system is on ERP on HANA with Simple Finance add-on. with-in the SAP FI Module. define view VIEW as select from acdoca inner join bseg on acdoca. This leads to system dumps since ACDOCA is in partially active status. Last Update - UPDDT. I was referring to the simple finance in SAP S4 HANA. We are using the ODP mechanism for data extraction from S4. But you find this FM updates BSEG table but does not update the value in ACDOCA. General Ledger: Balances, Leading Ledger. 0FIS_GL_LINEITEM. Click more to access the full version on SAP for Me (Login required). It successfully extracted data. Page Not Found | SAP Help Portal. 5/BW4) we are using S4/HANA 1809 and BW7. Couldn't activate CI_COBL and ACDOCA also. • Applied SAP note to make 0FI_ACDOCA_20 a “delta init without data… Show more This project is aimed to support various BW applications and my role includes: • Daily process chain and jobs monitoring, resolving incidents and service/change request • Involved in taking care of new enhancements, gathering requirement from user and. This EXIT move some custom information to the field BSEG-SGTXT. Read the Test Script on the page above as it is a user guide in the early sections. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. 0FI_ACDOCA_10. Understood. For R/3 releases from 4. Document Splitting: Lets say you buy office supplies for your company (say 5000 p. I am using 0FI_GL_4, 0FI_AR_4, and 0FI_AP_4 in S/4 HANA system and encountered duplicated records when loading delta records. Extractor 0FI_ACDOCA_20: This extractor is having VALUETYPE field but it has only 10. From SAP ERP 6. Hello Steffen, Is there any way to add custom characteristics with reference to the existing Data Elements and compound dependencies (Country and Region for example) through se11 to include structure INCL_EEW_MARKET_SEGMENT_PS. Read more. Diagnosis. We are looking at implementing HANA Optimised FI-GL Business Content that came with BW/4HANA. Data flow for 0FI_ACDOCA_10 (Unified Journal Entry) data source in SAP BI. The level of granularity coming from Universal Journal. BW-BCT-ISR (Retail and Consumer Products)Datasource : 0FI_GL_10. Below picture is depicting the structure of the universal journal in S/4HANA covering general ledger, profit center accounting, fixed asset accounting, ma Missing document using 0FI_ACDOCA_10. It will show transfer structure length of all the columns; Column length in Transfer structure and Extraction structure are generally not same. 0, version for SAP HANA. This means that only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables). 0: 2142781 - DataSources 0FI_GL_12, 0SEM_BCS_12 and related ones are not updating delta queue. KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problemsap acdoca table fieldssalon suites for rent in dc. 0FI_ACDOCA_20 . Search for additional results. Transaction (AWTYPE) is not extracted in the SAP standard extractor 0FI_GL_10, and therefore it cannot be used as a key field on the BI side. S/4HANA Finance Technical Changes. 0, version for SAP HANA. dataFrame. Below picture is depicting the structure of the universal journal in. I have a CFIN source system (S4Hana "Universal Journal Entry"), the IT area tells us that the table to extract is the "ACDOCA". This blog has been substantially rewritten in December 2018 to include information on how to retrieve fields from various associated master data tables like LFA1 and KNA1, and to clarify the steps for including the additional fields as dynamic selections. For more information, see SAP Notes 1476708. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system. The Structure ZAFINS_ACDOCA_BW is created for single field ZZNETDT. To summarise this example, the client has 865 live DS’s that extract data from ECC into BW. ACDOCA, mismatch, extractor , KBA , BW-BCT-FI. Create space : once the user is created, you have to create a space that is the Virtual workspace where the data models and stories are stored. 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. This includes advanced business processes such as Margin Analysis, New Bank Accounting, New Asset Accounting, Universal Allocation and much more. The BAdI filter ORIGIN_APPLICATION shall be set to ‘ BSEGV ’. Then create an Append structure and provide the field details. We were not be using the traditional ABAP as we can leverage more power from ABAP on HANA. Hi All, Hope everyone safe at Home. CLASS-METHODS: get_acdoca FOR TABLE. 今天仍然在研究财务数据的抽取,. Hi, I am creating an aDSO for above data source on BW4HANA, write optimized. To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. Pratyaksh Jeet. format ("org. However, this approach frequently encountered errors. we have requirement to export all line item postings from S/4HC to SAP BW and to distinguish between statistical and standard/real postings. pdf - Free download as PDF File (. More Information. The fields PS_PSP_PNR and PS_POSID (WBS element) in ACDOCA are not matching for a document. Loaded 0%. The note refers to InfoObjects 0* however, in S/4HANA those infoobjects doesn't exist anymore, instead we have /ERP/* infoobjects. Documents. RemoteCube-Compatible. I'm currently working on loading heavy SAP datasources, such as 0FI_ACDOCA_10, using Appflow to S3. 1 over B4HANA 2. G/L account and cost element have been merged into single field ACDOCA-RACCT. We are using 0FI_ACDOCA_10. We are BW4HANA system. The problem is that when we extract INIT load. Popup: Get New Mass Data Project ID for acdoca update (Currency Change) FI - General Ledger Accounting. The note contains the list of BW extractors which are fully supported, Partially supported and obsolete with S/4 HANA. 旧版本 . SAP S/4HANA Cloud all. 使用Table(GLT0和GLFUNCT) DataSrouce: 0FI_GL_1(余额,只支持FULL加载) 0FI_GL_2(余额,只支持FULL加载) 0FI_GL_4(行项目,支持DELTA加载)why is masjid al-haram so expensive 0941 399999. Sep 18, 2019 at 09:54 AM Delta load for 0FI_ACDOCA_10 data source not working 3996 Views Follow RSS Feed Dear Experts, We are BW4HANA system. That is how PO accrual works. Enter the InfoPackage description, select the Data Source and click Save. INTERFACES if_amdp_marker_hdb . Field "Due date for net payment" (NETDT) is not update in ACDOCA. Visit SAP Support Portal's SAP Notes and KBA Search. We have the requirement with the data from tables BSEG and BKPF Tables. Source of migrated line item (Field: MIG_SOURCE) 1. I use the general term “SAP BW” which refers to both SAP BW 7. Cookie Statement | Powered by:What a universal journal table ACDOCA covers and what not? 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. g. The field from which the data is taken depends on the ledger master data, the characteristics of the InfoObject OCURTYPE, and the posting period. 4 ; SAP S/4HANA Finance 1605 ; SAP Simple Finance add-on 1. For BW side we extract these tables through different extractors for Master data and Transaction data (0IC_C03). 1 Answer. Understood. This blog provides some background information about the postings made during conversion and references additional notes for more detailed information. Consider that not only the ACDOCA table is extended. With SAP S/4HANA Finance and Controlling, the totals tables are no longer required because data can be aggregated. The note 2341038 says that we can use the new 0FI_ACDOCA_10/20 datasources and even though we don't have any BI. Missing document using 0FI_ACDOCA_10. Data flow objects are created and edited in a graphical editor. Go to SE37 -> In the Menu click on ‘Function Module’ -> ‘Execute’ -> ‘Test Sequences’. , KBA , BW-WHM-DST-TRF , Transformation , BW-WHM-MTD-CTS , Transport connection , Problem. Like 0. With. Hello All, In this blog post I would like to bring to your attention these two Universal Tables which have been introduced in SAP S/4 HANA with respect to SAP PS objects and their linkages. Once select the delta records will come automatically even when failing the request at any cost level. Enter the function modules as below. Status – Implementation complete. ACDOCA-MIG_DOCLN table field - Item ID of migrated G/L line item . 2561628-Message "Name of field ACDOC_COPA_EEW_DUMMY_PA is longer than 16 characters" after activating 0FI_ACDOCA_10. (ex: 0FIGL_M30 0FIGL_M20 0FIAA_M20 for each module there are direct access supported using datasource like 0fi_gl_12 0FI_ACDOCA_20 etc. 0FI_GL_30(Balance Sheet) RFINDEX report to find Inxed based inconsistencies in system . BW as the target system; Source system version independent; 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. Select your data source and click on the edit icon. Motivation. I want to activate the Standard Content in BI and load data in it. I researched and found two possible standard extractors: 0FI_ACDOCA_10 and 0I_GLACCOUNTLINEITEMRAWDATA. Plan consolidation works in conjunction with SAP Analytics Cloud. 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 start. e. We are moving to S4 from our existing ECC system. : 0FI_ACDOCA_10 – Universal Journal Entry) from. Performance enhancements might be available for data extraction. Could anyone please suggest me which Info cube, DSO, Transformations to be activated for 0FI_ACDOCA_10 data source in BI. Before using data source ,make sure they are ODP enabled otherwise you need to run one prgram to make it ODP enabled data source. I am trying to create an external file in hive metastore, using apache hudi framework. we are aware of DataSource 0FI_ACDOCA_10 and the CDS View I. You can see the 0FI_ACDOCA_10 and 0FI_ACDOCA_20 DataSources in Figure 4. ; Take out the function from. About this page This is a preview of a SAP Knowledge Base Article. We got the existing Interface view “I_GLAccountLineItemRawData” consuming data from ACDOCA which satisfied our requirement. Successfully developed few of the reports in SAP FIORI by exposing the report from BEX in SAP BW. Visit SAP Support Portal's SAP Notes and KBA Search. Page Not Found | SAP Help Portal. Closing/Consolidation team can save. BW as the target system; Source system version independent; Product. 43 in NUMC is 0043. They help you to visualize the SAP BW∕4HANA objects (and their relationships) contained in a data flow. Sine 0FI_GL_10 is a totals extractor for balances, you can use 0FI_ACDOCA_20 based on notes: 2341038 - Usage of datasources 0FI_ACDOCA_10 and 0FI_ACDOCA_20 in sFIN / S4HANA -- you can find the field mapping. Delta Process: After Images with Deletion Flag Via Delta Queue (Like BtB. The lower limit for safety interval contains the value that needs to be taken from the highest value of the previous extraction to obtain the lowest value of. For assets the objectname = 'ANLAGENNR'. The field is used as a common currency for FI and CO. RSS Feed. to replace old finance DataSources. Application. The most important attributes of business entities are included, such as group G/L account or. What happens then with Real Time Consolidation RTC ? It will not leverage S4 HANA cloud transaction data at real time??This InfoSource contains the structure to provide new general ledger line item data to the EDW Core Layer. External services are maintained in purchasing documents in service lines below the item level. Visit SAP Support Portal's SAP Notes and KBA Search. The new content combines the capabilities of SAP HANA and SAP BW/4HANA for the most optimal solution. 1) If we go for ODP-CDS option, are there any standard CDS view providing the same data as above datasources. , as it seems during clearing this field is grayed out and same as clearing date, it seems not possible to change it in standard. But ACDOCA-AWREF is different from these two. We would like to show you a description here but the site won’t allow us. Space: Item created after migration. 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. 0. Planning at accounting level for companies that. For more information, see SAP Note 1523670. Delta load from BW to BPC from 0FI_ACDOCA_10 (Existing Data load from PCA to BPC- Pain point). In this case the following code will work properly: *XDIM_MEMBERSET ACCOUNT=PL110 //EXP ACCTYPE *XDIM_MEMBERSET. Probably (if SSO between SAC and BW has not been configured) your BW credentials will be requested at this moment. 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. g. Mar 03, 2008 at 03:27 PM. You notice that one or more queue-based/PUSH DataSources (i. Fill the offsetting account in FI Documents. . Hi, Where can I see the ACDOCA-AWREF (Reference doc. Scenario 4: Extracting in delta mode from SAP TM (Transportation Management) DataSources. G/L Account Master (Chart of Accounts) Field XSPEB GL Account Blocked for Posting. Financial Accounting is broken down into the following sub-modules: Accounts Receivables Accounts Payable Asset Accounting Bank Accounting Consolidation Funds Management General Ledger Special Purpose Ledger Travel. PUBLIC SECTION. Hive Metastore. T009. The DataSource works in the after image process. This causes problems when you activate the transfer. Configure and implement SAP FICO into the SAP S4 HANA. But i've seen scenarios where entries are getting maintained in both (BSEG & ACDOCA). I researched and found two possible standard extractors: 0FI_ACDOCA_10 and 0I_GLACCOUNTLINEITEMRAWDATA. The FI Line Item Browsers – Part 3 – Additional Fields from Base and Master Data Tables. Cannot get the data of WSL values after extract 0FI_ACDOCA_20. Flow Builder Plus used the central BAdI of One Exposure to adjust the final flow: BADI_FQM_FLOW_ADJUST_CORE. Not sure about 12, I think it is infosource only used for balances. Visit SAP Support Portal's SAP Notes and KBA Search. In this OSS note the current status is described how to activate the delta queues after migration to sFin 2. SAP enhancement package 6 for SAP ERP 6. Finance extractors use timestam ps for fetching new and. SAP BW/4HANA 1. 0 I have a requirement to add a field say MAKTL_MM, and some other fields which are part of ACDOCA but not present in 0FI_ACDOCA_10 Extract structure. 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. Understood. Here are some of the key features of the ODQ: Enables “extract once, deploy many” architectures for data sources. convert string to date in informatica expression sap acdoca table fieldsDescribe the problem you faced I am trying to bulk_insert a small table (~150MB) into s3 using Apache hudi. Data Migration Post implementation – very High. SAP enhancement package 6 for SAP ERP 6. 0COSTELMNT_ATTR is Not whitelisted, will work but with some. pdf. Follow. 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. Here, x stands for T, H, K or O. "/BIC/CODS0FI_ACDOCA_10" for 0FI_ACDOCA_10 data source). Data Hub is an application focusing on integrating data assets. xSLnn and xSLVT. I have a requirement to add a field say MAKTL_MM, and some other fields which are part of ACDOCA but not present in 0FI_ACDOCA_10 Extract structure. Customer. In this table the following fields are available. Search for additional results. However, My question do we really need to create COPA Extractor ( Account based) or can we leverage the Standard Extractor - 0FI_ACDOCA_10/20 which can fulfill all the details that we get for COPA Extractor ?. : 0FI_ACDOCA_10 – Universal Journal Entry) from S/4HANA system and it is fed into a standard/custom ADSO in BW system. 10412 Views. As per OSS note 2341038, I was trying to understand how to remap the 0FI_GL_ extractors like 0FL_GL_10/14 . Application: FI - General Ledger Accounting. Purpose. Go to the Eclipse ABAP Perspective and find extract structure for the datasource 0FI_ACDOCA_10. SAP S/4HANA 1610 ; SAP S/4HANA 1709 ; SAP S/4HANA. hudi") . Config guide 2JV will explain how to import the S4 data. We would like to extract data all data from ACDOCA table to BW and wanted to share the same for SAC usage. The Financial Planning & Analysis content for SAP S/4HANA shows you how to do this. We have requested users to change some transactions and tried the delta but no records are extracted. 0 ) for SAP Basis >= 730 2. 0FI_ACDOCA_10 Extractor Enhancement for BW extraction | SAP Community Relevancy Factor: 2. 有几个地方仍不理解. During the month-end. Enter the InfoPackage description, select the Data Source and click Save. Custom Reports – Very High. 0FI_ACDOCA_20 . How should we fix the incremental data? Attachments. Now We found that there is a different table called FAGLFLEXA & FAGLFLEXT , Which will have the combined data from BSEG , BKPF and some other tables. Similarly you can click on any target info providers name and all the requests which are already loaded to that info provider will be highlighted. General Ledger. When I replicate the datasources I see many of my used datasources in Controlling area. For SAP BW/4HANA, brand-new, ready-made content is delivered that uses the new objects, such as CompositeProviders, and is based on the simplified LSA++ architecture. But which is the best or have added the Maximum. However, you only get 16 keys in a DSO, and you simply won't have enough keys in a DSO for this data source. SAP S/4HANA Service Contracts. In our design we are using standard ECC datasource 0FI_GL_12 ( New GL : Balances of Leading Ledger ). If the DataSource is executed in any other mode, then it will not work. Data Source 0FI_GL_4 , will satisfy this requirement. " S/4 HANA Cloud S/4 HANA. Used the S4HANA generic adapter 0FI ACDOCA 10 for related transactional data. It comprises the journal entries brought about by these types of transactions and, therefore, represents a primary source of information on SAP S/4HANA. Share. transaction data like sales orders or similar, the application needs to provide delta records. During the month-end closing (specifically last 2 to 3 days), the financial data is frequently updated in S/4HANA system and the same data is extracted and reported. Visit SAP Support Portal's SAP Notes and KBA Search. If. Following are the symptoms: ERP: RSA5 - Look up and activation over datasource 0FI_GL_10 --> OK. Hudi is able to correctly populate the hive metastore for a new Hudi table, but updates to the Hudi table like addition of column and addition of partitions are not synced to hive metastore. Financial Accounting (FI) SAP S/4HANA Finance. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. ACDOCC is a standard Real-Time Consolidation Transparent Table in SAP FIN application, which stores Consolidation Journal data. I realized there is a field named "Offsetting Account" in table ACDOCA. In our design we are using standard ECC datasource 0FI_GL_12 ( New GL : Balances of Leading Ledger ). Testing works well for full load and delta load in Test Environment but when deployed to Production for full load, it was only. Please suggest how could i insert line items in ACDOCA.