R_ARLOCKBOXBATCHITEMTP
Lockbox Batch Item
R_ARLOCKBOXBATCHITEMTP is a CDS View in S/4HANA. Lockbox Batch Item. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ARLockboxBatchItem | view_entity | projection | CONSUMPTION | Lockbox Batch Item |
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ARLOCKBOXBATCHITEM"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_JOURNALENTRY",
"R_ARLOCKBOXBATCHITMREFERENCETP",
"R_ARLOCKBOXBATCHTP"
],
"BASE":
[
"I_ARLOCKBOXBATCHITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/