R_GLIncgOrdPrdtvAnalysis

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 R_GLIncgOrdPrdtvAnalysis.
-- 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: RFGLIOPRANLS

CREATE VIEW R_GLIncgOrdPrdtvAnalysis AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  DocumentDate,
  SalesOrganization,
  CustomerGroup,
  Customer,
  FiscalQuarter,
  FiscalPeriod,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  RecognizedRevnAmtInCCCrcy,
  RecognizedRevnAmtInGlobCrcy,
  RevenueAmountInCompanyCodeCrcy,
  RevenueInGlobalCurrency,
  RecognizedCOGSAmtInCCCrcy,
  CostOfGoodsSoldAmtInGlobCrcy,
  RecognizedMarginAmtInCCCrcy,
  RecognizedMarginAmount,
  SalesDeductionAmountInGlobCrcy,
  SalesDeductionAmtInCoCodeCrcy,
  RecognizableRevnAmtInGlobCrcy,
  MaterialGroup,
  ProfitCenter,
  ControllingArea,
  SalesDistrict,
  Segment,
  cast(SourceReferenceDocument as vdm_sales_order) AS SalesOrder,
  cast(SourceReferenceDocumentItem as fac_kdpos) AS SalesOrderItem,
  DistributionChannel,
  SoldMaterial,
  Division,
  OrderType,
  BusinessTransactionType,
  BusinessArea,
  CostCenter,
  CustomerSupplierCountry,
  FiscalYearPeriod,
  AmountInCompanyCodeCurrency,
  InvertedAmtInCoCodeCurrency,
  InvertedAmountInGlobalCurrency,
  AmountInGlobalCurrency,
  AmountInFunctionalCurrency,
  InvertedAmtInFuncnlCurrency,
  AccountingDocumentCategory,
  GLAccount,
  PostingDate,
  CreationDate,
  ChartOfAccounts,
  LedgerFiscalYear,
  FinancialTransactionType,
  TransactionCurrency,
  AmountInTransactionCurrency,
  InvertedAmtInTransCrcy,
  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,
  FiscalPeriodStartDate,
  JrnlEntrDerivedFiscalYear,
  JrnlEntrDerivedFiscalQuarter,
  JrnlEntrDerivedFiscalPeriod,
  JrnlEntrDerivdFiscalYearPeriod,
  JrnlEntryItemObsoleteReason,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  InvertedAmtInFreeDefinedCrcy1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  InvertedAmtInFreeDefinedCrcy2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  InvertedAmtInFreeDefinedCrcy3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  InvertedAmtInFreeDefinedCrcy4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  InvertedAmtInFreeDefinedCrcy5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  InvertedAmtInFreeDefinedCrcy6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  InvertedAmtInFreeDefinedCrcy7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  InvertedAmtInFreeDefinedCrcy8,
  cast( 1 as abap.int4 ) AS NumberOfSalesOrders,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ValuationArea,
  Supplier,
  SalesDocument,
  FixedAsset,
  MasterFixedAsset,
  OrderID,
  AssetClass,
  FunctionalArea
FROM P_GLIncgOrdPrdtvAnalysisUnion AS _GL
LEFT OUTER JOIN I_CurrentCostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_CurrentProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter  -- association [0..1]
;