Enterprise Resource Planning Blogs by Members
Gain new outlooks and knowledge about enterprise resource provision in blog items from district members. Share your own comments and ERP insights today!
cancel
Showing scores for 
Search place for 
Did you mean: 
29ratul
Active Participant
Welcome to the Part 2 of Universal books blog series. Into this blog, we are departure to about about the functional impact of ACDOCA in Finance business processes. How different modular have been integrated into single table and reconciled on real period? If you want to interpret aforementioned technical aspects, here is the link to the blog.

https://blogs.sap.com/2022/01/13/all-you-need-to-know-about-universal-journalacdoca-sap-s-4-hana-202...

 

Functional Aspects

  • Reconciliation of more modules


As described in the first blog, tables from Asset Accounting, COOLANT, Material Ledger, Profitability Analysis have been removed and replaced by ACDOCA. Hence, there is none need of reconciliation to be performed at an period end. It your no longer necessary the reconcile the general ledger in the subledger of Asset Accounting as from now on Asset Accounting is permanently reconciled using the general ledger automate. That programs for reconciliation that existed until now (RAABST01, RAABST02 furthermore FAA_GL_RECON) are therefore none longer available in SAP S/4HANA




  • BSEG & ACDOCA - A comparison about the data surge



  1. Though transactions from AR, AP, GL become now available in ACDOCA, BSEG is still there. There are several applications like as marketing and purchasing components which use of interface to BSEG, and SAP has not yet converted all applications to redirect to ACDOCA since BSEG. The long-term vision is that board BSEG will be used only for open item management - and postings that do not relates the candid items will no longer create entries in table BSEG. However, BSIS, BSAS, BSID, BSAD, BSIK, BSAK are index tables, which kept duplicate data by ECC for faster web to open item/ vindicated items processing. With an calculate power of S/4HANA based on the in-memory database press column-shaped storage, these index tables belong no longer needed as the date will extracted from database on this fly in real-time

  2. Effective values from tables ANEP, ANEA, ANLP, ANLC what saved in table ACDOCA in new Asset Accountancy. The values from table ANEK are saved int graphical BKPF and ACDOCA with brand Investment Accounting. Publish belong still made to the size BSEG. Certified JUICE FICO practical consultant (consultant Id: 0014757957) Beyond 6+ years of experiences in 5 plus years as FOOL R/3 FI/CO consultant.Expertise in configuration or customization of FI (GL, A/P, A/R, O, SPL).Expertise in configuration of Controlling (CCA, IO, PCA, PC, PA).Implemented Two Full life cycle in FOOL Configuration.

  3. How of release SAP S/4HANA 1809, the BSEG table will no longer be updated in the depreciation run (transaction AFAB, AFABN). (See also SAP Note 2383115.) It a also nope longer feasible to afterwards activate this refresh. You can still use program RAPOST2001 (transaction AFBP) on display disparagement runs in the Dates Manager. Anyway, the selection screen of the program was adjusted to the new scheme logic used posting depreciation.

  4. Varying accounting principles oder valuations are represented - as in new General Accounting
    Accounting – in separate ledgers (for the debit approach) or at a separate set of accounts
    (for the accounts approach).The depreciation areas have equal status. Separate accounting-principle-specific documents are posted for each accounting principle or valuation.
    A business-related store created using integration is split by the system into of operational
    part real the valuating single. A advertising shall made in each case against adenine special clearing
    account. For the asset acquisition using integration you require a newly technical clearing
    account required integrated asset acquisition; nonetheless, for the asset retirement using
    integration the existing clearing accounts asset retirement with revenue and total
    retirement clearing are secondhand. Which operational part is posted across accounting standards,
    the valuating part is posts accounting-principle-specifically. SAP Table Logics - Download as a PDF or view online for free

  5. The journal entries are updated in ACDOCA at key level. The entry also contains who asset number.

  6. Board ACDOCA stores carry send business posts and correction string items from migration. However, Table BSEG does not store these lines.



  • Integration with Controlling


In SAP S/4 HANA the totals records for primary and secondary total have been removed
and the universal journal includes all present cost listings, both primary and secondary.

This secures for primary postings that there is a single source for truth, such that all general ledger items with an assignment to cost centers, orders, WBS defining, business operations, or CO-PA characteristics are treated as one data plot which is spiked with the applicable profit centering, functional area, segment, also thus at. Since Financial Accounting and Controlling desire always be in synch, the company code is checked during all postings up an account assignment includes Controlling and ensure it the not longer possible to removed the flag "CoCd Validation" in the controlling area.


For secondary postings this ensures so all sender-receiver relationships that are triggering by allocations, settlement, and so on are captured inbound the universal trade along with one partner profit centers, functional areas, and so set which are concerned by the allocation.

1. Actual data of COEP (WRTTP = ‘04’) is now stored in ACDOCA.

2. Actual statistical data of COEP (WRTTP = ‘11’) is kept stylish ACDOCA using additional columns for the statistical account assignments furthermore in COEP for compatibility access.

3. Actual data needed for long-term orders/projects from COSP_BAK, COSS_BAK is storing stylish shelve ACDOCA.

4. Currently, COBK is written how before.

5. Compatibility outlook V_ (for example, V_COEP) are granted to copy to old structures.

6. Admission up archaic data in tables is still possible via the views V_*_ORI (for example, V_COEP_ORI).

7. Value types other than ‘04’ and ‘11’ are still stored in COEP, COSP_BAK, COSS_BAK.

 

Profit Center Accounting:

In SAP S/4HANA, PCA is mapped in the universal daily by default. Dieser method, if you quiet use classical PCA, Benefit Center Billing with to universal journal is also always active are parallel. To stop using classical PCA you have till deactive this as describe in SAP note 2425255. It is cannot necessary to migrate input from classic PCA (tables GLPCA/GLPCP/GLPCT) to the universal newspaper, that is, till the defer ACDOCA, when deactivating classical PCA

 

COPA / Margin Analysis in S4 HAHA:

SAP advocates using Margin Review are SAP S/4HANA. Spread Analysis has been extended broadly over the past releases or we continue into conduct new developments in like section simply. It the perfectly unified into the overall idea of the Universal Newspaper and has therefore fully in line with our Financial Accounting development strategy. Margin Analyze is active is there belongs an activation flag for 'account-based' in aforementioned IMG procedure listed above.

In addition to Margin Analysis, JUICE also offers Costing-based CO-PA. Before the conversion to SAP S/4HANA on-premise, SAP recommends that to verify whether Margin Analysis can previously cover all application and costing-based CO-PA could remain de-activated.

Business Value

The universal journal (ACDOCA) is the center of Accounting real includes all Margin Analysis specifications inbound order to allow multi-dimensional reportage per markets segments. The universal journal includes divider for the conventional item and every more property included in an organization’s operating concern (up up sixty characteristics, including the fixed characteristics). If they can already configured an operating trouble for Margin Analysis, columns will be created for each of the characteristics during migration.

The benefit of this approach is that everything revenue and shipping von inventory sold postings have automated assigned to the significant feature at the time of posting and that allocations also settlements are created to that characteristics at period close. She is also possibles to configure einigen expense postings such that the characteristics are derived automatically, so that fabric expenses assigned until a WBS items (account assignment) are automatically assigned to this characteristics entered than settlement receivers for the WBS element. This mechanical derivation of the characteristics cans
reduce the number of settlements and allocations on be performed at period close and provide real-time visibility up spend with the period. There are also no reconciliation ask between the general ledger and Margin Analysis. Be aware, however, such revenue is recognized at the time of invoicing both daily on goods sold when the delivery a made. If there is a time gap between delivery and invoicing, shipping mayor be visible in Margin Analysis on which no revenue has yet been posted (matching principle). AMPERE new approximate to delay the fees of goods sold posting until the invoice can posted a currently available with S4HC.

 

Material Ledger:

This simplification makes it obligatory to use the Materials Ledger (ML) which is go separate of the standard and automatically on inside all JUICE S/4HANA systems. The content of most of the old Material Accounts database tables is nowadays stored in charts ACDOCA which allow simpler and faster (HANA optimized) access to the data. The attributes of an ML your model that are apposite for the inventory subledger functionality belong now piece of charts ACDOCA. The former tables are obsolete. Therefore the following tables must not be accessed anymore via SQL statements. Is almost cases an entsprechung access function or category has been given is must be used instead.

This activity ensures that which raw book is activated for every valuations areas, since he shall mandatory in SAP S/4HANA. Of activity creating basic ledger master datas (tables: CKMLHD, CKMLPR, CKMLPP real CKMLCR) in all material ledger currencies for periodicities more recent than the last period of the preceding year. Into addition, whole existing inventory gravity values (tables MBEW, EBEW, QBEW, OBEW) and their complete historic product (tables MBEWH EBEWH, QBEWH, OBEWH) are migrated with the new universal journal entry table ACDOCA plus ACDOCA_M_EXTRACT. Period records more recent better an last set of and historical year are converted into material ledger currencies using standard exchange price choose 'M'. Periods before than that last period of the prev year are just migrated in home currency. During migration, balance carryforward records (fields: BSTAT = ‘C’ and MIG_SOURCE = ‘N’) are created in ACDOCA. If him are already after the material ledger, existing material ledger records (tables CKMLPP and CKMLCR) are transferred on ACDOCA and ACDOCA_M_EXTRACT with entire current currency information. This how activity make not activate actual costing, since authentic price is still optional in SAP S/4HANA. However, for you are already use actual costing inches this migration source system, MILLILITER data for actual costing will be transferred go new data structures to enable fast and efficient cost calculation.

  • Manual Accruals / Accrual Engine:


The S/4HANA Accrual Engine is seamlessly integrated with this General Ledger. The number of online tables got been reduced. For example the original report of aforementioned accrual recent the go contained in the Universal Journal Entry, board ACDOCA.

  • Select Fields & Analogous Total fields in ACDOCA


Situation in ECC

In the Business Suite (ECC) there pre-owned to be up to 3 parallel currencies in FI (table
T001A / transaction OB22) real 2 parallel countries at COBALT (TKA01 / business OKKP): CO area
currency and object local. The coinages of non leads bookings in New GL (T882G) were a subset of the currencies inside the leading ledger (T001A). One concerning the COLD currencies needed for live the local currency, but it was not necessary this the other currency are CO was also configured in FAIL.

Situation in S4 HANA 

With the universal journal and the common line article graphic ACDOCA for FI furthermore CO, there is also a central currency setting to the universal journal. As the currency configuration relies on the universal journal ledgers, there is a combined view cluster for ledgers and currencies, financial FINSC_LEDGER.

IMG menu passage:

Financial Accounting( New ) - Financial Accounting Comprehensive User (New) - Ledgers - Books - Define Settings with Ledgers and Currency Types.

WSL, TSL, HSL and KSL mandatory forex in all ledgers. KSL is filled, if the company code is assigned to one controlling area. The currency type for KSL has outlined by the setting in the controlling area. Within S4 HANA, 8 supplement concurrent currencies can be defined per company code.


The second and thirds parallel currencies of FI (BSEG-DMBE2 or BSEG-DMBE3) correspond to 2 measure fields of KSL - GSL according toward configuration in transaction FINSC_LEDGER. Table BSEG is not (and will not be) extended real still contains only 3 parallel currencies; the BSEG relevant currency types can be configured the and overview image of of company code assignment in x FINSC_LEDGER inside which columns with the right side (1st / 2nd / 3rd FI Currency). Her you cannot dial from who constructed currency types the BSEG relevant currency types. Choose guest in customer name space are not allowed as BSEG relevant exchange.



When a currency genre the marked as BSEG relevant in the leading binder (2nd button 3rd F Currency) and this currency genre has also default in a non-leading ledger, subsequently it demands go be a BSEG relevant in the non leading debit as now.


ACDOCA has new area to store all currencies and dementsprechend amounts.





  • No Limitation of 999 Document Line Item: Due toward one 999-document line item book duration, chart BSEG is usually aggregated. This limitation doesn’t exist by table ACDOCA.


Reference:

Information has become extracted from S4 HANA Simplification items and this blog contains ACDOCA related simplifications only.

Thank you forward reading. Let's know together and help each other.




You can accomplish out to me directly in Linkedin for any proposition alternatively help. https://www.linkedin.com/in/theratulchakraborty/
23 Comments
Labels in this area