P_CNSLDTNFNDNWITHRPTRULE1

Consolidation Foundation with Reporting Rule | view: PCCFNDNWITHRPT1 | Extraction: Not supported | Component: Embedded Analytics

Tables used: ACDOCU, ACDOCU, ACDOCU, ACDOCU, FINCS_RI_RT

🔑 Keys
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (8)
Other (27)
🔗 Relations (50)

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
ConsolidationReverseSign	Reverse Sign Indicator	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
ConsolidationReportingItem	Reporting Item	FC_ITEM
CustomerSupplierCorporateGroup	Group key	KONZS

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`P_CNSLDTNFNDNWITHRPTRULE1.BASEUNIT == T006.MSEHI` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T006.MANDT`
Billing Type Billing Type Client	`P_CNSLDTNFNDNWITHRPTRULE1.BILLINGDOCUMENTTYPE == TVFK.FKART` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TVFK.MANDT`
Bill-to Party Bill-to Party Client	`P_CNSLDTNFNDNWITHRPTRULE1.BILLTOPARTY == KNA1.KUNNR` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == KNA1.MANDT`
Business Area Business Area Client	`P_CNSLDTNFNDNWITHRPTRULE1.BUSINESSAREA == TGSB.GSBER` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`P_CNSLDTNFNDNWITHRPTRULE1.CHARTOFACCOUNTS == T004.KTOPL` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T004.MANDT`
Company Company Client	`P_CNSLDTNFNDNWITHRPTRULE1.COMPANY == T880.RCOMP` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T880.MANDT`
Original company code Client Original company code	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T001.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.COMPANYCODE == T001.BUKRS`
Consolidation Chart of Accounts Client Consolidation Chart of Accounts	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF120.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG`
Dimension Dimension Client	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONDIMENSION == TF150.DIMEN` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF150.MANDT`
Document Type Dimension Document Type Client	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONDIMENSION == TF500.DIMEN` `P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF500.MANDT`
Consolidation Group Dimension Client Consolidation Group	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONDIMENSION == TF180.DIMEN` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF180.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONGROUP == TF180.CONGR`
Ledger Ledger Client	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONLEDGER == T881.RLDNR` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T881.MANDT`
Consolidation Unit Dimension Client Consolidation Unit	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF160.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONUNIT == TF160.BUNIT`
Consolidation Version Consolidation Version Client	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONVERSION == TF200.RVERS` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF200.MANDT`
Controlling Area Controlling Area Client	`P_CNSLDTNFNDNWITHRPTRULE1.CONTROLLINGAREA == TKA01.KOKRS` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Client Cost Center	`P_CNSLDTNFNDNWITHRPTRULE1.[column in domain "DATBI"] == CSKS.DATBI` `P_CNSLDTNFNDNWITHRPTRULE1.CONTROLLINGAREA == CSKS.KOKRS` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == CSKS.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.COSTCENTER == CSKS.KOSTL`
Customer Number Customer Number Client	`P_CNSLDTNFNDNWITHRPTRULE1.CUSTOMER == KNA1.KUNNR` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`P_CNSLDTNFNDNWITHRPTRULE1.CUSTOMERGROUP == T151.KDGRP` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T151.MANDT`
Country/Region Key Country/Region Key Client	`P_CNSLDTNFNDNWITHRPTRULE1.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T005.MANDT`
Industry key Client Industry key	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T016.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Distribution Channel Client	`P_CNSLDTNFNDNWITHRPTRULE1.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TVTW.MANDT`
Financial Statement Item Reporting Item Financial Statement Item Client Consolidation Chart of Accounts	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONREPORTINGITEM == TF100.ITEM` `P_CNSLDTNFNDNWITHRPTRULE1.FINANCIALSTATEMENTITEM == TF100.ITEM` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF100.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG`
Transaction type Transaction type Client	`P_CNSLDTNFNDNWITHRPTRULE1.FINANCIALTRANSACTIONTYPE == T856.TRTYP` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T856.MANDT`
Functional Area Client Functional Area	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TFKB.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.FUNCTIONALAREA == TFKB.FKBER`
Account Number Client Original company code Account Number	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == SKB1.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.COMPANYCODE == SKB1.BUKRS` `P_CNSLDTNFNDNWITHRPTRULE1.GLACCOUNT == SKB1.SAKNR`
Investee Unit Dimension Client Investee Unit	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF160.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT`
Material Number Material Number Client	`P_CNSLDTNFNDNWITHRPTRULE1.MATERIAL == MARA.MATNR` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == MARA.MANDT`
Material Group Material Group Client	`P_CNSLDTNFNDNWITHRPTRULE1.MATERIALGROUP == T023.MATKL` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T023.MANDT`
Order Number Order Number Client	`P_CNSLDTNFNDNWITHRPTRULE1.ORDERID == AUFK.AUFNR` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == AUFK.MANDT`
Division Client Division	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TSPA.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.ORGANIZATIONDIVISION == TSPA.SPART`
Trading partner's business area Client Trading partner's business area	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TGSB.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Company ID of Trading Partner Client	`P_CNSLDTNFNDNWITHRPTRULE1.PARTNERCOMPANY == T880.RCOMP` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T880.MANDT`
Partner Unit Dimension Client Partner Unit	`P_CNSLDTNFNDNWITHRPTRULE1.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF160.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT`
Sender cost center ? Controlling Area Client Sender cost center	`P_CNSLDTNFNDNWITHRPTRULE1.[column in domain "DATBI"] == CSKS.DATBI` `P_CNSLDTNFNDNWITHRPTRULE1.CONTROLLINGAREA == CSKS.KOKRS` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == CSKS.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.PARTNERCOSTCENTER == CSKS.KOSTL`
Partner Functional Area Partner Functional Area Client	`P_CNSLDTNFNDNWITHRPTRULE1.PARTNERFUNCTIONALAREA == TFKB.FKBER` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TFKB.MANDT`
Partner Profit Center ? Controlling Area Partner Profit Center Client	`P_CNSLDTNFNDNWITHRPTRULE1.[column in domain "DATBI"] == CEPC.DATBI` `P_CNSLDTNFNDNWITHRPTRULE1.CONTROLLINGAREA == CEPC.KOKRS` `P_CNSLDTNFNDNWITHRPTRULE1.PARTNERPROFITCENTER == CEPC.PRCTR` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_CNSLDTNFNDNWITHRPTRULE1.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T001W.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.PLANT == T001W.WERKS`
Profit Center ? Controlling Area Client Profit Center	`P_CNSLDTNFNDNWITHRPTRULE1.[column in domain "DATBI"] == CEPC.DATBI` `P_CNSLDTNFNDNWITHRPTRULE1.CONTROLLINGAREA == CEPC.KOKRS` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == CEPC.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.PROFITCENTER == CEPC.PRCTR`
Sales District Client Sales District	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T171.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.SALESDISTRICT == T171.BZIRK`
Sales Organization Sales Organization Client	`P_CNSLDTNFNDNWITHRPTRULE1.SALESORGANIZATION == TVKO.VKORG` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TVKO.MANDT`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == FAGL_SEGM.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.SEGMENT == FAGL_SEGM.SEGMENT`
Ship-to Party Client Ship-to Party	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == KNA1.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.SHIPTOPARTY == KNA1.KUNNR`
Product Sold Product Sold Client	`P_CNSLDTNFNDNWITHRPTRULE1.SOLDPRODUCT == MARA.MATNR` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == MARA.MANDT`
Product Sold Group Product Sold Group Client	`P_CNSLDTNFNDNWITHRPTRULE1.SOLDPRODUCTGROUP == T023.MATKL` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == T023.MANDT`
Subitem Subitem Category Subitem Client	`P_CNSLDTNFNDNWITHRPTRULE1.SUBITEMCATEGORY == TF115.SITYP` `P_CNSLDTNFNDNWITHRPTRULE1.SUBITEM == TF115.SITEM` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF115.MANDT`
Subitem Category Subitem Category Client	`P_CNSLDTNFNDNWITHRPTRULE1.SUBITEMCATEGORY == TF110.SITYP` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TF110.MANDT`
Account Number of Supplier Account Number of Supplier Client	`P_CNSLDTNFNDNWITHRPTRULE1.SUPPLIER == LFA1.LIFNR` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == LFA1.MANDT`
Currency Key Client Currency Key	`P_CNSLDTNFNDNWITHRPTRULE1.MANDT == TCURC.MANDT` `P_CNSLDTNFNDNWITHRPTRULE1.TRANSACTIONCURRENCY == TCURC.WAERS`
User Name User Name Client	`P_CNSLDTNFNDNWITHRPTRULE1.USERID == USR02.BNAME` `P_CNSLDTNFNDNWITHRPTRULE1.MANDT == USR02.MANDT`