P_AR_SupplierPaymentDetail

DDL: P_AR_SUPPLIERPAYMENTDETAIL Type: view_entity CONSUMPTION
26 Fields 2 Data Sources

P_AR_SupplierPaymentDetail is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_AR_JournalEntry, P_AR_SupplierPaymentBPDetail) and exposes 26 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
P_AR_JournalEntry JournalEntry inner
P_AR_SupplierPaymentBPDetail Payment from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity P_AR_SupplierPaymentBPDetail StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_AR_SupplierPaymentBPDetail StatryRptCategory Report ID
KEY StatryRptRunID P_AR_SupplierPaymentBPDetail StatryRptRunID Report Run ID
KEY CompanyCode P_AR_SupplierPaymentBPDetail CompanyCode Receiver Company Code
KEY FiscalYear P_AR_SupplierPaymentBPDetail FiscalYear G/L Fiscal Year
KEY AccountingDocument P_AR_SupplierPaymentBPDetail AccountingDocument Journal Entry
KEY AccountingDocumentItem P_AR_SupplierPaymentBPDetail AccountingDocumentItem Posting View Item
KEY ClearingInformationIndex P_AR_SupplierPaymentBPDetail ClearingInformationIndex
KEY PaidItemClearingInfoIndex P_AR_SupplierPaymentBPDetail PaidItemClearingInfoIndex
KEY ReltdDocAccountingDocument P_AR_SupplierPaymentBPDetail ReltdDocAccountingDocument
KEY RelatedDocumentItemNumber P_AR_SupplierPaymentBPDetail RelatedDocumentItemNumber
PaymentDate P_AR_SupplierPaymentBPDetail PaymentDate Payment Date
CompanyCodeCountry P_AR_SupplierPaymentBPDetail CompanyCodeCountry Reporting Ctry/Reg.
PaymentDateendasDaysBetweenPayment
Supplier P_AR_SupplierPaymentBPDetail Supplier Supplier
BusinessPartnerName P_AR_SupplierPaymentBPDetail BusinessPartnerName Extracted Customer Name
RelatedDocumentFiscalYear P_AR_SupplierPaymentBPDetail RelatedDocumentFiscalYear
AR_PrintCharacter P_AR_JournalEntry AR_PrintCharacter
ReltdSpclGLTransacType P_AR_SupplierPaymentBPDetail ReltdSpclGLTransacType
AccountingDocumentType P_AR_JournalEntry AccountingDocumentType Journal Entry Type
AlternativeCurrencyKey AltvCurrency AlternativeCurrencyKey
ReltdDocTransactionCurrency P_AR_SupplierPaymentBPDetail ReltdDocTransactionCurrency
ReltdDocAmtInTransCurrency P_AR_SupplierPaymentBPDetail ReltdDocAmtInTransCurrency
CheckIssuerTaxNumber P_AR_SupplierPaymentBPDetail CheckIssuerTaxNumber
EndorsedBankTaxNumber P_AR_SupplierPaymentBPDetail EndorsedBankTaxNumber
EndorsedCheckNumber P_AR_SupplierPaymentBPDetail EndorsedCheckNumber

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 P_AR_SupplierPaymentDetail.
-- 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 P_AR_SupplierPaymentDetail AS
SELECT
  Payment.StatryRptgEntity AS StatryRptgEntity,
  Payment.StatryRptCategory AS StatryRptCategory,
  Payment.StatryRptRunID AS StatryRptRunID,
  Payment.CompanyCode AS CompanyCode,
  Payment.FiscalYear AS FiscalYear,
  Payment.AccountingDocument AS AccountingDocument,
  Payment.AccountingDocumentItem AS AccountingDocumentItem,
  Payment.ClearingInformationIndex AS ClearingInformationIndex,
  Payment.PaidItemClearingInfoIndex AS PaidItemClearingInfoIndex,
  Payment.ReltdDocAccountingDocument AS ReltdDocAccountingDocument,
  Payment.RelatedDocumentItemNumber AS RelatedDocumentItemNumber,
  Payment.PaymentDate AS PaymentDate,
  Payment.CompanyCodeCountry AS CompanyCodeCountry,
  case when Payment.PaymentDate <> '00000000' then dats_days_between(JournalEntry.PostingDate,Payment.PaymentDate) end as DaysBetweenPayment AS PaymentDateendasDaysBetweenPayment,
  Payment.Supplier AS Supplier,
  Payment.BusinessPartnerName AS BusinessPartnerName,
  Payment.RelatedDocumentFiscalYear AS RelatedDocumentFiscalYear,
  JournalEntry.AR_PrintCharacter AS AR_PrintCharacter,
  Payment.ReltdSpclGLTransacType AS ReltdSpclGLTransacType,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  AltvCurrency.AlternativeCurrencyKey AS AlternativeCurrencyKey,
  Payment.ReltdDocTransactionCurrency AS ReltdDocTransactionCurrency,
  Payment.ReltdDocAmtInTransCurrency AS ReltdDocAmtInTransCurrency,
  Payment.CheckIssuerTaxNumber AS CheckIssuerTaxNumber,
  Payment.EndorsedBankTaxNumber AS EndorsedBankTaxNumber,
  Payment.EndorsedCheckNumber AS EndorsedCheckNumber
FROM P_AR_SupplierPaymentBPDetail AS Payment
INNER JOIN P_AR_JournalEntry AS JournalEntry ON /* join condition not captured in parsed metadata */
;

Learn More