JV_JVTO1_ACDOCA_SWITCH_2

JVTO1-like view on ACDOCA w/ JV ledgers | view: CJVTO1_ACD_SW2 | TRAN | Extraction: Not supported | Component: Joint Venture Accounting
Tables used: AFKO, AFVC, ACDOCA, JVTO1, T8JTPM, T001, TKA02, T8JS, FINSC_LEDGER, T001, T881, T882, FINSC_LEDGER, T881, T882, T8JZ, FINSC_ACTVE_APPL, FINSC_LD_CMP, JVAONACDOCAACTIV, FINSC_LD_CMP
Column Name Description
rldnr Ledger
rrcty Record Type Show values
rvers Version
ryear Fiscal Year
robjnr Object number for objects (account assignment elements)
cobjnr Object number for transaction attributes
sobjnr Object number for partner objects (accnt assignmnt elements)
rtcur FK Currency Key
runit FK Base Unit of Measure
drcrk Debit/Credit Indicator Show values
rpmax Period
Column Name Description
💲 Currency Key (rtcur):
tslvt null
tsl01 null
tsl02 null
tsl03 null
tsl04 null
tsl05 null
tsl06 null
tsl07 null
tsl08 null
tsl09 null
tsl10 null
tsl11 null
tsl12 null
tsl13 null
tsl14 null
tsl15 null
tsl16 null
💲 null (curr1_4a):
hslvt null
hsl01 null
hsl02 null
hsl03 null
hsl04 null
hsl05 null
hsl06 null
hsl07 null
hsl08 null
hsl09 null
hsl10 null
hsl11 null
hsl12 null
hsl13 null
hsl14 null
hsl15 null
hsl16 null
💲 null (curr2_4a):
kslvt null
ksl01 null
ksl02 null
ksl03 null
ksl04 null
ksl05 null
ksl06 null
ksl07 null
ksl08 null
ksl09 null
ksl10 null
ksl11 null
ksl12 null
ksl13 null
ksl14 null
ksl15 null
ksl16 null
💲 null (curr1_4c):
hslvt_4c null
hsl01_4c null
hsl02_4c null
hsl03_4c null
hsl04_4c null
hsl05_4c null
hsl06_4c null
hsl07_4c null
hsl08_4c null
hsl09_4c null
hsl10_4c null
hsl11_4c null
hsl12_4c null
hsl13_4c null
hsl14_4c null
hsl15_4c null
hsl16_4c null
💲 null (curr2_4c):
kslvt_4c null
ksl01_4c null
ksl02_4c null
ksl03_4c null
ksl04_4c null
ksl05_4c null
ksl06_4c null
ksl07_4c null
ksl08_4c null
ksl09_4c null
ksl10_4c null
ksl11_4c null
ksl12_4c null
ksl13_4c null
ksl14_4c null
ksl15_4c null
ksl16_4c null
Column Name Description
Column Name Description
Column Name Description
rrcty Record Type Show values
drcrk Debit/Credit Indicator Show values
Column Name Description Domain name
rcntr Cost Center KOSTL
rordnr Order Number AUFNR
rprojk Work Breakdown Structure Element (WBS Element) PS_POSNR
nplnr Network Number for Account Assignment AUFNR
vornr Network activity VORNR
aufpl Routing number of operations in the order AUFPL
aplzl General counter for order CO_APLZL
prodper Production Month BUPER
curt1_4a null
curt2_4a null
curt1_4c null
curt2_4c null
Master Data Relations Join Conditions
Account Number
  • Client
  • Company Code
  • Account Number
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == SKB1.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RBUKRS == SKB1.BUKRS
  • JV_JVTO1_ACDOCA_SWITCH_2.RACCT == SKB1.SAKNR
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == TABW.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RANBWA == TABW.BWASL
Asset Subnumber
  • Asset Subnumber
  • ?
  • Client
  • Main Asset Number
  • JV_JVTO1_ACDOCA_SWITCH_2.RANLN2 == ANLA.ANLN2
  • JV_JVTO1_ACDOCA_SWITCH_2.[column in domain "BUKRS"] == ANLA.BUKRS
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == ANLA.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RANLN1 == ANLA.ANLN1
Company Code
  • Client
  • Company Code
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == T001.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RBUKRS == T001.BUKRS
Business Area
  • Client
  • Business Area
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == TGSB.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RBUSA == TGSB.GSBER
Equity group
  • ?
  • Client
  • Equity group
  • Joint venture
  • JV_JVTO1_ACDOCA_SWITCH_2.[column in domain "BUKRS"] == T8JF.BUKRS
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == T8JF.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.REGROU == T8JF.EGRUP
  • JV_JVTO1_ACDOCA_SWITCH_2.RJVNAM == T8JF.VNAME
Joint venture
  • ?
  • Client
  • Joint venture
  • JV_JVTO1_ACDOCA_SWITCH_2.[column in domain "BUKRS"] == T8JV.BUKRS
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == T8JV.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RJVNAM == T8JV.VNAME
Controlling Area
  • Controlling Area
  • Client
  • JV_JVTO1_ACDOCA_SWITCH_2.RKOKRS == TKA01.KOKRS
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == TKA01.MANDT
Partner account number
  • Client
  • Partner account number
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == KNA1.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RPARTN == KNA1.KUNNR
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • JV_JVTO1_ACDOCA_SWITCH_2.RPRCTR == CEPC.PRCTR
  • JV_JVTO1_ACDOCA_SWITCH_2.[column in domain "DATBI"] == CEPC.DATBI
  • JV_JVTO1_ACDOCA_SWITCH_2.RKOKRS == CEPC.KOKRS
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == CEPC.MANDT
Recovery Indicator
  • ?
  • Client
  • Recovery Indicator
  • JV_JVTO1_ACDOCA_SWITCH_2.[column in domain "BUKRS"] == T8JJ.BUKRS
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == T8JJ.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RRECIN == T8JJ.RECID
Currency Key
  • Client
  • Currency Key
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == TCURC.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RTCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • JV_JVTO1_ACDOCA_SWITCH_2.MANDT == T006.MANDT
  • JV_JVTO1_ACDOCA_SWITCH_2.RUNIT == T006.MSEHI