I_GLAcctLineItmSubLdgrItmTypeC

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 I_GLAcctLineItmSubLdgrItmTypeC.
-- 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: IGLSUBLDGITP

CREATE VIEW I_GLAcctLineItmSubLdgrItmTypeC AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  cast ( cast( '' as abap.char( 10 ) ) as fins_sem_tag preserving type ) AS SemanticTag,
  FiscalPeriod,
  LedgerFiscalYear,
  ProfitCenter,
  SoldProduct,
  SoldProductGroup,
  Customer,
  CustomerGroup,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  OrderID,
  OrderCategory,
  ConditionContract,
  FiscalYearPeriod,
  ChartOfAccounts,
  GLAccount,
  SalesOrganization,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  ShipToParty,
  BillToParty,
  BusinessTransactionType,
  SubLedgerAcctLineItemType,
  AccountAssignmentType,
  ControllingArea,
  CostSourceUnit,
  DistributionChannel,
  OrganizationDivision,
  BaseUnit,
  OrderType,
  Segment,
  cast( Project as fis_project_no_conv preserving type ) AS Project,
  cast( WBSElement as fis_wbs_no_conv preserving type ) AS WBSElement,
  ProjectNetwork,
  FunctionalArea,
  Plant,
  FiscalYearVariant,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  ServiceContractType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ProjectInternalID,
  BusinessArea,
  GlobalCurrency,
  CompanyCodeCurrency,
  FreeDefinedCurrency1,
  AmountInCompanyCodeCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInGlobalCurrency,
  FixedAmountInCoCodeCrcy,
  FixedAmountInGlobalCrcy,
  Supplier,
  AccountingDocumentType,
  FinancialAccountType,
  CostCenter,
  ValuationArea,
  AssetClass,
  PostingDate
FROM I_GLAccountLineItem
LEFT OUTER JOIN I_SemanticTag AS _SemanticTag ON SemanticTag = _SemanticTag.SemanticTag  -- association [0..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]
;