C_AlternateSupplierPOSituation

DDL: C_ALTERNATESUPPLIERPOSITUATION SQL: CPOALTSUPLRSIT Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN_V2
17 Fields 1 Data Sources 3 Associations

Alternate Suppliers for a Purchase Order Situation

C_AlternateSupplierPOSituation is a Consumption CDS View that provides data about "Alternate Suppliers for a Purchase Order Situation" in SAP S/4HANA. It reads from 1 data source (P_AlternateSupplierPOSit2) and exposes 17 fields with key fields Supplier, Material, Plant, PurchasingOrganization, PurchaseOrderItemCategory. It has 3 associations to related views. Part of development package ODATA_MM_PUR_PO_MAINTAIN_V2.

Data Sources (1)

SourceAliasJoin Type
P_AlternateSupplierPOSit2 _AltSupplierPOSituation from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_PurchaseOrderItem _PurchaseOrderItem _AltSupplierPOSituation.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and _AltSupplierPOSituation.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem and _AltSupplierPOSituation.Material = _PurchaseOrderItem.Material and _AltSupplierPOSituation.Plant = _PurchaseOrderItem.Plant and _AltSupplierPOSituation.PurchaseOrderItemCategory = _PurchaseOrderItem.PurchaseOrderItemCategory
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_PurgInfoRecordWithOrgData _inforecdata _inforecdata.Material = $projection.Material and _inforecdata.Plant = $projection.Plant and _inforecdata.PurchasingInfoRecordCategory = $projection.PurchaseOrderItemCategory and _inforecdata.PurchasingOrganization = $projection.PurchasingOrganization and _inforecdata.Supplier = $projection.Supplier and _inforecdata.Material != '' and _inforecdata.Material is not null

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPOALTSUPLRSIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Alternate Suppliers for a Purchase Order Situation view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.headerInfo.typeName Alternate Supplier view
UI.headerInfo.typeNamePlural Alternate Suppliers view
UI.headerInfo.title.value Supplier view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Supplier P_AlternateSupplierPOSit2 Supplier Supplier
KEY Material P_AlternateSupplierPOSit2 Material Vehicle Model
KEY Plant P_AlternateSupplierPOSit2 Plant Valuation Area
KEY PurchasingOrganization P_AlternateSupplierPOSit2 PurchasingOrganization Purchasing Organization
KEY PurchaseOrderItemCategory P_AlternateSupplierPOSit2 PurchaseOrderItemCategory Item Category
CreationDate P_AlternateSupplierPOSit2 CreationDate Order Date
PurchaseOrder PurchaseOrder Last Purchase Order
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
MaterialPlannedDeliveryDurn _inforecdata MaterialPlannedDeliveryDurn Delivery Time in Days
PurchasingInfoRecord _inforecdata PurchasingInfoRecord Info Record
NetPriceAmount _PurchaseOrderItem NetPriceAmount Net Order Price
DocumentCurrency _PurchaseOrderItem DocumentCurrency Document Currency
NetPriceQuantity _PurchaseOrderItem NetPriceQuantity Price Unit
OrderPriceUnit _PurchaseOrderItem OrderPriceUnit Order Price Un.
SupplierName _Supplier SupplierName Supplier Name
PurchasingGroup
CompanyCode

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 C_AlternateSupplierPOSituation.
-- 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: CPOALTSUPLRSIT

CREATE VIEW C_AlternateSupplierPOSituation AS
SELECT
  _AltSupplierPOSituation.Supplier AS Supplier,
  _AltSupplierPOSituation.Material AS Material,
  _AltSupplierPOSituation.Plant AS Plant,
  _AltSupplierPOSituation.PurchasingOrganization AS PurchasingOrganization,
  _AltSupplierPOSituation.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _AltSupplierPOSituation.CreationDate AS CreationDate,
  PurchaseOrder,
  PurchaseOrderItem,
  _inforecdata.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  _inforecdata.PurchasingInfoRecord AS PurchasingInfoRecord,
  _PurchaseOrderItem.NetPriceAmount AS NetPriceAmount,
  _PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  _PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  _PurchaseOrderItem.OrderPriceUnit AS OrderPriceUnit,
  _Supplier.SupplierName AS SupplierName,
  _PurchaseOrderItem._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderItem._PurchaseOrder.CompanyCode AS CompanyCode
FROM P_AlternateSupplierPOSit2 AS _AltSupplierPOSituation
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON _AltSupplierPOSituation.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND _AltSupplierPOSituation.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem AND _AltSupplierPOSituation.Material = _PurchaseOrderItem.Material AND _AltSupplierPOSituation.Plant = _PurchaseOrderItem.Plant AND _AltSupplierPOSituation.PurchaseOrderItemCategory = _PurchaseOrderItem.PurchaseOrderItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecordWithOrgData AS _inforecdata ON _inforecdata.Material = Material AND _inforecdata.Plant = Plant AND _inforecdata.PurchasingInfoRecordCategory = PurchaseOrderItemCategory AND _inforecdata.PurchasingOrganization = PurchasingOrganization AND _inforecdata.Supplier = Supplier AND _inforecdata.Material != '' AND _inforecdata.Material is not null  -- association [0..1]
;

Learn More