P_ACTPLNSTATKEYFIGITEMSEMTAG

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_ACTPLNSTATKEYFIGITEMSEMTAG.
-- 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: PFIACTPLNSEMUN

CREATE VIEW P_ACTPLNSTATKEYFIGITEMSEMTAG AS
SELECT
  Ledger,
  cast('' as fins_ledger_pers) AS SourceLedger,
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  StatisticalKeyFigureItem,
  cast('' as fis_belnr ) AS AccountingDocument,
  cast('' as fis_docln) AS LedgerGLLineItem,
  cast('' as fis_fp_request_tsn ) AS FinancialPlanningReqTransSqnc,
  cast('' as fis_fp_data_packet) AS FinancialPlanningDataPacket,
  cast(0 as fis_fp_entry_item) AS FinancialPlanningEntryItem,
  cast ('' as fins_sem_tag_hryid) AS GLAccountHierarchy,
  cast('' as fins_sem_tag) AS SemanticTag,
  cast('' as datab ) AS ValidityStartDate,
  cast('' as datab) AS ValidityEndDate,
  StatisticalKeyFigure,
  cast( FiscalYear as fis_ryear ) AS LedgerFiscalYear,
  StatisticalKeyFigureCategory,
  CostCenter,
  ProfitCenter,
  ControllingArea,
  FunctionalArea,
  cast('' as fis_sfkber) AS PartnerFunctionalArea,
  cast('' as fis_budat) AS PostingDate,
  FiscalYearPeriod,
  FiscalYearVariant,
  StatisticalKeyFigQtyUnit,
  StatisticalKeyFigureQuantity,
  cast('' as fcom_category) AS PlanningCategory,
  cast('' as fis_hwaer) AS CompanyCodeCurrency,
  cast(0 as fis_hsl) AS AmountInCompanyCodeCurrency,
  cast(0 as fis_hsl_inverted) AS InvertedAmtInCoCodeCurrency,
  cast('' as fis_rkcur) AS GlobalCurrency,
  cast(0 as fis_ksl) AS AmountInGlobalCurrency,
  cast(0 as fis_ksl_inverted) AS InvertedAmountInGlobalCurrency,
  cast('' as fis_rocur) AS FreeDefinedCurrency1,
  cast(0 as fis_osl) AS AmountInFreeDefinedCurrency1,
  cast(cast( 'SK' as abap.char (2)) as fis_actlpln_skf_code) AS ActualPlanStatKeyFigureCode,
  cast('' as profidproj) AS ProjectProfileCode,
  cast('' as profidproj) AS PartnerProjectProfileCode,
  cast('' as fis_paccas) AS PartnerAccountAssignment,
  cast('' as fis_paccasty) AS PartnerAccountAssignmentType,
  cast('' as bktxt) AS AccountingDocumentHeaderText,
  cast('' as fins_sem_tag_group) AS SemanticTagGroup,
  cast('' as ttet_dt_cr_time) AS CreationTime,
  cast('' as fis_cpdat) AS CreationDate,
  cast('' as fis_usnam) AS AccountingDocCreatedByUser,
  cast('' as pernr_d) AS PersonnelNumber,
  cast('' as fis_ktopl) AS ChartOfAccounts,
  cast('' as fis_racct) AS GLAccount,
  cast('' as accas) AS AccountAssignment,
  AccountAssignmentType,
  BusinessArea,
  Segment,
  OrderID,
  SalesOrder AS SalesDocument,
  ServiceDocument,
  ServiceDocumentType,
  ControllingBusTransacType,
  cast('' as md_supplier) AS Supplier,
  cast('' as kunnr) AS Customer,
  cast('' as fis_blart) AS AccountingDocumentType,
  cast('' as farp_koart) AS FinancialAccountType,
  cast('' as vkorg ) AS SalesOrganization,
  cast('' as vtweg) AS DistributionChannel,
  cast('' as fis_spart) AS OrganizationDivision,
  cast('' as werks_d) AS Plant,
  cast('' as anlkl) AS AssetClass,
  cast('' as fcom_category) AS SKFPlanningCategory,
  ActualPlanCode,
  ValuationArea
FROM I_FinStatisticalKeyFigureItem
-- UNION ALL with additional select branch(es): I_ActlPlnLineItemSemTagGLAcct
;