R_ARLockboxBatchItemTP

DDL: R_ARLOCKBOXBATCHITEMTP Type: view_entity TRANSACTIONAL

Lockbox Batch Item

R_ARLockboxBatchItemTP is a Transactional CDS View that provides data about "Lockbox Batch Item" in SAP S/4HANA. It reads from 1 data source (I_ARLockBoxBatchItem) and exposes 33 fields with key fields LockboxBatchInternalKey, LockboxBatchItem, LockboxBatch.

Data Sources (1)

SourceAliasJoin Type
I_ARLockBoxBatchItem item from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Lockbox Batch 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 LockboxBatchItem view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY LockboxBatchInternalKey LockboxBatchInternalKey
KEY LockboxBatchItem LockboxBatchItem
KEY LockboxBatch LockboxBatch
ValueDate ValueDate
Currency Currency
AmountInTransactionCurrency AmountInTransactionCurrency
LockboxBatchItmStatus LockboxBatchItmStatus
LockboxBatchItmStatusName LockboxBatchItmStatusName
Cheque Cheque
PartnerBankCountry PartnerBankCountry
PartnerBank PartnerBank
PartnerBankAccount PartnerBankAccount
BankLedgerDocument BankLedgerDocument
Customer Customer
PaymentAdviceAccountType PaymentAdviceAccountType
MemoLine1 MemoLine1
MemoLine MemoLine
PaymentAdvice PaymentAdvice
AssignmentReference AssignmentReference
DocumentItemText DocumentItemText
DocumentReferenceID DocumentReferenceID
PaymentManualTransacType PaymentManualTransacType
BankLedgerIsPosted BankLedgerIsPosted
SubledgerIsPostedSuccessfully SubledgerIsPostedSuccessfully
LockboxSubledgerDocument LockboxSubledgerDocument
CompanyCode CompanyCode
FiscalYear FiscalYear
SubledgerDocument SubledgerDocument
LockboxBatchItmAdditionalInfo LockboxBatchItmAdditionalInfo
_Currency _Currency
_Header _Header
_JournalEntry _JournalEntry
_LockboxClearing _LockboxClearing
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED }  }
@EndUserText: { label: 'Lockbox Batch Item' }
@VDM: { viewType:  #TRANSACTIONAL,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ObjectModel: { usageType:         { serviceQuality: #X,
                                     sizeCategory:   #L,
                                     dataClass:      #TRANSACTIONAL },
                semanticKey:       [ 'LockboxBatchItem' ],
                representativeKey: 'LockboxBatchItem' }

define view entity R_ARLockboxBatchItemTP
   as select from I_ARLockBoxBatchItem as item

  composition[0..*] of R_ARLockboxBatchItmReferenceTP as _LockboxClearing
  
  association to parent R_ARLockboxBatchTP as _Header
    on  $projection.LockboxBatchInternalKey  = _Header.LockboxBatchInternalKey
    and $projection.LockboxBatch = _Header.LockboxBatch
    
{
        
   key LockboxBatchInternalKey, 
   
   //To display as Data Point in Item Detail Page

//   @UI.dataPoint: { title: 'Memo Line No.' }      

   key LockboxBatchItem,
   // To display as collection facet in detail page

   key LockboxBatch,
   
   ValueDate, 
     
   Currency,  
   
   //To set the default table columns 

   AmountInTransactionCurrency, 
     
   LockboxBatchItmStatus,
   
   LockboxBatchItmStatusName,
   
   Cheque, //until 02/2018 CustomerReferenceNumber was used here. By accident.     

   
   PartnerBankCountry,
   
   PartnerBank,
   
   PartnerBankAccount,
   
   @Consumption.semanticObject: 'AccountingDocument'
   BankLedgerDocument,
   
   Customer,   
   PaymentAdviceAccountType,
   
//   ApplicationLog, 

   
   MemoLine1,
   
   MemoLine,
   
   PaymentAdvice,
   AssignmentReference,
//   PaymentExternalTransacType,

   DocumentItemText,
   DocumentReferenceID,
   PaymentManualTransacType,
   BankLedgerIsPosted,
   SubledgerIsPostedSuccessfully,
   
   @Consumption.semanticObject: 'AccountingDocument'
   LockboxSubledgerDocument,
   CompanyCode,
   FiscalYear ,
   
   @Consumption.semanticObject: 'AccountingDocument'
   SubledgerDocument,
   
   LockboxBatchItmAdditionalInfo,
   
   _Currency,
   _Header,
   _JournalEntry,
   _LockboxClearing
   
}