I_STOREPRODUCTRFIDCOUNT

CDS View

Store Product RFID Count

I_STOREPRODUCTRFIDCOUNT is a CDS View in S/4HANA. Store Product RFID Count. It contains 12 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 12 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_CSPRCount view from CONSUMPTION Count Products with RFID: Count
I_StoreProductRFIDCountApplLog view from BASIC Store Product RFID Count Application Log
I_StoreProductRFIDCountNumbers view from COMPOSITE Store Product RFID Count Numbers
I_StoreProductRFIDCountPrdcssr view from COMPOSITE Store Product RFID Count Predecessor
P_StoreProductRFIDCountCalc view from COMPOSITE

Fields (12)

KeyField CDS FieldsUsed in Views
KEY StoreProductRFIDCountUUID StoreProductRFIDCountUUID 3
CreationDateTime CreationDateTime 1
NotPostedNrOfSubmdMissingItems NotPostedNrOfSubmdMissingItems 2
NotPostedNrOfSubmdSurplusItems NotPostedNrOfSubmdSurplusItems 2
NumberOfExpectedItems NumberOfExpectedItems 2
SkippedNrOfSubmdMissingItems SkippedNrOfSubmdMissingItems 1
SkippedNrOfSubmdSurplusItems SkippedNrOfSubmdSurplusItems 1
StorageLocation StorageLocation 1
Store Store 2
StoreProdRFIDCntExprtnDteTme StoreProdRFIDCntExprtnDteTme 1
StoreProductRFIDCntProcgStatus StoreProductRFIDCntProcgStatus 1
SubmissionDateTime SubmissionDateTime 1 
@AbapCatalog.sqlViewName: 'IRTSTCPRCOUNT'
@EndUserText.label: 'Store Product RFID Count'

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

@VDM.viewType: #BASIC
@ObjectModel: {
    compositionRoot: true,
    representativeKey: 'StoreProductRFIDCountUUID',
    usageType.serviceQuality: #B,
    usageType.sizeCategory: #M,
    usageType.dataClass: #TRANSACTIONAL
}
define view I_StoreProductRFIDCount
  as select from rtst_cpr_count

  association [0..*] to I_StoreProductRFIDCountProduct as _StoreProductRFIDCountProduct  on  $projection.StoreProductRFIDCountUUID = _StoreProductRFIDCountProduct.StoreProductRFIDCountUUID
  association [0..*] to I_StoreProdRFIDCntProdInstance as _StoreProdRFIDCntProdInstance  on  $projection.StoreProductRFIDCountUUID = _StoreProdRFIDCntProdInstance.StoreProductRFIDCountUUID

  // Previous counts for the same store/storage location

  association [0..*] to I_StoreProductRFIDCount        as _PreviousStoreProductRFIDCount on  _PreviousStoreProductRFIDCount.Store            = $projection.Store
                                                                                         and _PreviousStoreProductRFIDCount.StorageLocation  = $projection.StorageLocation
                                                                                         and _PreviousStoreProductRFIDCount.CreationDateTime < $projection.CreationDateTime

  // Administrative data

  association [0..1] to I_User                         as _CreatedByUser                 on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                         as _SubmittedByUser               on  $projection.SubmittedByUser = _SubmittedByUser.UserID
{
  key storeproductrfidcountuuid      as StoreProductRFIDCountUUID,

      store                          as Store,
      storagelocation                as StorageLocation,
      numberofexpecteditems          as NumberOfExpectedItems,
      numberofsubmitteditems         as NumberOfSubmittedItems,
      numberofsubmittedmissingitems  as NumberOfSubmittedMissingItems,
      numberofsubmittedsurplusitems  as NumberOfSubmittedSurplusItems,
      notpostednrofsubmdmissingitems as NotPostedNrOfSubmdMissingItems,
      notpostednrofsubmdsurplusitems as NotPostedNrOfSubmdSurplusItems,
      skippednrofsubmdmissingitems   as SkippedNrOfSubmdMissingItems,
      skippednrofsubmdsurplusitems   as SkippedNrOfSubmdSurplusItems,
      unprocessedsalesareconsidered  as UnprocessedSalesAreConsidered,
      storeproductrfidcntprocgstatus as StoreProductRFIDCntProcgStatus,
      storeprodrfidcntexprtndtetme   as StoreProdRFIDCntExprtnDteTme,

      @Semantics.systemDate.createdAt: true
      creationdatetime               as CreationDateTime,
      createdbyuser                  as CreatedByUser,
      submissiondatetime             as SubmissionDateTime,
      submittedbyuser                as SubmittedByUser,

      _CreatedByUser,
      _SubmittedByUser,
      _PreviousStoreProductRFIDCount,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _StoreProductRFIDCountProduct,
      _StoreProdRFIDCntProdInstance
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RTST_CPR_COUNT"
],
"ASSOCIATED":
[
"I_STOREPRODRFIDCNTPRODINSTANCE",
"I_STOREPRODUCTRFIDCOUNTPRODUCT",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More