I_WorkPermitTechnicalObject

DDL: I_WORKPERMITTECHNICALOBJECT SQL: ITECHOBJLIST Type: view BASIC

Work Permit Technical Object

I_WorkPermitTechnicalObject is a Basic CDS View that provides data about "Work Permit Technical Object" in SAP S/4HANA. It reads from 2 data sources (I_WorkPermitBasic, wcaod) and exposes 10 fields with key fields WorkPermitInternalID, TechnicalObject, SftyCertItemCatType. It has 4 associations to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkPermitBasic _WorkPermitBasic inner
wcaod wcaod from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_Equipment _Equipment $projection.TechnicalObject = _Equipment.Equipment
[1..1] I_EquipmentText _EquipmentText $projection.TechnicalObject = _EquipmentText.Equipment and _EquipmentText.Language = $session.system_language
[1..1] I_FunctionalLocation _FunctionalLocation $projection.TechnicalObject = _FunctionalLocation.FunctionalLocation
[1..1] I_FunctionalLocationText _FunctionalLocationText $projection.TechnicalObject = _FunctionalLocationText.FunctionalLocation and _FunctionalLocationText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ITECHOBJLIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Work Permit Technical Object view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY WorkPermitInternalID wcaod objnr
KEY TechnicalObject wcaod ccobj
KEY SftyCertItemCatType wcaod cctyp
WorkPermit I_WorkPermitBasic WorkPermit
MaintenancePlanningPlant I_WorkPermitBasic MaintenancePlanningPlant
TechObjCnctntdActvSystSts
_Equipment _Equipment
_EquipmentText _EquipmentText
_FunctionalLocation _FunctionalLocation
_FunctionalLocationText _FunctionalLocationText 
@AbapCatalog.sqlViewName: 'ITECHOBJLIST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Work Permit Technical Object'
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
define view I_WorkPermitTechnicalObject
 as select from wcaod
 inner join   I_WorkPermitBasic as _WorkPermitBasic on wcaod.objnr = _WorkPermitBasic.WorkPermitInternalID
 association [1..1] to I_Equipment                as _Equipment              on  $projection.TechnicalObject = _Equipment.Equipment
 association [1..1] to I_EquipmentText            as _EquipmentText          on  $projection.TechnicalObject = _EquipmentText.Equipment
                                                                             and _EquipmentText.Language     = $session.system_language
 association [1..1] to I_FunctionalLocation       as _FunctionalLocation     on  $projection.TechnicalObject = _FunctionalLocation.FunctionalLocation                                                                             
 association [1..1] to I_FunctionalLocationText   as _FunctionalLocationText on  $projection.TechnicalObject = _FunctionalLocationText.FunctionalLocation
                                                                             and _FunctionalLocationText.Language = $session.system_language                                                                             
{
  key wcaod.objnr                                                                                    as WorkPermitInternalID,
  key wcaod.ccobj                                                                                    as TechnicalObject,
  key wcaod.cctyp                                                                                    as SftyCertItemCatType,
      _WorkPermitBasic.WorkPermit,
      _WorkPermitBasic.MaintenancePlanningPlant                                                      as MaintenancePlanningPlant,
      case when wcaod.cctyp = 'E' then cast ( 'Equipment' as  eams_tec_obj_type_desc)
           when wcaod.cctyp = 'F' then cast ( 'Functional Location' as  eams_tec_obj_type_desc ) end as TechObjIsEquipOrFuncnlLocDesc,
      cast ('' as vdm_j_system_status_concat_t) as TechObjCnctntdActvSystSts,
  // Associations

      _Equipment,
      _EquipmentText,
      _FunctionalLocation,
      _FunctionalLocationText
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKPERMITBASIC",
"WCAOD"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_EQUIPMENTTEXT",
"I_FUNCTIONALLOCATION",
"I_FUNCTIONALLOCATIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More