MATERIALDEMAND

Transparent Table Application Table
15 Fields 1 CDS Views

Enterprise Material Demand

MATERIALDEMAND is an SAP database table in S/4HANA. Enterprise Material Demand. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProjectDemandMaterial view_entity from BASIC Project Demand for Material

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY projectdemandmaterialuuid tv_proj_dmnd_material_uuid Material Demand UUID
projectdemanduuid tv_proj_dmnd_uuid Demand UUID
material tv_material Material Number
materialgroup tv_materialgroup Material Group
supplier tv_desiredsupplier Desired Supplier
purchasinginforecord tv_inforecord Demand Info Record
purchasecontract tv_purchasecontract Purchasing Doc Nmbr
purchasecontractitem tv_purchasecontractitem Contract Item Numbr
materialplanneddeliverydurn tv_planneddeliverytime Pl. Deliv. Time
storagelocation lgort_d Location
createdbyuser abp_creation_user Created By
creationdatetime abp_creation_tstmpl Created On
lastchangedbyuser abp_lastchange_user Changed By
lastchangedatetime abp_lastchange_tstmpl Changed On

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.

-- Enterprise Material Demand
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATERIALDEMAND (
    CLIENT,                       -- Client [mandt]
    PROJECTDEMANDMATERIALUUID,    -- Material Demand UUID [tv_proj_dmnd_material_uuid]
    PROJECTDEMANDUUID,            -- Demand UUID [tv_proj_dmnd_uuid]
    MATERIAL,                     -- Material Number [tv_material]
    MATERIALGROUP,                -- Material Group [tv_materialgroup]
    SUPPLIER,                     -- Desired Supplier [tv_desiredsupplier]
    PURCHASINGINFORECORD,         -- Demand Info Record [tv_inforecord]
    PURCHASECONTRACT,             -- Purchasing Doc Nmbr [tv_purchasecontract]
    PURCHASECONTRACTITEM,         -- Contract Item Numbr [tv_purchasecontractitem]
    MATERIALPLANNEDDELIVERYDURN,  -- Pl. Deliv. Time [tv_planneddeliverytime]
    STORAGELOCATION,              -- Location [lgort_d]
    CREATEDBYUSER,                -- Created By [abp_creation_user]
    CREATIONDATETIME,             -- Created On [abp_creation_tstmpl]
    LASTCHANGEDBYUSER,            -- Changed By [abp_lastchange_user]
    LASTCHANGEDATETIME,           -- Changed On [abp_lastchange_tstmpl]
    PRIMARY KEY (CLIENT, PROJECTDEMANDMATERIALUUID)
);

Learn More