C_MngJrnlEntrSpcfcLedgerView

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_MngJrnlEntrSpcfcLedgerView.
-- 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_MngJrnlEntrSpcfcLedgerView AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  _LedgerText.LedgerName AS LedgerName,
  cast(_CompanyCode.CompanyCodeName as fis_butxt preserving type) AS CompanyCodeName,
  Ledger,
  LedgerFiscalYear,
  GLRecordType,
  JrnlEntrAltvFYConsecutiveID,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  BusinessTransactionCategory,
  _BusTransactionCategoryText.BusTransactionCategoryName AS BusTransactionCategoryName,
  BusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  FinancialTransactionType,
  cast(_FinancialTransactionTypeT.FinancialTransactionTypeName as fincs_fintransactiontypename preserving type) AS FinancialTransactionTypeName,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocItem,
  PredecessorReferenceDocType,
  PredecessorReferenceDocument,
  SourceReferenceDocument,
  SourceReferenceDocumentType,
  SourceReferenceDocumentItem,
  SourceReferenceDocumentCntxt,
  SourceLogicalSystem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  cast(_JrnlEntryItemObsltRsnText.JrnlEntryItemObsoleteRsnName as jrnlentryitemobsoletersnname preserving type) AS JrnlEntryItemObsoleteRsnName,
  GLBusinessTransactionType,
  LogicalSystem,
  GLAccount,
  _GLAccountText.GLAccountName AS GLAccountName,
  _GLAccountText.GLAccountLongName AS GLAccountLongName,
  ChartOfAccounts,
  CostCenter,
  _CostCenterText.CostCenterName AS CostCenterName,
  ProfitCenter,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  Segment,
  _SegmentText.SegmentName AS SegmentName,
  PartnerCostCenter,
  cast(_PartnerCostCenterText.CostCenterName as fco_partner_cost_center_name preserving type) AS PartnerCostCenterName,
  PartnerProfitCenter,
  cast(_PartnerProfitCenterText.ProfitCenterName as fis_partner_prctr_short_name preserving type) AS PartnerProfitCenterName,
  PartnerFunctionalArea,
  cast(_PartnerFunctionalAreaText.FunctionalAreaName as fis_pfkbtx preserving type) AS PartnerFunctionalAreaName,
  PartnerBusinessArea,
  cast(_PartnerBusinessAreaText.BusinessAreaName as fis_partner_gtext_vdm preserving type) AS PartnerBusinessAreaName,
  PartnerCompany,
  cast(_PartnerCompany.CompanyName as fis_rassc_name preserving type) AS PartnerCompanyName,
  PartnerSegment,
  cast(_PartnerSegmentText.SegmentName as fis_partner_segment_name preserving type) AS PartnerSegmentName,
  PrdcssrJournalEntryCompanyCode,
  cast(_PrdcssrJrnlEntrCompanyCode.CompanyCodeName as prdcssrjrnlentrcompanycodename preserving type) AS PrdcssrJrnlEntrCompanyCodeName,
  PrdcssrJournalEntryFiscalYear,
  PredecessorJournalEntry,
  PredecessorJournalEntryItem,
  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,
  _Item.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  _Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _Item.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _Item.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _Item.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _Item.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _Item.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _Item.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _Item.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _Item.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _Item.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _Item.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  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,
  IncmpltSummableValnQtyUnt,
  IncmpltSummableValnQty,
  IncmpltSummableValnFxdQty,
  DebitCreditCode,
  ExchangeRateDate,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  PostingKey,
  _PostingKeyText.PostingKeyName AS PostingKeyName,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  _SubLedgerAccLineItemTypeT.SubLedgerAcctLineItemTypeName AS SubLedgerAcctLineItemTypeName,
  CreationDate,
  CreationDateTime,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  cast(_AlternativeGLAccountText.GLAccountName as alternativeglaccountname preserving type) AS AlternativeGLAccountName,
  CountryChartOfAccounts,
  ConsolidationUnit,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  PartnerConsolidationUnit,
  Company,
  _Company.CompanyName AS CompanyName,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  cast(_CnsldtnSubItemCategoryText.SubItemCategoryText as cnsldtnsubitemcategorytext preserving type) AS CnsldtnSubitemCategoryText,
  CnsldtnSubitem,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesDocument,
  SalesDocumentItem,
  Product,
  _ProductText.ProductName AS ProductName,
  ProductGroup,
  Plant,
  _Plant.PlantName AS PlantName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  cast(_Supplier.Country as fis_supplier_country preserving type ) AS SupplierCountry,
  Customer,
  _Customer.CustomerName AS CustomerName,
  Customer AS CustomerForFilter,
  _Customer.CustomerName AS CustomerNameForFilter,
  cast(_Customer.Country as fis_customer_country preserving type ) AS CustomerCountry,
  ServicesRenderedDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  FinancialAccountType,
  SpecialGLCode,
  cast(_SpecialGLCodeText.SpecialGLCodeLongName as specialglcodelongname preserving type) AS SpecialGLCodeName,
  TaxCode,
  TaxCountry,
  cast(_TaxCountryText.CountryName as fot_tax_country_descr preserving type) AS TaxCountryName,
  HouseBank,
  cast(_HouseBank._Bank.BankName as farp_banka preserving type) AS HouseBankName,
  HouseBankAccount,
  cast(_HouseBankAccountText.HouseBankAccountDescription as /pf1/dte_housebank_acct_desc preserving type) AS HouseBankAccountDescription,
  IsOpenItemManaged,
  ClearingDate,
  ClearingJournalEntryFiscalYear,
  ClearingJournalEntry,
  IsCleared,
  ValueDate,
  AssetDepreciationArea,
  MasterFixedAsset,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  FixedAssetExternalID,
  AssetValueDate,
  AssetTransactionType,
  cast(_AssetTransactionTypeText.AssetTransactionTypeName as assettransactiontypename preserving type) AS AssetTransactionTypeName,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  PartnerMasterFixedAsset,
  PartnerFixedAsset,
  AssetClass,
  cast(_AssetClassText.AssetClassName as faa_assetcla preserving type) AS AssetClassName,
  CostEstimate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  InvtrySpclStockWBSElmntExtID,
  ProductPriceControl,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObject,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  _WorkForcePersonMappings.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  BillableControl,
  ControllingObjectClass,
  PartnerCompanyCode,
  cast(_PartnerCompanyCode.CompanyCodeName as fis_partner_company_code_name preserving type) AS PartnerCompanyCodeName,
  PartnerControllingObjectClass,
  OriginCostCtrActivityType,
  cast(_OriginCostCtrActivityTypeT.CostCtrActivityTypeName as origincostctractivitytypename preserving type) AS OriginCostCtrActivityTypeName,
  OriginCostCenter,
  cast(_OriginCostCenterText.CostCenterName as fis_origin_cost_center_name preserving type) AS OriginCostCenterName,
  OriginProfitCenter,
  OriginProduct,
  cast(_OriginProductText.ProductName as fin_aci_orig_prod_name preserving type) AS OriginProductName,
  VarianceOriginGLAccount,
  AccountAssignment,
  AccountAssignmentType,
  _AccountAssignmentTypeT.AccountAssignmentTypeName AS AccountAssignmentTypeName,
  cast(CostCtrActivityType as fis_cctr_actytyp preserving type) AS CostCtrActivityType,
  _CostCtrActivityTypeT.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  OrderID,
  OrderCategory,
  WBSElementExternalID,
  WBSElementInternalID,
  WBSDescription,
  PartnerWBSElementInternalID,
  PartnerWBSElementExternalID,
  cast(PartnerWBSElementDescription as fis_partner_wbs_description preserving type) AS PartnerWBSElementDescription,
  WorkPackage,
  ProjectInternalID,
  PartnerProjectInternalID,
  PartnerProjectExternalID,
  cast(PartnerProjectDescription as fis_partner_projectdescription preserving type) AS PartnerProjectDescription,
  ProjectExternalID,
  ProjectDescription,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CostAnalysisResource,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  TimeSheetOvertimeCategory,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  cast(_PartnerAccountAssignmentTypeT.AccountAssignmentTypeName as partaccountassignmenttypename preserving type) AS PartAccountAssignmentTypeName,
  PartnerCostCtrActivityType,
  cast(_PartnerCostCtrActivityTypeT.CostCtrActivityTypeName as partnercostctractivitytypename preserving type) AS PartnerCostCtrActivityTypeName,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  WorkItem,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  cast(_CustomerGroupText.CustomerGroupName as fincs_kdgrp_t preserving type) AS CustomerGroupName,
  CustomerSupplierCountry,
  cast(_CustomerSupplierCountryText.CountryName as fincs_land1_t preserving type) AS CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  _CustomerSupplierIndustryText.CustomerSupplierIndustryName AS CustomerSupplierIndustryName,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CashLedgerCompanyCode,
  cast(_CashLedgerCompanyCode.CompanyCodeName as cashledgercompanycodename preserving type) AS CashLedgerCompanyCodeName,
  CashLedgerAccount,
  cast(_CashLedgerAccountText.GLAccountName as fis_re_account_name preserving type) AS CashLedgerAccountName,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  _FundText.FundName AS FundName,
  GrantID,
  cast(_GrantText.GrantName as fco_grant_name preserving type) AS GrantName,
  BudgetPeriod,
  _BudgetPeriodText.BudgetPeriodName AS BudgetPeriodName,
  PartnerFund,
  cast(_PartnerFundText.FundName as receiverpostedfundname preserving type) AS ReceiverPostedFundName,
  PartnerGrant,
  cast(_PartnerGrantText.GrantName as receiverpostedgrantname preserving type) AS ReceiverPostedGrantName,
  PartnerBudgetPeriod,
  cast(_PartnerBudgetPeriodText.BudgetPeriodName as receiverpostedbudgetperiodname preserving type) AS ReceiverPostedBudgetPeriodName,
  PubSecBudgetAccount,
  _BudgetAccountText.BudgetAccountName AS BudgetAccountName,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  _PubSecBdgtCnsmpnTypeText.PubSecBudgetCnsmpnTypeText AS PubSecBudgetCnsmpnTypeText,
  PubSecBudgetCnsmpnAmtType,
  _PubSecBdgtCnsmpnAmtTypeText.PubSecBdgtCnsmpnAmtTypeText AS PubSecBdgtCnsmpnAmtTypeText,
  SponsoredProgram,
  _SponsoredProgramText.SponsoredProgramName AS SponsoredProgramName,
  SponsoredClass,
  _SponsoredClassText.SponsoredClassName AS SponsoredClassName,
  GteeMBudgetValidityNumber,
  CommitmentItem,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVentureBillingType,
  JointVentureEquityType,
  JointVentureProductionDate,
  JointVentureBillingDate,
  JointVentureOperationalDate,
  JointVentureAccountingActivity,
  SettlementReferenceDate,
  PartnerVenture,
  PartnerEquityGroup,
  SenderCostRecoveryCode,
  CutbackAccount,
  CutbackCostObject,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  cast( REServiceChargeKey as fac_mje_rescsckey ) AS REServiceChargeKey,
  cast( RESettlementUnitID as fac_mje_rescsuid ) AS RESettlementUnitID,
  AccrualObjectType,
  AccrualObjectLogicalSystem,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualReferenceObject,
  AccrualValueDate,
  FinancialValuationObjectType,
  FinancialValuationObject,
  FinancialValuationSubobject,
  NetDueDate,
  CreditRiskClass,
  IsNegativePosting,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  OrderOperation,
  JrnlEntryItemMigrationSource,
  AccountingDocCreatedByUser,
  FinancialServicesProductGroup,
  _FinServicesProductGroupT.FinServicesProductGroupName AS FinServicesProductGroupName,
  FinancialServicesBranch,
  _FinancialServicesBranchT.FinancialServicesBranchName AS FinancialServicesBranchName,
  FinancialDataSource,
  _FinancialDataSourceT.FinancialDataSourceName AS FinancialDataSourceName,
  ProfitabilitySegment,
  RevenueAccountingContract,
  PerformanceObligation,
  ComponentBreakdown,
  CompBreakdownScaleNumerator,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  '' AS UICT_FinancialTransactionType,
  '' AS UICT_PostingKey,
  '' AS UICT_Customer,
  '' AS UICT_Supplier,
  '' 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_ClearingJournalEntry,
  '' AS UICT_ClearingDate,
  '' 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_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_LineItemIsCompleted,
  '' AS UICT_ValueDate,
  '' AS UICT_HouseBank,
  '' AS UICT_HouseBankAccount,
  '' AS UICT_PurchasingDocument,
  '' AS UICT_PurchasingDocumentItem,
  '' AS UICT_InvoiceReference,
  '' AS UICT_FollowOnDocumentType,
  '' AS UICT_InvoiceRefFiscalYear,
  '' AS UICT_InvoiceItemReference,
  '' AS UICT_SpecialGLAcctAssignment,
  '' AS UICT_SpecialGLCode,
  '' 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_TaxCountry,
  '' 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,
  '' AS UICT_EarmarkedFundsDocument,
  '' AS UICT_EmrkdFundsDocumentItem,
  cast ('' as abap.char(1)) AS UICT_AuditMask
FROM R_ManageJournalEntryLedgerView AS _Item
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON AccountingDocCreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
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 Ledger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;