ACDOCU table in SAP ERP (or) S/4HANA stores Group Journal Entries data. There are total 106 fields in ACDOCU table.This blog post provides key technical details of SAP ACDOCU table, including its availability across SAP S/4HANA versions and the list of CDS views for ACDOCU table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Cons: Reporting (FC07_UC) |
| Technical Component | Consolidation (EC-CS) |
SAP ACDOCU Table Fields
Following is the list of fields that are available in SAP ACDOCU table. The primary key fields of the table are RCLNT (Client), RLDNR (Ledger), RDIMEN (Dimension), RYEAR (Fiscal Year), DOCNR (Accounting Document Number), DOCLN (Six-Character Posting Item for Ledger).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | T000 | CLNT (3) |
| RLDNR | Ledger | RLDNR | T881 | CHAR (2) |
| RDIMEN | Dimension | FC_DIMEN | TF150 | CHAR (2) |
| RYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| DOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | CHAR (6) | |
| RRCTY | Record Type | FC_RRCTY | CHAR (1) | |
| RVERS | Consolidation (end-result) version | FC_RVERS | TF200 | CHAR (3) |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY (5) |
| RHCUR | Currency key of the local currency | LCURR | CUKY (5) | |
| RKCUR | Currency key of the ledger currency | GCURR | CUKY (5) | |
| RUNIT | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| POPER | Posting period | POPER | NUMC (3) | |
| FISCYEARPER | Fiscal Year/Period | FINCS_FISCYEARPER | NUMC (7) | |
| DOCCT | Document Category | DOCCT | CHAR (1) | |
| RCOMP | Company | RCOMP_D | T880 | CHAR (6) |
| RBUNIT | Consolidation Unit | FC_BUNIT | TF160 | CHAR (18) |
| RITCLG | Consolidation Chart of Accounts | FC_ITCLG | TF120 | CHAR (2) |
| RITEM | Financial Statement Item | FC_ITEM | TF100 | CHAR (10) |
| RBUPTR | Partner Unit | FC_BUPTR | TF160 | CHAR (18) |
| RCONGR | Consolidation Group | FC_CONGR | TF180 | CHAR (18) |
| ROBUKRS | Original company code | OBUKR | T001 | CHAR (4) |
| SITYP | Subitem Category | FC_SITYP | TF110 | CHAR (3) |
| SUBIT | Subitem | FC_SITEM | TF115 | CHAR (10) |
| PLEVL | Posting Level | FC_PLEVL | CHAR (2) | |
| RPFLG | Apportionment | FC_RPFLG | NUMC (1) | |
| RTFLG | Currency Translation | FC_RTFLG | NUMC (1) | |
| DOCTY | Document Type | FC_DOCTY | TF500 | CHAR (2) |
| YRACQ | Year of Acquisition | FC_RYACQ | NUMC (4) | |
| PRACQ | Period of Acquisition | RPACQ | NUMC (3) | |
| COICU | Investee Unit | FC_COICU | TF160 | CHAR (18) |
| UPPCU | Investor Unit | FC_UPPCU | TF160 | CHAR (18) |
| TSL | Value in Transaction Currency | VTCUR12 | CURR (23) | |
| HSL | Value in Local Currency | VLCUR12 | CURR (23) | |
| KSL | Value in Group Currency | VGCUR12 | CURR (23) | |
| MSL | Quantity | FINCS_QUAN | QUAN (29) | |
| SGTXT | Item Text | SGTXT | CHAR (50) | |
| AUTOM | Indicator: Automatic posting lines | AUTOM | CHAR (1) | |
| ACTIV | Business Transaction | GLVOR | CHAR (4) | |
| BVORG | Number of Cross-Company Code Posting Transaction | BVORG | CHAR (16) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| WSDAT | Value Date for Currency Translation | WSDAT | DATS (8) | |
| REFDOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| REFRYEAR | Original Fiscal Year | FC_OYEAR | NUMC (4) | |
| REFDOCLN | Six-figure number of line item | BUZEI6 | NUMC (6) | |
| REFDOCCT | Document Category | DOCCT | CHAR (1) | |
| REFACTIV | Business Transaction | GLVOR | CHAR (4) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| USNAM | User Name | USNAM | USR02 | CHAR (12) |
| RVSDOCNR | Reverse Document Number | STBLG | CHAR (10) | |
| ORNDOCNR | Number of Reversed Document | STBLN | CHAR (10) | |
| BUNNR | Document Bundle Number | FINCS_BUNNR | CHAR (13) | |
| COIAC | Consolidation of Investments Activity | FC_COIAC | CHAR (2) | |
| COINR | Consolidation of Investments Activity Number | FC_COINR | CHAR (10) | |
| REVYEAR | Year of reversal document or reversed document | FC_REVYEAR | NUMC (4) | |
| AWTYP | Reference procedure | AWTYP | CHAR (5) | |
| AWORG | Reference Organizational Units | AWORG | CHAR (10) | |
| LOGSYS | Logical system | LOGSYS | CHAR (10) | |
| KTOPL | Chart of Accounts | KTOPL | T004 | CHAR (4) |
| RACCT | Account Number | RACCT | SKB1 | CHAR (10) |
| XBLNR | Reference Document Number | XBLNR1 | CHAR (16) | |
| ZUONR | Assignment number | DZUONR | CHAR (18) | |
| RCNTR | Cost Center | KOSTL | CSKS | CHAR (10) |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR (10) |
| RFAREA | Functional Area | FKBER | TFKB | CHAR (16) |
| RBUSA | Business Area | GSBER | TGSB | CHAR (4) |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR (4) |
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | FAGL_SEGM | CHAR (10) |
| SCNTR | Sender cost center | SKOST | CSKS | CHAR (10) |
| PPRCTR | Partner Profit Center | PPRCTR | CEPC | CHAR (10) |
| SFAREA | Partner Functional Area | SFKBER | TFKB | CHAR (16) |
| SBUSA | Trading partner’s business area | PARGB | TGSB | CHAR (4) |
| RASSC | Company ID of Trading Partner | RASSC | T880 | CHAR (6) |
| PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | FAGL_SEGM | CHAR (10) |
| AUFNR | Order Number | AUFNR | AUFK | CHAR (12) |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR (10) |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR (10) |
| MATNR | Material Number | MATNR | MARA | CHAR (40) |
| MATKL_MM | Material Group | FINS_MATKL_MM | T023 | CHAR (9) |
| WERKS | Plant | WERKS_D | T001W | CHAR (4) |
| RMVCT | Transaction type | RMVCT | T856 | CHAR (3) |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | * | NUMC (8) |
| PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR (24) | |
| PS_PSPID | Project definition | PS_PSPID | CHAR (24) | |
| FKART | Billing Type | FKART | TVFK | CHAR (4) |
| VKORG | Sales Organization | VKORG | TVKO | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR (2) |
| SPART | Division | SPART | TSPA | CHAR (2) |
| MATNR_COPA | Product Sold | FINS_MATNR_PA | MARA | CHAR (40) |
| MATKL | Product Sold Group | FINS_MATKL_PA | T023 | CHAR (9) |
| KDGRP | Customer Group | KDGRP | T151 | CHAR (2) |
| LAND1 | Country Key | LAND1_GP | T005 | CHAR (3) |
| BRSCH | Industry key | BRSCH | T016 | CHAR (4) |
| BZIRK | Sales District | BZIRK | T171 | CHAR (6) |
| KUNRE | Bill-to party | KUNRE | KNA1 | CHAR (10) |
| KUNWE | Ship-to party | KUNWE | KNA1 | CHAR (10) |
| KONZS | Group key | KONZS | CHAR (10) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS (8) | |
| ADHOCITEM | Ad Hoc Item | FINCS_ADHOCITEM | FINCS_ADHITM | CHAR (30) |
| ADHOCSET | Ad Hoc Set | FINCS_ADHOCSET | FINCS_ADHSET | CHAR (30) |
| ADHOCSETITEM | Ad Hoc Set Item | FINCS_ADHOCSETITEM | FINCS_ADHSETITM | NUMC (8) |
| RCODE | Reason Code | ICA_RCODE | ICA_RC | CHAR (6) |
| ORIG_TYPE | Origin Type | FINCS_ORIG_TYPE | FINCS_ORIGTYPE | CHAR (3) |
| ORIG_REF | Origin Reference | FINCS_ORIG_REF | CHAR (30) |
Availability
ACDOCU table is available in SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ACDOCU table
The following is the list of ACDOCU CDS views, which can also be used instead of ACDOCU table based on your business requirements.
BASIC CDS Views
| CDS View | Description |
|---|---|
| I_CNSLDTNGROUPJRNLENTRYITEM | Group Journal Entry Item |
| I_CNSLDTNJRNLENTRYHEADER | Group Journal Entry Header |
| P_CNSLDTNJRNLENTRYMAXITEM | Group Journal Entry Header |
| P_CNSLDTNJRNLENTRYTP | Group Journal Entry Header |
| P_CNSLDTNJRNLENTRYUPLD | P_CnsldtnJrnlEntryUPLD |
| P_IJE_LOG_DETAIL_PRE | Import Journal Entries Log Details |
| P_IMPORTJOURNALENTRIES | Import Journal Entries |
| P_MATRIX_ELIMDATAWGROUPDERIVED | Matrix Consolidation: Elim. Data with Group Derived |
| P_MATRIX_PREPAREDELIMCGDERIV | Matrix Consolidation: Prepared Elim. Data for Grp Derivation |
COMPOSITE CDS Views
| CDS View | Description |
|---|---|
| A_CNSLDTNTRANSACTIONDATA | Consolidation – Transactional Data for Group Reporting |
| A_CNSLDTNTRANSDATARPTGRULES | Consolidation – Transaction Data With Reporting Rules |
| I_CNSLDTNFNDNCUBE | Consolidation Foundation Cube |
| I_CNSLDTNFNDNENHANCEDCUBE | Consolidation Foundation Enhanced Cube |
| I_CNSLDTNFOUNDATION | Consolidation Foundation |
| I_CNSLDTNINTCOELIMINATIONCUBE | Consolidation Interunit Enhanced Cube |
| I_CNSLDTNINTCORECNCLNCUBE | Consolidation Interunit Enhanced Cube |
| I_CNSLDTNJRNLENTR | Journal Entry (Database List) |
| I_CNSLDTNJRNLENTR1 | Journal Entry |
| I_CNSLDTNJRNLENTRITEM | Journal Entry (Database List) Items |
| I_CNSLDTNJRNLENTRITEM1 | Journal Entry Line Item |
| I_CNSLDTNRELEASEDRPTDFINDATA | Consolidation – Released Reported Data |
| I_CONSOLIDATIONGROUPREPORTC | Group Reporting Data Cube |
| I_CONSOLIDATIONGROUPRPTENHCDC | Enhanced Group Reporting Data Cube |
| I_CONSOLIDATIONJOURNALENTRYC | Group Journal Entries Cube |
| I_GROUPREPORTINGLINEITEM | Consolidation – Line Item |
| I_GROUPREPORTINGVALIDATION | Group Reporting Validation View |
| I_GRPRPTGSELFOREXTENSION | Group Reporting Unified Selection for Extension |
| I_MATRIXCNSLDTNFNDNCUBE | Matrix Consolidation Foundation Cube |
| I_MATRIXCNSLDTNFNDNENHCDCUBE | Matrix Consolidation Foundation Cube with Reporting Rule |
| I_MATRIXCNSLDTNFNDNFORPERMODE | Matrix Consolidation Foundation |
| I_MATRIXCNSLDTNFNDNFORYTDMODE | Matrix Consolidation Foundation |
| I_MATRIXCNSLDTNFOUNDATION | Matrix Consolidation Foundation |
| I_MATRIXCNSLDTNFOUNDATION_2 | Matrix Consolidation Foundation |
| I_MATRIXCNSLDTNJRNLENTR | Matrix Cnsldtn: Journal Entry |
| I_MATRIXCNSLDTNREPORTC_2 | Group Reporting Data – Cube |
| I_MATRIXCNSLDTNREPORTENHCDC_2 | Rule-Based Group Data Analysis – Cube |
| I_MATRIXCONSOLIDATIONREPORTC | Group Data Analysis Cube |
| I_MATRIXCONSOLIDATIONRPTENHCDC | Rule-Based Group Data Analysis Cube |
| P_CNSLDTNDATAWCNSLDTNLOGIC | Consolidation: Consolidated Data with Reporting Logic |
| P_CNSLDTNDATAWCNSLDTNLOGICYTD | Consolidation: Consolidated Data with Reporting Logic |
| P_CNSLDTNFNDNWITHRPTRULE | Data Foundation With Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE1 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE1_2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE1_3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE1_4 | P_CNSLDTNFNDNWITHRPTRULE1_4 |
| P_CNSLDTNFNDNWITHRPTRULE2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE2_2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE2_3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE2_4 | P_CNSLDTNFNDNWITHRPTRULE2_4 |
| P_CNSLDTNFNDNWITHRPTRULE3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE3_2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE3_3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE3_4 | P_CNSLDTNFNDNWITHRPTRULE3_4 |
| P_CNSLDTNFNDNWITHRPTRULE4 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE4_2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE4_3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE4_4 | P_CNSLDTNFNDNWITHRPTRULE4_4 |
| P_CNSLDTNFNDNWITHRPTRULE5 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE5_2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE5_3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE5_4 | P_CNSLDTNFNDNWITHRPTRULE5_4 |
| P_CNSLDTNFNDNWITHRPTRULE6 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE6_2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE6_3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE6_4 | P_CNSLDTNFNDNWITHRPTRULE6_4 |
| P_CNSLDTNFNDNWITHRPTRULE7 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE7_2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE7_3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE7_4 | P_CNSLDTNFNDNWITHRPTRULE7_4 |
| P_CNSLDTNFNDNWITHRPTRULE8 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE8_2 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE8_3 | Consolidation Foundation with Reporting Rule |
| P_CNSLDTNFNDNWITHRPTRULE8_4 | P_CNSLDTNFNDNWITHRPTRULE8_4 |
| P_CNSLDTNFNDNWITHRPTRULES | P_CNSLDTNFNDNWITHRPTRULES |
| P_CNSLDTNFNDNWITHRPTRULES_2 | P_CNSLDTNFNDNWITHRPTRULES_2 |
| P_CNSLDTNFNDNWITHRPTRULES_3 | P_CNSLDTNFNDNWITHRPTRULES_3 |
| P_CNSLDTNFNDNWITHRPTRULES_4 | P_CNSLDTNFNDNWITHRPTRULES_4 |
| P_CNSLDTNGROUPJRNLENTRYITEM | Group Journal Entry Item |
| P_CNSLDTNICRECONTHR1 | IC Reconciliation – Recon. View With Threshold 1 |
| P_CNSLDTNICRECONTHR2 | IC Reconciliation – Recon. View With Threshold 2 |
| P_CNSLDTNICRECONTHR3 | IC Reconciliation – Recon. View With Threshold 3 |
| P_CNSLDTNICRECONTHR4 | IC Reconciliation – Recon. View With Threshold 4 |
| P_CNSLDTNICRECONTHR5 | IC Reconciliation – Recon. View With Threshold 5 |
| P_CNSLDTNICRECONTHR6 | IC Reconciliation – Recon. View With Threshold 6 |
| P_CNSLDTNICRECONTHR7 | IC Reconciliation – Recon. View With Threshold 7 |
| P_CNSLDTNICRECONTHR8 | IC Reconciliation – Recon. View With Threshold 8 |
| P_CNSLDTNINTCOBASE | IC Reconciliation – Recon. View Base |
| P_CNSLDTNINTCOELIMINATION | IC Reconciliation – Elim. View Base |
| P_CNSLDTNINTCORECNCLN | IC Reconciliation – Recon. View Base |
| P_CONSOLIDATEDDATA | Consolidated Data |
| P_CONSOLIDATIONFNDNBASIC | Consolidation Foundation |
| P_CONSOLIDATIONFNDNWITHYTD | Consolidation Foundation |
| P_CONSOLIDATIONFOUNDATION | Consolidation Foundation |
| P_FINCS_USELECTION | Unified Selection |
| P_GROUPREPORTINGLINEITEM | Consolidation – Line Item |
| P_MATRIXCNSLDTNFNDNENHCDCUBE | P_CNSLDTNFNDNWITHRPTRULES_3 |
| P_MATRIXCNSLDTNFOUNDATION | Matrix Consolidation Foundation |
| P_MATRIX_CNSLDTDDATAWTHOUTELIM | Matrix Consolidation: Consolidated Data Without Elim. |
| P_MATRIX_CNSLDTNFNDN | Matrix Consolidation: Foundation View with Union |
| P_MATRIX_CNSLDTNFNDNPER | Matrix Consolidation: Foundation View with Union |
| P_MATRIX_CNSLDTNFNDNPERIODIC | Matrix Consolidation: Periodic Data |
| P_MATRIX_CNSLDTNFNDNPERIODIC_2 | Matrix Consolidation: Periodic Data |
| P_MATRIX_CNSLDTNFNDNWHIERFPER | Matrix Consolidation: Foundation View with Hierarchy |
| P_MATRIX_CNSLDTNFNDNWHIERFYTD | Matrix Consolidation: Foundation View with Hierarchy |
| P_MATRIX_CNSLDTNFNDNWITHHIER | Matrix Consolidation: Foundation View with Hierarchy |
| P_MATRIX_CNSLDTNFNDNWITHHIER_2 | Matrix Consolidation: Foundation View with Hierarchy |
| P_MATRIX_CNSLDTNFNDNYTD | Matrix Consolidation: Foundation View with Union |
| P_MATRIX_CNSLDTNFNDN_2 | Matrix Consolidation: Foundation View with Union |
| P_MATRIX_CNSLDTNFOUNDATION | Matrix Consolidation: Foundation View |
| P_MATRIX_CNSLDTNFOUNDATIONPER | Matrix Consolidation: Foundation View |
| P_MATRIX_CNSLDTNFOUNDATIONYTD | Matrix Consolidation: Foundation View |
| P_MATRIX_CNSLDTNFOUNDATION_2 | Matrix Consolidation: Foundation View |
| P_MATRIX_CP_GROUPDERIVED | Matrix Consolidation Periodic with derived Group |
| P_MATRIX_CP_GROUPDERIVED_2 | Matrix Consolidation Periodic with derived Group |
| P_MATRIX_CP_GROUPEMPTY | Matrix Consolidation Periodic with empty Group |
| P_MATRIX_CP_GROUPEMPTY_2 | Matrix Consolidation Periodic with empty Group |
| P_MATRIX_CP_GROUPFILLED | Matrix Consolidation Periodic with filled Group |
| P_MATRIX_CP_GROUPFILLED_2 | Matrix Consolidation Periodic with filled Group |
| P_MATRIX_ELIMDATA | Matrix Consolidation: Elimination Data (PL=20, 22) |
| P_MATRIX_ELIMDATAWITHOUTGROUP | Matrix Consolidation: Elimination Data (PL = 20) |
| P_MATRIX_NEWPCC | Matrix Consolidation: additional posting from new PCC |
| P_MATRIX_PCCDATA | Matrix Consolidation: PCC Data PL = 02, 12, 22 |
| P_MATRIX_PREPAREDSFDFORCGDERIV | Matrix Consolidation: Prepared SFD for Group Derivation |
| P_MATRIX_SFDWGROUPDERIVED | Matrix Consolidation: SFD with Group Derived |
| P_MATRIX_VECCNSLDTDDATA | Matrix Consolidation: For Vec, Consolidated Data |
| P_MATRIX_VECCONSOLIDATEDDATA | Matrix Consolidation: For Vec, Consolidated Data |
| P_MATRIX_VECELIM | Matrix Consolidation: For Vec, PL20 with Group Derived |
| P_MATRIX_VECPCC | Matrix Consolidation: For Vec, PCC Data |
| P_MATRIX_VECSFD | Matrix Consolidation: For Vec, SFD with Group Derived |
| P_MATRIX_WCNSLDTNLOGICYTD_ELIM | Matrix Consolidation: Elimination with Record Type ‘R’ |
| P_MATRIX_WCNSLDTNLOGICYTD_RFD | Matrix Consolidation: RFD with Record Type ‘R’ |
| P_MJEL_CNSLDTDDATAWTHOUTELIM | Matrix Consolidation: Consolidated Data Without Elim. |
| P_MJEL_CNSLDTNFNDN | Matrix Consolidation: Foundation View with Union |
| P_MJEL_CNSLDTNFNDNWITHHIER | Matrix Consolidation: Foundation View with Hierarchy |
| P_MJEL_CNSLDTNFOUNDATION | Matrix Consolidation: Foundation View |
| P_MJEL_CNSLDTNPERIODIC | Matrix Consolidation: Periodic Data |
| P_MJEL_ELIMDATA | Matrix Consolidation: Elimination Data (PL=20, 22) |
| P_MJEL_ELIMDATAWGROUPDERIVED | Matrix Consolidation: Elim. Data with Group Derived |
| P_MJEL_ELIMDATAWITHOUTGROUP | Matrix Consolidation: Elimination Data (PL = 20) |
| P_MJEL_PREPAREDELIMCGDERIV | Matrix Consolidation: Prepared Elim. Data for Grp Derivation |
| P_MJEL_PREPAREDSFDFORCGDERIV | Matrix Consolidation: Prepared SFD for Group Derivation |
| P_MJEL_SFDWGROUPDERIVED | Matrix Consolidation: SFD with Group Derived |
| P_MJEL_STANDARDIZEDDATA | Consolidation: Standardized Data |
| P_REPORTEDFINANCIALDATA | Consolidation: Reported Financial Data |
| P_REPORTEDFINANCIALDATA_RL_AG | Reported Financial Data for Real-time Units |
| P_STANDARDIZEDDATA | Consolidation: Standardized Data |
| P_STANDARDIZEDDATAWITHPARAM | Consolidation: Standardized Data |
| P_VECCONSOLIDATEDDATA | Consolidation Validation: Consolidated Data |
| P_VECCONSOLIDATEDDATA_01 | Get Consolidated Data per Year |
| P_VECCONSOLIDATEDDATA_02 | Union 2 years Consolidated Data |
| P_VECFINCSUNION | Consolidation Validation: Union |
| P_VECFINCSUNION_01 | Union Reported and Standard and Consolidated Task |
| P_VECREPFINDATA_01 | Get Reported Financial Data per Year |
| P_VECREPFINDATA_02 | Union 2 years Reported Financial Data |
| P_VECREPORTEDFINANCIALDATA | Consolidation Validation: Reported Financial Data |
| P_VECSTANDARDIZEDDATA | Consolidation Validation: Standardized Data |
| P_VECSTANDARDIZEDDATA_01 | Get Standardized Data per Year |
| P_VECSTANDARDIZEDDATA_02 | Union 2 years Standardized Data by Currency Type |
CONSUMPTION CDS Views
| CDS View | Description |
|---|---|
| C_CNSLDTDCMPLXRPT01Q | Cash Flow Statement – By Consolidation Units |
| C_CNSLDTDTOTALS01Q | Data Analysis ΓÇô Reporting Logic |
| C_CNSLDTDTOTALS11Q | Consolidated Balance Sheet |
| C_CNSLDTDTOTALS12Q | Consolidated Balance Sheet – Year Comparison |
| C_CNSLDTDTOTALS13Q | Consolidated Balance Sheet -By Subgroups |
| C_CNSLDTDTOTALS15Q | Consolidated Balance Sheet – By Movements |
| C_CNSLDTDTOTALS21Q | Consolidated P&L by Nature |
| C_CNSLDTDTOTALS22Q | Consolidated P&L by Nature – Year Comparison |
| C_CNSLDTDTOTALS23Q | Consolidated P&L by Nature – By Subgroups |
| C_CNSLDTDTOTALS24Q | Consolidated P&L by Nature – By Functional Areas |
| C_CNSLDTDTOTALS31Q | Consolidated P&L by Function |
| C_CNSLDTDTOTALS32Q | Consolidated P&L by Function – Year Comparison |
| C_CNSLDTDTOTALS33Q | Consolidated P&L by Function – By Subgroups |
| C_CNSLDTDTOTALS61Q | Currency Translation – Reserve Analysis |
| C_CNSLDTDTOTALS62Q | Currency Translation – Difference Analysis |
| C_CNSLDTNCMPLXRPT01Q | Cash Flow Statement |
| C_CNSLDTNCMPLXRPT02Q | Statement of Comprehensive Income |
| C_CNSLDTNCMPLXRPT03Q | Statement of Changes in Equity |
| C_CNSLDTNGRPACTLCOMPRN10Q | Actual & Budget Comparison ΓÇô YTD GC Value |
| C_CNSLDTNGRPACTLCOMPRN20Q | Actual & Budget Comparison ΓÇô Periodic GC Value |
| C_CNSLDTNGRPACTLCOMPRN30Q | Actual & Budget Comparison with Reporting Rule ΓÇô Periodic GC |
| C_CNSLDTNGRPFCSTCOMPRN10Q | Forecast Variance ΓÇô YTD GC Value |
| C_CNSLDTNGRPFCSTCOMPRN20Q | Forecast Variance ΓÇô Periodic GC Value |
| C_CNSLDTNGRPFCSTCOMPRN30Q | Forecast Variance with Reporting Rule ΓÇô Periodic GC Value |
| C_CNSLDTNINTCOELIMINATION01Q | Interunit Reconciliation – Group View |
| C_CNSLDTNINTCOELIMINATION02Q | Interunit Reconciliation – Group View |
| C_CNSLDTNINTCORECNCLN01Q | Interunit Reconciliation – Subsidiary View |
| C_CNSLDTNINTCORECNCLN02Q | Interunit Reconciliation – Subsidiary View |
| C_CNSLDTNJRNLENTR | Journal Entry Consumption View |
| C_CNSLDTNJRNLENTRITEM | Journal Entries List |
| C_CNSLDTNJRNLENTRYITEMTP | Journal Entry Item |
| C_CNSLDTNJRNLENTRYTP | Journal Entry Management |
| C_CNSLDTNRELEASEDRPTDFINDATA | Consolidation – Released Reported Data |
| C_CNSLDTNRPT30Q | Group Data Analysis |
| C_CNSLDTNRPT40Q | Group Data Analysis ΓÇô With Reporting Rules |
| C_CNSLDTNRULEBSDGRPRPT01Q | Group Reporting Data with Reporting Rules |
| C_CNSLDTNTOTALS01Q | Data Analysis |
| C_CNSLDTNTOTALS11Q | Balance Sheet – By Consolidation Units |
| C_CNSLDTNTOTALS12Q | Balance Sheet – Year Comparison |
| C_CNSLDTNTOTALS15Q | Balance Sheet – By Movements |
| C_CNSLDTNTOTALS21Q | P&L by Nature of Expense – By Consolidation Units |
| C_CNSLDTNTOTALS22Q | P&L by Nature of Expense – Year Comparison |
| C_CNSLDTNTOTALS24Q | P&L by Nature of Expense – By Functional Areas |
| C_CNSLDTNTOTALS31Q | P&L by Function of Expense – By Consolidation Units |
| C_CNSLDTNTOTALS32Q | P&L by Function of Expense – Year Comparison |
| C_CONSOLIDATIONGROUPOVRVIEW10Q | Periodic Overview – YTD GC Value |
| C_CONSOLIDATIONGROUPOVRVIEW20Q | Periodic Overview ΓÇô Periodic GC Value |
| C_CONSOLIDATIONGROUPOVRVIEW30Q | Periodic Overview with Reporting Rule ΓÇô Periodic GC Value |
| C_CONSOLIDATIONGROUPRPT10Q | Consolidated Balance Sheet |
| C_CONSOLIDATIONGROUPRPT20Q | Consolidated P&L by Nature of Expense |
| C_CONSOLIDATIONGROUPRPT90Q | Query for Data Visualization |
| C_CONSOLIDATIONMATRIXRPT10Q | Local/Group Data Analysis Query |
| C_CONSOLIDATIONMATRIXRPT30Q | Local/Group Data Analysis Query with Reporting Rules |
| C_MATRIXCNSLDTNJRNLENTR | Matrix Cnsldtn: JE Consumption View |
EXTENSION CDS Views
| CDS View | Description |
|---|---|
| E_CNSLDTNGROUPJRNLENTRYITEM | Group Journal Entry Item Extension |
