I_StoreProductRFIDMovement

DDL: I_STOREPRODUCTRFIDMOVEMENT SQL: IMSPRMOVEMENT Type: view BASIC Package: RFM_STORE_MOVE_PRODUCT_RFID

Store Product RFID Movement

I_StoreProductRFIDMovement is a Basic CDS View that provides data about "Store Product RFID Movement" in SAP S/4HANA. It reads from 1 data source (rtst_mpr_mvmnt) and exposes 11 fields with key field StoreProductRFIDMovementUUID. Part of development package RFM_STORE_MOVE_PRODUCT_RFID.

Data Sources (1)

SourceAliasJoin Type
rtst_mpr_mvmnt rtst_mpr_mvmnt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMSPRMOVEMENT view
EndUserText.label Store Product RFID Movement view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY StoreProductRFIDMovementUUID storeproductrfidmovementuuid Movement ID
Store store Plant
SourceStorageLocation sourcestoragelocation Location
TargetStorageLocation targetstoragelocation Location
NumberOfSubmittedItems numberofsubmitteditems
NotPostedNrOfSubmittedItems notpostednrofsubmitteditems
StoreProdRFIDMovementProcgSts storeprodrfidmovementprocgsts Processing Status
MaterialDocument materialdocument Material Doc.
MaterialDocumentYear materialdocumentyear Material Document Year
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp

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_StoreProductRFIDMovement.
-- 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: IMSPRMOVEMENT

CREATE VIEW I_StoreProductRFIDMovement AS
SELECT
  StoreProductRFIDMovementUUID,
  Store,
  SourceStorageLocation,
  TargetStorageLocation,
  NumberOfSubmittedItems,
  NotPostedNrOfSubmittedItems,
  StoreProdRFIDMovementProcgSts,
  MaterialDocument,
  MaterialDocumentYear,
  CreatedByUser,
  CreationDateTime
FROM rtst_mpr_mvmnt
;