C_MaintOrderForAction

DDL: C_MAINTORDERFORACTION SQL: CMAINTORDACT Type: view CONSUMPTION
16 Fields 1 Data Sources 1 Associations

Maintenance Order Operation for Action

C_MaintOrderForAction is a Consumption CDS View that provides data about "Maintenance Order Operation for Action" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderTP) and exposes 16 fields with key field MaintenanceOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderTP I_MaintOrderTP from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_MaintOrderOpForAction _MaintenanceOrderOperation _MaintenanceOrderOperation.MaintenanceOrder = $projection.MaintenanceOrder

Annotations (14)

NameValueLevelField
EndUserText.label Maintenance Order Operation for Action view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName CMAINTORDACT view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.draftEnabled false view
ObjectModel.transactionalProcessingDelegated true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
MaintenanceOrderDesc MaintenanceOrderDesc Description
MainWorkCenter _MainWorkCenter WorkCenter Work Center
MainWorkCenterPlant _MainWorkCenter Plant Valuation Area
ForDCLMaintObjectLocAcctAssgmtNmbr
Equipment Equipment Equipment check
MaintenanceOrderType MaintenanceOrderType Order Type
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlant MaintenancePlant Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
ControllingArea ControllingArea Controlling Area
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
_LocationAccountAssignment _LocationAccountAssignment
_Equipment _Equipment
_Order _Order
_MaintenanceOrderOperation _MaintenanceOrderOperation

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_MaintOrderForAction.
-- 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: CMAINTORDACT

CREATE VIEW C_MaintOrderForAction AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderDesc,
  _MainWorkCenter.WorkCenter AS MainWorkCenter,
  _MainWorkCenter.Plant AS MainWorkCenterPlant,
  Equipment,
  MaintenanceOrderType,
  MaintenancePlanningPlant,
  MaintenancePlant,
  MaintenancePlannerGroup,
  ControllingArea,
  ResponsibleCostCenter
FROM I_MaintOrderTP
LEFT OUTER JOIN C_MaintOrderOpForAction AS _MaintenanceOrderOperation ON _MaintenanceOrderOperation.MaintenanceOrder = MaintenanceOrder  -- association [0..*]
;

Learn More