P_Foundationp

Consolidation Foundation View of Planning | view: PFOUNDATIONP | Extraction: Not supported | Component: Real-Time Consolidation
Tables used: ACDOCP, T001, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Transaction Currency (rwcur):
wsl Amount in Transaction Currency
💲 Company Code Currency (rhcur):
hsl Amount in Company Code Currency
💲 Global Currency (rkcur):
ksl Amount in Global Currency
Column Name Description
📏 Unit of Measure for Valuation Quantity (runit):
msl Valuation quantity
Column Name Description
budat Start Date of Fiscal Period
Column Name Description
Column Name Description Domain name
gjahr General Ledger Fiscal Year GJAHR
belnr Document Number of an Accounting Document BELNR
periv Fiscal Year Variant PERIV
poper Posting period POPER
fiscyearper Fiscal Year Period FISCALYEARPERIOD
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
anbwa Asset Transaction Type BWASL
anln1 Main Asset Number ANLN1
ps_pspid Project definition PS_PSPID
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
Master Data Relations Join Conditions
Customer Group
  • Customer Group
  • Client
  • P_FOUNDATIONP.KDGRP == T151.KDGRP
  • P_FOUNDATIONP.MANDT == T151.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_FOUNDATIONP.KOKRS == TKA01.KOKRS
  • P_FOUNDATIONP.MANDT == TKA01.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_FOUNDATIONP.KTOPL == T004.KTOPL
  • P_FOUNDATIONP.MANDT == T004.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • P_FOUNDATIONP.MATKL == T023.MATKL
  • P_FOUNDATIONP.MANDT == T023.MANDT
Partner Profit Center
  • Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • P_FOUNDATIONP.PPRCTR == CEPC.PRCTR
  • P_FOUNDATIONP.[column in domain "DATBI"] == CEPC.DATBI
  • P_FOUNDATIONP.KOKRS == CEPC.KOKRS
  • P_FOUNDATIONP.MANDT == CEPC.MANDT
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • P_FOUNDATIONP.PRCTR == CEPC.PRCTR
  • P_FOUNDATIONP.[column in domain "DATBI"] == CEPC.DATBI
  • P_FOUNDATIONP.KOKRS == CEPC.KOKRS
  • P_FOUNDATIONP.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
Account Number
  • Chart of Accounts
  • Account Number
  • Client
  • P_FOUNDATIONP.KTOPL == SKA1.KTOPL
  • P_FOUNDATIONP.RACCT == SKA1.SAKNR
  • P_FOUNDATIONP.MANDT == SKA1.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_FOUNDATIONP.RASSC == T880.RCOMP
  • P_FOUNDATIONP.MANDT == T880.MANDT
Company Code
  • Company Code
  • Client
  • P_FOUNDATIONP.RBUKRS == T001.BUKRS
  • P_FOUNDATIONP.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • P_FOUNDATIONP.RBUSA == TGSB.GSBER
  • P_FOUNDATIONP.MANDT == TGSB.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • P_FOUNDATIONP.RCNTR == CSKS.KOSTL
  • P_FOUNDATIONP.[column in domain "DATBI"] == CSKS.DATBI
  • P_FOUNDATIONP.KOKRS == CSKS.KOKRS
  • P_FOUNDATIONP.MANDT == CSKS.MANDT
Allocation of company code to company
  • Client
  • Company
  • P_FOUNDATIONP.MANDT == T880.MANDT
  • P_FOUNDATIONP.RCOMP == T880.RCOMP
Functional Area
  • Functional Area
  • Client
  • P_FOUNDATIONP.RFAREA == TFKB.FKBER
  • P_FOUNDATIONP.MANDT == TFKB.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Transaction type
  • Transaction type
  • Client
  • P_FOUNDATIONP.RMVCT == T856.TRTYP
  • P_FOUNDATIONP.MANDT == T856.MANDT
Trading partner's business area
  • Client
  • Trading partner's business area
  • P_FOUNDATIONP.MANDT == TGSB.MANDT
  • P_FOUNDATIONP.SBUSA == TGSB.GSBER
Sender cost center
  • Sender cost center
  • ?
  • Controlling Area
  • Client
  • P_FOUNDATIONP.SCNTR == CSKS.KOSTL
  • P_FOUNDATIONP.[column in domain "DATBI"] == CSKS.DATBI
  • P_FOUNDATIONP.KOKRS == CSKS.KOKRS
  • P_FOUNDATIONP.MANDT == CSKS.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_FOUNDATIONP.SFAREA == TFKB.FKBER
  • P_FOUNDATIONP.MANDT == TFKB.MANDT
Division
  • Client
  • Division
  • P_FOUNDATIONP.MANDT == TSPA.MANDT
  • P_FOUNDATIONP.SPART == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • P_FOUNDATIONP.MANDT == TVKO.MANDT
  • P_FOUNDATIONP.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • P_FOUNDATIONP.VTWEG == TVTW.VTWEG
  • P_FOUNDATIONP.MANDT == TVTW.MANDT