P_SUPASSGMTDMNDDETS

CDS View

P_SUPASSGMTDMNDDETS is a CDS View in S/4HANA. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SupAssgmtDmndDets view from COMPOSITE Supply Assignment Demand Order Item Details

Fields (10)

KeyField CDS FieldsUsed in Views
KEY RequirementDocumentItem RequirementDocumentItem 1
KEY RequirementDocumentNumber RequirementDocumentNumber 1
KEY RequirementType RequirementType 1
BaseUnit BaseUnit 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 1
Material Material 1
MaterialGroup MaterialGroup 1
NetPriceAmount NetPriceAmount 1
Plant Plant 1
RequestedDeliveryDate RequestedDeliveryDate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SUPASSGMTDMNDDETS (
    REQUIREMENTDOCUMENTITEM,
    REQUIREMENTDOCUMENTNUMBER,
    REQUIREMENTTYPE,
    BASEUNIT,
    CROSSPLANTCONFIGURABLEPRODUCT,
    MATERIAL,
    MATERIALGROUP,
    NETPRICEAMOUNT,
    PLANT,
    REQUESTEDDELIVERYDATE,
    PRIMARY KEY (REQUIREMENTDOCUMENTITEM, REQUIREMENTDOCUMENTNUMBER, REQUIREMENTTYPE)
);