What is I_PaymentAdviceItemTP in SAP S/4HANA?

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

Which tables does I_PaymentAdviceItemTP read from?

I_PaymentAdviceItemTP reads data from: P_PaymentAdviceItem.

What VDM layer is I_PaymentAdviceItemTP?

I_PaymentAdviceItemTP is classified as a Transactional view that supports create, update, and delete operations.

I_PaymentAdviceItemTP

DDL: I_PAYMENTADVICEITEMTP SQL: IPAYTADVCITMTP Type: view TRANSACTIONAL Package: ODATA_PAYMENTADVICES

79 Fields 1 Data Sources 4 Associations

Payment Advice Item

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

Data Sources (1)

Source	Alias	Join Type
P_PaymentAdviceItem	P_PaymentAdviceItem	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_PaymentAdviceTP	_PaymentAdvice	`$projection.CompanyCode = _PaymentAdvice.CompanyCode and $projection.PaymentAdviceAccountType = _PaymentAdvice.PaymentAdviceAccountType and $projection.PaymentAdviceAccount = _PaymentAdvice.PaymentAdviceAccount and $projection.PaymentAdvice = _PaymentAdvice.PaymentAdvice`
[0..*]	I_PaymentAdviceSubItemTP	_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`
[1..1]	I_CompanyCode	_CompanyCodeForEdit	`$projection.CompanyCodeForEdit = _CompanyCodeForEdit.CompanyCode`
[1..1]	I_Customer	_CustomerForEdit	`$projection.PaymentAdviceAccountForEdit = _CustomerForEdit.Customer`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	IPAYTADVCITMTP	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.writeDraftPersistence	AVIP_DRAFT	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
EndUserText.label	Payment Advice Item	view

Fields (79)

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

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 I_PaymentAdviceItemTP.
-- 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: IPAYTADVCITMTP

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

Depth:

I_PaymentAdviceItemTP view

P_PaymentAdviceItem view

C_PaymentAdviceItem view