JVTO1

Transparent Table Application Table
135 Fields 6 CDS Views

JV Summary Table with Objects

JVTO1 is an SAP database table in S/4HANA. JV Summary Table with Objects. It contains 135 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FJV_MIG_JVTO1_ENH view from View on JVTO1 with combined currencies
JV_JVTO1_ACDOCA_4A_4C_SWITCH view union JVTO1-like view on ACDOCA w/ JV ledgers
JV_JVTO1_ACDOCA_CFW_PREP view union JVTO1-like ACDOCA view for CFW amnts PR
JV_JVTO1_T8JTPM_COMB view from Combined view for JVTO1 and T8JTPM
JV_JVTO1_T8JTPM_COMB_4A_4C view from Combined view for JVTO1 and T8JTPM
JV_JVTO1_T8JTPM_JV view from Combined view for JVTO1 and T8JTPM

Fields (135)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY rldnr rldnr Ledger
KEY rrcty rrcty Record Type
KEY rvers rvers Version
KEY ryear gjahr Fiscal Year
KEY robjnr gobjnr_r Object number
KEY cobjnr gobjnr_c Trans.objct no.
KEY sobjnr gobjnr_s Partner obj.no.
KEY rtcur rtcur Currency
KEY runit meins Base Unit
KEY drcrk shkzg Debit/Credit
KEY rpmax rpmax Period
rbukrs bukrs Company Code
rjvnam jv_name Joint venture
regrou jv_egroup Equity group
racct racct Account Number
rbusa gsber Business 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
rkokrs kokrs CO Area
nplnr nplnr Network
vornr vornr Activity
aufpl aufpl_ch TaskList No.Ops
aplzl aplzl_ch Counter
tslvt tslvt9_cs Bal. c/f TC
tsl01 tslxx9_cs Total TC
tsl02 tslxx9_cs Total TC
tsl03 tslxx9_cs Total TC
tsl04 tslxx9_cs Total TC
tsl05 tslxx9_cs Total TC
tsl06 tslxx9_cs Total TC
tsl07 tslxx9_cs Total TC
tsl08 tslxx9_cs Total TC
tsl09 tslxx9_cs Total TC
tsl10 tslxx9_cs Total TC
tsl11 tslxx9_cs Total TC
tsl12 tslxx9_cs Total TC
tsl13 tslxx9_cs Total TC
tsl14 tslxx9_cs Total TC
tsl15 tslxx9_cs Total TC
tsl16 tslxx9_cs Total TC
hslvt hslvt9_cs Bal. c/f LC
hsl01 hslxx9_cs Total LC
hsl02 hslxx9_cs Total LC
hsl03 hslxx9_cs Total LC
hsl04 hslxx9_cs Total LC
hsl05 hslxx9_cs Total LC
hsl06 hslxx9_cs Total LC
hsl07 hslxx9_cs Total LC
hsl08 hslxx9_cs Total LC
hsl09 hslxx9_cs Total LC
hsl10 hslxx9_cs Total LC
hsl11 hslxx9_cs Total LC
hsl12 hslxx9_cs Total LC
hsl13 hslxx9_cs Total LC
hsl14 hslxx9_cs Total LC
hsl15 hslxx9_cs Total LC
hsl16 hslxx9_cs Total LC
kslvt kslvt9_cs Bal. c/f GC
ksl01 kslxx9_cs Total GC
ksl02 kslxx9_cs Total GC
ksl03 kslxx9_cs Total GC
ksl04 kslxx9_cs Total GC
ksl05 kslxx9_cs Total GC
ksl06 kslxx9_cs Total GC
ksl07 kslxx9_cs Total GC
ksl08 kslxx9_cs Total GC
ksl09 kslxx9_cs Total GC
ksl10 kslxx9_cs Total GC
ksl11 kslxx9_cs Total GC
ksl12 kslxx9_cs Total GC
ksl13 kslxx9_cs Total GC
ksl14 kslxx9_cs Total GC
ksl15 kslxx9_cs Total GC
ksl16 kslxx9_cs Total GC
mslvt mslvt Qty c/f balance
msl01 mslxx Quantity
msl02 mslxx Quantity
msl03 mslxx Quantity
msl04 mslxx Quantity
msl05 mslxx Quantity
msl06 mslxx Quantity
msl07 mslxx Quantity
msl08 mslxx Quantity
msl09 mslxx Quantity
msl10 mslxx Quantity
msl11 mslxx Quantity
msl12 mslxx Quantity
msl13 mslxx Quantity
msl14 mslxx Quantity
msl15 mslxx Quantity
msl16 mslxx Quantity
cspred cspred Distr. key currency
qspred qspred Dist. key quantities
ctslvt jv_tslvt9 C BCF Tran.Curr
ctsl01 jv_tslxx9 C Total TC
ctsl02 jv_tslxx9 C Total TC
ctsl03 jv_tslxx9 C Total TC
ctsl04 jv_tslxx9 C Total TC
ctsl05 jv_tslxx9 C Total TC
ctsl06 jv_tslxx9 C Total TC
ctsl07 jv_tslxx9 C Total TC
ctsl08 jv_tslxx9 C Total TC
ctsl09 jv_tslxx9 C Total TC
ctsl10 jv_tslxx9 C Total TC
ctsl11 jv_tslxx9 C Total TC
ctsl12 jv_tslxx9 C Total TC
ctsl13 jv_tslxx9 C Total TC
ctsl14 jv_tslxx9 C Total TC
ctsl15 jv_tslxx9 C Total TC
ctsl16 jv_tslxx9 C Total TC
chslvt jv_hslvt9 C BCF Loc.Curr
chsl01 jv_hslxx9 C Total LC
chsl02 jv_hslxx9 C Total LC
chsl03 jv_hslxx9 C Total LC
chsl04 jv_hslxx9 C Total LC
chsl05 jv_hslxx9 C Total LC
chsl06 jv_hslxx9 C Total LC
chsl07 jv_hslxx9 C Total LC
chsl08 jv_hslxx9 C Total LC
chsl09 jv_hslxx9 C Total LC
chsl10 jv_hslxx9 C Total LC
chsl11 jv_hslxx9 C Total LC
chsl12 jv_hslxx9 C Total LC
chsl13 jv_hslxx9 C Total LC
chsl14 jv_hslxx9 C Total LC
chsl15 jv_hslxx9 C Total LC
chsl16 jv_hslxx9 C Total LC

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 Summary Table with Objects
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JVTO1 (
    RCLNT,   -- Client [mandt]
    RLDNR,   -- Ledger [rldnr]
    RRCTY,   -- Record Type [rrcty]
    RVERS,   -- Version [rvers]
    RYEAR,   -- Fiscal Year [gjahr]
    ROBJNR,  -- Object number [gobjnr_r]
    COBJNR,  -- Trans.objct no. [gobjnr_c]
    SOBJNR,  -- Partner obj.no. [gobjnr_s]
    RTCUR,   -- Currency [rtcur]
    RUNIT,   -- Base Unit [meins]
    DRCRK,   -- Debit/Credit [shkzg]
    RPMAX,   -- Period [rpmax]
    RBUKRS,  -- Company Code [bukrs]
    RJVNAM,  -- Joint venture [jv_name]
    REGROU,  -- Equity group [jv_egroup]
    RACCT,   -- Account Number [racct]
    RBUSA,   -- Business Area [gsber]
    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]
    RKOKRS,  -- CO Area [kokrs]
    NPLNR,   -- Network [nplnr]
    VORNR,   -- Activity [vornr]
    AUFPL,   -- TaskList No.Ops [aufpl_ch]
    APLZL,   -- Counter [aplzl_ch]
    TSLVT,   -- Bal. c/f TC [tslvt9_cs]
    TSL01,   -- Total TC [tslxx9_cs]
    TSL02,   -- Total TC [tslxx9_cs]
    TSL03,   -- Total TC [tslxx9_cs]
    TSL04,   -- Total TC [tslxx9_cs]
    TSL05,   -- Total TC [tslxx9_cs]
    TSL06,   -- Total TC [tslxx9_cs]
    TSL07,   -- Total TC [tslxx9_cs]
    TSL08,   -- Total TC [tslxx9_cs]
    TSL09,   -- Total TC [tslxx9_cs]
    TSL10,   -- Total TC [tslxx9_cs]
    TSL11,   -- Total TC [tslxx9_cs]
    TSL12,   -- Total TC [tslxx9_cs]
    TSL13,   -- Total TC [tslxx9_cs]
    TSL14,   -- Total TC [tslxx9_cs]
    TSL15,   -- Total TC [tslxx9_cs]
    TSL16,   -- Total TC [tslxx9_cs]
    HSLVT,   -- Bal. c/f LC [hslvt9_cs]
    HSL01,   -- Total LC [hslxx9_cs]
    HSL02,   -- Total LC [hslxx9_cs]
    HSL03,   -- Total LC [hslxx9_cs]
    HSL04,   -- Total LC [hslxx9_cs]
    HSL05,   -- Total LC [hslxx9_cs]
    HSL06,   -- Total LC [hslxx9_cs]
    HSL07,   -- Total LC [hslxx9_cs]
    HSL08,   -- Total LC [hslxx9_cs]
    HSL09,   -- Total LC [hslxx9_cs]
    HSL10,   -- Total LC [hslxx9_cs]
    HSL11,   -- Total LC [hslxx9_cs]
    HSL12,   -- Total LC [hslxx9_cs]
    HSL13,   -- Total LC [hslxx9_cs]
    HSL14,   -- Total LC [hslxx9_cs]
    HSL15,   -- Total LC [hslxx9_cs]
    HSL16,   -- Total LC [hslxx9_cs]
    KSLVT,   -- Bal. c/f GC [kslvt9_cs]
    KSL01,   -- Total GC [kslxx9_cs]
    KSL02,   -- Total GC [kslxx9_cs]
    KSL03,   -- Total GC [kslxx9_cs]
    KSL04,   -- Total GC [kslxx9_cs]
    KSL05,   -- Total GC [kslxx9_cs]
    KSL06,   -- Total GC [kslxx9_cs]
    KSL07,   -- Total GC [kslxx9_cs]
    KSL08,   -- Total GC [kslxx9_cs]
    KSL09,   -- Total GC [kslxx9_cs]
    KSL10,   -- Total GC [kslxx9_cs]
    KSL11,   -- Total GC [kslxx9_cs]
    KSL12,   -- Total GC [kslxx9_cs]
    KSL13,   -- Total GC [kslxx9_cs]
    KSL14,   -- Total GC [kslxx9_cs]
    KSL15,   -- Total GC [kslxx9_cs]
    KSL16,   -- Total GC [kslxx9_cs]
    MSLVT,   -- Qty c/f balance [mslvt]
    MSL01,   -- Quantity [mslxx]
    MSL02,   -- Quantity [mslxx]
    MSL03,   -- Quantity [mslxx]
    MSL04,   -- Quantity [mslxx]
    MSL05,   -- Quantity [mslxx]
    MSL06,   -- Quantity [mslxx]
    MSL07,   -- Quantity [mslxx]
    MSL08,   -- Quantity [mslxx]
    MSL09,   -- Quantity [mslxx]
    MSL10,   -- Quantity [mslxx]
    MSL11,   -- Quantity [mslxx]
    MSL12,   -- Quantity [mslxx]
    MSL13,   -- Quantity [mslxx]
    MSL14,   -- Quantity [mslxx]
    MSL15,   -- Quantity [mslxx]
    MSL16,   -- Quantity [mslxx]
    CSPRED,  -- Distr. key currency [cspred]
    QSPRED,  -- Dist. key quantities [qspred]
    CTSLVT,  -- C BCF Tran.Curr [jv_tslvt9]
    CTSL01,  -- C Total TC [jv_tslxx9]
    CTSL02,  -- C Total TC [jv_tslxx9]
    CTSL03,  -- C Total TC [jv_tslxx9]
    CTSL04,  -- C Total TC [jv_tslxx9]
    CTSL05,  -- C Total TC [jv_tslxx9]
    CTSL06,  -- C Total TC [jv_tslxx9]
    CTSL07,  -- C Total TC [jv_tslxx9]
    CTSL08,  -- C Total TC [jv_tslxx9]
    CTSL09,  -- C Total TC [jv_tslxx9]
    CTSL10,  -- C Total TC [jv_tslxx9]
    CTSL11,  -- C Total TC [jv_tslxx9]
    CTSL12,  -- C Total TC [jv_tslxx9]
    CTSL13,  -- C Total TC [jv_tslxx9]
    CTSL14,  -- C Total TC [jv_tslxx9]
    CTSL15,  -- C Total TC [jv_tslxx9]
    CTSL16,  -- C Total TC [jv_tslxx9]
    CHSLVT,  -- C BCF Loc.Curr [jv_hslvt9]
    CHSL01,  -- C Total LC [jv_hslxx9]
    CHSL02,  -- C Total LC [jv_hslxx9]
    CHSL03,  -- C Total LC [jv_hslxx9]
    CHSL04,  -- C Total LC [jv_hslxx9]
    CHSL05,  -- C Total LC [jv_hslxx9]
    CHSL06,  -- C Total LC [jv_hslxx9]
    CHSL07,  -- C Total LC [jv_hslxx9]
    CHSL08,  -- C Total LC [jv_hslxx9]
    CHSL09,  -- C Total LC [jv_hslxx9]
    CHSL10,  -- C Total LC [jv_hslxx9]
    CHSL11,  -- C Total LC [jv_hslxx9]
    CHSL12,  -- C Total LC [jv_hslxx9]
    CHSL13,  -- C Total LC [jv_hslxx9]
    CHSL14,  -- C Total LC [jv_hslxx9]
    CHSL15,  -- C Total LC [jv_hslxx9]
    CHSL16,  -- C Total LC [jv_hslxx9]
    PRIMARY KEY (RCLNT, RLDNR, RRCTY, RVERS, RYEAR, ROBJNR, COBJNR, SOBJNR, RTCUR, RUNIT, DRCRK, RPMAX)
);

Learn More