P_CnsldtnGrpJEItem_A

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_CnsldtnGrpJEItem_A.
-- 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 P_CnsldtnGrpJEItem_A AS
SELECT
  ryear AS FiscalYear,
  docnr AS ConsolidationDocumentNumber,
  docln AS ConsolidationPostingItem,
  poper AS FiscalPeriod,
  cast('PER' as fincs_period_mode) AS PeriodMode,
  rcongr AS ConsolidationGroup,
  rdimen AS ConsolidationDimension,
  cast('0' as rrcty) AS GLRecordType,
  rvers AS ConsolidationVersion,
  rvers AS ConsolidationVersionElement,
  rtcur AS TransactionCurrency,
  rhcur AS LocalCurrency,
  rkcur AS GroupCurrency,
  runit AS BaseUnit,
  fiscyearper AS FiscalYearPeriod,
  docty AS ConsolidationDocumentType,
  cast('' as shkzg) AS DebitCreditCode,
  rcomp AS Company,
  rbunit AS ConsolidationUnit,
  ritclg AS ConsolidationChartOfAccounts,
  ritem AS FinancialStatementItem,
  rbuptr AS PartnerConsolidationUnit,
  robukrs AS CompanyCode,
  sityp AS SubItemCategory,
  subit AS SubItem,
  plevl AS PostingLevel,
  rpflg AS ConsolidationApportionment,
  rtflg AS CurrencyConversionsDiffType,
  yracq AS ConsolidationAcquisitionYear,
  pracq AS ConsolidationAcquisitionPeriod,
  coicu AS InvesteeConsolidationUnit,
  tsl AS AmountInTransactionCurrency,
  hsl AS AmountInLocalCurrency,
  ksl AS AmountInGroupCurrency,
  cast(msl as fincs_quan) AS CnsldtnQuantityInBaseUnit,
  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,
  werks AS Plant,
  rmvct AS FinancialTransactionType,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matkl_mm AS MaterialGroup,
  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,
  cast('0' as fincs_adhocitem) AS CnsldtnAdhocItem,
  cast('0' as fincs_adhocset) AS CnsldtnAdhocSet,
  cast('00000000' as fincs_adhocsetitem) AS CnsldtnAdhocSetItem,
  cast('' as ica_rcode) AS MatchingReasonCode,
  cast('' as fincs_orig_type) AS OriginType,
  cast('' as fincs_orig_ref) AS OriginReference,
  cast('' as fincs_finsrvcsproductgroup) AS FinancialServicesProductGroup,
  cast('' as fincs_financialservicesbranch) AS FinancialServicesBranch,
  cast('' as fincs_financialdatasource) AS FinancialDataSource,
  cast('' as fincs_ghgdtaqltycharc) AS GHGDataQualityCharacteristic,
  cast('' as fincs_ghgenergyclassification) AS GHGEnergyClassification,
  cast('' as fincs_ghgenergymix) AS GHGEnergyMix,
  cast('' as fincs_ghgenergysourcingtype) AS GHGEnergySourcingType,
  cast('' as fincs_ghgcategory) AS GHGCategory,
  cast('' as fincs_ghgscope) AS GHGScope,
  cast('' as fincs_ghgscp2calculationmethod) AS GHGScope2CalculationMethod,
  cast('' as fincs_ghgscp2cntrctlinstrument) AS GHGScope2ContractualInstrument,
  cast('' as fincs_sustmodeoftransport) AS SustainabilityModeOfTransport,
  cast('' as fincs_financialmanagementarea) AS FinancialManagementArea,
  cast('' as fincs_fund) AS Fund,
  cast('' as fincs_grant) AS GrantID,
  cast('' as fincs_cashledgerchartofaccts) AS CnsldtnCashLedgerChartOfAccts,
  cast('' as fincs_cashledgeraccount) AS CashLedgerAccount,
  cast('' as bp_p_geber) AS PartnerFund,
  cast('A' as fincs_jrnl_entry_item_origin) AS CnsldtnJrnlEntryItemOrigin
FROM P_ReportedFinancialData_RL
;