JV_JVSO1_ACDOCA_4A_4C

JVSO1-like view on ACDOCA w/ JV ledgers | view: CJVSO1_ACD_4A4C | TRAN | Extraction: Not supported | Component: Joint Venture Accounting
Tables used: AFKO, AFVC, ACDOCA, T001, TKA02, T8JS, FINSC_LEDGER, T001, T881, T882, T881, T882, T8JZ, FINSC_ACTVE_APPL, FINSC_LD_CMP
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
💲 Currency key of currency 2 (curr1):
hsl Amount in Company Code Currency
💲 Currency key of currency 3 (curr2):
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
curt1 Currency type of the local currency (HSL) Show values
curt2 Currency type of the group currency (KSL) 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.RUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA_4A_4C.AUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T006.MANDT
Reference procedure JV_JVSO1_ACDOCA_4A_4C.AWTYP == TTYP.AWTYP
Billing Indicator
  • Billing Indicator
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.BILID == T8JA.BILIND
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T8JA.MANDT
Customer Number
  • Customer Number
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.CBCUSTOMER == KNA1.KUNNR
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == KNA1.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.CBVENDOR == LFA1.LIFNR
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == LFA1.MANDT
Currency key of currency 2
  • Currency key of currency 2
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.CURR1 == TCURC.WAERS
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == TCURC.MANDT
Currency key of currency 3
  • Currency key of currency 3
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.CURR2 == TCURC.WAERS
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == TCURC.MANDT
Document Type
  • Document Type
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.DOCTY == T003.BLART
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T003.MANDT
Logical system JV_JVSO1_ACDOCA_4A_4C.LOGSYS == TBDLS.LOGSYS
Activity Type
  • ?
  • Activity Type
  • Client
  • Controlling Area
  • JV_JVSO1_ACDOCA_4A_4C.[column in domain "DATBI"] == CSLA.DATBI
  • JV_JVSO1_ACDOCA_4A_4C.LSTAR == CSLA.LSTAR
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == CSLA.MANDT
  • JV_JVSO1_ACDOCA_4A_4C.RKOKRS == CSLA.KOKRS
Material Number
  • Client
  • Material Number
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == MARA.MANDT
  • JV_JVSO1_ACDOCA_4A_4C.MATNR == MARA.MATNR
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • ?
  • JV_JVSO1_ACDOCA_4A_4C.MWSKZ == T007A.MWSKZ
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T007A.MANDT
  • JV_JVSO1_ACDOCA_4A_4C.[column in domain "KALSM_D"] == T007A.KALSM
Account Number
  • Company Code
  • Client
  • Account Number
  • JV_JVSO1_ACDOCA_4A_4C.RBUKRS == SKB1.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == SKB1.MANDT
  • JV_JVSO1_ACDOCA_4A_4C.RACCT == SKB1.SAKNR
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.RANBWA == TABW.BWASL
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == TABW.MANDT
Asset Subnumber
  • Main Asset Number
  • ?
  • Client
  • Asset Subnumber
  • JV_JVSO1_ACDOCA_4A_4C.RANLN1 == ANLA.ANLN1
  • JV_JVSO1_ACDOCA_4A_4C.[column in domain "BUKRS"] == ANLA.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == ANLA.MANDT
  • JV_JVSO1_ACDOCA_4A_4C.RANLN2 == ANLA.ANLN2
Company Code
  • Company Code
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.RBUKRS == T001.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.RBUSA == TGSB.GSBER
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == TGSB.MANDT
Reference procedure JV_JVSO1_ACDOCA_4A_4C.REFAWTYP == TTYP.AWTYP
Logical system JV_JVSO1_ACDOCA_4A_4C.REFLOGSYS == TBDLS.LOGSYS
Equity group
  • Equity group
  • Joint venture
  • ?
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.REGROU == T8JF.EGRUP
  • JV_JVSO1_ACDOCA_4A_4C.RJVNAM == T8JF.VNAME
  • JV_JVSO1_ACDOCA_4A_4C.[column in domain "BUKRS"] == T8JF.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T8JF.MANDT
Joint venture
  • Joint venture
  • ?
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.RJVNAM == T8JV.VNAME
  • JV_JVSO1_ACDOCA_4A_4C.[column in domain "BUKRS"] == T8JV.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T8JV.MANDT
Controlling Area
  • Client
  • Controlling Area
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == TKA01.MANDT
  • JV_JVSO1_ACDOCA_4A_4C.RKOKRS == TKA01.KOKRS
Partner account number
  • Partner account number
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.RPARTN == KNA1.KUNNR
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == KNA1.MANDT
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • JV_JVSO1_ACDOCA_4A_4C.[column in domain "DATBI"] == CEPC.DATBI
  • JV_JVSO1_ACDOCA_4A_4C.RPRCTR == CEPC.PRCTR
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == CEPC.MANDT
  • JV_JVSO1_ACDOCA_4A_4C.RKOKRS == CEPC.KOKRS
Recovery Indicator
  • ?
  • Recovery Indicator
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.[column in domain "BUKRS"] == T8JJ.BUKRS
  • JV_JVSO1_ACDOCA_4A_4C.RRECIN == T8JJ.RECID
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T8JJ.MANDT
Currency Key
  • Currency Key
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.RTCUR == TCURC.WAERS
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Additional unit of measure
  • Client
  • JV_JVSO1_ACDOCA_4A_4C.RUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA_4A_4C.AUNIT == T006.MSEHI
  • JV_JVSO1_ACDOCA_4A_4C.MANDT == T006.MANDT