P_ARPaytReceiptPaymentDocument

DDL: P_ARPAYTRECEIPTPAYMENTDOCUMENT SQL: PARPAYTRECPTJE Type: view COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT
26 Fields 1 Data Sources

Argentina Payment document

P_ARPaytReceiptPaymentDocument is a Composite CDS View that provides data about "Argentina Payment document" in SAP S/4HANA. It reads from 1 data source (I_PaytReceiptJournalEntryVH) and exposes 26 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. Part of development package GLO_FIN_PAYMENT_RECEIPT.

Data Sources (1)

SourceAliasJoin Type
I_PaytReceiptJournalEntryVH I_PaytReceiptJournalEntryVH from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PARPAYTRECPTJE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
CompanyCodeName CompanyCodeName Company Name
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
Country Country Venue: Ctry/Reg
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
DocumentReferenceID DocumentReferenceID Reference
BusinessPlace BusinessPlace Business place
BusinessPlaceName BusinessPlaceName
DocumentDate DocumentDate Journal Entry Date
AmountInTransactionCurrency
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName AccountingDocumentTypeName
Currency Currency Valuation Crcy
AlternativeReferenceDocument AlternativeReferenceDocument Alternative Reference Document
PH_BusinessStyleOfBPText PH_BusinessStyleOfBPText
JournalEntry JournalEntry
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
IsUsedInPaymentTransaction IsUsedInPaymentTransaction Is Used In Payment Transaction
CashDiscountAmount
NetPaymentAmount
OperationalDocItemQty OperationalDocItemQty

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_ARPaytReceiptPaymentDocument.
-- 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.
-- SQL view name: PARPAYTRECPTJE

CREATE VIEW P_ARPaytReceiptPaymentDocument AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  CompanyCodeName,
  Customer,
  CustomerName,
  Country,
  Supplier,
  SupplierName,
  DocumentReferenceID,
  BusinessPlace,
  BusinessPlaceName,
  DocumentDate,
  sum(AmountInTransactionCurrency) AS AmountInTransactionCurrency,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  Currency,
  AlternativeReferenceDocument,
  PH_BusinessStyleOfBPText,
  JournalEntry,
  ClearingAccountingDocument,
  IsUsedInPaymentTransaction,
  sum(CashDiscountAmount) AS CashDiscountAmount,
  sum(NetPaymentAmount) AS NetPaymentAmount,
  OperationalDocItemQty
FROM I_PaytReceiptJournalEntryVH
;

Learn More