C_MngJrnlEntrTechLedgerView

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_MngJrnlEntrTechLedgerView.
-- 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.

CREATE VIEW C_MngJrnlEntrTechLedgerView AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  GLRecordType,
  JrnlEntrAltvFYConsecutiveID,
  ControllingArea,
  BusinessTransactionCategory,
  BusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  FinancialTransactionType,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocItem,
  PredecessorReferenceDocType,
  PredecessorReferenceDocument,
  SourceReferenceDocument,
  SourceReferenceDocumentType,
  SourceReferenceDocumentItem,
  SourceReferenceDocumentCntxt,
  SourceLogicalSystem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  GLBusinessTransactionType,
  LogicalSystem,
  GLAccount,
  ChartOfAccounts,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  CreditAmountInBalanceTransCrcy,
  CreditAmountInTransCrcy,
  CreditAmountInCoCodeCrcy,
  CreditAmountInGlobalCrcy,
  CreditAmountInFunctionalCrcy,
  CreditAmountInFreeDfndCrcy1,
  CreditAmountInFreeDfndCrcy2,
  CreditAmountInFreeDfndCrcy3,
  CreditAmountInFreeDfndCrcy4,
  CreditAmountInFreeDfndCrcy5,
  CreditAmountInFreeDfndCrcy6,
  CreditAmountInFreeDfndCrcy7,
  CreditAmountInFreeDfndCrcy8,
  DebitAmountInBalanceTransCrcy,
  DebitAmountInTransCrcy,
  DebitAmountInCoCodeCrcy,
  DebitAmountInGlobalCrcy,
  DebitAmountInFunctionalCrcy,
  DebitAmountInFreeDfndCrcy1,
  DebitAmountInFreeDfndCrcy2,
  DebitAmountInFreeDfndCrcy3,
  DebitAmountInFreeDfndCrcy4,
  DebitAmountInFreeDfndCrcy5,
  DebitAmountInFreeDfndCrcy6,
  DebitAmountInFreeDfndCrcy7,
  DebitAmountInFreeDfndCrcy8,
  BalanceTransactionCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  BaseUnit,
  Quantity,
  FixedQuantity,
  CostSourceUnit,
  ValuationQuantity,
  ValuationFixedQuantity,
  AdditionalQuantity1Unit,
  AdditionalQuantity1,
  AdditionalQuantity2Unit,
  AdditionalQuantity2,
  AdditionalQuantity3Unit,
  AdditionalQuantity3,
  DebitCreditCode,
  ExchangeRateDate,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  PostingKey,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  CreationDate,
  CreationDateTime,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  ConsolidationUnit,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  PartnerConsolidationUnit,
  Company,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesDocument,
  SalesDocumentItem,
  Product,
  ProductGroup,
  Plant,
  Supplier,
  cast(_Supplier.Country as fis_supplier_country preserving type ) AS SupplierCountry,
  Customer,
  Customer AS CustomerForFilter,
  cast(_Customer.Country as fis_customer_country preserving type ) AS CustomerCountry,
  ServicesRenderedDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  TaxCountry,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingJournalEntryFiscalYear,
  ClearingJournalEntry,
  IsCleared,
  ValueDate,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  AssetClass,
  CostEstimate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  InvtrySpclStockWBSElmntExtID,
  ProductPriceControl,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObject,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  BillableControl,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCtrActivityType,
  OriginCostCenter,
  OriginProfitCenter,
  OriginProduct,
  VarianceOriginGLAccount,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementExternalID,
  WBSElementInternalID,
  PartnerWBSElementInternalID,
  PartnerWBSElementExternalID,
  WorkPackage,
  ProjectInternalID,
  PartnerProjectInternalID,
  PartnerProjectExternalID,
  ProjectExternalID,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CostAnalysisResource,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  TimeSheetOvertimeCategory,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  WorkItem,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  PubSecBudgetCnsmpnAmtType,
  SponsoredProgram,
  SponsoredClass,
  GteeMBudgetValidityNumber,
  CommitmentItem,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVentureBillingType,
  JointVentureEquityType,
  JointVentureProductionDate,
  JointVentureBillingDate,
  JointVentureOperationalDate,
  JointVentureAccountingActivity,
  SettlementReferenceDate,
  PartnerVenture,
  PartnerEquityGroup,
  SenderCostRecoveryCode,
  CutbackAccount,
  CutbackCostObject,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  AccrualObjectType,
  AccrualObjectLogicalSystem,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualReferenceObject,
  AccrualValueDate,
  FinancialValuationObjectType,
  FinancialValuationObject,
  FinancialValuationSubobject,
  NetDueDate,
  CreditRiskClass,
  IsNegativePosting,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  OrderOperation,
  JrnlEntryItemMigrationSource,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  ProfitabilitySegment,
  '' AS UICT_FinancialTransactionType,
  '' AS UICT_PostingKey,
  '' AS UICT_Customer,
  '' AS UICT_Supplier,
  '' AS UICT_BranchAccount,
  '' AS UICT_PartnerCompany,
  '' AS UICT_GLAccount,
  '' AS UICT_CreditAmount,
  '' AS UICT_CreditAmtInFreeDfndCrcy1,
  '' AS UICT_CreditAmtInFreeDfndCrcy2,
  '' AS UICT_CreditAmtInFreeDfndCrcy3,
  '' AS UICT_CreditAmtInFreeDfndCrcy4,
  '' AS UICT_CreditAmtInFreeDfndCrcy5,
  '' AS UICT_CreditAmtInFreeDfndCrcy6,
  '' AS UICT_CreditAmtInFreeDfndCrcy7,
  '' AS UICT_CreditAmtInFreeDfndCrcy8,
  '' AS UICT_DebitAmount,
  '' AS UICT_DebitAmtInFreeDfndCrcy1,
  '' AS UICT_DebitAmtInFreeDfndCrcy2,
  '' AS UICT_DebitAmtInFreeDfndCrcy3,
  '' AS UICT_DebitAmtInFreeDfndCrcy4,
  '' AS UICT_DebitAmtInFreeDfndCrcy5,
  '' AS UICT_DebitAmtInFreeDfndCrcy6,
  '' AS UICT_DebitAmtInFreeDfndCrcy7,
  '' AS UICT_DebitAmtInFreeDfndCrcy8,
  '' AS UICT_DocumentItemText,
  '' AS UICT_AssignmentReference,
  '' AS UICT_Reference1IDByBizPartner,
  '' AS UICT_Reference2IDByBizPartner,
  '' AS UICT_Reference3IDByBizPartner,
  '' AS UICT_ClearingJournalEntry,
  '' AS UICT_ClearingDate,
  '' AS UICT_BranchCode,
  '' AS UICT_Quantity,
  '' AS UICT_PerfPeriodStartDate,
  '' AS UICT_PerformancePeriodEndDate,
  '' AS UICT_SubLedgerAcctLineItemType,
  '' AS UICT_ServicesRenderedDate,
  '' AS UICT_AccountAssignmentType,
  '' AS UICT_AccountAssignment,
  '' AS UICT_PrtnAccountAssignmentType,
  '' AS UICT_PartnerAccountAssignment,
  '' AS UICT_BusinessArea,
  '' AS UICT_PartnerBusinessArea,
  '' AS UICT_CompanyCode,
  '' AS UICT_ControllingArea,
  '' AS UICT_Product,
  '' AS UICT_CostCenter,
  '' AS UICT_OrderID,
  '' AS UICT_WBSElementExternalID,
  '' AS UICT_SalesDocument,
  '' AS UICT_SalesDocumentItem,
  '' AS UICT_ScheduleLine,
  '' AS UICT_PersonnelNumber,
  '' AS UICT_ProjectNetwork,
  '' AS UICT_Plant,
  '' AS UICT_ProfitCenter,
  '' AS UICT_PartnerProfitCenter,
  '' AS UICT_CostObject,
  '' AS UICT_FunctionalArea,
  '' AS UICT_CostCtrActivityType,
  '' AS UICT_BusinessProcess,
  '' AS UICT_Segment,
  '' AS UICT_PartnerSegment,
  '' AS UICT_EarmarkedFundsDocument,
  '' AS UICT_EmrkdFundsDocumentItem,
  '' AS UICT_LineItemIsCompleted,
  '' AS UICT_ValueDate,
  '' AS UICT_PaymentMethod,
  '' AS UICT_PaymentMethodSupplement,
  '' AS UICT_PaymentBlockingReason,
  '' AS UICT_HouseBank,
  '' AS UICT_HouseBankAccount,
  '' AS UICT_BPBankAccountInternalID,
  '' AS UICT_DataExchangeInstruction1,
  '' AS UICT_DataExchangeInstruction2,
  '' AS UICT_DataExchangeInstruction3,
  '' AS UICT_DataExchangeInstruction4,
  '' AS UICT_NetPaymentAmount,
  '' AS UICT_PaymentReference,
  '' AS UICT_AmountInPaymentCurrency,
  '' AS UICT_SEPAMandate,
  '' AS UICT_HasPaymentOrder,
  '' AS UICT_PaymentReason,
  '' AS UICT_CashDiscountBaseAmount,
  '' AS UICT_CashDiscountAmount,
  '' AS UICT_IsNotCashDiscountLiable,
  '' AS UICT_DueCalculationBaseDate,
  '' AS UICT_PaymentTerms,
  '' AS UICT_CashDiscount1Days,
  '' AS UICT_CashDiscount1Percent,
  '' AS UICT_CashDiscount2Days,
  '' AS UICT_CashDiscount2Percent,
  '' AS UICT_NetPaymentDays,
  '' AS UICT_FixedCashDiscount,
  '' AS UICT_PurchasingDocument,
  '' AS UICT_PurchasingDocumentItem,
  '' AS UICT_BillingDocument,
  '' AS UICT_InvoiceList,
  '' AS UICT_InvoiceReference,
  '' AS UICT_FollowOnDocumentType,
  '' AS UICT_InvoiceRefFiscalYear,
  '' AS UICT_InvoiceItemReference,
  '' AS UICT_SpecialGLAcctAssignment,
  '' AS UICT_SpecialGLCode,
  '' AS UICT_DunningArea,
  '' AS UICT_LastDunningDate,
  '' AS UICT_DunningBlockingReason,
  '' AS UICT_DunningLevel,
  '' AS UICT_DunningKey,
  '' AS UICT_PaymentDifferenceReason,
  '' AS UICT_AssetClass,
  '' AS UICT_MasterFixedAsset,
  '' AS UICT_FixedAsset,
  '' AS UICT_AssetDepreciationArea,
  '' AS UICT_AssetTransactionType,
  '' AS UICT_AssetValueDate,
  '' AS UICT_DepreciationFiscalPeriod,
  '' AS UICT_PartnerMasterFixedAsset,
  '' AS UICT_PartnerFixedAsset,
  '' AS UICT_TaxCode,
  '' AS UICT_TaxJurisdiction,
  '' AS UICT_TaxBaseAmountInCoCodeCrcy,
  '' AS UICT_TaxBaseAmountInTransCrcy,
  '' AS UICT_WithholdingTaxCode,
  '' AS UICT_WithholdingTaxAmount,
  '' AS UICT_WhgdTaxExemptionAmt,
  '' AS UICT_WithholdingTaxCertificate,
  '' AS UICT_WithholdingTaxBaseAmount,
  '' AS UICT_IsEUTriangularDeal,
  '' AS UICT_VATRegistration,
  '' AS UICT_Region,
  '' AS UICT_TaxDeterminationDate,
  '' AS UICT_TaxRateValidityStartDate,
  '' AS UICT_TaxCountry,
  '' AS UICT_BusinessPlace,
  '' AS UICT_SupplyingCountry,
  '' AS UICT_StateCntrlBkPaymentReason,
  '' AS UICT_CashLedgerCompanyCode,
  '' AS UICT_CashLedgerAccount,
  '' AS UICT_PubSecBudgetAccount,
  '' AS UICT_PubSecBudgetCnsmpnDate,
  '' AS UICT_PubSecBdgtCnsmpnFsclPerd,
  '' AS UICT_PubSecBdgtCnsmpnFsclYr,
  '' AS UICT_PubSecBudgetIsRelevant,
  '' AS UICT_PubSecBudgetCnsmpnType,
  '' AS UICT_PubSecBudgetCnsmpnAmtType,
  '' AS UICT_SponsoredProgram,
  '' AS UICT_SponsoredClass,
  '' AS UICT_GteeMBudgetValidityNumber,
  '' AS UICT_JointVenture,
  '' AS UICT_JointVentureEquityGroup,
  '' AS UICT_JntVntrCostRecoveryCode,
  '' AS UICT_JointVentureEquityType,
  '' AS UICT_ConsolidationUnit,
  '' AS UICT_PartnerConsolidationUnit,
  '' AS UICT_Company,
  '' AS UICT_CnsldtnChartOfAccounts,
  '' AS UICT_CnsldtnFinStatementItem,
  '' AS UICT_CnsldtnSubitemCategory,
  '' AS UICT_CnsldtnSubitem,
  '' AS UICT_FinancialManagementArea,
  '' AS UICT_FundsCenter,
  '' AS UICT_FundedProgram,
  '' AS UICT_Fund,
  '' AS UICT_GrantID,
  '' AS UICT_BudgetPeriod,
  '' AS UICT_PartnerFund,
  '' AS UICT_PartnerGrant,
  '' AS UICT_PartnerBudgetPeriod,
  '' AS UICT_PubSecBudgetAccountCoCode,
  '' AS UICT_ProfitabilitySegment,
  '' AS UICT_CommitmentItem,
  cast ('' as abap.char(1)) AS UICT_AuditMask,
  _AccountAssignmentTypeT.AccountAssignmentTypeName AS AccountAssignmentTypeName,
  _AlternativeGLAccountText.GLAccountName AS AlternativeGLAccountName,
  _AssetClassText.AssetClassName AS AssetClassName,
  _AssetTransactionTypeText.AssetTransactionTypeName AS AssetTransactionTypeName,
  _BudgetAccountText.BudgetAccountName AS BudgetAccountName,
  _BudgetPeriodText.BudgetPeriodName AS BudgetPeriodName,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  _CashLedgerAccountText.GLAccountName AS CashLedgerAccountName,
  _CashLedgerCompanyCode.CompanyCodeName AS CashLedgerCompanyCodeName,
  _CnsldtnSubItemCategoryText.SubItemCategoryText AS SubItemCategoryText,
  _Company.CompanyName AS CompanyName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _CostCenterText.CostCenterName AS CostCenterName,
  _CostCtrActivityTypeT.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _Customer.CustomerName AS CustomerName,
  _Customer.CustomerName AS CustomerNameForFilter,
  _CustomerGroupText.CustomerGroupName AS CustomerGroupName,
  _CustomerSupplierCountryText.CountryName AS CustomerSupplierCountryName,
  _CustomerSupplierIndustryText.CustomerSupplierIndustryName AS CustomerSupplierIndustryName,
  _FinancialDataSourceT.FinancialDataSourceName AS FinancialDataSourceName,
  _FinancialServicesBranchT.FinancialServicesBranchName AS FinancialServicesBranchName,
  _FinancialTransactionTypeT.FinancialTransactionTypeName AS FinancialTransactionTypeName,
  _FinServicesProductGroupT.FinServicesProductGroupName AS FinServicesProductGroupName,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  _FundText.FundName AS FundName,
  _GLAccountText.GLAccountName AS GLAccountName,
  _GrantText.GrantName AS GrantName,
  _HouseBankAccountText.HouseBankAccountDescription AS HouseBankAccountDescription,
  _HouseBankText.HouseBankName AS HouseBankName,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  _OriginCostCenterText.CostCenterName AS OriginCostCenterName,
  _OriginCostCtrActivityTypeT.CostCtrActivityTypeName AS OriginCostCtrActivityTypeName,
  _OriginProductText.ProductName AS OriginProductName,
  _PartnerAccountAssignmentTypeT.AccountAssignmentTypeName AS PartAccountAssignmentTypeName,
  _PartnerBudgetPeriodText.BudgetPeriodName AS ReceiverPostedBudgetPeriodName,
  _PartnerBusinessAreaText.BusinessAreaName AS PartnerBusinessAreaName,
  _PartnerCompany.CompanyName AS PartnerCompanyName,
  _PartnerCompanyCode.CompanyCodeName AS PartnerCompanyCodeName,
  _PartnerCostCenterText.CostCenterName AS PartnerCostCenterName,
  _PartnerCostCtrActivityTypeT.CostCtrActivityTypeName AS PartnerCostCtrActivityTypeName,
  _PartnerFunctionalAreaText.FunctionalAreaName AS PartnerFunctionalAreaName,
  _PartnerFundText.FundName AS ReceiverPostedFundName,
  _PartnerGrantText.GrantName AS ReceiverPostedGrantName,
  _PartnerProfitCenterText.ProfitCenterName AS PartnerProfitCenterName,
  _PartnerProjectBasicData.ProjectDescription AS PartnerProjectDescription,
  _PartnerSegmentText.SegmentName AS PartnerSegmentName,
  _PartnerWBSElementBasicData.WBSDescription AS PartnerWBSElementDescription,
  _Plant.PlantName AS PlantName,
  _PostingKeyText.PostingKeyName AS PostingKeyName,
  _ProductText.ProductName AS ProductName,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  _ProjectBasicData.ProjectDescription AS ProjectDescription,
  _PubSecBdgtCnsmpnAmtTypeText.PubSecBdgtCnsmpnAmtTypeText AS PubSecBdgtCnsmpnAmtTypeText,
  _PubSecBdgtCnsmpnTypeText.PubSecBudgetCnsmpnTypeText AS PubSecBudgetCnsmpnTypeText,
  _SegmentText.SegmentName AS SegmentName,
  _SpecialGLCodeText.SpecialGLCodeName AS SpecialGLCodeName,
  _SponsoredClassText.SponsoredClassName AS SponsoredClassName,
  _SponsoredProgramText.SponsoredProgramName AS SponsoredProgramName,
  _SubLedgerAccLineItemTypeT.SubLedgerAcctLineItemTypeName AS SubLedgerAcctLineItemTypeName,
  _Supplier.SupplierName AS SupplierName,
  _WBSElementBasicData.WBSDescription AS WBSDescription
FROM R_MngJrnlEntrTechLedgerView AS _Item
LEFT OUTER JOIN C_ManageJournalEntryNote AS _Note ON CompanyCode = _Note.CompanyCode AND AccountingDocument = _Note.AccountingDocument AND FiscalYear = _Note.FiscalYear AND LedgerGLLineItem = _Note.LedgerGLLineItem  -- association [0..*]
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]
;