I_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 I_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: IGRLINEITEM

CREATE VIEW I_GroupReportingLineItem AS
SELECT
  rldnr AS ConsolidationLedger,
  rdimen AS ConsolidationDimension,
  ryear AS FiscalYear,
  docnr AS ConsolidationDocumentNumber,
  docln AS ConsolidationPostingItem,
  cast (rrcty as fincs_rrcty preserving type ) AS GLRecordType,
  rvers AS ConsolidationVersion,
  rtcur AS TransactionCurrency,
  rhcur AS LocalCurrency,
  rkcur AS GroupCurrency,
  runit AS BaseUnit,
  poper AS FiscalPeriod,
  docty AS ConsolidationDocumentType,
  drcrk AS DebitCreditCode,
  rcomp AS Company,
  cast ( rbunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  ritclg AS ConsolidationChartOfAccounts,
  ritem AS FinancialStatementItem,
  cast ( rbuptr as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  rcongr AS ConsolidationGroup,
  robukrs AS CompanyCode,
  sityp AS SubItemCategory,
  subit AS SubItem,
  plevl AS PostingLevel,
  rpflg AS ConsolidationApportionment,
  rtflg AS CurrencyConversionsDiffType,
  yracq AS ConsolidationAcquisitionYear,
  pracq AS ConsolidationAcquisitionPeriod,
  cast ( coicu as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  tsl AS AmountInTransactionCurrency,
  hsl AS AmountInLocalCurrency,
  ksl AS AmountInGroupCurrency,
  msl AS QuantityInBaseUnit,
  sgtxt AS DocumentItemText,
  autom AS ConsolidationPostgItemAutoFlag,
  activ AS BusinessTransactionType,
  budat AS PostingDate,
  wsdat AS CurrencyTranslationDate,
  refdocnr AS RefConsolidationDocumentNumber,
  refryear AS ReferenceFiscalYear,
  refdocln AS RefConsolidationPostingItem,
  refdocct AS RefConsolidationDocumentType,
  refactiv AS RefBusinessTransactionType,
  timestamp AS CreationDateTime,
  cpudt AS CreationDate,
  cputm AS CreationTime,
  usnam AS UserID,
  rvsdocnr AS ReverseDocument,
  orndocnr AS ReversedDocument,
  coiac AS InvestmentActivityType,
  coinr AS InvestmentActivity,
  revyear AS ConsolidationDocReversalYear,
  awtyp AS ReferenceDocumentType,
  aworg AS ReferenceDocumentContext,
  logsys AS LogicalSystem,
  ktopl AS ChartOfAccounts,
  racct AS GLAccount,
  zuonr AS AssignmentReference,
  rcntr AS CostCenter,
  prctr AS ProfitCenter,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  kokrs AS ControllingArea,
  Segment,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  psegment AS PartnerSegment,
  aufnr AS OrderID,
  kunnr AS Customer,
  lifnr AS Supplier,
  matnr AS Material,
  matkl_mm AS MaterialGroup,
  werks AS Plant,
  rmvct AS FinancialTransactionType,
  ps_psp_pnr AS WBSElementInternalID,
  ps_pspid AS Project,
  gl_sirid AS ConsolidationRecordNumber,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldMaterial,
  matnr_copa AS SoldProduct,
  matkl AS SoldProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  konzs AS CustomerSupplierCorporateGroup,
  CnsldtnJrnlEntryItemOrigin,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  rldnr_fin AS Ledger,
  adhocitem AS CnsldtnAdhocItem,
  adhocset AS CnsldtnAdhocSet,
  adhocsetitem AS CnsldtnAdhocSetItem,
  rcode AS MatchingReasonCode,
  orig_ref AS OriginReference,
  orig_type AS OriginType,
  bunnr AS CnsldtnGroupJrnlEntryBundle,
  cast ( fs_product_group as fincs_finsrvcsproductgroup preserving type ) AS FinancialServicesProductGroup,
  cast ( branch_id as fincs_financialservicesbranch preserving type ) AS FinancialServicesBranch,
  cast ( datasource_id as fincs_financialdatasource preserving type ) AS FinancialDataSource,
  cast ( fikrs as fincs_financialmanagementarea preserving type) AS FinancialManagementArea,
  cast ( rfund as fincs_fund preserving type ) AS Fund,
  cast ( rgrant_nbr as fincs_grant preserving type ) AS GrantID,
  cast ( re_ktopl as fincs_cashledgerchartofaccts preserving type ) AS CnsldtnCashLedgerChartOfAccts,
  cast ( re_account as fincs_cashledgeraccount preserving type ) AS CashLedgerAccount,
  cast ( sfund as fincs_partnerfund preserving type ) AS PartnerFund,
  cast ( ghgscope as fincs_ghgscope preserving type ) AS GHGScope,
  cast ( ghgcategory as fincs_ghgcategory preserving type ) AS GHGCategory,
  cast ( ghgscp2calcmeth as fincs_ghgscp2calculationmethod preserving type ) AS GHGScope2CalculationMethod,
  cast ( ghgscp2contrinstr as fincs_ghgscp2cntrctlinstrument preserving type ) AS GHGScope2ContractualInstrument,
  cast ( susmodeoftransport as fincs_sustmodeoftransport preserving type ) AS SustainabilityModeOfTransport,
  cast ( ghgdtaqltycharc as fincs_ghgdtaqltycharc preserving type ) AS GHGDataQualityCharacteristic,
  cast ( ghgenergyclass as fincs_ghgenergyclassification preserving type ) AS GHGEnergyClassification,
  cast ( ghgenergymix as fincs_ghgenergymix preserving type ) AS GHGEnergyMix,
  cast ( ghgengysrcgtype as fincs_ghgenergysourcingtype preserving type ) AS GHGEnergySourcingType
FROM P_GroupReportingLineItem
;