MMSPQTNICNDSCL_D

Transparent Table Application Table
20 Fields 1 CDS Views

Draft table for entity R_SRCGPROJQTNITMCNDNSCALETP

MMSPQTNICNDSCL_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGPROJQTNITMCNDNSCALETP. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SrcgProjQtnItmCndnScaleDraft view_entity from BASIC Cndn Scale for Itm in SrcPrjQtn - Draft

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY conditionrecord knumh Cond.Record No.
KEY conditionsequentialnumbershort kopos Sequent. No. of Cond
KEY conditionscaleline klfn1 Line number
conditionscalequantity kstbm Scale Quantity
conditionscalequantityunit konms Scale UoM
conditionscaleamount kstbw Scale Value
conditionscaleamountcurrency konws Scale Currency
conditionratevalue vdm_conditionratevalue Condition Rate Value
conditionratevalueunit vdm_conditionratevalueunit Unit of Condition Rate Value
conditionrateratio vfprc_element_ratio Ratio
conditionrateratiounit vdm_conditionrateratiounit Unit of Condition Rate Ratio
conditionrateamount vfprc_element_amount Amount
conditionratevalueisamount vdm_conditionratevalueisamount Condition Rate Value Is Amount
conditionratevalueisratio vdm_conditionratevalueisratio Condition Rate Value Is Ratio
conditioncurrency konwa Cond. Currency
sourcingprojectquotationuuid vdm_srcgprojquotationuuid Supplier Quotation UUID
conditionquantity kpein Pricing Unit
conditionquantityunit vdm_conditionquantityunit Condition Quantity Unit
pricingscaletype stfkz Scale Type

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_SRCGPROJQTNITMCNDNSCALETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQTNICNDSCL_D (
    MANDT,                           -- Client [mandt]
    CONDITIONRECORD,                 -- Cond.Record No. [knumh]
    CONDITIONSEQUENTIALNUMBERSHORT,  -- 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,              -- Condition Rate Value [vdm_conditionratevalue]
    CONDITIONRATEVALUEUNIT,          -- Unit of Condition Rate Value [vdm_conditionratevalueunit]
    CONDITIONRATERATIO,              -- Ratio [vfprc_element_ratio]
    CONDITIONRATERATIOUNIT,          -- Unit of Condition Rate Ratio [vdm_conditionrateratiounit]
    CONDITIONRATEAMOUNT,             -- Amount [vfprc_element_amount]
    CONDITIONRATEVALUEISAMOUNT,      -- Condition Rate Value Is Amount [vdm_conditionratevalueisamount]
    CONDITIONRATEVALUEISRATIO,       -- Condition Rate Value Is Ratio [vdm_conditionratevalueisratio]
    CONDITIONCURRENCY,               -- Cond. Currency [konwa]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    CONDITIONQUANTITY,               -- Pricing Unit [kpein]
    CONDITIONQUANTITYUNIT,           -- Condition Quantity Unit [vdm_conditionquantityunit]
    PRICINGSCALETYPE,                -- Scale Type [stfkz]
    PRIMARY KEY (MANDT, CONDITIONRECORD, CONDITIONSEQUENTIALNUMBERSHORT, CONDITIONSCALELINE)
);

Learn More