I_STOREPICKINGREQUESTITEM

CDS View

Store Picking Request Item

I_STOREPICKINGREQUESTITEM is a CDS View in S/4HANA. Store Picking Request Item. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_StorePickingRequestItemCount view from COMPOSITE Store Picking Request Item Count
I_StorePickingRequestItemTP view_entity from TRANSACTIONAL Store Picking Request Item
I_StorePickupOrderItem view from COMPOSITE Store Pickup Order Items
I_StorePkngReqSubstnItmAll view cross BASIC Picking Request Subst item

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Product RetailStoreRequestedProduct 1
KEY Store Store 1
KEY StorePickingRequest StorePickingRequest 1
KEY StorePickingRequestItem StorePickingRequestItem 1
UnitOfMeasure UnitOfMeasure 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.

-- Store Picking Request Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STOREPICKINGREQUESTITEM (
    PRODUCT,
    STORE,
    STOREPICKINGREQUEST,
    STOREPICKINGREQUESTITEM,
    UNITOFMEASURE,
    PRIMARY KEY (PRODUCT, STORE, STOREPICKINGREQUEST, STOREPICKINGREQUESTITEM)
);