P_SUPDMNDSUPASSGMTDMND

CDS View

P_SUPDMNDSUPASSGMTDMND is a CDS View in S/4HANA. It contains 3 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_ARunOvwDemand view left_outer COMPOSITE Supply Assignment Run Demand View
I_SupDmndAllDocProdnOrdComp view left_outer COMPOSITE View for Production Order Components
I_SupDmndAllDocPurOrdComp view left_outer COMPOSITE View for Sub Contracting Purchase Order Components
I_SupDmndAllDocSD view left_outer COMPOSITE View for Sales Document
I_SupDmndAllDocSTO view left_outer COMPOSITE View for Stock Transport Order
I_SupDmndOvwTotalDemand view left_outer COMPOSITE Basic View for Demand

Fields (3)

KeyField CDS FieldsUsed in Views
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 4
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 4
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 4

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_SUPDMNDSUPASSGMTDMND (
    ASSIGNEDQUANTITYINBASEUNIT,
    NORMALASSIGNEDQUANTITYINBSUNT,
    PREVIEWASSIGNEDQUANTITYINBSUNT
);