JV_ACDOCA_JVSO1

ACDOCA-like view on JVSO1 | view: CACDOCA_JVSO1 | TRAN | Extraction: Not supported | Component: Joint Venture Accounting
Tables used: AFKO, AFVC, JVSO1, T001, TKA02, T8JS, FINSC_LEDGER, T881, T882, T8JZ, FINSC_ACTVE_APPL, FINSC_LD_CMP
Column Name Description
rldnr 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
💲 Currency Key (rwcur):
wsl Value in Transaction Currency
💲 Currency key of currency 2 (rhcur):
hsl Value in local currency
💲 Currency Key (rkcur):
ksl Value in group currency
💲 Currency Key (rocur):
osl Value field 12(23) characters with 2 decimal places
💲 Currency Key (rvcur):
vsl Value field 12(23) characters with 2 decimal places
💲 Currency Key (rbcur):
bsl Value field 12(23) characters with 2 decimal places
💲 Currency Key (rccur):
csl Value field 12(23) characters with 2 decimal places
💲 Currency Key (rdcur):
dsl Value field 12(23) characters with 2 decimal places
💲 Currency Key (recur):
esl Value field 12(23) characters with 2 decimal places
💲 Currency Key (rfcur):
fsl Value field 12(23) characters with 2 decimal places
💲 Currency Key (rgcur):
gsl 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
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 Document Number of an Accounting Document BELNR
aworg Reference Organizational Units AWORG
awitem Reference Document Line Item NUMC6
ryear Fiscal Year GJAHR
poper Posting period POPER
sgtxt Item Text TEXT50
vorgn Business Transaction CHAR4
ktosl Transaction Key CHAR3
kunnr Customer Number KUNNR
lifnr Account Number of Supplier LIFNR
prctr Profit Center PRCTR
accasty null
nplnr_vorgn Network activity VORNR
aufpl Task List Number for Operations in Order AUFPL
aplzl General Counter for Order CO_APLZL
vornr Operation/Activity Number VORNR
jvactivity null
cbrunid UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
usnam User Name XUBNAME
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • JV_ACDOCA_JVSO1.MANDT == TABW.MANDT
  • JV_ACDOCA_JVSO1.ANBWA == TABW.BWASL
Asset Subnumber
  • Main Asset Number
  • Company Code
  • Client
  • Asset Subnumber
  • JV_ACDOCA_JVSO1.ANLN1 == ANLA.ANLN1
  • JV_ACDOCA_JVSO1.RBUKRS == ANLA.BUKRS
  • JV_ACDOCA_JVSO1.MANDT == ANLA.MANDT
  • JV_ACDOCA_JVSO1.ANLN2 == ANLA.ANLN2
Order Number
  • Client
  • Order Number
  • JV_ACDOCA_JVSO1.MANDT == AUFK.MANDT
  • JV_ACDOCA_JVSO1.AUFNR == AUFK.AUFNR
Logical system JV_ACDOCA_JVSO1.AWSYS == TBDLS.LOGSYS
Reference procedure JV_ACDOCA_JVSO1.AWTYP == TTYP.AWTYP
Document type
  • Client
  • Document Type
  • JV_ACDOCA_JVSO1.MANDT == T003.MANDT
  • JV_ACDOCA_JVSO1.BLART == T003.BLART
Billing indicator
  • Client
  • Billing Indicator
  • JV_ACDOCA_JVSO1.MANDT == T8JA.MANDT
  • JV_ACDOCA_JVSO1.BTYPE == T8JA.BILIND
Equity group
  • Joint venture
  • Company Code
  • Client
  • Equity group
  • JV_ACDOCA_JVSO1.VNAME == T8JF.VNAME
  • JV_ACDOCA_JVSO1.RBUKRS == T8JF.BUKRS
  • JV_ACDOCA_JVSO1.MANDT == T8JF.MANDT
  • JV_ACDOCA_JVSO1.EGRUP == T8JF.EGRUP
Controlling Area
  • Client
  • Controlling Area
  • JV_ACDOCA_JVSO1.MANDT == TKA01.MANDT
  • JV_ACDOCA_JVSO1.KOKRS == TKA01.KOKRS
Activity Type
  • Activity Type
  • Posting Date in the Document
  • Client
  • Controlling Area
  • JV_ACDOCA_JVSO1.LSTAR == CSLA.LSTAR
  • JV_ACDOCA_JVSO1.BUDAT == CSLA.DATBI
  • JV_ACDOCA_JVSO1.MANDT == CSLA.MANDT
  • JV_ACDOCA_JVSO1.KOKRS == CSLA.KOKRS
Material Number
  • Client
  • Material Number
  • JV_ACDOCA_JVSO1.MANDT == MARA.MANDT
  • JV_ACDOCA_JVSO1.MATNR == MARA.MATNR
Tax code
  • Tax on sales/purchases code
  • Client
  • ?
  • JV_ACDOCA_JVSO1.MWSKZ == T007A.MWSKZ
  • JV_ACDOCA_JVSO1.MANDT == T007A.MANDT
  • JV_ACDOCA_JVSO1.[column in domain "KALSM_D"] == T007A.KALSM
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • JV_ACDOCA_JVSO1.NPLNR == AUFK.AUFNR
  • JV_ACDOCA_JVSO1.MANDT == AUFK.MANDT
G/L account number
  • Account Number
  • Client
  • ?
  • JV_ACDOCA_JVSO1.RACCT == SKA1.SAKNR
  • JV_ACDOCA_JVSO1.MANDT == SKA1.MANDT
  • JV_ACDOCA_JVSO1.[column in domain "KTOPL"] == SKA1.KTOPL
Company Code
  • Company Code
  • Client
  • JV_ACDOCA_JVSO1.RBUKRS == T001.BUKRS
  • JV_ACDOCA_JVSO1.MANDT == T001.MANDT
Business area
  • Client
  • Business Area
  • JV_ACDOCA_JVSO1.MANDT == TGSB.MANDT
  • JV_ACDOCA_JVSO1.RBUSA == TGSB.GSBER
Cost Center
  • Posting Date in the Document
  • Client
  • Cost Center
  • Controlling Area
  • JV_ACDOCA_JVSO1.BUDAT == CSKS.DATBI
  • JV_ACDOCA_JVSO1.MANDT == CSKS.MANDT
  • JV_ACDOCA_JVSO1.RCNTR == CSKS.KOSTL
  • JV_ACDOCA_JVSO1.KOKRS == CSKS.KOKRS
Recovery Indicator
  • Recovery Indicator
  • Company Code
  • Client
  • JV_ACDOCA_JVSO1.RECID == T8JJ.RECID
  • JV_ACDOCA_JVSO1.RBUKRS == T8JJ.BUKRS
  • JV_ACDOCA_JVSO1.MANDT == T8JJ.MANDT
Currency key of currency 2
  • Client
  • Currency key of currency 2
  • JV_ACDOCA_JVSO1.MANDT == TCURC.MANDT
  • JV_ACDOCA_JVSO1.RHCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • JV_ACDOCA_JVSO1.MANDT == T006.MANDT
  • JV_ACDOCA_JVSO1.RUNIT == T006.MSEHI
Currency Key
  • Currency Key
  • Client
  • JV_ACDOCA_JVSO1.RWCUR == TCURC.WAERS
  • JV_ACDOCA_JVSO1.MANDT == TCURC.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • JV_ACDOCA_JVSO1.VNAME == T8JV.VNAME
  • JV_ACDOCA_JVSO1.RBUKRS == T8JV.BUKRS
  • JV_ACDOCA_JVSO1.MANDT == T8JV.MANDT
Partner account number
  • Client
  • Partner account number
  • JV_ACDOCA_JVSO1.MANDT == KNA1.MANDT
  • JV_ACDOCA_JVSO1.VPTNR == KNA1.KUNNR