I_ProdCmplncLicRlvtPurgDocs

DDL: I_PRODCMPLNCLICRLVTPURGDOCS SQL: IPCLRPO Type: view COMPOSITE
10 Fields 1 Data Sources

License Relevant Purchase Order Items

I_ProdCmplncLicRlvtPurgDocs is a Composite CDS View that provides data about "License Relevant Purchase Order Items" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocumentItem) and exposes 10 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocumentItem I_PurchasingDocumentItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPCLRPO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label License Relevant Purchase Order Items view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
CreationDate I_PurchasingDocument CreationDate Time Stamp
NumberOfItems
Plant I_PurchasingDocumentItem Plant Valuation Area
PurchasingDocumentCategory I_PurchasingDocumentItem PurchasingDocumentCategory Doc. Category
IsEndOfPurposeBlocked I_PurchasingDocumentItem IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_PurchasingDocument I_PurchasingDocumentItem _PurchasingDocument
_Plant I_PurchasingDocumentItem _Plant
_PurgDocumentCategory I_PurchasingDocumentItem _PurgDocumentCategory

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 I_ProdCmplncLicRlvtPurgDocs.
-- 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: IPCLRPO

CREATE VIEW I_ProdCmplncLicRlvtPurgDocs AS
SELECT
  I_PurchasingDocumentItem.PurchasingDocument AS PurchasingDocument,
  I_PurchasingDocumentItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_PurchasingDocument.CreationDate AS CreationDate,
  cast( 1 as abap.int8 ) AS NumberOfItems,
  I_PurchasingDocumentItem.Plant AS Plant,
  I_PurchasingDocumentItem.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_PurchasingDocumentItem.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  I_PurchasingDocumentItem._PurchasingDocument AS _PurchasingDocument,
  I_PurchasingDocumentItem._Plant AS _Plant,
  I_PurchasingDocumentItem._PurgDocumentCategory AS _PurgDocumentCategory
FROM I_PurchasingDocumentItem
;

Learn More