JV_ACDOCA

JVA view on ACDOCA | view: CJVACDOCA | TRAN | Extraction: Not supported | Component: Joint Venture Accounting
Tables used: AFKO, AFVC, ACDOCA, T001, TKA02, T8JS, FINSC_LEDGER, T8JZ, FINSC_ACTVE_APPL, T8JZ
Column Name Description
rldnr FK Ledger in General Ledger Accounting
rbukrs FK Company Code
gjahr Fiscal Year
belnr Document Number of an Accounting Document
docln Six-Character Posting Item for Ledger
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
💲 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
Column Name Description
📏 Base Unit of Measure (runit):
msl Quantity
Column Name Description
budat Posting Date in the Document
valut Value date
bldat Document Date in Document
prodper Production Month (Date to find period and year)
billm Billing Month
pom Processing operational month
cpudt Day On Which Accounting Document Was Entered
cputm Time of Entry
Column Name Description
drcrk Debit/Credit Indicator Show values
Column Name Description Domain name
buzei Number of Line Item Within Accounting Document BUZEI
co_belnr Document Number CO_BELNR
co_buzei Posting Row BUZEI
vorgn Transaction Type for General Ledger VORGN
ryear General Ledger Fiscal Year GJAHR
poper Posting period POPER
awref Reference document number AWREF
aworg Reference Organizational Units AWORG
awitem Reference Document Line Item NUMC6
prec_awref Preceding Document Reference Document Number AWREF
prec_aworg Preceding Document Reference Organizational Units AWORG
prec_awitem Preceding Reference Document Line Item NUMC6
src_awref Source Document Number AWREF
src_aworg Organizational Unit of Source Document AWORG
src_awitem Line Item in Source Document NUMC6
sgtxt Item Text TEXT50
ktosl Transaction Key CHAR3
rcntr Cost Center KOSTL
aufnr Order Number AUFNR
ps_psp_pnr Work Breakdown Structure Element (WBS Element) PS_POSNR
nplnr Network Number for Account Assignment AUFNR
nplnr_vorgn Network Number for Account Assignment AUFNR
aufpl Routing number of operations in the order AUFPL
aplzl General counter for order CO_APLZL
vornr Operation/Activity Number VORNR
jvactivity JVA Activity (Joint Venture Accounting)
cbrunid Cutback Run ID (Joint Venture Accounting) TZNTSTMPL
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • JV_ACDOCA.MANDT == TABW.MANDT
  • JV_ACDOCA.ANBWA == TABW.BWASL
Asset Subnumber
  • Client
  • Asset Subnumber
  • Main Asset Number
  • ?
  • JV_ACDOCA.MANDT == ANLA.MANDT
  • JV_ACDOCA.ANLN2 == ANLA.ANLN2
  • JV_ACDOCA.ANLN1 == ANLA.ANLN1
  • JV_ACDOCA.[column in domain "BUKRS"] == ANLA.BUKRS
Logical system of source document JV_ACDOCA.AWSYS == TBDLS.LOGSYS
Reference procedure JV_ACDOCA.AWTYP == TTYP.AWTYP
Document Type
  • Client
  • Document Type
  • JV_ACDOCA.MANDT == T003.MANDT
  • JV_ACDOCA.BLART == T003.BLART
Billing Indicator
  • Client
  • Billing Indicator
  • JV_ACDOCA.MANDT == T8JA.MANDT
  • JV_ACDOCA.BTYPE == T8JA.BILIND
Equity group
  • Equity group
  • Client
  • Joint venture
  • ?
  • JV_ACDOCA.EGRUP == T8JF.EGRUP
  • JV_ACDOCA.MANDT == T8JF.MANDT
  • JV_ACDOCA.VNAME == T8JF.VNAME
  • JV_ACDOCA.[column in domain "BUKRS"] == T8JF.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • JV_ACDOCA.MANDT == TKA01.MANDT
  • JV_ACDOCA.KOKRS == TKA01.KOKRS
Customer Number
  • Client
  • Customer Number
  • JV_ACDOCA.MANDT == KNA1.MANDT
  • JV_ACDOCA.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • JV_ACDOCA.MANDT == LFA1.MANDT
  • JV_ACDOCA.LIFNR == LFA1.LIFNR
Activity Type
  • Client
  • Activity Type
  • ?
  • Controlling Area
  • JV_ACDOCA.MANDT == CSLA.MANDT
  • JV_ACDOCA.LSTAR == CSLA.LSTAR
  • JV_ACDOCA.[column in domain "DATBI"] == CSLA.DATBI
  • JV_ACDOCA.KOKRS == CSLA.KOKRS
Material Number
  • Material Number
  • Client
  • JV_ACDOCA.MATNR == MARA.MATNR
  • JV_ACDOCA.MANDT == MARA.MANDT
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • JV_ACDOCA.MANDT == T007A.MANDT
  • JV_ACDOCA.MWSKZ == T007A.MWSKZ
  • JV_ACDOCA.[column in domain "KALSM_D"] == T007A.KALSM
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • JV_ACDOCA.PRCTR == CEPC.PRCTR
  • JV_ACDOCA.MANDT == CEPC.MANDT
  • JV_ACDOCA.[column in domain "DATBI"] == CEPC.DATBI
  • JV_ACDOCA.KOKRS == CEPC.KOKRS
Logical System of Preceding Reference Document JV_ACDOCA.PREC_AWSYS == TBDLS.LOGSYS
Preceding Document Reference Transaction JV_ACDOCA.PREC_AWTYP == TTYP.AWTYP
Account Number
  • Account Number
  • Client
  • Company Code
  • JV_ACDOCA.RACCT == SKB1.SAKNR
  • JV_ACDOCA.MANDT == SKB1.MANDT
  • JV_ACDOCA.RBUKRS == SKB1.BUKRS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RBCUR == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • JV_ACDOCA.MANDT == T001.MANDT
  • JV_ACDOCA.RBUKRS == T001.BUKRS
Business Area
  • Client
  • Business Area
  • JV_ACDOCA.MANDT == TGSB.MANDT
  • JV_ACDOCA.RBUSA == TGSB.GSBER
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RCCUR == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RDCUR == TCURC.WAERS
Recovery Indicator
  • Client
  • Recovery Indicator
  • ?
  • JV_ACDOCA.MANDT == T8JJ.MANDT
  • JV_ACDOCA.RECID == T8JJ.RECID
  • JV_ACDOCA.[column in domain "BUKRS"] == T8JJ.BUKRS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RECUR == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RFCUR == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RGCUR == TCURC.WAERS
Company Code Currency
  • Client
  • Company Code Currency
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RHCUR == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RKCUR == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.ROCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • JV_ACDOCA.MANDT == T006.MANDT
  • JV_ACDOCA.RUNIT == T006.MSEHI
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RVCUR == TCURC.WAERS
Transaction Currency
  • Client
  • Transaction Currency
  • JV_ACDOCA.MANDT == TCURC.MANDT
  • JV_ACDOCA.RWCUR == TCURC.WAERS
Source Document System JV_ACDOCA.SRC_AWSYS == TBDLS.LOGSYS
Source Document Type JV_ACDOCA.SRC_AWTYP == TTYP.AWTYP
Joint venture
  • Client
  • Joint venture
  • ?
  • JV_ACDOCA.MANDT == T8JV.MANDT
  • JV_ACDOCA.VNAME == T8JV.VNAME
  • JV_ACDOCA.[column in domain "BUKRS"] == T8JV.BUKRS
Partner account number
  • Client
  • Partner account number
  • JV_ACDOCA.MANDT == KNA1.MANDT
  • JV_ACDOCA.VPTNR == KNA1.KUNNR