R_ARLockboxBatchItmReferenceTP

DDL: R_ARLOCKBOXBATCHITMREFERENCETP Type: view_entity TRANSACTIONAL

Lockbox Payment Advice Item

R_ARLockboxBatchItmReferenceTP is a Transactional CDS View that provides data about "Lockbox Payment Advice Item" in SAP S/4HANA. It reads from 2 data sources (I_PaymentAdviceItem, febep) and exposes 15 fields with key fields PaymentAdvice, PaymentAdviceItem, PaymentAdviceAccount, PaymentAdviceAccountType, CompanyCode. It has 1 association to related views.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_PaymentAdviceItem a from
febep f inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_ARLockboxBatchTP _Root $projection.LockboxBatchInternalKey = _Root.LockboxBatchInternalKey and $projection.LockboxBatch = _Root.LockboxBatch

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Lockbox Payment Advice Item view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey PaymentAdvice view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PaymentAdvice I_PaymentAdviceItem PaymentAdvice
KEY PaymentAdviceItem I_PaymentAdviceItem PaymentAdviceItem
KEY PaymentAdviceAccount I_PaymentAdviceItem PaymentAdviceAccount
KEY PaymentAdviceAccountType I_PaymentAdviceItem PaymentAdviceAccountType
KEY CompanyCode I_PaymentAdviceItem CompanyCode
LockboxBatchInternalKey febep kukey
LockboxBatchItem febep esnum
LockboxBatch febep batch
PaymentReference I_PaymentAdviceItem PaymentReference
NetPaymentAmountInPaytCurrency I_PaymentAdviceItem NetPaymentAmountInPaytCurrency
DeductionAmountInPaytCurrency I_PaymentAdviceItem DeductionAmountInPaytCurrency
PaymentDifferenceReason I_PaymentAdviceItem PaymentDifferenceReason
Currency I_PaymentAdviceItem Currency
_BatchItem _BatchItem
_Root _Root 
@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: #X,
                                     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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PAYMENTADVICEITEM",
"FEBEP"
],
"ASSOCIATED":
[
"R_ARLOCKBOXBATCHITEMTP",
"R_ARLOCKBOXBATCHTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More