I_SUPDMNDALLDOCDEMAND

CDS View

View for Demand of All Documents

I_SUPDMNDALLDOCDEMAND is a CDS View in S/4HANA. View for Demand of All Documents. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SupDmndAllDocAssgmt view inner COMPOSITE View for Assignment for all Modes
I_SupDmndAllDocTotDmnd view from COMPOSITE View for Total Demand of All Document Types

Fields (20)

KeyField CDS FieldsUsed in Views
BaseUnit BaseUnit 1
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 2
DocumentCurrency DocumentCurrency 2
Material Material 1
MaterialGroup MaterialGroup 2
MaterialType MaterialType 2
NetPriceAmount NetPriceAmount 2
Plant Plant 1
ProductAvailabilityDate ProductAvailabilityDate 1
RequestedDate RequestedDate 1
RequestedDeliveryDate RequestedDeliveryDate 2
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit 1
RequirementDocumentItem RequirementDocumentItem 1
RequirementDocumentNumber RequirementDocumentNumber 1
RequirementSegment RequirementSegment 2
RequirementType RequirementType 1
StorageLocation StorageLocation 1
SupplyProtectionName SupplyProtectionName 2
SupProtTimeBucketUUID SupProtTimeBucketUUID 1

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.

-- View for Demand of All Documents
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCDEMAND (
    BASEUNIT,
    CONFIRMEDRQMTQTYINBASEUNIT,
    CROSSPLANTCONFIGURABLEPRODUCT,
    DOCUMENTCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    MATERIALTYPE,
    NETPRICEAMOUNT,
    PLANT,
    PRODUCTAVAILABILITYDATE,
    REQUESTEDDATE,
    REQUESTEDDELIVERYDATE,
    REQUESTEDRQMTQTYINBASEUNIT,
    REQUIREMENTDOCUMENTITEM,
    REQUIREMENTDOCUMENTNUMBER,
    REQUIREMENTSEGMENT,
    REQUIREMENTTYPE,
    STORAGELOCATION,
    SUPPLYPROTECTIONNAME,
    SUPPROTTIMEBUCKETUUID
);