I_EngmntPrjMargOvwDSt

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_EngmntPrjMargOvwDSt.
-- 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 I_EngmntPrjMargOvwDSt AS
SELECT
  docid,
  version,
  doctag,
  docqprov,
  tra_00001,
  sva_00001,
  tra_supplier,
  sva_supplier,
  tra_00002,
  sva_00002,
  tra_00003,
  sva_00003,
  tra_00004,
  sva_00004,
  tra_customer,
  sva_customer,
  svh_customer,
  hnm_customer,
  hno_customer,
  hio_customer,
  tra_00005,
  sva_00005,
  tra_00006,
  sva_00006,
  tra_workitem,
  sva_workitem,
  tra_00007,
  sva_00007,
  tra_00008,
  sva_00008,
  tra_project,
  sva_project,
  tra_orderid,
  sva_orderid,
  tra_00009,
  sva_00009,
  svh_00009,
  hnm_00009,
  hno_00009,
  hio_00009,
  tra_00010,
  sva_00010,
  tra_00011,
  sva_00011,
  tra_00012,
  sva_00012,
  svh_00012,
  hnm_00012,
  hno_00012,
  hio_00012,
  tra_00013,
  sva_00013,
  svh_00013,
  hnm_00013,
  hno_00013,
  hio_00013,
  tra_00014,
  sva_00014,
  svh_00014,
  hnm_00014,
  hno_00014,
  hio_00014,
  cast( tra_00015 as fis_fp_entry_item_new ) AS tra_00015,
  sva_00015,
  tra_00016,
  sva_00016,
  tra_00017,
  sva_00017,
  tra_currency,
  sva_currency,
  tra_00018,
  sva_00018,
  tra_00019,
  sva_00019,
  tra_ledger,
  sva_ledger,
  tra_00020,
  sva_00020,
  tra_00021,
  sva_00021,
  tra_00022,
  sva_00022,
  tra_00023,
  sva_00023,
  svh_00023,
  hnm_00023,
  hno_00023,
  hio_00023,
  tra_00024,
  sva_00024,
  svh_00024,
  hnm_00024,
  hno_00024,
  hio_00024,
  tra_00025,
  sva_00025,
  tra_plant,
  sva_plant,
  svh_plant,
  hnm_plant,
  hno_plant,
  hio_plant,
  tra_00026,
  sva_00026,
  tra_c1,
  sva_c1,
  tra_00027,
  sva_00027,
  tra_00028,
  sva_00028,
  svh_00028,
  hnm_00028,
  hno_00028,
  hio_00028,
  tra_material,
  sva_material,
  tra_00029,
  sva_00029,
  tra_00030,
  sva_00030,
  tra_00031,
  sva_00031,
  tra_00032,
  sva_00032,
  svh_00032,
  hnm_00032,
  hno_00032,
  hio_00032,
  tra_00033,
  sva_00033,
  tra_00034,
  sva_00034,
  tra_00035,
  sva_00035,
  tra_00036,
  sva_00036,
  tra_00037,
  sva_00037,
  tra_00038,
  sva_00038,
  tra_00039,
  sva_00039,
  tra_00040,
  sva_00040,
  tra_00041,
  sva_00041,
  tra_00042,
  sva_00042,
  tra_00043,
  sva_00043,
  tra_00044,
  sva_00044,
  svh_00044,
  hnm_00044,
  hno_00044,
  hio_00044,
  tra_00045,
  sva_00045,
  tra_00046,
  sva_00046,
  tra_00047,
  sva_00047,
  svh_00047,
  hnm_00047,
  hno_00047,
  hio_00047,
  tra_00048,
  sva_00048,
  svh_00048,
  hnm_00048,
  hno_00048,
  hio_00048,
  tra_00049,
  sva_00049,
  tra_00050,
  sva_00050,
  svh_00050,
  hnm_00050,
  hno_00050,
  hio_00050,
  tra_00051,
  sva_00051,
  tra_00052,
  sva_00052,
  tra_00053,
  sva_00053,
  tra_segment,
  sva_segment,
  tra_00054,
  sva_00054,
  tra_00055,
  sva_00055,
  tra_00056,
  sva_00056,
  tra_00057,
  sva_00057,
  tra_baseunit,
  sva_baseunit,
  doctype,
  owner,
  infoprov,
  sva_infoprov,
  kyfnm,
  docstat,
  session_id,
  timestamp,
  document,
  seldr,
  docprop
FROM iengmntprdsttab
;