Fins_Rev_Rec_Acdoca_View

View on ACDOCA | view: FINS_RR_ACDOCA | Extraction: Not supported | Component: Event-Based Revenue Recognition

Tables used: ACDOCA, BKPF, T000

🔑 Keys
💰 Amounts (13)
∑ Quantities (4)
📅 Dates (5)
☰ Categorical (9)
Other (34)
🔗 Relations (61)

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
kfsl	Fixed Amount in Global Currency
💲 Freely Defined Currency 1 (rocur):
osl	Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (rvcur):
vsl	Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (rbcur):
bsl	Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (rccur):
csl	Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (rdcur):
dsl	Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (recur):
esl	Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (rfcur):
fsl	Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (rgcur):
gsl	Amount in Freely Defined Currency 8
💲 CO Object Currency (rco_ocur):
co_osl	Amount in CO Object Currency

Column Name	Description
📏 Base Unit of Measure (runit):
msl	Quantity
📏 Unit of Measure for Valuation Quantity (rvunit):
vmsl	Valuation quantity
📏 Unit of Measure for Reference Quantity (rrunit):
rmsl	Reference quantity
📏 Unit of Measure for CO Valuation Quantity (co_meinh):
co_megbtr	CO Valuation Quantity

Column Name	Description
budat	Posting Date in the Document
bldat	Document Date in Document
wwert	Translation date
fbuda	Date on which services are rendered
bzdat	Asset Value Date

Column Name	Description
xreversing	Indicator: Item is Reversing Another Item	Show values
xreversed	Indicator: Item is Reversed	Show values
xtruerev	Indicator: True reversal (i.e. cancellation)	Show values
scope	Object Class	Show values
beltp	Debit Type	Show values
drcrk	Debit/Credit Indicator	Show values
coind	Checkbox	Show values
trr_partial_ind	Partial Processing Indicator	Show values
aggregation_level	Aggregation level for the line item view of support monitor	Show values

Column Name	Description	Domain name
belnr	Document Number of an Accounting Document	BELNR
docln	Six-Character Posting Item for Ledger	DOCLN6
vorgn	Transaction Type for General Ledger	VORGN
bttype_tec	Technical Business Transaction Type	J_VORGANG
aworg	Reference Organizational Units	AWORG
awref	Reference document number	AWREF
awitem	Reference Document Line Item	NUMC6
awitgrp	Group of Reference Document Line Items	NUMC6
subta	Partial Document to be balanced to zero	NUMC6
co_belnr	Document Number	CO_BELNR
co_buzei	Posting Row	BUZEI
aworg_rev	Reversal: Reference Organizations of Document to Be Reversed	AWORG
awref_rev	Reversal: Reference Document No. of Document to Be Reversed	AWREF
ps_pspid	Project definition	PS_PSPID
ps_posid	Work Breakdown Structure Element (WBS Element)	PS_POSID
ps_psp_pnr	Work Breakdown Structure Element (WBS Element)	PS_POSNR
paobjnr	Profitability Segment Number (CO-PA)	RKEOBJNR
nplnr_vorgn	Network activity	VORNR
kdpos	Item number in Sales Order	NUM06
solution_order_id	Solution Order ID	CRM_OBJECT_ID
solution_order_item_id	Solution Order Item ID	CRMS4_NUMBER_INT
accas	Account Assignment	ACCAS
docyear	Fiscal Year	GJAHR
gjahr	General Ledger Fiscal Year	GJAHR
poper	Posting period	POPER
fiscyearper	Period/Year	JAHRPER
gkont	Offsetting Account Number	GKONT
ktosl	Transaction Key	CHAR3
work_item_id	Work Item ID	/CPD/PFP_WORKITEM_ID
pernr	Personnel Number	PERNR
overtimecat	Overtime Category	CATS_OVERTIME_CATEGORY
sgtxt	Item Text	TEXT50
timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
no_of_items	Number of line items

Master Data Relations	Join Conditions
Order Number Client Order Number	`FINS_REV_REC_ACDOCA_VIEW.MANDT == AUFK.MANDT` `FINS_REV_REC_ACDOCA_VIEW.AUFNR == AUFK.AUFNR`
Logical system of source document	`FINS_REV_REC_ACDOCA_VIEW.AWSYS == TBDLS.LOGSYS`
Reference procedure	`FINS_REV_REC_ACDOCA_VIEW.AWTYP == TTYP.AWTYP`
Reversal: Reference Transaction of Document to Be Reversed	`FINS_REV_REC_ACDOCA_VIEW.AWTYP_REV == TTYP.AWTYP`
Accounting Indicator Client Accounting Indicator	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TBMOT.MANDT` `FINS_REV_REC_ACDOCA_VIEW.BEMOT == TBMOT.BEMOT`
Document Type Client Document Type	`FINS_REV_REC_ACDOCA_VIEW.MANDT == T003.MANDT` `FINS_REV_REC_ACDOCA_VIEW.BLART == T003.BLART`
Posting Key Client Posting Key	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TBSL.MANDT` `FINS_REV_REC_ACDOCA_VIEW.BSCHL == TBSL.BSCHL`
Business Transaction Category Client Business Transaction Category	`FINS_REV_REC_ACDOCA_VIEW.MANDT == FINSC_BTTYPE.MANDT` `FINS_REV_REC_ACDOCA_VIEW.BTTYPE == FINSC_BTTYPE.BTTYPE`
Company Code Client Company Code	`FINS_REV_REC_ACDOCA_VIEW.MANDT == T001.MANDT` `FINS_REV_REC_ACDOCA_VIEW.BUKRS == T001.BUKRS`
Functional Area Client Functional Area	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TFKB.MANDT` `FINS_REV_REC_ACDOCA_VIEW.FKBER == TFKB.FKBER`
Business Area Client Business Area	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TGSB.MANDT` `FINS_REV_REC_ACDOCA_VIEW.GSBER == TGSB.GSBER`
Origin Group as Subdivision of Cost Element ? Client Origin Group as Subdivision of Cost Element ?	`FINS_REV_REC_ACDOCA_VIEW.[column in domain "HRKTYP"] == TKKH1.KOATY` `FINS_REV_REC_ACDOCA_VIEW.MANDT == TKKH1.MANDT` `FINS_REV_REC_ACDOCA_VIEW.HKGRP == TKKH1.HRKFT` `FINS_REV_REC_ACDOCA_VIEW.[column in domain "KOKRS"] == TKKH1.KOKRS`
Account Number Client Company Code Account Number	`FINS_REV_REC_ACDOCA_VIEW.MANDT == SKB1.MANDT` `FINS_REV_REC_ACDOCA_VIEW.BUKRS == SKB1.BUKRS` `FINS_REV_REC_ACDOCA_VIEW.HKONT == SKB1.SAKNR`
CO key subnumber Client CO key subnumber	`FINS_REV_REC_ACDOCA_VIEW.MANDT == COKEY.MANDT` `FINS_REV_REC_ACDOCA_VIEW.HRKFT == COKEY.HRKFT`
Customer Number Customer Number Client	`FINS_REV_REC_ACDOCA_VIEW.KUNNR == KNA1.KUNNR` `FINS_REV_REC_ACDOCA_VIEW.MANDT == KNA1.MANDT`
Account Number of Supplier Client Account Number of Supplier	`FINS_REV_REC_ACDOCA_VIEW.MANDT == LFA1.MANDT` `FINS_REV_REC_ACDOCA_VIEW.LIFNR == LFA1.LIFNR`
Material Number Client Material Number	`FINS_REV_REC_ACDOCA_VIEW.MANDT == MARA.MANDT` `FINS_REV_REC_ACDOCA_VIEW.MATNR == MARA.MATNR`
Product Sold Client Product Sold	`FINS_REV_REC_ACDOCA_VIEW.MANDT == MARA.MANDT` `FINS_REV_REC_ACDOCA_VIEW.MATNR_COPA == MARA.MATNR`
Network Number for Account Assignment Network Number for Account Assignment Client	`FINS_REV_REC_ACDOCA_VIEW.NPLNR == AUFK.AUFNR` `FINS_REV_REC_ACDOCA_VIEW.MANDT == AUFK.MANDT`
Trading partner's business area Client Trading partner's business area	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TGSB.MANDT` `FINS_REV_REC_ACDOCA_VIEW.PARGB == TGSB.GSBER`
Company Code of Partner Company Code of Partner Client	`FINS_REV_REC_ACDOCA_VIEW.PBUKRS == T001.BUKRS` `FINS_REV_REC_ACDOCA_VIEW.MANDT == T001.MANDT`
Fiscal Year Variant Client Fiscal Year Variant	`FINS_REV_REC_ACDOCA_VIEW.MANDT == T009.MANDT` `FINS_REV_REC_ACDOCA_VIEW.PERIV == T009.PERIV`
Partner Functional Area Client Partner Functional Area	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TFKB.MANDT` `FINS_REV_REC_ACDOCA_VIEW.PFKBER == TFKB.FKBER`
Partner Profit Center ? Client ? Partner Profit Center	`FINS_REV_REC_ACDOCA_VIEW.[column in domain "DATBI"] == CEPC.DATBI` `FINS_REV_REC_ACDOCA_VIEW.MANDT == CEPC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.[column in domain "KOKRS"] == CEPC.KOKRS` `FINS_REV_REC_ACDOCA_VIEW.PPRCTR == CEPC.PRCTR`
Profit Center ? Client ? Profit Center	`FINS_REV_REC_ACDOCA_VIEW.[column in domain "DATBI"] == CEPC.DATBI` `FINS_REV_REC_ACDOCA_VIEW.MANDT == CEPC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.[column in domain "KOKRS"] == CEPC.KOKRS` `FINS_REV_REC_ACDOCA_VIEW.PRCTR == CEPC.PRCTR`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`FINS_REV_REC_ACDOCA_VIEW.PSEGMENT == FAGL_SEGM.SEGMENT` `FINS_REV_REC_ACDOCA_VIEW.MANDT == FAGL_SEGM.MANDT`
Project (internal) Client Project (internal)	`FINS_REV_REC_ACDOCA_VIEW.MANDT == PROJ.MANDT` `FINS_REV_REC_ACDOCA_VIEW.PS_PRJ_PNR == PROJ.PSPNR`
Freely Defined Currency 3 Client Freely Defined Currency 3	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RBCUR == TCURC.WAERS`
Freely Defined Currency 4 Client Freely Defined Currency 4	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RCCUR == TCURC.WAERS`
CO Object Currency Client CO Object Currency	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RCO_OCUR == TCURC.WAERS`
Freely Defined Currency 5 Client Freely Defined Currency 5	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RDCUR == TCURC.WAERS`
Freely Defined Currency 6 Client Freely Defined Currency 6	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RECUR == TCURC.WAERS`
Freely Defined Currency 7 Client Freely Defined Currency 7	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RFCUR == TCURC.WAERS`
Freely Defined Currency 8 Client Freely Defined Currency 8	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RGCUR == TCURC.WAERS`
Company Code Currency Client Company Code Currency	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RHCUR == TCURC.WAERS`
Global Currency Client Global Currency	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RKCUR == TCURC.WAERS`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`FINS_REV_REC_ACDOCA_VIEW.MANDT == FINSC_LEDGER.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RLDNR == FINSC_LEDGER.RLDNR`
Freely Defined Currency 1 Client Freely Defined Currency 1	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.ROCUR == TCURC.WAERS`
Unit of Measure for Reference Quantity Client Unit of Measure for Reference Quantity	`FINS_REV_REC_ACDOCA_VIEW.MANDT == T006.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RRUNIT == T006.MSEHI`
Resource ? Client ? Resource	`FINS_REV_REC_ACDOCA_VIEW.[column in domain "DATBI"] == CSKR.DATBI` `FINS_REV_REC_ACDOCA_VIEW.MANDT == CSKR.MANDT` `FINS_REV_REC_ACDOCA_VIEW.[column in domain "KOKRS"] == CSKR.KOKRS` `FINS_REV_REC_ACDOCA_VIEW.RSRCE == CSKR.RESRC`
Base Unit of Measure Client Base Unit of Measure	`FINS_REV_REC_ACDOCA_VIEW.MANDT == T006.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RUNIT == T006.MSEHI`
Freely Defined Currency 2 Client Freely Defined Currency 2	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RVCUR == TCURC.WAERS`
Unit of Measure for Valuation Quantity Client Unit of Measure for Valuation Quantity	`FINS_REV_REC_ACDOCA_VIEW.MANDT == T006.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RVUNIT == T006.MSEHI`
Transaction Currency Client Transaction Currency	`FINS_REV_REC_ACDOCA_VIEW.MANDT == TCURC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.RWCUR == TCURC.WAERS`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`FINS_REV_REC_ACDOCA_VIEW.MANDT == FAGL_SEGM.MANDT` `FINS_REV_REC_ACDOCA_VIEW.SEGMENT == FAGL_SEGM.SEGMENT`
Service Contract ID Client Service Contract ID Service Contract Item ID Service Contract Type	`FINS_REV_REC_ACDOCA_VIEW.MANDT == FCO_SRVDOC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_CONTRACT_ID == FCO_SRVDOC.SERVICE_DOC_ID` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_CONTRACT_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_CONTRACT_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Item ID Client Service Contract ID Service Contract Item ID Service Contract Type	`FINS_REV_REC_ACDOCA_VIEW.MANDT == FCO_SRVDOC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_CONTRACT_ID == FCO_SRVDOC.SERVICE_DOC_ID` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_CONTRACT_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_CONTRACT_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE`
Service Contract Type Client Service Contract Type	`FINS_REV_REC_ACDOCA_VIEW.MANDT == CRMC_PROC_TYPE.CLIENT` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_CONTRACT_TYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Service Document ID Client Service Document Type Service Document Item ID Service Document ID	`FINS_REV_REC_ACDOCA_VIEW.MANDT == FCO_SRVDOC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID`
Service Document Item ID Client Service Document Type Service Document Item ID Service Document ID	`FINS_REV_REC_ACDOCA_VIEW.MANDT == FCO_SRVDOC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_DOC_TYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_DOC_ITEM_ID == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_DOC_ID == FCO_SRVDOC.SERVICE_DOC_ID`
Service Document Type Client Service Document Type	`FINS_REV_REC_ACDOCA_VIEW.MANDT == CRMC_PROC_TYPE.CLIENT` `FINS_REV_REC_ACDOCA_VIEW.SERVICE_DOC_TYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Subledger-Specific Line Item Type	`FINS_REV_REC_ACDOCA_VIEW.SLALITTYPE == FINSTS_SLALITTY.SLALITTYPE`
Origin cost center ? Client Origin cost center ?	`FINS_REV_REC_ACDOCA_VIEW.[column in domain "DATBI"] == CSKS.DATBI` `FINS_REV_REC_ACDOCA_VIEW.MANDT == CSKS.MANDT` `FINS_REV_REC_ACDOCA_VIEW.UKOSTL == CSKS.KOSTL` `FINS_REV_REC_ACDOCA_VIEW.[column in domain "KOKRS"] == CSKS.KOKRS`
Origin activity ? Client Origin activity ?	`FINS_REV_REC_ACDOCA_VIEW.[column in domain "DATBI"] == CSLA.DATBI` `FINS_REV_REC_ACDOCA_VIEW.MANDT == CSLA.MANDT` `FINS_REV_REC_ACDOCA_VIEW.ULSTAR == CSLA.LSTAR` `FINS_REV_REC_ACDOCA_VIEW.[column in domain "KOKRS"] == CSLA.KOKRS`
Origin Profit Center ? Client Origin Profit Center ?	`FINS_REV_REC_ACDOCA_VIEW.[column in domain "DATBI"] == CEPC.DATBI` `FINS_REV_REC_ACDOCA_VIEW.MANDT == CEPC.MANDT` `FINS_REV_REC_ACDOCA_VIEW.UPRCTR == CEPC.PRCTR` `FINS_REV_REC_ACDOCA_VIEW.[column in domain "KOKRS"] == CEPC.KOKRS`
Source: Business Process ? Client ? Source: Business Process	`FINS_REV_REC_ACDOCA_VIEW.[column in domain "DATBI"] == CBPR.DATBI` `FINS_REV_REC_ACDOCA_VIEW.MANDT == CBPR.MANDT` `FINS_REV_REC_ACDOCA_VIEW.[column in domain "KOKRS"] == CBPR.KOKRS` `FINS_REV_REC_ACDOCA_VIEW.UPRZNR == CBPR.PRZNR`
Company ID of Trading Partner Client Company ID of Trading Partner	`FINS_REV_REC_ACDOCA_VIEW.MANDT == T880.MANDT` `FINS_REV_REC_ACDOCA_VIEW.VBUND == T880.RCOMP`
Identification of a Provider Contract Client Identification of a Provider Contract	`FINS_REV_REC_ACDOCA_VIEW.MANDT == DFKK_VT_H.MANDT` `FINS_REV_REC_ACDOCA_VIEW.VTKEY == DFKK_VT_H.VTKEY`
Contract: Item Number Client Contract: Item Number Identification of a Provider Contract	`FINS_REV_REC_ACDOCA_VIEW.MANDT == DFKK_VT_I.MANDT` `FINS_REV_REC_ACDOCA_VIEW.VTPOS == DFKK_VT_I.VTPOS` `FINS_REV_REC_ACDOCA_VIEW.VTKEY == DFKK_VT_I.VTKEY`
Plant Client Plant	`FINS_REV_REC_ACDOCA_VIEW.MANDT == T001W.MANDT` `FINS_REV_REC_ACDOCA_VIEW.WERKS == T001W.WERKS`