R_ARLOCKBOXBATCHITMREFERENCETP

CDS View

Lockbox Payment Advice Item

R_ARLOCKBOXBATCHITMREFERENCETP is a CDS View in S/4HANA. Lockbox Payment Advice Item. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ARLockboxBatchItmReference view_entity projection CONSUMPTION Lockbox Payment Advice Item 
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED }  }
@EndUserText: { label: 'Lockbox Payment Advice Item' }
@VDM: { viewType:  #TRANSACTIONAL,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ObjectModel: { usageType:         { serviceQuality: #C,
                                     sizeCategory:   #L,
                                     dataClass:      #TRANSACTIONAL },
                semanticKey:       [ 'PaymentReference' ],
                representativeKey: 'PaymentAdvice' }
define view entity R_ARLockboxBatchItmReferenceTP
  as select from I_PaymentAdviceItem as a inner join febep as f 

on f.avsid = a.PaymentAdvice 
  
  association to parent R_ARLockboxBatchItemTP as _BatchItem
    on $projection.LockboxBatchInternalKey = _BatchItem.LockboxBatchInternalKey
     and $projection.LockboxBatchItem = _BatchItem.LockboxBatchItem
     and $projection.LockboxBatch = _BatchItem.LockboxBatch
     
  association [1..1] to R_ARLockboxBatchTP as _Root
    on $projection.LockboxBatchInternalKey = _Root.LockboxBatchInternalKey
     and $projection.LockboxBatch = _Root.LockboxBatch
  
{
  key a.PaymentAdvice as PaymentAdvice,
  key a.PaymentAdviceItem as PaymentAdviceItem,
  key a.PaymentAdviceAccount as PaymentAdviceAccount,
  key a.PaymentAdviceAccountType as PaymentAdviceAccountType,
  key a.CompanyCode as CompanyCode,
  f.kukey as LockboxBatchInternalKey,
  f.esnum as LockboxBatchItem,
  f.batch as LockboxBatch,
  a.PaymentReference as PaymentReference,
  a.NetPaymentAmountInPaytCurrency as NetPaymentAmountInPaytCurrency,
  a.DeductionAmountInPaytCurrency as DeductionAmountInPaytCurrency,
  a.PaymentDifferenceReason as PaymentDifferenceReason,
  a.Currency as Currency,
  _BatchItem,
  _Root
}

Learn More