I_SUPDMNDALLDOCPURORDCOMPBSC

CDS View
26 Fields 6 CDS Views

Basic View for Sub Contracting Purchase Order Components

I_SUPDMNDALLDOCPURORDCOMPBSC is a CDS View in S/4HANA. Basic View for Sub Contracting Purchase Order Components. It contains 26 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_SupDmndAllDocDemand view union_all COMPOSITE View for Demand of All Documents
I_SupDmndAllDocPurOrdComp view from COMPOSITE View for Sub Contracting Purchase Order Components
I_SupDmndAllDocPurOrdComp1C view inner COMPOSITE Cube View for Sub Contracting PO Components Assignments
I_SupDmndAllDocPurOrdCompC view from COMPOSITE Cube View for Sub Contracting Purchase Order Components
I_SupDmndOvwDemand view union_all COMPOSITE SDO Demand Basic View
P_ARunDmndMntrSubcontrgDeliver view from CONSUMPTION P view for subcontracting delivery

Fields (26)

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
BaseUnit BaseUnit 3
CompanyCode CompanyCode 1
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
Customer Customer 1
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
Material Material 3
MaterialGroup MaterialGroup 3
OrderType OrderType 1
Plant Plant 3
ProdAvailabilityCheckGroup ProdAvailabilityCheckGroup 1
PurchasingDocument PurchasingDocument 1
RequestedDeliveryDate RequestedDeliveryDate 2
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit 1
RequirementSegment RequirementSegment 1
ReservationItem ReservationItem 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
SegmentationStrategy SegmentationStrategy 1
SegmentationStrategyScope SegmentationStrategyScope 1
StorageLocation StorageLocation 3

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.

-- Basic View for Sub Contracting Purchase Order Components
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCPURORDCOMPBSC (
    PRODUCTAVAILABILITYDATE,
    REQUESTEDDATE,
    REQUIREMENTDOCUMENTITEM,
    REQUIREMENTDOCUMENTNUMBER,
    REQUIREMENTTYPE,
    BASEUNIT,
    COMPANYCODE,
    CONFIRMEDRQMTQTYINBASEUNIT,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CUSTOMER,
    DELIVEREDQUANTITYINBASEUNIT,
    MATERIAL,
    MATERIALGROUP,
    ORDERTYPE,
    PLANT,
    PRODAVAILABILITYCHECKGROUP,
    PURCHASINGDOCUMENT,
    REQUESTEDDELIVERYDATE,
    REQUESTEDRQMTQTYINBASEUNIT,
    REQUIREMENTSEGMENT,
    RESERVATIONITEM,
    SALESORDER,
    SALESORDERITEM,
    SEGMENTATIONSTRATEGY,
    SEGMENTATIONSTRATEGYSCOPE,
    STORAGELOCATION,
    PRIMARY KEY (PRODUCTAVAILABILITYDATE, REQUESTEDDATE, REQUIREMENTDOCUMENTITEM, REQUIREMENTDOCUMENTNUMBER, REQUIREMENTTYPE)
);

Learn More