I_MaintOrderOpProdnRsceTool

DDL: I_MAINTORDEROPPRODNRSCETOOL SQL: IMAINTOPPRT Type: view BASIC

Maintenance Order Operation PRT

I_MaintOrderOpProdnRsceTool is a Basic CDS View that provides data about "Maintenance Order Operation PRT" in SAP S/4HANA. It reads from 4 data sources (affh, afih, afvc, crfh) and exposes 13 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, ProdnRsceToolItemNumber. It has 1 association to related views.

4 data source(s) 13 fields

Data Sources (4)

SourceAliasJoin Type
affh affh inner
afih afih from
afvc afvc inner
crfh crfh inner

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTOPPRT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Operation PRT view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder afih aufnr
KEY MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation
KEY ProdnRsceToolItemNumber affh psnfh
OrderProdnRsceToolInternalID affh pzlfh
OrderProdnRsceToolText affh txtz1
ProductionResourceType affh objty
ProductionResourceInternalID affh objid
ProdnRsceToolControlProfile affh steuf
ProdnRsceToolCategory
ProdnRsceToolStandardWorkQty affh mgvgw
ProdnRsceToolStdWorkQtyUnit affh mgeinh
_MaintenanceOrder _MaintenanceOrder 
@AbapCatalog.sqlViewName: 'IMAINTOPPRT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Operation PRT'

@VDM.viewType: #BASIC

@ObjectModel.semanticKey:  [ 'MaintenanceOrder', 'MaintenanceOrderOperation', 'MaintenanceOrderSubOperation', 'ProdnRsceToolItemNumber' ]

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

define view I_MaintOrderOpProdnRsceTool
  as select from           afih as afih
    left outer to one join afko as afko on afih.aufnr = afko.aufnr
    inner join             afvc as afvc on  afko.aufpl = afvc.aufpl
                                        and afvc.sumnr is initial
    inner join             affh as affh on  afvc.aufpl = affh.aufpl
                                        and afvc.aplzl = affh.aplzl
                                        and affh.loekz is initial
    inner join             crfh as crfh on  affh.objty     = crfh.objty
                                        and affh.objid     = crfh.objid
                                        and affh.zaehl_key = crfh.zaehl

  association [1..1] to I_MaintenanceOrder as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder

{

  key  afih.aufnr                                                      as MaintenanceOrder,
  key  cast( afvc.vornr as maintenanceorderoperation preserving type ) as MaintenanceOrderOperation,
  key  cast( '    ' as maintenanceordersuboperation preserving type )  as MaintenanceOrderSubOperation,
  key  affh.psnfh                                                      as ProdnRsceToolItemNumber,

       affh.pzlfh                                                      as OrderProdnRsceToolInternalID,
       affh.txtz1                                                      as OrderProdnRsceToolText,
       affh.objty                                                      as ProductionResourceType,
       affh.objid                                                      as ProductionResourceInternalID,
       affh.steuf                                                      as ProdnRsceToolControlProfile,
       cast( crfh.fhmar as mpe_fhmar preserving type )                 as ProdnRsceToolCategory,
       @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolStdWorkQtyUnit'
       affh.mgvgw                                                      as ProdnRsceToolStandardWorkQty,
       @Semantics.unitOfMeasure: true
       affh.mgeinh                                                     as ProdnRsceToolStdWorkQtyUnit,

       _MaintenanceOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AFFH",
"AFIH",
"AFKO",
"AFVC",
"CRFH"
],
"ASSOCIATED":
[
"I_MAINTENANCEORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More