I_StorePickingRequestTP

DDL: I_STOREPICKINGREQUESTTP SQL: ISTRPICKREQTP Type: view_entity TRANSACTIONAL
18 Fields 1 Data Sources 5 Associations

Store Picking Request

I_StorePickingRequestTP is a Transactional CDS View that provides data about "Store Picking Request" in SAP S/4HANA. It reads from 1 data source (I_StorePickingRequest) and exposes 18 fields with key fields Store, StorePickingRequest. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_StorePickingRequest Request from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_StorePickingRequestStatus _StatusDescription $projection.StorePickingRequestStatus = _StatusDescription.StorePickingRequestStatus and _StatusDescription.Language = $session.system_language
[0..1] I_RetailStoreUserAssignment _RetailStoreUserAssignment $projection.Store = _RetailStoreUserAssignment.Store and _RetailStoreUserAssignment.AssignedUser = $session.user
[1..1] I_StorePickingRequestItemCount _ItemCount $projection.StorePickingRequest = _ItemCount.StorePickingRequest
[0..1] E_StorePickingRequest _RequestExtension Request.Store = _RequestExtension.Store and Request.StorePickingRequest = _RequestExtension.StorePickingRequest
[0..*] I_StorePickingRequestItemTP _Items

Annotations (7)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Store Picking Request view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Store Store Plant
KEY StorePickingRequest StorePickingRequest Store Pick Req ID
StoreReferenceOrder StoreReferenceOrder Ref Order No.
StoreReferenceDocumentType StoreReferenceDocumentType Ref. Doc. Type
StorePlannedPickingDateTime StorePlannedPickingDateTime Store Picking Request Time Stamp
StorePickingRequestStatus StorePickingRequestStatus Pick. Status
HandoverShelfSpaceID HandoverShelfSpaceID Shelf Space ID
UserAssignedToPickingRequest UserAssignedToPickingRequest User Name
GrossWeight GrossWeight Total Weight
WeightUnit WeightUnit Weight unit
GrossVolume GrossVolume Total Volume
VolumeUnit VolumeUnit Volume Unit
RetailStoreCustomerReference RetailStoreCustomerReference
RetailStoreExternalReference RetailStoreExternalReference
NumberOfProducts _ItemCount NumberOfProducts
StorePickingRequestStatusText _StatusDescription StorePickingRequestStatusText
AssignedUser _RetailStoreUserAssignment AssignedUser
_Items _Items

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_StorePickingRequestTP.
-- 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: ISTRPICKREQTP

CREATE VIEW I_StorePickingRequestTP AS
SELECT
  Store,
  StorePickingRequest,
  StoreReferenceOrder,
  StoreReferenceDocumentType,
  StorePlannedPickingDateTime,
  StorePickingRequestStatus,
  HandoverShelfSpaceID,
  UserAssignedToPickingRequest,
  GrossWeight,
  WeightUnit,
  GrossVolume,
  VolumeUnit,
  RetailStoreCustomerReference,
  RetailStoreExternalReference,
  _ItemCount.NumberOfProducts AS NumberOfProducts,
  _StatusDescription.StorePickingRequestStatusText AS StorePickingRequestStatusText,
  _RetailStoreUserAssignment.AssignedUser AS AssignedUser
FROM I_StorePickingRequest AS Request
LEFT OUTER JOIN I_StorePickingRequestStatus AS _StatusDescription ON StorePickingRequestStatus = _StatusDescription.StorePickingRequestStatus AND _StatusDescription.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_RetailStoreUserAssignment AS _RetailStoreUserAssignment ON Store = _RetailStoreUserAssignment.Store AND _RetailStoreUserAssignment.AssignedUser = $session.user  -- association [0..1]
LEFT OUTER JOIN I_StorePickingRequestItemCount AS _ItemCount ON StorePickingRequest = _ItemCount.StorePickingRequest  -- association [1..1]
LEFT OUTER JOIN E_StorePickingRequest AS _RequestExtension ON Request.Store = _RequestExtension.Store AND Request.StorePickingRequest = _RequestExtension.StorePickingRequest  -- association [0..1]
LEFT OUTER JOIN I_StorePickingRequestItemTP AS _Items ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More