I_MaintOrderOperationCost

DDL: I_MAINTORDEROPERATIONCOST SQL: IMAINTORDOPCOST Type: view BASIC
29 Fields 1 Data Sources 1 Associations

Maintenance Order Operation Cost

I_MaintOrderOperationCost is a Basic CDS View that provides data about "Maintenance Order Operation Cost" in SAP S/4HANA. It reads from 1 data source (pmco_op) and exposes 29 fields with key fields MaintOrderOperationInternalID, ControllingAreaCurrency, ControllingObjectDebitType, ControllingValueType, FiscalYear. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
pmco_op pmco_op from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrderOperation _MaintenanceOrderOperation $projection.MaintOrderOperationInternalID = _MaintenanceOrderOperation.MaintOrderOperationInternalID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTORDOPCOST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Order Operation Cost view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderOperationInternalID pmco_op objnr Val. Obj. No.
KEY ControllingAreaCurrency pmco_op cocur Currency
KEY ControllingObjectDebitType pmco_op beltp Debit Type
KEY ControllingValueType pmco_op wrttp Value Type
KEY FiscalYear pmco_op gjahr Settlement Year
KEY ValueCategory pmco_op acpos Val.category
KEY PlanningVersion pmco_op versn Version
KEY HighestPeriodInRecord pmco_op perbl Period Block
KEY BudgetType pmco_op vorga Transfer proc.
KEY AccountingIndicatorCode pmco_op bemot AcctIndicator
KEY ResultCategory
Period00EarnedValInCtrlgArCrcy pmco_op wrt00 Period
Period01EarnedValInCtrlgArCrcy pmco_op wrt01 Period
Period02EarnedValInCtrlgArCrcy pmco_op wrt02 Period
Period03EarnedValInCtrlgArCrcy pmco_op wrt03 Period
Period04EarnedValInCtrlgArCrcy pmco_op wrt04 Period
Period05EarnedValInCtrlgArCrcy pmco_op wrt05 Period
Period06EarnedValInCtrlgArCrcy pmco_op wrt06 Period
Period07EarnedValInCtrlgArCrcy pmco_op wrt07 Period
Period08EarnedValInCtrlgArCrcy pmco_op wrt08 Period
Period09EarnedValInCtrlgArCrcy pmco_op wrt09 Period
Period10EarnedValInCtrlgArCrcy pmco_op wrt10 Period
Period11EarnedValInCtrlgArCrcy pmco_op wrt11 Period
Period12EarnedValInCtrlgArCrcy pmco_op wrt12 Period
Period13EarnedValInCtrlgArCrcy pmco_op wrt13 Period
Period14EarnedValInCtrlgArCrcy pmco_op wrt14 Period
Period15EarnedValInCtrlgArCrcy pmco_op wrt15 Period
Period16EarnedValInCtrlgArCrcy pmco_op wrt16 Period
_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 I_MaintOrderOperationCost.
-- 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: IMAINTORDOPCOST

CREATE VIEW I_MaintOrderOperationCost AS
SELECT
  pmco_op.objnr AS MaintOrderOperationInternalID,
  pmco_op.cocur AS ControllingAreaCurrency,
  pmco_op.beltp AS ControllingObjectDebitType,
  pmco_op.wrttp AS ControllingValueType,
  pmco_op.gjahr AS FiscalYear,
  pmco_op.acpos AS ValueCategory,
  pmco_op.versn AS PlanningVersion,
  pmco_op.perbl AS HighestPeriodInRecord,
  pmco_op.vorga AS BudgetType,
  pmco_op.bemot AS AccountingIndicatorCode,
  cast(pmco_op.abkat as eam_abkat) AS ResultCategory,
  pmco_op.wrt00 AS Period00EarnedValInCtrlgArCrcy,
  pmco_op.wrt01 AS Period01EarnedValInCtrlgArCrcy,
  pmco_op.wrt02 AS Period02EarnedValInCtrlgArCrcy,
  pmco_op.wrt03 AS Period03EarnedValInCtrlgArCrcy,
  pmco_op.wrt04 AS Period04EarnedValInCtrlgArCrcy,
  pmco_op.wrt05 AS Period05EarnedValInCtrlgArCrcy,
  pmco_op.wrt06 AS Period06EarnedValInCtrlgArCrcy,
  pmco_op.wrt07 AS Period07EarnedValInCtrlgArCrcy,
  pmco_op.wrt08 AS Period08EarnedValInCtrlgArCrcy,
  pmco_op.wrt09 AS Period09EarnedValInCtrlgArCrcy,
  pmco_op.wrt10 AS Period10EarnedValInCtrlgArCrcy,
  pmco_op.wrt11 AS Period11EarnedValInCtrlgArCrcy,
  pmco_op.wrt12 AS Period12EarnedValInCtrlgArCrcy,
  pmco_op.wrt13 AS Period13EarnedValInCtrlgArCrcy,
  pmco_op.wrt14 AS Period14EarnedValInCtrlgArCrcy,
  pmco_op.wrt15 AS Period15EarnedValInCtrlgArCrcy,
  pmco_op.wrt16 AS Period16EarnedValInCtrlgArCrcy
FROM pmco_op
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON MaintOrderOperationInternalID = _MaintenanceOrderOperation.MaintOrderOperationInternalID  -- association [0..1]
;

Learn More