SDPRCG_CNDNR

Transparent Table Application Table
62 Fields 1 CDS Views

Condition Record for Pricing in Sales

SDPRCG_CNDNR is an SAP database table in S/4HANA. Condition Record for Pricing in Sales. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsPricingConditionRecordTP view from TRANSACTIONAL Condition Record for Pricing in Sales

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY conditionrecorduuid /BOBF/UUID Key
conditionrecord KNUMH Cond.Record No.
conditionsequentialnumber KOPOS Sequent. No. of Cond
conditiontable KOTABNR_CHAR Condition Table
conditionapplication KAPPL Application
conditiontype KSCHA Condition Type
conditionvalidityenddate DATBI Valid To
conditionvaliditystartdate DATAB Valid From
createdbyuser ERNAM Created By
creationdate ERDAT Created On
conditiontextid KNUMT Text number
pricingscaletype STFKZ Scale Type
pricingscalebasis KZBZG Scale Base Type
conditionscalequantity KSTBM Scale Quantity
conditionscalequantityunit KONMS Scale UoM
conditionscaleamount KSTBW Scale Value
conditionscaleamountcurrency KONWS Scale Currency
conditioncalculationtype KRECH Calculat.Type
conditionratevalue KBETR_KOND Amount
conditionratevalueunit KONWA Cond. Currency
conditionrateratio VFPRC_ELEMENT_RATIO Ratio
conditionrateratiounit MSEHIUNIT Unit of Measure
conditionrateamount VFPRC_ELEMENT_AMOUNT Amount
conditioncurrency WAERS Currency
conditionquantity KPEIN Pricing Unit
conditionquantityunit KMEIN Unit of Measure
conditiontobaseqtynmrtr KUMZA Numer.for Conv.
conditiontobaseqtydnmntr KUMNE Den. for Conv.
baseunit MEINS Base Unit
conditionlowerlimit MXWRT Lower limit
conditionlowerlimitamount VFPRC_ELEMENT_AMOUNT Amount
conditionlowerlimitratio VFPRC_ELEMENT_RATIO Ratio
conditionupperlimit GKWRT Upper limit
conditionupperlimitamount VFPRC_ELEMENT_AMOUNT Amount
conditionupperlimitratio VFPRC_ELEMENT_RATIO Ratio
conditionalternativecurrency KWAEH Cndn Currency
conditionexclusion KZNEP Exclusion
conditionisdeleted LOEVM_KO Deletion Indic.
additionalvaluedays VALTG Add. Value Days
fixedvaluedate VALDT Fixed Val. Date
paymentterms DZTERM Pyt Terms
cndnmaxnumberofsalesorders ANZAUF NumberOfOrders
minimumconditionbasisvalue MIKBAS MinCondBaseVal.
maximumconditionbasisvalue MXKBAS MaxCondBaseVal.
maximumconditionamount KOMXWRT MaxConditValue
incrementalscale KLF_STG Increment scale
pricingscaleline KLF_KAL Pricing scale
conditionreleasestatus KFRST Release Status
salespriceapprovalrequest SALESPRICEAPPROVALREQUEST Sales Price Aprv Req
conditionchangereason CNDN_CHGREASON Cndn Change Reason
prevapprovedconditionrecord KNUMH_PREV_APRVD Cond.Record No.
pricingscalecheckingrule KSTPR Check Scale
conditiontaxcode MWSKZ Tax Code
conditionwithholdingtaxcode WT_WITHCD W/Tax Code
taxexemptionlicense LICNO License Number
licensegrantdate LICDT License Date
conditionistaxrate BOOLE_D TRUE
conditioniswithholdingtax BOOLE_D TRUE
conditionistaxwithexemption BOOLE_D TRUE
conditionclass KOAID Condition Class
conditioncategory KNTYP Condit.Category

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.

-- Condition Record for Pricing in Sales
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDPRCG_CNDNR (
    MANDT,                         -- Client [MANDT]
    CONDITIONRECORDUUID,           -- Key [/BOBF/UUID]
    CONDITIONRECORD,               -- Cond.Record No. [KNUMH]
    CONDITIONSEQUENTIALNUMBER,     -- Sequent. No. of Cond [KOPOS]
    CONDITIONTABLE,                -- Condition Table [KOTABNR_CHAR]
    CONDITIONAPPLICATION,          -- Application [KAPPL]
    CONDITIONTYPE,                 -- Condition Type [KSCHA]
    CONDITIONVALIDITYENDDATE,      -- Valid To [DATBI]
    CONDITIONVALIDITYSTARTDATE,    -- Valid From [DATAB]
    CREATEDBYUSER,                 -- Created By [ERNAM]
    CREATIONDATE,                  -- Created On [ERDAT]
    CONDITIONTEXTID,               -- Text number [KNUMT]
    PRICINGSCALETYPE,              -- Scale Type [STFKZ]
    PRICINGSCALEBASIS,             -- Scale Base Type [KZBZG]
    CONDITIONSCALEQUANTITY,        -- Scale Quantity [KSTBM]
    CONDITIONSCALEQUANTITYUNIT,    -- Scale UoM [KONMS]
    CONDITIONSCALEAMOUNT,          -- Scale Value [KSTBW]
    CONDITIONSCALEAMOUNTCURRENCY,  -- Scale Currency [KONWS]
    CONDITIONCALCULATIONTYPE,      -- Calculat.Type [KRECH]
    CONDITIONRATEVALUE,            -- Amount [KBETR_KOND]
    CONDITIONRATEVALUEUNIT,        -- Cond. Currency [KONWA]
    CONDITIONRATERATIO,            -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONRATERATIOUNIT,        -- Unit of Measure [MSEHIUNIT]
    CONDITIONRATEAMOUNT,           -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONCURRENCY,             -- Currency [WAERS]
    CONDITIONQUANTITY,             -- Pricing Unit [KPEIN]
    CONDITIONQUANTITYUNIT,         -- Unit of Measure [KMEIN]
    CONDITIONTOBASEQTYNMRTR,       -- Numer.for Conv. [KUMZA]
    CONDITIONTOBASEQTYDNMNTR,      -- Den. for Conv. [KUMNE]
    BASEUNIT,                      -- Base Unit [MEINS]
    CONDITIONLOWERLIMIT,           -- Lower limit [MXWRT]
    CONDITIONLOWERLIMITAMOUNT,     -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONLOWERLIMITRATIO,      -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONUPPERLIMIT,           -- Upper limit [GKWRT]
    CONDITIONUPPERLIMITAMOUNT,     -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONUPPERLIMITRATIO,      -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONALTERNATIVECURRENCY,  -- Cndn Currency [KWAEH]
    CONDITIONEXCLUSION,            -- Exclusion [KZNEP]
    CONDITIONISDELETED,            -- Deletion Indic. [LOEVM_KO]
    ADDITIONALVALUEDAYS,           -- Add. Value Days [VALTG]
    FIXEDVALUEDATE,                -- Fixed Val. Date [VALDT]
    PAYMENTTERMS,                  -- Pyt Terms [DZTERM]
    CNDNMAXNUMBEROFSALESORDERS,    -- NumberOfOrders [ANZAUF]
    MINIMUMCONDITIONBASISVALUE,    -- MinCondBaseVal. [MIKBAS]
    MAXIMUMCONDITIONBASISVALUE,    -- MaxCondBaseVal. [MXKBAS]
    MAXIMUMCONDITIONAMOUNT,        -- MaxConditValue [KOMXWRT]
    INCREMENTALSCALE,              -- Increment scale [KLF_STG]
    PRICINGSCALELINE,              -- Pricing scale [KLF_KAL]
    CONDITIONRELEASESTATUS,        -- Release Status [KFRST]
    SALESPRICEAPPROVALREQUEST,     -- Sales Price Aprv Req [SALESPRICEAPPROVALREQUEST]
    CONDITIONCHANGEREASON,         -- Cndn Change Reason [CNDN_CHGREASON]
    PREVAPPROVEDCONDITIONRECORD,   -- Cond.Record No. [KNUMH_PREV_APRVD]
    PRICINGSCALECHECKINGRULE,      -- Check Scale [KSTPR]
    CONDITIONTAXCODE,              -- Tax Code [MWSKZ]
    CONDITIONWITHHOLDINGTAXCODE,   -- W/Tax Code [WT_WITHCD]
    TAXEXEMPTIONLICENSE,           -- License Number [LICNO]
    LICENSEGRANTDATE,              -- License Date [LICDT]
    CONDITIONISTAXRATE,            -- TRUE [BOOLE_D]
    CONDITIONISWITHHOLDINGTAX,     -- TRUE [BOOLE_D]
    CONDITIONISTAXWITHEXEMPTION,   -- TRUE [BOOLE_D]
    CONDITIONCLASS,                -- Condition Class [KOAID]
    CONDITIONCATEGORY,             -- Condit.Category [KNTYP]
    PRIMARY KEY (MANDT, CONDITIONRECORDUUID)
);

Learn More