R_ARLockboxBatchTP

DDL: R_ARLOCKBOXBATCHTP Type: view_entity TRANSACTIONAL

Lockbox Batch

R_ARLockboxBatchTP is a Transactional CDS View that provides data about "Lockbox Batch" in SAP S/4HANA. It reads from 1 data source (I_ARLockBoxBatch) and exposes 16 fields with key fields LockboxBatchInternalKey, LockboxBatch. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ARLockBoxBatch header from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_ARLockboxBatchItemTP _Item

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Lockbox Batch view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey LockboxBatch view
ObjectModel.sapObjectNodeType.name ARLockbox view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY LockboxBatchInternalKey LockboxBatchInternalKey
KEY LockboxBatch LockboxBatch
Lockbox Lockbox
CompanyCode CompanyCode
LockboxBatchDestination LockboxBatchDestination
LockboxBatchOrigin LockboxBatchOrigin
IncomingPaymentFile IncomingPaymentFile
LockboxBatchStatus LockboxBatchStatus
LockboxBatchStatusName LockboxBatchStatusName
NumberOfItems NumberOfItems
Currency Currency
AmountInTransactionCurrency AmountInTransactionCurrency
NumberOfIncompleteCheques NumberOfIncompleteCheques
BatchIsLatest BatchIsLatest
JournalEntryIsNotToBePosted
_Item _Item 
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED }  }
@EndUserText: { label: 'Lockbox Batch' }
@VDM: { viewType:  #TRANSACTIONAL,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ObjectModel: { usageType:         { serviceQuality: #X,
                                     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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ARLOCKBOXBATCH"
],
"ASSOCIATED":
[
"R_ARLOCKBOXBATCHITEMTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More