I_StoreProdRFIDCntProdInstance

DDL: I_STOREPRODRFIDCNTPRODINSTANCE SQL: IRTSTCPRCNTPRDIN Type: view BASIC Package: ODATA_RETAIL_ST_CNT_PROD_RFID
8 Fields 1 Data Sources 2 Associations

Store Product RFID Count Product Instce

I_StoreProdRFIDCntProdInstance is a Basic CDS View that provides data about "Store Product RFID Count Product Instce" in SAP S/4HANA. It reads from 1 data source (rtst_cpr_cnt_ins) and exposes 8 fields with key fields StoreProductRFIDCountUUID, Product, GlobalTradeItemNumber, SerialNumber. It has 2 associations to related views. Part of development package ODATA_RETAIL_ST_CNT_PROD_RFID.

Data Sources (1)

SourceAliasJoin Type
rtst_cpr_cnt_ins rtst_cpr_cnt_ins from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_StoreProductRFIDCount _StoreProductRFIDCount $projection.StoreProductRFIDCountUUID = _StoreProductRFIDCount.StoreProductRFIDCountUUID
[1..1] I_StoreProductRFIDCountProduct _StoreProductRFIDCountProduct $projection.StoreProductRFIDCountUUID = _StoreProductRFIDCountProduct.StoreProductRFIDCountUUID and $projection.Product = _StoreProductRFIDCountProduct.Product

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IRTSTCPRCNTPRDIN view
EndUserText.label Store Product RFID Count Product Instce view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.representativeKey SerialNumber view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY StoreProductRFIDCountUUID storeproductrfidcountuuid Count ID
KEY Product product Product Sold
KEY GlobalTradeItemNumber globaltradeitemnumber GTIN
KEY SerialNumber serialnumber Serial Number
ElectronicProductCodeURI electronicproductcodeuri Elec Product Code
LastChangeDateTime lastchangedatetime Timestamp
_StoreProductRFIDCount _StoreProductRFIDCount
_StoreProductRFIDCountProduct _StoreProductRFIDCountProduct

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_StoreProdRFIDCntProdInstance.
-- 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: IRTSTCPRCNTPRDIN

CREATE VIEW I_StoreProdRFIDCntProdInstance AS
SELECT
  StoreProductRFIDCountUUID,
  Product,
  GlobalTradeItemNumber,
  SerialNumber,
  ElectronicProductCodeURI,
  LastChangeDateTime
FROM rtst_cpr_cnt_ins
LEFT OUTER JOIN I_StoreProductRFIDCount AS _StoreProductRFIDCount ON StoreProductRFIDCountUUID = _StoreProductRFIDCount.StoreProductRFIDCountUUID  -- association [1..1]
LEFT OUTER JOIN I_StoreProductRFIDCountProduct AS _StoreProductRFIDCountProduct ON StoreProductRFIDCountUUID = _StoreProductRFIDCountProduct.StoreProductRFIDCountUUID AND Product = _StoreProductRFIDCountProduct.Product  -- association [1..1]
;

Learn More