I_MaintenanceOrderCost

DDL: I_MAINTENANCEORDERCOST Type: view_entity BASIC Package: IWO2

Maintenance Order Cost

I_MaintenanceOrderCost is a Basic CDS View that provides data about "Maintenance Order Cost" in SAP S/4HANA. It reads from 1 data source (pmco) and exposes 29 fields with key fields MaintenanceOrderInternalID, ControllingAreaCurrency, ControllingObjectDebitType, ControllingValueType, FiscalYear. It has 1 association to related views. Part of development package IWO2.

Data Sources (1)

SourceAliasJoin Type
pmco pmco from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrder _MaintenanceOrder $projection.MaintenanceOrderInternalID = _MaintenanceOrder.MaintenanceOrderInternalID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order 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 MaintenanceOrderInternalID pmco objnr
KEY ControllingAreaCurrency pmco cocur
KEY ControllingObjectDebitType pmco beltp
KEY ControllingValueType pmco wrttp
KEY FiscalYear pmco gjahr
KEY ValueCategory pmco acpos
KEY PlanningVersion pmco versn
KEY HighestPeriodInRecord pmco perbl
KEY BudgetType pmco vorga
KEY AccountingIndicatorCode pmco bemot
KEY ResultCategory
Period00EarnedValInCtrlgArCrcy pmco wrt00
Period01EarnedValInCtrlgArCrcy pmco wrt01
Period02EarnedValInCtrlgArCrcy pmco wrt02
Period03EarnedValInCtrlgArCrcy pmco wrt03
Period04EarnedValInCtrlgArCrcy pmco wrt04
Period05EarnedValInCtrlgArCrcy pmco wrt05
Period06EarnedValInCtrlgArCrcy pmco wrt06
Period07EarnedValInCtrlgArCrcy pmco wrt07
Period08EarnedValInCtrlgArCrcy pmco wrt08
Period09EarnedValInCtrlgArCrcy pmco wrt09
Period10EarnedValInCtrlgArCrcy pmco wrt10
Period11EarnedValInCtrlgArCrcy pmco wrt11
Period12EarnedValInCtrlgArCrcy pmco wrt12
Period13EarnedValInCtrlgArCrcy pmco wrt13
Period14EarnedValInCtrlgArCrcy pmco wrt14
Period15EarnedValInCtrlgArCrcy pmco wrt15
Period16EarnedValInCtrlgArCrcy pmco wrt16
_MaintenanceOrder _MaintenanceOrder
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Cost'

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #BASIC

define view entity I_MaintenanceOrderCost
  as select from pmco
  association [0..1] to I_MaintenanceOrder as _MaintenanceOrder on $projection.MaintenanceOrderInternalID = _MaintenanceOrder.MaintenanceOrderInternalID
{
      /* Fields */
  key pmco.objnr                    as MaintenanceOrderInternalID,
  key pmco.cocur                    as ControllingAreaCurrency,
  key pmco.beltp                    as ControllingObjectDebitType,
  key pmco.wrttp                    as ControllingValueType,
  key pmco.gjahr                    as FiscalYear,
  key pmco.acpos                    as ValueCategory,
  key pmco.versn                    as PlanningVersion,
  key pmco.perbl                    as HighestPeriodInRecord,
  key pmco.vorga                    as BudgetType,
  key pmco.bemot                    as AccountingIndicatorCode,
  key cast(pmco.abkat as eam_abkat) as ResultCategory,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt00                    as Period00EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt01                    as Period01EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt02                    as Period02EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt03                    as Period03EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt04                    as Period04EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt05                    as Period05EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt06                    as Period06EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt07                    as Period07EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt08                    as Period08EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt09                    as Period09EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt10                    as Period10EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt11                    as Period11EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt12                    as Period12EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt13                    as Period13EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt14                    as Period14EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt15                    as Period15EarnedValInCtrlgArCrcy,
      @Semantics.amount.currencyCode: 'CONTROLLINGAREACURRENCY' 
pmco.wrt16                    as Period16EarnedValInCtrlgArCrcy,

      /* Associations */
      _MaintenanceOrder
}