C_CSPRStorageLocation

DDL: C_CSPRSTORAGELOCATION SQL: CCSPRSTRGELOCTN Type: view CONSUMPTION

Count Products with RFID: Storage Locatn

C_CSPRStorageLocation is a Consumption CDS View that provides data about "Count Products with RFID: Storage Locatn" in SAP S/4HANA. It reads from 1 data source (I_StorageLocation) and exposes 8 fields with key fields Store, StorageLocation. It has 3 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_StorageLocation I_StorageLocation from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_RetailStoreApplicationStore _RetailStoreApplicationStore $projection.Store = _RetailStoreApplicationStore.Store and _RetailStoreApplicationStore.RetailStoreApplicationCategory = '2'
[0..1] C_CSPRCount _ActiveRFIDCount _ActiveRFIDCount.Store = $projection.Store and _ActiveRFIDCount.StorageLocation = $projection.StorageLocation and ( _ActiveRFIDCount.StoreProductRFIDCntProcgStatus = '07' or( ( _ActiveRFIDCount.StoreProductRFIDCntProcgStatus = '00' or _ActiveRFIDCount.StoreProductRFIDCntProcgStatus = '01' ) and _ActiveRFIDCount.StoreProdRFIDCntExprtnDteTme >= $projection.CurrentDateTime ) )
[0..1] C_CSPRCount _LastRFIDCount _LastRFIDCount.Store = $projection.Store and _LastRFIDCount.StorageLocation = $projection.StorageLocation and _LastRFIDCount.SubmissionDateTime = $projection.LastRFIDCountSubmissionDteTme and _LastRFIDCount.StoreProductRFIDCntProcgStatus = '02'

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCSPRSTRGELOCTN view
EndUserText.label Count Products with RFID: Storage Locatn view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey StorageLocation view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Store I_StorageLocation Plant
KEY StorageLocation I_StorageLocation StorageLocation
StorageLocationName I_StorageLocation StorageLocationName
LastRFIDCountSubmissionDteTme I_StorageLocationLastRFIDCount LastRFIDCountSubmissionDteTme
CurrentDateTime
_ActiveRFIDCount _ActiveRFIDCount
_LastRFIDCount _LastRFIDCount
_RetailStoreApplicationStore _RetailStoreApplicationStore 
@AbapCatalog.sqlViewName: 'CCSPRSTRGELOCTN'
@EndUserText.label: 'Count Products with RFID: Storage Locatn'

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

@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    representativeKey: 'StorageLocation',
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #M,
    usageType.dataClass: #MIXED
}
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view C_CSPRStorageLocation
  as select from I_StorageLocation
    join         I_StorageLocationLastRFIDCount on  I_StorageLocationLastRFIDCount.Store           = I_StorageLocation.Plant
                                                and I_StorageLocationLastRFIDCount.StorageLocation = I_StorageLocation.StorageLocation

  association [0..*] to I_RetailStoreApplicationStore as _RetailStoreApplicationStore on  $projection.Store                                           = _RetailStoreApplicationStore.Store
                                                                                      and _RetailStoreApplicationStore.RetailStoreApplicationCategory = '2'

  association [0..1] to C_CSPRCount                   as _ActiveRFIDCount             on  _ActiveRFIDCount.Store                                = $projection.Store
                                                                                      and _ActiveRFIDCount.StorageLocation                      = $projection.StorageLocation
                                                                                      and (
                                                                                         _ActiveRFIDCount.StoreProductRFIDCntProcgStatus        = '07' // submitting

                                                                                         or(
                                                                                           (
                                                                                             _ActiveRFIDCount.StoreProductRFIDCntProcgStatus    = '00' // new

                                                                                             or _ActiveRFIDCount.StoreProductRFIDCntProcgStatus = '01' // in process

                                                                                           )
                                                                                           and _ActiveRFIDCount.StoreProdRFIDCntExprtnDteTme    >= $projection.CurrentDateTime // outdated

                                                                                         )
                                                                                       )

  association [0..1] to C_CSPRCount                   as _LastRFIDCount               on  _LastRFIDCount.Store                          = $projection.Store
                                                                                      and _LastRFIDCount.StorageLocation                = $projection.StorageLocation
                                                                                      and _LastRFIDCount.SubmissionDateTime             = $projection.LastRFIDCountSubmissionDteTme
                                                                                      and _LastRFIDCount.StoreProductRFIDCntProcgStatus = '02'
{
  key I_StorageLocation.Plant                as Store,
  key I_StorageLocation.StorageLocation,

      I_StorageLocation.StorageLocationName,

      I_StorageLocationLastRFIDCount.LastRFIDCountSubmissionDteTme,

      @Consumption.hidden: true
      tstmp_current_utctimestamp()           as CurrentDateTime,

      _ActiveRFIDCount,
      _LastRFIDCount,
      _RetailStoreApplicationStore
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STORAGELOCATION",
"I_STORAGELOCATIONLASTRFIDCOUNT"
],
"ASSOCIATED":
[
"C_CSPRCOUNT",
"I_RETAILSTOREAPPLICATIONSTORE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More