A_PaymentAdviceItem_2

DDL: A_PAYMENTADVICEITEM_2 Type: view_entity COMPOSITE
57 Fields 1 Data Sources 5 Associations

Payment Advice Item

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

Data Sources (1)

SourceAliasJoin Type
R_PaymentAdviceItemTP R_PaymentAdviceItemTP projection

Associations (5)

CardinalityTargetAliasCondition
[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
[0..1] A_BusinessPartner _BusinessPartner $projection.PaymentAdviceAccount = _BusinessPartner.BusinessPartner and $projection.PaymentAdviceAccountType = 'G'

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Payment Advice Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
OData.entitySet.name PaymentAdviceItem view
OData.entityType.name PaymentAdviceItem_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view

Fields (57)

KeyFieldSource TableSource FieldDescription
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
_BusinessPartner _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 A_PaymentAdviceItem_2.
-- 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_2 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 R_PaymentAdviceItemTP
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]
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartner ON PaymentAdviceAccount = _BusinessPartner.BusinessPartner AND PaymentAdviceAccountType = 'G'  -- association [0..1]
;

Learn More