P_AR_SuplrPaymentPartialFull

DDL: P_AR_SUPLRPAYMENTPARTIALFULL Type: view_entity CONSUMPTION
21 Fields 3 Data Sources

P_AR_SuplrPaymentPartialFull is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_ClrgInfoRelationForAcctgDoc, I_OperationalAcctgDocItem, I_StRpJournalEntryHeaderLog) and exposes 21 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear.

Data Sources (3)

SourceAliasJoin Type
I_ClrgInfoRelationForAcctgDoc ClearingInfo inner
I_OperationalAcctgDocItem Payment inner
I_StRpJournalEntryHeaderLog StRpJournalEntryLog from

Annotations (6)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_StRpJournalEntryHeaderLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryHeaderLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryHeaderLog StatryRptRunID Report Run ID
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
KEY ReltdDocAccountingDocument
KEY RelatedDocumentItemNumber I_ClrgInfoRelationForAcctgDoc AccountingDocumentItem Posting View Item
KEY ClearingInformationIndex I_ClrgInfoRelationForAcctgDoc ClearingInformationIndex Clrg Info Seq. No.
KEY PaidItemClearingInfoIndex
RelatedDocumentFiscalYear
ReltdSpclGLTransacType ClearingSpecialGLCode SpecialGLTransactionType Transact.Type
CompanyCodeCountry
PaymentDate
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
PaytAmountInCoCodeCurrency
HouseBank I_OperationalAcctgDocItem HouseBank House Bank
PaymentGLAccount I_OperationalAcctgDocItem GLAccount General Ledger
_GLAccountInCompanyCode I_OperationalAcctgDocItem _GLAccountInCompanyCode
PaymentMethod PaymentVendorLine PaymentMethod Pymt Meth.

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_SuplrPaymentPartialFull.
-- 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_SuplrPaymentPartialFull AS
SELECT
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  Payment.CompanyCode AS CompanyCode,
  Payment.FiscalYear AS FiscalYear,
  Payment.AccountingDocument AS AccountingDocument,
  Payment.AccountingDocumentItem AS AccountingDocumentItem,
  cast( ClearingInfo.AccountingDocument as fis_belnr_rel_doc preserving type ) AS ReltdDocAccountingDocument,
  ClearingInfo.AccountingDocumentItem AS RelatedDocumentItemNumber,
  ClearingInfo.ClearingInformationIndex AS ClearingInformationIndex,
  cast( ClearingInfoPaidItem.ClearingInformationIndex as fiar_index_clr_paid preserving type ) AS PaidItemClearingInfoIndex,
  cast( ClearingInfo.FiscalYear as fis_gjahr_rel_doc preserving type ) AS RelatedDocumentFiscalYear,
  ClearingSpecialGLCode.SpecialGLTransactionType AS ReltdSpclGLTransacType,
  Payment._CompanyCode.Country AS CompanyCodeCountry,
  cast( Payment.PostingDate as farp_payment_date preserving type ) AS PaymentDate,
  Payment.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( abs( Payment.AmountInCompanyCodeCurrency) as fiar_payment_amount_cocodecrcy ) AS PaytAmountInCoCodeCurrency,
  Payment.HouseBank AS HouseBank,
  Payment.GLAccount AS PaymentGLAccount,
  Payment._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  PaymentVendorLine.PaymentMethod AS PaymentMethod
FROM I_StRpJournalEntryHeaderLog AS StRpJournalEntryLog
INNER JOIN I_OperationalAcctgDocItem AS Payment ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClrgInfoRelationForAcctgDoc AS ClearingInfo ON /* join condition not captured in parsed metadata */
;

Learn More