I_EntProjProcmtPurReqOrd

DDL: I_ENTPROJPROCMTPURREQORD SQL: IEPPROCMTPRPO Type: view_entity COMPOSITE Package: ODATA_PS_PUR_REQORD_MNG
50 Fields 1 Data Sources

Project Procmnt Purc Reqn Order

I_EntProjProcmtPurReqOrd is a Composite CDS View that provides data about "Project Procmnt Purc Reqn Order" in SAP S/4HANA. It reads from 1 data source (P_ENTPROJPROCMTPURREQORD) and exposes 50 fields with key fields WBSElementInternalID, PurchaseOrder, PurchaseOrderItem, PurchaseRequisition, PurchaseRequisitionItem. Part of development package ODATA_PS_PUR_REQORD_MNG.

Data Sources (1)

SourceAliasJoin Type
P_ENTPROJPROCMTPURREQORD P_ENTPROJPROCMTPURREQORD from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Project Procmnt Purc Reqn Order view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Search.searchable true view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBS Internal ID
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
KEY PurchasingDocumentPartnerType PurchasingDocumentPartnerType Partner Type
ProjectInternalID ProjectInternalID Project Def.
ProjectCategory ProjectCategory Proj. Category
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchaseRequisitionItemText PurchaseRequisitionItemText Short Text
FormattedPurRequisitionItem
FormattedPurchaseOrderItem
Project ProjectExternalID Project def.
ProjectSummaryTaskUUID ProjectSummaryTaskUUID Entity GUID
ProjectUUID ProjectUUID Project UUID
ProjectProfileCode ProjectProfileCode Project Profile
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
WBSElement WBSElementWithCodingMask
WBSDescription WBSDescription WBS Element Name
ProjectDescription ProjectDescription Project Name
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
Material Material Vehicle Model
MaterialName MaterialName Material Description
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
PurchasingOrganization PurchasingOrganization Purchasing Organization
ProjectType ProjectType Project Type
PurchasingGroup PurchasingGroup Purchasing Group
StorageLocation StorageLocation StorageLocation
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
DocumentCurrency DocumentCurrency Document Currency
DisplayCurrency
NetAmount NetAmount Stated Amount
NetValueAmountInDocCurrency NetAmount Stated Amount
DeliveryDate DeliveryDate Delivery Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
OrderQuantityUnit OrderQuantityUnit Sales Unit
TotalQuantity TotalQuantity Activity Quantity
StockTransferDeliveredQuantity
OrderedQuantity OrderedQuantity Quantity
int8asOverdueDays
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
CreationDate _PRPODetails CreationDate Time Stamp
IsSettled IsSettled Is Settled
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
FunctionalArea FunctionalArea Sendr Fctl Area

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_EntProjProcmtPurReqOrd.
-- 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: IEPPROCMTPRPO
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_EntProjProcmtPurReqOrd AS
SELECT
  cast(WBSElementInternalID as ps_s4_pspnr) AS WBSElementInternalID,
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchasingDocumentPartnerType,
  ProjectInternalID,
  ProjectCategory,
  PurchasingDocumentType,
  PurchasingDocumentCategory,
  PurchaseRequisitionItemText,
  cast(concat(concat(PurchaseRequisition, '/'), PurchaseRequisitionItem) as mm_pur_requisition_frmtdpritem) AS FormattedPurRequisitionItem,
  concat(concat(PurchaseOrder, '/'), PurchaseOrderItem) AS FormattedPurchaseOrderItem,
  ProjectExternalID AS Project,
  ProjectSummaryTaskUUID,
  ProjectUUID,
  ProjectProfileCode,
  CompanyCode,
  ControllingArea,
  ProfitCenter,
  WBSElementWithCodingMask AS WBSElement,
  WBSDescription,
  ProjectDescription,
  Supplier,
  SupplierName,
  Material,
  MaterialName,
  MaterialGroup,
  Plant,
  PurchasingOrganization,
  ProjectType,
  PurchasingGroup,
  StorageLocation,
  IsCompletelyDelivered,
  DocumentCurrency,
  cast ($parameters.P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  NetAmount,
  NetAmount AS NetValueAmountInDocCurrency,
  DeliveryDate,
  ScheduleLineDeliveryDate,
  OrderQuantityUnit,
  TotalQuantity,
  TotalQuantity - OrderedQuantity AS StockTransferDeliveredQuantity,
  OrderedQuantity,
  cast ( dats_days_between( cast( $session.system_date as abap.dats), DeliveryDate ) as abap.int8) as OverdueDays AS int8asOverdueDays,
  PurReqnReleaseStatus,
  _PRPODetails.CreationDate AS CreationDate,
  IsSettled,
  ResponsibleCostCenter,
  FunctionalArea
FROM P_ENTPROJPROCMTPURREQORD
;

Learn More