P_InspSpecQuantityCtrl

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PINSPQTYCTRL' //must start with "P"

define view P_InspSpecQuantityCtrl //must start with "P_"; same as DDL source name in upper-camelcase notation

   as select from qpmk
   //---> Decomment if you want to join further data sources

   //left outer to one join DatabaseTableOrBasicCdsView2 

   //   on qpmk.FieldName = DatabaseTableOrBasicCdsView2.FieldName2

   
   association [0..1] to I_UnitOfMeasure as _UnitOfMeasure
      on  $projection.InspectionSpecificationUnit = _UnitOfMeasure.UnitOfMeasure

{
//   key DatabaseFieldName //usage of global field names and cast to data element with proper labels is optional

   key qpmk.zaehler     as InspectionSpecificationPlant,
   key qpmk.mkmnr       as InspectionSpecification,
   key qpmk.version     as InspectionSpecificationVersion,
   
   case substring(qpmk.steuerkz,1,1) // InspSpecIsQuantitative

        when 'X' then cast ( '1' as qchar_type_basic ) // = Quantitative

                 else cast ( '2' as qchar_type_basic ) // = Qualitative

   end                                                 as InspSpecCharacteristicType,
   
   /* Provide only the "not-initial" (aka NI) fields for quantities and the corresponding quantity fields */
   /* Re-use existing GFN                                                                                 */
   qpmk.stellen         as InspSpecDecimalPlaces, 
   qpmk.masseinhsw      as InspectionSpecificationUnit, 
   qpmk.sollwert        as InspSpecTargetValue, 
   qpmk.sollwni         as InspSpecHasTargetValue, 
   qpmk.toleranzob      as InspSpecUpperLimit, 
   qpmk.tolobni, 
   qpmk.toleranzun      as InspSpecLowerLimit, 
   qpmk.tolunni, 
//   qpmk.klasanzahl, 

//   qpmk.klasbreite, 

//   qpmk.klasbrni, 

//   qpmk.klasmitte, 

//   qpmk.klasmini, 

   qpmk.grenzeob1       as InspSpecFirstUpperSpecLimit, 
   qpmk.grenzob1ni, 
   qpmk.grenzeun1       as InspSpecFirstLowerSpecLimit, 
   qpmk.grenzun1ni, 
   qpmk.grenzeob2       as InspSpecSecondUpperSpecLimit, 
   qpmk.grenzob2ni, 
   qpmk.grenzeun2       as InspSpecSecondLowerSpecLimit, 
   qpmk.grenzun2ni, 
   qpmk.plausioben      as InspSpecUpperPlausibilityLimit, 
   qpmk.plausiobni, 
   qpmk.plausiunte      as InspSpecLowerPlausibilityLimit, 
   qpmk.plausiunni, 
   qpmk.tolerweiob      as InspSpecUpperSpecLimitChange, 
   qpmk.tolwobni, 
   qpmk.tolerweiun      as InspSpecLowerSpecLimitChange, 
   qpmk.tolwunni,
   
   _UnitOfMeasure._Text[1:Language=$session.system_language].UnitOfMeasureName,
   
   /* Associtions */
   _UnitOfMeasure
   
} 
      
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UNITOFMEASURE",
"I_UNITOFMEASURETEXT",
"QPMK"
],
"ASSOCIATED":
[
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/