_REPRESENTATIVEORDERITEM

_REPRESENTATIVEORDERITEM is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
ActualDeliveryDate ActualDeliveryDate,DeliveryDate 2
BaseUnit BaseUnit,UnitOfMeasure 5
InventorySpecialStockType InventorySpecialStockType 2
InventorySpecialStockValnType InventorySpecialStockValnType 2
Material LeadingMfgOrderMaterial,Material 8
MRPArea MRPArea 3
MRPPlant MRPPlant 8
OrderIsRefurbishmentOrder OrderIsRefurbishmentOrder 1
OrderItem OrderItem 2
ProductionVersion ProductionVersion 7
SalesOrder SalesOrder 12
SalesOrderItem SalesOrderItem 9
StockSegment StockSegment 2
StorageLocation StorageLocation 7
ValuationType ValuationType 5
WBSElementInternalID WBSElementInternalID 5

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 _REPRESENTATIVEORDERITEM (
    ACTUALDELIVERYDATE,
    BASEUNIT,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    MATERIAL,
    MRPAREA,
    MRPPLANT,
    ORDERISREFURBISHMENTORDER,
    ORDERITEM,
    PRODUCTIONVERSION,
    SALESORDER,
    SALESORDERITEM,
    STOCKSEGMENT,
    STORAGELOCATION,
    VALUATIONTYPE,
    WBSELEMENTINTERNALID
);