I_PurOrdsOpenForConf

DDL: I_PURORDSOPENFORCONF SQL: IPOOPNCNFUNION Type: view COMPOSITE
30 Fields 2 Data Sources

Union on all PO open for cnf

I_PurOrdsOpenForConf is a Composite CDS View that provides data about "Union on all PO open for cnf" in SAP S/4HANA. It reads from 2 data sources (I_ProcmtHubPurReqnOpenForConf, C_PRItemDetails) and exposes 30 fields with key fields PurchaseRequisition, PurchaseOrder, PurchaseOrderItem, ProcuringPlant, PurchaseOrder.

Data Sources (2)

SourceAliasJoin Type
I_ProcmtHubPurReqnOpenForConf I_ProcmtHubPurReqnOpenForConf union
C_PRItemDetails PRItemForGoodsReceipt from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPOOPNCNFUNION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Union on all PO open for cnf view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition C_PRItemDetails PurchaseRequisition Requisition
KEY PurchaseOrder C_PRItemDetails PurchasingDocument Purchasing Doc.
KEY PurchaseOrderItem C_PRItemDetails PurchasingDocumentItem Item
KEY ProcuringPlant C_PRItemDetails Plant Plant
PurchaseRequisitionItem C_PRItemDetails PurchaseRequisitionItem Requisn. item
Plant C_PRItemDetails Plant Valuation Area
ReferenceDocumentPlant Plant
OpenQuantity C_PRItemDetails OpenQuantity PO Quantity
PurchaseOrderQuantityUnit C_PRItemDetails OrderQuantityUnit Base Unit
Material C_PRItemDetails Material Material
PurchasingDocumentItemText C_PRItemDetails PurchasingDocumentItemText Short Text
Supplier C_PRItemDetails Supplier Supplier
IsExtPurgScenario
PurchaseReqnItemUniqueID C_PRItemDetails PurchaseReqnItemUniqueID Purch. Doc. ID
PurReqnSSPRequestor C_PRItemDetails PurReqnSSPRequestor Requestor
KEY PurchaseOrder ProcmtHubReferencePurOrder Purchasing Doc.
KEY PurchaseOrderItem ProcmtHubReferencePurOrderItm Item
KEY ProcuringPlant ExtPlantForPurg Plant
PurchaseRequisitionItem ProcmtHubPurRequisitionItem Requisn. item
Plant Valuation Area
ReferenceDocumentPlant ExtPlantForPurg Plant
OpenQuantity ProcmtHubRefPurOrderOpenQty PO Quantity
PurchaseOrderQuantityUnit ProcmtHubRefPurOrdItemUoM Base Unit
Material ProcmtHubRefPurOrdItemMaterial Material
PurchasingDocumentItemText Short Text
Supplier ProcmtHubRefPurOrdSupplier Supplier
IsExtPurgScenario
PurchaseReqnItemUniqueID Purch. Doc. ID
PurReqnSSPRequestor PurReqnRequestor Requestor
PurReqnSSPAuthor SSPAuthorExternalBPIdnNumber Author

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_PurOrdsOpenForConf.
-- 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: IPOOPNCNFUNION

CREATE VIEW I_PurOrdsOpenForConf AS
SELECT
  PRItemForGoodsReceipt.PurchaseRequisition AS PurchaseRequisition,
  PRItemForGoodsReceipt.PurchasingDocument AS PurchaseOrder,
  PRItemForGoodsReceipt.PurchasingDocumentItem AS PurchaseOrderItem,
  PRItemForGoodsReceipt.Plant AS ProcuringPlant,
  PRItemForGoodsReceipt.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PRItemForGoodsReceipt.Plant AS Plant,
  cast ('' as werks_d) AS ReferenceDocumentPlant,
  PRItemForGoodsReceipt.OpenQuantity AS OpenQuantity,
  PRItemForGoodsReceipt.OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PRItemForGoodsReceipt.Material AS Material,
  PRItemForGoodsReceipt.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  PRItemForGoodsReceipt.Supplier AS Supplier,
  cast ('' as boole_d) AS IsExtPurgScenario,
  PRItemForGoodsReceipt.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  PRItemForGoodsReceipt.PurReqnSSPRequestor AS PurReqnSSPRequestor,
  SSPAuthorExternalBPIdnNumber AS PurReqnSSPAuthor
FROM C_PRItemDetails AS PRItemForGoodsReceipt
-- UNION with additional select branch(es): I_ProcmtHubPurReqnOpenForConf
;

Learn More