SDPRCG_CNDNS

Transparent Table Application Table
19 Fields 1 CDS Views

Record Scale

SDPRCG_CNDNS is an SAP database table in S/4HANA. Record Scale. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsPrcgCndnRecordScaleTP view from TRANSACTIONAL Pricing Scale in Sales - TP

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY conditionscaleuuid /BOBF/UUID Key
conditionrecorduuid /BOBF/UUID Key
conditionrecord KNUMH Cond.Record No.
conditionsequentialnumber KOPOS Sequent. No. of Cond
conditionscaleline KLFN1 Line number
conditionscalequantity KSTBM Scale Quantity
conditionscalequantityunit KONMS Scale UoM
conditionscaleamount KSTBW Scale Value
conditionscaleamountcurrency KONWS Scale Currency
conditionratevalue KBETR Amount
conditionratevalueunit KONWA Cond. Currency
conditionrateratio VFPRC_ELEMENT_RATIO Ratio
conditionrateratiounit MSEHIUNIT Unit of Measure
conditionrateamount VFPRC_ELEMENT_AMOUNT Amount
conditioncurrency WAERS Currency
pricingscaletype STFKZ Scale Type
conditionquantity KPEIN Pricing Unit
conditionquantityunit KMEIN Unit of Measure

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.

-- Record Scale
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDPRCG_CNDNS (
    MANDT,                         -- Client [MANDT]
    CONDITIONSCALEUUID,            -- Key [/BOBF/UUID]
    CONDITIONRECORDUUID,           -- Key [/BOBF/UUID]
    CONDITIONRECORD,               -- Cond.Record No. [KNUMH]
    CONDITIONSEQUENTIALNUMBER,     -- Sequent. No. of Cond [KOPOS]
    CONDITIONSCALELINE,            -- Line number [KLFN1]
    CONDITIONSCALEQUANTITY,        -- Scale Quantity [KSTBM]
    CONDITIONSCALEQUANTITYUNIT,    -- Scale UoM [KONMS]
    CONDITIONSCALEAMOUNT,          -- Scale Value [KSTBW]
    CONDITIONSCALEAMOUNTCURRENCY,  -- Scale Currency [KONWS]
    CONDITIONRATEVALUE,            -- Amount [KBETR]
    CONDITIONRATEVALUEUNIT,        -- Cond. Currency [KONWA]
    CONDITIONRATERATIO,            -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONRATERATIOUNIT,        -- Unit of Measure [MSEHIUNIT]
    CONDITIONRATEAMOUNT,           -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONCURRENCY,             -- Currency [WAERS]
    PRICINGSCALETYPE,              -- Scale Type [STFKZ]
    CONDITIONQUANTITY,             -- Pricing Unit [KPEIN]
    CONDITIONQUANTITYUNIT,         -- Unit of Measure [KMEIN]
    PRIMARY KEY (MANDT, CONDITIONSCALEUUID)
);

Learn More