C_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 C_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: CGLIOPRANLS

CREATE VIEW C_GLIncgOrdPrdtvAnalysis AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  Ledger AS PredictionLedger,
  _LedgerText[1:Language = $session.system_language].LedgerName AS LedgerName,
  _GLAccountHierarchyText[1:Language = $session.system_language].GLAccountHierarchyName AS GLAccountHierarchyName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast(_SemanticTagText[1:Language = $session.system_language].SemanticTagName as fins_sem_tag_name) AS SemanticTagName,
  DocumentDate,
  AmountInGlobalCurrency,
  InvertedAmountInGlobalCurrency,
  ProfitCenter,
  _ProfitCenterText[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  GLAccount,
  cast(_GLAccountText[1:Language = $session.system_language].GLAccountName as fin_glaccount_name) AS GLAccountName,
  cast(SourceReferenceDocument as vdm_sales_order) AS SalesOrder,
  SalesOrganization,
  _SalesOrganizationText[1:Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannelText[1:Language = $session.system_language].DistributionChannelName AS DistributionChannelName,
  cast (SoldMaterial as fins_matnr_pa preserving type) AS SoldProduct,
  _SoldProductText[1:Language = $session.system_language].ProductName AS SoldProductName,
  MaterialGroup AS ProductGroup,
  cast(_ProductGroupText[1:Language = $session.system_language].MaterialGroupName as fins_matkl_pa_desc) AS ProductGroupName,
  CustomerGroup,
  _CustomerGroupText[1:Language = $session.system_language].CustomerGroupName AS CustomerGroupName,
  Customer,
  _CustomerText.CustomerName AS CustomerName,
  FiscalQuarter,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  JrnlEntrDerivedFiscalYear,
  JrnlEntrDerivedFiscalQuarter,
  JrnlEntrDerivedFiscalPeriod,
  JrnlEntrDerivdFiscalYearPeriod,
  FiscalPeriodStartDate,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  InvertedAmtInFuncnlCurrency,
  SalesDistrict,
  _SalesDistrictText[1:Language = $session.system_language].SalesDistrictName AS SalesDistrictName,
  Segment,
  _SegmentText[1:Language = $session.system_language].SegmentName AS SegmentName,
  cast( SourceReferenceDocumentItem as fac_kdpos) AS SalesOrderItem,
  _SalesOrderItemText.SalesOrderItemText AS SalesOrderItemText,
  OrderType,
  Division,
  _DivisionText[1:Language = $session.system_language].DivisionName AS DivisionName,
  BusinessTransactionType,
  _BusinessTransactionTypeText[1:Language = $session.system_language].BusinessTransactionTypeName AS BusinessTransactionTypeName,
  BusinessArea,
  _BusinessAreaText[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  CostCenter,
  _CostCenterText[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  CustomerSupplierCountry,
  _GLI.ControllingArea AS ControllingArea,
  _ControllingAreaText.ControllingAreaName AS ControllingAreaName,
  AmountInCompanyCodeCurrency,
  InvertedAmtInCoCodeCurrency,
  AccountingDocumentCategory,
  cast(_AccountingDocumentCategoryT[1:Language = $session.system_language].AccountingDocumentCategoryName as fis_bstat_name) AS AccountingDocumentCategoryName,
  PostingDate,
  CreationDate,
  _GLI.ChartOfAccounts AS ChartOfAccounts,
  _ChartOfAccountsText[1:Language = $session.system_language].ChartOfAccountsName AS ChartOfAccountsName,
  LedgerFiscalYear,
  FinancialTransactionType,
  TransactionCurrency,
  AmountInTransactionCurrency,
  InvertedAmtInTransCrcy,
  BaseUnit,
  _UnitOfMeasureText[1:Language = $session.system_language].UnitOfMeasureName AS BaseUnitName,
  Quantity,
  FixedQuantity,
  DebitCreditCode,
  AssignmentReference,
  PostingKey,
  AccountingDocCreatedByUser,
  GLAccountType,
  Plant,
  FinancialAccountType,
  SpecialGLCode,
  ClearingDate,
  ClearingAccountingDocument,
  BillingDocumentType,
  CustomerSupplierIndustry,
  BillToParty,
  ShipToParty,
  SourceReferenceDocumentType,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  OperatingConcern,
  AccountingDocumentItem,
  TransactionTypeDetermination,
  ControllingDebitCreditCode,
  AccountingDocumentType,
  _AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  ReferenceDocumentType,
  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,
  CostSourceUnit,
  ValuationQuantity,
  NumberOfSalesOrders,
  cast(0 as abap.dec( 10,2 )) AS SalesOrderDiscountRate,
  cast(0 as abap.dec( 10, 2 )) AS SalesOrderGrossMargin,
  cast('%' as msehi) AS UnitOfMeasure,
  RecognizedRevnAmtInGlobCrcy AS RevenueInGlobalCurrency,
  RecognizedMarginAmount,
  -SalesDeductionAmountInGlobCrcy AS SalesDeductionAmountInGlobCrcy,
  RecognizableRevnAmtInGlobCrcy,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ValuationArea,
  Supplier,
  SalesDocument,
  FixedAsset,
  MasterFixedAsset,
  OrderID,
  OrganizationDivision,
  AssetClass,
  FunctionalArea
FROM R_GLIncgOrdPrdtvAnalysis AS _GLI
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItemText ON SourceReferenceDocument = _SalesOrderItemText.SalesOrder AND SourceReferenceDocumentItem = _SalesOrderItemText.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND ValidityEndDate = _ProfitCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON DistributionChannel = _DistributionChannelText.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _SoldProductText ON SoldProduct = _SoldProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText ON ProductGroup = _ProductGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_CustomerGroupText AS _CustomerGroupText ON CustomerGroup = _CustomerGroupText.CustomerGroup  -- association [0..*]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON Division = _DivisionText.Division  -- association [0..*]
LEFT OUTER JOIN I_SemanticTagText AS _SemanticTagText ON SemanticTag = _SemanticTagText.SemanticTag  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentCategoryT AS _AccountingDocumentCategoryT ON AccountingDocumentCategory = _AccountingDocumentCategoryT.AccountingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND _CostCenterText.ValidityStartDate <= $session.system_date AND _CostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON BaseUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccountHierarchyText AS _GLAccountHierarchyText ON GLAccountHierarchy = _GLAccountHierarchyText.GLAccountHierarchy  -- association [0..*]
LEFT OUTER JOIN I_SalesDistrictText AS _SalesDistrictText ON SalesDistrict = _SalesDistrictText.SalesDistrict  -- association [0..*]
;