This is a preview of a SAP Knowledge Base Article. Click to access the full version on SAP for Me (Login required). FAGLL03 report terminates with a dump TSV_TNEW_PAGE_ALLOC_FAILED. The report runs for a single day, for a single company code and for a single GL account. Memory settings are taken care of as per the KBA 2180736. 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. allow me to see the value of BSEG_BELNR, however the CHANGING parameter will not allow for modification of BSEG_SGTXT. I am able to write a standalone program to update already posted docs and schedule a batch job, but I prefer a more real-time update, if I cannot update BSEG_SGTXT with BSEG_BELNR before posting document then This is a preview of a SAP Knowledge Base Article. Click to access the full version on SAP for Me (Login required). Local and second local currency (group currency) amounts are not getting updated when posting via FBB1 even though customizing is correct in FINSC_LEDGER / OB22 respectively. This is important, because JOINs between two tables will always have duplicate field. So SELECT * doesn't work. And it's a bad practice anyway. You almost never need all the fields, so SELECT * is almost always a waste of memory and CPU cycles. Take both SELECTs and prefix every column name with the table. The DataSource uses the delta method to transfer each new status of the changed line item. For this reason, it is not possible to update the InfoCube directly. The InfoCube can only be deleted via the DataStore object (update with MOVE). The delta method works with a lower safety interval of an hour (standard setting). 7 12 19,310. 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. ACDOCA – It is the universal journal table unifying the elements for Accounting. ACDOCP – This table was introduced in S/4 HANA 1610 ACDOCT is a Compatibility View on ACDOCA that can be used in Report Writer/Painter. Just like the Compatibility Views FAGLFLEXT and GLT0, it has a Balance Carryforward field that gets populated from the Period 0 postings on ACDOCA, to make it easy to report on the carryforward balance with the reporting tools. 3. NJ8P.