SERIALNUMBERSTOCKSEGMENT

SERIALNUMBERSTOCKSEGMENT is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
_Customer _Customer 1
_InventorySpecialStockType _InventorySpecialStockType 1
_InventoryStockType _InventoryStockType 1
_Plant _Plant 1
_SalesOrder _SalesOrder 1
_SalesOrderItem _SalesOrderItem 1
_StorageLocation _StorageLocation 1
_Supplier _Supplier 1
_WBSElementByInternalKey _WBSElementByInternalKey 1
Batch MaterialSerialNumberStockBatch 1
Customer Customer 1
InventorySpecialStockType InventorySpecialStockType 1
InventoryStockType InventoryStockType 1
Plant Plant 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
StockOwner StockOwner 1
StorageLocation StorageLocation 1
Supplier Supplier 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SERIALNUMBERSTOCKSEGMENT (
    _CUSTOMER,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYSTOCKTYPE,
    _PLANT,
    _SALESORDER,
    _SALESORDERITEM,
    _STORAGELOCATION,
    _SUPPLIER,
    _WBSELEMENTBYINTERNALKEY,
    BATCH,
    CUSTOMER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSTOCKTYPE,
    PLANT,
    SALESORDER,
    SALESORDERITEM,
    STOCKOWNER,
    STORAGELOCATION,
    SUPPLIER
);