JVSO2

Transparent Table Application Table
49 Fields 2 CDS Views

JV Billing FI-SL Line Item

JVSO2 is an SAP database table in S/4HANA. JV Billing FI-SL Line Item. It contains 49 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
JV_JVSO2_ACDOCA_4B_4D_SWITCH view union JVSO2-like view on ACDOCA/JVSO2
JV_JVSO2_COMB view from Combined view of ledgers 4B/4D on JVSO2

Fields (49)

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
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
rpartn JV_PART Partner
rbilid JV_BILIND Billing ind.
rprojk PS_PSP_PNR WBS Element
rdpom JV_DPOM Po Per Diff-OM
rdbillm JV_DBILLM Delta InvM
tsl VTCUR9_CS Tran. Crcy
hsl VLCUR9_CS Local crcy
ksl VGCUR9_CS GrpCurr
sgtxt SGTXT Text
autom AUTOM Auto. ID
docty DOCTY Document Type
activ GLVOR Bus.transaction
bvorg BVORG Cross-CC Number
budat BUDAT Posting Date
wsdat WSDAT 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
billm JV_BILLM Billing Month
pom JV_POM Proc.Oper.Month
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

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 Billing FI-SL Line Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JVSO2 (
    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]
    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]
    RPARTN,     -- Partner [JV_PART]
    RBILID,     -- Billing ind. [JV_BILIND]
    RPROJK,     -- WBS Element [PS_PSP_PNR]
    RDPOM,      -- Po Per Diff-OM [JV_DPOM]
    RDBILLM,    -- Delta InvM [JV_DBILLM]
    TSL,        -- Tran. Crcy [VTCUR9_CS]
    HSL,        -- Local crcy [VLCUR9_CS]
    KSL,        -- GrpCurr [VGCUR9_CS]
    SGTXT,      -- Text [SGTXT]
    AUTOM,      -- Auto. ID [AUTOM]
    DOCTY,      -- Document Type [DOCTY]
    ACTIV,      -- Bus.transaction [GLVOR]
    BVORG,      -- Cross-CC Number [BVORG]
    BUDAT,      -- Posting Date [BUDAT]
    WSDAT,      -- Value Date [WSDAT]
    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]
    BILLM,      -- Billing Month [JV_BILLM]
    POM,        -- Proc.Oper.Month [JV_POM]
    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]
    PRIMARY KEY (RCLNT, GL_SIRID)
);

Learn More