P_ARLOCKBOXBATCH

CDS View

P_ARLOCKBOXBATCH is a CDS View in S/4HANA. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ARLockbox view from COMPOSITE Lockboxes at our House Banks
I_ARLockBoxBatch view from COMPOSITE Lock Box Batch Header Data
P_Arlockboxbatchlatest view from COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
KEY LockboxBatchInternalKey LockboxBatchInternalKey 1 
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@AbapCatalog.sqlViewName: 'PARLOCKBOXBATCH' 

define view 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 StatementShortID                                                         as LockboxBatchInternalKey,
   key itm.LockboxBatch                                                         as LockboxBatch,      
   
   cast(LPAD(RTRIM(SUBSTRING(InternalID,1,7),' '),7,'0') as abap.numc(7))       as Lockbox,
   
   SendingBank,
   CompanyCode,
   HouseBank,
   HouseBankAccount,
   StatementDate                                                                as DepositDate,    
   BankStatementTime                                                            as DepositTime,
   itm.NumberOfItems                                                            as NumberOfItems,   
   itm.Currency,
   itm.AmountInTransactionCurrency                                              as AmountInTransactionCurrency,
   itm.NumberOfIncompleteCheques                                                as NumberOfIncompleteCheques,
   BankAccount,
   BankAccountInternalID,
   BankAccountHolderName,
   BankAccountAdditionalName,
   BankAccountType,
   BankName,
   ChartOfAccounts,
   CreatedByUser,
   GLAccount,
   InterestRateInPercent,
   BankAccountReferenceText,
   BankStatementImportDate,                         
   BankStatementImportTime,
   
   case 
    when 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