RFM_ST_PICK_REQI

Transparent Table Application Table
19 Fields 2 CDS Views

Store Picking Request: Item Data

RFM_ST_PICK_REQI is an SAP database table in S/4HANA. Store Picking Request: Item Data. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_StorePickingRequestItem view from EXTENSION Extension view for RFM_ST_PICK_REQI
I_StorePickingRequestItem view from BASIC Store Picking Request Item

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY store w_werks Plant
KEY storepickingrequest rfm_st_pick_request Store Pick Req ID
KEY storepickingrequestitem rfm_st_pick_request_item Store Picking Request Item ID
product matnr Material
requestedquantity rfm_st_req_qty Req Item Qty
productpickedquantity rfm_st_pick_qty Picked Item Quantity
unitofmeasure meins Base Unit
storepickingrequestitemstatus rfm_st_pick_req_item_status Store Picking Request Item Status
referencestorepickuporder rfm_st_reforder Ref Order No.
referencestorepickuporderitem rfm_st_reforder_item Items No.
storeitemoverallstatus rfm_st_pick_req_item_ovrl_sts Item Overall Status
requestedstorepickingreqitem rfm_st_pick_req_reqstd_item Requested Item Num
storepkngreqitemissubstituted rfm_st_pick_req_subst Is Substituted
productremainingquantity rfm_st_remaining_qty Remaining item quantity
retailstoreprodispickingcmpltd rfm_st_pick_prd_pkcompd Picking completed flag for Store Picking Request Item
retailstoreprodisnonstock rfm_st_nonstock_product Retail Store Non Stock Product flag
storepkngreqitemishigherlvl rfm_st_higherlvl_item Higher Lvl Item Flag
retailstoreproductisempties rfm_st_empties_product

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 Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RFM_ST_PICK_REQI (
    MANDT,                           -- Client [mandt]
    STORE,                           -- Plant [w_werks]
    STOREPICKINGREQUEST,             -- Store Pick Req ID [rfm_st_pick_request]
    STOREPICKINGREQUESTITEM,         -- Store Picking Request Item ID [rfm_st_pick_request_item]
    PRODUCT,                         -- Material [matnr]
    REQUESTEDQUANTITY,               -- Req Item Qty [rfm_st_req_qty]
    PRODUCTPICKEDQUANTITY,           -- Picked Item Quantity [rfm_st_pick_qty]
    UNITOFMEASURE,                   -- Base Unit [meins]
    STOREPICKINGREQUESTITEMSTATUS,   -- Store Picking Request Item Status [rfm_st_pick_req_item_status]
    REFERENCESTOREPICKUPORDER,       -- Ref Order No. [rfm_st_reforder]
    REFERENCESTOREPICKUPORDERITEM,   -- Items No. [rfm_st_reforder_item]
    STOREITEMOVERALLSTATUS,          -- Item Overall Status [rfm_st_pick_req_item_ovrl_sts]
    REQUESTEDSTOREPICKINGREQITEM,    -- Requested Item Num [rfm_st_pick_req_reqstd_item]
    STOREPKNGREQITEMISSUBSTITUTED,   -- Is Substituted [rfm_st_pick_req_subst]
    PRODUCTREMAININGQUANTITY,        -- Remaining item quantity [rfm_st_remaining_qty]
    RETAILSTOREPRODISPICKINGCMPLTD,  -- Picking completed flag for Store Picking Request Item [rfm_st_pick_prd_pkcompd]
    RETAILSTOREPRODISNONSTOCK,       -- Retail Store Non Stock Product flag [rfm_st_nonstock_product]
    STOREPKNGREQITEMISHIGHERLVL,     -- Higher Lvl Item Flag [rfm_st_higherlvl_item]
    RETAILSTOREPRODUCTISEMPTIES,     -- rfm_st_empties_product
    PRIMARY KEY (MANDT, STORE, STOREPICKINGREQUEST, STOREPICKINGREQUESTITEM)
);

Learn More