P_PlanData_RT

Reported Financial Data for Real-time Units | view: PPLANDATA | Extraction: Not supported | Component: Consolidation
Tables used: SCAL_TT_YEAR, ACDOCP, RTC_PULL_REQ, TF500, 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
gl_sirid Record number of the line item record
Column Name Description
💲 Currency Key (rtcur):
tsl Value in Transaction Currency
💲 Currency key of the local currency (rhcur):
hsl Value in Local Currency
💲 Currency key of the ledger currency (rkcur):
ksl Value in Group Currency
Column Name Description
msl Quantity
Column Name Description
budat Posting Date in the Document
cpudt Day On Which Accounting Document Was Entered
cputm Time of Entry
wsdat Value Date for Currency Translation
_dataaging Data Filter Value for Data Aging
Column Name Description
rrcty Record Type Show values
rtflg Currency Translation Show values
drcrk Debit/Credit Indicator Show values
coiac Consolidation of Investments Activity Show values
plevl Posting Level Show values
refdocct Document Category Show values
docct Document Category Show values
rpflg Apportionment Show values
Column Name Description Domain name
rldnr Ledger RLDNR
rvers Consolidation Version FC_RVERS
ryear Ledger Fiscal Year GJAHR
poper Fiscal Period POPER
rdimen Dimension FC_DIMEN
rbunit Consolidation Unit FC_BUNIT
ritclg Consolidation Chart of Accounts FC_ITCLG
ritem Financial Statement Item FC_ITEM
rbuptr Partner Unit FC_BUNIT
sityp Subitem Category FC_SITYP
subit Subitem FC_SITEM
racct Account Number SAKNR
zuonr Assignment number ZUONR
rcntr Cost Center KOSTL
prctr Profit Center PRCTR
rfarea Functional Area FKBER
rbusa Business Area GSBER
segment Segment for Segmental Reporting FB_SEGMENT
lifnr Account Number of Supplier LIFNR
rmvct Transaction type RMVCT
ps_posid WBS Element External ID FIS_WBSEXT_NO_CONV
ps_pspid Project FIS_PROJECT_NO_CONV
konzs Corporate Group of Customer or Supplier KONZS
ps_psp_pnr WBS Element Internal ID FIS_WBSINT_NO_CONV
timestamp Created On TZNTSTMPS
xblnr Reference Document Number XBLNR1
docty Document Type FC_DOCTY
docnr Document Number of an Accounting Document BELNR
docln Six-Character Posting Item for Ledger DOCLN6
refryear Fiscal Year GJAHR
fiscyearper Fiscal Year Period FIS_JAHRPER_CONV
updhp Highest update period POPER
refdocnr Document Number of an Accounting Document BELNR
awtyp Reference procedure AWTYP
aworg Reference Organizational Units AWORG
logsys Logical system LOGSYS
usnam User Name XUBNAME
refdocln Six-figure number of line item BUZEI6
coicu Investee Unit FC_BUNIT
rvsdocnr Reverse Document Number BELNR
revyear Year of reversal document or reversed document GJAHR
yracq Year of Acquisition GJAHR
sgtxt Item Text TEXT50
autom Indicator: Automatic posting lines TEXT1
rcongr Consolidation Group FC_CONGR
bvorg Number of Cross-Company Code Posting Transaction BVORG
orndocnr Number of Reversed Document BELNR
coinr Consolidation of Investments Activity Number BELNR
refactiv Business Transaction CHAR4
activ Business Transaction CHAR4
rcomp Company RCOMP
pracq Period of Acquisition NUM03
uppcu Investor Unit FC_BUNIT
reqtsn Financial Planning Request Transaction Sequence Number FIS_RSPM_TSN
datapakid Financial Planning Data Packet Number NUM6
record Financial Planning Entry Item RSNUMRECORD
Master Data Relations Join Conditions
Industry Key
  • Client
  • Industry Key
  • P_PLANDATA_RT.MANDT == T016.MANDT
  • P_PLANDATA_RT.BRSCH == T016.BRSCH
Sales District
  • Client
  • Sales District
  • P_PLANDATA_RT.MANDT == T171.MANDT
  • P_PLANDATA_RT.BZIRK == T171.BZIRK
Billing Type
  • Billing Type
  • Client
  • P_PLANDATA_RT.FKART == TVFK.FKART
  • P_PLANDATA_RT.MANDT == TVFK.MANDT
Customer Group
  • Customer Group
  • Client
  • P_PLANDATA_RT.KDGRP == T151.KDGRP
  • P_PLANDATA_RT.MANDT == T151.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_PLANDATA_RT.KOKRS == TKA01.KOKRS
  • P_PLANDATA_RT.MANDT == TKA01.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_PLANDATA_RT.MANDT == T004.MANDT
  • P_PLANDATA_RT.KTOPL == T004.KTOPL
Customer Number
  • Client
  • Customer Number
  • P_PLANDATA_RT.MANDT == KNA1.MANDT
  • P_PLANDATA_RT.KUNNR == KNA1.KUNNR
Bill-to Party
  • Bill-to Party
  • Client
  • P_PLANDATA_RT.KUNRE == KNA1.KUNNR
  • P_PLANDATA_RT.MANDT == KNA1.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_PLANDATA_RT.KUNWE == KNA1.KUNNR
  • P_PLANDATA_RT.MANDT == KNA1.MANDT
Country/Region of Customer or Supplier
  • Country/Region of Customer or Supplier
  • Client
  • P_PLANDATA_RT.LAND1 == T005.LAND1
  • P_PLANDATA_RT.MANDT == T005.MANDT
Product Group
  • Client
  • Product Sold Group
  • Product Group
  • P_PLANDATA_RT.MANDT == T023.MANDT
  • P_PLANDATA_RT.MATKL_MM == T023.MATKL
  • P_PLANDATA_RT.MATKL == T023.MATKL
Product Sold Group
  • Client
  • Product Sold Group
  • Product Group
  • P_PLANDATA_RT.MANDT == T023.MANDT
  • P_PLANDATA_RT.MATKL_MM == T023.MATKL
  • P_PLANDATA_RT.MATKL == T023.MATKL
Material Number
  • Client
  • Material Number
  • P_PLANDATA_RT.MANDT == MARA.MANDT
  • P_PLANDATA_RT.MATNR == MARA.MATNR
Product Sold
  • Product Sold
  • Client
  • P_PLANDATA_RT.MATNR_COPA == MARA.MATNR
  • P_PLANDATA_RT.MANDT == MARA.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • Client
  • P_PLANDATA_RT.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANDATA_RT.KOKRS == CEPC.KOKRS
  • P_PLANDATA_RT.PPRCTR == CEPC.PRCTR
  • P_PLANDATA_RT.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_PLANDATA_RT.MANDT == T880.MANDT
  • P_PLANDATA_RT.RASSC == T880.RCOMP
Company Code
  • Client
  • Company Code
  • P_PLANDATA_RT.MANDT == T001.MANDT
  • P_PLANDATA_RT.ROBUKRS == T001.BUKRS
Partner Business Area
  • Client
  • Partner Business Area
  • P_PLANDATA_RT.MANDT == TGSB.MANDT
  • P_PLANDATA_RT.SBUSA == TGSB.GSBER
Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • Partner Cost Center
  • P_PLANDATA_RT.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANDATA_RT.KOKRS == CSKS.KOKRS
  • P_PLANDATA_RT.MANDT == CSKS.MANDT
  • P_PLANDATA_RT.SCNTR == CSKS.KOSTL
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_PLANDATA_RT.SFAREA == TFKB.FKBER
  • P_PLANDATA_RT.MANDT == TFKB.MANDT
Organization Division
  • Organization Division
  • Client
  • P_PLANDATA_RT.SPART == TSPA.SPART
  • P_PLANDATA_RT.MANDT == TSPA.MANDT
Sales Organization
  • Client
  • Sales Organization
  • P_PLANDATA_RT.MANDT == TVKO.MANDT
  • P_PLANDATA_RT.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • P_PLANDATA_RT.MANDT == TVTW.MANDT
  • P_PLANDATA_RT.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • P_PLANDATA_RT.MANDT == T001W.MANDT
  • P_PLANDATA_RT.WERKS == T001W.WERKS