P_ARLOCKBOXBATCH

CDS View

Lock Box Batch Header Data

P_ARLOCKBOXBATCH is a CDS View in S/4HANA. Lock Box Batch Header Data. It contains 16 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 16 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ARLockbox view_entity from COMPOSITE Lockboxes at our House Banks
I_ARLockBoxBatch view_entity from COMPOSITE Lock Box Batch Header Data
P_Arlockboxbatchlatest view_entity from COMPOSITE Latest lockbox Batches

Fields (16)

KeyField CDS FieldsUsed in Views
KEY LockboxBatchInternalKey LockboxBatchInternalKey 1
BankAccount BankAccount 1
BankAccountAdditionalName BankAccountAdditionalName 1
BankAccountHolderName BankAccountHolderName 1
BankAccountInternalID BankAccountInternalID 1
BankAccountReferenceText BankAccountReferenceText 1
BankAccountType BankAccountType 1
BankName BankName 1
BankStatementImportDate BankStatementImportDate 1
BankStatementImportTime BankStatementImportTime 1
ChartOfAccounts ChartOfAccounts 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
Currency Currency 1
GLAccount GLAccount 1
InterestRateInPercent InterestRateInPercent 1 
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity P_Arlockboxbatch

  as select from    P_Arbanktransactiondoc   as hdr // passing the 0003 application for LockBox


    left outer join P_Arlockboxbatchitemaggr as itm on itm.LockboxBatchInternalKey = hdr.StatementShortID


{

  key hdr.StatementShortID                                                       as LockboxBatchInternalKey,
  key itm.LockboxBatch                                                           as LockboxBatch,

      cast(lpad(rtrim(substring(hdr.InternalID,1,7),' '),7,'0') as abap.numc(7)) as Lockbox,

      hdr.SendingBank,
      hdr.CompanyCode,
      hdr.HouseBank,
      hdr.HouseBankAccount,
      hdr.StatementDate                                                          as DepositDate,
      hdr.BankStatementTime                                                      as DepositTime,
      itm.NumberOfItems                                                          as NumberOfItems,
      itm.Currency,
      @Semantics.amount.currencyCode: 'Currency'
      cast( itm.AmountInTransactionCurrency   as farp_kwbtr)                     as AmountInTransactionCurrency,
      itm.NumberOfIncompleteCheques                                              as NumberOfIncompleteCheques,
      hdr.BankAccount,
      hdr.BankAccountInternalID,
      hdr.BankAccountHolderName,
      hdr.BankAccountAdditionalName,
      hdr.BankAccountType,
      hdr.BankName,
      hdr.ChartOfAccounts,
      hdr.CreatedByUser,
      hdr.GLAccount,
      hdr.InterestRateInPercent,
      hdr.BankAccountReferenceText,
      hdr.BankStatementImportDate,
      hdr.BankStatementImportTime,

      case
       when itm.NumberOfIncompleteCheques = 0 then cast( '8' as abap.char(1))
                else cast('7' as abap.char(1)) end                               as LockboxBatchStatus

}
where
  hdr.BankDataStorageApplication = '0003' // passing the 0003 application for LockBox

Learn More