- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
P_MJEL_CnsldtnFoundation
Matrix Consolidation: Foundation View
| view: P_MCONSFNDV
| Extraction:
Not supported
| Component: Embedded Analytics
Tables used:
SCAL_TT_YEAR, ACDOCU, FINCS_REF_VERS_R, ACDOCA, ACDOCP, RTC_PULL_REQ, ACDOCU, ACDOCA, TF500, FINCS_FSITEM, FINCS_GRPSTR, TF110, TF160, TF162, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, FINCS_FSITEM, T000, TF164, HRRP_NODE, T881, TF165, TF200, TF110, T881, TF165, TF168, TF200, TF110, TF103A, TF001, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, FINSC_LEDGER_REP, TFIN010, TFIN010, TFIN010, TFIN010, TF040
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (rtcur): | ||
| tsl | Value in Transaction Currency | |
| 💲 Currency key of the local currency (rhcur): | ||
| hsl | Value in Local Currency | |
| 💲 Currency key of the ledger currency (rkcur): | ||
| ksl | Value in Group Currency | |
| Column Name | Description | |
|---|---|---|
| 📏 Base Unit of Measure (runit): | ||
| msl | Quantity | |
| Column Name | Description | |
|---|---|---|
| budat | Posting Date in the Document | |
| wsdat | Value Date for Currency Translation | |
| cpudt | Day On Which Accounting Document Was Entered | |
| cputm | Time of Entry |
| Column Name | Description | |
|---|---|---|
| rrcty | Record Type | Show values |
| drcrk | Debit/Credit Indicator | Show values |
| period_mode | Period Mode | Show values |
| docct | Document Category | Show values |
| plevl | Posting Level | Show values |
| rpflg | Apportionment | Show values |
| rtflg | Currency Translation | Show values |
| refdocct | Document Category | Show values |
| coiac | Consolidation of Investments Activity | Show values |
| CnsldtnJrnlEntryItemOrigin | Consolidation Journal Entry Item Origin | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| rldnr | Ledger | RLDNR | |
| rdimen | Dimension | FC_DIMEN | |
| ryear | Fiscal Year | GJAHR | |
| docnr | Document Number of an Accounting Document | BELNR | |
| docln | Six-Character Posting Item for Ledger | DOCLN6 | |
| rvers | Version | RVERS | |
| ref_version | Consolidation Version | FC_RVERS | |
| poper | Reporting Period | POPER | |
| year_period | Fiscal Year + Fiscal Period | FINS_FYEARPERIOD | |
| poper_posting | Posting period | POPER | |
| rcomp | Company | RCOMP | |
| rbunit | Consolidation Unit | FC_BUNIT | |
| rbunit_eliminated | Consolidation Elimination Member | FINCS_ELIMINATION_MEMBER | |
| ritclg | Consolidation Chart of Accounts | FC_ITCLG | |
| ritem | Financial Statement Item | FC_ITEM | |
| rbuptr | Partner Unit | FC_BUNIT | |
| rcongr | Consolidation Group | FC_CONGR | |
| robukrs | Original company code | BUKRS | |
| sityp | Subitem Category | FC_SITYP | |
| subit | Subitem | FC_SITEM | |
| docty | Document Type | FC_DOCTY | |
| yracq | Year of Acquisition | GJAHR | |
| pracq | Period of Acquisition | NUM03 | |
| coicu | Investee Unit | FC_BUNIT | |
| sgtxt | Item Text | TEXT50 | |
| autom | Indicator: Automatic posting lines | TEXT1 | |
| activ | Business Transaction | CHAR4 | |
| bvorg | Number of Cross-Company Code Posting Transaction | BVORG | |
| refdocnr | Document Number of an Accounting Document | BELNR | |
| refryear | Fiscal Year | GJAHR | |
| refdocln | Six-figure number of line item | BUZEI6 | |
| refactiv | Business Transaction | CHAR4 | |
| timestamp | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| usnam | User Name | XUBNAME | |
| rvsdocnr | Reverse Document Number | BELNR | |
| orndocnr | Number of Reversed Document | BELNR | |
| coinr | Consolidation of Investments Activity Number | BELNR | |
| revyear | Year of reversal document or reversed document | GJAHR | |
| awtyp | Reference procedure | AWTYP | |
| aworg | Reference Organizational Units | AWORG | |
| logsys | Logical system | LOGSYS | |
| racct | Account Number | SAKNR | |
| xblnr | Reference Document Number | XBLNR1 | |
| zuonr | Assignment number | ZUONR | |
| rcntr | Cost Center | KOSTL | |
| prctr | Profit Center | PRCTR | |
| prctr_eliminated | Consolidation Elimination Member | FINCS_ELIMINATION_MEMBER | |
| rfarea | Functional Area | FKBER | |
| rbusa | Business Area | GSBER | |
| segment | Segment for Segmental Reporting | FB_SEGMENT | |
| segment_eliminated | Consolidation Elimination Member | FINCS_ELIMINATION_MEMBER | |
| rmvct | Transaction type | RMVCT | |
| ps_psp_pnr | Work Breakdown Structure Element (WBS Element) | PS_POSNR | |
| ps_posid | Work Breakdown Structure Element (WBS Element) | PS_POSID | |
| ps_pspid | Project definition | PS_PSPID | |
| konzs | Group key | KONZS | |
| FinancialPlanningReqTransSqnc | Financial Planning Request Transaction Sequence Number | FIS_RSPM_TSN | |
| FinancialPlanningDataPacket | Financial Planning Data Packet Number | NUM6 | |
| FinancialPlanningEntryItem | Financial Planning Entry Item | RSNUMRECORD | |
| rldnr_fin | Ledger in General Ledger Accounting | FINS_LEDGER | |
| adhocitem | Ad Hoc Item | FINCS_ADHOCITEM | |
| adhocset | Ad Hoc Set | FINCS_ADHOCSET | |
| adhocsetitem | Ad Hoc Set Item | FINCS_ADHOCSETITEM | |
| rcode | Reason Code | ICA_RCODE | |
| orig_type | Origin Type | FINCS_ORIG_TYPE | |
| orig_ref | Origin Reference | FINCS_ORIG_REF |
| Master Data Relations | Join Conditions |
|---|---|
Order Number
| |
Industry key
| |
Sales District
| |
Billing Type
| |
Customer Group
| |
Controlling Area
| |
Chart of Accounts
| |
Customer Number
| |
Bill-to Party
| |
Ship-to Party
| |
Country/Region Key
| |
Account Number of Supplier
| |
Product Sold Group
| |
Material Group
| |
Material Number
| |
Product Sold
| |
Partner Profit Center
| |
Partner Segment for Segmental Reporting
| |
Company ID of Trading Partner
| |
Trading partner's business area
| |
Sender cost center
| |
Partner Functional Area
| |
Division
| |
Sales Organization
| |
Distribution Channel
| |
Plant
|