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. BW请求数据,在R3端执行对应的FM操作,获取数据. srv100775. Hi, Where can I see the ACDOCA-AWREF (Reference doc. This causes problems when you activate the transfer. png. InfoProvider for actuals data. e. The integrity and authenticity of the financial. Entered On - CPUDT. 1) If we go for ODP-CDS option, are there any standard CDS view providing the same data as above datasources. Indexes Vs. After activating the text views, you are now able to start the extension: 4. 当录入冲销凭证时F-02选择反记账 BSEG与ACDOCA表的凭证记录的借贷方会相反,金额正负号也是相反的 2. odbc. This EXIT move some custom information to the field BSEG-SGTXT. You need to select the following options in RFINDEX: 1. Following are the symptoms: ERP: RSA5 - Look up and activation over datasource 0FI_GL_10 --> OK. Step 5 ACE: Migrate accrual postings. 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. In the list, select those services that you want to activate and choose Add Selected Services . ROOSFIELD is a standard BW Service API Transparent Table in SAP Basis application, which stores DataSource Fields data. Field XBILK whether Balance Sheet- or Profit & Loss-Account. SAP S/4HANA Service Contracts. Scenario 3: Extracting from FI (Financial) DataSources. The BAdI filter ORIGIN_APPLICATION shall be set to ‘ BSEGV ’. Pratyaksh Jeet. In addition, you can define and derive your own business transaction types. 3 Answers. I have the following queries:Delta fields for ACDOCA. I have a question. Popup: Get New Mass Data Project ID for acdoca update (Currency Change) FI - General Ledger Accounting. "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Hi All, What fields can I use to identify delta records in ACDOCA to identify changed/deleted/new records? Is there a timestamp or date/time field I can rely on? I need to use BODS to pick up data from this table on a daily basis and need this detail. Our environment is BW4HANA (SP5) with S4HANA (1709). Below picture is depicting the structure of the universal journal in. This DataSource extracts Accounts Payable Accounting line items from tables BSIK (open items) and BSAK (cleared items) in the R/3 source system. odbc file are manually created in the INFA_HOME/9. SAP enhancement package 6 for SAP ERP 6. Financial Accounting: General Ledger Accounting (FI-GL) Available as of Release. Steps to convert the datasource to ODP if AIP is 2. 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). top selling product by. Hello, I'm trying to use 0FI_ACDOCA_10 data source to extract data from ACDOCA table. ROOSFIELD. Please find an example setup of the InfoProvider for the actuals data below. This data source extracts data records for universal journal entries. Step 2. option (HoodieWriteConfig. Examples of such DataSources include 0FI_GL_10, 0FI_GL_14, 3FI_GL_xx_TT, 0EC_PCA_1, 0EC_PCA_3, 0FI_GL_4, 0APO_LPROD_ATTR, etc. The problem is that when we extract INIT load. Hi, two more remarks from my side to avoid misunderstandings: program RODPS_OS_EXPOSE can only be used to release DataSources in the customer namespace (starting with letters e. Motivation. Apr 21, 2020 at 10:23 AM. | Learn more about Rohit Ghosal's work. The note 2341038 says that we can use the new 0FI_ACDOCA_10/20 datasources and even though we don't have any BI. Read more. Highly efficient data compression (>90%). I realized there is a field named "Offsetting Account" in table ACDOCA. Jun 24, 2016 at 05:57 AM. RSS Feed. 0B to 4. ACDOCA, mismatch, extractor , KBA , BW-BCT-FI. ABAP FM. Creation of InfoObject. SAP Universal Journal analyzes the major impact of S/4 HANA Finance’s table architecture design on General Ledger Accounting. 0FI_ACDOCA_20, MIG_SOURCE , KBA , BW-BCT. Maintain number intervals for assets directly via transaction AS08. Page Not Found | SAP Help Portal. 30 = Group Currency) is also configured as parallel currency in FI (table T001A / tx OB22) Then KSL filled in all line items in all ledgers. System must add buffer to timestamp because of the document saving time consuming. In table T003 is the number of the number range. e. Visit SAP Support Portal's SAP Notes and KBA Search. 0FI_GL_30(Balance Sheet) RFINDEX report to find Inxed based inconsistencies in system . According to this general approach, the UJE contains all JVA-relevant data and is the source of all JVA processes and reporting. More Information. Extend the CDS views – Eclipse. InfoProvider for BPC planning data As part of it, the financial related data is extracted (e. Visit SAP Support Portal's SAP Notes and KBA Search. ACDOCC is a standard Real-Time Consolidation Transparent Table in SAP FIN application, which stores Consolidation Journal data. DataSource 0FI_ACDOCA_10 did not extract some documents from ACDOCA table during the initialization. 0. 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. For R/3 releases from 4. e. Will it have any positive impact on performance. 0 to SAP S / 4, the standard table structure has changed significantly. Cheers. ACDOCP – This table was introduced in S/4 HANA 1610. 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. FAGLFLEXA. 0. Especially for Actual Costing. pdf), Text File (. Data Source 0FI_GL_4 , will satisfy this requirement. It will activate the Everything in InfoSource (Transfer Structure, Transfer Rules, PSA etc). 1 for our consolidation and need to extract transaction data for consolidation from S/4 system into BW, I notice that there are extractor 0FI_ACDOCA_10 can been used, but since consolidation data is YTD data we have to use some customized coding to get the YTD data, is there other extractor can achieve the. , KBA , BW-WHM-DST-TRF , Transformation , BW-WHM-MTD-CTS , Transport connection , Problem. ACDOCA is a standard General Ledger Accounting Transparent Table in SAP FI application, which stores Universal Journal Entry Line Items data. Using 0FI_ACDOCA_10/20 vs 0F_GL_10/14. 5. 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. Before using data source ,make sure they are ODP enabled otherwise you need to run one prgram to make it ODP enabled data source. Thank-You. The data flow brings SAP S/4HANA Service contracts data into your SAP BW/4HANA extending the existing data flows for SAP S/4HANA Service. SAP S/4HANA. Init without data transfer 2. Click to access the full version on SAP for Me (Login required). Step 1. 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. I have a CFIN source system (S4Hana "Universal Journal Entry"), the IT area tells us that the table to extract is the "ACDOCA". Thanks. Delta load from BW to BPC from 0FI_ACDOCA_10 (Existing Data load from PCA to BPC- Pain point). 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. SAP enhancement package 6 for SAP ERP 6. Here are some of the key features of the ODQ: Enables “extract once, deploy many” architectures for data sources. : 0FI_ACDOCA_10 – Universal Journal Entry) from. F, G, C, M, A: Line items or balance information originating from classic GL, New GL, CO, ML or AA. You can use a filter, if needed. 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. S/4: New Field "Type of a General Ledger Account" (GLACCOUNT_TYPE) for Cost Element Definition. Visit SAP Support Portal's SAP Notes and KBA Search. FINS_ACDOCA_BW_CT is a standard Information System Structure in SAP FI application. Our team is working to fix the problem as quickly as possible. Working on impact analysis of ECC based BW extractors by replacing the current CO and FI standard extractors to adapt the new extractors 0FI_ACDOCA_10 and 0FI_ACDOCA_20 for extracting data to BW. What I have seen so far is there is a paper which talks about the old approach / traditional approach of using extractor 0FI_ACDOCA_10 to connect and fetch data for BPC. 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. Characteristics. 0COSTELMNT_ATTR is Not whitelisted, will work but with some. It allows you to prepare and consolidate plan data, for example, budget and forecast, and to compare the plan data with actual data on a periodic or year-to-date basis. This is the preferred type of Profitability Analysis. The overall footprint of the JV. we are aware of DataSource 0FI_ACDOCA_10 and the CDS View I. belnr and bseg. DataStore Object (advanced): CM S/4 FI: GL. g. When you migrate to SAP S/4HANA you will be automatically switched to new asset accounting. Mapping 2. Search for additional results. 6C, note 328197 must be installed. Looks like BSEG still gets updated until you deactivate classical PCA. Hi, I am creating an aDSO for above data source on BW4HANA, write optimized. Master Data. Read the Test Script on the page above as it is a user guide in the early sections. A delta load or delta initialization using an extractor-based DataSource with time-related delta pointer fails. One can sync the Hudi table metadata to the Hive metastore as well. With GRDC Data Mapping, you can automate the mapping, transformation and data load from SAP and non-SAP systems into ACDOCU. Debit / Credit indicator incorrectly updated in ACDOCA table. I have been reading S4/HANA and how MSEG and MKPF have been simplified to MATDOC table. Extractor 0FI_ACDOCA_10 : This extractor is not having VALUETYPE field. ; Take out the function from. Visit SAP Support Portal's SAP Notes and KBA Search. gjahr = acdoca. When the structure is created first, the Line number 2 will say: #NOT_EXTENSIBLE, change. In our Project we had requirement to enhance the 0FI_ACDOCA_10 extractors in S/4 HANA (Central Finance) System. The field is used as a common currency for FI and CO. Configure and implement SAP FICO into the SAP S4 HANA. 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, 0FI_ACDOCA_20 (About RSA2_SERV_BW_CONNECTED , table rsbasidoc, often needed in the ODP scenario) 2776983 - Postings to FI-GL, FI-SL, EC-PCA: Unnecessary selects on ROOSPRMSC and ROOSPRMSF (2) Extractor 0FI_ACDOCA_10 : This extractor is not having VALUETYPE field. 5 (BW4 to be). SAP enhancement package for SAP ERP. You have noticed that the CPUDT & CUPTM for a document saved in BKPF table is different with the timestamp saved in ACDOCA table. 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 0FI_*_4 extractors use this table for registering change data. Now table ACDOCA got a new customer field field zz1_xyz . Valuation of Foreign Currency Balance Sheet Accounts (Non Open Item Managed Accounts) or open item managed accounts you are unsure of results. " S/4 HANA Cloud S/4 HANA. Document Vs. Visit SAP Support Portal's SAP Notes and KBA Search. It contains all documents posted with the components FI, CO, MM, SD. I mainly understand it as a change to accommodate reporting. 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). About this page This is a preview of a SAP Knowledge Base Article. T003. The differences occur in append structure APPEND_EEW_ACDOC_COPA or APPEND_COPACRIT_DB (other generated structures are mentioned in note 353257). I use the general term “SAP BW” which refers to both SAP BW 7. SAP Enhancement Package 3 for SAP ERP 6. 与ACDOCA表相关的标准提取器为0FI_ACDOCA_10和0FI_ACDOCA_20。. 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. For example Finance data extractor 0FI_GL_10 is Whitelisted with S/4 HANA, this means the data source is fully supported and will work with out any restriction. b. Here, x stands for T, H, K or O. Thanks a lot Nathan, Material ledger is already integrated in ACDOCA in SFIN 3. But why use COPA still at all - I see nowhere that the documentation or any blog explains the benefit of continuing with COPA. Click more to access the full version on SAP for Me (Login required). I have a question. We have newly. Click more to access the full version on SAP for Me (Login required). ) field in the FB03 screen? I know where is BKPF-XBLNR is and where is XREF1. The symptom materializes in dS/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAW) - /IMO/FI_IS401. 0 using the extractor 0FI_ACDOCA_10. Visit SAP Support Portal's SAP Notes and KBA Search. - After S4 conversion will FAGLFLEXA still be used for any purpose? - After conversion the new table ACDOCA will be used in place of FAGLFLEXA. Enter a prefix for your service and model names, for example Z and enter a valid package and choose Enter . Hi, Yes, I think so. hudi") . The table (with partiti. In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here. 5/BW4) we are using S4/HANA 1809 and BW7. Enter the relevant system alias. Add a Comment. Status – Implementation complete. I am implementing Inventory management on BW 7. Hello experts, It is commonly understood that the (yellow) key fields of FAGLFLEXT must also be key fields in the DSO on the BI side, so that totals are not overwritten. Entered at - CPUTM. . Search for additional results. Umfassender Buchungsbeleg. Extractor 0FI_GL_10: This extractor is having VALUETYPE field but it has only 10 (Actual Data). G/L account and cost element have been merged into single field ACDOCA-RACCT. 4 ; SAP S/4HANA Finance 1605 ; SAP Simple Finance add-on 1. Replacing these tables with views with the same names ensures the continuation of all read accesses to the tables mentioned. SAP BW/4HANA 1. Extractor 0FI_ACDOCA_20: This extractor is having VALUETYPE field but it has only 10. As part of it, the financial related data is extracted (e. GoTo Schedule tab and start the extraction. This InfoSource is based on DataSource 0FI_GL_14. Hi SAP, If. The extractor is available in BW system with the old way of data extraction. 0fi-acdoca-10. Data Extraction from ACDOCA and ACDOCP - missing field "Planning VERSION". The concept of the Universal Journal in SAP emerges with the first launch of SAP S/4 HANA Finance. ACDOCA_M_EXTRACT. DataSource 0FI_ACDOCA_20 no extraction of ACDOCA-WSL. When we extracted. Delta extraction or initialization of delta. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. Now your company wants to see how much was spent on papers, cartridges, copier, markers and etc. Example: A remote client copy is performed. I researched and found two possible standard extractors: 0FI_ACDOCA_10 and 0I_GLACCOUNTLINEITEMRAWDATA. Here you have 3 options – Person, Organization and Group. This InfoSource is based on DataSource Raw Data of G/L Account Line Item (0I_GLACCOUNTLINEITEMRAWDATA). 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. Please save your work. Symptom. Select the variant and click on execute. As a consequence the extracted records have all key figures multiplied. Data Hub is the new SAP solution to build big data warehousing scenarios. For example, BW and BODS can extract from the same delta queue (ODQ) of the extractor. 5 Table ACDOCA and Finance DataSources Unlike logistics DataSources, there is no need for a setup table to do a historical data load here. Working with Group Currency in SAP S/4HANA. Project-based training gives a real-time replica experience for the best learning. In an InfoPackage with Delta upload, enter the selection for actual data (0VTYPE = 010). If the system prompts you to specify a package, specify a custom package (your own transportable package). For assets the objectname = 'ANLAGENNR'. Now, if a commit occurs in “Do something” you’ll get an invalid cursor dump – this time it’s SAPSQL_SQLS_INVALID_CURSOR. Config guide 2JX will explain how to import the model on 2EB page above. We have posting to different GL accounts in a single document. Ramky Prabhakar. Check SM50 on R/3 side to track. We have newly configured the flow with 0FI_ACDOCA_10 Datasource and replicated to BW. 0, version for SAP HANA. To reduce the number of overlapping delta records, the safety intervals for the extractor can be adapted. 0, version for SAP HANA. 01 and 2021. Config guide 2JV will explain how to import the S4 data. This means that all company codes in the same client will have the same group currency. Plan consolidation works in conjunction with SAP Analytics Cloud. Mapping 1. You can see the 0FI_ACDOCA_10 and 0FI_ACDOCA_20 DataSources in Figure 4. SAP. . 3)Now schedule the infopackage and monitor the status. General Ledger Accounting: Transaction Figures. We would like to show you a description here but the site won’t allow us. This blog provides some background information about the postings made during conversion and references additional notes for more detailed information. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Journal Entry Extension "Classic" Coding Block extensions using the OXK3 transaction and the CI_COBL structure. There is a strange behavior in the release GL data task from data monitor, while triggering this step for 2021. 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. Hive Metastore. Customer. General Ledger: Balances, Leading Ledger. 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. Enter the function modules as below. delta process in RSA2 mentions "via delta queue") missed some delta records that belong to a specific time range. 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. About this page This is a preview of a SAP Knowledge Base Article. If it did not stopped i could not make enhancement to append ACDOCA internal table. A delta load or delta initialization using an extractor-based DataSource with time-related delta pointer fails. Description. I know that these datasources use AIE as delta mode. The Release from Universal Journal task helps to release the reported financial data from the universal journal for consolidation purposes. BALANCE. And for Income Statement GL Accounts we should be getting periodic postings as it happens in S4HANA. Refer to attached file on LnItm 000001 and 000002, both posted to GL 11114012 for Offsetting account 62950600. how to updat1 Answer. A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!Let’s learn on new changes in SAP Controlling module, from ECC to S/4 HANA. Diese Data Source extrahiert Datensätze zu umfassender Buchungsbelegen. RSS Feed. : 0FI_ACDOCA_10 – Universal Journal Entry) from S/4HANA system and it is fed into a standard/custom ADSO in BW system. In cases, in which big data volumes with a frequent changes are expected, e. Enter the InfoSource and Source System ID. If you see below screenshot, Transaction code is FD01. Marc covered the “big data warehousing” scenario and how Data Hub relates to BW/4HANA. 2. I researched and found two possible standard extractors: 0FI_ACDOCA_10 and 0I_GLACCOUNTLINEITEMRAWDATA. Terms of use Legal Disclosure DataSource 0FI_ACDOCA_10. g. Environment. The Universal Journal Entry Line Items (ACDOCA) table has become the primary source for this data within SAP ERP. 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. We are using BPC 10. In this case the following code will work properly: *XDIM_MEMBERSET ACCOUNT=PL110 //EXP ACCTYPE *XDIM_MEMBERSET. About Currency Types . 0FI_ACDOCA_10 Extractor Enhancement for BW extraction | SAP Community Relevancy Factor: 2. I think for COPA Extractor there is some filtering applied for few of the cost elements. All my FI reports were well managed by 10 and 14. : 0FI_ACDOCA_10 – Universal Journal Entry) from S/4HANA system and it is fed into a standard/custom ADSO in BW system. 留在家中安全:). Consider that not only the ACDOCA table is extended. . Safety interval is mandatory to FI-CO extractors, the underlying reason is FI-CO extraction rely on timestamp. Then you need to right-click the system and choose: New -> InfoObject…. 0FIS_GL_LINEITEM. to the ACDOCA extractors. 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. With document splitting you are able to break down the 5000 p. KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problemsap acdoca table fieldssalon suites for rent in dc. pdf - Free download as PDF File (. in a new build BW/4HANA 2021 SP03 we decided to extract data via 0FI_ACDOCA_10 and a generic extractor based on ACDOCP. The number of days the data stored here depends on the setting in the bwom_settings table. Using 0FI_ACDOCA_10/20 vs 0F_GL_10/14 - SAP Q&A Relevancy Factor: 1. Now how this new table will impact our extractors. The FI Line Item Browsers – Part 3 – Additional Fields from Base and Master Data Tables. Data Hub is the new SAP solution to build big data warehousing scenarios. Description: General Ledger: Leading Ledger Balances. A whole new Dataflow for the SAP S/4HANA Service area as depicted here. . 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. g. I am trying to create an external file in hive metastore, using apache hudi framework. Please suggest how could i insert line items in ACDOCA. 如有任何疑问,请通知我。. Now we created another source system connection with OPD (SAPI). Understood. Enter the InfoPackage description, select the Data Source and click Save. In BW, the delta extraction for 0FI_GL_4 from the source system can be loaded as per the processchain or infopackage schedule but where as,. The field MIG_SOURCE is not availiable in datasource 0FI_ACDOCA_20. 有几个地方仍不理解. About this page This is a preview of a SAP Knowledge Base Article. If you click on it, this will take you to transaction Code BP. 196 Views. Double click on the data Source and the field is not there in selections. SAP Support. Simplified and lean Data model using minimal BW objects like ADSO and composite providers and field based modeling/info-objects. Plan data can be transferred using a different InfoPackage in full upload. Of course, we can do it, but the question is - is the extra step worth the effort. The extractor does not transfer any redundant fields to BW. 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. 0FI_ACDOCA_10, delta, missing, fields , KBA , BW-BCT-FI-GL , BW only - General Ledger , How To . However, the key field Ref. Closing/Consolidation team can save. Full load 3. Hi All, I have one doubt regarding Generic DS Delta Properties Will Generic DS with delta type as numeric pointer gives changed records or only new records. 我们正在使用0FI_ACDOCA_10。. Datasource Type: Transaction Data Extractor. Execute Program BS_ANLY_DS_RELEASE_ODP. Use. 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. It is called “Global currency for FI and CO”. Using an editor you can flexibly. We are BW4HANA system. I am having an issue where Hudi does not update the hive metastore with new schema changes in AWS Glue Catalog. For example Finance data extractor 0FI_GL_10 is Whitelisted with S/4 HANA, this means the data source is fully supported and will work with out any restriction. ACDOCA step by step document required. Source System of BW system. 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. Based on my understanding the below Business Content Extractors pull from FAGLFLEXT and. 0FI_ACDOCA_10. Edit with transaction OBA7. Open The Update Tab and select the Full Load Radio Button and start the extraction from schedule tab. Sales order document is in reference to the Outbound Delivery. FAGLFLEXT where as 0FI_GL_14 is used to fetch Line item table info i. Hello everyone, When SAP launched S/4HANA, there were changes to unify the source of information for accounting documents. 5289 Views Last edit Jan 27, 2020 at 05:38 AM 2 rev. For this, SAP at year end writes initial Balance postings in the Universal Journal Table ACDOCA but with "Period 0 - zero (ACDOCA-POPER = 0)". DataStore object (advanced): FI-GL: New GL Leading Ledger - Balances (0FI_GL_12) - /IMO/CMFIGL12. BW DATASOURCE Description Application; 1 : 0FI_GL_14: General Ledger (New): Line Items Leading Ledger FI - General Ledger Accounting: 2 : 0GLACCEXT_T011_HIER这样一个集成的信息源,就能生成各式各样的报表:固定资产,库存,应收应付,利润,销售成本cogs),资产负债表,损益表. Request loaded from 0FI_ACDOCA_10 are highlighted. In the transaction RSA5, select the DataSource (s) and click Activate Data Sources. This means that only fields that are relevant for the general ledger are transferred from the Financial Accounting document (BKPF and BSEG tables). Source System of BW system; SAP R/3; SAP R/3 Enterprise; SAP ERP Central Component; SAP ERP; SAP enhancement package for SAP ERP; SAP enhancement package for SAP ERP, version for SAP HANA Page Not Found | SAP Help Portal. 0; SAP NetWeaver; SAP ERP; SAP ERP Central Component; SAP enhancement package for SAP ERP; SAP enhancement package for SAP ERP, version for SAP HANA0FI_GL_04 extraction out of ACDOCA (to BW7. 43 in NUMC is 0043. 0: 2142781 - DataSources 0FI_GL_12, 0SEM_BCS_12 and related ones are not updating delta queue. 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. SAP ERP Central Component. Scenario 4: Extracting in delta mode from SAP TM (Transportation Management) DataSources. Understood.