A_ARLockboxBatchItem

DDL: A_ARLOCKBOXBATCHITEM Type: view_entity CONSUMPTION
28 Fields 1 Data Sources

Lockbox Batch Item

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

Data Sources (1)

SourceAliasJoin Type
R_ARLockboxBatchItemTP R_ARLockboxBatchItemTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Lockbox Batch Item view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY LockboxBatchInternalKey LockboxBatchInternalKey
KEY LockboxBatchItem LockboxBatchItem
KEY LockboxBatch LockboxBatch
ValueDate ValueDate Value Date
Currency Currency Valuation Crcy
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
LockboxBatchItmStatus LockboxBatchItmStatus
LockboxBatchItmStatusName LockboxBatchItmStatusName
Cheque Cheque Cheque No
PartnerBankCountry PartnerBankCountry Part. Ctry/Rgn
PartnerBank PartnerBank
PartnerBankAccount PartnerBankAccount
BankLedgerDocument BankLedgerDocument
Customer Customer Sold-to Party
MemoLine1 MemoLine1
MemoLine MemoLine Memo Line
PaymentAdvice PaymentAdvice Payment Advice Number
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
DocumentReferenceID DocumentReferenceID Reference
PaymentManualTransacType PaymentManualTransacType
BankLedgerIsPosted BankLedgerIsPosted
SubledgerIsPostedSuccessfully SubledgerIsPostedSuccessfully
LockboxSubledgerDocument LockboxSubledgerDocument
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
SubledgerDocument SubledgerDocument
LockboxBatchItmAdditionalInfo LockboxBatchItmAdditionalInfo

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_ARLockboxBatchItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_ARLockboxBatchItem AS
SELECT
  LockboxBatchInternalKey,
  LockboxBatchItem,
  LockboxBatch,
  ValueDate,
  Currency,
  AmountInTransactionCurrency,
  LockboxBatchItmStatus,
  LockboxBatchItmStatusName,
  Cheque,
  PartnerBankCountry,
  PartnerBank,
  PartnerBankAccount,
  BankLedgerDocument,
  Customer,
  MemoLine1,
  MemoLine,
  PaymentAdvice,
  AssignmentReference,
  DocumentItemText,
  DocumentReferenceID,
  PaymentManualTransacType,
  BankLedgerIsPosted,
  SubledgerIsPostedSuccessfully,
  LockboxSubledgerDocument,
  CompanyCode,
  FiscalYear,
  SubledgerDocument,
  LockboxBatchItmAdditionalInfo
FROM R_ARLockboxBatchItemTP
;

Learn More