MMSPQTNICNDAMT_D

Transparent Table Application Table
45 Fields 1 CDS Views

Draft table for entity R_SRCGPROJQTNITMCNDNAMOUNTTP

MMSPQTNICNDAMT_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGPROJQTNITMCNDNAMOUNTTP. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SrcgProjQtnItmCndnAmtDraft view_entity from BASIC Cndn Amt for Itm in SrcgProjQtn - Draft

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY conditionrecord knumh Cond.Record No.
KEY conditionsequentialnumbershort kopos Sequent. No. of Cond
conditionvalidityenddate kodatbi Valid To
conditionvaliditystartdate kodatab Valid From
conditiontype kscha Condition Type
conditiontextid knumt Text number
conditioncalculationtypeshort krech Calculat.Type
conditionratevalue kbetr_kond Amount
conditionratevalueunit vdm_conditionratevalueunit Unit of Condition Rate Value
conditionrateamount vfprc_element_amount Amount
conditioncurrency konwa Cond. Currency
conditionrateratio vfprc_element_ratio Ratio
conditionrateratiounit vdm_conditionrateratiounit Unit of Condition Rate Ratio
conditionquantity kpein Pricing Unit
conditionquantityunit vdm_conditionquantityunit Condition Quantity Unit
conditionratevalueisamount vdm_conditionratevalueisamount Condition Rate Value Is Amount
conditionratevalueisratio vdm_conditionratevalueisratio Condition Rate Value Is Ratio
conditiontobaseqtynmrtr kumza Numer.for Conv.
conditiontobaseqtydnmntr kumne Den. for Conv.
baseunit meins Base Unit
conditionlowerlimit mxwrt Lower limit
conditionupperlimit gkwrt Upper limit
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
conditionreleasestatus kfrst Release Status
conditionchangereason cndn_chgreason Cndn Change Reason
cmmdtypricingengineisenabled cond_is_cpe_enabled Enabled for CPE
pricingscaletype stfkz Scale Type
pricingscalebasisshort kzbzg Scale Base Type
pricingscaleline klf_kal Pricing scale
conditionscalequantity kstbm Scale Quantity
conditionscalequantityunit konms Scale UoM
conditionscaleamount kstbw Scale Value
conditionscaleamountcurrency konws Scale Currency
sourcingprojectquotationuuid vdm_srcgprojquotationuuid Supplier Quotation UUID
cmmdtyprcgconditionisactivated boolean Boolean Variable (X = True, - = False, Space = Unknown)

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.

-- Draft table for entity R_SRCGPROJQTNITMCNDNAMOUNTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQTNICNDAMT_D (
    MANDT,                           -- Client [mandt]
    CONDITIONRECORD,                 -- Cond.Record No. [knumh]
    CONDITIONSEQUENTIALNUMBERSHORT,  -- Sequent. No. of Cond [kopos]
    CONDITIONVALIDITYENDDATE,        -- Valid To [kodatbi]
    CONDITIONVALIDITYSTARTDATE,      -- Valid From [kodatab]
    CONDITIONTYPE,                   -- Condition Type [kscha]
    CONDITIONTEXTID,                 -- Text number [knumt]
    CONDITIONCALCULATIONTYPESHORT,   -- Calculat.Type [krech]
    CONDITIONRATEVALUE,              -- Amount [kbetr_kond]
    CONDITIONRATEVALUEUNIT,          -- Unit of Condition Rate Value [vdm_conditionratevalueunit]
    CONDITIONRATEAMOUNT,             -- Amount [vfprc_element_amount]
    CONDITIONCURRENCY,               -- Cond. Currency [konwa]
    CONDITIONRATERATIO,              -- Ratio [vfprc_element_ratio]
    CONDITIONRATERATIOUNIT,          -- Unit of Condition Rate Ratio [vdm_conditionrateratiounit]
    CONDITIONQUANTITY,               -- Pricing Unit [kpein]
    CONDITIONQUANTITYUNIT,           -- Condition Quantity Unit [vdm_conditionquantityunit]
    CONDITIONRATEVALUEISAMOUNT,      -- Condition Rate Value Is Amount [vdm_conditionratevalueisamount]
    CONDITIONRATEVALUEISRATIO,       -- Condition Rate Value Is Ratio [vdm_conditionratevalueisratio]
    CONDITIONTOBASEQTYNMRTR,         -- Numer.for Conv. [kumza]
    CONDITIONTOBASEQTYDNMNTR,        -- Den. for Conv. [kumne]
    BASEUNIT,                        -- Base Unit [meins]
    CONDITIONLOWERLIMIT,             -- Lower limit [mxwrt]
    CONDITIONUPPERLIMIT,             -- Upper limit [gkwrt]
    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]
    CONDITIONRELEASESTATUS,          -- Release Status [kfrst]
    CONDITIONCHANGEREASON,           -- Cndn Change Reason [cndn_chgreason]
    CMMDTYPRICINGENGINEISENABLED,    -- Enabled for CPE [cond_is_cpe_enabled]
    PRICINGSCALETYPE,                -- Scale Type [stfkz]
    PRICINGSCALEBASISSHORT,          -- Scale Base Type [kzbzg]
    PRICINGSCALELINE,                -- Pricing scale [klf_kal]
    CONDITIONSCALEQUANTITY,          -- Scale Quantity [kstbm]
    CONDITIONSCALEQUANTITYUNIT,      -- Scale UoM [konms]
    CONDITIONSCALEAMOUNT,            -- Scale Value [kstbw]
    CONDITIONSCALEAMOUNTCURRENCY,    -- Scale Currency [konws]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    CMMDTYPRCGCONDITIONISACTIVATED,  -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PRIMARY KEY (MANDT, CONDITIONRECORD, CONDITIONSEQUENTIALNUMBERSHORT)
);

Learn More