R_PaymentAdviceItemTP

DDL: R_PAYMENTADVICEITEMTP Type: view_entity TRANSACTIONAL Package: RAP_FIN_OPS_PAYMT_ADVICE_API
70 Fields 1 Data Sources 7 Associations

Payment Advice Item

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

Data Sources (1)

SourceAliasJoin Type
I_PaymentAdviceItem I_PaymentAdviceItem from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.PaymentAdviceAccount = _Customer.Customer
[1..1] I_CustomerCompany _CustomerCompany $projection.PaymentAdviceAccount = _CustomerCompany.Customer and $projection.CompanyCode = _CustomerCompany.CompanyCode
[0..1] I_Supplier _Supplier $projection.PaymentAdviceAccount = _Supplier.Supplier
[1..1] I_SupplierCompany _SupplierCompany $projection.PaymentAdviceAccount = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode
[1..1] I_PaymentAdviceStatus _PaymentAdviceStatus $projection.PaymentAdviceStatus = _PaymentAdviceStatus.PaymentAdviceStatus
[1..1] I_CASelectionCategory _CASelectionCategory $projection.CASelectionCategory = _CASelectionCategory.CASelectionCategory
[1..1] I_PaytAdviceAccountTypeStdVH _PaytAdviceAccountType $projection.PaymentAdviceAltvAccountType = _PaytAdviceAccountType.PaymentAdviceAccountType

Annotations (8)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Payment Advice Item view

Fields (70)

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
PaymentAdviceItemForEdit PaymentAdviceItem Payt Adv. Item
PaymentAdviceAltvAccount PaymentAdviceAltvAccount Altern. Account
AlternativeCompanyCode AlternativeCompanyCode Alternative Company Code
AccountingDocument Journal Entry
DocumentReferenceID DocumentReferenceID Reference
BillingDocument BillingDocument SD Document
BranchAccount BranchAccount Branch Account No.
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
CADocumentNumber CADocumentNumber Document Number
CASelectionCategory CASelectionCategory Selection Cat.
CASelectionValue CASelectionValue Field Value
CAAssignedAmountInPaytCrcy CAAssignedAmountInPaytCrcy Assigned Amount
LockboxInvoiceReference LockboxInvoiceReference Lockbox Invoice Reference
_PaymentAdviceTP _PaymentAdviceTP
_Customer _Customer
_CustomerCompany _CustomerCompany
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_BusinessPartner _BusinessPartner
_BusinessArea _BusinessArea
_PaymentAdviceStatus _PaymentAdviceStatus
_CASelectionCategory _CASelectionCategory
_PaytAdviceAccountType _PaytAdviceAccountType
_CompanyCode _CompanyCode
_PaymentDifferenceReason _PaymentDifferenceReason

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 R_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.

CREATE VIEW R_PaymentAdviceItemTP AS
SELECT
  CompanyCode,
  PaymentAdviceAccountType,
  PaymentAdviceAccount,
  PaymentAdvice,
  PaymentAdviceItem,
  PaymentAdviceItem AS PaymentAdviceItemForEdit,
  PaymentAdviceAltvAccount,
  AlternativeCompanyCode,
  cast(AccountingDocument as farp_pa_belnr_d) AS AccountingDocument,
  DocumentReferenceID,
  BillingDocument,
  BranchAccount,
  cast (AccountingDocumentCreationDate as farp_pa_cpudt preserving type ) AS 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,
  CADocumentNumber,
  CASelectionCategory,
  CASelectionValue,
  CAAssignedAmountInPaytCrcy,
  LockboxInvoiceReference
FROM I_PaymentAdviceItem
LEFT OUTER JOIN I_Customer AS _Customer ON PaymentAdviceAccount = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON PaymentAdviceAccount = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON PaymentAdviceAccount = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON PaymentAdviceAccount = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PaymentAdviceStatus AS _PaymentAdviceStatus ON PaymentAdviceStatus = _PaymentAdviceStatus.PaymentAdviceStatus  -- association [1..1]
LEFT OUTER JOIN I_CASelectionCategory AS _CASelectionCategory ON CASelectionCategory = _CASelectionCategory.CASelectionCategory  -- association [1..1]
LEFT OUTER JOIN I_PaytAdviceAccountTypeStdVH AS _PaytAdviceAccountType ON PaymentAdviceAltvAccountType = _PaytAdviceAccountType.PaymentAdviceAccountType  -- association [1..1]
;

Learn More