I_EQUIPMENTSTOCKSEGMENT

CDS View
24 Fields 6 CDS Views

Equipment Stock Segment

I_EQUIPMENTSTOCKSEGMENT is a CDS View in S/4HANA. Equipment Stock Segment. It contains 24 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_DFS_EquipPlntStorLocVH view_entity from CONSUMPTION EquipmentSearch by Plant StorageLocation
I_AuthzdActlEquipmentDetails view inner COMPOSITE View of Equipments relevant for AAC
I_DFS_MaintEquipUtilizerDets view from COMPOSITE Interface view of utilizer details
I_MaterialSerialNumber view from COMPOSITE Serial No for Material and Stock Segment
I_SerialNumberStockSegment view from BASIC Serial Number Stock Segment
P_UnplndRegnProdnRsceTool view_entity inner COMPOSITE

Fields (24)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 3
_Customer _Customer 1
_CustomerCompanyByPlant _CustomerCompanyByPlant 1
_Equipment _Equipment 1
_InventorySpecialStockType _InventorySpecialStockType 1
_InventoryStockType _InventoryStockType 1
_Plant _Plant 1
_SalesOrder _SalesOrder 1
_SalesOrderItem _SalesOrderItem 1
_StorageLocation _StorageLocation 1
_Supplier _Supplier 1
_SupplierCompanyByPlant _SupplierCompanyByPlant 1
_WBSElementByInternalKey _WBSElementByInternalKey 1
Batch Batch 1
Customer Customer 1
InventorySpecialStockType InventorySpecialStockType 1
InventoryStockType InventoryStockType 1
Plant DfsMaintEquipmentPlant,Plant 3
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
StockOwner StockOwner 1
StorageLocation DfsMaintEquipStorageLocation,StorageLocation 2
Supplier Supplier 1
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.

-- Equipment Stock Segment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EQUIPMENTSTOCKSEGMENT (
    EQUIPMENT,
    _CUSTOMER,
    _CUSTOMERCOMPANYBYPLANT,
    _EQUIPMENT,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYSTOCKTYPE,
    _PLANT,
    _SALESORDER,
    _SALESORDERITEM,
    _STORAGELOCATION,
    _SUPPLIER,
    _SUPPLIERCOMPANYBYPLANT,
    _WBSELEMENTBYINTERNALKEY,
    BATCH,
    CUSTOMER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSTOCKTYPE,
    PLANT,
    SALESORDER,
    SALESORDERITEM,
    STOCKOWNER,
    STORAGELOCATION,
    SUPPLIER,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (EQUIPMENT)
);

Learn More