JV_JVSO1_ACDOCA_CLASSIC

JVSO1-like view on ACDOCA (classic) | view: CJVSO1_ACD_CL | TRAN | Extraction: Not supported | Component: Joint Venture Accounting
Tables used: AFKO, AFVC, ACDOCA, FAGL_SPLINFO, T001, TKA02, T8JS, FINSC_LEDGER, T8JZ, FINSC_ACTVE_APPL
Column Name Description
rldnr FK Ledger in General Ledger Accounting
rrcty Record Type Show values
rbukrs FK Company Code
gjahr Fiscal Year
docnr Document Number of an Accounting Document
docln Six-Character Posting Item for Ledger
Column Name Description
💲 Transaction Currency (rtcur):
tsl 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
bldat Document Date in Document
valut Value date
wsdat Translation date
cpudt null
cputm null
prodper Production Month (Date to find period and year)
billm Billing Month
pom Processing operational month
Column Name Description
rrcty Record Type Show values
drcrk Debit/Credit Indicator Show values
mig_source Source of a migrated journal entry item Show values
Column Name Description Domain name
ryear General Ledger Fiscal Year GJAHR
poper Posting period POPER
docct null
refdocnr Document Number CO_BELNR
refdocln Posting Row BUZEI
refdocct null
refryear Fiscal Year GJAHR
aworg Reference Organizational Units AWORG
reffidoc Document Number of an Accounting Document BELNR
reffidln Number of Line Item Within Accounting Document BUZEI
refawref Preceding Document Reference Document Number AWREF
refaworg Preceding Document Reference Organizational Units AWORG
sgtxt Item Text TEXT50
orecid Recovery Indicator JV_RECIND
refactiv Transaction Type for General Ledger VORGN
activ null
rcntr Cost Center KOSTL
rordnr Order Number AUFNR
rprojk Work Breakdown Structure Element (WBS Element) PS_POSNR
nplnr Network Number for Account Assignment AUFNR
aufpl Routing number of operations in the order AUFPL
aplzl Internal counter CIM_COUNT
ktosl Transaction Key CHAR3
mig_docln Item ID of migrated G/L line item DOCLN6
Master Data Relations Join Conditions
Reference procedure JV_JVSO1_ACDOCA_CLASSIC.AWTYP == TTYP.AWTYP
Billing Indicator
  • Client
  • Billing Indicator
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == T8JA.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.BILID == T8JA.BILIND
Customer Number
  • Customer Number
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.CBCUSTOMER == KNA1.KUNNR
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == KNA1.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == LFA1.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.CBVENDOR == LFA1.LIFNR
Document Type
  • Document Type
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.DOCTY == T003.BLART
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == T003.MANDT
Company Code Currency
  • Company Code Currency
  • Company Code Currency
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.HWAER == TCURC.WAERS
  • JV_JVSO1_ACDOCA_CLASSIC.RHCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
Logical system of source document JV_JVSO1_ACDOCA_CLASSIC.LOGSYS == TBDLS.LOGSYS
Activity Type
  • ?
  • Client
  • Controlling Area
  • Activity Type
  • JV_JVSO1_ACDOCA_CLASSIC.[column in domain "DATBI"] == CSLA.DATBI
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == CSLA.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RKOKRS == CSLA.KOKRS
  • JV_JVSO1_ACDOCA_CLASSIC.LSTAR == CSLA.LSTAR
Material Number
  • Material Number
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.MATNR == MARA.MATNR
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == MARA.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.MWSKZ == T007A.MWSKZ
  • JV_JVSO1_ACDOCA_CLASSIC.[column in domain "KALSM_D"] == T007A.KALSM
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == T007A.MANDT
Account Number
  • Account Number
  • Client
  • Company Code
  • JV_JVSO1_ACDOCA_CLASSIC.RACCT == SKB1.SAKNR
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == SKB1.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RBUKRS == SKB1.BUKRS
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TABW.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RANBWA == TABW.BWASL
Asset Subnumber
  • Asset Subnumber
  • Client
  • Main Asset Number
  • ?
  • JV_JVSO1_ACDOCA_CLASSIC.RANLN2 == ANLA.ANLN2
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == ANLA.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RANLN1 == ANLA.ANLN1
  • JV_JVSO1_ACDOCA_CLASSIC.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.RBCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
Company Code
  • Client
  • Company Code
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == T001.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RBUKRS == T001.BUKRS
Business Area
  • Business Area
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.RBUSA == TGSB.GSBER
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TGSB.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.RCCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RDCUR == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RECUR == TCURC.WAERS
Preceding Document Reference Transaction JV_JVSO1_ACDOCA_CLASSIC.REFAWTYP == TTYP.AWTYP
Logical System of Preceding Reference Document JV_JVSO1_ACDOCA_CLASSIC.REFLOGSYS == TBDLS.LOGSYS
Equity group
  • Joint venture
  • Client
  • ?
  • Equity group
  • JV_JVSO1_ACDOCA_CLASSIC.RJVNAM == T8JF.VNAME
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == T8JF.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.[column in domain "BUKRS"] == T8JF.BUKRS
  • JV_JVSO1_ACDOCA_CLASSIC.REGROU == T8JF.EGRUP
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RFCUR == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RGCUR == TCURC.WAERS
Company Code Currency
  • Company Code Currency
  • Company Code Currency
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.HWAER == TCURC.WAERS
  • JV_JVSO1_ACDOCA_CLASSIC.RHCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
Joint venture
  • Joint venture
  • Client
  • ?
  • JV_JVSO1_ACDOCA_CLASSIC.RJVNAM == T8JV.VNAME
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == T8JV.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.[column in domain "BUKRS"] == T8JV.BUKRS
Global Currency
  • Client
  • Global Currency
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RKCUR == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TKA01.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RKOKRS == TKA01.KOKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.ROCUR == TCURC.WAERS
Partner account number
  • Partner account number
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.RPARTN == KNA1.KUNNR
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == KNA1.MANDT
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • JV_JVSO1_ACDOCA_CLASSIC.[column in domain "DATBI"] == CEPC.DATBI
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == CEPC.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RKOKRS == CEPC.KOKRS
  • JV_JVSO1_ACDOCA_CLASSIC.RPRCTR == CEPC.PRCTR
Recovery Indicator
  • Client
  • Recovery Indicator
  • ?
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == T8JJ.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RRECIN == T8JJ.RECID
  • JV_JVSO1_ACDOCA_CLASSIC.[column in domain "BUKRS"] == T8JJ.BUKRS
Transaction Currency
  • Client
  • Transaction Currency
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RTCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == T006.MANDT
  • JV_JVSO1_ACDOCA_CLASSIC.RUNIT == T006.MSEHI
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • JV_JVSO1_ACDOCA_CLASSIC.RVCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA_CLASSIC.MANDT == TCURC.MANDT