I_CMPLRQRSLTPROTHAND

CDS View

Personal Protection Measures Hand Basic

I_CMPLRQRSLTPROTHAND is a CDS View in S/4HANA. Personal Protection Measures Hand Basic. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmplRqRsltProtHandTP view from TRANSACTIONAL Personal Protection Measures Hand 
@AbapCatalog.sqlViewName: 'ICRRPPMHAND'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel:
{
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #B
  }
}
@Search.searchable: false
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Personal Protection Measures Hand Basic'
define view I_CmplRqRsltProtHand
  as select from ehfndd_ppm_hand
  association [1..1] to I_CmplRqRslt         as _CmplRqRslt               on $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID
  --Link to operators
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
  association [0..1] to I_PCPrptyOptrLowrLmt as _OperatorLowrLmtHandWear  on $projection.PrsnlProtWearDurnLowrQtyOptr = _OperatorLowrLmtHandWear.PCPrptyLowrLmtOptr
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
  association [0..1] to I_PCPrptyOptrLowrLmt as _OperatorLowrLmtThickness on $projection.PrsnlProtThicknessLowrQtyOptr = _OperatorLowrLmtThickness.PCPrptyLowrLmtOptr

{
      //ehfndd_ppm_hand

  key cmplrqrsltprothanduuid         as CmplRqRsltProtHandUUID,
      cmplrqrsltuuid                 as CmplRqRsltUUID,
      pcprptysequence                as PCPrptySequence,
      prsnlprotglovematerialtypeuuid as PrsnlProtGloveMaterialTypeUUID,
      prsnlprotgloveprotindexuuid    as PrsnlProtGloveProtIndexUUID,
      prsnlprotgloveaddlstmntuuid    as PrsnlProtGloveAddlStmntUUID,

      prsnlprotglovemaxweardurn      as PrsnlProtGloveMaxWearDurn,
      prsnlprotglovemaxweardurntxt   as PrsnlProtGloveMaxWearDurnTxt,
      prsnlprotweardurnlowrqtyoptr   as PrsnlProtWearDurnLowrQtyOptr,

      prsnlprotweardurnupperqty      as PrsnlProtWearDurnUpperQty,
      prsnlprotweardurnupperqtyoptr  as PrsnlProtWearDurnUpperQtyOptr,
      prsnlprotweardurnupperqtytxt   as PrsnlProtWearDurnUpperQtyTxt,

      prsnlprotglovemaxweardurnunit  as PrsnlProtGloveMaxWearDurnUnit,

      prsnlprotglovethicknessqty     as PrsnlProtGloveThicknessQty,
      prsnlprotglovethicknessqtytxt  as PrsnlProtGloveThicknessQtyTxt,
      prsnlprotthicknesslowrqtyoptr  as PrsnlProtThicknessLowrQtyOptr,

      prsnlprotthicknessupperqty     as PrsnlProtThicknessUpperQty,
      prsnlprotthicknessupperqtyoptr as PrsnlProtThicknessUpperQtyOptr,
      prsnlprotthicknessupperqtytxt  as PrsnlProtThicknessUpperQtyTxt,

      prsnlprotglovethicknessunit    as PrsnlProtGloveThicknessUnit,


      // ADMIN FIELDS

      @Semantics.systemDateTime.createdAt: true
      creationdatetime               as CreationDateTime,
      @Semantics.user.createdBy: true
      createdbyuser                  as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime             as LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      lastchangedbyuser              as LastChangedByUser,

      _CmplRqRslt,
      _OperatorLowrLmtHandWear,
      _OperatorLowrLmtThickness
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDD_PPM_HAND"
],
"ASSOCIATED":
[
"I_CMPLRQRSLT",
"I_PCPRPTYOPTRLOWRLMT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More