C_MSPRStorageLocation

DDL: C_MSPRSTORAGELOCATION SQL: CMSPRSTRGELOCTN Type: view CONSUMPTION Package: RFM_STORE_MOVE_PRODUCT_RFID

Move Products w/ RFID: Storage Location

C_MSPRStorageLocation is a Consumption CDS View that provides data about "Move Products w/ RFID: Storage Location" in SAP S/4HANA. It reads from 1 data source (I_StorageLocation) and exposes 6 fields with key fields Store, StorageLocation. It has 1 association to related views. It is exposed through 1 OData service (UI_RFM_STORE_MOVEPRODRFID). Part of development package RFM_STORE_MOVE_PRODUCT_RFID.

1 data source(s) Exposed by 1 service(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_StorageLocation I_StorageLocation from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_RetailStoreApplicationStore _RetailStoreApplicationStore $projection.Store = _RetailStoreApplicationStore.Store and _RetailStoreApplicationStore.RetailStoreApplicationCategory = '2'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMSPRSTRGELOCTN view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey StorageLocation view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_STORE_MOVEPRODRFID UI_RFM_STORE_MOVEPRODRFID V2 C1 NOT_RELEASED

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Store I_StorageLocation Plant
KEY StorageLocation I_StorageLocation StorageLocation
StorageLocationName I_StorageLocation StorageLocationName
CurrentDateTime
_RetailStoreApplicationStore _RetailStoreApplicationStore
_Store _Store 
@AbapCatalog.sqlViewName: 'CMSPRSTRGELOCTN'

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

@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    representativeKey: 'StorageLocation',
    usageType.serviceQuality: #B,
    usageType.sizeCategory: #M,
    usageType.dataClass: #MASTER
}

define view C_MSPRStorageLocation
  as select from I_StorageLocation
  association [0..*] to I_RetailStoreApplicationStore as _RetailStoreApplicationStore on  $projection.Store                                           = _RetailStoreApplicationStore.Store
                                                                                      and _RetailStoreApplicationStore.RetailStoreApplicationCategory = '2'
  association to parent C_MSPRStore as _Store on $projection.Store = _Store.Store
{
  key I_StorageLocation.Plant                as Store,
  key I_StorageLocation.StorageLocation,

      I_StorageLocation.StorageLocationName,

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

      _RetailStoreApplicationStore,
      _Store
}

Learn More