R_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 R_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 R_MngJrnlEntrTechLedgerView AS
SELECT
  cast( _Item.AssetTransactionType as fco_asset_transaction_type preserving type ) AS AssetTransactionType,
  _Item.SourceLedger AS SourceLedger,
  _Item.CompanyCode AS CompanyCode,
  _Item.FiscalYear AS FiscalYear,
  _Item.AccountingDocument AS AccountingDocument,
  _Item.LedgerGLLineItem AS LedgerGLLineItem,
  _Item.LedgerFiscalYear AS LedgerFiscalYear,
  _Item.GLRecordType AS GLRecordType,
  _Item.JrnlEntrAltvFYConsecutiveID AS JrnlEntrAltvFYConsecutiveID,
  _Item.ControllingArea AS ControllingArea,
  _Item.BusinessTransactionCategory AS BusinessTransactionCategory,
  _Item.BusinessTransactionType AS BusinessTransactionType,
  _Item.ReferenceDocumentType AS ReferenceDocumentType,
  _Item.ReferenceDocumentContext AS ReferenceDocumentContext,
  _Item.ReferenceDocument AS ReferenceDocument,
  _Item.ReferenceDocumentItem AS ReferenceDocumentItem,
  _Item.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  _Item.FinancialTransactionType AS FinancialTransactionType,
  _Item.IsReversal AS IsReversal,
  _Item.IsReversed AS IsReversed,
  _Item.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  _Item.ReversalReferenceDocument AS ReversalReferenceDocument,
  _Item.IsSettlement AS IsSettlement,
  _Item.IsSettled AS IsSettled,
  _Item.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  _Item.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  _Item.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  _Item.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  _Item.SourceReferenceDocument AS SourceReferenceDocument,
  _Item.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  _Item.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  _Item.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  _Item.SourceLogicalSystem AS SourceLogicalSystem,
  _Item.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  _Item.IsCommitment AS IsCommitment,
  _Item.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  _Item.GLBusinessTransactionType AS GLBusinessTransactionType,
  _Item.LogicalSystem AS LogicalSystem,
  _Item.GLAccount AS GLAccount,
  _Item.ChartOfAccounts AS ChartOfAccounts,
  _Item.CostCenter AS CostCenter,
  _Item.ProfitCenter AS ProfitCenter,
  _Item.FunctionalArea AS FunctionalArea,
  _Item.BusinessArea AS BusinessArea,
  _Item.Segment AS Segment,
  _Item.PartnerCostCenter AS PartnerCostCenter,
  _Item.PartnerProfitCenter AS PartnerProfitCenter,
  _Item.PartnerFunctionalArea AS PartnerFunctionalArea,
  _Item.PartnerBusinessArea AS PartnerBusinessArea,
  _Item.PartnerCompany AS PartnerCompany,
  _Item.PartnerSegment AS PartnerSegment,
  _Item.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  _Item.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  _Item.TransactionCurrency AS TransactionCurrency,
  _Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _Item.GlobalCurrency AS GlobalCurrency,
  _Item.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _Item.FunctionalCurrency AS FunctionalCurrency,
  _Item.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _Item.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _Item.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _Item.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _Item.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _Item.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _Item.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _Item.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _Item.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _Item.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _Item.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _Item.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _Item.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _Item.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _Item.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _Item.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _Item.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _Item.ControllingObjectCurrency AS ControllingObjectCurrency,
  _Item.AmountInObjectCurrency AS AmountInObjectCurrency,
  _Item.GrantCurrency AS GrantCurrency,
  _Item.AmountInGrantCurrency AS AmountInGrantCurrency,
  _Item.CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
  _Item.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  _Item.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  _Item.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  _Item.CreditAmountInFunctionalCrcy AS CreditAmountInFunctionalCrcy,
  _Item.CreditAmountInFreeDfndCrcy1 AS CreditAmountInFreeDfndCrcy1,
  _Item.CreditAmountInFreeDfndCrcy2 AS CreditAmountInFreeDfndCrcy2,
  _Item.CreditAmountInFreeDfndCrcy3 AS CreditAmountInFreeDfndCrcy3,
  _Item.CreditAmountInFreeDfndCrcy4 AS CreditAmountInFreeDfndCrcy4,
  _Item.CreditAmountInFreeDfndCrcy5 AS CreditAmountInFreeDfndCrcy5,
  _Item.CreditAmountInFreeDfndCrcy6 AS CreditAmountInFreeDfndCrcy6,
  _Item.CreditAmountInFreeDfndCrcy7 AS CreditAmountInFreeDfndCrcy7,
  _Item.CreditAmountInFreeDfndCrcy8 AS CreditAmountInFreeDfndCrcy8,
  _Item.DebitAmountInBalanceTransCrcy AS DebitAmountInBalanceTransCrcy,
  _Item.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  _Item.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  _Item.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  _Item.DebitAmountInFunctionalCrcy AS DebitAmountInFunctionalCrcy,
  _Item.DebitAmountInFreeDfndCrcy1 AS DebitAmountInFreeDfndCrcy1,
  _Item.DebitAmountInFreeDfndCrcy2 AS DebitAmountInFreeDfndCrcy2,
  _Item.DebitAmountInFreeDfndCrcy3 AS DebitAmountInFreeDfndCrcy3,
  _Item.DebitAmountInFreeDfndCrcy4 AS DebitAmountInFreeDfndCrcy4,
  _Item.DebitAmountInFreeDfndCrcy5 AS DebitAmountInFreeDfndCrcy5,
  _Item.DebitAmountInFreeDfndCrcy6 AS DebitAmountInFreeDfndCrcy6,
  _Item.DebitAmountInFreeDfndCrcy7 AS DebitAmountInFreeDfndCrcy7,
  _Item.DebitAmountInFreeDfndCrcy8 AS DebitAmountInFreeDfndCrcy8,
  _Item.BaseUnit AS BaseUnit,
  _Item.Quantity AS Quantity,
  _Item.FixedQuantity AS FixedQuantity,
  _Item.CostSourceUnit AS CostSourceUnit,
  _Item.ValuationQuantity AS ValuationQuantity,
  _Item.ValuationFixedQuantity AS ValuationFixedQuantity,
  _Item.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  _Item.AdditionalQuantity1 AS AdditionalQuantity1,
  _Item.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  _Item.AdditionalQuantity2 AS AdditionalQuantity2,
  _Item.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  _Item.AdditionalQuantity3 AS AdditionalQuantity3,
  _Item.DebitCreditCode AS DebitCreditCode,
  _Item.ExchangeRateDate AS ExchangeRateDate,
  _Item.FiscalPeriod AS FiscalPeriod,
  _Item.FiscalYearVariant AS FiscalYearVariant,
  _Item.FiscalYearPeriod AS FiscalYearPeriod,
  _Item.PostingDate AS PostingDate,
  _Item.DocumentDate AS DocumentDate,
  _Item.AccountingDocumentType AS AccountingDocumentType,
  _Item.AccountingDocumentItem AS AccountingDocumentItem,
  _Item.AssignmentReference AS AssignmentReference,
  _Item.AccountingDocumentCategory AS AccountingDocumentCategory,
  _Item.PostingKey AS PostingKey,
  _Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  _Item.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  _Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _Item.CreationDate AS CreationDate,
  _Item.CreationDateTime AS CreationDateTime,
  _Item.EliminationProfitCenter AS EliminationProfitCenter,
  _Item.OriginObjectType AS OriginObjectType,
  _Item.GLAccountType AS GLAccountType,
  _Item.AlternativeGLAccount AS AlternativeGLAccount,
  _Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  _Item.ConsolidationUnit AS ConsolidationUnit,
  _Item.InvoiceReference AS InvoiceReference,
  _Item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _Item.FollowOnDocumentType AS FollowOnDocumentType,
  _Item.InvoiceItemReference AS InvoiceItemReference,
  _Item.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  _Item.Company AS Company,
  _Item.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _Item.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  _Item.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  _Item.CnsldtnSubitem AS CnsldtnSubitem,
  _Item.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  _Item.PurchasingDocument AS PurchasingDocument,
  _Item.PurchasingDocumentItem AS PurchasingDocumentItem,
  _Item.AccountAssignmentNumber AS AccountAssignmentNumber,
  _Item.DocumentItemText AS DocumentItemText,
  _Item.SalesDocument AS SalesDocument,
  _Item.SalesDocumentItem AS SalesDocumentItem,
  _Item.Product AS Product,
  _Item.ProductGroup AS ProductGroup,
  _Item.Plant AS Plant,
  _Item.Supplier AS Supplier,
  _Item.Customer AS Customer,
  _Item.ServicesRenderedDate AS ServicesRenderedDate,
  _Item.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  _Item.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  _Item.FinancialAccountType AS FinancialAccountType,
  _Item.SpecialGLCode AS SpecialGLCode,
  _Item.TaxCode AS TaxCode,
  _Item.TaxCountry AS TaxCountry,
  _Item.HouseBank AS HouseBank,
  _Item.HouseBankAccount AS HouseBankAccount,
  _Item.IsOpenItemManaged AS IsOpenItemManaged,
  _Item.ClearingDate AS ClearingDate,
  _Item.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  _Item.ClearingJournalEntry AS ClearingJournalEntry,
  _Item.IsCleared AS IsCleared,
  _Item.ValueDate AS ValueDate,
  _Item.AssetDepreciationArea AS AssetDepreciationArea,
  _Item.MasterFixedAsset AS MasterFixedAsset,
  _Item.FixedAsset AS FixedAsset,
  _Item.AssetValueDate AS AssetValueDate,
  _Item.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  _Item.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  _Item.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  _Item.GroupFixedAsset AS GroupFixedAsset,
  _Item.AssetClass AS AssetClass,
  _Item.CostEstimate AS CostEstimate,
  _Item.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  _Item.InventorySpecialStockType AS InventorySpecialStockType,
  _Item.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  _Item.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  _Item.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  _Item.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  _Item.InventoryValuationType AS InventoryValuationType,
  _Item.ValuationArea AS ValuationArea,
  _Item.InvtrySpclStockWBSElmntExtID AS InvtrySpclStockWBSElmntExtID,
  _Item.ProductPriceControl AS ProductPriceControl,
  _Item.SenderGLAccount AS SenderGLAccount,
  _Item.SenderAccountAssignment AS SenderAccountAssignment,
  _Item.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  _Item.ControllingObject AS ControllingObject,
  _Item.CostOriginGroup AS CostOriginGroup,
  _Item.OriginSenderObject AS OriginSenderObject,
  _Item.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _Item.ControllingObjectDebitType AS ControllingObjectDebitType,
  _Item.QuantityIsIncomplete AS QuantityIsIncomplete,
  _Item.OffsettingAccount AS OffsettingAccount,
  _Item.OffsettingAccountType AS OffsettingAccountType,
  _Item.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  _Item.LineItemIsCompleted AS LineItemIsCompleted,
  _Item.PersonnelNumber AS PersonnelNumber,
  _Item.BillableControl AS BillableControl,
  _Item.ControllingObjectClass AS ControllingObjectClass,
  _Item.PartnerCompanyCode AS PartnerCompanyCode,
  _Item.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  _Item.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  _Item.OriginCostCenter AS OriginCostCenter,
  _Item.OriginProfitCenter AS OriginProfitCenter,
  _Item.OriginProduct AS OriginProduct,
  _Item.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  _Item.AccountAssignment AS AccountAssignment,
  _Item.AccountAssignmentType AS AccountAssignmentType,
  _Item.CostCtrActivityType AS CostCtrActivityType,
  _Item.OrderID AS OrderID,
  _Item.OrderCategory AS OrderCategory,
  _Item.WBSElementInternalID AS WBSElementInternalID,
  _Item.WBSElementExternalID AS WBSElementExternalID,
  _Item.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  _Item.PartnerWBSElementExternalID AS PartnerWBSElementExternalID,
  _Item.WorkPackage AS WorkPackage,
  _Item.ProjectInternalID AS ProjectInternalID,
  _Item.PartnerProjectInternalID AS PartnerProjectInternalID,
  _Item.PartnerProjectExternalID AS PartnerProjectExternalID,
  _Item.ProjectExternalID AS ProjectExternalID,
  _Item.OperatingConcern AS OperatingConcern,
  _Item.ProjectNetwork AS ProjectNetwork,
  _Item.RelatedNetworkActivity AS RelatedNetworkActivity,
  _Item.BusinessProcess AS BusinessProcess,
  _Item.CostObject AS CostObject,
  _Item.CostAnalysisResource AS CostAnalysisResource,
  _Item.CustomerServiceNotification AS CustomerServiceNotification,
  _Item.ServiceDocumentType AS ServiceDocumentType,
  _Item.ServiceDocument AS ServiceDocument,
  _Item.ServiceDocumentItem AS ServiceDocumentItem,
  _Item.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  _Item.PartnerServiceDocument AS PartnerServiceDocument,
  _Item.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  _Item.ServiceContractType AS ServiceContractType,
  _Item.ServiceContract AS ServiceContract,
  _Item.ServiceContractItem AS ServiceContractItem,
  _Item.BusinessSolutionOrder AS BusinessSolutionOrder,
  _Item.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  _Item.ProviderContract AS ProviderContract,
  _Item.ProviderContractItem AS ProviderContractItem,
  _Item.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _Item.PartnerAccountAssignment AS PartnerAccountAssignment,
  _Item.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  _Item.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  _Item.PartnerOrder AS PartnerOrder,
  _Item.PartnerOrderCategory AS PartnerOrderCategory,
  _Item.PartnerSalesDocument AS PartnerSalesDocument,
  _Item.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  _Item.PartnerProjectNetwork AS PartnerProjectNetwork,
  _Item.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  _Item.PartnerBusinessProcess AS PartnerBusinessProcess,
  _Item.PartnerCostObject AS PartnerCostObject,
  _Item.WorkItem AS WorkItem,
  _Item.BillingDocumentType AS BillingDocumentType,
  _Item.SalesOrganization AS SalesOrganization,
  _Item.DistributionChannel AS DistributionChannel,
  _Item.OrganizationDivision AS OrganizationDivision,
  _Item.SoldProduct AS SoldProduct,
  _Item.SoldProductGroup AS SoldProductGroup,
  _Item.CustomerGroup AS CustomerGroup,
  _Item.CustomerSupplierCountry AS CustomerSupplierCountry,
  _Item.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  _Item.SalesDistrict AS SalesDistrict,
  _Item.BillToParty AS BillToParty,
  _Item.ShipToParty AS ShipToParty,
  _Item.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  _Item.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  _Item.CashLedgerAccount AS CashLedgerAccount,
  _Item.FinancialManagementArea AS FinancialManagementArea,
  _Item.FundsCenter AS FundsCenter,
  _Item.FundedProgram AS FundedProgram,
  _Item.Fund AS Fund,
  _Item.GrantID AS GrantID,
  _Item.BudgetPeriod AS BudgetPeriod,
  _Item.PartnerFund AS PartnerFund,
  _Item.PartnerGrant AS PartnerGrant,
  _Item.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  _Item.PubSecBudgetAccount AS PubSecBudgetAccount,
  _Item.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  _Item.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  _Item.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  _Item.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  _Item.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  _Item.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  _Item.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  _Item.SponsoredProgram AS SponsoredProgram,
  _Item.SponsoredClass AS SponsoredClass,
  _Item.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  _Item.CommitmentItem AS CommitmentItem,
  _Item.JointVenture AS JointVenture,
  _Item.JointVentureEquityGroup AS JointVentureEquityGroup,
  _Item.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  _Item.JointVenturePartner AS JointVenturePartner,
  _Item.JointVentureBillingType AS JointVentureBillingType,
  _Item.JointVentureEquityType AS JointVentureEquityType,
  _Item.JointVentureProductionDate AS JointVentureProductionDate,
  _Item.JointVentureBillingDate AS JointVentureBillingDate,
  _Item.JointVentureOperationalDate AS JointVentureOperationalDate,
  _Item.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  _Item.SettlementReferenceDate AS SettlementReferenceDate,
  _Item.PartnerVenture AS PartnerVenture,
  _Item.PartnerEquityGroup AS PartnerEquityGroup,
  _Item.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  _Item.CutbackAccount AS CutbackAccount,
  _Item.CutbackCostObject AS CutbackCostObject,
  _Item.REBusinessEntity AS REBusinessEntity,
  _Item.RealEstateBuilding AS RealEstateBuilding,
  _Item.RealEstateProperty AS RealEstateProperty,
  _Item.RERentalObject AS RERentalObject,
  _Item.RealEstateContract AS RealEstateContract,
  _Item.REServiceChargeKey AS REServiceChargeKey,
  _Item.RESettlementUnitID AS RESettlementUnitID,
  _Item.AccrualObjectType AS AccrualObjectType,
  _Item.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  _Item.AccrualObject AS AccrualObject,
  _Item.AccrualSubobject AS AccrualSubobject,
  _Item.AccrualItemType AS AccrualItemType,
  _Item.AccrualReferenceObject AS AccrualReferenceObject,
  _Item.AccrualValueDate AS AccrualValueDate,
  _Item.FinancialValuationObjectType AS FinancialValuationObjectType,
  _Item.FinancialValuationObject AS FinancialValuationObject,
  _Item.FinancialValuationSubobject AS FinancialValuationSubobject,
  _Item.NetDueDate AS NetDueDate,
  _Item.CreditRiskClass AS CreditRiskClass,
  _Item.IsNegativePosting AS IsNegativePosting,
  _Item.IsStatisticalOrder AS IsStatisticalOrder,
  _Item.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  _Item.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  _Item.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  _Item.OrderOperation AS OrderOperation,
  _Item.JrnlEntryItemMigrationSource AS JrnlEntryItemMigrationSource,
  _Item.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  _Item.FinancialServicesBranch AS FinancialServicesBranch,
  _Item.FinancialDataSource AS FinancialDataSource,
  _Item.ProfitabilitySegment AS ProfitabilitySegment,
  _Item._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  _Item._Order AS _Order,
  _Item._AccountingDocumentType AS _AccountingDocumentType,
  _Item._ServiceDocument AS _ServiceDocument,
  _Item._SalesDocument AS _SalesDocument
FROM P_ManageJournalEntryLedgerView AS _Item
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]
LEFT OUTER JOIN I_Ledger AS _Ledger ON SourceLedger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCode ON PartnerCompanyCode = _PartnerCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionTypeT AS _FinancialTransactionTypeT ON FinancialTransactionType = _FinancialTransactionTypeT.FinancialTransactionType AND _FinancialTransactionTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount AND _GLAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND PostingDate <= _CostCenterText.ValidityEndDate AND PostingDate >= _CostCenterText.ValidityStartDate AND _CostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _OriginCostCenterText ON ControllingArea = _OriginCostCenterText.ControllingArea AND OriginCostCenter = _OriginCostCenterText.CostCenter AND PostingDate <= _OriginCostCenterText.ValidityEndDate AND PostingDate >= _OriginCostCenterText.ValidityStartDate AND _OriginCostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _PartnerCostCenterText ON ControllingArea = _PartnerCostCenterText.ControllingArea AND PartnerCostCenter = _PartnerCostCenterText.CostCenter AND PostingDate <= _PartnerCostCenterText.ValidityEndDate AND PostingDate >= _PartnerCostCenterText.ValidityStartDate AND _PartnerCostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND PostingDate <= _ProfitCenterText.ValidityEndDate AND PostingDate >= _ProfitCenterText.ValidityStartDate AND _ProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _PartnerProfitCenterText ON ControllingArea = _PartnerProfitCenterText.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenterText.ProfitCenter AND PostingDate <= _PartnerProfitCenterText.ValidityEndDate AND PostingDate >= _PartnerProfitCenterText.ValidityStartDate AND _PartnerProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _PartnerFunctionalAreaText ON PartnerFunctionalArea = _PartnerFunctionalAreaText.FunctionalArea AND _PartnerFunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea AND _PartnerBusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment AND _SegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment AND _PartnerSegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_PostingKeyText AS _PostingKeyText ON PostingKey = _PostingKeyText.PostingKey AND _PostingKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemTypeT AS _SubLedgerAccLineItemTypeT ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemTypeT.SubLedgerAcctLineItemType AND _SubLedgerAccLineItemTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _AlternativeGLAccountText ON CountryChartOfAccounts = _AlternativeGLAccountText.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccountText.GLAccount AND _AlternativeGLAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _Company ON Company = _Company.Company  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategoryText AS _CnsldtnSubItemCategoryText ON CnsldtnSubitemCategory = _CnsldtnSubItemCategoryText.SubItemCategory AND _CnsldtnSubItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCodeText AS _SpecialGLCodeText ON FinancialAccountType = _SpecialGLCodeText.FinancialAccountType AND SpecialGLCode = _SpecialGLCodeText.SpecialGLCode AND _SpecialGLCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionTypeText AS _AssetTransactionTypeText ON AssetTransactionType = _AssetTransactionTypeText.AssetTransactionType AND _AssetTransactionTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AssetClassText AS _AssetClassText ON AssetClass = _AssetClassText.AssetClass AND _AssetClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _OriginCostCtrActivityTypeT ON ControllingArea = _OriginCostCtrActivityTypeT.ControllingArea AND OriginCostCtrActivityType = _OriginCostCtrActivityTypeT.CostCtrActivityType AND PostingDate <= _OriginCostCtrActivityTypeT.ValidityEndDate AND PostingDate >= _OriginCostCtrActivityTypeT.ValidityStartDate AND _OriginCostCtrActivityTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCtrActivityTypeT ON ControllingArea = _CostCtrActivityTypeT.ControllingArea AND CostCtrActivityType = _CostCtrActivityTypeT.CostCtrActivityType AND PostingDate <= _CostCtrActivityTypeT.ValidityEndDate AND PostingDate >= _CostCtrActivityTypeT.ValidityStartDate AND _CostCtrActivityTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _PartnerCostCtrActivityTypeT ON ControllingArea = _PartnerCostCtrActivityTypeT.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityTypeT.CostCtrActivityType AND PostingDate <= _PartnerCostCtrActivityTypeT.ValidityEndDate AND PostingDate >= _PartnerCostCtrActivityTypeT.ValidityStartDate AND _PartnerCostCtrActivityTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _OriginProductText ON OriginProduct = _OriginProductText.Product AND _OriginProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElementBasicData ON PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicData ON PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CustomerSupplierCountryText ON CustomerSupplierCountry = _CustomerSupplierCountryText.Country AND _CustomerSupplierCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CashLedgerCompanyCode ON CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _CashLedgerAccountText ON CashLedgerCompanyCode = _CashLedgerAccountText.CompanyCode AND CashLedgerAccount = _CashLedgerAccountText.GLAccount AND _CashLedgerAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund AND _FundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod AND _BudgetPeriodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON FinancialManagementArea = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund AND _PartnerFundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _PartnerGrantText ON PartnerGrant = _PartnerGrantText.GrantID AND _PartnerGrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _PartnerBudgetPeriodText ON PartnerBudgetPeriod = _PartnerBudgetPeriodText.BudgetPeriod AND _PartnerBudgetPeriodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccountText AS _BudgetAccountText ON PubSecBudgetAccount = _BudgetAccountText.PubSecBudgetAccount AND PubSecBudgetAccountCoCode = _BudgetAccountText.PubSecBudgetAccountCoCode AND _BudgetAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnTypeText AS _PubSecBdgtCnsmpnTypeText ON PubSecBudgetCnsmpnType = _PubSecBdgtCnsmpnTypeText.PubSecBudgetCnsmpnType AND _PubSecBdgtCnsmpnTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnAmtTypeText AS _PubSecBdgtCnsmpnAmtTypeText ON PubSecBudgetCnsmpnAmtType = _PubSecBdgtCnsmpnAmtTypeText.PubSecBudgetCnsmpnAmtType AND _PubSecBdgtCnsmpnAmtTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SponsoredProgramText AS _SponsoredProgramText ON SponsoredProgram = _SponsoredProgramText.SponsoredProgram AND _SponsoredProgramText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SponsoredClassText AS _SponsoredClassText ON SponsoredClass = _SponsoredClassText.SponsoredClass AND _SponsoredClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentTypeT AS _AccountAssignmentTypeT ON AccountAssignmentType = _AccountAssignmentTypeT.AccountAssignmentType AND _AccountAssignmentTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentTypeT AS _PartnerAccountAssignmentTypeT ON PartnerAccountAssignmentType = _PartnerAccountAssignmentTypeT.AccountAssignmentType AND _PartnerAccountAssignmentTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinServicesProductGroupT AS _FinServicesProductGroupT ON FinancialServicesProductGroup = _FinServicesProductGroupT.FinancialServicesProductGroup AND _FinServicesProductGroupT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialServicesBranchT AS _FinancialServicesBranchT ON FinancialServicesBranch = _FinancialServicesBranchT.FinancialServicesBranch AND _FinancialServicesBranchT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialDataSourceT AS _FinancialDataSourceT ON FinancialDataSource = _FinancialDataSourceT.FinancialDataSource AND _FinancialDataSourceT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustryText AS _CustomerSupplierIndustryText ON CustomerSupplierIndustry = _CustomerSupplierIndustryText.Industry AND _CustomerSupplierIndustryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroupText AS _CustomerGroupText ON CustomerGroup = _CustomerGroupText.CustomerGroup AND _CustomerGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HouseBankText AS _HouseBankText ON HouseBank = _HouseBankText.HouseBank AND CompanyCode = _HouseBankText.CompanyCode AND HouseBankAccount = _HouseBankText.HouseBankAccount AND _HouseBankText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON HouseBank = _HouseBankAccountText.HouseBank AND CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount AND _HouseBankAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
;