P_CnsldtnFndnWithRptRule

Data Foundation With Reporting Rule | view: PCCFNDNWITHRPT | Extraction: Not supported | Component: Embedded Analytics
Tables used: ACDOCU, ACDOCU, ACDOCU, ACDOCU, FINCS_RIASSGMT
Column Name Description
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Value in Transaction Currency
💲 Currency key of the local currency (LocalCurrency):
AmountInLocalCurrency Value in Local Currency
💲 Currency key of the ledger currency (GroupCurrency):
AmountInGroupCurrency Value in Group Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
PostingDate Posting Date in the Document
CurrencyTranslationDate Value Date for Currency Translation
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
Column Name Description
GLRecordType Record Type Show values
DebitCreditCode Debit/Credit Indicator Show values
PostingLevel Posting Level Show values
ConsolidationApportionment Apportionment Show values
CurrencyConversionsDiffType Currency Translation Show values
RefConsolidationDocumentType Document Category Show values
InvestmentActivityType Consolidation of Investments Activity Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
ConsolidationDocumentNumber Document Number of an Accounting Document BELNR
ConsolidationPostingItem Six-Character Posting Item for Ledger DOCLN6
FiscalPeriod Posting period POPER
ConsolidationAcquisitionYear Year of Acquisition GJAHR
ConsolidationAcquisitionPeriod Period of Acquisition NUM03
DocumentItemText Item Text TEXT50
ConsolidationPostgItemAutoFlag Indicator: Automatic posting lines TEXT1
BusinessTransactionType Business Transaction CHAR4
RefConsolidationDocumentNumber Document Number of an Accounting Document BELNR
ReferenceFiscalYear Original Fiscal Year GJAHR
RefConsolidationPostingItem Six-figure number of line item BUZEI6
RefBusinessTransactionType Business Transaction CHAR4
ReverseDocument Reverse Document Number BELNR
ReversedDocument Number of Reversed Document BELNR
InvestmentActivity Consolidation of Investments Activity Number BELNR
ConsolidationDocReversalYear Year of reversal document or reversed document GJAHR
ReferenceDocumentType Reference procedure AWTYP
ReferenceDocumentContext Reference Organizational Units AWORG
LogicalSystem Logical system LOGSYS
AssignmentReference Assignment number ZUONR
WBSElementInternalID Work Breakdown Structure Element (WBS Element) PS_POSNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Project Project definition PS_PSPID
ConsolidationRecordNumber Record number of the line item record OBJNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == T006.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TGSB.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == T004.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CHARTOFACCOUNTS == T004.KTOPL
Company
  • Client
  • Company
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == T880.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.COMPANY == T880.RCOMP
Original company code
  • Original company code
  • Client
  • P_CNSLDTNFNDNWITHRPTRULE.COMPANYCODE == T001.BUKRS
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == T001.MANDT
Consolidation Chart of Accounts
  • Consolidation Chart of Accounts
  • Client
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF120.MANDT
Dimension
  • Client
  • Dimension
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF150.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONDIMENSION == TF150.DIMEN
Document Type
  • Client
  • Document Type
  • Dimension
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF500.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONDIMENSION == TF500.DIMEN
Consolidation Group
  • Consolidation Group
  • Client
  • Dimension
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONGROUP == TF180.CONGR
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF180.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONDIMENSION == TF180.DIMEN
Ledger
  • Client
  • Ledger
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == T881.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONLEDGER == T881.RLDNR
Reporting Item
  • Reporting Item
  • Financial Statement Item
  • Client
  • ?
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONREPORTINGITEM == TF100.ITEM
  • P_CNSLDTNFNDNWITHRPTRULE.FINANCIALSTATEMENTITEM == TF100.ITEM
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF100.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.[column in domain "FC_ITCLG"] == TF100.ITCLG
Consolidation Unit
  • Client
  • Dimension
  • Consolidation Unit
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF160.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONUNIT == TF160.BUNIT
Consolidation Version
  • Client
  • Consolidation Version
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF200.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONVERSION == TF200.RVERS
Controlling Area
  • Client
  • Controlling Area
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TKA01.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == CSKS.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNFNDNWITHRPTRULE.CONTROLLINGAREA == CSKS.KOKRS
  • P_CNSLDTNFNDNWITHRPTRULE.COSTCENTER == CSKS.KOSTL
Customer Number
  • Client
  • Customer Number
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == KNA1.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CUSTOMER == KNA1.KUNNR
Financial Statement Item
  • Consolidation Chart of Accounts
  • Client
  • Reporting Item
  • Financial Statement Item
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF100.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONREPORTINGITEM == TF100.ITEM
  • P_CNSLDTNFNDNWITHRPTRULE.FINANCIALSTATEMENTITEM == TF100.ITEM
Transaction type
  • Client
  • Transaction type
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == T856.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Client
  • Functional Area
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TFKB.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.FUNCTIONALAREA == TFKB.FKBER
Account Number
  • Original company code
  • Account Number
  • Client
  • P_CNSLDTNFNDNWITHRPTRULE.COMPANYCODE == SKB1.BUKRS
  • P_CNSLDTNFNDNWITHRPTRULE.GLACCOUNT == SKB1.SAKNR
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == SKB1.MANDT
Investee Unit
  • Client
  • Dimension
  • Investee Unit
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF160.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_CNSLDTNFNDNWITHRPTRULE.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT
Material Number
  • Client
  • Material Number
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == MARA.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.MATERIAL == MARA.MATNR
Order Number
  • Client
  • Order Number
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == AUFK.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.ORDERID == AUFK.AUFNR
Trading partner's business area
  • Client
  • Trading partner's business area
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TGSB.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == T880.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.PARTNERCOMPANY == T880.RCOMP
Partner Unit
  • Partner Unit
  • Client
  • Dimension
  • P_CNSLDTNFNDNWITHRPTRULE.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF160.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.CONSOLIDATIONDIMENSION == TF160.DIMEN
Sender cost center
  • Client
  • ?
  • Controlling Area
  • Sender cost center
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == CSKS.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNFNDNWITHRPTRULE.CONTROLLINGAREA == CSKS.KOKRS
  • P_CNSLDTNFNDNWITHRPTRULE.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TFKB.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Client
  • Partner Profit Center
  • ?
  • Controlling Area
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == CEPC.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_CNSLDTNFNDNWITHRPTRULE.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNFNDNWITHRPTRULE.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == FAGL_SEGM.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == T001W.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.PLANT == T001W.WERKS
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • P_CNSLDTNFNDNWITHRPTRULE.PROFITCENTER == CEPC.PRCTR
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == CEPC.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNFNDNWITHRPTRULE.CONTROLLINGAREA == CEPC.KOKRS
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == FAGL_SEGM.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.SEGMENT == FAGL_SEGM.SEGMENT
Subitem
  • Subitem
  • Client
  • Subitem Category
  • P_CNSLDTNFNDNWITHRPTRULE.SUBITEM == TF115.SITEM
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF115.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.SUBITEMCATEGORY == TF115.SITYP
Subitem Category
  • Client
  • Subitem Category
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TF110.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.SUBITEMCATEGORY == TF110.SITYP
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == LFA1.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.SUPPLIER == LFA1.LIFNR
Currency Key
  • Currency Key
  • Client
  • P_CNSLDTNFNDNWITHRPTRULE.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == TCURC.MANDT
User Name
  • Client
  • User Name
  • P_CNSLDTNFNDNWITHRPTRULE.MANDT == USR02.MANDT
  • P_CNSLDTNFNDNWITHRPTRULE.USERID == USR02.BNAME