I_MAINTORDEROPPRODNRSCETOOL

CDS View

Maintenance Order Operation PRT

I_MAINTORDEROPPRODNRSCETOOL is a CDS View in S/4HANA. Maintenance Order Operation PRT. It contains 11 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 11 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_MaintOrderOpProdnRsceToolTP view_entity from TRANSACTIONAL Maintenance Order Operation PRT TP

Fields (11)

KeyField CDS FieldsUsed in Views
KEY MaintenanceOrder MaintenanceOrder 1
KEY MaintenanceOrderOperation MaintenanceOrderOperation 1
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation 1
KEY ProdnRsceToolItemNumber ProdnRsceToolItemNumber 1
OrderProdnRsceToolText OrderProdnRsceToolText 1
ProdnRsceToolCategory ProdnRsceToolCategory 1
ProdnRsceToolControlProfile ProdnRsceToolControlProfile 1
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty 1
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit 1
ProductionResourceInternalID ProductionResourceInternalID 1
ProductionResourceType ProductionResourceType 1 
@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