I_CntrbtScenWrkrOplCndnTP

DDL: I_CNTRBTSCENWRKROPLCNDNTP Type: view TRANSACTIONAL

Operational Condition - TP

I_CntrbtScenWrkrOplCndnTP is a Transactional CDS View that provides data about "Operational Condition - TP" in SAP S/4HANA. It reads from 1 data source (I_CntrbtScenOplCndn) and exposes 14 fields with key field PCESOperationalConditionUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CntrbtScenOplCndn I_CntrbtScenOplCndn from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRsltPCESWrkrAssmtTP _CmplRqRslt $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ICRROPRCONTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Operational Condition - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence EHSDSW_CS_WRKOC view
ObjectModel.writeActivePersistence EHSDSV_CS_OC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.entityChangeStateId LastChangeDateTime view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PCESOperationalConditionUUID PCESOperationalConditionUUID
ComplianceAssessmentUUIDCmplRqRsltUUID
TypeofusePCESUseTypePhrsUUID
AmbienttemperatureunitPCESAmbientTempUoM
RoomsizelowervaluePCESRoomSizeLowrValue
RoomsizeuppervaluePCESRoomSizeUprValue
RoomsizeunitPCESRoomSizeUnitPhrsUUID
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
_CmplRqRslt _CmplRqRslt
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
@AbapCatalog:
{
  sqlViewName: 'ICRROPRCONTP',
  compiler.compareFilter: true,
  preserveKey: true
}

@EndUserText.label: 'Operational Condition - TP'

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  modelCategory: #BUSINESS_OBJECT,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  writeDraftPersistence: 'EHSDSW_CS_WRKOC',
  writeActivePersistence: 'EHSDSV_CS_OC',
  semanticKey:  [ 'PCESOperationalConditionUUID' ],
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
  },
  entityChangeStateId: 'LastChangeDateTime'
}
define view I_CntrbtScenWrkrOplCndnTP
  as select from I_CntrbtScenOplCndn

  association [1..1] to I_CmplRqRsltPCESWrkrAssmtTP as _CmplRqRslt on $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID

{

  key PCESOperationalConditionUUID,

      --Compliance Assessment UUID
      @ObjectModel.mandatory: true
      CmplRqRsltUUID,

      --Outdoor indoor
      PCESOutdoorIndoorActyPhrsUUID,

      --Type of use
      PCESUseTypePhrsUUID,

      --Ambient temp condition
      PCESAmbientTempCndnPhrsUUID,

      --Ambient temperature - Lower value
      PCESAmbientTempLowrValue,

      --Ambient temperature lower value text
      PCESAmbientTempLowrValueTxt,

      --Ambient temperature Lower value optr
      PCESAmbientTempLowrValueOptr,

      --Ambient temperature upper value
      PCESAmbientTempUprValue,

      --Ambient temperature upper value text
      PCESAmbientTempUprValueTxt,

      --Ambient temperature upper value optr
      PCESAmbientTempUprValueOptr,

      --Ambient temperature unit
      PCESAmbientTempUoM,

      --Ventilation rate condition
      PCESVentnRateCndnPhrsUUID,

      --Ventilation rate lower value
      PCESVentnRateLowrValue,

      --Ventilation rate lower value text
      PCESVentnRateLowrValueTxt,

      --Ventilation rate lower value optr
      PCESVentnRateLowrValueOptr,

      --Ventilation rate upper value
      PCESVentnRateUprValue,

      --Ventilation rate upper value text
      PCESVentnRateUprValueTxt,

      --Ventilation rate upper value optr
      PCESVentnRateUprValueOptr,

      --Room size condition
      PCESRoomSizeCndnPhrsUUID,

      --Room size lower value
      PCESRoomSizeLowrValue,

      --Room size lower value
      PCESRoomSizeLowrValueTxt,

      --Room size lower value text
      PCESRoomSizeLowrValueOptr,

      --Room size upper value
      PCESRoomSizeUprValue,

      --Room size upper value text
      PCESRoomSizeUprValueTxt,

      --Room size upper value optr
      PCESRoomSizeUprValueOptr,

      --Room size unit
      PCESRoomSizeUnitPhrsUUID,


      @ObjectModel.readOnly: true
      CreationDateTime,

      @ObjectModel.readOnly: true
      CreatedByUser,

      @ObjectModel.readOnly: true
      LastChangeDateTime,

      @ObjectModel.readOnly: true
      LastChangedByUser,


      /* Associations */
      //      _RegisteredBy,

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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNTRBTSCENOPLCNDN"
],
"ASSOCIATED":
[
"I_CMPLRQRSLTPCESWRKRASSMTTP",
"I_USER"
],
"BASE":
[
"I_CNTRBTSCENOPLCNDN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/