I_StoreProductRFIDCountProduct

DDL: I_STOREPRODUCTRFIDCOUNTPRODUCT SQL: IRTSTCPRCNTPRD Type: view BASIC

Store Product RFID Count Product

I_StoreProductRFIDCountProduct is a Basic CDS View that provides data about "Store Product RFID Count Product" in SAP S/4HANA. It reads from 1 data source (rtst_cpr_cnt_prd) and exposes 7 fields with key fields StoreProductRFIDCountUUID, Product. It has 4 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
rtst_cpr_cnt_prd rtst_cpr_cnt_prd from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_StoreProductRFIDCount _StoreProductRFIDCount $projection.StoreProductRFIDCountUUID = _StoreProductRFIDCount.StoreProductRFIDCountUUID
[0..*] I_StoreProdRFIDCntProdInstance _StoreProdRFIDCntProdInstance $projection.StoreProductRFIDCountUUID = _StoreProdRFIDCntProdInstance.StoreProductRFIDCountUUID and $projection.Product = _StoreProdRFIDCntProdInstance.Product
[1..1] I_Product _Product $projection.Product = _Product.Product
[1..*] I_ProductUnitOfMeasureEAN _ProductUnitOfMeasureEAN $projection.Product = _ProductUnitOfMeasureEAN.Product

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IRTSTCPRCNTPRD view
EndUserText.label Store Product RFID Count Product 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 Product view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StoreProductRFIDCountUUID storeproductrfidcountuuid
KEY Product product
NumberOfExpectedItems numberofexpecteditems
_Product _Product
_ProductUnitOfMeasureEAN _ProductUnitOfMeasureEAN
_StoreProductRFIDCount _StoreProductRFIDCount
_StoreProdRFIDCntProdInstance _StoreProdRFIDCntProdInstance 
@AbapCatalog.sqlViewName: 'IRTSTCPRCNTPRD'
@EndUserText.label: 'Store Product RFID Count Product'

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

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

  association [1..1] to I_StoreProductRFIDCount        as _StoreProductRFIDCount        on  $projection.StoreProductRFIDCountUUID = _StoreProductRFIDCount.StoreProductRFIDCountUUID
  association [0..*] to I_StoreProdRFIDCntProdInstance as _StoreProdRFIDCntProdInstance on  $projection.StoreProductRFIDCountUUID = _StoreProdRFIDCntProdInstance.StoreProductRFIDCountUUID
                                                                                        and $projection.Product                   = _StoreProdRFIDCntProdInstance.Product
  association [1..1] to I_Product                      as _Product                      on  $projection.Product = _Product.Product
  association [1..*] to I_ProductUnitOfMeasureEAN      as _ProductUnitOfMeasureEAN      on  $projection.Product = _ProductUnitOfMeasureEAN.Product
{
      @ObjectModel.foreignKey.association: '_StoreProductRFIDCount'
  key storeproductrfidcountuuid                        as StoreProductRFIDCountUUID,
  key product                                          as Product,

      numberofexpecteditems                            as NumberOfExpectedItems,

      _Product,
      _ProductUnitOfMeasureEAN,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _StoreProductRFIDCount,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _StoreProdRFIDCntProdInstance
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RTST_CPR_CNT_PRD"
],
"ASSOCIATED":
[
"I_PRODUCT",
"I_PRODUCTUNITOFMEASUREEAN",
"I_STOREPRODRFIDCNTPRODINSTANCE",
"I_STOREPRODUCTRFIDCOUNT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More