P_Actualplanlineitemsemtag

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_Actualplanlineitemsemtag.
-- 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: PFIAPGLACCTLITST

CREATE VIEW P_Actualplanlineitemsemtag AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  cast(cast('00000000000000000000000' as abap.numc(23))as fis_fp_request_tsn) AS FinancialPlanningReqTransSqnc,
  cast(cast('000000' as abap.numc(6)) as fis_fp_data_packet) AS FinancialPlanningDataPacket,
  cast(0 as fis_fp_entry_item_new) AS FinancialPlanningEntryItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  LedgerFiscalYear,
  cast(cast( 'A' as abap.char (1)) as fis_actual_plan_code) AS ActualPlanCode,
  FiscalQuarter,
  ChartOfAccounts,
  ControllingArea,
  FinancialTransactionType,
  BusinessTransactionType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  GLAccount,
  cast(cast('' as abap.char(50)) as /cpd/plan_item_id ) AS WorkPackage,
  cast(cast('' as abap.char(10)) as /cpd/pfp_workitem_id) AS WorkItem,
  BillableControl,
  cast(cast('' as abap.char(1)) as psknz) AS IsLotSizeIndependent,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FixedAmountInGlobalCrcy,
  GrpValnFixedAmtInGlobCrcy,
  PrftCtrValnFxdAmtInGlobCrcy,
  TotalPriceVarcInGlobalCrcy,
  GrpValnTotPrcVarcInGlobCrcy,
  PrftCtrValnTotPrcVarcInGlbCrcy,
  FixedPriceVarcInGlobalCrcy,
  GrpValnFixedPrcVarcInGlobCrcy,
  PrftCtrValnFxdPrcVarcInGlbCrcy,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  BaseUnit,
  Quantity,
  FixedQuantity,
  CostSourceUnit,
  ValuationQuantity,
  ValuationFixedQuantity,
  AdditionalQuantity1Unit,
  AdditionalQuantity1,
  AdditionalQuantity2Unit,
  AdditionalQuantity2,
  AdditionalQuantity3Unit,
  AdditionalQuantity3,
  DebitCreditCode,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  PostingKey,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  CreationDate,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  Material,
  Plant,
  Supplier,
  Customer,
  ServicesRenderedDate,
  ConditionContract,
  cast(cast( 'ACT01' as abap.char( 5 )) as fcom_category) AS PlanningCategory,
  ControllingDebitCreditCode,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  CostEstimate,
  InventorySpecialStockValnType,
  InvtrySpecialStockValnType_2,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InvtrySpclStockWBSElmntExtID,
  InventorySpclStockWBSElement,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  CostOriginGroup,
  OriginSenderObject,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElement,
  WBSElementExternalID,
  PartnerWBSElementInternalID,
  PartnerWBSElementExternalID,
  ProjectInternalID,
  WBSElementInternalID,
  Project,
  ProjectExternalID,
  PartnerProjectInternalID,
  PartnerProjectExternalID,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CostAnalysisResource,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrder_2,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerProject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  cast(cast('' as abap.char(2)) as spart) AS Division,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  SoldProduct,
  SoldProductGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  FinancialManagementArea,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  FundsCenter,
  FundedProgram,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  SettlementReferenceDate,
  WorkCenterInternalID,
  OrderOperation,
  OrderItem,
  OrderSuboperation,
  Equipment,
  FunctionalLocation,
  Assembly,
  MaintenanceActivityType,
  MaintenanceOrderPlanningCode,
  MaintPriorityType,
  MaintPriority,
  SuperiorOrder,
  MaintenanceOrderIsPlanned,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  DebitAmountInBalanceTransCrcy,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  DebitAmountInFreeDefinedCrcy1,
  CreditAmountInFreeDefinedCrcy1,
  DebitAmountInFreeDefinedCrcy2,
  CreditAmountInFreeDefinedCrcy2,
  DebitAmountInFreeDefinedCrcy3,
  CreditAmountInFreeDefinedCrcy3,
  DebitAmountInFreeDefinedCrcy4,
  CreditAmountInFreeDefinedCrcy4,
  DebitAmountInFreeDefinedCrcy5,
  CreditAmountInFreeDefinedCrcy5,
  DebitAmountInFreeDefinedCrcy6,
  CreditAmountInFreeDefinedCrcy6,
  DebitAmountInFreeDefinedCrcy7,
  CreditAmountInFreeDefinedCrcy7,
  DebitAmountInFreeDefinedCrcy8,
  CreditAmountInFreeDefinedCrcy8,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  cast(RevenueAmountInCompanyCodeCrcy as fis_revenue_hsl_a) AS ActualRevenueAmtInCCCrcy,
  cast(GrossRevenueAmtInCCCrcy as fis_gross_rev_hsl_a) AS ActlGrossRevenueAmtInCCCrcy,
  cast(RecognizedRevnAmtInCCCrcy as fis_reco_rev_hsl_a) AS ActlRecognizedRevnAmtInCCCrcy,
  cast(RecognizedRevnAmtInGlobCrcy as fis_reco_rev_ksl_a) AS ActlRecgdRevenueAmtInGlobCrcy,
  cast(RevenueAdjustmentAmtInCCCrcy as fis_adj_rev_hsl_a) AS ActlRevnAdjustmentAmtInCCCrcy,
  cast(DeferredRevenueAmtInCCCrcy as fis_def_rev_hsl_a) AS ActlDeferredRevenueAmtInCCCrcy,
  cast(AccruedRevenueAmtInCCCrcy as fis_acr_rev_hsl_a) AS ActlAccruedRevenueAmtInCCCrcy,
  cast(BilledRevenueAmtInCoCodeCrcy as fis_bill_rev_hsl_a) AS ActlBilledRevenueAmtInCCCrcy,
  cast(BilledRevenueAmtInGlobCrcy as fis_bill_rev_ksl_a) AS ActlBilledRevenueAmtInGlobCrcy,
  cast(RecognizedMarginAmtInCCCrcy as fis_rec_margin_hsl_a) AS ActlRecognizedMargAmtInCCCrcy,
  cast(CostAmountInCompanyCodeCrcy as fis_cost_hsl_a) AS ActualCostAmtInCCCrcy,
  cast(CostOfGoodsSoldAmtInGlobCrcy as fis_cogs_ksl_a) AS ActlCostOfGdsSoldAmtInGlobCrcy,
  cast(RecognizedCOGSAmtInCCCrcy as fis_reco_cos_hsl_a) AS ActlRecognizedCOGSAmtInCCCrcy,
  cast(COGSAdjustmentAmtInCCCrcy as fis_adj_cos_hsl_a) AS ActlCOGSAdjustmentAmtInCCCrcy,
  cast(DeferredCOGSAmtInCCCrcy as fis_def_cost_hsl_a) AS ActlDeferredCOGSAmtInCCCrcy,
  cast(AccruedCOGSAmtInCCCrcy as fis_acr_cost_hsl_a) AS ActlAccruedCOGSAmtInCCCrcy,
  cast(RecognizableCostAmtInCCCrcy as fis_act_cost_hsl_a) AS ActlRecgblCostAmtInCCCrcy,
  cast(ImminentLossRsrvAmtInCCCrcy as fis_res_mil_hsl_a) AS ActlImmntLossRsrvAmtInCCCrcy,
  cast(SalesDeductReserveAmtInCCCrcy as fis_res_masd_hsl_a) AS ActlSalesDeductRsrvAmtInCCCrcy,
  cast(UnrlzdCostsReserveAmtInCCCrcy as fis_res_muc_hsl_a) AS ActlUnrlzdCostsRsrvAmtInCCCrcy,
  cast(SalesDeductionAmountInGlobCrcy as fis_sales_ded_ksl_a) AS ActlSlsDeductionAmtInGlobCrcy,
  cast(SalesDeductionAmtInCoCodeCrcy as fis_sales_ded_hsl_a) AS ActlSlsDeductionAmtInCCCrcy,
  cast(PriceDifferenceAmtInGlobCrcy as fis_price_dif_ksl_a) AS ActlPrcDifferenceAmtInGlobCrcy,
  cast(AdminOverheadAmtInGlobCrcy as fis_ovh_admin_ksl_a) AS ActlAdminOverheadAmtInGlobCrcy,
  cast(SalesOverheadAmtInGlobCrcy as fis_ovh_sales_ksl_a) AS ActlSalesOverheadAmtInGlobCrcy,
  cast(MarketingOverheadAmtInGlobCrcy as fis_ovh_market_ksl_a) AS ActlMarketingOvhdAmtInGlobCrcy,
  cast(RnDOverheadAmtInGlobCrcy as fis_ovh_rnd_ksl_a) AS ActlRnDOverheadAmtInGlobCrcy,
  cast(LongTermInvmtAmtInCCCrcy as fis_chgltinv_hsl_a) AS ActlLongTermInvmtAmtInCCCrcy,
  cast(AcctsRblAmtInCCCrcy as fis_accrec_hsl_a) AS ActlAcctsRblAmtInCCCrcy,
  cast(AcctsOthRblAmtInCCCrcy as fis_accrec_oth_hsl_a) AS ActlAcctsOthRblAmtInCCCrcy,
  cast(AcctsPyblAmtInCCCrcy as fis_accpay_hsl_a) AS ActlAcctsPyblAmtInCCCrcy,
  cast(AcctsOthPyblAmtInCCCrcy as fis_accpay_oth_hsl_a) AS ActlAcctsOthPyblAmtInCCCrcy,
  cast(ProvisionAmtInCCCrcy as fis_provisions_hsl_a) AS ActlProvisionAmtInCCCrcy,
  cast(NotesReceivableAmtInCCCrcy as fis_notereceiv_hsl_a) AS ActlNotesReceivableAmtInCCCrcy,
  cast(TangibleAstDeprAmtInCCCrcy as fis_dprtasset_hsl_a) AS ActlTangibleAstDeprAmtInCCCrcy,
  cast(IntngblAssetAmtznAmtInCCCrcy as fis_amorinasst_hsl_a) AS ActlIntngblAstAmtznAmtInCCCrcy,
  cast(TangibleAstAmtInCCCrcy as fis_tangassets_hsl_a) AS ActlTangibleAstAmtInCCCrcy,
  cast(IntangibleAstAmtInCCCrcy as fis_itangasset_hsl_a) AS ActlIntangibleAstAmtInCCCrcy,
  cast(FixedAssetRtrmtAmtInCCCrcy as fis_chgfaret_hsl_a) AS ActlFxdAstRtrmtAmtInCCCrcy,
  cast(InventoryAmtInCCCrcy as fis_inventory_hsl_a) AS ActlInventoryAmtInCCCrcy,
  cast(CommonStockAmtInCCCrcy as fis_comnstock_hsl_a) AS ActlCommonStockAmtInCCCrcy,
  cast(CashAndCashEqvlntAmtInCCCrcy as fis_cfs_cashneqv_hsl_a) AS ActlCshAndCshEqvlntAmtInCCCrcy,
  cast(AssetAmtInCCCrcy as fis_asset_hsl_a) AS ActlAssetAmtInCCCrcy,
  cast(LiabilityEquityAmtInCCCrcy as fis_liab_equity_hsl_a) AS ActlLbltyEquityAmtInCCCrcy,
  cast(NotAssignedAmtInCCCrcy as fis_unassigned_hsl_a) AS ActlNotAssignedAmtInCCCrcy,
  cast(NetResultAmtInCCCrcy as fis_netresult_hsl_a) AS ActlNetRsltAmtInCCCrcy,
  cast(PnLResultAmtInCCCrcy as fis_pl_result_hsl_a) AS ActlPnLResultAmtInCCCrcy,
  cast(GLAcctNetIncomeAmtInCCCrcy as fis_ntinc_alac_hsl_a) AS ActlGLAcctNetIncAmtInCCCrcy,
  cast(OperatingActyCashAmtInCCCrcy as fis_cfs_cashopg_hsl_a) AS ActlOpgActyCashAmtInCCCrcy,
  cast(InvestingActyCashAmtInCCCrcy as fis_cfs_cashinvtg_hsl_a) AS ActlInvstgActyCashAmtInCCCrcy,
  cast(FinancingActyCashAmtInCCCrcy as fis_cfs_cashfin_hsl_a) AS ActlFinActyCashAmtInCCCrcy,
  cast(NetCashAmtInCCCrcy as fis_cfs_netcash_hsl_a) AS ActlNetCashAmtInCCCrcy,
  cast(0 as fis_revenue_hsl_p) AS PlnRevenueAmountInCCCrcy,
  cast(0 as fis_gross_rev_hsl_p) AS PlnGrossRevenueAmtInCCCrcy,
  cast(0 as fis_reco_rev_hsl_p) AS PlnRecognizedRevnAmtInCCCrcy,
  cast(0 as fis_reco_rev_ksl_p) AS PlnRecgdRevenueAmtInGlobCrcy,
  cast(0 as fis_adj_rev_hsl_p) AS PlnRevnAdjustmentAmtInCCCrcy,
  cast(0 as fis_def_rev_hsl_p) AS PlnDeferredRevenueAmtInCCCrcy,
  cast(0 as fis_acr_rev_hsl_p) AS PlnAccruedRevenueAmtInCCCrcy,
  cast(0 as fis_bill_rev_hsl_p) AS PlnBilledRevenueAmtInCCCrcy,
  cast(0 as fis_bill_rev_ksl_p) AS PlnBilledRevenueAmtInGlobCrcy,
  cast(0 as fis_rec_margin_hsl_p) AS PlnRecognizedMargAmtInCCCrcy,
  cast(0 as fis_cost_hsl_p) AS PlnCostAmtInCompanyCodeCrcy,
  cast(0 as fis_reco_cos_hsl_p) AS PlnRecognizedCOGSAmtInCCCrcy,
  cast(0 as fis_adj_cos_hsl_p) AS PlnCOGSAdjustmentAmtInCCCrcy,
  cast(0 as fis_def_cost_hsl_p) AS PlnDeferredCOGSAmtInCCCrcy,
  cast(0 as fis_acr_cost_hsl_p) AS PlnAccruedCOGSAmtInCCCrcy,
  cast(0 as fis_cogs_ksl_p) AS PlnCostOfGdsSoldAmtInGlobCrcy,
  cast(0 as fis_res_mil_hsl_p) AS PlnImmntLossRsrvAmtInCCCrcy,
  cast(0 as fis_res_masd_hsl_p) AS PlnSalesDeductRsrvAmtInCCCrcy,
  cast(0 as fis_res_muc_hsl_p) AS PlnUnrlzdCostsRsrvAmtInCCCrcy,
  cast(0 as fis_sales_ded_ksl_p) AS PlnSlsDeductionAmtInGlobCrcy,
  cast(0 as fis_sales_ded_hsl_p) AS PlnSlsDeductionAmtInCCCrcy,
  cast(0 as fis_price_dif_ksl_p) AS PlnPrcDifferenceAmtInGlobCrcy,
  cast(0 as fis_ovh_admin_ksl_p) AS PlnAdminOverheadAmtInGlobCrcy,
  cast(0 as fis_ovh_sales_ksl_p) AS PlnSalesOverheadAmtInGlobCrcy,
  cast(0 as fis_ovh_market_ksl_p) AS PlnMarketingOvhdAmtInGlobCrcy,
  cast(0 as fis_ovh_rnd_ksl_p) AS PlnRnDOverheadAmtInGlobCrcy,
  cast(0 as fis_paygrliain_hsl_p) AS PlnLongTermInvmtAmtInCCCrcy,
  cast(0 as fis_accrec_hsl_p) AS PlnAcctsRblAmtInCCCrcy,
  cast(0 as fis_accrec_oth_hsl_p) AS PlnAcctsOthRblAmtInCCCrcy,
  cast(0 as fis_accpay_hsl_p) AS PlnAcctsPyblAmtInCCCrcy,
  cast(0 as fis_accpay_oth_hsl_p) AS PlnAcctsOthPyblAmtInCCCrcy,
  cast(0 as fis_provisions_hsl_p) AS PlnProvisionAmtInCCCrcy,
  cast(0 as fis_notereceiv_hsl_p) AS PlnNotesReceivableAmtInCCCrcy,
  cast(0 as fis_dprtasset_hsl_p) AS PlnTangibleAstDeprAmtInCCCrcy,
  cast(0 as fis_dprltasset_hsl_p) AS PlnIntngblAstAmtznAmtInCCCrcy,
  cast(0 as fis_tangassets_hsl_p) AS PlnTangibleAstAmtInCCCrcy,
  cast(0 as fis_itangasset_hsl_p) AS PlnIntangibleAstAmtInCCCrcy,
  cast(0 as fis_chgfaret_hsl_p) AS PlnFxdAstRtrmtAmtInCCCrcy,
  cast(0 as fis_inventory_hsl_p) AS PlnInventoryAmtInCCCrcy,
  cast(0 as fis_stockshare_hsl_p) AS PlnCommonStockAmtInCCCrcy,
  cast(0 as fis_cfs_cashneqv_hsl_p) AS PlnCshAndCshEqvlntAmtInCCCrcy,
  cast(0 as fis_asset_hsl_p) AS PlnAssetAmtInCCCrcy,
  cast(0 as fis_liab_equity_hsl_p) AS PlnLbltyEquityAmtInCCCrcy,
  cast(0 as fis_unassigned_hsl_p) AS PlnNotAssignedAmtInCCCrcy,
  cast(0 as fis_netresult_hsl_p) AS PlnNetRsltAmtInCCCrcy,
  cast(0 as fis_pl_result_hsl_p) AS PlnPnLResultAmtInCCCrcy,
  cast(0 as fis_ntinc_alac_hsl_p) AS PlnGLAcctNetIncAmtInCCCrcy,
  cast (0 as fis_contrbn_margin_ii_ksl_p) AS PlnContrbnMarg2AmtInGlobCrcy,
  cast(0 as fis_cfs_cashopg_hsl_p) AS PlnOpgActyCashAmtInCCCrcy,
  cast(0 as fis_cfs_cashinvtg_hsl_p) AS PlnInvstgActyCashAmtInCCCrcy,
  cast(0 as fis_cfs_cashfin_hsl_p) AS PlnFinActyCashAmtInCCCrcy,
  cast(0 as fis_cfs_netcash_hsl_p) AS PlnNetCashAmtInCCCrcy,
  AssetClass,
  FunctionalCurrency,
  AmountInFunctionalCurrency AS OrderIDkeyLedger,
  AmountInFunctionalCurrency
FROM I_GLAccountLineItemSemTag
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PlanLineItemSemTag
;