C_PaymentAdviceItem_2
Payment Advice Item
C_PaymentAdviceItem_2 is a Consumption CDS View that provides data about "Payment Advice Item" in SAP S/4HANA. It reads from 1 data source (R_PaymentAdviceItemTP) and exposes 72 fields with key fields CompanyCode, PaymentAdviceAccountType, PaymentAdviceAccount, PaymentAdvice, PaymentAdviceItem. It is exposed through 2 OData services (ASQL_F2550A, UI_PAYMENTADVICE). Part of development package RAP_FIN_OPS_PAYMT_ADVICE_UI.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_PaymentAdviceItemTP | R_PaymentAdviceItemTP | projection |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Payment Advice Item | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Metadata.allowExtensions | true | view |
OData Services (2)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| ASQL_F2550A | ASQL_F2550A | C2 | NOT_RELEASED | |
| UI_PAYMENTADVICE | UI_PAYMENTADVICE | V4 | C1 | NOT_RELEASED |
Fields (72)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 | PaymentAdviceItemForEdit | Payt Adv. Item | ||
| PaymentAdviceAltvAccount | PaymentAdviceAltvAccount | Altern. Account | ||
| CustomerName | _Customer | CustomerName | Name of Customer | |
| AlternativeCompanyCode | AlternativeCompanyCode | Alternative Company Code | ||
| CompanyCodeName | _CompanyCode | CompanyCodeName | Company Name | |
| 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 | ||
| BusinessAreaName | ||||
| 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 | ||
| PaymentAdviceAccountTypeName | Alternative Account Type Description | |||
| 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 | ||
| PaymentDifferenceReasonName | Reason Code Description | |||
| 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 | ||
| PaymentAdviceStatusName | ||||
| 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. | ||
| CASelectionCategoryName | Selection Category Name | |||
| CASelectionValue | CASelectionValue | Field Value | ||
| CAAssignedAmountInPaytCrcy | CAAssignedAmountInPaytCrcy | Assigned Amount | ||
| LockboxInvoiceReference | LockboxInvoiceReference | Lockbox Invoice Reference | ||
| virtualPaytAdvcItmProcessStsCritltyint1 | ||||
| virtualClearingJournalEntryaugbl | ||||
| _BusinessPartner | _BusinessPartner | |||
| _Customer | _Customer | |||
| _CustomerCompany | _CustomerCompany | |||
| _Supplier | _Supplier | |||
| _SupplierCompany | _SupplierCompany |
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_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 C_PaymentAdviceItem_2 AS
SELECT
CompanyCode,
PaymentAdviceAccountType,
PaymentAdviceAccount,
PaymentAdvice,
PaymentAdviceItem,
PaymentAdviceItemForEdit,
PaymentAdviceAltvAccount,
_Customer.CustomerName AS CustomerName,
AlternativeCompanyCode,
_CompanyCode.CompanyCodeName AS CompanyCodeName,
AccountingDocument,
DocumentReferenceID,
BillingDocument,
BranchAccount,
AccountingDocumentCreationDate,
BusinessArea,
_BusinessArea._Text[1:Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
AssignmentReference,
PaytDifferenceReasonExtCode,
DocumentItemText,
TaxAmountInCoCodeCrcy,
TaxCode,
GrossAmountInPaymentCurrency,
NetPaymentAmountInPaytCurrency,
CashDiscountAmountInPaytCrcy,
FiscalYear,
AccountingDocumentItem,
PaymentAdviceAltvAccountType,
_PaytAdviceAccountType._Text[1:Language=$session.system_language].PaymentAdviceAccountTypeName AS PaymentAdviceAccountTypeName,
CashDiscountPercent,
CashDiscountDays,
DifferenceAmountInCoCodeCrcy,
DifferenceAmount,
DiffAmtInAdditionalCurrency1,
DiffAmtInAdditionalCurrency2,
ItemIsActivated,
CashDiscountIsActivated,
IsPartialPayment,
PaytDiffRsdlBalIsCarriedFwd,
PaymentDifferenceReason,
_PaymentDifferenceReason._Text[1:Language=$session.system_language].PaymentDifferenceReasonName AS PaymentDifferenceReasonName,
Currency,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
DeliveryDocument,
InvoiceDate,
PurchasingDocReferenceByCust,
IsPostedOnAccount,
PaymentAdviceStatus,
_PaymentAdviceStatus._Text[1:Language=$session.system_language].PaymentAdviceStatusName AS PaymentAdviceStatusName,
DeductionAmountInPaytCurrency,
PaymentReference,
PaymentAdviceSelectionField,
PaymentAdviceSelectionValue,
PaytAdvcExternalSelectionField,
TaxCalculationProcedure,
AdditionalCurrency1,
AdditionalCurrency2,
CompanyCodeCurrency,
CADocumentNumber,
CASelectionCategory,
_CASelectionCategory._Text[1:Language =$session.system_language].CASelectionCategoryName AS CASelectionCategoryName,
CASelectionValue,
CAAssignedAmountInPaytCrcy,
LockboxInvoiceReference,
virtual PaytAdvcItmProcessStsCritlty : int1 AS virtualPaytAdvcItmProcessStsCritltyint1,
virtual ClearingJournalEntry : augbl AS virtualClearingJournalEntryaugbl
FROM R_PaymentAdviceItemTP
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA