R_ARLOCKBOXBATCHTP

CDS View

Lockbox Batch

R_ARLOCKBOXBATCHTP is a CDS View in S/4HANA. Lockbox Batch. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ARLockboxBatch view_entity projection CONSUMPTION Lockbox Batch 
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED }  }
@EndUserText: { label: 'Lockbox Batch' }
@VDM: { viewType:  #TRANSACTIONAL,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ObjectModel: { usageType:         { serviceQuality: #C,
                                     sizeCategory:   #L,
                                     dataClass:      #TRANSACTIONAL },
                semanticKey:       [ 'LockboxBatch' ],
                representativeKey: 'LockboxBatch' }
@ObjectModel.sapObjectNodeType.name: 'ARLockbox'

define root view entity R_ARLockboxBatchTP
  as select from I_ARLockBoxBatch as header 

  composition [0..*] of R_ARLockboxBatchItemTP as _Item
//  association [0..1] to I_Housebank            as _HouseBank          on  $projection.HouseBank   = _HouseBank.HouseBank

//                                                                      and $projection.CompanyCode = _HouseBank.CompanyCode

//  association [0..1] to I_HouseBankAccountVH   as _HouseBankAccountVH on  _HouseBankAccountVH.CompanyCode      = $projection.CompanyCode

//                                                                      and _HouseBankAccountVH.HouseBank        = $projection.HouseBank

//                                                                      and _HouseBankAccountVH.HouseBankAccount = $projection.HouseBankAccount


{

      //For Filter Group

      //@UI.fieldGroup: { qualifier: 'Lockbox Batch', position: 10 }

  key LockboxBatchInternalKey,

      //To set the default table columns

  key LockboxBatch,

//      @ObjectModel.foreignKey.association: '_Lockbox'

      Lockbox,

      CompanyCode,

      @Consumption.semanticObject: 'HouseBank'
      //HouseBank,


      //@ObjectModel.foreignKey.association: '_HouseBank'

      LockboxBatchDestination,
      LockboxBatchOrigin,
      cast(dats_tims_to_tstmp(DepositDate,
                              DepositTime,
                              'UTC',
                              $session.client,
                              'INITIAL' ) as far_aztmstmp) as DepositDateTime,                
      
      @Consumption.semanticObject: 'IncomingPaymentFile'
      IncomingPaymentFile,

      //@UI.selectionField.qualifier: 'Batch Status'

      LockboxBatchStatus,

      LockboxBatchStatusName,

      NumberOfItems,

      Currency,

      AmountInTransactionCurrency,

      NumberOfIncompleteCheques,

      BatchIsLatest,
      
      ' ' as JournalEntryIsNotToBePosted,

//      _Company,

      //_Housebank,

//      _HouseBankAccountVH,

//      _Lockbox,

//      _Currency,

      _Item

}

Learn More