What is C_PaymentAdviceItem in SAP S/4HANA?

C_PaymentAdviceItem is a consumption CDS view in SAP S/4HANA. Payment Advice Item It contains 79 fields.

Which tables does C_PaymentAdviceItem read from?

C_PaymentAdviceItem reads data from: I_PaymentAdviceItemTP.

What VDM layer is C_PaymentAdviceItem?

C_PaymentAdviceItem is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PaymentAdviceItem

DDL: C_PAYMENTADVICEITEM SQL: CPAYTADVCITM Type: view CONSUMPTION

79 Fields 1 Data Sources 2 Associations

Payment Advice Item

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

Data Sources (1)

Source	Alias	Join Type
I_PaymentAdviceItemTP	I_PaymentAdviceItemTP	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	C_PaymentAdvice	_PaymentAdvice	`$projection.CompanyCode = _PaymentAdvice.CompanyCode and $projection.PaymentAdviceAccountType = _PaymentAdvice.PaymentAdviceAccountType and $projection.PaymentAdviceAccount = _PaymentAdvice.PaymentAdviceAccount and $projection.PaymentAdvice = _PaymentAdvice.PaymentAdvice`
[0..*]	C_PaymentAdviceSubItem	_PaymentAdviceSubItem	`$projection.CompanyCode = _PaymentAdviceSubItem.CompanyCode and $projection.PaymentAdviceAccountType = _PaymentAdviceSubItem.PaymentAdviceAccountType and $projection.PaymentAdviceAccount = _PaymentAdviceSubItem.PaymentAdviceAccount and $projection.PaymentAdvice = _PaymentAdviceSubItem.PaymentAdvice and $projection.PaymentAdviceItem = _PaymentAdviceSubItem.PaymentAdviceItem`

Annotations (22)

Name	Value	Level
AbapCatalog.sqlViewName	CPAYTADVCITM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Payment Advice Item	view
VDM.viewType	#CONSUMPTION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
UI.headerInfo.typeName	Payment Advice Item	view
UI.headerInfo.typeNamePlural	Payment Advice Items	view
UI.headerInfo.title.label	Payment Advice Item	view
UI.headerInfo.title.value	PaymentAdviceItem	view
UI.headerInfo.description.type	#STANDARD	view
UI.headerInfo.description.value	PaymentAdviceForEdit	view
UI.presentationVariant.sortOrder.by	PaymentAdviceItemForEdit	view
UI.presentationVariant.sortOrder.direction	#ASC	view

Fields (79)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_PaymentAdviceItemTP	CompanyCode	Receiver Company Code
KEY	PaymentAdviceAccountType	I_PaymentAdviceItemTP	PaymentAdviceAccountType	Account Type
KEY	PaymentAdviceAccount	I_PaymentAdviceItemTP	PaymentAdviceAccount	Account
KEY	PaymentAdvice	I_PaymentAdviceItemTP	PaymentAdvice	Payment Advice Number
KEY	PaymentAdviceItem	I_PaymentAdviceItemTP	PaymentAdviceItem	Payt Adv. Item
	CompanyCodeForEdit	I_PaymentAdviceItemTP	CompanyCodeForEdit	Company Code
	PaytAdviceAccountTypeForEdit	I_PaymentAdviceItemTP	PaytAdviceAccountTypeForEdit	Subledger
	PaymentAdviceAccountForEdit	I_PaymentAdviceItemTP	PaymentAdviceAccountForEdit	Account
	PaymentAdviceForEdit	I_PaymentAdviceItemTP	PaymentAdviceForEdit	Payment Advice Number
	PaymentAdviceItemForEdit	I_PaymentAdviceItemTP	PaymentAdviceItemForEdit	Payt Adv. Item
	AccountingDocument	I_PaymentAdviceItemTP	AccountingDocument	Journal Entry
	AccountingDocumentCreationDate	I_PaymentAdviceItemTP	AccountingDocumentCreationDate	Journal Entry Date
	NetPaymentAmountInPaytCurrency	I_PaymentAdviceItemTP	NetPaymentAmountInPaytCurrency	Payment Amount
	Currency	I_PaymentAdviceItemTP	Currency	Valuation Crcy
	AccountingDocumentItem	I_PaymentAdviceItemTP	AccountingDocumentItem	Posting View Item
	AlternativeCompanyCode	I_PaymentAdviceItemTP	AlternativeCompanyCode	Alternative Company Code
	DifferenceAmountInCoCodeCrcy	I_PaymentAdviceItemTP	DifferenceAmountInCoCodeCrcy	Difference Val.
	BillingDocument	I_PaymentAdviceItemTP	BillingDocument	SD Document
	BranchAccount	I_PaymentAdviceItemTP	BranchAccount	Branch Account No.
	BusinessArea	I_PaymentAdviceItemTP	BusinessArea	Business Area
	BusinessAreaName	I_PaymentAdviceItemTP	BusinessAreaName	Business Area Name
	CashDiscountAmountInPaytCrcy	I_PaymentAdviceItemTP	CashDiscountAmountInPaytCrcy	Cash Discount Amount
	CashDiscountDays	I_PaymentAdviceItemTP	CashDiscountDays	Cash Disc.Days
	PaymentAdviceAltvAccount	I_PaymentAdviceItemTP	PaymentAdviceAltvAccount	Altern. Account
	DocumentReferenceID	I_PaymentAdviceItemTP	DocumentReferenceID	Reference
	AssignmentReference	I_PaymentAdviceItemTP	AssignmentReference	Assignment Reference
	PaytDifferenceReasonExtCode	I_PaymentAdviceItemTP	PaytDifferenceReasonExtCode	Ext.Reason Code
	DocumentItemText	I_PaymentAdviceItemTP	DocumentItemText	Text
	TaxAmountInCoCodeCrcy	I_PaymentAdviceItemTP	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxCode	I_PaymentAdviceItemTP	TaxCode	Tax Code
	GrossAmountInPaymentCurrency	I_PaymentAdviceItemTP	GrossAmountInPaymentCurrency	Gross Amount
	FiscalYear	I_PaymentAdviceItemTP	FiscalYear	G/L Fiscal Year
	PaymentAdviceAltvAccountType	I_PaymentAdviceItemTP	PaymentAdviceAltvAccountType	Alternative Account Type
	CashDiscountPercent	I_PaymentAdviceItemTP	CashDiscountPercent	Cash Discount %
	DifferenceAmount	I_PaymentAdviceItemTP	DifferenceAmount	Amount Difference in Foreign Currency
	DiffAmtInAdditionalCurrency1	I_PaymentAdviceItemTP	DiffAmtInAdditionalCurrency1	Amount Diff. in Second Local Currency
	DiffAmtInAdditionalCurrency2	I_PaymentAdviceItemTP	DiffAmtInAdditionalCurrency2	Amount Diff. in Third Local Currency
	ItemIsActivated	I_PaymentAdviceItemTP	ItemIsActivated	Items Active
	CashDiscountIsActivated	I_PaymentAdviceItemTP	CashDiscountIsActivated	Cash Discount Activated
	IsPartialPayment	I_PaymentAdviceItemTP	IsPartialPayment	Partial Payments
	PaytDiffRsdlBalIsCarriedFwd	I_PaymentAdviceItemTP	PaytDiffRsdlBalIsCarriedFwd	Carryforward for Payment Difference
	PaymentDifferenceReason	I_PaymentAdviceItemTP	PaymentDifferenceReason	Reason Code
	PaymentDifferenceReasonName	I_PaymentAdviceItemTP	PaymentDifferenceReasonName
	PaymentDifferenceReasonDesc	I_PaymentAdviceItemTP	PaymentDifferenceReasonDesc
	Reference1IDByBusinessPartner	I_PaymentAdviceItemTP	Reference1IDByBusinessPartner	Reference Key 1
	Reference2IDByBusinessPartner	I_PaymentAdviceItemTP	Reference2IDByBusinessPartner	Reference Key 2
	DeliveryDocument	I_PaymentAdviceItemTP	DeliveryDocument	Outbound Delivery
	InvoiceDate	I_PaymentAdviceItemTP	InvoiceDate	Run On
	PurchasingDocReferenceByCust	I_PaymentAdviceItemTP	PurchasingDocReferenceByCust	Cust. Reference
	IsPostedOnAccount	I_PaymentAdviceItemTP	IsPostedOnAccount	On Account
	PaymentAdviceStatus	I_PaymentAdviceItemTP	PaymentAdviceStatus	Payment Advice Status
	DeductionAmountInPaytCurrency	I_PaymentAdviceItemTP	DeductionAmountInPaytCurrency	Deduction Amount
	PaymentReference	I_PaymentAdviceItemTP	PaymentReference	Payment Reference
	TaxCalculationProcedure	I_PaymentAdviceItemTP	TaxCalculationProcedure	Tax Procedure
	TotalCount	I_PaymentAdviceItemTP	TotalCount
	_Customer	I_PaymentAdviceItemTP	_Customer
	_CustomerCompany	I_PaymentAdviceItemTP	_CustomerCompany
	_Supplier	I_PaymentAdviceItemTP	_Supplier
	_SupplierCompany	I_PaymentAdviceItemTP	_SupplierCompany
	_CompanyCode	I_PaymentAdviceItemTP	_CompanyCode
	_CustomerForEdit	I_PaymentAdviceItemTP	_CustomerForEdit
	_CompanyCodeForEdit	I_PaymentAdviceItemTP	_CompanyCodeForEdit
	_AlternativeCompanyCode	I_PaymentAdviceItemTP	_AlternativeCompanyCode
	_BusinessArea	I_PaymentAdviceItemTP	_BusinessArea
	_Currency	I_PaymentAdviceItemTP	_Currency
	_PaymentDifferenceReason	I_PaymentAdviceItemTP	_PaymentDifferenceReason
	_TaxCode	I_PaymentAdviceItemTP	_TaxCode
	_TaxCalculationProcedure	I_PaymentAdviceItemTP	_TaxCalculationProcedure
	_BusinessPartner	I_PaymentAdviceItemTP	_BusinessPartner
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	LockboxInvoiceReference		LockboxInvoiceReference	Lockbox Invoice Reference
	CASelectionValue		CASelectionValue	Field Value
	CASelectionCategory		CASelectionCategory	Selection Cat.
	CADocumentNumber		CADocumentNumber	Document Number
	CAAssignedAmountInPaytCrcy		CAAssignedAmountInPaytCrcy	Assigned Amount
	_PaymentAdviceSubItem		_PaymentAdviceSubItem
	_PaymentAdvice		_PaymentAdvice

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 C_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.
-- SQL view name: CPAYTADVCITM

CREATE VIEW C_PaymentAdviceItem AS
SELECT
  I_PaymentAdviceItemTP.CompanyCode AS CompanyCode,
  I_PaymentAdviceItemTP.PaymentAdviceAccountType AS PaymentAdviceAccountType,
  I_PaymentAdviceItemTP.PaymentAdviceAccount AS PaymentAdviceAccount,
  I_PaymentAdviceItemTP.PaymentAdvice AS PaymentAdvice,
  I_PaymentAdviceItemTP.PaymentAdviceItem AS PaymentAdviceItem,
  I_PaymentAdviceItemTP.CompanyCodeForEdit AS CompanyCodeForEdit,
  I_PaymentAdviceItemTP.PaytAdviceAccountTypeForEdit AS PaytAdviceAccountTypeForEdit,
  I_PaymentAdviceItemTP.PaymentAdviceAccountForEdit AS PaymentAdviceAccountForEdit,
  I_PaymentAdviceItemTP.PaymentAdviceForEdit AS PaymentAdviceForEdit,
  I_PaymentAdviceItemTP.PaymentAdviceItemForEdit AS PaymentAdviceItemForEdit,
  I_PaymentAdviceItemTP.AccountingDocument AS AccountingDocument,
  I_PaymentAdviceItemTP.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  I_PaymentAdviceItemTP.NetPaymentAmountInPaytCurrency AS NetPaymentAmountInPaytCurrency,
  I_PaymentAdviceItemTP.Currency AS Currency,
  I_PaymentAdviceItemTP.AccountingDocumentItem AS AccountingDocumentItem,
  I_PaymentAdviceItemTP.AlternativeCompanyCode AS AlternativeCompanyCode,
  I_PaymentAdviceItemTP.DifferenceAmountInCoCodeCrcy AS DifferenceAmountInCoCodeCrcy,
  I_PaymentAdviceItemTP.BillingDocument AS BillingDocument,
  I_PaymentAdviceItemTP.BranchAccount AS BranchAccount,
  I_PaymentAdviceItemTP.BusinessArea AS BusinessArea,
  I_PaymentAdviceItemTP.BusinessAreaName AS BusinessAreaName,
  I_PaymentAdviceItemTP.CashDiscountAmountInPaytCrcy AS CashDiscountAmountInPaytCrcy,
  I_PaymentAdviceItemTP.CashDiscountDays AS CashDiscountDays,
  I_PaymentAdviceItemTP.PaymentAdviceAltvAccount AS PaymentAdviceAltvAccount,
  I_PaymentAdviceItemTP.DocumentReferenceID AS DocumentReferenceID,
  I_PaymentAdviceItemTP.AssignmentReference AS AssignmentReference,
  I_PaymentAdviceItemTP.PaytDifferenceReasonExtCode AS PaytDifferenceReasonExtCode,
  I_PaymentAdviceItemTP.DocumentItemText AS DocumentItemText,
  I_PaymentAdviceItemTP.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_PaymentAdviceItemTP.TaxCode AS TaxCode,
  I_PaymentAdviceItemTP.GrossAmountInPaymentCurrency AS GrossAmountInPaymentCurrency,
  I_PaymentAdviceItemTP.FiscalYear AS FiscalYear,
  I_PaymentAdviceItemTP.PaymentAdviceAltvAccountType AS PaymentAdviceAltvAccountType,
  I_PaymentAdviceItemTP.CashDiscountPercent AS CashDiscountPercent,
  I_PaymentAdviceItemTP.DifferenceAmount AS DifferenceAmount,
  I_PaymentAdviceItemTP.DiffAmtInAdditionalCurrency1 AS DiffAmtInAdditionalCurrency1,
  I_PaymentAdviceItemTP.DiffAmtInAdditionalCurrency2 AS DiffAmtInAdditionalCurrency2,
  I_PaymentAdviceItemTP.ItemIsActivated AS ItemIsActivated,
  I_PaymentAdviceItemTP.CashDiscountIsActivated AS CashDiscountIsActivated,
  I_PaymentAdviceItemTP.IsPartialPayment AS IsPartialPayment,
  I_PaymentAdviceItemTP.PaytDiffRsdlBalIsCarriedFwd AS PaytDiffRsdlBalIsCarriedFwd,
  I_PaymentAdviceItemTP.PaymentDifferenceReason AS PaymentDifferenceReason,
  I_PaymentAdviceItemTP.PaymentDifferenceReasonName AS PaymentDifferenceReasonName,
  I_PaymentAdviceItemTP.PaymentDifferenceReasonDesc AS PaymentDifferenceReasonDesc,
  I_PaymentAdviceItemTP.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  I_PaymentAdviceItemTP.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  I_PaymentAdviceItemTP.DeliveryDocument AS DeliveryDocument,
  I_PaymentAdviceItemTP.InvoiceDate AS InvoiceDate,
  I_PaymentAdviceItemTP.PurchasingDocReferenceByCust AS PurchasingDocReferenceByCust,
  I_PaymentAdviceItemTP.IsPostedOnAccount AS IsPostedOnAccount,
  I_PaymentAdviceItemTP.PaymentAdviceStatus AS PaymentAdviceStatus,
  I_PaymentAdviceItemTP.DeductionAmountInPaytCurrency AS DeductionAmountInPaytCurrency,
  I_PaymentAdviceItemTP.PaymentReference AS PaymentReference,
  I_PaymentAdviceItemTP.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_PaymentAdviceItemTP.TotalCount AS TotalCount,
  I_PaymentAdviceItemTP._Customer AS _Customer,
  I_PaymentAdviceItemTP._CustomerCompany AS _CustomerCompany,
  I_PaymentAdviceItemTP._Supplier AS _Supplier,
  I_PaymentAdviceItemTP._SupplierCompany AS _SupplierCompany,
  I_PaymentAdviceItemTP._CompanyCode AS _CompanyCode,
  I_PaymentAdviceItemTP._CustomerForEdit AS _CustomerForEdit,
  I_PaymentAdviceItemTP._CompanyCodeForEdit AS _CompanyCodeForEdit,
  I_PaymentAdviceItemTP._AlternativeCompanyCode AS _AlternativeCompanyCode,
  I_PaymentAdviceItemTP._BusinessArea AS _BusinessArea,
  I_PaymentAdviceItemTP._Currency AS _Currency,
  I_PaymentAdviceItemTP._PaymentDifferenceReason AS _PaymentDifferenceReason,
  I_PaymentAdviceItemTP._TaxCode AS _TaxCode,
  I_PaymentAdviceItemTP._TaxCalculationProcedure AS _TaxCalculationProcedure,
  I_PaymentAdviceItemTP._BusinessPartner AS _BusinessPartner,
  AdditionalCurrency1,
  AdditionalCurrency2,
  CompanyCodeCurrency,
  LockboxInvoiceReference,
  CASelectionValue,
  CASelectionCategory,
  CADocumentNumber,
  CAAssignedAmountInPaytCrcy
FROM I_PaymentAdviceItemTP
LEFT OUTER JOIN C_PaymentAdvice AS _PaymentAdvice ON CompanyCode = _PaymentAdvice.CompanyCode AND PaymentAdviceAccountType = _PaymentAdvice.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdvice.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdvice.PaymentAdvice  -- association [1..1]
LEFT OUTER JOIN C_PaymentAdviceSubItem AS _PaymentAdviceSubItem ON CompanyCode = _PaymentAdviceSubItem.CompanyCode AND PaymentAdviceAccountType = _PaymentAdviceSubItem.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdviceSubItem.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdviceSubItem.PaymentAdvice AND PaymentAdviceItem = _PaymentAdviceSubItem.PaymentAdviceItem  -- association [0..*]
;

Depth:

C_PaymentAdviceItem view

I_PaymentAdviceItemTP view