P_ActPlnSemTagMarginUnion

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_ActPlnSemTagMarginUnion.
-- 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.
-- Parameters: P_GLAccountHierarchy : fins_sem_tag_hryid

CREATE VIEW P_ActPlnSemTagMarginUnion AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  ActlSemTagMargin.LedgerGLLineItem AS LedgerGLLineItem,
  cast('00000000000000000000000' as fis_fp_request_tsn preserving type ) AS FinancialPlanningReqTransSqnc,
  cast('000000' as fis_fp_data_packet preserving type ) AS FinancialPlanningDataPacket,
  cast(0 as fis_fp_entry_item_new) AS FinancialPlanningEntryItem,
  SemanticTag,
  CurrencyField,
  cast( 'X' as fins_xsemtag_calculated preserving type ) AS LineIsSemTagCalculated,
  cast( 'A' as fis_actual_plan_code preserving type ) AS ActualPlanCode,
  cast( 'ACT01' as fcom_category ) AS PlanningCategory,
  LedgerFiscalYear,
  FiscalPeriod,
  PostingDate,
  ProfitCenter,
  OriginProfitCenter,
  SoldProduct,
  SoldProductGroup,
  Customer,
  CustomerGroup,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  OrderID,
  OrderCategory,
  ConditionContract,
  FiscalYearPeriod,
  ChartOfAccounts,
  GLAccount,
  SalesOrganization,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  ShipToParty,
  BillToParty,
  ControllingArea,
  CostSourceUnit,
  BusinessTransactionType,
  SubLedgerAcctLineItemType,
  DistributionChannel,
  OrganizationDivision,
  BaseUnit,
  OrderType,
  Segment,
  WBSElement,
  WBSElementInternalID,
  ProjectNetwork,
  FunctionalArea,
  Plant,
  FiscalYearVariant,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  ServiceContractType,
  AccountAssignmentType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  Project,
  ProjectInternalID,
  ProjectExternalID,
  Supplier,
  AccountingDocumentType,
  FinancialAccountType,
  CostCenter,
  AssetClass,
  ValuationArea,
  BillableControl,
  ServicesRenderedDate,
  Material,
  WorkPackage,
  WorkItem,
  CostAnalysisResource,
  TimeSheetOvertimeCategory,
  PersonnelNumber,
  OriginCostCtrActivityType,
  PartnerCostCtrActivityType,
  IsCommitment,
  ControllingDebitCreditCode,
  Currency,
  AmountInDisplayCurrency,
  FixedAmountInDspCrcy,
  BilledRevenueAmtInDspCrcy,
  ActualSalesDdctdInDspCrcy,
  ActualCostAmtInDspCrcy,
  ActlFixedCostInDspCrcy,
  RevenueAdjustmentAmtInDspCrcy,
  COGSAdjustmentAmtInDspCrcy,
  DeferredRevenueAmtInDspCrcy,
  DeferredCOGSAmtInDspCrcy,
  AccruedRevenueAmtInDspCrcy,
  AccruedCOGSAmtInDspCrcy,
  ImminentLossRsrvAmtInDspCrcy,
  SalesDeductReserveAmtInDspCrcy,
  UnrlzdCostsReserveAmtInDspCrcy,
  ProjAndSlsOrdStkAmtInDspCrcy,
  RecognizedMargAmtInDisplayCrcy,
  RecognizedRevnAmtInDspCrcy,
  RecognizedCOGSAmtInDspCrcy,
  CostOfGoodsSoldAmtInDspCrcy,
  FxdCOGSAmtInDspCrcy,
  PriceDiffAmtInDisplayCrcy,
  AdminOverheadAmtInDspCrcy,
  SalesOverheadAmtInDspCrcy,
  MarketingOvhdAmtInDspCrcy,
  RnDOverheadAmtInDspCrcy,
  MnlContrAccrPnLItmAmtInDspCrcy,
  UnbilledRevnInDspCrcy,
  MnlContrAccrBalShtAmtInDspCrcy,
  WIPProjAmtInDspCrcy,
  MatlStkAmtInDspCrcy,
  WIPProdnAmtInDspCrcy,
  DownPaymentAmountInDspCrcy,
  Quantity,
  TimeConfirmationAmtInDspCrcy,
  ConfirmedHoursQuantity,
  BilledHoursQuantity,
  WIPHoursQuantity,
  WIPAmtInDisplayCurrency,
  PlannedCosAmtInDspCrcy,
  BdgtCtrldBdgtCostInDspCrcy
FROM P_ActlSemTagMarginMultiCrcy AS ActlSemTagMargin
-- UNION ALL with additional select branch(es): P_PlnSemTagMarginMultiCrcy
;