Ansicht
Dokumentation
RTC_CRTECFVIEW - Create Consolidation Foundation View
Addresses (Business Address Services) CL_GUI_FRONTEND_SERVICES - Frontend ServicesThis documentation is copyright by SAP AG.
In this Customizing activity, you create consolidation foundation views that will be the basis for all the consolidation tasks in a consolidation model. This activity is not mandatory for customers on SAP S/4HANA 1709because two default foundation views are pre-delivered by SAP.
Based on foundation views, additional consolidation views are generated by the Real-Time Consolidation modeling tool.
Foundation views can be CDS view or HANA calculation view. CDS views are created using ABAP Development Tools (ADT), while HANA calculation views are created using the graphical modeling features of the SAP HANA Modeler. In both cases, you must have SAP HANA Studio (Eclipse-based) installed.
Refer to https://help.sap.com/viewer/a2a49126a5c546a9864aae22c05c3d0e/2.0.01/en-US for SAP HANA StudioInstallation Procedure.
In general, foundation views must achieve the following objectives:
- Project consolidation-relevant fields from the financial journal table.
- Make necessary data filtering.
Fields in foundation views are protocoled. Some fields are mandatory and with fixed names, while others can be freely added. Below is an example of streamlined foundation view for company dimension consolidation. It projects fields from universal journal (ACDOCA).
Field Name | Field Description | Usage | |
---|---|---|---|
RCLNT | SAP Client | Mandatory | |
RLDNR | Ledger in G/L Accounting | Mandatory: for drill-through | |
GJAHR | Local Fiscal Year | Mandatory: for drill-through | |
RBUKRS | Company Code | Mandatory: for drill-through | |
BELNR | Accounting Document Number | Mandatory: for drill-through | |
RCOMP | Company | Mandatory if consolidation is on company | |
RASSC | Trading Partner | Mandatory if consolidation is on company | |
BUDAT | Posting Date | Mandatory: for fiscal year period alignment | |
KTOPL | Local CoA | Mandatory | |
RACCT | Local Account Number | Mandatory | |
RMVCT | Transaction Type | Mandatory | |
RWCUR | Transaction Currency Key | Optional | |
RHCUR | Company Code Currency Key | Mandatory | |
WSL | Amount in Transaction Currency | Optional | |
HSL | Amount in Company Code Currency | Mandatory | |
TIMESTAMP | Timestamp | Mandatory: for data cut-off |
Below example foundation views are provided for your reference. You can copy it to your own SAP HANA package, and adjust it per your own requirements.
Data Category | Type | View | Description | |
---|---|---|---|---|
ACTUAL | CDS | P_FOUNDATIONA | Foundation View on ACDOCA | |
ACTUAL | Calc | RTC_C_FOUNDATIONA | Foundation View on ACDOCA | |
PLAN | CDS | P_FOUNDATIONP | Foundation View on ACDOCP | |
PLAN | Calc | RTC_C_FOUNDATIONP | Foundation View on ACDOCP |
The HANA Calculation Views are in package: sap.erp.sfin.rtc. The modeling tool will automatically copy them to your own HANA package if you use them.
RFUMSV00 - Advance Return for Tax on Sales/Purchases Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 6328 Date: 20240523 Time: 221203 sap01-206 ( 54 ms )