P_PLANDATA_NRL

Reported Financial Data for Real-time Units | view: PPLANDNRL | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing

Tables used: ACDOCP, FINCS_FSITEM, TF110, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, TF103A, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (1)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates
☰ Categorical
Other (28)
🔗 Relations (28)

Column Name	Description
ConsolidationRecordNumber	Record number of the line item record

Column Name	Description
💲 Currency key of the local currency (LocalCurrency):
AmountInLocalCurrency	Value in Local Currency
💲 Currency key of the ledger currency (GroupCurrency):
AmountInGroupCurrency	Value in Group Currency
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency	Value in Transaction Currency

Column Name	Description
QuantityInBaseUnit	Quantity

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
ReferenceDocumentNumber	Reference Document Number	XBLNR1
SubItemCategory	Subitem Category	FC_SITYP
SubItem	Subitem	FC_SITEM
PartnerConsolidationUnit	Partner Unit	FC_BUNIT
FinancialTransactionType	Transaction type	RMVCT
FunctionalArea	Functional Area	FKBER
BusinessArea	Business Area	GSBER
CostCenter	Cost Center	KOSTL
GLAccount	Account Number	SAKNR
ProfitCenter	Profit Center	PRCTR
Segment	Segment for Segmental Reporting	FB_SEGMENT
FinancialStatementItem	Financial Statement Item	FC_ITEM
ConsolidationChartOfAccounts	Consolidation Chart of Accounts	FC_ITCLG
ConsolidationUnit	Consolidation Unit	FINCS_MD_BUNIT
ConsolidationVersion	Version	FC_RVERS
ConsolidationLedger	Consolidation Ledger	FC_RLDNR_CONS
FiscalPeriod	Fiscal Period	POPER
FiscalYear	Ledger Fiscal Year	GJAHR
AssignmentReference	Assignment number	ZUONR
Supplier	Account Number of Supplier	LIFNR
WBSElementExternalID	WBS Element External ID	FIS_WBSEXT_NO_CONV
Project	Project	FIS_PROJECT_NO_CONV
CustomerSupplierCorporateGroup	Corporate Group of Customer or Supplier	KONZS
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV
CreationDateTime	Created On	TZNTSTMPS
FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number	FIS_RSPM_TSN
FinancialPlanningDataPacket	Financial Planning Data Packet Number	NUM6
FinancialPlanningEntryItem	Financial Planning Entry Item	FIS_INT4_UNSIGNED

Master Data Relations	Join Conditions
Billing Type Billing Type Client	`P_PLANDATA_NRL.BILLINGDOCUMENTTYPE == TVFK.FKART` `P_PLANDATA_NRL.MANDT == TVFK.MANDT`
Bill-to Party Bill-to Party Client	`P_PLANDATA_NRL.BILLTOPARTY == KNA1.KUNNR` `P_PLANDATA_NRL.MANDT == KNA1.MANDT`
Chart of Accounts Chart of Accounts Client	`P_PLANDATA_NRL.CHARTOFACCOUNTS == T004.KTOPL` `P_PLANDATA_NRL.MANDT == T004.MANDT`
Company Code Company Code Client	`P_PLANDATA_NRL.COMPANYCODE == T001.BUKRS` `P_PLANDATA_NRL.MANDT == T001.MANDT`
Dimension Client Dimension	`P_PLANDATA_NRL.MANDT == TF150.MANDT` `P_PLANDATA_NRL.CONSOLIDATIONDIMENSION == TF150.DIMEN`
Controlling Area Controlling Area Client	`P_PLANDATA_NRL.CONTROLLINGAREA == TKA01.KOKRS` `P_PLANDATA_NRL.MANDT == TKA01.MANDT`
Customer Number Customer Number Client	`P_PLANDATA_NRL.CUSTOMER == KNA1.KUNNR` `P_PLANDATA_NRL.MANDT == KNA1.MANDT`
Customer Group Client Customer Group	`P_PLANDATA_NRL.MANDT == T151.MANDT` `P_PLANDATA_NRL.CUSTOMERGROUP == T151.KDGRP`
Country/Region of Customer or Supplier Country/Region of Customer or Supplier Client	`P_PLANDATA_NRL.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `P_PLANDATA_NRL.MANDT == T005.MANDT`
Industry Key Industry Key Client	`P_PLANDATA_NRL.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH` `P_PLANDATA_NRL.MANDT == T016.MANDT`
Distribution Channel Distribution Channel Client	`P_PLANDATA_NRL.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `P_PLANDATA_NRL.MANDT == TVTW.MANDT`
Currency key of the ledger currency Client Currency key of the ledger currency	`P_PLANDATA_NRL.MANDT == TCURC.MANDT` `P_PLANDATA_NRL.GROUPCURRENCY == TCURC.WAERS`
Currency key of the local currency Client Currency key of the local currency	`P_PLANDATA_NRL.MANDT == TCURC.MANDT` `P_PLANDATA_NRL.LOCALCURRENCY == TCURC.WAERS`
Material Number Material Number Client	`P_PLANDATA_NRL.MATERIAL == MARA.MATNR` `P_PLANDATA_NRL.MANDT == MARA.MANDT`
Product Sold Group Product Sold Group Product Group Client	`P_PLANDATA_NRL.MATERIALGROUP == T023.MATKL` `P_PLANDATA_NRL.SOLDPRODUCTGROUP == T023.MATKL` `P_PLANDATA_NRL.MANDT == T023.MANDT`
Organization Division Organization Division Client	`P_PLANDATA_NRL.ORGANIZATIONDIVISION == TSPA.SPART` `P_PLANDATA_NRL.MANDT == TSPA.MANDT`
Partner Business Area Client Partner Business Area	`P_PLANDATA_NRL.MANDT == TGSB.MANDT` `P_PLANDATA_NRL.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Company ID of Trading Partner Client	`P_PLANDATA_NRL.PARTNERCOMPANY == T880.RCOMP` `P_PLANDATA_NRL.MANDT == T880.MANDT`
Partner Cost Center Controlling Area Client Partner Cost Center ?	`P_PLANDATA_NRL.CONTROLLINGAREA == CSKS.KOKRS` `P_PLANDATA_NRL.MANDT == CSKS.MANDT` `P_PLANDATA_NRL.PARTNERCOSTCENTER == CSKS.KOSTL` `P_PLANDATA_NRL.[column in domain "DATBI"] == CSKS.DATBI`
Partner Functional Area Partner Functional Area Client	`P_PLANDATA_NRL.PARTNERFUNCTIONALAREA == TFKB.FKBER` `P_PLANDATA_NRL.MANDT == TFKB.MANDT`
Partner Profit Center Controlling Area Partner Profit Center Client ?	`P_PLANDATA_NRL.CONTROLLINGAREA == CEPC.KOKRS` `P_PLANDATA_NRL.PARTNERPROFITCENTER == CEPC.PRCTR` `P_PLANDATA_NRL.MANDT == CEPC.MANDT` `P_PLANDATA_NRL.[column in domain "DATBI"] == CEPC.DATBI`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_PLANDATA_NRL.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `P_PLANDATA_NRL.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`P_PLANDATA_NRL.MANDT == T001W.MANDT` `P_PLANDATA_NRL.PLANT == T001W.WERKS`
Sales District Sales District Client	`P_PLANDATA_NRL.SALESDISTRICT == T171.BZIRK` `P_PLANDATA_NRL.MANDT == T171.MANDT`
Sales Organization Client Sales Organization	`P_PLANDATA_NRL.MANDT == TVKO.MANDT` `P_PLANDATA_NRL.SALESORGANIZATION == TVKO.VKORG`
Ship-to Party Client Ship-to Party	`P_PLANDATA_NRL.MANDT == KNA1.MANDT` `P_PLANDATA_NRL.SHIPTOPARTY == KNA1.KUNNR`
Product Sold Product Sold Client	`P_PLANDATA_NRL.SOLDPRODUCT == MARA.MATNR` `P_PLANDATA_NRL.MANDT == MARA.MANDT`
Product Group Product Sold Group Product Group Client	`P_PLANDATA_NRL.MATERIALGROUP == T023.MATKL` `P_PLANDATA_NRL.SOLDPRODUCTGROUP == T023.MATKL` `P_PLANDATA_NRL.MANDT == T023.MANDT`