C_GLIncgOrdOrdEntrVislFltr

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_GLIncgOrdOrdEntrVislFltr.
-- 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: CGLIOORDRENTRVF

CREATE VIEW C_GLIncgOrdOrdEntrVislFltr AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  Ledger AS PredictionLedger,
  DocumentDate,
  SalesOrganization,
  CustomerGroup,
  _CustomerGroupText[1:Language = $session.system_language].CustomerGroupName AS CustomerGroupName,
  Customer,
  FiscalQuarter,
  FiscalPeriod,
  cast(FiscalYearPeriod as abap.numc( 7 )) AS FiscalYearPeriod,
  JrnlEntrDerivedFiscalYear,
  JrnlEntrDerivedFiscalQuarter,
  JrnlEntrDerivedFiscalPeriod,
  JrnlEntrDerivdFiscalYearPeriod,
  FiscalPeriodStartDate,
  cast (MaterialGroup as productgroup preserving type) AS ProductGroup,
  _ProductGroupText[1:Language = $session.system_language].MaterialGroupName AS ProductGroupName,
  ProfitCenter,
  _ProfitCenterText[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  ControllingArea,
  CompanyCodeCurrency,
  GlobalCurrency,
  SalesDistrict,
  Segment,
  cast(SourceReferenceDocumentItem as fac_kdpos) AS SalesOrderItem,
  OrderType,
  cast (SoldMaterial as fins_matnr_pa preserving type) AS SoldProduct,
  DistributionChannel,
  Division,
  BusinessTransactionType,
  BusinessArea,
  CostCenter,
  CustomerSupplierCountry,
  RecognizedRevnAmtInCCCrcy AS RevenueAmountInCompanyCodeCrcy,
  RecognizedRevnAmtInGlobCrcy AS RevenueInGlobalCurrency,
  -RecognizedCOGSAmtInCCCrcy AS COGSAmountInCoCodeCrcy,
  -CostOfGoodsSoldAmtInGlobCrcy AS COGSAmountInGlobCrcy,
  RecognizedMarginAmtInCCCrcy,
  RecognizedMarginAmount,
  -SalesDeductionAmtInCoCodeCrcy AS SalesDeductionAmtInCoCodeCrcy,
  -SalesDeductionAmountInGlobCrcy AS SalesDeductionAmountInGlobCrcy,
  GLAccount,
  cast(_GLAccountText[1:Language = $session.system_language].GLAccountName as fin_glaccount_name) AS GLAccountName,
  PostingDate,
  CreationDate,
  _GLI.ChartOfAccounts AS ChartOfAccounts,
  LedgerFiscalYear,
  FinancialTransactionType,
  TransactionCurrency,
  BaseUnit,
  DebitCreditCode,
  AssignmentReference,
  PostingKey,
  AccountingDocCreatedByUser,
  GLAccountType,
  Plant,
  FinancialAccountType,
  SpecialGLCode,
  ClearingDate,
  ClearingAccountingDocument,
  BillingDocumentType,
  CustomerSupplierIndustry,
  BillToParty,
  ShipToParty,
  SourceReferenceDocumentType,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  OperatingConcern,
  AccountingDocumentItem,
  TransactionTypeDetermination,
  ControllingDebitCreditCode,
  AccountingDocumentType,
  ReferenceDocumentType,
  JrnlEntryItemObsoleteReason,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ValuationArea,
  Supplier,
  SalesDocument,
  FixedAsset,
  MasterFixedAsset,
  OrderID,
  OrganizationDivision,
  AssetClass,
  FunctionalArea
FROM R_GLIncgOrdPrdtvAnalysis AS _GLI
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- 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..*]
;