I_CnsldtnGrpJrnlItemDSt

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_CnsldtnGrpJrnlItemDSt.
-- 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_CnsldtnGrpJrnlItemDSt AS
SELECT
  docid,
  version,
  doctag,
  docqprov,
  tra_00001,
  sva_00001,
  tra_00002,
  sva_00002,
  tra_00003,
  sva_00003,
  svh_00003,
  hnm_00003,
  hno_00003,
  hio_00003,
  tra_00004,
  sva_00004,
  tra_00005,
  sva_00005,
  tra_00006,
  sva_00006,
  tra_00007,
  sva_00007,
  tra_00008,
  sva_00008,
  tra_00009,
  sva_00009,
  tra_00010,
  sva_00010,
  tra_00011,
  sva_00011,
  tra_00012,
  sva_00012,
  tra_00013,
  sva_00013,
  svh_00013,
  hnm_00013,
  hno_00013,
  hio_00013,
  tra_baseunit,
  sva_baseunit,
  tra_company,
  sva_company,
  tra_customer,
  sva_customer,
  svh_customer,
  hnm_customer,
  hno_customer,
  hio_customer,
  tra_fund,
  sva_fund,
  tra_grantid,
  sva_grantid,
  tra_material,
  sva_material,
  svh_material,
  hnm_material,
  hno_material,
  hio_material,
  tra_orderid,
  sva_orderid,
  tra_plant,
  sva_plant,
  svh_plant,
  hnm_plant,
  hno_plant,
  hio_plant,
  tra_project,
  sva_project,
  svh_project,
  hnm_project,
  hno_project,
  hio_project,
  tra_segment,
  sva_segment,
  svh_segment,
  hnm_segment,
  hno_segment,
  hio_segment,
  tra_subitem,
  sva_subitem,
  svh_subitem,
  hnm_subitem,
  hno_subitem,
  hio_subitem,
  tra_supplier,
  sva_supplier,
  svh_supplier,
  hnm_supplier,
  hno_supplier,
  hio_supplier,
  tra_userid,
  sva_userid,
  tra_00014,
  sva_00014,
  svh_00014,
  hnm_00014,
  hno_00014,
  hio_00014,
  tra_00015,
  sva_00015,
  tra_00016,
  sva_00016,
  svh_00016,
  hnm_00016,
  hno_00016,
  hio_00016,
  tra_00017,
  sva_00017,
  svh_00017,
  hnm_00017,
  hno_00017,
  hio_00017,
  tra_00018,
  sva_00018,
  tra_00019,
  sva_00019,
  tra_00020,
  sva_00020,
  tra_00021,
  sva_00021,
  tra_00022,
  sva_00022,
  tra_00023,
  sva_00023,
  tra_00024,
  sva_00024,
  tra_00025,
  sva_00025,
  tra_00026,
  sva_00026,
  tra_00027,
  sva_00027,
  tra_00028,
  sva_00028,
  svh_00028,
  hnm_00028,
  hno_00028,
  hio_00028,
  tra_00029,
  sva_00029,
  svh_00029,
  hnm_00029,
  hno_00029,
  hio_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,
  svh_00034,
  hnm_00034,
  hno_00034,
  hio_00034,
  tra_00035,
  sva_00035,
  svh_00035,
  hnm_00035,
  hno_00035,
  hio_00035,
  tra_00036,
  sva_00036,
  svh_00036,
  hnm_00036,
  hno_00036,
  hio_00036,
  tra_00037,
  sva_00037,
  tra_00038,
  sva_00038,
  svh_00038,
  hnm_00038,
  hno_00038,
  hio_00038,
  tra_00039,
  sva_00039,
  svh_00039,
  hnm_00039,
  hno_00039,
  hio_00039,
  tra_00040,
  sva_00040,
  tra_00041,
  sva_00041,
  svh_00041,
  hnm_00041,
  hno_00041,
  hio_00041,
  tra_00042,
  sva_00042,
  svh_00042,
  hnm_00042,
  hno_00042,
  hio_00042,
  tra_00043,
  sva_00043,
  tra_00044,
  sva_00044,
  tra_00045,
  sva_00045,
  svh_00045,
  hnm_00045,
  hno_00045,
  hio_00045,
  tra_00046,
  sva_00046,
  tra_00047,
  sva_00047,
  svh_00047,
  hnm_00047,
  hno_00047,
  hio_00047,
  tra_00048,
  sva_00048,
  tra_00049,
  sva_00049,
  svh_00049,
  hnm_00049,
  hno_00049,
  hio_00049,
  tra_00050,
  sva_00050,
  svh_00050,
  hnm_00050,
  hno_00050,
  hio_00050,
  tra_00051,
  sva_00051,
  tra_00052,
  sva_00052,
  svh_00052,
  hnm_00052,
  hno_00052,
  hio_00052,
  tra_00053,
  sva_00053,
  svh_00053,
  hnm_00053,
  hno_00053,
  hio_00053,
  tra_00054,
  sva_00054,
  tra_00055,
  sva_00055,
  svh_00055,
  hnm_00055,
  hno_00055,
  hio_00055,
  tra_00056,
  sva_00056,
  tra_00057,
  sva_00057,
  svh_00057,
  hnm_00057,
  hno_00057,
  hio_00057,
  tra_00058,
  sva_00058,
  tra_00059,
  sva_00059,
  tra_00060,
  sva_00060,
  tra_00061,
  sva_00061,
  svh_00061,
  hnm_00061,
  hno_00061,
  hio_00061,
  tra_00062,
  sva_00062,
  tra_00063,
  sva_00063,
  svh_00063,
  hnm_00063,
  hno_00063,
  hio_00063,
  tra_00064,
  sva_00064,
  tra_00065,
  sva_00065,
  tra_00066,
  sva_00066,
  tra_00067,
  sva_00067,
  tra_00068,
  sva_00068,
  tra_00069,
  sva_00069,
  tra_00070,
  sva_00070,
  tra_00071,
  sva_00071,
  tra_00072,
  sva_00072,
  svh_00072,
  hnm_00072,
  hno_00072,
  hio_00072,
  tra_00073,
  sva_00073,
  svh_00073,
  hnm_00073,
  hno_00073,
  hio_00073,
  tra_00074,
  sva_00074,
  tra_00075,
  sva_00075,
  tra_00076,
  sva_00076,
  tra_00077,
  sva_00077,
  tra_00078,
  sva_00078,
  tra_00081,
  sva_00081,
  tra_00082,
  sva_00082,
  tra_00083,
  sva_00083,
  doctype,
  owner,
  infoprov,
  sva_infoprov,
  kyfnm,
  docstat,
  session_id,
  timestamp,
  document,
  seldr,
  docprop
FROM icnsldt_doc
;