P_Foundationa

Consolidation Foundation View of ACDOCA | view: PFOUNDATIONA | Extraction: Not supported | Component: Real-Time Consolidation

Tables used: ACDOCA, T001

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

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
📏 Base Unit of Measure (runit):
msl	Quantity

Column Name	Description
budat	Posting Date in the Document

Column Name	Description

Column Name	Description	Domain name
gjahr	Fiscal Year	GJAHR
belnr	Document Number of an Accounting Document	BELNR
poper	Posting period	POPER
fiscyearper	Fiscal Year Period	FISCALYEARPERIOD
timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
ps_pspid	Project definition	PS_PSPID
ps_posid	Work Breakdown Structure Element (WBS Element)	PS_POSID

Master Data Relations	Join Conditions
Asset Transaction Type Client Asset Transaction Type	`P_FOUNDATIONA.MANDT == TABW.MANDT` `P_FOUNDATIONA.ANBWA == TABW.BWASL`
Customer Group Client Customer Group	`P_FOUNDATIONA.MANDT == T151.MANDT` `P_FOUNDATIONA.KDGRP == T151.KDGRP`
Controlling Area Client Controlling Area	`P_FOUNDATIONA.MANDT == TKA01.MANDT` `P_FOUNDATIONA.KOKRS == TKA01.KOKRS`
Chart of Accounts Chart of Accounts Client	`P_FOUNDATIONA.KTOPL == T004.KTOPL` `P_FOUNDATIONA.MANDT == T004.MANDT`
Product Sold Group Product Sold Group Client	`P_FOUNDATIONA.MATKL == T023.MATKL` `P_FOUNDATIONA.MANDT == T023.MANDT`
Company Code of Partner Client Company Code of Partner	`P_FOUNDATIONA.MANDT == T001.MANDT` `P_FOUNDATIONA.PBUKRS == T001.BUKRS`
Fiscal Year Variant Fiscal Year Variant Client	`P_FOUNDATIONA.PERIV == T009.PERIV` `P_FOUNDATIONA.MANDT == T009.MANDT`
Partner Profit Center ? Client Controlling Area Partner Profit Center	`P_FOUNDATIONA.[column in domain "DATBI"] == CEPC.DATBI` `P_FOUNDATIONA.MANDT == CEPC.MANDT` `P_FOUNDATIONA.KOKRS == CEPC.KOKRS` `P_FOUNDATIONA.PPRCTR == CEPC.PRCTR`
Profit Center ? Profit Center Client Controlling Area	`P_FOUNDATIONA.[column in domain "DATBI"] == CEPC.DATBI` `P_FOUNDATIONA.PRCTR == CEPC.PRCTR` `P_FOUNDATIONA.MANDT == CEPC.MANDT` `P_FOUNDATIONA.KOKRS == CEPC.KOKRS`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_FOUNDATIONA.PSEGMENT == FAGL_SEGM.SEGMENT` `P_FOUNDATIONA.MANDT == FAGL_SEGM.MANDT`
Account Number Account Number Client Company Code	`P_FOUNDATIONA.RACCT == SKB1.SAKNR` `P_FOUNDATIONA.MANDT == SKB1.MANDT` `P_FOUNDATIONA.RBUKRS == SKB1.BUKRS`
Company ID of Trading Partner Client Company ID of Trading Partner	`P_FOUNDATIONA.MANDT == T880.MANDT` `P_FOUNDATIONA.RASSC == T880.RCOMP`
Company Code Client Company Code	`P_FOUNDATIONA.MANDT == T001.MANDT` `P_FOUNDATIONA.RBUKRS == T001.BUKRS`
Business Area Client Business Area	`P_FOUNDATIONA.MANDT == TGSB.MANDT` `P_FOUNDATIONA.RBUSA == TGSB.GSBER`
Cost Center ? Client Cost Center Controlling Area	`P_FOUNDATIONA.[column in domain "DATBI"] == CSKS.DATBI` `P_FOUNDATIONA.MANDT == CSKS.MANDT` `P_FOUNDATIONA.RCNTR == CSKS.KOSTL` `P_FOUNDATIONA.KOKRS == CSKS.KOKRS`
Allocation of company code to company Company Client	`P_FOUNDATIONA.RCOMP == T880.RCOMP` `P_FOUNDATIONA.MANDT == T880.MANDT`
Functional Area Client Functional Area	`P_FOUNDATIONA.MANDT == TFKB.MANDT` `P_FOUNDATIONA.RFAREA == TFKB.FKBER`
Company Code Currency Client Company Code Currency	`P_FOUNDATIONA.MANDT == TCURC.MANDT` `P_FOUNDATIONA.RHCUR == TCURC.WAERS`
Global Currency Client Global Currency	`P_FOUNDATIONA.MANDT == TCURC.MANDT` `P_FOUNDATIONA.RKCUR == TCURC.WAERS`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`P_FOUNDATIONA.MANDT == FINSC_LEDGER.MANDT` `P_FOUNDATIONA.RLDNR == FINSC_LEDGER.RLDNR`
Transaction type Client Transaction type	`P_FOUNDATIONA.MANDT == T856.MANDT` `P_FOUNDATIONA.RMVCT == T856.TRTYP`
Base Unit of Measure Client Base Unit of Measure	`P_FOUNDATIONA.MANDT == T006.MANDT` `P_FOUNDATIONA.RUNIT == T006.MSEHI`
Transaction Currency Client Transaction Currency	`P_FOUNDATIONA.MANDT == TCURC.MANDT` `P_FOUNDATIONA.RWCUR == TCURC.WAERS`
Trading partner's business area Client Trading partner's business area	`P_FOUNDATIONA.MANDT == TGSB.MANDT` `P_FOUNDATIONA.SBUSA == TGSB.GSBER`
Sender cost center ? Client Sender cost center Controlling Area	`P_FOUNDATIONA.[column in domain "DATBI"] == CSKS.DATBI` `P_FOUNDATIONA.MANDT == CSKS.MANDT` `P_FOUNDATIONA.SCNTR == CSKS.KOSTL` `P_FOUNDATIONA.KOKRS == CSKS.KOKRS`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`P_FOUNDATIONA.SEGMENT == FAGL_SEGM.SEGMENT` `P_FOUNDATIONA.MANDT == FAGL_SEGM.MANDT`
Partner Functional Area Client Partner Functional Area	`P_FOUNDATIONA.MANDT == TFKB.MANDT` `P_FOUNDATIONA.SFAREA == TFKB.FKBER`
Division Client Division	`P_FOUNDATIONA.MANDT == TSPA.MANDT` `P_FOUNDATIONA.SPART == TSPA.SPART`
Sales Organization Client Sales Organization	`P_FOUNDATIONA.MANDT == TVKO.MANDT` `P_FOUNDATIONA.VKORG == TVKO.VKORG`
Distribution Channel Client Distribution Channel	`P_FOUNDATIONA.MANDT == TVTW.MANDT` `P_FOUNDATIONA.VTWEG == TVTW.VTWEG`