C_GLAccountLineItemImpact

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_GLAccountLineItemImpact.
-- 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: CGLACCTLNITIMPCT

CREATE VIEW C_GLAccountLineItemImpact AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  GLAccount,
  cast (_GLAcctInChartOfAccountsText[1:Language = $session.system_language ].GLAccountName as fin_aci_accname ) AS GLAccountName,
  _GLAcctInChartOfAccountsText[1:Language = $session.system_language ].GLAccountLongName AS GLAccountLongName,
  PostingDate,
  GLAccountType,
  CreationDateTime,
  cast (SourceReferenceDocument as fis_aci_awref) AS SourceReferenceDocument,
  cast (SourceReferenceDocumentType as fins_aci_src_awtyp) AS SourceReferenceDocumentType,
  DebitCreditCode,
  AccountingDocumentType,
  cast (_AccountingDocumentType._Text[1:Language = $session.system_language ].AccountingDocumentTypeName as fin_aci_doctpname) AS AccountingDocumentTypeName,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  cast (CompanyCodeCurrency as fins_aci_currh) AS CompanyCodeCurrency,
  TransactionCurrency,
  GlobalCurrency,
  cast (BalanceTransactionCurrency as fins_aci_currt) AS BalanceTransactionCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  WBSElementInternalID,
  cast( WBSElement as fis_wbs_no_conv preserving type ) AS WBSElement,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  CostCenter,
  _CurrentCostCenter._Text[ 1:Language = $session.system_language].CostCenterDescription AS CostCenterDescription,
  ProfitCenter,
  _CurrentProfitCenter._Text[ 1:Language = $session.system_language].ProfitCenterLongName AS ProfitCenterLongName,
  AssignmentReference,
  ReferenceDocument,
  Fund,
  _Fund._Text[ 1:Language = $session.system_language].FundName AS FundName,
  BudgetPeriod,
  _BudgetPeriod._Text[ 1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  GrantID,
  cast ( _Grant._Text[ 1:Language = $session.system_language].GrantName as fins_aci_grant_name preserving type ) AS GrantName,
  cast( MasterFixedAsset as fis_aci_anln1 preserving type ) AS MasterFixedAsset,
  _MasterFixedAssetText.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  _FixedAssetText.FixedAssetDescription AS FixedAssetDescription,
  _Ledger._Text[ 1:Language = $session.system_language].LedgerName AS LedgerName,
  cast ( _SourceLedger._Text[ 1:Language = $session.system_language].LedgerName as fin_aci_src_ledger_name preserving type ) AS SourceLedgerName,
  AssetTransactionType,
  SubLedgerAcctLineItemType,
  cast ( _SubLedgerAccLineItemType._Text[ 1:Language = $session.system_language].SubLedgerAcctLineItemTypeName as fin_aci_slalitype_desc preserving type ) AS SubLedgerAcctLineItemTypeName,
  AssetClass,
  OriginProduct,
  OriginCostCenter,
  OriginCostCtrActivityType,
  VarianceOriginGLAccount,
  cast ( _OriginProduct._Text[ 1:Language = $session.system_language].ProductName as fin_aci_orig_prod_name preserving type ) AS OriginProductName,
  LedgerFiscalYear,
  Segment,
  _GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  ChartOfAccounts
FROM I_GLAccountLineItem AS GLAccountLineItem
LEFT OUTER JOIN I_GLAccountLineItem AS _GLAccountLineItem ON Ledger = _GLAccountLineItem.Ledger AND SourceLedger = _GLAccountLineItem.SourceLedger AND CompanyCode = _GLAccountLineItem.CompanyCode AND FiscalYear = _GLAccountLineItem.FiscalYear AND AccountingDocument = _GLAccountLineItem.AccountingDocument AND LedgerGLLineItem = _GLAccountLineItem.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [1..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;