I_StoreProdRFIDCntProdInstance

DDL: I_STOREPRODRFIDCNTPRODINSTANCE SQL: IRTSTCPRCNTPRDIN Type: view BASIC

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.

1 data source(s) 8 fields

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
KEY Product product
KEY GlobalTradeItemNumber globaltradeitemnumber
KEY SerialNumber serialnumber
ElectronicProductCodeURI electronicproductcodeuri
LastChangeDateTime lastchangedatetime
_StoreProductRFIDCount _StoreProductRFIDCount
_StoreProductRFIDCountProduct _StoreProductRFIDCountProduct 
@AbapCatalog.sqlViewName: 'IRTSTCPRCNTPRDIN'
@EndUserText.label: 'Store Product RFID Count Product Instce'

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@ObjectModel: {
    representativeKey: 'SerialNumber',
    usageType.serviceQuality: #B,
    usageType.sizeCategory: #L,
    usageType.dataClass: #TRANSACTIONAL
}
define view I_StoreProdRFIDCntProdInstance
  as select from rtst_cpr_cnt_ins

  association [1..1] to I_StoreProductRFIDCount        as _StoreProductRFIDCount        on  $projection.StoreProductRFIDCountUUID = _StoreProductRFIDCount.StoreProductRFIDCountUUID
  association [1..1] to I_StoreProductRFIDCountProduct as _StoreProductRFIDCountProduct on  $projection.StoreProductRFIDCountUUID = _StoreProductRFIDCountProduct.StoreProductRFIDCountUUID
                                                                                        and $projection.Product                   = _StoreProductRFIDCountProduct.Product

{
      @ObjectModel.foreignKey.association: '_StoreProductRFIDCount'
  key storeproductrfidcountuuid                                                         as StoreProductRFIDCountUUID,
  key product                                                                           as Product,
  key globaltradeitemnumber                                                             as GlobalTradeItemNumber,
  key serialnumber                                                                      as SerialNumber,

      electronicproductcodeuri                                                          as ElectronicProductCodeURI,
      lastchangedatetime                                                                as LastChangeDateTime,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _StoreProductRFIDCount,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _StoreProductRFIDCountProduct
}

Learn More