I_StorePkngReqSubstnItem

DDL: I_STOREPKNGREQSUBSTNITEM SQL: ISTRPKNGSBSTITEM Type: view COMPOSITE Package: RFM_STORE_PICK_PRODUCTS
14 Fields 2 Data Sources

Picking Request Subst item

I_StorePkngReqSubstnItem is a Composite CDS View that provides data about "Picking Request Subst item" in SAP S/4HANA. It reads from 2 data sources (I_ProductPlant, I_StorePkngReqSubstnItmAll) and exposes 14 fields with key fields Product, RetailStoreRequestedProduct, AlternativeUnit, ConsecutiveNumber, Store. Part of development package RFM_STORE_PICK_PRODUCTS.

Data Sources (2)

SourceAliasJoin Type
I_ProductPlant ProductPlant from
I_StorePkngReqSubstnItmAll StorePkngReqSubstnItemAll inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISTRPKNGSBSTITEM view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Picking Request Subst item view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductPlant Product Product Sold
KEY RetailStoreRequestedProduct I_StorePkngReqSubstnItmAll RetailStoreRequestedProduct Product Sold
KEY AlternativeUnit I_StorePkngReqSubstnItmAll AlternativeUnit Base UoM
KEY ConsecutiveNumber I_StorePkngReqSubstnItmAll ConsecutiveNumber
KEY Store I_ProductPlant Plant Valuation Area
KEY StorePickingRequest I_StorePkngReqSubstnItmAll StorePickingRequest Store Pick Req ID
KEY StorePickingRequestItem I_StorePkngReqSubstnItmAll StorePickingRequestItem Store Picking Request Item ID
ProductStandardID I_StorePkngReqSubstnItmAll ProductStandardID GTIN
RetailStoreReqdProductStdID I_StorePkngReqSubstnItmAll RetailStoreReqdProductStdID GTIN
SerialNumberProfile I_ProductPlant SerialNumberProfile SerialNoProfile
InternationalArticleNumberCat I_StorePkngReqSubstnItmAll InternationalArticleNumberCat GTIN Category
IsMainGlobalTradeItemNumber I_StorePkngReqSubstnItmAll IsMainGlobalTradeItemNumber Main EAN
UnitOfMeasure I_StorePkngReqSubstnItmAll UnitOfMeasure Unit Protected Qty
_InternationalArticleNumber I_StorePkngReqSubstnItmAll _InternationalArticleNumber

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_StorePkngReqSubstnItem.
-- 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: ISTRPKNGSBSTITEM

CREATE VIEW I_StorePkngReqSubstnItem AS
SELECT
  ProductPlant.Product AS Product,
  StorePkngReqSubstnItemAll.RetailStoreRequestedProduct AS RetailStoreRequestedProduct,
  StorePkngReqSubstnItemAll.AlternativeUnit AS AlternativeUnit,
  StorePkngReqSubstnItemAll.ConsecutiveNumber AS ConsecutiveNumber,
  ProductPlant.Plant AS Store,
  StorePkngReqSubstnItemAll.StorePickingRequest AS StorePickingRequest,
  StorePkngReqSubstnItemAll.StorePickingRequestItem AS StorePickingRequestItem,
  StorePkngReqSubstnItemAll.ProductStandardID AS ProductStandardID,
  StorePkngReqSubstnItemAll.RetailStoreReqdProductStdID AS RetailStoreReqdProductStdID,
  ProductPlant.SerialNumberProfile AS SerialNumberProfile,
  StorePkngReqSubstnItemAll.InternationalArticleNumberCat AS InternationalArticleNumberCat,
  StorePkngReqSubstnItemAll.IsMainGlobalTradeItemNumber AS IsMainGlobalTradeItemNumber,
  StorePkngReqSubstnItemAll.UnitOfMeasure AS UnitOfMeasure,
  StorePkngReqSubstnItemAll._InternationalArticleNumber AS _InternationalArticleNumber
FROM I_ProductPlant AS ProductPlant
INNER JOIN I_StorePkngReqSubstnItmAll AS StorePkngReqSubstnItemAll ON /* join condition not captured in parsed metadata */
;

Learn More