C_ManageJournalEntryLedgerView

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_ManageJournalEntryLedgerView.
-- 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_ManageJournalEntryLedgerView AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  _LedgerText.LedgerName AS LedgerName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  LedgerFiscalYear,
  GLRecordType,
  JrnlEntrAltvFYConsecutiveID,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  BusinessTransactionCategory,
  BusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  FinancialTransactionType,
  _FinancialTransactionTypeT.FinancialTransactionTypeName AS FinancialTransactionTypeName,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocItem,
  PredecessorReferenceDocType,
  PredecessorReferenceDocument,
  SourceReferenceDocument,
  SourceReferenceDocumentType,
  SourceReferenceDocumentItem,
  SourceReferenceDocumentCntxt,
  SourceLogicalSystem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  _JrnlEntryItemObsltRsnText.JrnlEntryItemObsoleteRsnName AS JrnlEntryItemObsoleteRsnName,
  GLBusinessTransactionType,
  LogicalSystem,
  GLAccount,
  _GLAccountText.GLAccountName AS GLAccountName,
  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,
  _PartnerCostCenterText.CostCenterName AS PartnerCostCenterName,
  PartnerProfitCenter,
  _PartnerProfitCenterText.ProfitCenterName AS PartnerProfitCenterName,
  PartnerFunctionalArea,
  _PartnerFunctionalAreaText.FunctionalAreaName AS PartnerFunctionalAreaName,
  PartnerBusinessArea,
  _PartnerBusinessAreaText.BusinessAreaName AS PartnerBusinessAreaName,
  PartnerCompany,
  _PartnerCompany.CompanyName AS PartnerCompanyName,
  PartnerSegment,
  _PartnerSegmentText.SegmentName AS PartnerSegmentName,
  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,
  _PostingKeyText.PostingKeyName AS PostingKeyName,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  _SubLedgerAccLineItemTypeT.SubLedgerAcctLineItemTypeName AS SubLedgerAcctLineItemTypeName,
  CreationDate,
  CreationDateTime,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  _AlternativeGLAccountText.GLAccountName AS AlternativeGLAccountName,
  CountryChartOfAccounts,
  ConsolidationUnit,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  PartnerConsolidationUnit,
  Company,
  _Company.CompanyName AS CompanyName,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  _CnsldtnSubItemCategoryText.SubItemCategoryText AS SubItemCategoryText,
  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,
  _SpecialGLCodeText.SpecialGLCodeName AS SpecialGLCodeName,
  TaxCode,
  TaxCountry,
  HouseBank,
  _HouseBankText.HouseBankName AS HouseBankName,
  HouseBankAccount,
  _HouseBankAccountText.HouseBankAccountDescription AS HouseBankAccountDescription,
  IsOpenItemManaged,
  ClearingDate,
  ClearingJournalEntryFiscalYear,
  ClearingJournalEntry,
  IsCleared,
  ValueDate,
  AssetDepreciationArea,
  MasterFixedAsset,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  AssetValueDate,
  AssetTransactionType,
  _AssetTransactionTypeText.AssetTransactionTypeName AS AssetTransactionTypeName,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  PartnerMasterFixedAsset,
  PartnerFixedAsset,
  AssetClass,
  _AssetClassText.AssetClassName AS AssetClassName,
  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,
  _PartnerCompanyCode.CompanyCodeName AS PartnerCompanyCodeName,
  PartnerControllingObjectClass,
  OriginCostCtrActivityType,
  _OriginCostCtrActivityTypeT.CostCtrActivityTypeName AS OriginCostCtrActivityTypeName,
  OriginCostCenter,
  _OriginCostCenterText.CostCenterName AS OriginCostCenterName,
  OriginProfitCenter,
  OriginProduct,
  _OriginProductText.ProductName AS OriginProductName,
  VarianceOriginGLAccount,
  AccountAssignment,
  AccountAssignmentType,
  _AccountAssignmentTypeT.AccountAssignmentTypeName AS AccountAssignmentTypeName,
  CostCtrActivityType,
  _CostCtrActivityTypeT.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  OrderID,
  OrderCategory,
  WBSElementExternalID,
  WBSElementInternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  PartnerWBSElementInternalID,
  PartnerWBSElementExternalID,
  _PartnerWBSElementBasicData.WBSDescription AS PartnerWBSElementDescription,
  WorkPackage,
  ProjectInternalID,
  PartnerProjectInternalID,
  PartnerProjectExternalID,
  _PartnerProjectBasicData.ProjectDescription AS PartnerProjectDescription,
  ProjectExternalID,
  _ProjectBasicData.ProjectDescription AS ProjectDescription,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CostAnalysisResource,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  TimeSheetOvertimeCategory,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  _PartnerAccountAssignmentTypeT.AccountAssignmentTypeName AS PartAccountAssignmentTypeName,
  PartnerCostCtrActivityType,
  _PartnerCostCtrActivityTypeT.CostCtrActivityTypeName AS PartnerCostCtrActivityTypeName,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  WorkItem,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  _CustomerGroupText.CustomerGroupName AS CustomerGroupName,
  CustomerSupplierCountry,
  _CustomerSupplierCountryText.CountryName AS CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  _CustomerSupplierIndustryText.CustomerSupplierIndustryName AS CustomerSupplierIndustryName,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CashLedgerCompanyCode,
  _CashLedgerCompanyCode.CompanyCodeName AS CashLedgerCompanyCodeName,
  CashLedgerAccount,
  _CashLedgerAccountText.GLAccountName AS CashLedgerAccountName,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  _FundText.FundName AS FundName,
  GrantID,
  _GrantText.GrantName AS GrantName,
  BudgetPeriod,
  _BudgetPeriodText.BudgetPeriodName AS BudgetPeriodName,
  PartnerFund,
  _PartnerFundText.FundName AS ReceiverPostedFundName,
  PartnerGrant,
  _PartnerGrantText.GrantName AS ReceiverPostedGrantName,
  PartnerBudgetPeriod,
  _PartnerBudgetPeriodText.BudgetPeriodName 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,
  REServiceChargeKey,
  RESettlementUnitID,
  AccrualObjectType,
  AccrualObjectLogicalSystem,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualReferenceObject,
  AccrualValueDate,
  FinancialValuationObjectType,
  FinancialValuationObject,
  FinancialValuationSubobject,
  NetDueDate,
  CreditRiskClass,
  IsNegativePosting,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  OrderOperation,
  JrnlEntryItemMigrationSource,
  AccountingDocCreatedByUser,
  WithholdingTaxCode,
  BillingDocument,
  ScheduleLine,
  IsNotCashDiscountLiable,
  BranchAccount,
  SpecialGLAccountAssignment,
  DueCalculationBaseDate,
  PaymentTerms,
  _PaymentTermsText.PaymentTermsName AS PaymentTermsName,
  CashDiscountBaseAmount,
  CashDiscountAmount,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  PaymentBlockingReason,
  _PaymentBlockingReasonText.PaymentBlockingReasonName AS PaymentBlockingReasonName,
  FixedCashDiscount,
  BPBankAccountInternalID,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  InvoiceList,
  DunningKey,
  DunningBlockingReason,
  LastDunningDate,
  DunningLevel,
  DunningArea,
  _DunningAreaText.DunningAreaName AS DunningAreaName,
  WithholdingTaxCertificate,
  VATRegistration,
  VATRegistration AS VATRegistrationForFilter,
  PaymentDifferenceReason,
  TaxJurisdiction,
  IsEUTriangularDeal,
  PaymentMethodSupplement,
  Reference1IDByBusinessPartner,
  Reference2IDByBusinessPartner,
  Reference3IDByBusinessPartner,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  Region,
  HasPaymentOrder,
  PaymentReference,
  TaxDeterminationDate,
  BusinessPlace,
  SEPAMandate,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  TaxRateValidityStartDate,
  PaymentReason,
  BranchCode,
  PaymentCurrency,
  NetPaymentAmount,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  WithholdingTaxAmount,
  WithholdingTaxExemptionAmt,
  WithholdingTaxBaseAmount,
  FinancialServicesProductGroup,
  _FinServicesProductGroupT.FinServicesProductGroupName AS FinServicesProductGroupName,
  FinancialServicesBranch,
  _FinancialServicesBranchT.FinancialServicesBranchName AS FinancialServicesBranchName,
  FinancialDataSource,
  _FinancialDataSourceT.FinancialDataSourceName AS FinancialDataSourceName,
  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_WithholdingTaxItem,
  '' 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_OplAcctgDocItmCSRef1,
  cast ('' as abap.sstring( 1332 )) AS UICT_GloMetadata,
  cast ('' as abap.char(1)) AS UICT_AuditMask,
  SampleAccountingDocument,
  AddressAndBankIsSetManually,
  IsOneTimeAccount,
  AlternativePayeeIsAllowed,
  PayerIsAlternativePayer,
  PayeeIsAlternativePayee,
  OplAcctgDocItmCntrySpcfcRef1
FROM R_ManageJournalEntryLedgerView AS _Item
LEFT OUTER JOIN C_MngJrnlEntrWhgdTaxItem AS _WithholdingTaxItem ON CompanyCode = _WithholdingTaxItem.CompanyCode AND AccountingDocument = _WithholdingTaxItem.AccountingDocument AND FiscalYear = _WithholdingTaxItem.FiscalYear AND AccountingDocumentItem = _WithholdingTaxItem.AccountingDocumentItem  -- association [0..*]
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]
;