P_ARLOCKBOXBATCHITEM

CDS View

Lockbox Batch Item Details Aggegation

P_ARLOCKBOXBATCHITEM is a CDS View in S/4HANA. Lockbox Batch Item Details Aggegation. It contains 53 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 53 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ARLockBoxBatchItem view_entity from COMPOSITE Lockbox Batch Item Data

Fields (53)

KeyField CDS FieldsUsed in Views
KEY LockboxBatch LockboxBatch 1
KEY LockboxBatchInternalKey LockboxBatchInternalKey 1
KEY LockboxBatchItem LockboxBatchItem 1
AdditionalInformation LockboxBatchItmAdditionalInfo 1
AmountInOriginalCurrency AmountInOriginalCurrency 1
AssignmentReference AssignmentReference 1
BankLedgerAcctgDocFiscalYear BankLedgerAcctgDocFiscalYear 1
BankLedgerDocument BankLedgerDocument 1
BankPostingDate BankPostingDate 1
BankPostingKey BankPostingKey 1
BankReference BankReference 1
BankStatementInternalID BankStatementInternalID 1
BankStatementItemDraftUUID BankStatementItemDraftUUID 1
BankStmntItemReprocessReason BankStmntItemReprocessReason 1
BusinessArea BusinessArea 1
BusinessPartnerName BusinessPartnerName 1
CompanyCode CompanyCode 1
CostCenter CostCenter 1
Currency Currency 1
DaybookEntry DaybookEntry 1
DebitCreditCode DebitCreditCode 1
DocumentReferenceID DocumentReferenceID 1
DunningBlockingReason DunningBlockingReason 1
ExchangeRate ExchangeRate 1
FeeAmountInOriginalCrcy FeeAmountInOriginalCrcy 1
FeeAmountInTransactionCrcy FeeAmountInTransactionCrcy 1
FiscalYear FiscalYear 1
IsCompleted IsCompleted 1
LockboxProcessingStatus LockboxProcessingStatus 1
MachineLrngBankStmntItemStatus MachineLrngBankStmntItemStatus 1
MemoLineIsChanged MemoLineIsChanged 1
OriginalCurrency OriginalCurrency 1
OverdueChargeAmtInTransacCrcy OverdueChargeAmtInTransacCrcy 1
PartnerBankIBAN PartnerBankIBAN 1
PartnerBankSWIFTCode PartnerBankSWIFTCode 1
PaymentAdvice PaymentAdvice 1
PaymentAdviceAccount PaymentAdviceAccount 1
PaymentAdviceAccountType PaymentAdviceAccountType 1
PaymentAdviceAccountTypeName PaymentAdviceAccountTypeName 1
PaymentReference PaymentReference 1
PostingDate PostingDate 1
PostingErrorStatus PostingErrorStatus 1
ProfitCenter ProfitCenter 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentType ReferenceDocumentType 1
ReturnReason ReturnReason 1
SubledgerAcctgDocFiscalYear SubledgerAcctgDocFiscalYear 1
SubledgerDocument SubledgerDocument 1
SubledgerOnAccountDocument SubledgerOnAccountDocument 1
TreasuryContract TreasuryContract 1
TreasuryContractType TreasuryContractType 1
ValueDate ValueDate 1
ValueDateTime ValueDateTime 1 
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity 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,
      @Semantics.amount.currencyCode: 'Currency'
      cast( AmountInTransactionCurrency   as farp_kwbtr) as AmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'ORIGINALCURRENCY'
      cast( AmountInOriginalCurrency   as farp_fwbtr)    as 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,
      @Semantics.amount.currencyCode: 'CURRENCY'
      FeeAmountInTransactionCrcy,
      @Semantics.amount.currencyCode: 'ORIGINALCURRENCY'
      FeeAmountInOriginalCrcy,
      IsCompleted,
      MemoLineIsChanged,
      OriginalCurrency,
      @Semantics.amount.currencyCode: 'CURRENCY'
      OverdueChargeAmtInTransacCrcy,
      PartnerBankIBAN,
      PartnerBankSWIFTCode,
      PaymentAdviceAccount,
      PaymentAdviceAccountType,
      PaymentAdviceAccountTypeName,
      PaymentReference,
      PostingDate,
      PostingErrorStatus,
      ProfitCenter,
      ReferenceDocument,
      ReferenceDocumentType,
      BankStmntItemReprocessReason,
      ReturnReason,
      TreasuryContractType,
      ValueDateTime,
      MachineLrngBankStmntItemStatus,
      CostCenter,
      AdditionalInformation
}
where
  item.BankDataStorageApplication = '0003'

Learn More