I_MaintOrdCompPurRequisitionC

DDL: I_MAINTORDCOMPPURREQUISITIONC SQL: IMTORDCOMPPURREQ Type: view COMPOSITE
57 Fields 1 Data Sources

Purchase Requisitions for Maintenance Order Components

I_MaintOrdCompPurRequisitionC is a Composite CDS View that provides data about "Purchase Requisitions for Maintenance Order Components" in SAP S/4HANA. It reads from 1 data source (P_MaintOrdDirectProcmtViaPR) and exposes 57 fields with key fields PurchaseRequisition, PurchaseRequisitionItem.

Data Sources (1)

SourceAliasJoin Type
P_MaintOrdDirectProcmtViaPR P_MaintOrdDirectProcmtViaPR from

Annotations (10)

NameValueLevelField
EndUserText.label Purchase Requisitions for Maintenance Order Components view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IMTORDCOMPPURREQ view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition PurchaseRequisition Requisition
KEY PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
MaintenanceOrder MaintenanceOrder Order
MaintOrderRoutingNumber MaintOrderRoutingNumber Plan No.f.Oper.
MaintOrderOperationCounter MaintOrderOperationCounter Counter
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
MaintOrdBasicStartDate MaintOrdBasicStartDate Bas. Start Date
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte Earl.start date
RequirementDate RequirementDate Requirement Date
MaintenanceOrderOperation MaintenanceOrderOperation Suboperation
OperationDescription OperationDescription Op. Short Text
ReferenceDate ReferenceDate Reference Date
MaintenanceOrderDesc MaintenanceOrderDesc Description
MaintenanceOrderType MaintenanceOrderType Order Type
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
MaintPriorityDesc MaintPriorityDesc Priority
MaintenanceRevision MaintenanceRevision Revision
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlant MaintenancePlant Plant
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicStartTime ScheduledBasicStartTime
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ScheduledBasicEndTime ScheduledBasicEndTime
PlantSection PlantSection Plant Section
WorkCenterInternalID WorkCenterInternalID Work Center
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
RequestedQuantity RequestedQuantity Requested Quantity
BaseUnit BaseUnit Unit of Measure
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
PreferredSupplier PreferredSupplier Supplier
PreferredSupplierName PreferredSupplierName
Material Material Vehicle Model
MaterialName MaterialName Material Description
PurchaseRequisitionItemText PurchaseRequisitionItemText Short Text
PurchasingGroup PurchasingGroup Purchasing Group
PurReqnItemCurrency PurReqnItemCurrency Currency
PurchaseRequisitionPrice PurchaseRequisitionPrice Valuation Price
OperationIsProcessedExternally OperationIsProcessedExternally
MaintProcurementMilestone MaintProcurementMilestone Milestone
MaintOrdProcmtMilestoneDate MaintOrdProcmtMilestoneDate Milestone Date
MaintOrdProcmtMlstnDateTime MaintOrdProcmtMlstnDateTime Milestone Date&Time
_FuncnlLocationLabel _FuncnlLocationLabel
_MaintenanceOrder _MaintenanceOrder
_PurchaseRequisitionItem _PurchaseRequisitionItem
_Supplier _Supplier
_PreferredSupplier _PreferredSupplier

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_MaintOrdCompPurRequisitionC.
-- 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: IMTORDCOMPPURREQ

CREATE VIEW I_MaintOrdCompPurRequisitionC AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  MaintenanceOrder,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  Reservation,
  ReservationItem,
  MaintOrdBasicStartDate,
  OpErlstSchedldExecStrtDte,
  RequirementDate,
  MaintenanceOrderOperation,
  OperationDescription,
  ReferenceDate,
  MaintenanceOrderDesc,
  MaintenanceOrderType,
  MaintPriority,
  MaintPriorityType,
  MaintPriorityDesc,
  MaintenanceRevision,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MaintenancePlant,
  MainWorkCenter,
  MainWorkCenterPlant,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  PlantSection,
  WorkCenterInternalID,
  Equipment,
  FunctionalLocation,
  MaintObjectLocAcctAssgmtNmbr,
  PurchaseOrder,
  PurchaseOrderItem,
  PurReqnReleaseStatus,
  RequestedQuantity,
  BaseUnit,
  Supplier,
  SupplierName,
  PreferredSupplier,
  PreferredSupplierName,
  Material,
  MaterialName,
  PurchaseRequisitionItemText,
  PurchasingGroup,
  PurReqnItemCurrency,
  PurchaseRequisitionPrice,
  OperationIsProcessedExternally,
  MaintProcurementMilestone,
  MaintOrdProcmtMilestoneDate,
  MaintOrdProcmtMlstnDateTime
FROM P_MaintOrdDirectProcmtViaPR
;

Learn More