S

S is an SAP database table in S/4HANA. It contains 57 fields.

Fields (57)

KeyField CDS FieldsUsed in Views
KEY belnr belnr 5
KEY bukrs bukrs 5
KEY buzei buzei 4
KEY curtp curtp 1
KEY docln docln 1
KEY gjahr gjahr 6
KEY mandt mandt 1
KEY rbukrs rbukrs 1
KEY rdims_guid boost_id 1
KEY rldnr rldnr 1
KEY spl_no spl_no 1
_dataaging _dataaging 1
awitem awitem 1
bsl_sum bsl 1
budat budat 1
csl_sum csl 1
currtyp currtyp 1
dsl_sum dsl 1
esl_sum esl 1
fcsl_sum fcsl 1
fsl_sum fsl 1
gsl_sum gsl 1
hsl_sum hsl 1
kokrs kokrs 1
ksl_sum ksl 1
OrganizationBPName1 suppliername 1
osl_sum osl 1
Plant Plant 2
prctr prctr 1
rbcur rbcur 1
rccur rccur 1
rdcur rdcur 1
recur recur 1
rfccur rfccur 1
rfcur rfcur 1
rgcur rgcur 1
rhcur rhcur 1
rkcur rkcur 1
rocur rocur 1
rtcur rtcur 1
rvcur rvcur 1
rwcur rwcur 1
segment segment 1
seqno seqno 1
set_id set_id 1
significance significance 1
status_desc StatusSort 1
StorageLocation StorageLocation 2
Supplier suppliernumber 1
Text JobStatusText 1
timestmp_mod_seg changed_on 1
tsl_sum tsl 1
user_id user_id 1
vsl_sum vsl 1
waers waers 1
wrbtr wrbtr 1
wsl_sum wsl 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE S (
    BELNR,
    BUKRS,
    BUZEI,
    CURTP,
    DOCLN,
    GJAHR,
    MANDT,
    RBUKRS,
    RDIMS_GUID,
    RLDNR,
    SPL_NO,
    _DATAAGING,
    AWITEM,
    BSL_SUM,
    BUDAT,
    CSL_SUM,
    CURRTYP,
    DSL_SUM,
    ESL_SUM,
    FCSL_SUM,
    FSL_SUM,
    GSL_SUM,
    HSL_SUM,
    KOKRS,
    KSL_SUM,
    ORGANIZATIONBPNAME1,
    OSL_SUM,
    PLANT,
    PRCTR,
    RBCUR,
    RCCUR,
    RDCUR,
    RECUR,
    RFCCUR,
    RFCUR,
    RGCUR,
    RHCUR,
    RKCUR,
    ROCUR,
    RTCUR,
    RVCUR,
    RWCUR,
    SEGMENT,
    SEQNO,
    SET_ID,
    SIGNIFICANCE,
    STATUS_DESC,
    STORAGELOCATION,
    SUPPLIER,
    TEXT,
    TIMESTMP_MOD_SEG,
    TSL_SUM,
    USER_ID,
    VSL_SUM,
    WAERS,
    WRBTR,
    WSL_SUM,
    PRIMARY KEY (BELNR, BUKRS, BUZEI, CURTP, DOCLN, GJAHR, MANDT, RBUKRS, RDIMS_GUID, RLDNR, SPL_NO)
);