We can see that the view apparently recursively accesses the COEP table and other tables like the ACDOCA. The UNION statement indicates that part of the data records are from COEP and the rest from ACDOCA and the other tables. 2.2 Where is what. To find out where the data are, let’s try to use our well-known board tools like transaction SE16h. In the integrated scenario, where the consolidation units receive the reported financial data via the ‘Release from Universal Journal’ task from the Universal Journal Table (ACDOCA), the full granularity of data is available in the ACDOCA records (including the additional characteristics) can be taken over into the Group Reporting journals There can be differences between the aggregated line items and the old totals tables, e.g. due to data archiving of line items. Published Financial statements in the past were based on totals reporting; therefore, these differences need to be corrected by additional line items in ACDOCA in the migration of balances step. Jul 28, 2010 at 07:22 AM. Please note the overall document postings will be consistent between BSEG and FAGLFLEXA. The difference is that there may be many lines in FAGLFLEXA for a single line in BSEG due to the document splitting. One of the benefits of the new GL is enhanced reporting - i.e. a full trial balance by a profit center. and the Other 2 items have material (ABC) and Profit center (PQR6789). Now these appear in Bseg as only 2 items, all the items with similar materials, profit center etc will be clubbed in Bseg (While Accounting). I.e In BSEG you will only find 2 entries for the above 4 items of VBRP. I need to divide the data that I am getting from BSEG exactly check theses links u may get an idea abt relationship.and might be somewht helpful to u. Sana. connect vbak & bseg using kna1-kunnr. ie. vbak inner join kna1 on vbak kunnr = kna1 kunnr. bseg inner join kna1 on bseg kunnr = kna1 kunnr. u can't link directly. instead u can do by linking vbak to bkpf. den bkpf to bseg. I am going to make GL Pay service Tax Report. i wnt to make report selection from FAGLFLEXT-RACCT. (GL Account number) and Fetch data from BKPF, BSEG, SKAT table. So Please Guide me about hw to make Relationship from FAGLFLEXT-RACCT. to BKPF and BSEG Table. The Foll code for fetch data. FORM data_retrieval. SELECT * FROM FAGLFLEXT INTO TABLE IT Going through all of it also made me shift my question from linking EKPO and BSEG to linking EKPO-EBELP and the G/L accounts. The BSEG-HKONT (with filter to BSEG-KOART = 'S') are also in EKKN-SAKTO. SELECT ebeln, ebelp, netwr, sakto, vproz, vproz * netwr / 100 AS sakto_netwr FROM ekpo LEFT JOIN ( SELECT mandt ,ebeln ,ebelp ,sakto ,SUM (vproz .

difference between bseg and acdoca