I_SUPDMNDALLDOCPRODNORDBSC

CDS View
22 Fields 4 CDS Views

Basic View for Production Order

I_SUPDMNDALLDOCPRODNORDBSC is a CDS View in S/4HANA. Basic View for Production Order. It contains 22 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SupDmndAllDocProdnOrd view from COMPOSITE View for Production Order
I_SupDmndAllDocProdnOrdAssgC view left_outer COMPOSITE Cube View for Production Order Assignment Details
I_SupDmndAllDocProdnOrdC view from COMPOSITE Cube View for Production Order Details
I_SupDmndAllDocSupply view union_all COMPOSITE View for Supply of All Documents

Fields (22)

KeyField CDS FieldsUsed in Views
KEY AssignedSupplyType AssignedSupplyType 3
KEY Batch Batch 3
KEY Material Material 3
KEY Plant Plant 3
KEY ProductAvailabilityDate ProductAvailabilityDate 3
KEY StorageLocation StorageLocation 3
KEY SupplyItem SupplyItem 3
KEY SupplyNumber SupplyNumber 3
KEY SupplyScheduleLine SupplyScheduleLine 3
BaseUnit BaseUnit 3
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
GoodsReceiptDurationInDays GoodsReceiptDurationInDays 1
MaterialGroup MaterialGroup 3
MRPArea MRPArea 1
OrderType OrderType 1
RequestedDeliveryDate RequestedDeliveryDate 2
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
StockSegment StockSegment 1
SupAssgmtSource SupAssgmtSource 3
SupplyDeliveryDate SupplyDeliveryDate 1
TotalQuantity TotalQuantity 2

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 Production Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCPRODNORDBSC (
    ASSIGNEDSUPPLYTYPE,
    BATCH,
    MATERIAL,
    PLANT,
    PRODUCTAVAILABILITYDATE,
    STORAGELOCATION,
    SUPPLYITEM,
    SUPPLYNUMBER,
    SUPPLYSCHEDULELINE,
    BASEUNIT,
    CROSSPLANTCONFIGURABLEPRODUCT,
    GOODSRECEIPTDURATIONINDAYS,
    MATERIALGROUP,
    MRPAREA,
    ORDERTYPE,
    REQUESTEDDELIVERYDATE,
    SALESORDER,
    SALESORDERITEM,
    STOCKSEGMENT,
    SUPASSGMTSOURCE,
    SUPPLYDELIVERYDATE,
    TOTALQUANTITY,
    PRIMARY KEY (ASSIGNEDSUPPLYTYPE, BATCH, MATERIAL, PLANT, PRODUCTAVAILABILITYDATE, STORAGELOCATION, SUPPLYITEM, SUPPLYNUMBER, SUPPLYSCHEDULELINE)
);

Learn More