I_StorePickingReqSchema

DDL: I_STOREPICKINGREQSCHEMA SQL: ISTRPKREQSCHEMA Type: view BASIC Package: RFM_STORE_PICK_REQ
4 Fields 1 Data Sources

Store Picking Req Customizing Schema

I_StorePickingReqSchema is a Basic CDS View that provides data about "Store Picking Req Customizing Schema" in SAP S/4HANA. It reads from 1 data source (rfm_c_st_scheme) and exposes 4 fields with key fields RetailStoreSchemaType, RetailStoreSchemaID, StorePickUpOrderType. Part of development package RFM_STORE_PICK_REQ.

Data Sources (1)

SourceAliasJoin Type
rfm_c_st_scheme rfm_c_st_scheme from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISTRPKREQSCHEMA view
EndUserText.label Store Picking Req Customizing Schema view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY RetailStoreSchemaType setting_id Setting ID
KEY RetailStoreSchemaID scheme_id Scheme
KEY StorePickUpOrderType ref_doc_type Ref. procedure
IsDefaultValue is_standard Is Standard

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_StorePickingReqSchema.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISTRPKREQSCHEMA

CREATE VIEW I_StorePickingReqSchema AS
SELECT
  setting_id AS RetailStoreSchemaType,
  scheme_id AS RetailStoreSchemaID,
  ref_doc_type AS StorePickUpOrderType,
  is_standard AS IsDefaultValue
FROM rfm_c_st_scheme
;

Learn More