The Universal Journal, in essence, is a book of original entries on corporate transactions in Controlling (CO) and Financial Accounting (FI). "Delta management can take the lower limit from the last extraction. About this page This is a preview of a SAP Knowledge Base Article. 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. 0 or S/4 HANA Nov release. . Group. 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. This DataSource extracts Accounts Payable Accounting line items from tables BSIK (open items) and BSAK (cleared items) in the R/3 source system. I realized there is a field named "Offsetting Account" in table ACDOCA. Field name ACDOC_COPA_EEW_DUMMY_PA is longer than 16 characters. png. 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. data using Tcode : RSA3 for. Step 3. Sales order document is in reference to the Outbound Delivery. 0/ODBC6. in a new build BW/4HANA 2021 SP03 we decided to extract data via 0FI_ACDOCA_10 and a generic extractor based on ACDOCP. txt) or read online for free. Coding Block has to be added in the. Edited by: Venky1903 on Jul 16, 2011 6:15 AM. Monitor the extraction. Initially, I set up a flow run in incremental loading mode without any filters. 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,. Hi, You can assign a CHAR to a NUMC as long as it has a NUMC format, that is only numbers with a specific lenght, i. 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. 1. Dec 04, 2013 at 11:06 PM. Go to the update tab and. 29– 2023-05-25 PUBLIC Simplification List for SAP S/4HANA 2022 Initial Shipment, Feature Pack Stack 1 & 2Hi I have below requirement where I need to get the cumulative Balance for the periods where we dont have data in SAP ACDOCA table. Hi Bramhananda Reddy Koosam, ACDOCA table related standard extractors are 0FI_ACDOCA_10 & 0FI_ACDOCA_20 . The new content combines the capabilities of SAP HANA and SAP BW/4HANA for the most optimal solution. (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. × []SAP Help PortalHere is the BAPI is filled with the same information: click on Save. 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. This InfoSource contains the structure to provide GL Account line item data into the Integrated DWH Layer. 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). DataSource 0FI_ACDOCA_10 did not extract some documents from ACDOCA table during the initialization. Data Extraction from ACDOCA and ACDOCP - missing field "Planning VERSION". Thank-You. The content was built around the Layered Scalable Architecture (LSA) approach. It provides two main features. This table covers field in General Ledger Accounting (FI-GL), Asset Accounting (FI-AA), Profitability Analysis (CO-PA) and the Material Ledger (CO-PC-ACT). - After S4 conversion will FAGLFLEXA still be used for any purpose? - After conversion the new table ACDOCA will be used in place of FAGLFLEXA. The business transactions relevant for Financial Accounting are entered, saved, and evaluated at company code level. We got the existing Interface view “I_GLAccountLineItemRawData” consuming data from ACDOCA which satisfied our requirement. m. SAP BW/4HANA 1. top selling product by. I know that these datasources use AIE as delta mode. Customer. InfoSources. Environment. You may choose to manage your own preferences. Q: For example if I can filly leverage 0FI-ACDOCA_10 I can throw all the FI/CO extrcators you shared in this slide. I have a CFIN source system (S4Hana "Universal Journal Entry"), the IT area tells us that the table to extract is the "ACDOCA". System must add buffer to timestamp because of the document saving time consuming. 3 Answers. g. have its own benefits and Value Addition. ACDOCA is a standard General Ledger Accounting Transparent Table in SAP FI application, which stores Universal Journal Entry Line Items data. In this case if you have set the lower limit to 1, the delta run of Thrusday will fetch data from Sunday till Thursday. Add a Comment. ACDOCA-MIG_DOCLN table field - Item ID of migrated G/L line item . It is called “Global currency for FI and CO”. We have posting to different GL accounts in a single document. The rest api expects Graphql query, she asked me to check code view in postman and the issue was found. You have noticed that the CPUDT & CUPTM for a document saved in BKPF table is different with the timestamp saved in ACDOCA table. The level of granularity coming from Universal Journal. SAP Help Portal | SAP Help Portal. The most important attributes of business entities are included, such as group G/L account or cost center responsible. But let us understand this with some real time scenario. Cookie Statement | Powered by: Gaurav Agarwal . You have noticed that the CPUDT & CUPTM for a document saved in BKPF table is different with the timestamp saved in ACDOCA table. R. The Structure ZAFINS_ACDOCA_BW is created for single field ZZNETDT. You should also consider using the new datasource 0FI_ACDOCA_10 to extract the complete universal journal to SAP BW, where BW runs as a dedicated data warehouse, rather than in embedded mode. S4CORE. Closing/Consolidation team can save. ) ? please see the BW4 BCT documentation at. SAP S/4HANA. 5. 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. For more information, see SAP Notes 1476708. I am implementing Inventory management on BW 7. From the 865 live DS’s, 278 DS’s (865 – 587 (Whitelisted)) could be. 0FIS_GL_LINEITEM. When we extracted. In the subsequent screen, double-click the Currency Types folder, which will take you to the screen shown here. Scenario 3: Extracting from FI (Financial) DataSources. It comprises the journal entries brought about by these types of transactions and, therefore, represents a primary source of information on SAP S/4HANA. Can we use same functionality in customized real time infocube in S/4 premise. All my FI reports were well managed by 10 and 14. DataStore Object (advanced): CM S/4 FI: GL Account Line Item. Step 5 ACE: Migrate accrual postings. 2) What are the Pros and Cons in using ODP-CDS compared to ODP-SAP (e. Possible scenarios are. Field "Due date for net payment" (NETDT) is not update in ACDOCA. 2713775 FI_DOCUMENT_CHANGE is not updating ACDOCA. 4 ; SAP S/4HANA Finance 1605 ; SAP Simple Finance add-on 1. 总账标记： 如果F-02记账抬头凭证状态为U. The field MIG_SOURCE is not availiable in datasource 0FI_ACDOCA_20. Enter the relevant system alias. Since the client is moving to a new S/4HANA system, and the document splitting option is enabled in the 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. There is a strange behavior in the release GL data task from data monitor, while triggering this step for 2021. SAP Data Warehouse Cloud - First Guidance_ Data Integration for ABAP Source Systems - Free download as PDF File (. It contains all the totals records (transaction figures) from new General Ledger Accounting that were uploaded from the connected source system (s) using the InfoSource General Ledger (New): Transaction Figures . As part of it, the financial related data is extracted (e. Press the 'Refresh' button to the right of 'Metadata' section. About this page This is a preview of a SAP Knowledge Base Article. Even using an S/4 Hana system you can still view further. But why use COPA still at all - I see nowhere that the documentation or any blog explains the benefit of continuing with COPA. Press the button to proceed. Data Source 0FI_GL_4 , will satisfy this requirement. 0. ShipmentHi, We are extracting data using Azure CDC connector to Azure Data Factory (Blob). SAP_FIN. CLASS-METHODS: get_acdoca FOR TABLE. Configure and implement SAP FICO into the SAP S4 HANA. 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. 0FI_ACDOCA_10 Extractor Enhancement for BW extraction | SAP Community Relevancy Factor: 2. 0fi-acdoca-10. ACDOCA) across systems regarding CO-PA related characteristics. This means that all company codes in the same client will have the same group currency. And the corresponding fields are: 00 : ACDOCA-TSL (basic currency type) 10 : ACDOCA-HSL (Free defined Currency 1) 30 : ACDOCA-KSL (Free defined Currency 2) 50: ACDOCA-OSL (Free defined Currency 3) The code is as below: METHOD. Terms of use Legal Disclosure The field MIG_SOURCE is not availiable in datasource 0FI_ACDOCA_20In many companies, BW system is being used for financial month-end closing requirements. Here are some of the key features of the ODQ: Enables “extract once, deploy many” architectures for data sources. Sample 2: We have data in EXP account in PERIODIC model Planning and we want to convert this data to YTD and store result in the same EXP account of the different YTD model PlanYTD. Nextkeyboard_arrow_right. Hi SAP, If any one have ACDOCA s/4 HANA how to update step by step documents please provide me it useful. MIG_SOURCE not available in datasource 0FI_ACDOCA_20. In our design we are using standard ECC datasource 0FI_GL_12 ( New GL : Balances of Leading Ledger ). However, the well known "Controlling"-Fields, such as VERSION, VTYPE, MEASTYPE, VTDETAIL, VTSTAT etc. writeStream . Diagnosis. In BW there are scenarios where you have to enhance an existing Datasource with one or more fields and program a logic to fill those fields in or change the extraction in any other way. keyboard_arrow_leftPrevious. For assets the objectname = 'ANLAGENNR'. ACDOCP – This table was introduced in S/4 HANA 1610. Here is what SAP says with respect to your query. But which is the best or have added the Maximum. 最. Unified configuration of monitoring for all provider and subscriber types. With document splitting you are able to break down the 5000 p. 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. In PowerCenter, the . Then save & run the task. 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. General Ledger is nothing but an Account, as a sub Module it covers all the Accounts used. This can be done in several ways. It is a standard daa source as i found it in RSA5 in ECC. format ("org. Performance enhancements might be available for data extraction. Please check the initialization with restrictions on some fields to limit the amount of data. Note: Your browser does not support JavaScript or it is turned off. A delta load or delta initialization using an extractor-based DataSource with time-related delta pointer fails. 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. hudi") . About this page This is a preview of a SAP Knowledge Base Article. 5. More Information. Delta Process: After Images with Deletion Flag Via Delta Queue (Like BtB. I am trying to create an external file in hive metastore, using apache hudi framework. 3. Fiori vs LTMC vs ACDOCA – Benefits, Value addition Comparision. In this OSS note the current status is described how to activate the delta queues after migration to sFin 2. This blog post will focus on the streaming process chain run modes and provides URLs to additional sources in the end. Here, x stands for T, H, K or O. Extractor 0FI_ACDOCA_20: This extractor is having VALUETYPE field but it has only 10 (Actual Data). Based on my understanding the below Business Content Extractors pull from FAGLFLEXT and. Relevancy Factor: 320. Hello, I'm trying to use 0FI_ACDOCA_10 data source to extract data from ACDOCA table. 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). Extractor 0FI_GL_10: This extractor is having VALUETYPE field but it has only 10 (Actual Data). TRF doesn't contain master data lookup rule. Arkadiusz Drużynin. SAP NetWeaver 7. Click to access the full version on SAP for Me (Login required). Pratyaksh Jeet. Thank you Isabel. . b. You expect that ACDOCA-GKONT is filled in every cases, but some for some of the documents it is missing. Tried SE14. It lists all CDS extractors with two filter. 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”. Tried appending the z fields in CI_COBL custom include. 5 and SAP BW/4HANA (any release). Also, evaluated Pros and Cons of 0FI_ACDOCA_10 vs 0FI_ACDOCA_20. Below are the steps you need to follow: Go to RSA6 >> select the desired datasource >> In the top there is a tab Enhance Extract Structure >> Click on it. RSS Feed. #saphanamigration #pradeephota #sapsimplefinancetrainingLearn SAP S/4HANA Migration Process with Technical aspect with Sum tools, CDS Views, ACDOCA concept a. 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. . 2> 3FI_GL_xx_SI General Ledger Accounting (New): Line Items of Any Ledger (FAGLFLEXA table) Through this Data Source, you may extract line items from a particular ledger to the new General Ledger Accounting. External services are maintained in purchasing documents in service lines below the item level. But control did not stopped there. Not sure about 12, I think it is infosource only used for balances. e. The Structure ZAFINS_ACDOCA_BW is created for single field ZZNETDT. html>kftgz. The problem is that when we extract INIT load. 0fi Gl 14 Acdoca Database Tables in SAP (31 Tables)Operational Delta Queue is a physical Queue (T-Code: ODQMON), present in the source system. 我们使用0fi_acdoca_10数据源新配置了该流，并将其复制到bw。 我们正在使用odp机制从s4提取数据。 问题是当我们提取init负载时。 它成功提取了数据。 我们已请求用户更改一些交易并尝试使用增量，但未提取任何记录。Hi, are we going to have standard content based on 0fi_acdoca_10/20 for FI and CO. During the month-end. We would like to show you a description here but the site won’t allow us. As per OSS note 2341038, I was trying to understand how to remap the 0FI_GL_ extractors like 0FL_GL_10/14 . Enter the InfoSource and Source System ID. Replacing these tables with views with the same names ensures the continuation of all read accesses to the tables mentioned. 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. Init without data transfer 2. Besides for the basis currency type 00, this company has 3 other currency types: 10, 30, 50. Hi Ratul, Thanks again. For example, for 0FI_GL_04 we need BSEG table, which is still in S4/HANA, but not storing all the data. 5 7 53,730. InfoSource 0FI_AR_4 replaces InfoSource 0FI_AR_3. General Ledger. Consider that not only the ACDOCA table is extended. Search for additional results. Read more. Mapping 2. However, the well known "Controlling"-Fields, such as VERSION, VTYPE, MEASTYPE, VTDETAIL, VTSTAT etc. I have a CFIN source system (S4Hana "Universal Journal Entry"), the IT area tells us that the table to extract is the "ACDOCA". 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. They have no relevance for the SAP BW∕4HANA runtime. ODQMON stores data in compressed format and is also a replacement of traditional PSA. I need to build a data model on top of 0FI_AR_30 which is Account Receivables. RFINDEX report to find Inxed based inconsistencies in system. 5 and noticed few things. It serves as a Repository of Business Transaction which has an Accounting Impact. Search for additional results. Create a BAdI Implementation for Flow Builder Plus. 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. Click to access the full version on SAP for Me (Login required). Enter the InfoPackage description, select the Data Source and click Save. Hello, we are using datasource 0FI_ACDOCA_10 and exposed it via SEGW/oData as described here. Its able to connect with hive metastore but throws exception after the connection when trying to create table. Step 3: Create Class to consume CDS View. In this case, activate the DataSource using transaction RSA5, by following the steps given below. It is replacement of traditional RSA7 Delta Queue. 1. Step 2. 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. This maps to COEP-KSTAR, BSEG-KSTAR and FAGLFLEXA-COST_ELEM. BSEG Field mapping in table ACDOCA in S/4 HANA. 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. I have datasource 0FI_ACDOCA_10 and an ADSO already available in BW. to the ACDOCA extractors. 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. Run report RFINDEX on a regular basis to check inconsistency in your systems. TCode: RSA6 –> Select data source 0FI_GL_10 –> Double click to see the details of the data source. pdf), Text File (. We are facing some range of GL account defined in 2 different nodes according to it's balance (debit/credit). need to understand from base source how to take in ACDOCA field for update and journal & reports. Now your company wants to see how much was spent on papers, cartridges, copier, markers and etc. 与ACDOCA表相关的标准提取器为0FI_ACDOCA_10和0FI_ACDOCA_20。. It is requested, purchased, recorded, and invoiced via External Services Management. I want to activate the Standard Content in BI and load data in it. As part of it, the financial related data is extracted (e. Visit. With the Group Reporting Preparation Ledger, you can turn an existing accounting ledger into a group reporting preparation ledger. Hi Nawa, I tried the way you suggested. From BI we need to push Accumulated Balance to BPC for consolidation balancesheet report. 7 12 18,781. 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. ACDOCA-SDM_VERSION table field - SDM: Version field for ACDOCA . 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. 01, the program is pulling ACDOCA data for all FY 2021 (in this specific example, GL data for periods 2021. This blog provides some background information about the postings made during conversion and references additional notes for more detailed information. e. I want to activate the Standard Content in BI and load data in it. Changed On - AEDAT. You may choose to manage your own preferences. This means, if you still use classical PCA, Profit Center Accounting in the universal jour 0FI_ACDOCA_10 Extractor Enhancement for BW extraction. The note contains the list of BW extractors which are fully supported, Partially supported and obsolete with S/4 HANA. It will activate the Everything in InfoSource (Transfer Structure, Transfer Rules, PSA etc). The symptom materializes in dS/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAW) - /IMO/FI_IS401. 5 (BW4 to be). The corresponding flag to distinguish between statistical and real postings can be seen in App “Cost Center - Plan/Actual”. 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. "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Our environment is BW4HANA (SP5) with S4HANA (1709). Units field RIUNIT for field LBKUM of DataSource 0FI_ACDOCA_10 is hidden. You can extend many processes that lead to journal entries in the ACDOCA table. Even if LIS 03 data sources are active in LBWE, the material document collection(SM13 or LBWQ) doesn’t start until a delta is initialed on the data sources(BF or BX). For BW side we extract these tables through different extractors for Master data and Transaction. Uploaded By madysjayanth. Hi, The header table of ACDOCA is BKPF. In our Project we had requirement to enhance the 0FI_ACDOCA_10 extractors in S/4 HANA (Central Finance) System. This includes advanced business processes such as Margin Analysis, New Bank Accounting, New Asset Accounting, Universal Allocation and much more. to replace old finance DataSources. Search for additional results. List of changed documents with the change date and the document number which helps in the delta extraction. As per your requirement ,you can use any data source from listed above and get data into your BW4/hana targeted object. Please find an example setup of the InfoProvider for the actuals data below. FAGLFLEXA. Request loaded from 0FI_ACDOCA_10 are highlighted. 1) If we go for ODP-CDS option, are there any standard CDS view providing the same data as above datasources. Visit SAP Support Portal's SAP Notes and KBA Search. 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. Follow. Refer to attached file on LnItm 000001 and 000002, both posted to GL 11114012 for Offsetting account 62950600. I need to build a data model on top of 0FI_AR_30 which is Account Receivables. . There is a high-level list of all CDS extractors in each SAP S/4HANA system starting from releases in 2020. Visit SAP Support Portal's SAP Notes and KBA Search. However, TDF did. As promised in part one, let’s have a closer look at the delta handling in CDS based extraction. 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. Extractor 0FI_ACDOCA_20: This extractor is having VALUETYPE field but it has only 10. Then you need to right-click the system and choose: New -> InfoObject…. SAP ERP. What does FDOCA stand for?School planning and reporting; Location and transport; Enrolment; Financial contributions and assistance; Our staff; Rules and policies; What we offer; Local AreaIn order to work with 0FI_ACDOCA_10 you have to setup a DSO with overwrite mode (to process also document changes, clearings and reversals correctly) with the key fields as shown below. 0COSTELMNT_ATTR is Not whitelisted, will work but with some. This DSO is updated by the InfoSource FI-GL: Line Items (0FI_GL_14) ( /IMO/FIGL_IS14 ). 0FI_ACDOCA_10, delta, missing, fields , KBA , BW-BCT-FI-GL , BW only - General Ledger , How To . Now how this new table will impact our extractors. Just another site4 The amount of data is mainly the number of lines, times the number of columns, times the memory consumption of the data type of the specific column. Con este curso de 0fi_acdoca_10 comprenderás las características y los conceptos de los diferentes módulos de SAP您好 Bramhananda Reddy Koosam ，. 0 to SAP S / 4, the standard table structure has changed significantly. We would like to extract data all data from ACDOCA table to BW and wanted to share the same for SAC usage. ROOSFIELD. The Universal Journal (= database table ACDOCA) is the “single source of truth” for all accounting data. You may choose to manage your own preferences. 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. The overall footprint of the JV. To summarise this example, the client has 865 live DS’s that extract data from ECC into BW. I researched and found two possible standard extractors: 0FI_ACDOCA_10 and 0I_GLACCOUNTLINEITEMRAWDATA. , as it seems during clearing this field is grayed out and same as clearing date, it seems not possible to change it in standard. SAP Library - General Ledger Accounting (FI-GL) (New) General Ledger Accounting (FI-GL) (New) Configuration of General Ledger Accounting. g. We are loading Actuals Data from S4HANA to B4HANA 2. 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. Click Display. 0 1. " S/4 HANA Cloud S/4 HANA. 1 folder for ODBC connectivity purposes. pdf - Free download as PDF File (. In addition, you can define and derive your own business transaction types. Example: A remote client copy is performed. I have the following queries: Jan 27, 2020 at 04:24 PM. 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. Choose Add Service . A whole new Dataflow for the SAP S/4HANA Service area as depicted here. g. After Images Marked for Deletion via Extractor (FI-GL/AP/AR) The DataSource uses the delta method to transfer each new status of the changed line item. ACDOCA is a standard General Ledger Accounting Transparent Table in SAP FI application, which stores Universal Journal Entry Line Items data. NUMC 4 is from 0000 to 9999. BWFI_AEDAT. If the system prompts you to specify a package, specify a custom package (your own transportable package). rbukrs = bseg. I have a question. This InfoSource contains the structure to provide new general ledger line item data to the Integrated DWH Layer. Most important ABAP Function Modules for Acdoca Update. InfoProvider for actuals data. GRDC is an app to help you collect financial data, non-financials and comments into SAP S/4HANA for group reporting – in the ACDOCU consolidation table. But still Fiori will have edge. We are having an requirement to display ECC Accumulated Balance data in BI. This will open pop-up screen, where you define your InfoObject. "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. We will create Global Class and handle method to get data from CDS View which was created in step 1. 6C, note 328197 must be installed. odbc. Click more to access the full version on SAP for Me (Login required). 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. After a few seconds, OData Version and Action name should be displayed under 'Metadata' section, as it shown on my screenshot. Now for any Balance Sheet item, we are getting Periodic Numbers in BPC Planning model. S/4 FI: GL Account Line Item (0I_GLACCOUNTLINEITEMRAW) - /IMO/FI_IS401. 0FI_ACDOCA_10 extracts line items only so it corresponds more to 0FI_GL_14. Search for additional results. FI-GL: New GL Leading Ledger - Line Items (0FI_GL_14) - /IMO/FIGL_IS14. Could anyone please suggest me which Info cube, DSO, Transformations to be activated for 0FI_ACDOCA_10 data source in BI. With all of the characteristics available in the ACDOCA table, what is the benefit of continuing to use COPA, even if you use Account. Conclusion – LTMC, ACDOCA and FIORI will be used at its best. FINS_ACDOCA_BW_CT is a standard Information System Structure in SAP FI application. Introduction. with-in the SAP FI Module. FAGLFLEXA. Step1: Append the Structure of Datasource 0FI_ACDOCA_10. FINS_CURR_CHGE_NEW_PROJ_POPUP. From SAP ERP 6. 0, version for SAP HANA. We have the requirement with the data from tables BSEG and BKPF Tables. ; Take out the function from. 2561628-Message "Name of field ACDOC_COPA_EEW_DUMMY_PA is longer than 16 characters" after activating 0FI_ACDOCA_10. Marc covered the “big data warehousing” scenario and how Data Hub relates to BW/4HANA. Click more to access the full version on SAP for Me (Login required).