I_CmplRqRsltProtHandTP

DDL: I_CMPLRQRSLTPROTHANDTP SQL: ICRRPPMHANDTP Type: view TRANSACTIONAL

Personal Protection Measures Hand

I_CmplRqRsltProtHandTP is a Transactional CDS View that provides data about "Personal Protection Measures Hand" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRsltProtHand) and exposes 29 fields with key field CmplRqRsltProtHandUUID. It has 2 associations to related views.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltProtHand I_CmplRqRsltProtHand from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRsltProtTP _CmplRqRsltProt $projection.CmplRqRsltUUID = _CmplRqRsltProt.CmplRqRsltUUID
[0..*] I_CmplRqRsltProtHandRatgTP _CmplRqRsltProtHandRatg $projection.CmplRqRsltProtHandUUID = _CmplRqRsltProtHandRatg.PCPrptyParentUUID

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName ICRRPPMHANDTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Personal Protection Measures Hand view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CmplRqRsltProtHandUUID view
ObjectModel.semanticKey CmplRqRsltProtHandUUID view
ObjectModel.transactionalProcessingUnitRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeActivePersistence EHFNDD_PPM_HAND view
ObjectModel.writeDraftPersistence EHFNDW_PPM_HAND view
ObjectModel.entityChangeStateId LastChangeDateTime view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltProtHandUUID CmplRqRsltProtHandUUID
CmplRqRsltUUID CmplRqRsltUUID
PCPrptySequence PCPrptySequence
PrsnlProtGloveMaterialTypeUUID PrsnlProtGloveMaterialTypeUUID
PrsnlProtGloveProtIndexUUID PrsnlProtGloveProtIndexUUID
PrsnlProtGloveAddlStmntUUID PrsnlProtGloveAddlStmntUUID
PrsnlProtGloveMaxWearDurn PrsnlProtGloveMaxWearDurn
PrsnlProtWearDurnLowrQtyOptr PrsnlProtWearDurnLowrQtyOptr
PrsnlProtGloveMaxWearDurnTxt PrsnlProtGloveMaxWearDurnTxt
PrsnlProtWearDurnUpperQty PrsnlProtWearDurnUpperQty
PrsnlProtWearDurnUpperQtyOptr PrsnlProtWearDurnUpperQtyOptr
PrsnlProtWearDurnUpperQtyTxt PrsnlProtWearDurnUpperQtyTxt
PrsnlProtGloveMaxWearDurnUnit PrsnlProtGloveMaxWearDurnUnit
PrsnlProtGloveThicknessQty PrsnlProtGloveThicknessQty
PrsnlProtThicknessLowrQtyOptr PrsnlProtThicknessLowrQtyOptr
PrsnlProtGloveThicknessQtyTxt PrsnlProtGloveThicknessQtyTxt
PrsnlProtThicknessUpperQty PrsnlProtThicknessUpperQty
PrsnlProtThicknessUpperQtyOptr PrsnlProtThicknessUpperQtyOptr
PrsnlProtThicknessUpperQtyTxt PrsnlProtThicknessUpperQtyTxt
PrsnlProtGloveThicknessUnit PrsnlProtGloveThicknessUnit
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
_CmplRqRsltProt _CmplRqRsltProt
_CmplRqRslt _CmplRqRslt
_CmplRqRsltProtHandRatg _CmplRqRsltProtHandRatg
_OperatorLowrLmtHandWear _OperatorLowrLmtHandWear
_OperatorLowrLmtThickness _OperatorLowrLmtThickness 
@AbapCatalog.sqlViewName: 'ICRRPPMHANDTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl:{
    authorizationCheck: #CHECK,
    privilegedAssociations: ['_CmplRqRsltProtHandRatg']
}
@EndUserText.label: 'Personal Protection Measures Hand'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    representativeKey: 'CmplRqRsltProtHandUUID',
    semanticKey: 'CmplRqRsltProtHandUUID',
    transactionalProcessingUnitRoot: true,
    transactionalProcessingEnabled:true,
    createEnabled:true,
    updateEnabled:true,
    deleteEnabled:true,
    writeActivePersistence: 'EHFNDD_PPM_HAND',
    writeDraftPersistence:  'EHFNDW_PPM_HAND',
    entityChangeStateId: 'LastChangeDateTime',
    usageType: {
        serviceQuality: #C,
        sizeCategory:  #L,
        dataClass: #TRANSACTIONAL
    }
}
define view I_CmplRqRsltProtHandTP
  as select from I_CmplRqRsltProtHand
  association [1..1] to I_CmplRqRsltProtTP         as _CmplRqRsltProt         on $projection.CmplRqRsltUUID = _CmplRqRsltProt.CmplRqRsltUUID
  association [0..*] to I_CmplRqRsltProtHandRatgTP as _CmplRqRsltProtHandRatg on $projection.CmplRqRsltProtHandUUID = _CmplRqRsltProtHandRatg.PCPrptyParentUUID
{
  key CmplRqRsltProtHandUUID,
      @ObjectModel.foreignKey.association: '_CmplRqRsltProt'
      CmplRqRsltUUID,
      PCPrptySequence,

      @ObjectModel.mandatory: true
      PrsnlProtGloveMaterialTypeUUID,
      PrsnlProtGloveProtIndexUUID,
      PrsnlProtGloveAddlStmntUUID,

      PrsnlProtGloveMaxWearDurn,
      PrsnlProtWearDurnLowrQtyOptr,
      PrsnlProtGloveMaxWearDurnTxt,

      PrsnlProtWearDurnUpperQty,
      PrsnlProtWearDurnUpperQtyOptr,
      PrsnlProtWearDurnUpperQtyTxt,

      PrsnlProtGloveMaxWearDurnUnit,

      PrsnlProtGloveThicknessQty,
      PrsnlProtThicknessLowrQtyOptr,
      PrsnlProtGloveThicknessQtyTxt,

      PrsnlProtThicknessUpperQty,
      PrsnlProtThicknessUpperQtyOptr,
      PrsnlProtThicknessUpperQtyTxt,

      PrsnlProtGloveThicknessUnit,

      CreationDateTime,
      CreatedByUser,
      LastChangeDateTime,
      LastChangedByUser,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _CmplRqRsltProt,
      _CmplRqRslt,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CmplRqRsltProtHandRatg,

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

Learn More