P_AR_SuplrPaymentPartialFull2

DDL: P_AR_SUPLRPAYMENTPARTIALFULL2 Type: view_entity CONSUMPTION Package: GLO_FIN_IS_AR_SUPPLIER_PAYMENT
17 Fields 2 Data Sources

Argentina Supplier Payment Full and Partial Payment 2

P_AR_SuplrPaymentPartialFull2 is a Consumption CDS View that provides data about "Argentina Supplier Payment Full and Partial Payment 2" in SAP S/4HANA. It reads from 2 data sources (P_AR_SuplrPaymentPartialFull, I_OperationalAcctgDocItem) and exposes 17 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_AR_SUPPLIER_PAYMENT.

Data Sources (2)

SourceAliasJoin Type
P_AR_SuplrPaymentPartialFull PaymentItem from
I_OperationalAcctgDocItem RelatedItem inner

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 (17)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity P_AR_SuplrPaymentPartialFull StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_AR_SuplrPaymentPartialFull StatryRptCategory Report ID
KEY StatryRptRunID P_AR_SuplrPaymentPartialFull StatryRptRunID Report Run ID
KEY CompanyCode P_AR_SuplrPaymentPartialFull CompanyCode Receiver Company Code
KEY FiscalYear P_AR_SuplrPaymentPartialFull FiscalYear G/L Fiscal Year
KEY AccountingDocument P_AR_SuplrPaymentPartialFull AccountingDocument Journal Entry
KEY AccountingDocumentItem P_AR_SuplrPaymentPartialFull AccountingDocumentItem Posting View Item
KEY ClearingInformationIndex P_AR_SuplrPaymentPartialFull ClearingInformationIndex
KEY PaidItemClearingInfoIndex P_AR_SuplrPaymentPartialFull PaidItemClearingInfoIndex
PaymentDate P_AR_SuplrPaymentPartialFull PaymentDate Payment Date
CompanyCodeCountry P_AR_SuplrPaymentPartialFull CompanyCodeCountry Reporting Ctry/Reg.
CompanyCodeCurrency P_AR_SuplrPaymentPartialFull CompanyCodeCurrency Local Currency
PaytAmountInCoCodeCurrency P_AR_SuplrPaymentPartialFull PaytAmountInCoCodeCurrency
ReltdSpclGLTransacType P_AR_SuplrPaymentPartialFull ReltdSpclGLTransacType Transact.Type
HouseBank P_AR_SuplrPaymentPartialFull HouseBank House Bank
PaymentGLAccount P_AR_SuplrPaymentPartialFull PaymentGLAccount General Ledger
_GLAccountInCompanyCode P_AR_SuplrPaymentPartialFull _GLAccountInCompanyCode

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_SuplrPaymentPartialFull2.
-- 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_SuplrPaymentPartialFull2 AS
SELECT
  PaymentItem.StatryRptgEntity AS StatryRptgEntity,
  PaymentItem.StatryRptCategory AS StatryRptCategory,
  PaymentItem.StatryRptRunID AS StatryRptRunID,
  PaymentItem.CompanyCode AS CompanyCode,
  PaymentItem.FiscalYear AS FiscalYear,
  PaymentItem.AccountingDocument AS AccountingDocument,
  PaymentItem.AccountingDocumentItem AS AccountingDocumentItem,
  PaymentItem.ClearingInformationIndex AS ClearingInformationIndex,
  PaymentItem.PaidItemClearingInfoIndex AS PaidItemClearingInfoIndex,
  PaymentItem.PaymentDate AS PaymentDate,
  PaymentItem.CompanyCodeCountry AS CompanyCodeCountry,
  PaymentItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  PaymentItem.PaytAmountInCoCodeCurrency AS PaytAmountInCoCodeCurrency,
  PaymentItem.ReltdSpclGLTransacType AS ReltdSpclGLTransacType,
  PaymentItem.HouseBank AS HouseBank,
  PaymentItem.PaymentGLAccount AS PaymentGLAccount,
  PaymentItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode
FROM P_AR_SuplrPaymentPartialFull AS PaymentItem
INNER JOIN I_OperationalAcctgDocItem AS RelatedItem ON /* join condition not captured in parsed metadata */
;

Learn More