P_PLANDATA_RT_07

Evaluate breakdown by RTCUR and provide fields from ACDOCP | view: PPLANDATA_07 | Extraction: Not supported | Component: Consolidation
Tables used: SCAL_TT_YEAR, ACDOCP, RTC_PULL_REQ, FINCS_FSITEM, TF160, TF162, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, T000, TF164, T881, TF165, TF200, TF110, TF103A, TF040, FINSC_FISC_DATE, FINSC_PERIOD, FINSC_LEDGER_REP, TFIN010, TFIN010
Column Name Description
Column Name Description
AmountInTransactionCurrency Amount in Transaction Currency
AmountInLocalCurrency Amount in Global Currency
AmountInGroupCurrency Amount in Global Currency
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
ConsolidationVersion Consolidation Version FC_RVERS
ConsolidationLedger Ledger RLDNR
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
  • Billing Type
  • Client
  • P_PLANDATA_RT_07.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_PLANDATA_RT_07.MANDT == TVFK.MANDT
Bill-to Party
  • Client
  • Bill-to Party
  • P_PLANDATA_RT_07.MANDT == KNA1.MANDT
  • P_PLANDATA_RT_07.BILLTOPARTY == KNA1.KUNNR
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_PLANDATA_RT_07.MANDT == T004.MANDT
  • P_PLANDATA_RT_07.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_PLANDATA_RT_07.COMPANYCODE == T001.BUKRS
  • P_PLANDATA_RT_07.MANDT == T001.MANDT
Dimension
  • Dimension
  • Client
  • P_PLANDATA_RT_07.CONSOLIDATIONDIMENSION == TF150.DIMEN
  • P_PLANDATA_RT_07.MANDT == TF150.MANDT
Consolidation Unit
  • Dimension
  • Consolidation Unit
  • Client
  • P_PLANDATA_RT_07.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_PLANDATA_RT_07.CONSOLIDATIONUNIT == TF160.BUNIT
  • P_PLANDATA_RT_07.MANDT == TF160.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_PLANDATA_RT_07.MANDT == TKA01.MANDT
  • P_PLANDATA_RT_07.CONTROLLINGAREA == TKA01.KOKRS
Customer Number
  • Client
  • Customer Number
  • P_PLANDATA_RT_07.MANDT == KNA1.MANDT
  • P_PLANDATA_RT_07.CUSTOMER == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • P_PLANDATA_RT_07.CUSTOMERGROUP == T151.KDGRP
  • P_PLANDATA_RT_07.MANDT == T151.MANDT
Country/Region of Customer or Supplier
  • Country/Region of Customer or Supplier
  • Client
  • P_PLANDATA_RT_07.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_PLANDATA_RT_07.MANDT == T005.MANDT
Industry Key
  • Client
  • Industry Key
  • P_PLANDATA_RT_07.MANDT == T016.MANDT
  • P_PLANDATA_RT_07.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Client
  • Distribution Channel
  • P_PLANDATA_RT_07.MANDT == TVTW.MANDT
  • P_PLANDATA_RT_07.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Material Number
  • Client
  • Material Number
  • P_PLANDATA_RT_07.MANDT == MARA.MANDT
  • P_PLANDATA_RT_07.MATERIAL == MARA.MATNR
Product Sold Group
  • Client
  • Product Sold Group
  • Product Group
  • P_PLANDATA_RT_07.MANDT == T023.MANDT
  • P_PLANDATA_RT_07.MATERIALGROUP == T023.MATKL
  • P_PLANDATA_RT_07.SOLDPRODUCTGROUP == T023.MATKL
Organization Division
  • Client
  • Organization Division
  • P_PLANDATA_RT_07.MANDT == TSPA.MANDT
  • P_PLANDATA_RT_07.ORGANIZATIONDIVISION == TSPA.SPART
Partner Business Area
  • Client
  • Partner Business Area
  • P_PLANDATA_RT_07.MANDT == TGSB.MANDT
  • P_PLANDATA_RT_07.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_PLANDATA_RT_07.MANDT == T880.MANDT
  • P_PLANDATA_RT_07.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • ?
  • Client
  • Controlling Area
  • Partner Cost Center
  • P_PLANDATA_RT_07.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANDATA_RT_07.MANDT == CSKS.MANDT
  • P_PLANDATA_RT_07.CONTROLLINGAREA == CSKS.KOKRS
  • P_PLANDATA_RT_07.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_PLANDATA_RT_07.MANDT == TFKB.MANDT
  • P_PLANDATA_RT_07.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • ?
  • Client
  • Controlling Area
  • Partner Profit Center
  • P_PLANDATA_RT_07.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANDATA_RT_07.MANDT == CEPC.MANDT
  • P_PLANDATA_RT_07.CONTROLLINGAREA == CEPC.KOKRS
  • P_PLANDATA_RT_07.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_PLANDATA_RT_07.MANDT == FAGL_SEGM.MANDT
  • P_PLANDATA_RT_07.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • P_PLANDATA_RT_07.MANDT == T001W.MANDT
  • P_PLANDATA_RT_07.PLANT == T001W.WERKS
Sales District
  • Client
  • Sales District
  • P_PLANDATA_RT_07.MANDT == T171.MANDT
  • P_PLANDATA_RT_07.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • P_PLANDATA_RT_07.MANDT == TVKO.MANDT
  • P_PLANDATA_RT_07.SALESORGANIZATION == TVKO.VKORG
Ship-to Party
  • Client
  • Ship-to Party
  • P_PLANDATA_RT_07.MANDT == KNA1.MANDT
  • P_PLANDATA_RT_07.SHIPTOPARTY == KNA1.KUNNR
Product Sold
  • Client
  • Product Sold
  • P_PLANDATA_RT_07.MANDT == MARA.MANDT
  • P_PLANDATA_RT_07.SOLDPRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Sold Group
  • Product Group
  • P_PLANDATA_RT_07.MANDT == T023.MANDT
  • P_PLANDATA_RT_07.MATERIALGROUP == T023.MATKL
  • P_PLANDATA_RT_07.SOLDPRODUCTGROUP == T023.MATKL