P_APJrnlEntrItmOpenPay1

DDL: P_APJRNLENTRITMOPENPAY1 SQL: PAPJEITMOPNPAY1 Type: view COMPOSITE
34 Fields 2 Data Sources

P_APJrnlEntrItmOpenPay1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_JournalEntryOperationalView, I_ReceivablesPayablesItem) and exposes 34 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntryOperationalView OpenPayables from
I_ReceivablesPayablesItem ReferencedInvoices left_outer

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PAPJEITMOPNPAY1 view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntryOperationalView CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntryOperationalView FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryOperationalView AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryOperationalView LedgerGLLineItem Journal Entry Item
AccountingDocumentCategory I_JournalEntryOperationalView AccountingDocumentCategory Journal Entry Category
AccountingDocumentType I_JournalEntryOperationalView AccountingDocumentType Journal Entry Type
AccountingDocumentItem I_JournalEntryOperationalView AccountingDocumentItem Posting View Item
InvoiceReference I_JournalEntryOperationalView InvoiceReference Invoice Reference
InvoiceItemReference I_JournalEntryOperationalView InvoiceItemReference Item
InvoiceReferenceFiscalYear I_JournalEntryOperationalView InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ClearingDate I_JournalEntryOperationalView ClearingDate Clearing Date
PostingDate I_JournalEntryOperationalView PostingDate Posting Date for GR
DocumentDate I_JournalEntryOperationalView DocumentDate Journal Entry Date
FinancialAccountType I_JournalEntryOperationalView FinancialAccountType Fin. Account Type
Supplier I_JournalEntryOperationalView Supplier Supplier
FollowOnDocumentType I_JournalEntryOperationalView FollowOnDocumentType Follow-On Document Type
NetDueDate I_JournalEntryOperationalView NetDueDate Net Due Date
SpecialGLCode I_JournalEntryOperationalView SpecialGLCode Special G/L Ind
GLAccount I_JournalEntryOperationalView GLAccount General Ledger
CostCenter I_JournalEntryOperationalView CostCenter Cost Center
ProfitCenter I_JournalEntryOperationalView ProfitCenter Profit Center
FunctionalArea I_JournalEntryOperationalView FunctionalArea Sendr Fctl Area
BusinessArea I_JournalEntryOperationalView BusinessArea Business Area
Segment I_JournalEntryOperationalView Segment Segment number
PurchasingDocument I_JournalEntryOperationalView PurchasingDocument Purchasing Document
AssignmentReference I_JournalEntryOperationalView AssignmentReference Assignment Reference
CompanyCodeCurrency I_JournalEntryOperationalView CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_JournalEntryOperationalView AmountInCompanyCodeCurrency Local Crcy Amt
RefInvcDocumentDate I_ReceivablesPayablesItem DocumentDate Journal Entry Date
RefInvcFinancialAccountType I_ReceivablesPayablesItem FinancialAccountType Fin. Account Type
RefInvcDebitCreditCode I_ReceivablesPayablesItem DebitCreditCode Single-Character Flag
RefInvcNetPaymentDays I_ReceivablesPayablesItem NetPaymentDays Net Pmt Terms Period
RefInvcInvoiceReference I_ReceivablesPayablesItem InvoiceReference Invoice Reference
RefInvcNetDueDate I_ReceivablesPayablesItem NetDueDate Net Due Date

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_APJrnlEntrItmOpenPay1.
-- 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: PAPJEITMOPNPAY1
-- Parameters: P_KeyDate : sydate

CREATE VIEW P_APJrnlEntrItmOpenPay1 AS
SELECT
  OpenPayables.CompanyCode AS CompanyCode,
  OpenPayables.FiscalYear AS FiscalYear,
  OpenPayables.AccountingDocument AS AccountingDocument,
  OpenPayables.LedgerGLLineItem AS LedgerGLLineItem,
  OpenPayables.AccountingDocumentCategory AS AccountingDocumentCategory,
  OpenPayables.AccountingDocumentType AS AccountingDocumentType,
  OpenPayables.AccountingDocumentItem AS AccountingDocumentItem,
  OpenPayables.InvoiceReference AS InvoiceReference,
  OpenPayables.InvoiceItemReference AS InvoiceItemReference,
  OpenPayables.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  OpenPayables.ClearingDate AS ClearingDate,
  OpenPayables.PostingDate AS PostingDate,
  OpenPayables.DocumentDate AS DocumentDate,
  OpenPayables.FinancialAccountType AS FinancialAccountType,
  OpenPayables.Supplier AS Supplier,
  OpenPayables.FollowOnDocumentType AS FollowOnDocumentType,
  OpenPayables.NetDueDate AS NetDueDate,
  OpenPayables.SpecialGLCode AS SpecialGLCode,
  OpenPayables.GLAccount AS GLAccount,
  OpenPayables.CostCenter AS CostCenter,
  OpenPayables.ProfitCenter AS ProfitCenter,
  OpenPayables.FunctionalArea AS FunctionalArea,
  OpenPayables.BusinessArea AS BusinessArea,
  OpenPayables.Segment AS Segment,
  OpenPayables.PurchasingDocument AS PurchasingDocument,
  OpenPayables.AssignmentReference AS AssignmentReference,
  OpenPayables.CompanyCodeCurrency AS CompanyCodeCurrency,
  OpenPayables.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  ReferencedInvoices.DocumentDate AS RefInvcDocumentDate,
  ReferencedInvoices.FinancialAccountType AS RefInvcFinancialAccountType,
  ReferencedInvoices.DebitCreditCode AS RefInvcDebitCreditCode,
  ReferencedInvoices.NetPaymentDays AS RefInvcNetPaymentDays,
  ReferencedInvoices.InvoiceReference AS RefInvcInvoiceReference,
  ReferencedInvoices.NetDueDate AS RefInvcNetDueDate
FROM I_JournalEntryOperationalView AS OpenPayables
LEFT OUTER JOIN I_ReceivablesPayablesItem AS ReferencedInvoices ON /* join condition not captured in parsed metadata */
;

Learn More