JVSO1

Transparent Table Application Table
82 Fields 3 CDS Views

JV LI Table with Objects for JVTO1

JVSO1 is an SAP database table in S/4HANA. JV LI Table with Objects for JVTO1. It contains 82 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_JointVentureAcctgDetail view from BASIC Joint Venture Accounting Detail
JV_JVSO1_ACDOCA_4A_4C_SWITCH view union JVSO1-like view on ACDOCA/JVSO1
JV_JVSO1_COMB view from Combined view of ledgers 4A/4C on JVSO1

Fields (82)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY gl_sirid gu_recid Record number
rldnr rldnr Ledger
rrcty rrcty Record Type
rvers rvers Version
ryear gjahr Fiscal Year
rtcur rtcur Currency
runit meins Base Unit
drcrk shkzg Debit/Credit
poper poper Posting Period
docct docct Document Categ.
docnr belnr_d Document Number
docln jv_docln Line Item
rbukrs bukrs Company Code
rjvnam jv_name Joint venture
regrou jv_egroup Equity group
racct racct Account Number
rbusa gsber Business Area
rkokrs kokrs CO Area
rcntr kostl Cost Center
rordnr aufnr Order
rprojk ps_psp_pnr WBS Element
rprctr prctr Profit Center
ranln1 anln1 Asset
ranln2 anln2 Sub-number
ranbwa anbwa Ast Transaction Type
rrecin jv_recind Recovery Ind.
rpartn jv_part Partner
rdpom jv_dpom Po Per Diff-OM
rdbillm jv_dbillm Delta InvM
nplnr nplnr Network
aufpl aufpl_ch TaskList No.Ops
aplzl aplzl_ch Counter
vornr vornr Activity
tsl vtcur9_cs Tran. Crcy
hsl vlcur9_cs Local crcy
ksl vgcur9_cs GrpCurr
msl quan1 Quantity
aunit aunit Add.unit/meas.
sgtxt sgtxt Text
autom autom Auto. ID
docty blart Document Type
activ glvor Bus.transaction
budat budat Posting Date
wsdat wsdat Value Date
valut valut Value date
refdocnr belnr_d Document Number
refryear gjahr Fiscal Year
refdocln jv_refdln Ref. LI
refdocct docct Document Categ.
refactiv glvor Bus.transaction
reffidln buzei Item
cpudt cpudt Entered On
cputm cputm Entered at
usnam usnam User Name
bldat bldat Document Date
bilid jv_bilind Billing ind.
orecid jv_orecid Orig. Rec. Ind
mwskz mwskz Tax Code
billm jv_billm Billing Month
pom jv_pom Proc.Oper.Month
cbperiod jv_cbperi Cutback Period
ebeln ebeln Purchasing Doc.
ebelp ebelp Item
ktosl ktosl Transaction
mmact jv_mm_act MM Activity Type
lstar lstar Activity Type
cycle cycle Cycle
sdate sdate Valid From
seqnr sqnr Segment number
seqname seqname Segment
refcyc jv_refcyc Reference
matnr matnr Material
condi jv_condcod CondKey
awtyp awtyp Ref. procedure
aworg aworg Refer. Org.Unit
logsys logsys Logical system
refawtyp awtyp Ref. procedure
refawref awref Reference Doc.
refaworg aworg Refer. Org.Unit
reflogsys logsys Logical system
prodper jv_prodper Prod.Month

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- JV LI Table with Objects for JVTO1
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JVSO1 (
    RCLNT,      -- Client [mandt]
    GL_SIRID,   -- Record number [gu_recid]
    RLDNR,      -- Ledger [rldnr]
    RRCTY,      -- Record Type [rrcty]
    RVERS,      -- Version [rvers]
    RYEAR,      -- Fiscal Year [gjahr]
    RTCUR,      -- Currency [rtcur]
    RUNIT,      -- Base Unit [meins]
    DRCRK,      -- Debit/Credit [shkzg]
    POPER,      -- Posting Period [poper]
    DOCCT,      -- Document Categ. [docct]
    DOCNR,      -- Document Number [belnr_d]
    DOCLN,      -- Line Item [jv_docln]
    RBUKRS,     -- Company Code [bukrs]
    RJVNAM,     -- Joint venture [jv_name]
    REGROU,     -- Equity group [jv_egroup]
    RACCT,      -- Account Number [racct]
    RBUSA,      -- Business Area [gsber]
    RKOKRS,     -- CO Area [kokrs]
    RCNTR,      -- Cost Center [kostl]
    RORDNR,     -- Order [aufnr]
    RPROJK,     -- WBS Element [ps_psp_pnr]
    RPRCTR,     -- Profit Center [prctr]
    RANLN1,     -- Asset [anln1]
    RANLN2,     -- Sub-number [anln2]
    RANBWA,     -- Ast Transaction Type [anbwa]
    RRECIN,     -- Recovery Ind. [jv_recind]
    RPARTN,     -- Partner [jv_part]
    RDPOM,      -- Po Per Diff-OM [jv_dpom]
    RDBILLM,    -- Delta InvM [jv_dbillm]
    NPLNR,      -- Network [nplnr]
    AUFPL,      -- TaskList No.Ops [aufpl_ch]
    APLZL,      -- Counter [aplzl_ch]
    VORNR,      -- Activity [vornr]
    TSL,        -- Tran. Crcy [vtcur9_cs]
    HSL,        -- Local crcy [vlcur9_cs]
    KSL,        -- GrpCurr [vgcur9_cs]
    MSL,        -- Quantity [quan1]
    AUNIT,      -- Add.unit/meas. [aunit]
    SGTXT,      -- Text [sgtxt]
    AUTOM,      -- Auto. ID [autom]
    DOCTY,      -- Document Type [blart]
    ACTIV,      -- Bus.transaction [glvor]
    BUDAT,      -- Posting Date [budat]
    WSDAT,      -- Value Date [wsdat]
    VALUT,      -- Value date [valut]
    REFDOCNR,   -- Document Number [belnr_d]
    REFRYEAR,   -- Fiscal Year [gjahr]
    REFDOCLN,   -- Ref. LI [jv_refdln]
    REFDOCCT,   -- Document Categ. [docct]
    REFACTIV,   -- Bus.transaction [glvor]
    REFFIDLN,   -- Item [buzei]
    CPUDT,      -- Entered On [cpudt]
    CPUTM,      -- Entered at [cputm]
    USNAM,      -- User Name [usnam]
    BLDAT,      -- Document Date [bldat]
    BILID,      -- Billing ind. [jv_bilind]
    ORECID,     -- Orig. Rec. Ind [jv_orecid]
    MWSKZ,      -- Tax Code [mwskz]
    BILLM,      -- Billing Month [jv_billm]
    POM,        -- Proc.Oper.Month [jv_pom]
    CBPERIOD,   -- Cutback Period [jv_cbperi]
    EBELN,      -- Purchasing Doc. [ebeln]
    EBELP,      -- Item [ebelp]
    KTOSL,      -- Transaction [ktosl]
    MMACT,      -- MM Activity Type [jv_mm_act]
    LSTAR,      -- Activity Type [lstar]
    CYCLE,      -- Cycle [cycle]
    SDATE,      -- Valid From [sdate]
    SEQNR,      -- Segment number [sqnr]
    SEQNAME,    -- Segment [seqname]
    REFCYC,     -- Reference [jv_refcyc]
    MATNR,      -- Material [matnr]
    CONDI,      -- CondKey [jv_condcod]
    AWTYP,      -- Ref. procedure [awtyp]
    AWORG,      -- Refer. Org.Unit [aworg]
    LOGSYS,     -- Logical system [logsys]
    REFAWTYP,   -- Ref. procedure [awtyp]
    REFAWREF,   -- Reference Doc. [awref]
    REFAWORG,   -- Refer. Org.Unit [aworg]
    REFLOGSYS,  -- Logical system [logsys]
    PRODPER,    -- Prod.Month [jv_prodper]
    PRIMARY KEY (RCLNT, GL_SIRID)
);

Learn More