JV_JVTO1_ACDOCA_SWITCH

JVTO1-like view on ACDOCA w/ JV ledgers | view: CJVTO1_ACD_SW | TRAN | Extraction: Not supported | Component: Joint Venture Accounting
Tables used: AFKO, AFVC, ACDOCA, JVSO1, T001, TKA02, T8JS, FINSC_LEDGER, T001, T881, T882, 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
📏 Base Unit of Measure (runit):
mslvt null
msl01 null
msl02 null
msl03 null
msl04 null
msl05 null
msl06 null
msl07 null
msl08 null
msl09 null
msl10 null
msl11 null
msl12 null
msl13 null
msl14 null
msl15 null
msl16 null
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
  • Account Number
  • Client
  • Company Code
  • JV_JVTO1_ACDOCA_SWITCH.RACCT == SKB1.SAKNR
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == SKB1.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RBUKRS == SKB1.BUKRS
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == TABW.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RANBWA == TABW.BWASL
Asset Subnumber
  • Client
  • Main Asset Number
  • Asset Subnumber
  • ?
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == ANLA.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RANLN1 == ANLA.ANLN1
  • JV_JVTO1_ACDOCA_SWITCH.RANLN2 == ANLA.ANLN2
  • JV_JVTO1_ACDOCA_SWITCH.[column in domain "BUKRS"] == ANLA.BUKRS
Company Code
  • Client
  • Company Code
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == T001.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RBUKRS == T001.BUKRS
Business Area
  • Client
  • Business Area
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == TGSB.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RBUSA == TGSB.GSBER
Equity group
  • Equity group
  • Client
  • Joint venture
  • ?
  • JV_JVTO1_ACDOCA_SWITCH.REGROU == T8JF.EGRUP
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == T8JF.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RJVNAM == T8JF.VNAME
  • JV_JVTO1_ACDOCA_SWITCH.[column in domain "BUKRS"] == T8JF.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == TCURC.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RHCUR == TCURC.WAERS
Joint venture
  • Client
  • Joint venture
  • ?
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == T8JV.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RJVNAM == T8JV.VNAME
  • JV_JVTO1_ACDOCA_SWITCH.[column in domain "BUKRS"] == T8JV.BUKRS
Global Currency
  • Client
  • Global Currency
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == TCURC.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RKCUR == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • JV_JVTO1_ACDOCA_SWITCH.RKOKRS == TKA01.KOKRS
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == TKA01.MANDT
Partner account number
  • Client
  • Partner account number
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == KNA1.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RPARTN == KNA1.KUNNR
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • JV_JVTO1_ACDOCA_SWITCH.RKOKRS == CEPC.KOKRS
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == CEPC.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.[column in domain "DATBI"] == CEPC.DATBI
  • JV_JVTO1_ACDOCA_SWITCH.RPRCTR == CEPC.PRCTR
Recovery Indicator
  • Client
  • Recovery Indicator
  • ?
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == T8JJ.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RRECIN == T8JJ.RECID
  • JV_JVTO1_ACDOCA_SWITCH.[column in domain "BUKRS"] == T8JJ.BUKRS
Currency Key
  • Client
  • Currency Key
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == TCURC.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RTCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • JV_JVTO1_ACDOCA_SWITCH.MANDT == T006.MANDT
  • JV_JVTO1_ACDOCA_SWITCH.RUNIT == T006.MSEHI