P_AltSuplrPOItemSituation

DDL: P_ALTSUPLRPOITEMSITUATION SQL: PPOITEMSUPLRSIT Type: view CONSUMPTION Package: APPL_MM_PUR_PO_AI
8 Fields 1 Data Sources

Purchase Order Item for Alternate Supplier Situation

P_AltSuplrPOItemSituation is a Consumption CDS View that provides data about "Purchase Order Item for Alternate Supplier Situation" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 8 fields with key fields PurchaseOrder, Supplier, Material, Plant, PurchaseOrderItemCategory. Part of development package APPL_MM_PUR_PO_AI.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem po_item from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPOITEMSUPLRSIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Order Item for Alternate Supplier Situation view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY Supplier _PurchaseOrder Supplier Supplier
KEY Material I_PurchaseOrderItem Material Vehicle Model
KEY Plant I_PurchaseOrderItem Plant Valuation Area
KEY PurchaseOrderItemCategory I_PurchaseOrderItem PurchaseOrderItemCategory Item Category
KEY PurchasingOrganization _PurchaseOrder PurchasingOrganization Purchasing Organization
KEY CreationDate _PurchaseOrder CreationDate Time Stamp
PurchaseOrderItem

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_AltSuplrPOItemSituation.
-- 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: PPOITEMSUPLRSIT

CREATE VIEW P_AltSuplrPOItemSituation AS
SELECT
  po_item.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrder.Supplier AS Supplier,
  po_item.Material AS Material,
  po_item.Plant AS Plant,
  po_item.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.CreationDate AS CreationDate,
  max( PurchaseOrderItem ) AS PurchaseOrderItem
FROM I_PurchaseOrderItem AS po_item
;

Learn More