P_ARLOCKBOXBATCHITEM

CDS View

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

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ARLockBoxBatchItem view from COMPOSITE Lockbox Batch Item Data 
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@AbapCatalog.sqlViewName: 'PARLOCKBOXITEM' 
define view P_ARLockBoxBatchItem 
    as select from P_Arbanktransactiondocitem_07
                  ( 
                    P_TransactionType : '2') as item                                      
{
   key StatementShortID                                         as LockboxBatchInternalKey,     
   key StatementItem                                            as LockboxBatchItem,
   key BatchNumber                                              as LockboxBatch,
   ValueDate,
   TransactionCurrency                                          as Currency,
   AmountInTransactionCurrency,
   AmountInOriginalCurrency,
   cast(case when BankLedgerIsPosted = 'X' and SubledgerIsPostedSuccessfully = 'X'
    then 
      case when NumberOfSecondSubledgerDoc = '' and PostingErrorStatus = '3' then '1'  
                                                                             else '2'  end
    else
      case when SubledgerOnAccountDocument = '' then '4'
                                                       else '3' end
   end as abap.char(1))                                         as LockboxBatchItmStatus,
   BankStatementItemDraftUUID,
   BankStatementInternalID,
   ProcessingStatus as LockboxProcessingStatus,
   CustomerReferenceNumber as Cheque, //The field CustomerReferenceNumber on P_Arbanktransactiondocitem_07 contains the check number    

   PartnerBankCountry,
   PartnerBank,
   PartnerBankAccount,                                                                
   BankLedgerDocument,
   BankLedgerAcctgDocFiscalYear,
   cast ('Log' as abap.char(3) )                                as ApplicationLog, 
   MemoLine1,
   cast ( ' ' as abap.char(1333) )                              as MemoLine,
   AssignmentReference,
   PaymentExternalTransacType,
   DocumentItemText,
   DocumentReferenceID,
   PaymentManualTransacType,
   BankLedgerIsPosted,
   SubledgerIsPostedSuccessfully,
   NumberOfSecondSubledgerDoc                                   as LockboxSubledgerDocument,
   CompanyCode,
   FiscalYear,
   SubledgerDocument,
   SubledgerAcctgDocFiscalYear,
   PaymentAdvice,
   NumberOfSecondSubledgerDoc,
   SubledgerOnAccountDocument,
   accdoc_tmp_doc_id,
   DebitCreditCode,
   
   BankPostingDate,
   BankPostingKey,
   BankReference,
   BusinessArea,
   BusinessPartnerName,
   TreasuryContract,
   DaybookEntry,
   DunningBlockingReason,
   ExchangeRate,
   FeeAmountInTransactionCrcy,
   FeeAmountInOriginalCrcy,
   IsCompleted,
   MemoLineIsChanged,
   OriginalCurrency,
   OverdueChargeAmtInTransacCrcy,
   PartnerBankIBAN,
   PartnerBankSWIFTCode,
   PaymentAdviceAccount,
   PaymentAdviceAccountType,
   PaymentAdviceAccountTypeName,
   PaymentReference,
   PostingDate,
   PostingErrorStatus,
   ProfitCenter,
   ReferenceDocument,
   ReferenceDocumentType,
   BankStmntItemReprocessReason,
   ReturnReason,
   TreasuryContractType,
   ValueDateTime,
   MachineLrngBankStmntItemStatus,
   CostCenter,
   AdditionalInformation
} where item.BankDataStorageApplication = '0003'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ARBANKTRANSACTIONDOCITEM_07"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More