P_GroupReportingLineItem

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 P_GroupReportingLineItem.
-- 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: PGRLINEITEM

CREATE VIEW P_GroupReportingLineItem AS
SELECT
  cast('' as gu_recid) AS gl_sirid,
  rldnr,
  cast('0' as rrcty) AS rrcty,
  rvers,
  ryear,
  rtcur,
  rhcur,
  rkcur,
  runit,
  cast('' as shkzg) AS drcrk,
  poper,
  docct,
  docnr,
  docln,
  rcomp,
  rdimen,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rpflg,
  rtflg,
  docty,
  yracq,
  pracq,
  coicu,
  tsl,
  hsl,
  ksl,
  cast(msl as fincs_quan) AS msl,
  sgtxt,
  autom,
  activ,
  bvorg,
  budat,
  wsdat,
  refdocnr,
  refryear,
  refdocln,
  refdocct,
  refactiv,
  cpudt,
  cputm,
  usnam,
  rvsdocnr,
  orndocnr,
  coiac,
  coinr,
  revyear,
  awtyp,
  aworg,
  logsys,
  timestamp,
  racct,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  rmvct,
  matnr,
  werks,
  kunnr,
  lifnr,
  ps_posid,
  ps_pspid,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  zuonr,
  aufnr,
  xblnr,
  matkl_mm,
  ps_psp_pnr,
  ktopl,
  cast('A' as fincs_jrnl_entry_item_origin) AS CnsldtnJrnlEntryItemOrigin,
  cast('00000000000000000000000' as fis_fp_request_tsn) AS FinancialPlanningReqTransSqnc,
  cast('000000' as fis_fp_data_packet) AS FinancialPlanningDataPacket,
  cast(0 as fis_fp_entry_item) AS FinancialPlanningEntryItem,
  cast(rldnr_fin as fins_ledger) AS rldnr_fin,
  cast('0' as fincs_adhocitem) AS adhocitem,
  cast('0' as fincs_adhocset) AS adhocset,
  cast( '00000000' as fincs_adhocsetitem) AS adhocsetitem,
  cast('' as ica_rcode ) AS rcode,
  cast('' as fincs_orig_ref ) AS orig_ref,
  cast('' as fincs_orig_type ) AS orig_type,
  cast('' as fincs_bunnr ) AS bunnr,
  cast( '' as fincs_financialservicesbranch ) AS branch_id,
  cast( '' as fincs_financialmanagementarea ) AS fikrs,
  cast( '' as fincs_fund ) AS rfund,
  cast( '' as fincs_grant ) AS rgrant_nbr,
  cast( '' as fincs_cashledgerchartofaccts ) AS re_ktopl,
  cast( '' as fincs_cashledgeraccount ) AS re_account,
  cast( '' as fincs_partnerfund ) AS sfund,
  cast( '' as fincs_ghgscope ) AS ghgscope,
  cast( '' as fincs_ghgcategory ) AS ghgcategory,
  cast( '' as fincs_ghgenergymix ) AS ghgenergymix
FROM P_ReportedFinancialData_RL
-- UNION ALL with additional select branch(es): P_PlanData_RL, I_CnsldtnGroupJrnlEntryItem, P_CnsldtnDataWCnsldtnLogicYTD
;