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