SCPRVALS

Transparent Table System Table (transport)
7 Fields 1 CDS Views

BC Set: Values

SCPRVALS is an SAP database table in S/4HANA. BC Set: Values. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/FTI/V_EXT_MAINT_SRV_VIEW view left_outer

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY id SCPR_ID BC Set
KEY version SCPR_VERS BC Set version
KEY tablename SCPR_TABL Table/View Name
KEY recnumber SCPR_RECNR Record number
KEY fieldname SCPR_FLD Field name
flag SCPR_FLAG FIX flag
value SCPR_VALUE Value from table

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.

-- BC Set: Values
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCPRVALS (
    ID,         -- BC Set [SCPR_ID]
    VERSION,    -- BC Set version [SCPR_VERS]
    TABLENAME,  -- Table/View Name [SCPR_TABL]
    RECNUMBER,  -- Record number [SCPR_RECNR]
    FIELDNAME,  -- Field name [SCPR_FLD]
    FLAG,       -- FIX flag [SCPR_FLAG]
    VALUE,      -- Value from table [SCPR_VALUE]
    PRIMARY KEY (ID, VERSION, TABLENAME, RECNUMBER, FIELDNAME)
);

Learn More