I_MATERIALSTOCK

CDS View
16 Fields 18 CDS Views

Material Stock Calculation

I_MATERIALSTOCK is a CDS View in S/4HANA. Material Stock Calculation. It contains 16 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
arun_i_batch_lines view from Batch Stock selection at storage level
ARUN_I_STOCK_LINES view from Physical Stock selection aggregation
arun_i_stora_line view from Storage location stock aggregation
Arun_Stock_Lines view from Aggregate stock for Supply Assignment
Arun_Stock_Menge view from Fetch total physical stock
ARUN_STOCK_TYPE_MENGE view from Select stock based on stock identifier
I_ExsTxMaterialStockAggrgn view from COMPOSITE Aggregate Material stock for Excise Tax
I_JITStkAnlysAtStorLoc view from COMPOSITE Stock Analysis for Material at Storage Location Level
P_AvailSubcontrgStock view from CONSUMPTION Available Stock at Subcontractor
P_BR_RptgInvtryBusinessPlace view from CONSUMPTION Inventory - Business Place
P_Materialaggr view_entity from CONSUMPTION Material Stock Calculation
P_MPE_MaterialPlantSalesStkQty view_entity from CONSUMPTION Sales Ord Stk Qty for Material Plant lvl
P_MPE_MaterialPlantStkQty view_entity from CONSUMPTION Stock Qty for Material in Plant level
P_MPE_MaterialPlantWBSStkQty view_entity from CONSUMPTION WBS Element Stock Qty for Material Plant
P_MPE_MaterialSalesStockQty view_entity from CONSUMPTION Sales Order Stock Qty for Material
P_MPE_MaterialStorageLocStkQty view_entity from CONSUMPTION Stock qty for Material in Stor Loc level
P_MPE_MaterialWBSElementStkQty view_entity from CONSUMPTION WBS Element Stock Qty for Material
P_UnrestrictedStk view from CONSUMPTION Unrestricted Stock

Fields (16)

KeyField CDS FieldsUsed in Views
Batch Batch 5
CompanyCode CompanyCode 3
CostEstimate CostEstimate 1
Customer Customer 1
InventorySpecialStockType InventorySpecialStockType 4
InventoryStockType InventoryStockType 2
Material Material 7
MaterialBaseUnit MaterialBaseUnit 7
MatlWrhsStkQtyInMatlBaseUnit StockQty 1
Plant Plant 7
SDDocument SDDocument 1
SDDocumentItem SDDocumentItem 1
SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner 1
StorageLocation StorageLocation 7
Supplier Supplier 5
WBSElementInternalID WBSElementInternalID 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.

-- Material Stock Calculation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALSTOCK (
    BATCH,
    COMPANYCODE,
    COSTESTIMATE,
    CUSTOMER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSTOCKTYPE,
    MATERIAL,
    MATERIALBASEUNIT,
    MATLWRHSSTKQTYINMATLBASEUNIT,
    PLANT,
    SDDOCUMENT,
    SDDOCUMENTITEM,
    SPECIALSTOCKIDFGSTOCKOWNER,
    STORAGELOCATION,
    SUPPLIER,
    WBSELEMENTINTERNALID
);

Learn More