RFM_ST_PICK_REQ

Transparent Table Application Table
17 Fields 2 CDS Views

Store Picking Request: Header Data

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_StorePickingRequest view from EXTENSION Extension view for RFM_ST_PICK_REQ
I_StorePickingRequest view from BASIC Store Picking Request

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY store w_werks Plant
KEY storepickingrequest rfm_st_pick_request Store Pick Req ID
referencestorepickuporder rfm_st_reforder Ref Order No.
storepickupordertype rfm_st_ref_doc_type Ref. Doc. Type
storeplannedpickingdatetime rfm_st_picking_datetime Store Picking Request Time Stamp
storepickingrequeststatus rfm_st_request_status Pick. Status
handovershelfspaceid rfm_st_shelf_space_id Shelf Space ID
userassignedtopickingrequest usnam User Name
grossweight rfm_st_gross_weight Gross Wt.
weightunit rfm_st_gross_weight_unit Gross Weight Unit
grossvolume rfm_st_gross_volume Gross Vol
volumeunit rfm_st_gross_volume_unit Gross Vol. UoM
createdbyuser ernam Created By
creationdatetime rfm_st_pkreq_creationdatetime Creation Date Time
lastchangedbyuser last_changed_by_user Last Changed By
lastchangedatetime rfm_st_pkreq_changedatetime Change Date Time

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: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RFM_ST_PICK_REQ (
    MANDT,                         -- Client [mandt]
    STORE,                         -- Plant [w_werks]
    STOREPICKINGREQUEST,           -- Store Pick Req ID [rfm_st_pick_request]
    REFERENCESTOREPICKUPORDER,     -- Ref Order No. [rfm_st_reforder]
    STOREPICKUPORDERTYPE,          -- Ref. Doc. Type [rfm_st_ref_doc_type]
    STOREPLANNEDPICKINGDATETIME,   -- Store Picking Request Time Stamp [rfm_st_picking_datetime]
    STOREPICKINGREQUESTSTATUS,     -- Pick. Status [rfm_st_request_status]
    HANDOVERSHELFSPACEID,          -- Shelf Space ID [rfm_st_shelf_space_id]
    USERASSIGNEDTOPICKINGREQUEST,  -- User Name [usnam]
    GROSSWEIGHT,                   -- Gross Wt. [rfm_st_gross_weight]
    WEIGHTUNIT,                    -- Gross Weight Unit [rfm_st_gross_weight_unit]
    GROSSVOLUME,                   -- Gross Vol [rfm_st_gross_volume]
    VOLUMEUNIT,                    -- Gross Vol. UoM [rfm_st_gross_volume_unit]
    CREATEDBYUSER,                 -- Created By [ernam]
    CREATIONDATETIME,              -- Creation Date Time [rfm_st_pkreq_creationdatetime]
    LASTCHANGEDBYUSER,             -- Last Changed By [last_changed_by_user]
    LASTCHANGEDATETIME,            -- Change Date Time [rfm_st_pkreq_changedatetime]
    PRIMARY KEY (MANDT, STORE, STOREPICKINGREQUEST)
);

Learn More