P_TH_PaytRcptJournalEntry

DDL: P_TH_PAYTRCPTJOURNALENTRY Type: view_entity COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT
25 Fields 2 Data Sources

Payment Receipt Journal Entry for Thailand

P_TH_PaytRcptJournalEntry is a Composite CDS View that provides data about "Payment Receipt Journal Entry for Thailand" in SAP S/4HANA. It reads from 2 data sources (I_PaymentReceiptType, P_TH_PaytRcptJournalEntry1) and exposes 25 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. Part of development package GLO_FIN_PAYMENT_RECEIPT.

Data Sources (2)

SourceAliasJoin Type
I_PaymentReceiptType _PaymentReceiptType inner
P_TH_PaytRcptJournalEntry1 AccountingDocument from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_TH_PaytRcptJournalEntry1 CompanyCode Receiver Company Code
KEY FiscalYear P_TH_PaytRcptJournalEntry1 FiscalYear G/L Fiscal Year
KEY AccountingDocument P_TH_PaytRcptJournalEntry1 AccountingDocument Journal Entry
KEY AccountingDocumentItem P_TH_PaytRcptJournalEntry1 AccountingDocumentItem Posting View Item
CompanyCodeName I_PaymentReceiptType CompanyCodeName Company Name
DocumentReferenceID P_TH_PaytRcptJournalEntry1 DocumentReferenceID Reference
Customer P_TH_PaytRcptJournalEntry1 Customer Sold-to Party
AlternativeReferenceDocument P_TH_PaytRcptJournalEntry1 AlternativeReferenceDocument Alternative Reference Document
BusinessPlace P_TH_PaytRcptJournalEntry1 BusinessPlace Business place
DocumentDate P_TH_PaytRcptJournalEntry1 DocumentDate Journal Entry Date
PostingDate P_TH_PaytRcptJournalEntry1 PostingDate Posting Date for GR
AmountInTransactionCurrency P_TH_PaytRcptJournalEntry1 AmountInTransactionCurrency Pt Crcy Amt
Currency P_TH_PaytRcptJournalEntry1 TransactionCurrency Transaction Currency
AccountingDocumentType P_TH_PaytRcptJournalEntry1 AccountingDocumentType Journal Entry Type
CompanyCodeCurrency P_TH_PaytRcptJournalEntry1 CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_TH_PaytRcptJournalEntry1 AmountInCompanyCodeCurrency Local Crcy Amt
ClearingAccountingDocument P_TH_PaytRcptJournalEntry1 ClearingAccountingDocument Clearing Journal Entry
CashDiscountAmount P_TH_PaytRcptJournalEntry1 CashDiscountAmount CD Amount
NetPaymentAmount P_TH_PaytRcptJournalEntry1 NetPaymentAmount Net Payment Amount
IsUsedInPaymentTransaction P_TH_PaytRcptJournalEntry1 IsUsedInPaymentTransaction Is Used In Payment Transaction
BranchCode P_TH_PaytRcptJournalEntry1 BranchCode Branch Code
CustomerBusinessPlace P_TH_PaytRcptJournalEntry1 CustomerBusinessPlace
PaymentMethod P_TH_PaytRcptJournalEntry1 PaymentMethod Pymt Meth.
PaymentReceiptType P_TH_PaytRcptJournalEntry1 PaymentReceiptType Payment Receipt Type
JournalEntry _usedJounralEntry JournalEntry

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_TH_PaytRcptJournalEntry.
-- 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_TH_PaytRcptJournalEntry AS
SELECT
  AccountingDocument.CompanyCode AS CompanyCode,
  AccountingDocument.FiscalYear AS FiscalYear,
  AccountingDocument.AccountingDocument AS AccountingDocument,
  AccountingDocument.AccountingDocumentItem AS AccountingDocumentItem,
  _PaymentReceiptType.CompanyCodeName AS CompanyCodeName,
  AccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  AccountingDocument.Customer AS Customer,
  AccountingDocument.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  AccountingDocument.BusinessPlace AS BusinessPlace,
  AccountingDocument.DocumentDate AS DocumentDate,
  AccountingDocument.PostingDate AS PostingDate,
  AccountingDocument.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  AccountingDocument.TransactionCurrency AS Currency,
  AccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  AccountingDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  AccountingDocument.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AccountingDocument.ClearingAccountingDocument AS ClearingAccountingDocument,
  AccountingDocument.CashDiscountAmount AS CashDiscountAmount,
  AccountingDocument.NetPaymentAmount AS NetPaymentAmount,
  AccountingDocument.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  AccountingDocument.BranchCode AS BranchCode,
  AccountingDocument.CustomerBusinessPlace AS CustomerBusinessPlace,
  AccountingDocument.PaymentMethod AS PaymentMethod,
  AccountingDocument.PaymentReceiptType AS PaymentReceiptType,
  _usedJounralEntry.JournalEntry AS JournalEntry
FROM P_TH_PaytRcptJournalEntry1 AS AccountingDocument
INNER JOIN I_PaymentReceiptType AS _PaymentReceiptType ON /* join condition not captured in parsed metadata */
;

Learn More