P_PLANDATA_NRL_06

Evaluate breakdown by RTCUR and provide fields from ACDOCP | view: PPLANDNRL_06 | 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
💰 Amounts (3)
∑ Quantities (1)
📅 Dates
☰ Categorical
Other (29)
🔗 Relations (28)

Column Name	Description

Column Name	Description
AmountInTransactionCurrency	Amount in Transaction Currency
AmountInLocalCurrency	Amount in Freely Defined Currency 8
AmountInGroupCurrency	Amount in Freely Defined Currency 8

Column Name	Description
QuantityInBaseUnit	Valuation quantity

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
SubItemCategory	Fixed value for a subitem category-like characteristic	CHAR10
SubItem	null
PartnerConsolidationUnit	null
BaseUnit	null
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	Work Breakdown Structure Element (WBS Element)	PS_POSID
WBSElement	Work Breakdown Structure Element (WBS Element)	PS_POSID
Project	Project definition	PS_PSPID
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 Client Billing Type	`P_PLANDATA_NRL_06.MANDT == TVFK.MANDT` `P_PLANDATA_NRL_06.BILLINGDOCUMENTTYPE == TVFK.FKART`
Bill-to Party Bill-to Party Client	`P_PLANDATA_NRL_06.BILLTOPARTY == KNA1.KUNNR` `P_PLANDATA_NRL_06.MANDT == KNA1.MANDT`
Chart of Accounts Client Chart of Accounts	`P_PLANDATA_NRL_06.MANDT == T004.MANDT` `P_PLANDATA_NRL_06.CHARTOFACCOUNTS == T004.KTOPL`
Company Code Client Company Code	`P_PLANDATA_NRL_06.MANDT == T001.MANDT` `P_PLANDATA_NRL_06.COMPANYCODE == T001.BUKRS`
Dimension Dimension Client	`P_PLANDATA_NRL_06.CONSOLIDATIONDIMENSION == TF150.DIMEN` `P_PLANDATA_NRL_06.MANDT == TF150.MANDT`
Local Currency Local Currency Client	`P_PLANDATA_NRL_06.CONSOLIDATIONUNITLOCALCURRENCY == TCURC.WAERS` `P_PLANDATA_NRL_06.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`P_PLANDATA_NRL_06.CONTROLLINGAREA == TKA01.KOKRS` `P_PLANDATA_NRL_06.MANDT == TKA01.MANDT`
Customer Number Client Customer Number	`P_PLANDATA_NRL_06.MANDT == KNA1.MANDT` `P_PLANDATA_NRL_06.CUSTOMER == KNA1.KUNNR`
Customer Group Client Customer Group	`P_PLANDATA_NRL_06.MANDT == T151.MANDT` `P_PLANDATA_NRL_06.CUSTOMERGROUP == T151.KDGRP`
Country/Region of Customer or Supplier Country/Region of Customer or Supplier Client	`P_PLANDATA_NRL_06.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `P_PLANDATA_NRL_06.MANDT == T005.MANDT`
Industry Key Client Industry Key	`P_PLANDATA_NRL_06.MANDT == T016.MANDT` `P_PLANDATA_NRL_06.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Client Distribution Channel	`P_PLANDATA_NRL_06.MANDT == TVTW.MANDT` `P_PLANDATA_NRL_06.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Group Currency of Consolidation Version Group Currency of Consolidation Version Client	`P_PLANDATA_NRL_06.GROUPCURRENCY == TCURC.WAERS` `P_PLANDATA_NRL_06.MANDT == TCURC.MANDT`
Material Number Client Material Number	`P_PLANDATA_NRL_06.MANDT == MARA.MANDT` `P_PLANDATA_NRL_06.MATERIAL == MARA.MATNR`
Product Sold Group Product Group Product Sold Group Client	`P_PLANDATA_NRL_06.SOLDPRODUCTGROUP == T023.MATKL` `P_PLANDATA_NRL_06.MATERIALGROUP == T023.MATKL` `P_PLANDATA_NRL_06.MANDT == T023.MANDT`
Organization Division Client Organization Division	`P_PLANDATA_NRL_06.MANDT == TSPA.MANDT` `P_PLANDATA_NRL_06.ORGANIZATIONDIVISION == TSPA.SPART`
Partner Business Area Partner Business Area Client	`P_PLANDATA_NRL_06.PARTNERBUSINESSAREA == TGSB.GSBER` `P_PLANDATA_NRL_06.MANDT == TGSB.MANDT`
Company ID of Trading Partner Client Company ID of Trading Partner	`P_PLANDATA_NRL_06.MANDT == T880.MANDT` `P_PLANDATA_NRL_06.PARTNERCOMPANY == T880.RCOMP`
Partner Cost Center Partner Cost Center Controlling Area Client ?	`P_PLANDATA_NRL_06.PARTNERCOSTCENTER == CSKS.KOSTL` `P_PLANDATA_NRL_06.CONTROLLINGAREA == CSKS.KOKRS` `P_PLANDATA_NRL_06.MANDT == CSKS.MANDT` `P_PLANDATA_NRL_06.[column in domain "DATBI"] == CSKS.DATBI`
Partner Functional Area Partner Functional Area Client	`P_PLANDATA_NRL_06.PARTNERFUNCTIONALAREA == TFKB.FKBER` `P_PLANDATA_NRL_06.MANDT == TFKB.MANDT`
Partner Profit Center Controlling Area Client ? Partner Profit Center	`P_PLANDATA_NRL_06.CONTROLLINGAREA == CEPC.KOKRS` `P_PLANDATA_NRL_06.MANDT == CEPC.MANDT` `P_PLANDATA_NRL_06.[column in domain "DATBI"] == CEPC.DATBI` `P_PLANDATA_NRL_06.PARTNERPROFITCENTER == CEPC.PRCTR`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`P_PLANDATA_NRL_06.MANDT == FAGL_SEGM.MANDT` `P_PLANDATA_NRL_06.PARTNERSEGMENT == FAGL_SEGM.SEGMENT`
Plant Plant Client	`P_PLANDATA_NRL_06.PLANT == T001W.WERKS` `P_PLANDATA_NRL_06.MANDT == T001W.MANDT`
Sales District Sales District Client	`P_PLANDATA_NRL_06.SALESDISTRICT == T171.BZIRK` `P_PLANDATA_NRL_06.MANDT == T171.MANDT`
Sales Organization Sales Organization Client	`P_PLANDATA_NRL_06.SALESORGANIZATION == TVKO.VKORG` `P_PLANDATA_NRL_06.MANDT == TVKO.MANDT`
Ship-to Party Client Ship-to Party	`P_PLANDATA_NRL_06.MANDT == KNA1.MANDT` `P_PLANDATA_NRL_06.SHIPTOPARTY == KNA1.KUNNR`
Product Sold Product Sold Client	`P_PLANDATA_NRL_06.SOLDPRODUCT == MARA.MATNR` `P_PLANDATA_NRL_06.MANDT == MARA.MANDT`
Product Group Product Group Product Sold Group Client	`P_PLANDATA_NRL_06.SOLDPRODUCTGROUP == T023.MATKL` `P_PLANDATA_NRL_06.MATERIALGROUP == T023.MATKL` `P_PLANDATA_NRL_06.MANDT == T023.MANDT`