Fins_Rev_Rec_Acdoca_Balance

Acdoca balance for introducing a new accounting principle | view: FINSRR_ACDOCABAL | Extraction: Not supported | Component: Event-Based Revenue Recognition

Tables used: ACDOCA, T000, FINSC_LD_CMP

🔑 Keys
💰 Amounts (13)
∑ Quantities (1)
📅 Dates
☰ Categorical
Other (5)
🔗 Relations (27)

Column Name	Description

Column Name	Description
wsl	null
hsl	null
ksl	null
kfsl	null
osl	null
vsl	null
bsl	null
csl	null
dsl	null
esl	null
fsl	null
gsl	null
co_osl	null

Column Name	Description
msl	null

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
ps_posid	Work Breakdown Structure Element (WBS Element)	PS_POSID
ps_psp_pnr	Work Breakdown Structure Element (WBS Element)	PS_POSNR
kdpos	Item number in Sales Order	NUM06
pernr	Personnel Number	PERNR
accas	Account Assignment	ACCAS

Master Data Relations	Join Conditions
Order Number Order Number Client	`FINS_REV_REC_ACDOCA_BALANCE.AUFNR == AUFK.AUFNR` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == AUFK.MANDT`
Profit Center ? Profit Center ? Client	`FINS_REV_REC_ACDOCA_BALANCE.[column in domain "DATBI"] == CEPC.DATBI` `FINS_REV_REC_ACDOCA_BALANCE.PRCTR == CEPC.PRCTR` `FINS_REV_REC_ACDOCA_BALANCE.[column in domain "KOKRS"] == CEPC.KOKRS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == CEPC.MANDT`
Account Number Account Number Company Code Client	`FINS_REV_REC_ACDOCA_BALANCE.RACCT == SKB1.SAKNR` `FINS_REV_REC_ACDOCA_BALANCE.RBUKRS == SKB1.BUKRS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == SKB1.MANDT`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`FINS_REV_REC_ACDOCA_BALANCE.RBCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Company Code Company Code Client	`FINS_REV_REC_ACDOCA_BALANCE.RBUKRS == T001.BUKRS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == T001.MANDT`
Business Area Business Area Client	`FINS_REV_REC_ACDOCA_BALANCE.RBUSA == TGSB.GSBER` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TGSB.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`FINS_REV_REC_ACDOCA_BALANCE.RCCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
CO Object Currency CO Object Currency Client	`FINS_REV_REC_ACDOCA_BALANCE.RCO_OCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Freely Defined Currency 5 Client Freely Defined Currency 5	`FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_BALANCE.RDCUR == TCURC.WAERS`
Freely Defined Currency 6 Freely Defined Currency 6 Client	`FINS_REV_REC_ACDOCA_BALANCE.RECUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Freely Defined Currency 7 Freely Defined Currency 7 Client	`FINS_REV_REC_ACDOCA_BALANCE.RFCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Freely Defined Currency 8 Freely Defined Currency 8 Client	`FINS_REV_REC_ACDOCA_BALANCE.RGCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Company Code Currency Company Code Currency Client	`FINS_REV_REC_ACDOCA_BALANCE.RHCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Global Currency Client Global Currency	`FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_BALANCE.RKCUR == TCURC.WAERS`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Client	`FINS_REV_REC_ACDOCA_BALANCE.RLDNR == FINSC_LEDGER.RLDNR` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == FINSC_LEDGER.MANDT`
Freely Defined Currency 1 Freely Defined Currency 1 Client	`FINS_REV_REC_ACDOCA_BALANCE.ROCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Resource ? Resource ? Client	`FINS_REV_REC_ACDOCA_BALANCE.[column in domain "DATBI"] == CSKR.DATBI` `FINS_REV_REC_ACDOCA_BALANCE.RSRCE == CSKR.RESRC` `FINS_REV_REC_ACDOCA_BALANCE.[column in domain "KOKRS"] == CSKR.KOKRS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == CSKR.MANDT`
Base Unit of Measure Base Unit of Measure Client	`FINS_REV_REC_ACDOCA_BALANCE.RUNIT == T006.MSEHI` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == T006.MANDT`
Freely Defined Currency 2 Freely Defined Currency 2 Client	`FINS_REV_REC_ACDOCA_BALANCE.RVCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Transaction Currency Transaction Currency Client	`FINS_REV_REC_ACDOCA_BALANCE.RWCUR == TCURC.WAERS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == TCURC.MANDT`
Service Contract ID Service Contract Item ID Service Contract ID Client ?	`FINS_REV_REC_ACDOCA_BALANCE.SERVICE_CONTRACT_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `FINS_REV_REC_ACDOCA_BALANCE.SERVICE_CONTRACT_ID == FCO_SRVDOC.SERVICE_DOC_ID` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == FCO_SRVDOC.MANDT` `FINS_REV_REC_ACDOCA_BALANCE.[column in domain "FCO_SRVDOC_TYPE"] == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Item ID Service Contract Item ID Service Contract ID Client ?	`FINS_REV_REC_ACDOCA_BALANCE.SERVICE_CONTRACT_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `FINS_REV_REC_ACDOCA_BALANCE.SERVICE_CONTRACT_ID == FCO_SRVDOC.SERVICE_DOC_ID` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == FCO_SRVDOC.MANDT` `FINS_REV_REC_ACDOCA_BALANCE.[column in domain "FCO_SRVDOC_TYPE"] == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Document ID Service Document Item ID ? Client Service Document ID	`FINS_REV_REC_ACDOCA_BALANCE.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `FINS_REV_REC_ACDOCA_BALANCE.[column in domain "FCO_SRVDOC_TYPE"] == FCO_SRVDOC.SERVICE_DOC_TYPE` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == FCO_SRVDOC.MANDT` `FINS_REV_REC_ACDOCA_BALANCE.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID`
Service Document Item ID Service Document Item ID ? Client Service Document ID	`FINS_REV_REC_ACDOCA_BALANCE.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `FINS_REV_REC_ACDOCA_BALANCE.[column in domain "FCO_SRVDOC_TYPE"] == FCO_SRVDOC.SERVICE_DOC_TYPE` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == FCO_SRVDOC.MANDT` `FINS_REV_REC_ACDOCA_BALANCE.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID`
Subledger-Specific Line Item Type	`FINS_REV_REC_ACDOCA_BALANCE.SLALITTYPE == FINSTS_SLALITTY.SLALITTYPE`
Plant Plant Client	`FINS_REV_REC_ACDOCA_BALANCE.WERKS == T001W.WERKS` `FINS_REV_REC_ACDOCA_BALANCE.MANDT == T001W.MANDT`