I_WORKPERMITBASIC

CDS View

Work Permit

I_WORKPERMITBASIC is a CDS View in S/4HANA. Work Permit. It contains 40 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 40 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_WorkPermit view_entity from COMPOSITE Work Permit
I_WorkPermitApprvlSgmt view inner BASIC Work Permit Approval Segment
I_WorkPermitIssueHistory view inner BASIC Hand Out Work Permit history
I_WorkPermitOrder view_entity inner BASIC Work Permit Assigned Orders
I_WorkPermitSafetyCertificate view_entity inner COMPOSITE Safety Certificate in Work Permit
I_WorkPermitStatus view inner BASIC Work Permit Status
I_WorkPermitTechnicalObject view inner BASIC Work Permit Technical Object
I_WorkPermitTemplate view from COMPOSITE Work Permit Template
I_WrkPmtTmplSftyCertTemplate view_entity inner COMPOSITE Wrk Pmt Tmpl Sfty Cert Template
P_WorkPermitCube view_entity from COMPOSITE Work Permit - Cube

Fields (40)

KeyField CDS FieldsUsed in Views
KEY WorkPermit WorkPermit 9
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationDateTime CreationDateTime 2
CreationTime CreationTime 2
Equipment Equipment 2
FunctionalLocation FunctionalLocation 2
LastChangeDate LastChangeDate 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
LastChangeTime LastChangeTime 2
LongTextKey LongTextKey 2
MaintenancePlannerGroup MaintenancePlannerGroup 2
MaintenancePlanningPlant MaintenancePlanningPlant 4
ObjectTypeCode ObjectTypeCode 2
OperationWorkCenterInternalID OperationWorkCenterInternalID 2
PlantTimeZone PlantTimeZone 1
StatusProfile StatusProfile 2
TechObjAuthorizationGroup TechObjAuthorizationGroup 2
ValidFromDateTime ValidFromDateTime 2
ValidToDateTime ValidToDateTime 2
WorkPermitHasLongText WorkPermitHasLongText 2
WorkPermitInternalID WorkPermitInternalID 2
WorkPermitOperationLongTextKey WorkPermitOperationLongTextKey 2
WorkPermitProcessingStatus WorkPermitProcessingStatus 3
WorkPermitTmplID WorkPermitTmplID 2
WorkPermitType WorkPermitType 3
WrkPermitDesc WrkPermitDesc 3
WrkPermitHasMaintRemark WrkPermitHasMaintRemark 2
WrkPermitHasObjectList WrkPermitHasObjectList 2
WrkPermitHasOpRemark WrkPermitHasOpRemark 2
WrkPermitIsDeleted WrkPermitIsDeleted 2
WrkPermitIsLinkdToDoc WrkPermitIsLinkdToDoc 2
WrkPermitValidFrmDate WrkPermitValidFrmDate 2
WrkPermitValidFrmTime WrkPermitValidFrmTime 2
WrkPermitValidToDate WrkPermitValidToDate 2
WrkPermitValidToTime WrkPermitValidToTime 2
WrkPmtMaintenanceLongTextKey WrkPmtMaintenanceLongTextKey 2
WrkPmtMgmtObjSubType WrkPmtMgmtObjSubType 4
WrkPmtMgmtPriority WrkPmtMgmtPriority 2 
@AbapCatalog.sqlViewName: 'IWRKPMTBASIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory:#L , dataClass:#TRANSACTIONAL }
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'WorkPermit'
@ObjectModel.semanticKey: ['WorkPermit']
@EndUserText.label: 'Work Permit'

define view I_WorkPermitBasic
  as select from wcaap
{
  key wapinr                                             as WorkPermit,
      objnr                                              as WorkPermitInternalID,
      wapityp                                            as WrkPmtMgmtObjSubType,
      wapiuse                                            as WorkPermitType,
      @Semantics.text :true
      stxt                                               as WrkPermitDesc,
      lflg                                               as WorkPermitHasLongText,
      delflg                                             as WrkPermitIsDeleted,
      ingrp                                              as MaintenancePlannerGroup,
      iwerk                                              as MaintenancePlanningPlant,
      wkcrtyp                                            as ObjectTypeCode,
      wkcrid                                             as OperationWorkCenterInternalID,
      begru                                              as TechObjAuthorizationGroup,
      datefr                                             as WrkPermitValidFrmDate,
      timefr                                             as WrkPermitValidFrmTime,
      dateto                                             as WrkPermitValidToDate,
      timeto                                             as WrkPermitValidToTime,
      priok                                              as WrkPmtMgmtPriority,
      cast ( tplnr as eams_ui_oid_name preserving type ) as FunctionalLocation,
      equnr                                              as Equipment,
      lnkflg                                             as WrkPermitHasObjectList,
      @Semantics.user.createdBy: true
      crname                                             as CreatedByUser,
      crdate                                             as CreationDate,
      crtime                                             as CreationTime,
      @Semantics.systemDateTime.createdAt: true
      cast( dats_tims_to_tstmp( wcaap.crdate,
                        wcaap.crtime,
                        abap_system_timezone( $session.client,'NULL' ),
                        $session.client,
                       'NULL' ) as timestamp )           as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      chname                                             as LastChangedByUser,
      chname                                             as VersionLastChangedByUser,
      chdate                                             as LastChangeDate,
      chtime                                             as LastChangeTime,
      @Semantics.systemDateTime.lastChangedAt: true
      cast( dats_tims_to_tstmp( wcaap.chdate,
                       wcaap.chtime,
                       abap_system_timezone( $session.client,'NULL' ),
                       $session.client,
                      'NULL' ) as timestamp )            as LastChangeDateTime,
      cast( dats_tims_to_tstmp( wcaap.datefr,
                   wcaap.timefr,
                   abap_system_timezone( $session.client,'NULL' ),
                   $session.client,
                  'NULL' ) as timestamp )                as ValidFromDateTime,
      cast($session.user_timezone as tznzone)            as PlantTimeZone,
      cast( dats_tims_to_tstmp( wcaap.dateto,
                          wcaap.timeto,
                          abap_system_timezone( $session.client,'NULL' ),
                          $session.client,
                         'NULL' ) as timestamp )         as ValidToDateTime,
      docflg                                             as WrkPermitIsLinkdToDoc,
      wapistsma                                          as StatusProfile,
      refobj                                             as WorkPermitTmplID,

      remarkflg1                                         as WrkPermitHasMaintRemark,
      remarkflg2                                         as WrkPermitHasOpRemark,
      case wcaap.remarkflg2
             when 'X' then cast(concat(wcaap.objnr, 'REM2') as tdobname)
             else '' end                                 as WorkPermitOperationLongTextKey,

      case wcaap.remarkflg1
        when 'X' then cast( concat( wcaap.objnr,'REM1') as tdobname)
        else '' end                                      as WrkPmtMaintenanceLongTextKey,

      case wcaap.lflg
       when 'X' then cast(concat(wcaap.objnr, 'LTXT' ) as tdobname)
       else '' end                                       as LongTextKey,
      workpermitprocessingstatus                         as WorkPermitProcessingStatus
}
where
     wapityp = 'P'
  or wapityp = 'M'

Learn More