I_WorkPermitBasic

DDL: I_WORKPERMITBASIC SQL: IWRKPMTBASIC Type: view BASIC

Work Permit

I_WorkPermitBasic is a Basic CDS View that provides data about "Work Permit" in SAP S/4HANA. It reads from 1 data source (wcaap) and exposes 38 fields with key field WorkPermit.

1 data source(s) 38 fields

Data Sources (1)

SourceAliasJoin Type
wcaap wcaap from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IWRKPMTBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey WorkPermit view
EndUserText.label Work Permit view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY WorkPermit wapinr
WorkPermitInternalID objnr
WrkPmtMgmtObjSubType wapityp
WorkPermitType wapiuse
WrkPermitDesc stxt
WorkPermitHasLongText lflg
WrkPermitIsDeleted delflg
MaintenancePlannerGroup ingrp
MaintenancePlanningPlant iwerk
ObjectTypeCode wkcrtyp
OperationWorkCenterInternalID wkcrid
TechObjAuthorizationGroup begru
WrkPermitValidFrmDate datefr
WrkPermitValidFrmTime timefr
WrkPermitValidToDate dateto
WrkPermitValidToTime timeto
WrkPmtMgmtPriority priok
FunctionalLocation
Equipment equnr
WrkPermitHasObjectList lnkflg
CreatedByUser crname
CreationDate crdate
CreationTime crtime
clientNULLastimestampasCreationDateTime
LastChangedByUser chname
VersionLastChangedByUser chname
LastChangeDate chdate
LastChangeTime chtime
clientNULLastimestampasValidFromDateTime
PlantTimeZone
clientNULLastimestampasValidToDateTime
WrkPermitIsLinkdToDoc docflg
StatusProfile wapistsma
WorkPermitTmplID refobj
WrkPermitHasMaintRemark remarkflg1
WrkPermitHasOpRemark remarkflg2
objnrLTXTastdobnameelseendasLongTextKey
WorkPermitProcessingStatus workpermitprocessingstatus 
@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WCAAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More