MATERIALSUPPLY

Transparent Table Application Table
15 Fields 1 CDS Views

Material Demand Response

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ProjectDemandMaterialSupply view_entity from BASIC Supply Data of Material Demand

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY projdemandmaterialsupplyuuid TV_PROJ_DMND_MATL_SUPPLY_UUID Mtrl Dmnd Sply UUID
projectdemandmaterialuuid TV_PROJ_DMND_MATERIAL_UUID Material Demand UUID
projectdemanduuid TV_PROJ_DMND_UUID Demand UUID
purchaserequisition TV_PURREQNNUMBER PR Number
purchaserequisitionitem TV_PURREQNITEMNUMBER PR Item Number
createdbyuser ABP_CREATION_USER Created By
creationdatetime ABP_CREATION_TSTMPL Created On
lastchangedbyuser ABP_LASTCHANGE_USER Changed By
lastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
projectdemandrequirementplan TV_PROJ_DMND_RQMT_PLAN Requirement Plan
projdmndplndindeprqmtitem TV_PROJ_DMND_PLNDINDEPRQMTITEM Planned Ind Req Itm
projectdemandreservation TV_PROJ_DMND_RESVN Demand Reservation
projectdemandreservationitem TV_PROJ_DMND_RESVNITEM Reservation Item
projectdemandhasreservation TV_PROJ_DMND_HASRESVN ProjDmnHasRes

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.

-- Material Demand Response
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATERIALSUPPLY (
    CLIENT,                        -- Client [MANDT]
    PROJDEMANDMATERIALSUPPLYUUID,  -- Mtrl Dmnd Sply UUID [TV_PROJ_DMND_MATL_SUPPLY_UUID]
    PROJECTDEMANDMATERIALUUID,     -- Material Demand UUID [TV_PROJ_DMND_MATERIAL_UUID]
    PROJECTDEMANDUUID,             -- Demand UUID [TV_PROJ_DMND_UUID]
    PURCHASEREQUISITION,           -- PR Number [TV_PURREQNNUMBER]
    PURCHASEREQUISITIONITEM,       -- PR Item Number [TV_PURREQNITEMNUMBER]
    CREATEDBYUSER,                 -- Created By [ABP_CREATION_USER]
    CREATIONDATETIME,              -- Created On [ABP_CREATION_TSTMPL]
    LASTCHANGEDBYUSER,             -- Changed By [ABP_LASTCHANGE_USER]
    LASTCHANGEDATETIME,            -- Changed On [ABP_LASTCHANGE_TSTMPL]
    PROJECTDEMANDREQUIREMENTPLAN,  -- Requirement Plan [TV_PROJ_DMND_RQMT_PLAN]
    PROJDMNDPLNDINDEPRQMTITEM,     -- Planned Ind Req Itm [TV_PROJ_DMND_PLNDINDEPRQMTITEM]
    PROJECTDEMANDRESERVATION,      -- Demand Reservation [TV_PROJ_DMND_RESVN]
    PROJECTDEMANDRESERVATIONITEM,  -- Reservation Item [TV_PROJ_DMND_RESVNITEM]
    PROJECTDEMANDHASRESERVATION,   -- ProjDmnHasRes [TV_PROJ_DMND_HASRESVN]
    PRIMARY KEY (CLIENT, PROJDEMANDMATERIALSUPPLYUUID)
);

Learn More