What is C_PaymentAdvice in SAP S/4HANA?

C_PaymentAdvice is a consumption CDS view in SAP S/4HANA. Payment Advice Header It contains 69 fields.

Which tables does C_PaymentAdvice read from?

C_PaymentAdvice reads data from: I_PaymentAdviceTP.

What VDM layer is C_PaymentAdvice?

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

C_PaymentAdvice

DDL: C_PAYMENTADVICE SQL: CPAYTADVC Type: view CONSUMPTION

69 Fields 1 Data Sources 2 Associations

Payment Advice Header

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

Data Sources (1)

Source	Alias	Join Type
I_PaymentAdviceTP	I_PaymentAdviceTP	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	C_PaymentAdviceItem	_PaymentAdviceItem	`$projection.CompanyCode = _PaymentAdviceItem.CompanyCode and $projection.PaymentAdviceAccountType = _PaymentAdviceItem.PaymentAdviceAccountType and $projection.PaymentAdviceAccount = _PaymentAdviceItem.PaymentAdviceAccount and $projection.PaymentAdvice = _PaymentAdviceItem.PaymentAdvice`
[1..1]	I_PaymentAdviceUserVH	_UserVH	`$projection.CompanyCode = _UserVH.CompanyCode and $projection.PaymentAdviceAccountType = _UserVH.PaymentAdviceAccountType and $projection.PaymentAdviceAccount = _UserVH.PaymentAdviceAccount and $projection.PaymentAdvice = _UserVH.PaymentAdvice`

Annotations (24)

Name	Value	Level
AbapCatalog.sqlViewName	CPAYTADVC	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Payment Advice Header	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
Search.searchable	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.compositionRoot	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.draftEnabled	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
Consumption.semanticObject	PaymentAdvice	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
UI.headerInfo.typeName	Payment Advice	view
UI.headerInfo.typeNamePlural	Payment Advices	view
UI.headerInfo.title.label	Payment Advice	view
UI.headerInfo.title.value	PaymentAdviceForEdit	view
UI.presentationVariant.sortOrder.by	PaymentAdviceForEdit	view
UI.presentationVariant.sortOrder.direction	#ASC	view

Fields (69)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_PaymentAdviceTP	CompanyCode	Receiver Company Code
KEY	PaymentAdviceAccountType	I_PaymentAdviceTP	PaymentAdviceAccountType	Account Type
KEY	PaymentAdviceAccount	I_PaymentAdviceTP	PaymentAdviceAccount	Account
KEY	PaymentAdvice	I_PaymentAdviceTP	PaymentAdvice	Payment Advice Number
	CompanyCodeForEdit	I_PaymentAdviceTP	CompanyCodeForEdit	Company Code
	PaytAdviceAccountTypeForEdit	I_PaymentAdviceTP	PaytAdviceAccountTypeForEdit	Subledger
	PaymentAdviceAccountForEdit	I_PaymentAdviceTP	PaymentAdviceAccountForEdit	Account
	PaymentAdviceForEdit	I_PaymentAdviceTP	PaymentAdviceForEdit	Payment Advice Number
	PaidAmountInPaytCurrency	I_PaymentAdviceTP	PaidAmountInPaytCurrency	Payment Amount
	PaymentCurrency	I_PaymentAdviceTP	PaymentCurrency	Payment Currency
	CashDiscountAmountInPaytCrcy	I_PaymentAdviceTP	CashDiscountAmountInPaytCrcy	Cash Discount Amount
	PaymentDocument	I_PaymentAdviceTP	PaymentDocument	Payment Document Number
	PaymentDate	I_PaymentAdviceTP	PaymentDate	Payment Date
	PaytAdvcDiffDeterminationRule	I_PaymentAdviceTP	PaytAdvcDiffDeterminationRule	Reason Code Conversion
	PaytAdvcDiffDetnRuleDesc	I_PaymentAdviceTP	PaytAdvcDiffDetnRuleDesc
	PaymentAdviceSelectionRule	I_PaymentAdviceTP	PaymentAdviceSelectionRule	Selection Rule
	PaytAdviceSelectionRuleDesc	I_PaymentAdviceTP	PaytAdviceSelectionRuleDesc
	AccountByShipper	I_PaymentAdviceTP	AccountByShipper	Payee's Account at the Customer
	PaymentAdviceHeaderText	I_PaymentAdviceTP	PaymentAdviceHeaderText	Payment Advice Header Text
	PaymentAdviceType	I_PaymentAdviceTP	PaymentAdviceType	Payt Adv. Type
	PaymentAdviceTypeName	I_PaymentAdviceTP	PaymentAdviceTypeName
	CustomerName	I_PaymentAdviceTP	CustomerName	Name of Customer
	AccountingClerk	I_PaymentAdviceTP	AccountingClerk	Clerk Abbrev.
	AccountingClerkName	I_PaymentAdviceTP	AccountingClerkName
	Customer	I_PaymentAdviceTP	Customer	Sold-to Party
	OrganizationBPName1	I_PaymentAdviceTP	OrganizationBPName1	Name 1
	OrganizationBPName2	I_PaymentAdviceTP	OrganizationBPName2	Name 2
	CreationDate	I_PaymentAdviceTP	CreationDate	Time Stamp
	CreatedByUser	I_PaymentAdviceTP	CreatedByUser	User Name
	FullName	I_PaymentAdviceTP	FullName	Name
	LastChangeDate	I_PaymentAdviceTP	LastChangeDate	Time Stamp
	LastChangedByUser	I_PaymentAdviceTP	LastChangedByUser	User Name
	CreationTime	I_PaymentAdviceTP	CreationTime	Time of Change
	CreationDateTime	I_PaymentAdviceTP	CreationDateTime	Created On
	PaymentAdviceIsHeld	I_PaymentAdviceTP	PaymentAdviceIsHeld	Hold Payt Adv.
	PaymentAdviceStatus	I_PaymentAdviceTP	PaymentAdviceStatus	Payment Advice Status
	UxFcPaymentAdviceAccount	I_PaymentAdviceTP	UxFcPaymentAdviceAccount
	PaymentAdviceIsExtracted	I_PaymentAdviceTP	PaymentAdviceIsExtracted	Is Processed?
	PaytAdviceExtractorConfidence	I_PaymentAdviceTP	PaytAdviceExtractorConfidence
	PaytAdviceTotalNumberOfPages	I_PaymentAdviceTP	PaytAdviceTotalNumberOfPages	Total Pages
	PaymentAdviceExtractorUUID	I_PaymentAdviceTP	PaymentAdviceExtractorUUID
	PaymentAdviceUUID	I_PaymentAdviceTP	PaymentAdviceUUID
	PaymentAdviceExtractionStatus	I_PaymentAdviceTP	PaymentAdviceExtractionStatus
	PaymentAdviceExtractorType		PaymentAdviceExtractorType	Extractor Type
	CompanyCodeName		CompanyCodeName	Company Name
	PaymentAdviceItemTotalAmount		PaymentAdviceItemTotalAmount
	BankReference		BankReference	Payment Reference
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	PaymentAdviceSubledgerText
	CAPaymentDocument		CAPaymentDocument	Usage Doc.
	ContractAccount		ContractAccount	Contract Acct
	CAPaymentAdvice		CAPaymentAdvice	Payment Advice Note
	BusinessPartner		BusinessPartner	Issuing Authority
	Supplier		Supplier	Supplier
	_PaymentAdviceItem		_PaymentAdviceItem
	_UserVH		_UserVH
	_CompanyCode	I_PaymentAdviceTP	_CompanyCode
	_CompanyCodeForEdit	I_PaymentAdviceTP	_CompanyCodeForEdit
	_Currency	I_PaymentAdviceTP	_Currency
	_Customer	I_PaymentAdviceTP	_Customer
	_CustomerCompany	I_PaymentAdviceTP	_CustomerCompany
	_Supplier	I_PaymentAdviceTP	_Supplier
	_SupplierCompany	I_PaymentAdviceTP	_SupplierCompany
	_CustomerForEdit	I_PaymentAdviceTP	_CustomerForEdit
	_PaymentAdviceType	I_PaymentAdviceTP	_PaymentAdviceType
	_PaytAdviceSelRules	I_PaymentAdviceTP	_PaytAdviceSelRules
	_PaytAdvcDiffDeterminationRule	I_PaymentAdviceTP	_PaytAdvcDiffDeterminationRule
	_UserContactCard	I_PaymentAdviceTP	_UserContactCard
	_BusinessPartner	I_PaymentAdviceTP	_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 C_PaymentAdvice.
-- 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: CPAYTADVC

CREATE VIEW C_PaymentAdvice AS
SELECT
  I_PaymentAdviceTP.CompanyCode AS CompanyCode,
  I_PaymentAdviceTP.PaymentAdviceAccountType AS PaymentAdviceAccountType,
  I_PaymentAdviceTP.PaymentAdviceAccount AS PaymentAdviceAccount,
  I_PaymentAdviceTP.PaymentAdvice AS PaymentAdvice,
  I_PaymentAdviceTP.CompanyCodeForEdit AS CompanyCodeForEdit,
  I_PaymentAdviceTP.PaytAdviceAccountTypeForEdit AS PaytAdviceAccountTypeForEdit,
  I_PaymentAdviceTP.PaymentAdviceAccountForEdit AS PaymentAdviceAccountForEdit,
  I_PaymentAdviceTP.PaymentAdviceForEdit AS PaymentAdviceForEdit,
  I_PaymentAdviceTP.PaidAmountInPaytCurrency AS PaidAmountInPaytCurrency,
  I_PaymentAdviceTP.PaymentCurrency AS PaymentCurrency,
  I_PaymentAdviceTP.CashDiscountAmountInPaytCrcy AS CashDiscountAmountInPaytCrcy,
  I_PaymentAdviceTP.PaymentDocument AS PaymentDocument,
  I_PaymentAdviceTP.PaymentDate AS PaymentDate,
  I_PaymentAdviceTP.PaytAdvcDiffDeterminationRule AS PaytAdvcDiffDeterminationRule,
  I_PaymentAdviceTP.PaytAdvcDiffDetnRuleDesc AS PaytAdvcDiffDetnRuleDesc,
  I_PaymentAdviceTP.PaymentAdviceSelectionRule AS PaymentAdviceSelectionRule,
  I_PaymentAdviceTP.PaytAdviceSelectionRuleDesc AS PaytAdviceSelectionRuleDesc,
  I_PaymentAdviceTP.AccountByShipper AS AccountByShipper,
  I_PaymentAdviceTP.PaymentAdviceHeaderText AS PaymentAdviceHeaderText,
  I_PaymentAdviceTP.PaymentAdviceType AS PaymentAdviceType,
  I_PaymentAdviceTP.PaymentAdviceTypeName AS PaymentAdviceTypeName,
  I_PaymentAdviceTP.CustomerName AS CustomerName,
  I_PaymentAdviceTP.AccountingClerk AS AccountingClerk,
  I_PaymentAdviceTP.AccountingClerkName AS AccountingClerkName,
  I_PaymentAdviceTP.Customer AS Customer,
  I_PaymentAdviceTP.OrganizationBPName1 AS OrganizationBPName1,
  I_PaymentAdviceTP.OrganizationBPName2 AS OrganizationBPName2,
  I_PaymentAdviceTP.CreationDate AS CreationDate,
  I_PaymentAdviceTP.CreatedByUser AS CreatedByUser,
  I_PaymentAdviceTP.FullName AS FullName,
  I_PaymentAdviceTP.LastChangeDate AS LastChangeDate,
  I_PaymentAdviceTP.LastChangedByUser AS LastChangedByUser,
  I_PaymentAdviceTP.CreationTime AS CreationTime,
  I_PaymentAdviceTP.CreationDateTime AS CreationDateTime,
  I_PaymentAdviceTP.PaymentAdviceIsHeld AS PaymentAdviceIsHeld,
  I_PaymentAdviceTP.PaymentAdviceStatus AS PaymentAdviceStatus,
  I_PaymentAdviceTP.UxFcPaymentAdviceAccount AS UxFcPaymentAdviceAccount,
  I_PaymentAdviceTP.PaymentAdviceIsExtracted AS PaymentAdviceIsExtracted,
  I_PaymentAdviceTP.PaytAdviceExtractorConfidence AS PaytAdviceExtractorConfidence,
  I_PaymentAdviceTP.PaytAdviceTotalNumberOfPages AS PaytAdviceTotalNumberOfPages,
  I_PaymentAdviceTP.PaymentAdviceExtractorUUID AS PaymentAdviceExtractorUUID,
  I_PaymentAdviceTP.PaymentAdviceUUID AS PaymentAdviceUUID,
  I_PaymentAdviceTP.PaymentAdviceExtractionStatus AS PaymentAdviceExtractionStatus,
  PaymentAdviceExtractorType,
  CompanyCodeName,
  PaymentAdviceItemTotalAmount,
  BankReference,
  BusinessPartnerName,
  _PaymentAdviceSubledger._Text[ 1:Language = $session.system_language ].PaymentAdviceSubledgerText AS PaymentAdviceSubledgerText,
  CAPaymentDocument,
  ContractAccount,
  CAPaymentAdvice,
  BusinessPartner,
  Supplier,
  I_PaymentAdviceTP._CompanyCode AS _CompanyCode,
  I_PaymentAdviceTP._CompanyCodeForEdit AS _CompanyCodeForEdit,
  I_PaymentAdviceTP._Currency AS _Currency,
  I_PaymentAdviceTP._Customer AS _Customer,
  I_PaymentAdviceTP._CustomerCompany AS _CustomerCompany,
  I_PaymentAdviceTP._Supplier AS _Supplier,
  I_PaymentAdviceTP._SupplierCompany AS _SupplierCompany,
  I_PaymentAdviceTP._CustomerForEdit AS _CustomerForEdit,
  I_PaymentAdviceTP._PaymentAdviceType AS _PaymentAdviceType,
  I_PaymentAdviceTP._PaytAdviceSelRules AS _PaytAdviceSelRules,
  I_PaymentAdviceTP._PaytAdvcDiffDeterminationRule AS _PaytAdvcDiffDeterminationRule,
  I_PaymentAdviceTP._UserContactCard AS _UserContactCard,
  I_PaymentAdviceTP._BusinessPartner AS _BusinessPartner
FROM I_PaymentAdviceTP
LEFT OUTER JOIN C_PaymentAdviceItem AS _PaymentAdviceItem ON CompanyCode = _PaymentAdviceItem.CompanyCode AND PaymentAdviceAccountType = _PaymentAdviceItem.PaymentAdviceAccountType AND PaymentAdviceAccount = _PaymentAdviceItem.PaymentAdviceAccount AND PaymentAdvice = _PaymentAdviceItem.PaymentAdvice  -- association [0..*]
LEFT OUTER JOIN I_PaymentAdviceUserVH AS _UserVH ON CompanyCode = _UserVH.CompanyCode AND PaymentAdviceAccountType = _UserVH.PaymentAdviceAccountType AND PaymentAdviceAccount = _UserVH.PaymentAdviceAccount AND PaymentAdvice = _UserVH.PaymentAdvice  -- association [1..1]
;

Depth:

C_PaymentAdvice view

I_PaymentAdviceTP view