C_ObjPgMaintOrderCostAggrgData

DDL: C_OBJPGMAINTORDERCOSTAGGRGDATA SQL: COPMNTORDCOSTAD Type: view CONSUMPTION

Maintenance Order Cost Aggregate Data

C_ObjPgMaintOrderCostAggrgData is a Consumption CDS View that provides data about "Maintenance Order Cost Aggregate Data" in SAP S/4HANA. It reads from 1 data source (C_ObjPgMaintOrderCost) and exposes 6 fields with key field MaintenanceOrderInternalID. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
C_ObjPgMaintOrderCost C_ObjPgMaintOrderCost from

Associations (1)

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

Annotations (9)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName COPMNTORDCOSTAD view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Order Cost Aggregate Data view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrderInternalID C_ObjPgMaintOrderCost MaintenanceOrderInternalID
MaintOrderTotalActualCost Total Actual Cost
MaintOrderTotalEstimatedCost Total Estimated Cost
MaintOrderTotalPlannedCost Total Planned Cost
Currency
_MaintenanceOrder _MaintenanceOrder 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'COPMNTORDCOSTAD'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maintenance Order Cost Aggregate Data'

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #CONSUMPTION

define view C_ObjPgMaintOrderCostAggrgData
  as select from C_ObjPgMaintOrderCost

  association [1..1] to I_MaintenanceOrder as _MaintenanceOrder on _MaintenanceOrder.MaintenanceOrderInternalID = $projection.MaintenanceOrderInternalID
{
  key C_ObjPgMaintOrderCost.MaintenanceOrderInternalID,

      @EndUserText.label: 'Total Actual Cost'
      @Semantics.amount.currencyCode: 'Currency'
      @UI:{
          dataPoint: {
                title: 'Actual Cost'
          }
      }
      cast('0' as dpmistval)  as MaintOrderTotalActualCost,

      @EndUserText.label: 'Total Estimated Cost'
      @Semantics.amount.currencyCode: 'Currency'
      @UI:{
          dataPoint: {
                title: 'Estimated Cost'
          }
      }
      cast('0' as dpmestval)  as MaintOrderTotalEstimatedCost,

      @EndUserText.label: 'Total Planned Cost'
      @Semantics.amount.currencyCode: 'Currency'
      @UI:{
          dataPoint: {
                title: 'Planned Cost'
          }
      }
      cast('0' as dpmplanval) as MaintOrderTotalPlannedCost,

      @Semantics.currencyCode: true
      cast('' as waers)       as Currency,

      // association

      _MaintenanceOrder
}
group by
  C_ObjPgMaintOrderCost.MaintenanceOrderInternalID 
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_OBJPGMAINTORDERCOST"
],
"ASSOCIATED":
[
"I_MAINTENANCEORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More