MMSPICNDNAMTH_D

Transparent Table Application Table
31 Fields 1 CDS Views

Draft table for entity R_SPITEMCNDNAMOUNTHIERARCHYTP

MMSPICNDNAMTH_D is an SAP database table in S/4HANA. Draft table for entity R_SPITEMCNDNAMOUNTHIERARCHYTP. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SPItmCndnAmtHierarchyDraft view_entity from BASIC Hierarchy Cndn Amt for SPItm - Draft

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY srcgprojitemcndnamountuuid VDM_SRCGPROJCNDNAMOUNTUUID Srcg Proj Item Condition Amount UUID
sourcingprojectuuid VDM_SOURCINGPROJECTUUID Sourcing Project UUID
srcgprojitemcndnvaldtyuuid VDM_SRCGPROJCNDNVLDTYUUID Srcg Proj Item Condition Validity UUID
sourcingprojectitemuuid VDM_SOURCINGPROJECTITEMUUID Item UUID
spitmconditionamountparentuuid VDM_SRCGPROJCNDNAMOUNTUUID Srcg Proj Item Condition Amount UUID
conditiontype KSCHA Condition Type
srcgprojitemcndnismand VDM_SRCGPROJITEMCNDNISMAND Condition is Mandatory
srcgprojitemcndnisexcld VDM_SRCGPROJITEMCNDNISEXCLD Condition is Excluded
srcgprojpricingscalebasis KZBZG Scale Base Type
conditionrecord KNUMH Cond.Record No.
conditionquantity KPEIN Pricing Unit
conditionquantityunit KMEIN Unit of Measure
conditionsequentialnumbershort KOPOS Sequent. No. of Cond
conditionvaliditystartdate KODATAB Valid From
conditionvalidityenddate KODATBI Valid To
cmmdtypricingengineisenabled COND_IS_CPE_ENABLED Enabled for CPE
suplrcostbreakdownisrelevant VDM_SUPLRCBDTEMPLISRELEVANT Condition is Relevant for Cost Breakdown
sourcingorigin VDM_SOURCINGORIGIN Sourcing Origin
sourcingscenario VDM_SOURCINGSCENARIO Integration Scenario
procmthubplantuniqueid MMPUR_BE_PLANT_UNIQUE_ID Plant Unique ID
procurementhubsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
procurementhubsourcesystemname MMPUR_D_SOURCE_SYS_NAME Connected Sys Name
procmthubplant MMPUR_D_PLANT Connected Plant
procmthubplantname WERKS_NAME Plant Name
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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_SPITEMCNDNAMOUNTHIERARCHYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPICNDNAMTH_D (
    MANDT,                           -- Client [MANDT]
    SRCGPROJITEMCNDNAMOUNTUUID,      -- Srcg Proj Item Condition Amount UUID [VDM_SRCGPROJCNDNAMOUNTUUID]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [VDM_SOURCINGPROJECTUUID]
    SRCGPROJITEMCNDNVALDTYUUID,      -- Srcg Proj Item Condition Validity UUID [VDM_SRCGPROJCNDNVLDTYUUID]
    SOURCINGPROJECTITEMUUID,         -- Item UUID [VDM_SOURCINGPROJECTITEMUUID]
    SPITMCONDITIONAMOUNTPARENTUUID,  -- Srcg Proj Item Condition Amount UUID [VDM_SRCGPROJCNDNAMOUNTUUID]
    CONDITIONTYPE,                   -- Condition Type [KSCHA]
    SRCGPROJITEMCNDNISMAND,          -- Condition is Mandatory [VDM_SRCGPROJITEMCNDNISMAND]
    SRCGPROJITEMCNDNISEXCLD,         -- Condition is Excluded [VDM_SRCGPROJITEMCNDNISEXCLD]
    SRCGPROJPRICINGSCALEBASIS,       -- Scale Base Type [KZBZG]
    CONDITIONRECORD,                 -- Cond.Record No. [KNUMH]
    CONDITIONQUANTITY,               -- Pricing Unit [KPEIN]
    CONDITIONQUANTITYUNIT,           -- Unit of Measure [KMEIN]
    CONDITIONSEQUENTIALNUMBERSHORT,  -- Sequent. No. of Cond [KOPOS]
    CONDITIONVALIDITYSTARTDATE,      -- Valid From [KODATAB]
    CONDITIONVALIDITYENDDATE,        -- Valid To [KODATBI]
    CMMDTYPRICINGENGINEISENABLED,    -- Enabled for CPE [COND_IS_CPE_ENABLED]
    SUPLRCOSTBREAKDOWNISRELEVANT,    -- Condition is Relevant for Cost Breakdown [VDM_SUPLRCBDTEMPLISRELEVANT]
    SOURCINGORIGIN,                  -- Sourcing Origin [VDM_SOURCINGORIGIN]
    SOURCINGSCENARIO,                -- Integration Scenario [VDM_SOURCINGSCENARIO]
    PROCMTHUBPLANTUNIQUEID,          -- Plant Unique ID [MMPUR_BE_PLANT_UNIQUE_ID]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [MMPUR_D_SOURCE_SYS]
    PROCUREMENTHUBSOURCESYSTEMNAME,  -- Connected Sys Name [MMPUR_D_SOURCE_SYS_NAME]
    PROCMTHUBPLANT,                  -- Connected Plant [MMPUR_D_PLANT]
    PROCMTHUBPLANTNAME,              -- Plant Name [WERKS_NAME]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, SRCGPROJITEMCNDNAMOUNTUUID)
);

Learn More