I_SUPDMNDALLDOCNONBATSTKBSC

CDS View
26 Fields 4 CDS Views

Basic View for Non Batch Stock

I_SUPDMNDALLDOCNONBATSTKBSC is a CDS View in S/4HANA. Basic View for Non Batch Stock. It contains 26 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SupDmndAllDocNonBatchStock view from COMPOSITE View for Non Batch Stock
I_SupDmndAllDocNonBatStkAssgC view left_outer COMPOSITE Cube View for Non Batch Stock Assignment Details
I_SupDmndAllDocNonBatStkC view from COMPOSITE Cube View for Non Batch Stock Details
I_SupDmndAllDocSupply view union_all COMPOSITE View for Supply of All Documents

Fields (26)

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
Customer Customer 1
DeliveredQuantity DeliveredQuantity 1
DocumentCurrency DocumentCurrency 2
InventorySpecialStockType InventorySpecialStockType 1
IsInternalBatchManaged IsInternalBatchManaged 1
MaterialGroup MaterialGroup 3
NetPriceAmount NetPriceAmount 2
RequestedDeliveryDate RequestedDeliveryDate 2
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
StockSegment StockSegment 1
SupAssgmtSource SupAssgmtSource 3
Supplier Supplier 1
SupplyDeliveryDate SupplyDeliveryDate 1
TotalQuantity TotalQuantity 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.

-- Basic View for Non Batch Stock
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCNONBATSTKBSC (
    ASSIGNEDSUPPLYTYPE,
    BATCH,
    MATERIAL,
    PLANT,
    PRODUCTAVAILABILITYDATE,
    STORAGELOCATION,
    SUPPLYITEM,
    SUPPLYNUMBER,
    SUPPLYSCHEDULELINE,
    BASEUNIT,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CUSTOMER,
    DELIVEREDQUANTITY,
    DOCUMENTCURRENCY,
    INVENTORYSPECIALSTOCKTYPE,
    ISINTERNALBATCHMANAGED,
    MATERIALGROUP,
    NETPRICEAMOUNT,
    REQUESTEDDELIVERYDATE,
    SALESORDER,
    SALESORDERITEM,
    STOCKSEGMENT,
    SUPASSGMTSOURCE,
    SUPPLIER,
    SUPPLYDELIVERYDATE,
    TOTALQUANTITY,
    PRIMARY KEY (ASSIGNEDSUPPLYTYPE, BATCH, MATERIAL, PLANT, PRODUCTAVAILABILITYDATE, STORAGELOCATION, SUPPLYITEM, SUPPLYNUMBER, SUPPLYSCHEDULELINE)
);

Learn More