P_GLIncgOrdPrdtvAnalysisUnion

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_GLIncgOrdPrdtvAnalysisUnion.
-- 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: PFGLIOPRANLS

CREATE VIEW P_GLIncgOrdPrdtvAnalysisUnion AS
SELECT
  SourceLedger AS Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  DocumentDate,
  SalesOrganization,
  CustomerGroup,
  Customer,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  FiscalPeriod,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  cast(SoldProductGroup as fins_matkl_pa) AS MaterialGroup,
  ProfitCenter,
  ControllingArea,
  SalesDistrict,
  Segment,
  cast(SourceReferenceDocument as vdm_sales_order) AS SalesOrder,
  cast(SourceReferenceDocumentItem as fac_kdpos) AS SalesOrderItem,
  DistributionChannel,
  SoldProduct AS SoldMaterial,
  _SalesDocumentBasic.OrganizationDivision AS Division,
  _SalesDocumentBasic.SalesDocumentType AS OrderType,
  BusinessTransactionType,
  BusinessArea,
  CostCenter,
  CustomerSupplierCountry,
  FiscalYearPeriod,
  AccountingDocumentCategory,
  _GL.GLAccount AS GLAccount,
  PostingDate,
  CreationDate,
  _GL.ChartOfAccounts AS ChartOfAccounts,
  LedgerFiscalYear,
  FinancialTransactionType,
  TransactionCurrency,
  BaseUnit,
  Quantity,
  FixedQuantity,
  DebitCreditCode,
  AssignmentReference,
  PostingKey,
  AccountingDocCreatedByUser,
  GLAccountType,
  Plant,
  FinancialAccountType,
  SpecialGLCode,
  ClearingDate,
  ClearingAccountingDocument,
  BillingDocumentType,
  OrganizationDivision,
  CustomerSupplierIndustry,
  BillToParty,
  ShipToParty,
  cast(SourceReferenceDocumentType as fins_src_awtyp) AS SourceReferenceDocumentType,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  cast(_GL.OperatingConcern as fins_erkrs preserving type) AS OperatingConcern,
  AccountingDocumentItem,
  TransactionTypeDetermination,
  cast(ControllingDebitCreditCode as fins_debit_credit_indicator_co preserving type) AS ControllingDebitCreditCode,
  AccountingDocumentType,
  ReferenceDocumentType,
  FiscalYearVariant,
  _DocumentFiscalCalendarDate.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  cast(_DocumentFiscalCalendarDate.FiscalYear as fins_gjahr_je) AS JrnlEntrDerivedFiscalYear,
  cast(_DocumentFiscalCalendarDate.FiscalQuarter as fins_fscalquarter_je) AS JrnlEntrDerivedFiscalQuarter,
  cast(_DocumentFiscalCalendarDate.FiscalPeriod as fins_fiscalperiod_je) AS JrnlEntrDerivedFiscalPeriod,
  cast(JrnlEntryItemObsoleteReason as fins_obs_reason) AS JrnlEntryItemObsoleteReason,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  IsCommitment,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ValuationArea,
  Supplier,
  SalesDocument,
  FixedAsset,
  MasterFixedAsset,
  OrderID,
  AssetClass,
  _GL.FunctionalArea AS FunctionalArea
FROM I_GLAccountLineItemRawData AS _GL
INNER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
INNER JOIN I_SemTagFuncArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalCalendarDate AS _DocumentFiscalCalendarDate ON DocumentDate = _DocumentFiscalCalendarDate.CalendarDate AND FiscalYearVariant = _DocumentFiscalCalendarDate.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocumentBasic ON SourceReferenceDocument = _SalesDocumentBasic.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Product AS _SoldMaterial ON SoldMaterial = _SoldMaterial.Product  -- association [0..1]
-- UNION ALL with additional select branch(es): I_GLAccountLineItemRawData
;