FCCX_V_Task_exec_p

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 FCCX_V_Task_exec_p.
-- 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.

CREATE VIEW FCCX_V_Task_exec_p AS
SELECT
  A.execuuid AS execuuid,
  txn.is_test_run AS IS_TEST_RUN,
  A.created_on AS created_on,
  A.created_by AS created_by,
  A.task AS task,
  TMD.task AS task_tm,
  A.text AS text,
  A.profile AS profile,
  A.item AS item,
  A.instance AS instance,
  A.job_name AS job_name,
  A.job_count AS job_count,
  concat('AFC-', concat ( concat( upper( A.profile ), concat('-', ltrim( substring( cast( A.instance as sstring ), 5, 3), '0') ) ), concat( concat('-', ltrim( substring( A.item, 1, 6 ), '0' ) ), concat('-', ltrim( substring( A.item, 7, 6 ), '0' ) ) ) ) ) as TaskID AS item760asTaskID,
  A.task_uuid AS task_uuid,
  TMD.APJ_Job_template_name AS APJ_Job_template_name,
  TMD.APJ_job_catalog_entry_name AS APJ_job_catalog_entry_name,
  TMD.Report_Name AS Report_Name,
  TMD.CheckModeParameter AS CheckModeParameter,
  TMD.TestRunParameter AS TestRunParameter,
  TMD.UpdateRunParameter AS UpdateRunParameter,
  TMD.tasktype AS tasktype,
  TMD.bttype AS bttype,
  B.status AS status,
  B.strtdate AS strtdate,
  B.strttime AS strttime,
  B.enddate AS enddate,
  B.endtime AS endtime,
  dats_tims_to_tstmp( B.strtdate, B.strttime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as StartTimeStamp AS clientNULLasStartTimeStamp,
  dats_tims_to_tstmp( B.enddate, B.endtime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as EndTimeStamp AS clientNULLasEndTimeStamp,
  tstmp_seconds_between( dats_tims_to_tstmp( B.strtdate, B.strttime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ), dats_tims_to_tstmp( B.enddate, B.endtime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ), 'NULL') as DurationInSecs AS clientNULLNULLasDurationInSecs,
  A.kokrs AS kokrs,
  A.bukrs AS bukrs,
  A.werks AS werks,
  A.cgrop AS cgrop,
  A.cunit AS cunit,
  TMD.bttypeexists AS bttypeexists,
  case when TMD.task = A.task then 'X' else ' ' end as taskmodelexists AS taskthenXelseendastaskmodelexists,
  A.bttype_val AS bttype_val,
  A.report_val AS report_val
FROM fccx_task_exec_p AS A
LEFT OUTER JOIN FCCX_V_Task_Meta_Data AS TMD ON /* join condition not captured in parsed metadata */
INNER JOIN fccx_task_exec_t AS txn ON /* join condition not captured in parsed metadata */
;