P_Matrix_CP_GroupEmpty_2

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_Matrix_CP_GroupEmpty_2.
-- 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: PMCPGRPE2
-- Parameters: P_ConsolidationGroup : fc_congr, P_FromFiscalYearPeriod : fincs_fiscyearper, P_ToFiscalYearPeriod : fincs_fiscyearper

CREATE VIEW P_Matrix_CP_GroupEmpty_2 AS
SELECT
  $session.client AS rclnt,
  ConsolidationLedger AS rldnr,
  ConsolidationDimension AS rdimen,
  FiscalYear AS ryear,
  CnsldtnGroupJrnlEntry AS docnr,
  CnsldtnGroupJrnlEntryItem AS docln,
  cast('0' as fc_rrcty) AS rrcty,
  ConsolidationVersion AS rvers,
  TransactionCurrency AS rtcur,
  LocalCurrency AS rhcur,
  GroupCurrency AS rkcur,
  BaseUnit AS runit,
  cast('' as shkzg preserving type) AS drcrk,
  FiscalPeriod AS poper,
  FiscalYearPeriod AS fiscyearper,
  cast('PER' as fincs_period_mode) AS period_mode,
  DocumentCategory AS docct,
  Company AS rcomp,
  ConsolidationUnit AS rbunit,
  ConsolidationChartOfAccounts AS ritclg,
  FinancialStatementItem AS ritem,
  PartnerConsolidationUnit AS rbuptr,
  ConsolidationGroup AS rcongr,
  CompanyCode AS robukrs,
  SubItemCategory AS sityp,
  SubItem AS subit,
  PostingLevel AS plevl,
  ConsolidationApportionment AS rpflg,
  CurrencyConversionsDiffType AS rtflg,
  ConsolidationDocumentType AS docty,
  ConsolidationAcquisitionYear AS yracq,
  ConsolidationAcquisitionPeriod AS pracq,
  InvesteeConsolidationUnit AS coicu,
  InvestorConsolidationUnit AS uppcu,
  AmountInTransactionCurrency AS tsl,
  AmountInLocalCurrency AS hsl,
  AmountInGroupCurrency AS ksl,
  CnsldtnQuantityInBaseUnit AS msl,
  CnsldtnCstmSignAmtInTransCrcy AS tsl_csign,
  CnsldtnCstmSignAmtInLoclCrcy AS hsl_csign,
  CnsldtnCstmSignAmtInGrpCrcy AS ksl_csign,
  CnsldtnCstmSignLongQtyInBsUnit AS msl_csign,
  DocumentItemText AS sgtxt,
  ConsolidationPostgItemAutoFlag AS autom,
  BusinessTransactionType AS activ,
  '' AS bvorg,
  PostingDate AS budat,
  CurrencyTranslationDate AS wsdat,
  RefConsolidationDocumentNumber AS refdocnr,
  ReferenceFiscalYear AS refryear,
  RefConsolidationPostingItem AS refdocln,
  RefConsolidationDocumentType AS refdocct,
  RefBusinessTransactionType AS refactiv,
  CreationDateTime AS timestamp,
  CreationDate AS cpudt,
  CreationTime AS cputm,
  UserID AS usnam,
  ReverseDocument AS rvsdocnr,
  ReversedDocument AS orndocnr,
  InvestmentActivityType AS coiac,
  InvestmentActivity AS coinr,
  ConsolidationDocReversalYear AS revyear,
  ReferenceDocumentType AS awtyp,
  ReferenceDocumentContext AS aworg,
  LogicalSystem AS logsys,
  ChartOfAccounts AS ktopl,
  GLAccount AS racct,
  '' AS xblnr,
  AssignmentReference AS zuonr,
  CostCenter AS rcntr,
  ProfitCenter AS prctr,
  FunctionalArea AS rfarea,
  BusinessArea AS rbusa,
  ControllingArea AS kokrs,
  segment,
  PartnerCostCenter AS scntr,
  PartnerProfitCenter AS pprctr,
  PartnerFunctionalArea AS sfarea,
  PartnerBusinessArea AS sbusa,
  PartnerCompany AS rassc,
  PartnerSegment AS psegment,
  OrderID AS aufnr,
  Customer AS kunnr,
  Supplier AS lifnr,
  Material AS matnr,
  MaterialGroup AS matkl_mm,
  Plant AS werks,
  FinancialTransactionType AS rmvct,
  WBSElementInternalID AS ps_psp_pnr,
  WBSElementExternalID AS ps_posid,
  Project AS ps_pspid,
  BillingDocumentType AS fkart,
  SalesOrganization AS vkorg,
  DistributionChannel AS vtweg,
  OrganizationDivision AS spart,
  SoldMaterial AS matnr_copa,
  SoldProductGroup AS matkl,
  CustomerGroup AS kdgrp,
  CustomerSupplierCountry AS land1,
  CustomerSupplierIndustry AS brsch,
  SalesDistrict AS bzirk,
  BillToParty AS kunre,
  ShipToParty AS kunwe,
  CustomerSupplierCorporateGroup AS konzs,
  CnsldtnAdhocItem AS adhocitem,
  CnsldtnAdhocSet AS adhocset,
  CnsldtnAdhocSetItem AS adhocsetitem,
  MatchingReasonCode AS rcode,
  OriginType AS orig_type,
  OriginReference AS orig_ref,
  CnsldtnGroupJrnlEntryBundle AS bunnr,
  FinancialServicesBranch AS branch_id,
  ghgscope,
  ghgcategory,
  ghgenergymix,
  FinancialManagementArea AS fikrs,
  Fund AS rfund,
  GrantID AS rgrant_nbr,
  CnsldtnCashLedgerChartOfAccts AS re_ktopl,
  CashLedgerAccount AS re_account,
  PartnerFund AS bp_p_geber
FROM P_CnsldtnGroupJrnlEntryItem
;