I_WorkPermitApprvlSgmt

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_WorkPermitApprvlSgmt.
-- 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: IWRKPMTAPVRLSGMT

CREATE VIEW I_WorkPermitApprvlSgmt AS
SELECT
  wcagns.objnr AS WorkPermitInternalID,
  wcagns.counter AS NumberOfWrkPermitApprovals,
  wcagns.counters AS WrkPermitApprvlSgmt,
  _WorkPermitBasic.WorkPermit AS WorkPermit,
  wcagns.genname AS WrkPermitApprvlEnteredByUsr,
  wcagns.gendatum AS WrkPermitApprvlEntryDate,
  wcagns.gentime AS WrkPermitApprvlEntryTime,
  cast( dats_tims_to_tstmp(wcagns.gendatum , wcagns.gentime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as timestamp ) as ApprovalDateTime AS clientNULLastimestampasApprovalDateTime,
  wcagns.genvdate AS WrkPermitAprvdFromDate,
  wcagns.genbdate AS WrkPermitAprvdToDate,
  wcagns.genvtime AS WrkPermitAprvdFromTime,
  wcagns.genbtime AS WrkPermitAprvdToTime,
  wcagns.geniname AS WrkPermitApprvlDactvtdByUsr,
  wcagns.genidate AS WrkPmtApprvlDeactivationDate,
  wcagns.genitime AS WrkPmtApprvlDeactivationTime,
  wcagns.geniakt AS WrkPermitApprvlSgmtIsInactive,
  wcagns.workpermitapprovalcomment AS WorkPermitApprovalComment,
  _WorkPermitBasic.WrkPmtMgmtObjSubType AS WrkPmtMgmtObjSubType,
  _WorkPermitApproval.WorkPermitApprovalDescription AS WorkPermitApprovalDescription,
  case when _WorkPermitApproval.WorkPermitHasLongText = 'X' or _WorkPermitApproval.WorkPermitHasLongText = '' then cast (concat( concat(wcagns.objnr, wcagns.counter ),wcagns.counters ) as tdobname ) else '' end as TextObjectKey AS countersastdobnameelseendasTextObjectKey
FROM wcagns
INNER JOIN I_WorkPermitBasic AS _WorkPermitBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkPermitApproval AS _WorkPermitApproval ON _WorkPermitApproval.WorkPermitInternalID = WorkPermitInternalID AND _WorkPermitApproval.NumberOfWrkPermitApprovals = NumberOfWrkPermitApprovals  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = WrkPermitApprvlEnteredByUsr  -- association [1..1]
LEFT OUTER JOIN I_User AS _RejectByUser ON _RejectByUser.UserID = WrkPermitApprvlDactvtdByUsr  -- association [1..1]
;