I_WorkPermitType

DDL: I_WORKPERMITTYPE SQL: IWRKPMTTYPE Type: view BASIC

Work Permit Type

I_WorkPermitType is a Basic CDS View that provides data about "Work Permit Type" in SAP S/4HANA. It reads from 1 data source (ptwpermittype) and exposes 7 fields with key fields MaintenancePlanningPlant, WorkPermitType. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
ptwpermittype ptwpermittype from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_WorkPermitTypeText _WorkPermitTypeText $projection.WorkPermitType = _WorkPermitTypeText.WorkPermitType and $projection.MaintenancePlanningPlant = _WorkPermitTypeText.MaintenancePlanningPlant and _WorkPermitTypeText.Language = $session.system_language
[1..1] I_PermitToWorkProfile _PermitToWorkProfile $projection.MaintenancePlanningPlant = _PermitToWorkProfile.MaintenancePlanningPlant

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IWRKPMTTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
EndUserText.label Work Permit Type view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey WorkPermitType view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlanningPlant iwerk
KEY WorkPermitType workpermittype
WorkPermitTypeDescription _WorkPermitTypeText WorkPermitTypeDescription
_WorkPermitTypeText _WorkPermitTypeText
_PermitToWorkProfile _PermitToWorkProfile
InternalNumberRangeInterval int_range
ExternalNumberRangeInterval ext_range 
@AbapCatalog.sqlViewName: 'IWRKPMTTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@Search.searchable: true
@EndUserText.label: 'Work Permit Type'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'WorkPermitType'
define view I_WorkPermitType
  as select from ptwpermittype
  association [1..1] to I_WorkPermitTypeText  as _WorkPermitTypeText  on  $projection.WorkPermitType           = _WorkPermitTypeText.WorkPermitType
                                                                      and $projection.MaintenancePlanningPlant = _WorkPermitTypeText.MaintenancePlanningPlant
                                                                      and _WorkPermitTypeText.Language         = $session.system_language
  association [1..1] to I_PermitToWorkProfile as _PermitToWorkProfile on  $projection.MaintenancePlanningPlant = _PermitToWorkProfile.MaintenancePlanningPlant
{

      @Search: {defaultSearchElement: true, ranking: #HIGH}
      @Consumption.filter.hidden: true
    key  iwerk          as MaintenancePlanningPlant,
      @Search: {defaultSearchElement: true, ranking: #HIGH}
      @Semantics.text
      @ObjectModel.text.element: ['WorkPermitTypeDescription']
      @Consumption.filter.hidden: true
      @EndUserText: { label: 'Work Permit Type', quickInfo: 'Work Permit Type' }
    key workpermittype as WorkPermitType,
      @Consumption.filter.hidden: true
      @EndUserText: { label: 'Work Permit Type Description', quickInfo: 'Work Permit Type Description' }
      _WorkPermitTypeText.WorkPermitTypeDescription,
      @Consumption.filter.hidden: true
      _WorkPermitTypeText,
      _PermitToWorkProfile,
      @UI.hidden: true
      int_range      as InternalNumberRangeInterval,
      @UI.hidden: true
      ext_range      as ExternalNumberRangeInterval
}
where
  wrkpmtusagetype = 'P' ;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKPERMITTYPETEXT",
"PTWPERMITTYPE"
],
"ASSOCIATED":
[
"I_PERMITTOWORKPROFILE",
"I_WORKPERMITTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More