JV_JVSO1_ACDOCA_4A_4C_SWITCH

JVSO1-like view on ACDOCA/JVSO1 | view: CJVSO1_ACD4A4CSW | 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
Column Name Description
rldnr Ledger
rrcty Record Type Show values
rvers Version
ryear Fiscal Year
rtcur FK Currency Key
runit FK Base Unit of Measure
drcrk Debit/Credit Indicator Show values
poper Posting period
docct Document Category Show values
docnr Document Number of an Accounting Document
docln Six-Character Posting Item for Ledger
rbukrs FK Company Code
Column Name Description
💲 Currency Key (rtcur):
tsl Amount in Transaction Currency
💲 Company Code Currency (JV_JVSO1_ACDOCA.rhcur):
hsl Amount in Company Code Currency
💲 Global Currency (JV_JVSO1_ACDOCA.rkcur):
ksl Value field 12(23) characters with 2 decimal places
Column Name Description
📏 Base Unit of Measure (runit):
msl Quantity
Column Name Description
budat Posting Date in the Document
wsdat Translation date
valut Value date
cpudt Day On Which Accounting Document Was Entered
cputm Time of Entry
bldat Document Date in Document
billm Billing Month
pom Processing operational month
sdate Start Date
prodper Production Month (Date to find period and year)
Column Name Description
rrcty Record Type Show values
drcrk Debit/Credit Indicator Show values
docct Document Category Show values
refdocct Document Category Show values
mmact JVA MM Activity Type Show values
xsbl Flag: Line is Split Basis Line Show values
Column Name Description Domain name
rcntr Cost Center KOSTL
rordnr Order Number AUFNR
rprojk Work Breakdown Structure Element (WBS Element) PS_POSNR
rdpom Posting Period Difference for Operational Month CHAR4
rdbillm Invoice Month: Posting Period Difference CHAR4
nplnr Network Number for Account Assignment AUFNR
aufpl Routing number of operations in the order AUFPL
aplzl General counter for order CO_APLZL
vornr Network activity VORNR
sgtxt Item Text TEXT50
autom Indicator: Automatic posting lines TEXT1
activ Business Transaction CHAR4
refdocnr Document Number of an Accounting Document BELNR
refryear Fiscal Year GJAHR
refdocln Line Item in Joint Venture Reference Doc NUMC5
refactiv Business Transaction CHAR4
reffidln Number of Line Item Within Accounting Document BUZEI
orecid Original Recovery Indicator JV_RECIND
cbperiod JV Cutback Period POPER
ktosl Transaction Key CHAR3
cycle Allocation/cycle CYCLE
seqnr Segment number within a cycle SQNR
seqname Name of a Segment in Assessment/Distribution SEQNAME
refcyc Reference Field for Allocation Cycle TEXT10
condi Joint Venture Indicator (Condition Key) JV_CONDCOD
aworg Reference Organizational Units AWORG
refawref Reference document number AWREF
refaworg Reference Organizational Units AWORG
reffidoc Document Number of an Accounting Document BELNR
cbpayterm Terms of payment key ZTERM
sbrefln Reference Split Basis Line Number JV_SBREFLN
Master Data Relations Join Conditions
Additional unit of measure
  • Base Unit of Measure
  • Additional unit of measure
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.AUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T006.MANDT
Reference procedure JV_JVSO1_ACDOCA_4A_4C_SWITCH.AWTYP == TTYP.AWTYP
Billing Indicator
  • Client
  • Billing Indicator
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T8JA.MANDT
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.BILID == T8JA.BILIND
Customer Number
  • Client
  • Customer Number
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == KNA1.MANDT
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.CBCUSTOMER == KNA1.KUNNR
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.CBVENDOR == LFA1.LIFNR
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == LFA1.MANDT
Document Type
  • Client
  • Document Type
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T003.MANDT
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.DOCTY == T003.BLART
Logical system JV_JVSO1_ACDOCA_4A_4C_SWITCH.LOGSYS == TBDLS.LOGSYS
Activity Type
  • ?
  • Controlling Area
  • Activity Type
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.[column in domain "DATBI"] == CSLA.DATBI
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RKOKRS == CSLA.KOKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.LSTAR == CSLA.LSTAR
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == CSLA.MANDT
Material Number
  • Material Number
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MATNR == MARA.MATNR
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == MARA.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.[column in domain "KALSM_D"] == T007A.KALSM
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MWSKZ == T007A.MWSKZ
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T007A.MANDT
Account Number
  • Company Code
  • Account Number
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RBUKRS == SKB1.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RACCT == SKB1.SAKNR
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == SKB1.MANDT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == TABW.MANDT
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RANBWA == TABW.BWASL
Asset Subnumber
  • Main Asset Number
  • Asset Subnumber
  • ?
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RANLN1 == ANLA.ANLN1
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RANLN2 == ANLA.ANLN2
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.[column in domain "BUKRS"] == ANLA.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == ANLA.MANDT
Company Code
  • Company Code
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RBUKRS == T001.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RBUSA == TGSB.GSBER
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == TGSB.MANDT
Reference procedure JV_JVSO1_ACDOCA_4A_4C_SWITCH.REFAWTYP == TTYP.AWTYP
Logical system JV_JVSO1_ACDOCA_4A_4C_SWITCH.REFLOGSYS == TBDLS.LOGSYS
Equity group
  • Equity group
  • Joint venture
  • ?
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.REGROU == T8JF.EGRUP
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RJVNAM == T8JF.VNAME
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.[column in domain "BUKRS"] == T8JF.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T8JF.MANDT
Joint venture
  • Joint venture
  • ?
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RJVNAM == T8JV.VNAME
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.[column in domain "BUKRS"] == T8JV.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T8JV.MANDT
Controlling Area
  • Controlling Area
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RKOKRS == TKA01.KOKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == TKA01.MANDT
Partner account number
  • Client
  • Partner account number
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == KNA1.MANDT
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RPARTN == KNA1.KUNNR
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RPRCTR == CEPC.PRCTR
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.[column in domain "DATBI"] == CEPC.DATBI
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RKOKRS == CEPC.KOKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == CEPC.MANDT
Recovery Indicator
  • Recovery Indicator
  • ?
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RRECIN == T8JJ.RECID
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.[column in domain "BUKRS"] == T8JJ.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T8JJ.MANDT
Currency Key
  • Client
  • Currency Key
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RTCUR == TCURC.WAERS
Base Unit of Measure
  • Base Unit of Measure
  • Additional unit of measure
  • Client
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.RUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.AUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA_4A_4C_SWITCH.MANDT == T006.MANDT