P_ConsolidationFndnWithYTD

Consolidation Foundation | view: PCSFDYTD | Extraction: Not supported | Component: S4HANA Financial Consolidation[Cloud]

Tables used: ACDOCU, ACDOCU

🔑 Keys (5)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (7)
Other (23)
🔗 Relations (50)

Column Name	Description
rldnr FK	Ledger
rdimen FK	Dimension
ryear	Fiscal Year
docnr	Document Number of an Accounting Document
docln	Six-Character Posting Item for Ledger

Column Name	Description
💲 Currency Key (rtcur):
tsl_ytd	Cumulative Value in Transaction Currency
💲 Currency key of the local currency (rhcur):
hsl_ytd	Cumulative Value in Local Currency
💲 Currency key of the ledger currency (rkcur):
ksl_ytd	Cumulative Value in Group Currency

Column Name	Description
📏 Base Unit of Measure (runit):
msl_ytd	Cumulative Quantity in Base Unit

Column Name	Description
budat	Posting Date in the Document
wsdat	Value Date for Currency Translation
cpudt	Day On Which Accounting Document Was Entered
cputm	Time of Entry

Column Name	Description
rrcty	Record Type	Show values
drcrk	Debit/Credit Indicator	Show values
plevl	Posting Level	Show values
rpflg	Apportionment	Show values
rtflg	Currency Translation	Show values
refdocct	Document Category	Show values
coiac	Consolidation of Investments Activity	Show values

Column Name	Description	Domain name
poper	Posting period	POPER
yracq	Year of Acquisition	GJAHR
pracq	Period of Acquisition	NUM03
sgtxt	Item Text	TEXT50
autom	Indicator: Automatic posting lines	TEXT1
activ	Business Transaction	CHAR4
refdocnr	Document Number of an Accounting Document	BELNR
refryear	Original Fiscal Year	GJAHR
refdocln	Six-figure number of line item	BUZEI6
refactiv	Business Transaction	CHAR4
rvsdocnr	Reverse Document Number	BELNR
orndocnr	Number of Reversed Document	BELNR
coinr	Consolidation of Investments Activity Number	BELNR
revyear	Year of reversal document or reversed document	GJAHR
awtyp	Reference procedure	AWTYP
aworg	Reference Organizational Units	AWORG
logsys	Logical system	LOGSYS
zuonr	Assignment number	ZUONR
ps_psp_pnr	Work Breakdown Structure Element (WBS Element)	PS_POSNR
ps_posid	Work Breakdown Structure Element (WBS Element)	PS_POSID
ps_pspid	Project definition	PS_PSPID
gl_sirid	Record number of the line item record	OBJNR
konzs	Group key	KONZS

Master Data Relations	Join Conditions
Order Number Order Number Client	`P_CONSOLIDATIONFNDNWITHYTD.AUFNR == AUFK.AUFNR` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == AUFK.MANDT`
Industry key Industry key Client	`P_CONSOLIDATIONFNDNWITHYTD.BRSCH == T016.BRSCH` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == T016.MANDT`
Sales District Sales District Client	`P_CONSOLIDATIONFNDNWITHYTD.BZIRK == T171.BZIRK` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == T171.MANDT`
Investee Unit Client Dimension Investee Unit	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF160.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RDIMEN == TF160.DIMEN` `P_CONSOLIDATIONFNDNWITHYTD.COICU == TF160.BUNIT`
Document Type Document Type Client Dimension	`P_CONSOLIDATIONFNDNWITHYTD.DOCTY == TF500.DOCTY` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF500.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RDIMEN == TF500.DIMEN`
Billing Type Client Billing Type	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TVFK.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.FKART == TVFK.FKART`
Customer Group Customer Group Client	`P_CONSOLIDATIONFNDNWITHYTD.KDGRP == T151.KDGRP` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == T151.MANDT`
Controlling Area Client Controlling Area	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TKA01.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.KOKRS == TKA01.KOKRS`
Chart of Accounts Client Chart of Accounts	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T004.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.KTOPL == T004.KTOPL`
Customer Number Customer Number Client	`P_CONSOLIDATIONFNDNWITHYTD.KUNNR == KNA1.KUNNR` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == KNA1.MANDT`
Bill-to Party Bill-to Party Client	`P_CONSOLIDATIONFNDNWITHYTD.KUNRE == KNA1.KUNNR` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == KNA1.MANDT`
Ship-to Party Client Ship-to Party	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == KNA1.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.KUNWE == KNA1.KUNNR`
Country/Region Key Country/Region Key Client	`P_CONSOLIDATIONFNDNWITHYTD.LAND1 == T005.LAND1` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == T005.MANDT`
Account Number of Supplier Account Number of Supplier Client	`P_CONSOLIDATIONFNDNWITHYTD.LIFNR == LFA1.LIFNR` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == LFA1.MANDT`
Product Sold Group Client Product Sold Group	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T023.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.MATKL == T023.MATKL`
Material Group Client Material Group	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T023.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.MATKL_MM == T023.MATKL`
Material Number Client Material Number	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == MARA.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.MATNR == MARA.MATNR`
Product Sold Client Product Sold	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == MARA.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.MATNR_COPA == MARA.MATNR`
Partner Profit Center ? Client Controlling Area Partner Profit Center	`P_CONSOLIDATIONFNDNWITHYTD.[column in domain "DATBI"] == CEPC.DATBI` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == CEPC.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.KOKRS == CEPC.KOKRS` `P_CONSOLIDATIONFNDNWITHYTD.PPRCTR == CEPC.PRCTR`
Profit Center ? Client Profit Center Controlling Area	`P_CONSOLIDATIONFNDNWITHYTD.[column in domain "DATBI"] == CEPC.DATBI` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == CEPC.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.PRCTR == CEPC.PRCTR` `P_CONSOLIDATIONFNDNWITHYTD.KOKRS == CEPC.KOKRS`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == FAGL_SEGM.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.PSEGMENT == FAGL_SEGM.SEGMENT`
Account Number Client Account Number Original company code	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == SKB1.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RACCT == SKB1.SAKNR` `P_CONSOLIDATIONFNDNWITHYTD.ROBUKRS == SKB1.BUKRS`
Company ID of Trading Partner Client Company ID of Trading Partner	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T880.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RASSC == T880.RCOMP`
Consolidation Unit Client Consolidation Unit Dimension	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF160.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RBUNIT == TF160.BUNIT` `P_CONSOLIDATIONFNDNWITHYTD.RDIMEN == TF160.DIMEN`
Partner Unit Client Dimension Partner Unit	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF160.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RDIMEN == TF160.DIMEN` `P_CONSOLIDATIONFNDNWITHYTD.RBUPTR == TF160.BUNIT`
Business Area Client Business Area	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TGSB.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RBUSA == TGSB.GSBER`
Cost Center ? Client Controlling Area Cost Center	`P_CONSOLIDATIONFNDNWITHYTD.[column in domain "DATBI"] == CSKS.DATBI` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == CSKS.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.KOKRS == CSKS.KOKRS` `P_CONSOLIDATIONFNDNWITHYTD.RCNTR == CSKS.KOSTL`
Company Client Company	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T880.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RCOMP == T880.RCOMP`
Consolidation Group Client Consolidation Group Dimension	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF180.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RCONGR == TF180.CONGR` `P_CONSOLIDATIONFNDNWITHYTD.RDIMEN == TF180.DIMEN`
Dimension Client Dimension	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF150.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RDIMEN == TF150.DIMEN`
Functional Area Client Functional Area	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TFKB.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RFAREA == TFKB.FKBER`
Consolidation Chart of Accounts Client Consolidation Chart of Accounts	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF120.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RITCLG == TF120.ITCLG`
Financial Statement Item Client Financial Statement Item Consolidation Chart of Accounts	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF100.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RITEM == TF100.ITEM` `P_CONSOLIDATIONFNDNWITHYTD.RITCLG == TF100.ITCLG`
Ledger Client Ledger	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T881.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RLDNR == T881.RLDNR`
Transaction type Client Transaction type	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T856.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RMVCT == T856.TRTYP`
Original company code Client Original company code	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T001.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.ROBUKRS == T001.BUKRS`
Currency Key Client Currency Key	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TCURC.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RTCUR == TCURC.WAERS`
Base Unit of Measure Client Base Unit of Measure	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T006.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RUNIT == T006.MSEHI`
Consolidation Version Client Consolidation Version	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF200.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.RVERS == TF200.RVERS`
Trading partner's business area Client Trading partner's business area	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TGSB.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.SBUSA == TGSB.GSBER`
Sender cost center ? Client Controlling Area Sender cost center	`P_CONSOLIDATIONFNDNWITHYTD.[column in domain "DATBI"] == CSKS.DATBI` `P_CONSOLIDATIONFNDNWITHYTD.MANDT == CSKS.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.KOKRS == CSKS.KOKRS` `P_CONSOLIDATIONFNDNWITHYTD.SCNTR == CSKS.KOSTL`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == FAGL_SEGM.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.SEGMENT == FAGL_SEGM.SEGMENT`
Partner Functional Area Client Partner Functional Area	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TFKB.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.SFAREA == TFKB.FKBER`
Subitem Category Client Subitem Category	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF110.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.SITYP == TF110.SITYP`
Division Client Division	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TSPA.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.SPART == TSPA.SPART`
Subitem Client Subitem Subitem Category	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TF115.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.SUBIT == TF115.SITEM` `P_CONSOLIDATIONFNDNWITHYTD.SITYP == TF115.SITYP`
User Name Client User Name	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == USR02.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.USNAM == USR02.BNAME`
Sales Organization Client Sales Organization	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TVKO.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.VKORG == TVKO.VKORG`
Distribution Channel Client Distribution Channel	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == TVTW.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.VTWEG == TVTW.VTWEG`
Plant Client Plant	`P_CONSOLIDATIONFNDNWITHYTD.MANDT == T001W.MANDT` `P_CONSOLIDATIONFNDNWITHYTD.WERKS == T001W.WERKS`