C_ARLockBoxBatchItem

DDL: C_ARLOCKBOXBATCHITEM Type: view_entity CONSUMPTION Package: ODATA_LOCKBOX

Lockbox Batch Item

C_ARLockBoxBatchItem is a Consumption CDS View that provides data about "Lockbox Batch Item" in SAP S/4HANA. It reads from 1 data source (I_ARLockBoxBatchItem) and exposes 32 fields with key fields LockboxBatchInternalKey, LockboxBatchItem, LockboxBatch. It has 1 association to related views. Part of development package ODATA_LOCKBOX.

Data Sources (1)

SourceAliasJoin Type
I_ARLockBoxBatchItem item from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_ARLockBoxBatch _Header item.LockboxBatchInternalKey = _Header.LockboxBatchInternalKey and item.LockboxBatch = _Header.LockboxBatch

Annotations (11)

NameValueLevelField
EndUserText.label Lockbox Batch Item view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Lockbox Batch Item view
UI.headerInfo.typeNamePlural Lockbox Batch Items view
UI.headerInfo.title.value LockboxBatchItem view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value _Header.Lockbox view

Fields (32)

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
ApplicationLog ApplicationLog
MemoLine1 MemoLine1
MemoLine MemoLine
PaymentAdvice PaymentAdvice
AssignmentReference AssignmentReference
PaymentExternalTransacType PaymentExternalTransacType
DocumentItemText DocumentItemText
DocumentReferenceID DocumentReferenceID
PaymentManualTransacType PaymentManualTransacType
BankLedgerIsPosted BankLedgerIsPosted
SubledgerIsPostedSuccessfully SubledgerIsPostedSuccessfully
LockboxSubledgerDocument LockboxSubledgerDocument
CompanyCode CompanyCode
FiscalYear FiscalYear
SubledgerDocument SubledgerDocument
_Currency _Currency
_Header _Header
_JournalEntry _JournalEntry
@EndUserText.label: 'Lockbox Batch Item'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA') //Partner's Bank Account - archiving is possible

@ObjectModel.usageType.sizeCategory: #XL 
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@UI.headerInfo:{ 
  typeName: 'Lockbox Batch Item',
  typeNamePlural: 'Lockbox Batch Items',
  title: { value: 'LockboxBatchItem' },
  description: { type: #STANDARD, value: '_Header.Lockbox'}
}
@UI.presentationVariant: [{requestAtLeast: [ 'FiscalYear' ]}]
define view entity C_ARLockBoxBatchItem 
   as select from I_ARLockBoxBatchItem as item

  association [1..1] to C_ARLockBoxBatch as _Header
    on  item.LockboxBatchInternalKey   = _Header.LockboxBatchInternalKey
    and item.LockboxBatch  = _Header.LockboxBatch
    
{
    @UI.facet: [
    {
      label: 'Lockbox Batch Item',
      id: 'COLLFAC2',
      type: #COLLECTION,
      position: 10
    },
    {
      label: '',
      id: 'Q1',
      parentId: 'COLLFAC2',
      type: #IDENTIFICATION_REFERENCE,
      position: 10      
    }
    ]
   @UI.identification: [{ position: 29 }]
   key LockboxBatchInternalKey, 
   
   @UI.identification: [{ position: 28 }]  
   key LockboxBatchItem,
   
   @UI.identification: [{ position: 1 }]
   key LockboxBatch,
   
   @UI.identification: [{ position: 3 }] 
   ValueDate, 
   
   @UI.identification: [{ position: 5 }]
   Currency,  
   
   @Semantics.amount.currencyCode: 'CURRENCY' 
@UI.identification: [{ position: 4 }]
   //To set the default table columns 

   @UI.lineItem: [ {position:60, importance: #HIGH } ]
   AmountInTransactionCurrency, 
   
   @UI.identification: [{ position: 8 }]  
   LockboxBatchItmStatus,
   
   @UI.identification: [{ position: 26 }]
   @UI.lineItem: [ { position:10, importance: #HIGH } ]
   LockboxBatchItmStatusName,
   
   @UI.identification: [{ position: 2 }] 
   @UI.lineItem: [{position:20}]
   Cheque, //until 02/2018 CustomerReferenceNumber was used here. By accident.     

   
   @UI.identification: [{ position: 25 }]
   @UI.lineItem: [ { position:30, importance: #HIGH } ]
   PartnerBankCountry,
   
   @UI.identification: [{ position: 24 }]
   @UI.lineItem: [ { position:40, importance: #HIGH } ]
   PartnerBank,
   
   @UI.identification: [{ position: 23 }]
   @UI.lineItem: [ { position:50, importance: #HIGH } ]
   PartnerBankAccount,
   
   @UI.identification: [{ position: 10 }]
   @UI.lineItem: [ { position:70, importance: #HIGH } ]
   @Consumption.semanticObject: 'AccountingDocument'
   BankLedgerDocument,
   
   @UI.identification: [{ position: 9 }]
   @UI.lineItem: [ { position:80, importance: #HIGH } ]
   Customer,   
   
   @UI.identification: [{ position: 27 }]
   ApplicationLog, 
   
   //not needed due to new string based persistence

   @UI.identification: [{ position: 7 }]
   @UI.lineItem: [ { position:90, importance: #HIGH } ]
   MemoLine1,
   
   @UI.identification: [{ position: 6 }]   
   MemoLine,
   
   @UI.identification: [{ position: 11 }]
   @UI.lineItem: [ { position:95, importance: #HIGH } ]
   @Consumption.semanticObject: 'PaymentAdvice'
   PaymentAdvice,
   
   @UI.identification: [{ position: 12 }]
   AssignmentReference,
   @UI.identification: [{ position: 13 }]
   PaymentExternalTransacType,
   @UI.identification: [{ position: 14 }]
   DocumentItemText,
   @UI.identification: [{ position: 15 }]
   DocumentReferenceID,
   @UI.identification: [{ position: 16 }]
   PaymentManualTransacType,
   @UI.identification: [{ position: 17 }]
   BankLedgerIsPosted,
   @UI.identification: [{ position: 18 }]
   SubledgerIsPostedSuccessfully,
   
   @UI.identification: [{ position: 19 }]
   @Consumption.semanticObject: 'AccountingDocument'
   LockboxSubledgerDocument,
   
   @UI.identification: [{ position: 20 }]
   CompanyCode,
   @UI.identification: [{ position: 21 }]
 //  @UI.lineItem: [ { position:100, importance: #HIGH } ]

   FiscalYear ,
   @UI.identification: [{ position: 22 }]
   @Consumption.semanticObject: 'AccountingDocument'
   SubledgerDocument,
   
   _Currency,
   _Header,
   _JournalEntry
   
}