MMSPITMCNDVAL

Transparent Table Application Table
10 Fields 1 CDS Views

Sourcing Project Item Condition Validity

MMSPITMCNDVAL is an SAP database table in S/4HANA. Sourcing Project Item Condition Validity. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SrcgProjItmCndnValidity view from BASIC Condition Validity of Srcg Project Item

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY srcgprojitemcndnvaldtyuuid VDM_SRCGPROJCNDNVLDTYUUID Srcg Proj Item Condition Validity UUID
sourcingprojectuuid VDM_SOURCINGPROJECTUUID Sourcing Project UUID
sourcingprojectitemuuid VDM_SOURCINGPROJECTITEMUUID Item UUID
conditionvaliditystartdate KODATAB Valid From
conditionvalidityenddate KODATBI Valid To
procmthubplantuniqueid MMPUR_BE_PLANT_UNIQUE_ID Plant Unique ID
conditiontype KSCHA Condition Type
sourcingorigin VDM_SOURCINGORIGIN Sourcing Origin
sourcingscenario VDM_SOURCINGSCENARIO Integration Scenario

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.

-- Sourcing Project Item Condition Validity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPITMCNDVAL (
    MANDT,                       -- Client [MANDT]
    SRCGPROJITEMCNDNVALDTYUUID,  -- Srcg Proj Item Condition Validity UUID [VDM_SRCGPROJCNDNVLDTYUUID]
    SOURCINGPROJECTUUID,         -- Sourcing Project UUID [VDM_SOURCINGPROJECTUUID]
    SOURCINGPROJECTITEMUUID,     -- Item UUID [VDM_SOURCINGPROJECTITEMUUID]
    CONDITIONVALIDITYSTARTDATE,  -- Valid From [KODATAB]
    CONDITIONVALIDITYENDDATE,    -- Valid To [KODATBI]
    PROCMTHUBPLANTUNIQUEID,      -- Plant Unique ID [MMPUR_BE_PLANT_UNIQUE_ID]
    CONDITIONTYPE,               -- Condition Type [KSCHA]
    SOURCINGORIGIN,              -- Sourcing Origin [VDM_SOURCINGORIGIN]
    SOURCINGSCENARIO,            -- Integration Scenario [VDM_SOURCINGSCENARIO]
    PRIMARY KEY (MANDT, SRCGPROJITEMCNDNVALDTYUUID)
);

Learn More