P_PurReqnItemSoS

DDL: P_PURREQNITEMSOS SQL: PPURREQNITEMSOS Type: view CONSUMPTION Package: ODATA_MM_PUR_REQUISITION_FS
18 Fields 1 Data Sources 1 Associations

Purchase Requisition Item Source Of Supply

P_PurReqnItemSoS is a Consumption CDS View that provides data about "Purchase Requisition Item Source Of Supply" in SAP S/4HANA. It reads from 1 data source (I_Purchaserequisitionitem) and exposes 18 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 1 association to related views. Part of development package ODATA_MM_PUR_REQUISITION_FS.

Data Sources (1)

SourceAliasJoin Type
I_Purchaserequisitionitem I_Purchaserequisitionitem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Supplier _PreferredSupplier $projection.PreferredSupplier = _PreferredSupplier.Supplier

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPURREQNITEMSOS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Purchase Requisition Item Source Of Supply view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_Purchaserequisitionitem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_Purchaserequisitionitem PurchaseRequisitionItem Requisn. item
PurchaseRequisitionType I_Purchaserequisitionitem PurchaseRequisitionType Order Type
Plant I_Purchaserequisitionitem Plant Valuation Area
PurchasingGroup I_Purchaserequisitionitem PurchasingGroup Purchasing Group
PurchasingOrganization I_Purchaserequisitionitem PurchasingOrganization Purchasing Organization
PreferredSupplier I_Purchaserequisitionitem Supplier Supplier
PreferredSupplierName _PreferredSupplier SupplierName Supplier Name
FixedSupplier I_Purchaserequisitionitem FixedSupplier Fixed Vendor
SupplierName
PurchaseContract I_Purchaserequisitionitem PurchaseContract Purchasing Doc.
ExtDesiredSupplierForPurg I_Purchaserequisitionitem ExtDesiredSupplierForPurg Desired Supplier
ExtFixedSupplierForPurg I_Purchaserequisitionitem ExtFixedSupplierForPurg Fixed Supplier
ExtContractItemForPurg I_Purchaserequisitionitem ExtContractItemForPurg Item
PurchaseContractItem I_Purchaserequisitionitem PurchaseContractItem Item
ProcurementHubSourceSystem I_Purchaserequisitionitem ProcurementHubSourceSystem Connected System ID
ExtInfoRecordForPurg I_Purchaserequisitionitem ExtInfoRecordForPurg Info Record
PurchasingInfoRecord I_Purchaserequisitionitem PurchasingInfoRecord Info Record

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_PurReqnItemSoS.
-- 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: PPURREQNITEMSOS

CREATE VIEW P_PurReqnItemSoS AS
SELECT
  I_Purchaserequisitionitem.PurchaseRequisition AS PurchaseRequisition,
  I_Purchaserequisitionitem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_Purchaserequisitionitem.PurchaseRequisitionType AS PurchaseRequisitionType,
  I_Purchaserequisitionitem.Plant AS Plant,
  I_Purchaserequisitionitem.PurchasingGroup AS PurchasingGroup,
  I_Purchaserequisitionitem.PurchasingOrganization AS PurchasingOrganization,
  I_Purchaserequisitionitem.Supplier AS PreferredSupplier,
  _PreferredSupplier.SupplierName AS PreferredSupplierName,
  I_Purchaserequisitionitem.FixedSupplier AS FixedSupplier,
  I_Purchaserequisitionitem._Supplier.SupplierName AS SupplierName,
  I_Purchaserequisitionitem.PurchaseContract AS PurchaseContract,
  I_Purchaserequisitionitem.ExtDesiredSupplierForPurg AS ExtDesiredSupplierForPurg,
  I_Purchaserequisitionitem.ExtFixedSupplierForPurg AS ExtFixedSupplierForPurg,
  I_Purchaserequisitionitem.ExtContractItemForPurg AS ExtContractItemForPurg,
  I_Purchaserequisitionitem.PurchaseContractItem AS PurchaseContractItem,
  I_Purchaserequisitionitem.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  I_Purchaserequisitionitem.ExtInfoRecordForPurg AS ExtInfoRecordForPurg,
  I_Purchaserequisitionitem.PurchasingInfoRecord AS PurchasingInfoRecord
FROM I_Purchaserequisitionitem
LEFT OUTER JOIN I_Supplier AS _PreferredSupplier ON PreferredSupplier = _PreferredSupplier.Supplier  -- association [1..1]
;

Learn More