Fins_Rev_Rec_Data_View2

Data of trans. based revenue recog. for cumulative process. | view: FINS_RR_DATA2 | Extraction: Not supported | Component: Event-Based Revenue Recognition

Tables used: ACDOCA, FINSC_LD_CMP

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

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
max_budat	null

Column Name	Description
rtind	Real Time Indicator	Show values

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
ps_pspid	Project definition	PS_PSPID
paobjnr	Profitability Segment Number (CO-PA)	RKEOBJNR
kdpos	Item number in Sales Order	NUM06
gkont	Offsetting Account Number	GKONT
pernr	Personnel Number	PERNR

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