What is A_PaymentAdviceItem in SAP S/4HANA?

A_PaymentAdviceItem is a basic CDS view in SAP S/4HANA. Payment Advice Line Item It contains 56 fields.

Which tables does A_PaymentAdviceItem read from?

A_PaymentAdviceItem reads data from: I_PaymentAdviceItem.

What VDM layer is A_PaymentAdviceItem?

A_PaymentAdviceItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

A_PaymentAdviceItem

DDL: A_PAYMENTADVICEITEM Type: view BASIC

56 Fields 1 Data Sources 4 Associations

Payment Advice Line Item

A_PaymentAdviceItem is a Basic CDS View that provides data about "Payment Advice Line Item" in SAP S/4HANA. It reads from 1 data source (I_PaymentAdviceItem) and exposes 56 fields with key fields CompanyCode, PaymentAdviceAccountType, PaymentAdviceAccount, PaymentAdvice, PaymentAdviceItem. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PaymentAdviceItem	I_PaymentAdviceItem	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	A_Customer	_Customer	`$projection.PaymentAdviceAccount = _Customer.Customer`
[1..1]	A_CustomerCompany	_CustomerCompany	`$projection.PaymentAdviceAccount = _CustomerCompany.Customer and $projection.CompanyCode = _CustomerCompany.CompanyCode`
[0..1]	A_Supplier	_Supplier	`$projection.PaymentAdviceAccount = _Supplier.Supplier`
[1..1]	A_SupplierCompany	_SupplierCompany	`$projection.PaymentAdviceAccount = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	APAYTADVCITM	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Payment Advice Line Item	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view

Fields (56)

Key	Field	Source Field	Description
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	PaymentAdviceAccountType	PaymentAdviceAccountType	Account Type
KEY	PaymentAdviceAccount	PaymentAdviceAccount	Account
KEY	PaymentAdvice	PaymentAdvice	Payment Advice Number
KEY	PaymentAdviceItem	PaymentAdviceItem	Payt Adv. Item
	PaymentAdviceAltvAccount	PaymentAdviceAltvAccount	Altern. Account
	AlternativeCompanyCode	AlternativeCompanyCode	Alternative Company Code
	AccountingDocument	AccountingDocument	Journal Entry
	DocumentReferenceID	DocumentReferenceID	Reference
	BillingDocument	BillingDocument	SD Document
	BranchAccount	BranchAccount	Branch Account No.
	AccountingDocumentCreationDate	AccountingDocumentCreationDate	Journal Entry Date
	BusinessArea	BusinessArea	Business Area
	AssignmentReference	AssignmentReference	Assignment Reference
	PaytDifferenceReasonExtCode	PaytDifferenceReasonExtCode	Ext.Reason Code
	DocumentItemText	DocumentItemText	Text
	TaxAmountInCoCodeCrcy	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxCode	TaxCode	Tax Code
	GrossAmountInPaymentCurrency	GrossAmountInPaymentCurrency	Gross Amount
	NetPaymentAmountInPaytCurrency	NetPaymentAmountInPaytCurrency	Payment Amount
	CashDiscountAmountInPaytCrcy	CashDiscountAmountInPaytCrcy	Cash Discount Amount
	FiscalYear	FiscalYear	G/L Fiscal Year
	AccountingDocumentItem	AccountingDocumentItem	Posting View Item
	PaymentAdviceAltvAccountType	PaymentAdviceAltvAccountType	Alternative Account Type
	CashDiscountPercent	CashDiscountPercent	Cash Discount %
	CashDiscountDays	CashDiscountDays	Cash Disc.Days
	DifferenceAmountInCoCodeCrcy	DifferenceAmountInCoCodeCrcy	Difference Val.
	DifferenceAmount	DifferenceAmount	Amount Difference in Foreign Currency
	DiffAmtInAdditionalCurrency1	DiffAmtInAdditionalCurrency1	Amount Diff. in Second Local Currency
	DiffAmtInAdditionalCurrency2	DiffAmtInAdditionalCurrency2	Amount Diff. in Third Local Currency
	ItemIsActivated	ItemIsActivated	Items Active
	CashDiscountIsActivated	CashDiscountIsActivated	Cash Discount Activated
	IsPartialPayment	IsPartialPayment	Partial Payments
	PaytDiffRsdlBalIsCarriedFwd	PaytDiffRsdlBalIsCarriedFwd	Carryforward for Payment Difference
	PaymentDifferenceReason	PaymentDifferenceReason	Reason Code
	Currency	Currency	Valuation Crcy
	Reference1IDByBusinessPartner	Reference1IDByBusinessPartner	Reference Key 1
	Reference2IDByBusinessPartner	Reference2IDByBusinessPartner	Reference Key 2
	DeliveryDocument	DeliveryDocument	Outbound Delivery
	InvoiceDate	InvoiceDate	Run On
	PurchasingDocReferenceByCust	PurchasingDocReferenceByCust	Cust. Reference
	IsPostedOnAccount	IsPostedOnAccount	On Account
	PaymentAdviceStatus	PaymentAdviceStatus	Payment Advice Status
	DeductionAmountInPaytCurrency	DeductionAmountInPaytCurrency	Deduction Amount
	PaymentReference	PaymentReference	Payment Reference
	PaymentAdviceSelectionField	PaymentAdviceSelectionField	Selection Field
	PaymentAdviceSelectionValue	PaymentAdviceSelectionValue	Value
	PaytAdvcExternalSelectionField	PaytAdvcExternalSelectionField	External Selection
	TaxCalculationProcedure	TaxCalculationProcedure	Tax Procedure
	AdditionalCurrency1	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	AdditionalCurrency2	Local curr. 3
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	_Customer	_Customer
	_CustomerCompany	_CustomerCompany
	_Supplier	_Supplier
	_SupplierCompany	_SupplierCompany

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_PaymentAdviceItem.
-- 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_PaymentAdviceItem AS
SELECT
  CompanyCode,
  PaymentAdviceAccountType,
  PaymentAdviceAccount,
  PaymentAdvice,
  PaymentAdviceItem,
  PaymentAdviceAltvAccount,
  AlternativeCompanyCode,
  AccountingDocument,
  DocumentReferenceID,
  BillingDocument,
  BranchAccount,
  AccountingDocumentCreationDate,
  BusinessArea,
  AssignmentReference,
  PaytDifferenceReasonExtCode,
  DocumentItemText,
  TaxAmountInCoCodeCrcy,
  TaxCode,
  GrossAmountInPaymentCurrency,
  NetPaymentAmountInPaytCurrency,
  CashDiscountAmountInPaytCrcy,
  FiscalYear,
  AccountingDocumentItem,
  PaymentAdviceAltvAccountType,
  CashDiscountPercent,
  CashDiscountDays,
  DifferenceAmountInCoCodeCrcy,
  DifferenceAmount,
  DiffAmtInAdditionalCurrency1,
  DiffAmtInAdditionalCurrency2,
  ItemIsActivated,
  CashDiscountIsActivated,
  IsPartialPayment,
  PaytDiffRsdlBalIsCarriedFwd,
  PaymentDifferenceReason,
  Currency,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  DeliveryDocument,
  InvoiceDate,
  PurchasingDocReferenceByCust,
  IsPostedOnAccount,
  PaymentAdviceStatus,
  DeductionAmountInPaytCurrency,
  PaymentReference,
  PaymentAdviceSelectionField,
  PaymentAdviceSelectionValue,
  PaytAdvcExternalSelectionField,
  TaxCalculationProcedure,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CompanyCodeCurrency
FROM I_PaymentAdviceItem
LEFT OUTER JOIN A_Customer AS _Customer ON PaymentAdviceAccount = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN A_CustomerCompany AS _CustomerCompany ON PaymentAdviceAccount = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN A_Supplier AS _Supplier ON PaymentAdviceAccount = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN A_SupplierCompany AS _SupplierCompany ON PaymentAdviceAccount = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [1..1]
;

Depth:

A_PaymentAdviceItem view

I_PaymentAdviceItem view