P_ActlPlnLineItemSemTagGLAcct

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_ActlPlnLineItemSemTagGLAcct.
-- 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: PFIAPGLACCLITSTG

CREATE VIEW P_ActlPlnLineItemSemTagGLAcct 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,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  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,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  CreationDate,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  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,
  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,
  SoldProduct,
  SoldProductGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  AssetClass,
  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,
  DebitAmountInFreeDfndCrcy1,
  CreditAmountInFreeDfndCrcy1,
  DebitAmountInFreeDfndCrcy2,
  CreditAmountInFreeDfndCrcy2,
  DebitAmountInFreeDfndCrcy3,
  CreditAmountInFreeDfndCrcy3,
  DebitAmountInFreeDfndCrcy4,
  CreditAmountInFreeDfndCrcy4,
  DebitAmountInFreeDfndCrcy5,
  CreditAmountInFreeDfndCrcy5,
  DebitAmountInFreeDfndCrcy6,
  CreditAmountInFreeDfndCrcy6,
  DebitAmountInFreeDfndCrcy7,
  CreditAmountInFreeDfndCrcy7,
  DebitAmountInFreeDfndCrcy8,
  CreditAmountInFreeDfndCrcy8,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  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(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 AS OrderIDkeyLedger,
  PlnGLAcctNetIncAmtInCCCrcy
FROM I_GLAcctLineItemSemTagGLAcct
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_PlanLineItemSemTagGLAcct
;