I_SUPDMNDALLDOCPLNDORDCOMP

CDS View
27 Fields 4 CDS Views

View for Planned Order Components

I_SUPDMNDALLDOCPLNDORDCOMP is a CDS View in S/4HANA. View for Planned Order Components. It contains 27 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SupDmndAllDocDemand view union_all COMPOSITE View for Demand of All Documents
I_SupDmndAllDocPlndOrdComp1C view left_outer COMPOSITE Cube View for Planned Order Components Assignment Details
I_SupDmndAllDocPlndOrdCompC view from COMPOSITE Cube View for Planned Order Components
P_SupDmndAllDocPlndOrdComp view from COMPOSITE View for Planned Order Components

Fields (27)

KeyField CDS FieldsUsed in Views
KEY ProductAvailabilityDate ProductAvailabilityDate 3
KEY RequestedDate RequestedDate 3
KEY RequirementDocumentItem RequirementDocumentItem 3
KEY RequirementDocumentNumber RequirementDocumentNumber 3
KEY RequirementType RequirementType 3
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 1
BaseUnit BaseUnit 3
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
Material Material 3
MaterialGroup MaterialGroup 3
MaterialType MaterialType 1
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 1
OpenQuantity OpenQuantity 1
OrderType OrderType 1
Plant Plant 3
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 1
RequestedDeliveryDate RequestedDeliveryDate 2
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit 1
RequirementSegment RequirementSegment 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
SegmentationStrategy SegmentationStrategy 1
SegmentationStrategyScope SegmentationStrategyScope 1
StorageLocation StorageLocation 3
WithdrawnQuantity WithdrawnQuantity 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 Planned Order Components
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCPLNDORDCOMP (
    PRODUCTAVAILABILITYDATE,
    REQUESTEDDATE,
    REQUIREMENTDOCUMENTITEM,
    REQUIREMENTDOCUMENTNUMBER,
    REQUIREMENTTYPE,
    ASSIGNEDQUANTITYINBASEUNIT,
    BASEUNIT,
    CONFIRMEDRQMTQTYINBASEUNIT,
    CROSSPLANTCONFIGURABLEPRODUCT,
    DELIVEREDQUANTITYINBASEUNIT,
    MATERIAL,
    MATERIALGROUP,
    MATERIALTYPE,
    NORMALASSIGNEDQUANTITYINBSUNT,
    OPENQUANTITY,
    ORDERTYPE,
    PLANT,
    PREVIEWASSIGNEDQUANTITYINBSUNT,
    REQUESTEDDELIVERYDATE,
    REQUESTEDRQMTQTYINBASEUNIT,
    REQUIREMENTSEGMENT,
    SALESORDER,
    SALESORDERITEM,
    SEGMENTATIONSTRATEGY,
    SEGMENTATIONSTRATEGYSCOPE,
    STORAGELOCATION,
    WITHDRAWNQUANTITY,
    PRIMARY KEY (PRODUCTAVAILABILITYDATE, REQUESTEDDATE, REQUIREMENTDOCUMENTITEM, REQUIREMENTDOCUMENTNUMBER, REQUIREMENTTYPE)
);

Learn More