JV_ACDOCA_JVSO1_SWITCH

ACDOCA-like view on JVSO1/ACDOCA | view: CACDOCA_JVSO1_SW | TRAN | Extraction: Not supported | Component: Joint Venture Accounting
Tables used: AFKO, AFVC, ACDOCA, JVSO1, T001, TKA02, T8JS, FINSC_LEDGER, T881, T882, T8JZ, FINSC_ACTVE_APPL, T8JZ, JVAONACDOCAACTIV, FINSC_LD_CMP
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
bldat Document Date in Document
valut Value date
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
awref Reference document number AWREF
aworg Reference Organizational Units AWORG
awitem Reference Document Line Item NUMC6
ryear General Ledger Fiscal Year GJAHR
poper Posting period POPER
vorgn Transaction Type for General Ledger VORGN
jvactivity JVA Activity (Joint Venture Accounting)
cbrunid Cutback Run ID (Joint Venture Accounting) TZNTSTMPL
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
ktosl Transaction Key CHAR3
sgtxt Item Text TEXT50
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TABW.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.ANBWA == TABW.BWASL
Asset Subnumber
  • ?
  • Client
  • Main Asset Number
  • Asset Subnumber
  • JV_ACDOCA_JVSO1_SWITCH.[column in domain "BUKRS"] == ANLA.BUKRS
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == ANLA.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.ANLN1 == ANLA.ANLN1
  • JV_ACDOCA_JVSO1_SWITCH.ANLN2 == ANLA.ANLN2
Logical system of source document JV_ACDOCA_JVSO1_SWITCH.AWSYS == TBDLS.LOGSYS
Reference procedure JV_ACDOCA_JVSO1_SWITCH.AWTYP == TTYP.AWTYP
Document Type
  • Client
  • Document Type
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == T003.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.BLART == T003.BLART
Billing Indicator
  • Client
  • Billing Indicator
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == T8JA.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.BTYPE == T8JA.BILIND
Equity group
  • Equity group
  • ?
  • Client
  • Joint venture
  • JV_ACDOCA_JVSO1_SWITCH.EGRUP == T8JF.EGRUP
  • JV_ACDOCA_JVSO1_SWITCH.[column in domain "BUKRS"] == T8JF.BUKRS
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == T8JF.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.VNAME == T8JF.VNAME
Controlling Area
  • Client
  • Controlling Area
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TKA01.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.KOKRS == TKA01.KOKRS
Customer Number
  • Customer Number
  • Client
  • JV_ACDOCA_JVSO1_SWITCH.KUNNR == KNA1.KUNNR
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == KNA1.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • JV_ACDOCA_JVSO1_SWITCH.LIFNR == LFA1.LIFNR
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == LFA1.MANDT
Activity Type
  • Activity Type
  • Client
  • Controlling Area
  • ?
  • JV_ACDOCA_JVSO1_SWITCH.LSTAR == CSLA.LSTAR
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == CSLA.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.KOKRS == CSLA.KOKRS
  • JV_ACDOCA_JVSO1_SWITCH.[column in domain "DATBI"] == CSLA.DATBI
Material Number
  • Client
  • Material Number
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == MARA.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.MATNR == MARA.MATNR
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • ?
  • JV_ACDOCA_JVSO1_SWITCH.MWSKZ == T007A.MWSKZ
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == T007A.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.[column in domain "KALSM_D"] == T007A.KALSM
Profit Center
  • Profit Center
  • Client
  • Controlling Area
  • ?
  • JV_ACDOCA_JVSO1_SWITCH.PRCTR == CEPC.PRCTR
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == CEPC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.KOKRS == CEPC.KOKRS
  • JV_ACDOCA_JVSO1_SWITCH.[column in domain "DATBI"] == CEPC.DATBI
Account Number
  • Account Number
  • Client
  • Company Code
  • JV_ACDOCA_JVSO1_SWITCH.RACCT == SKB1.SAKNR
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == SKB1.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RBUKRS == SKB1.BUKRS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RBCUR == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == T001.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RBUKRS == T001.BUKRS
Business Area
  • Client
  • Business Area
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TGSB.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RBUSA == TGSB.GSBER
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • JV_ACDOCA_JVSO1_SWITCH.RCCUR == TCURC.WAERS
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RDCUR == TCURC.WAERS
Recovery Indicator
  • ?
  • Client
  • Recovery Indicator
  • JV_ACDOCA_JVSO1_SWITCH.[column in domain "BUKRS"] == T8JJ.BUKRS
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == T8JJ.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RECID == T8JJ.RECID
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RECUR == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RFCUR == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RGCUR == TCURC.WAERS
Company Code Currency
  • Company Code Currency
  • Client
  • JV_ACDOCA_JVSO1_SWITCH.RHCUR == TCURC.WAERS
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
Global Currency
  • Client
  • Global Currency
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.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_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.ROCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == T006.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RUNIT == T006.MSEHI
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RVCUR == TCURC.WAERS
Transaction Currency
  • Client
  • Transaction Currency
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.RWCUR == TCURC.WAERS
Joint venture
  • ?
  • Client
  • Joint venture
  • JV_ACDOCA_JVSO1_SWITCH.[column in domain "BUKRS"] == T8JV.BUKRS
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == T8JV.MANDT
  • JV_ACDOCA_JVSO1_SWITCH.VNAME == T8JV.VNAME
Partner account number
  • Partner account number
  • Client
  • JV_ACDOCA_JVSO1_SWITCH.VPTNR == KNA1.KUNNR
  • JV_ACDOCA_JVSO1_SWITCH.MANDT == KNA1.MANDT