JV_JVSO1_ACDOCA

JVSO1-like view on ACDOCA | view: CJVSO1_ACD | TRAN | Extraction: Not supported | Component: Joint Venture Accounting
Tables used: AFKO, AFVC, ACDOCA, T001, TKA02, T8JS, FINSC_LEDGER, T001, T881, T882, T8JZ, FINSC_ACTVE_APPL, FINSC_LD_CMP
Column Name Description
gl_sirid Record number of the line item record
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
tsl_acd Amount in Balance Transaction Currency
💲 Company Code Currency (rhcur):
hsl Amount in Company Code Currency
💲 null (curr2_4a):
ksl Value field 12(23) characters with 2 decimal places
💲 null (curr1_4c):
hsl_4c Value field 12(23) characters with 2 decimal places
💲 null (curr2_4c):
ksl_4c Value field 12(23) characters with 2 decimal places
💲 Global Currency (rkcur):
ksl_acd 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
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
mig_source Source of a migrated journal entry item 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
curt1_4a null
curt2_4a null
curt1_4c null
curt2_4c null
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
ryear_gl General Ledger Fiscal Year GJAHR
belnr_gl Document Number of an Accounting Document BELNR
buzei Number of Line Item Within Accounting Document BUZEI
mig_docln Item ID of migrated G/L line item DOCLN6
ps_pspid Project definition PS_PSPID
Master Data Relations Join Conditions
Additional unit of measure
  • Client
  • Additional unit of measure
  • Base Unit of Measure
  • JV_JVSO1_ACDOCA.MANDT == T006.MANDT
  • JV_JVSO1_ACDOCA.AUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA.RUNIT == T006.MSEHI
Reference procedure JV_JVSO1_ACDOCA.AWTYP == TTYP.AWTYP
Billing Indicator
  • Billing Indicator
  • Client
  • JV_JVSO1_ACDOCA.BILID == T8JA.BILIND
  • JV_JVSO1_ACDOCA.MANDT == T8JA.MANDT
Customer Number
  • Client
  • Customer Number
  • JV_JVSO1_ACDOCA.MANDT == KNA1.MANDT
  • JV_JVSO1_ACDOCA.CBCUSTOMER == KNA1.KUNNR
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • JV_JVSO1_ACDOCA.CBVENDOR == LFA1.LIFNR
  • JV_JVSO1_ACDOCA.MANDT == LFA1.MANDT
Document Type
  • Document Type
  • Client
  • JV_JVSO1_ACDOCA.DOCTY == T003.BLART
  • JV_JVSO1_ACDOCA.MANDT == T003.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • Company Code Currency
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA.HWAER == TCURC.WAERS
  • JV_JVSO1_ACDOCA.RHCUR == TCURC.WAERS
Logical system JV_JVSO1_ACDOCA.LOGSYS == TBDLS.LOGSYS
Activity Type
  • ?
  • Controlling Area
  • Activity Type
  • Client
  • JV_JVSO1_ACDOCA.[column in domain "DATBI"] == CSLA.DATBI
  • JV_JVSO1_ACDOCA.RKOKRS == CSLA.KOKRS
  • JV_JVSO1_ACDOCA.LSTAR == CSLA.LSTAR
  • JV_JVSO1_ACDOCA.MANDT == CSLA.MANDT
Material Number
  • Material Number
  • Client
  • JV_JVSO1_ACDOCA.MATNR == MARA.MATNR
  • JV_JVSO1_ACDOCA.MANDT == MARA.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • JV_JVSO1_ACDOCA.[column in domain "KALSM_D"] == T007A.KALSM
  • JV_JVSO1_ACDOCA.MWSKZ == T007A.MWSKZ
  • JV_JVSO1_ACDOCA.MANDT == T007A.MANDT
Account Number
  • Account Number
  • Company Code
  • Client
  • JV_JVSO1_ACDOCA.RACCT == SKB1.SAKNR
  • JV_JVSO1_ACDOCA.RBUKRS == SKB1.BUKRS
  • JV_JVSO1_ACDOCA.MANDT == SKB1.MANDT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • JV_JVSO1_ACDOCA.RANBWA == TABW.BWASL
  • JV_JVSO1_ACDOCA.MANDT == TABW.MANDT
Asset Subnumber
  • ?
  • Main Asset Number
  • Asset Subnumber
  • Client
  • JV_JVSO1_ACDOCA.[column in domain "BUKRS"] == ANLA.BUKRS
  • JV_JVSO1_ACDOCA.RANLN1 == ANLA.ANLN1
  • JV_JVSO1_ACDOCA.RANLN2 == ANLA.ANLN2
  • JV_JVSO1_ACDOCA.MANDT == ANLA.MANDT
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA.RBCUR == TCURC.WAERS
Company Code
  • Company Code
  • Client
  • JV_JVSO1_ACDOCA.RBUKRS == T001.BUKRS
  • JV_JVSO1_ACDOCA.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • JV_JVSO1_ACDOCA.RBUSA == TGSB.GSBER
  • JV_JVSO1_ACDOCA.MANDT == TGSB.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • JV_JVSO1_ACDOCA.RCCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • JV_JVSO1_ACDOCA.RDCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA.RECUR == TCURC.WAERS
Reference procedure JV_JVSO1_ACDOCA.REFAWTYP == TTYP.AWTYP
Logical system JV_JVSO1_ACDOCA.REFLOGSYS == TBDLS.LOGSYS
Equity group
  • Equity group
  • ?
  • Client
  • Joint venture
  • JV_JVSO1_ACDOCA.REGROU == T8JF.EGRUP
  • JV_JVSO1_ACDOCA.[column in domain "BUKRS"] == T8JF.BUKRS
  • JV_JVSO1_ACDOCA.MANDT == T8JF.MANDT
  • JV_JVSO1_ACDOCA.RJVNAM == T8JF.VNAME
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • JV_JVSO1_ACDOCA.RFCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • JV_JVSO1_ACDOCA.RGCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • Company Code Currency
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
  • JV_JVSO1_ACDOCA.HWAER == TCURC.WAERS
  • JV_JVSO1_ACDOCA.RHCUR == TCURC.WAERS
Joint venture
  • ?
  • Client
  • Joint venture
  • JV_JVSO1_ACDOCA.[column in domain "BUKRS"] == T8JV.BUKRS
  • JV_JVSO1_ACDOCA.MANDT == T8JV.MANDT
  • JV_JVSO1_ACDOCA.RJVNAM == T8JV.VNAME
Global Currency
  • Global Currency
  • Client
  • JV_JVSO1_ACDOCA.RKCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • JV_JVSO1_ACDOCA.RKOKRS == TKA01.KOKRS
  • JV_JVSO1_ACDOCA.MANDT == TKA01.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • JV_JVSO1_ACDOCA.ROCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
Partner account number
  • Partner account number
  • Client
  • JV_JVSO1_ACDOCA.RPARTN == KNA1.KUNNR
  • JV_JVSO1_ACDOCA.MANDT == KNA1.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • JV_JVSO1_ACDOCA.[column in domain "DATBI"] == CEPC.DATBI
  • JV_JVSO1_ACDOCA.RKOKRS == CEPC.KOKRS
  • JV_JVSO1_ACDOCA.RPRCTR == CEPC.PRCTR
  • JV_JVSO1_ACDOCA.MANDT == CEPC.MANDT
Recovery Indicator
  • ?
  • Recovery Indicator
  • Client
  • JV_JVSO1_ACDOCA.[column in domain "BUKRS"] == T8JJ.BUKRS
  • JV_JVSO1_ACDOCA.RRECIN == T8JJ.RECID
  • JV_JVSO1_ACDOCA.MANDT == T8JJ.MANDT
Currency Key
  • Currency Key
  • Client
  • JV_JVSO1_ACDOCA.RTCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT
Base Unit of Measure
  • Client
  • Additional unit of measure
  • Base Unit of Measure
  • JV_JVSO1_ACDOCA.MANDT == T006.MANDT
  • JV_JVSO1_ACDOCA.AUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA.RUNIT == T006.MSEHI
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • JV_JVSO1_ACDOCA.RVCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA.MANDT == TCURC.MANDT