P_APVendorOpenItems11

DDL: P_APVENDOROPENITEMS11 SQL: PFIAPVNDROPITM11 Type: view COMPOSITE Package: FINS_FIS_AP_APPS
13 Fields 2 Data Sources

Accounts Payable Vendor Open Items. Delete empty

P_APVendorOpenItems11 is a Composite CDS View that provides data about "Accounts Payable Vendor Open Items. Delete empty" in SAP S/4HANA. It reads from 2 data sources (P_APVendorOpenItems10, P_APVendorOpenItems0) and exposes 13 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. Part of development package FINS_FIS_AP_APPS.

Data Sources (2)

SourceAliasJoin Type
P_APVendorOpenItems10 DeleteEmpty from
P_APVendorOpenItems0 P_APVendorOpenItems0 inner

Annotations (6)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_APVendorOpenItems0 CompanyCode Receiver Company Code
KEY AccountingDocument P_APVendorOpenItems0 AccountingDocument Journal Entry
KEY FiscalYear P_APVendorOpenItems0 FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem P_APVendorOpenItems0 AccountingDocumentItem Posting View Item
Supplier P_APVendorOpenItems0 Supplier Supplier
DocumentCurrency P_APVendorOpenItems0 DocumentCurrency Document Currency
SpecialGLTransactionType P_APVendorOpenItems10 SpecialGLTransactionType Transact.Type
OpenAmount P_APVendorOpenItems10 OpenAmount
OpenAmountelse0endasDownPaymentAmount
OpenAmountendasOtherPaymentAmount
AccountingDocCreatedByUser _AccountingDocumentHeader AccountingDocCreatedByUser User which created overhead document
CompanyCodeCurrency P_APVendorOpenItems0 CompanyCodeCurrency Local Currency
_DocumentCurrency _DocumentCurrency

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_APVendorOpenItems11.
-- 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: PFIAPVNDROPITM11

CREATE VIEW P_APVendorOpenItems11 AS
SELECT
  P_APVendorOpenItems0.CompanyCode AS CompanyCode,
  P_APVendorOpenItems0.AccountingDocument AS AccountingDocument,
  P_APVendorOpenItems0.FiscalYear AS FiscalYear,
  P_APVendorOpenItems0.AccountingDocumentItem AS AccountingDocumentItem,
  P_APVendorOpenItems0.Supplier AS Supplier,
  P_APVendorOpenItems0.DocumentCurrency AS DocumentCurrency,
  DeleteEmpty.SpecialGLTransactionType AS SpecialGLTransactionType,
  DeleteEmpty.OpenAmount AS OpenAmount,
  case DeleteEmpty.SpecialGLTransactionType when 'A' then DeleteEmpty.OpenAmount else 0 end as DownPaymentAmount AS OpenAmountelse0endasDownPaymentAmount,
  case DeleteEmpty.SpecialGLTransactionType when 'A' then 0 else DeleteEmpty.OpenAmount end as OtherPaymentAmount AS OpenAmountendasOtherPaymentAmount,
  _AccountingDocumentHeader.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  P_APVendorOpenItems0.CompanyCodeCurrency AS CompanyCodeCurrency
FROM P_APVendorOpenItems10 AS DeleteEmpty
INNER JOIN P_APVendorOpenItems0 ON /* join condition not captured in parsed metadata */
;

Learn More