I_WorkPermitBasic

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkPermitBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IWRKPMTBASIC

CREATE VIEW I_WorkPermitBasic AS
SELECT
  wapinr AS WorkPermit,
  objnr AS WorkPermitInternalID,
  wapityp AS WrkPmtMgmtObjSubType,
  wapiuse AS WorkPermitType,
  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,
  crname AS CreatedByUser,
  crdate AS CreationDate,
  crtime AS CreationTime,
  cast( dats_tims_to_tstmp( wcaap.crdate, wcaap.crtime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as timestamp ) as CreationDateTime AS clientNULLastimestampasCreationDateTime,
  chname AS LastChangedByUser,
  chname AS VersionLastChangedByUser,
  chdate AS LastChangeDate,
  chtime AS LastChangeTime,
  cast( dats_tims_to_tstmp( wcaap.datefr, wcaap.timefr, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as timestamp ) as ValidFromDateTime AS clientNULLastimestampasValidFromDateTime,
  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 AS clientNULLastimestampasValidToDateTime,
  docflg AS WrkPermitIsLinkdToDoc,
  wapistsma AS StatusProfile,
  refobj AS WorkPermitTmplID,
  remarkflg1 AS WrkPermitHasMaintRemark,
  remarkflg2 AS WrkPermitHasOpRemark,
  case wcaap.lflg when 'X' then cast(concat(wcaap.objnr, 'LTXT' ) as tdobname) else '' end as LongTextKey AS objnrLTXTastdobnameelseendasLongTextKey,
  WorkPermitProcessingStatus
FROM wcaap
;