P_APJrnlEntrItmOpenPay1

DDL: P_APJRNLENTRITMOPENPAY1 SQL: PAPJEITMOPNPAY1 Type: view COMPOSITE Package: FINS_FIS_AP_APPS
28 Fields 1 Data Sources

P_APJrnlEntrItmOpenPay1

P_APJrnlEntrItmOpenPay1 is a Composite CDS View that provides data about "P_APJrnlEntrItmOpenPay1" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryOperationalView) and exposes 28 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package FINS_FIS_AP_APPS.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryOperationalView OpenPayables from

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

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

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
FROM I_JournalEntryOperationalView AS OpenPayables
;

Learn More