P_JournalEntryOrders

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 P_JournalEntryOrders.
-- 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 P_JournalEntryOrders AS
SELECT
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
  JournalEntryItem.GLRecordType AS GLRecordType,
  JournalEntryItem.JrnlEntrAltvFYConsecutiveID AS JrnlEntrAltvFYConsecutiveID,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem.FinancialTransactionType AS FinancialTransactionType,
  JournalEntryItem.BusinessTransactionCategory AS BusinessTransactionCategory,
  JournalEntryItem.BusinessTransactionType AS BusinessTransactionType,
  JournalEntryItem.FinancialClosingStep AS FinancialClosingStep,
  JournalEntryItem.ControllingBusTransacType AS ControllingBusTransacType,
  JournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntryItem.LogicalSystem AS LogicalSystem,
  JournalEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  JournalEntryItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  JournalEntryItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  JournalEntryItem.IsReversal AS IsReversal,
  JournalEntryItem.IsReversed AS IsReversed,
  JournalEntryItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  JournalEntryItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntryItem.IsSettlement AS IsSettlement,
  JournalEntryItem.IsSettled AS IsSettled,
  JournalEntryItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  JournalEntryItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  JournalEntryItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  JournalEntryItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  JournalEntryItem.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  JournalEntryItem.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  JournalEntryItem.PredecessorJournalEntry AS PredecessorJournalEntry,
  JournalEntryItem.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  JournalEntryItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  JournalEntryItem.SourceLogicalSystem AS SourceLogicalSystem,
  JournalEntryItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  JournalEntryItem.SourceReferenceDocument AS SourceReferenceDocument,
  JournalEntryItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  JournalEntryItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  JournalEntryItem.IsCommitment AS IsCommitment,
  JournalEntryItem.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  JournalEntryItem.OrganizationalChange AS OrganizationalChange,
  JournalEntryItem.AccountingNotificationUUID AS AccountingNotificationUUID,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem.ProfitCenter AS ProfitCenter,
  JournalEntryItem.FunctionalArea AS FunctionalArea,
  JournalEntryItem.BusinessArea AS BusinessArea,
  JournalEntryItem.Segment AS Segment,
  JournalEntryItem.PartnerCostCenter AS PartnerCostCenter,
  JournalEntryItem.PartnerProfitCenter AS PartnerProfitCenter,
  JournalEntryItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  JournalEntryItem.PartnerBusinessArea AS PartnerBusinessArea,
  JournalEntryItem.PartnerCompany AS PartnerCompany,
  JournalEntryItem.PartnerSegment AS PartnerSegment,
  JournalEntryItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  JournalEntryItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntryItem.GlobalCurrency AS GlobalCurrency,
  JournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  JournalEntryItem.FunctionalCurrency AS FunctionalCurrency,
  JournalEntryItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  JournalEntryItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  JournalEntryItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  JournalEntryItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  JournalEntryItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  JournalEntryItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  JournalEntryItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  JournalEntryItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  JournalEntryItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  JournalEntryItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  JournalEntryItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  JournalEntryItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  JournalEntryItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  JournalEntryItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  JournalEntryItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  JournalEntryItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  JournalEntryItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  JournalEntryItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  JournalEntryItem.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  JournalEntryItem.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  JournalEntryItem.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  JournalEntryItem.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  JournalEntryItem.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  JournalEntryItem.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  JournalEntryItem.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  JournalEntryItem.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  JournalEntryItem.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  JournalEntryItem.ControllingObjectCurrency AS ControllingObjectCurrency,
  JournalEntryItem.AmountInObjectCurrency AS AmountInObjectCurrency,
  JournalEntryItem.GrantCurrency AS GrantCurrency,
  JournalEntryItem.AmountInGrantCurrency AS AmountInGrantCurrency,
  JournalEntryItem.BaseUnit AS BaseUnit,
  JournalEntryItem.Quantity AS Quantity,
  JournalEntryItem.FixedQuantity AS FixedQuantity,
  JournalEntryItem.CostSourceUnit AS CostSourceUnit,
  JournalEntryItem.ValuationQuantity AS ValuationQuantity,
  JournalEntryItem.ValuationFixedQuantity AS ValuationFixedQuantity,
  JournalEntryItem.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  JournalEntryItem.ReferenceQuantity AS ReferenceQuantity,
  JournalEntryItem.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  JournalEntryItem.AdditionalQuantity1 AS AdditionalQuantity1,
  JournalEntryItem.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  JournalEntryItem.AdditionalQuantity2 AS AdditionalQuantity2,
  JournalEntryItem.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  JournalEntryItem.AdditionalQuantity3 AS AdditionalQuantity3,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem.FiscalPeriod AS FiscalPeriod,
  JournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  JournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.DocumentDate AS DocumentDate,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItem.AssignmentReference AS AssignmentReference,
  JournalEntryItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntryItem.JournalEntryItemCategory AS JournalEntryItemCategory,
  JournalEntryItem.PostingKey AS PostingKey,
  JournalEntryItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  JournalEntryItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  JournalEntryItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  JournalEntryItem.LastChangeDateTime AS LastChangeDateTime,
  JournalEntryItem.CreationDateTime AS CreationDateTime,
  JournalEntryItem.CreationDate AS CreationDate,
  JournalEntryItem.EliminationProfitCenter AS EliminationProfitCenter,
  JournalEntryItem.OriginObjectType AS OriginObjectType,
  JournalEntryItem.GLAccountType AS GLAccountType,
  JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  JournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  JournalEntryItem.ConsolidationUnit AS ConsolidationUnit,
  JournalEntryItem.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  JournalEntryItem.Company AS Company,
  JournalEntryItem.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  JournalEntryItem.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  JournalEntryItem.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  JournalEntryItem.CnsldtnSubitem AS CnsldtnSubitem,
  JournalEntryItem.InvoiceReference AS InvoiceReference,
  JournalEntryItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  JournalEntryItem.FollowOnDocumentType AS FollowOnDocumentType,
  JournalEntryItem.InvoiceItemReference AS InvoiceItemReference,
  JournalEntryItem.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  JournalEntryItem.PurchasingDocument AS PurchasingDocument,
  JournalEntryItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  JournalEntryItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  JournalEntryItem.DocumentItemText AS DocumentItemText,
  JournalEntryItem.SalesOrder AS SalesOrder,
  JournalEntryItem.SalesOrderItem AS SalesOrderItem,
  JournalEntryItem.SalesDocument AS SalesDocument,
  JournalEntryItem.SalesDocumentItem AS SalesDocumentItem,
  JournalEntryItem.Material AS Material,
  JournalEntryItem.Product AS Product,
  JournalEntryItem.Plant AS Plant,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem.ServicesRenderedDate AS ServicesRenderedDate,
  JournalEntryItem.ConditionContract AS ConditionContract,
  JournalEntryItem.ComponentBreakdown AS ComponentBreakdown,
  JournalEntryItem.CompBreakdownScaleNumerator AS CompBreakdownScaleNumerator,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem.SpecialGLCode AS SpecialGLCode,
  JournalEntryItem.TaxCode AS TaxCode,
  JournalEntryItem.TaxCountry AS TaxCountry,
  JournalEntryItem.HouseBank AS HouseBank,
  JournalEntryItem.HouseBankAccount AS HouseBankAccount,
  JournalEntryItem.ClearingDate AS ClearingDate,
  cast( JournalEntryItem.ClearingJournalEntryFiscalYear as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  JournalEntryItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  JournalEntryItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  JournalEntryItem.ClearingJournalEntry AS ClearingJournalEntry,
  JournalEntryItem.ValueDate AS ValueDate,
  JournalEntryItem.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  JournalEntryItem.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  JournalEntryItem.AssetDepreciationArea AS AssetDepreciationArea,
  JournalEntryItem.MasterFixedAsset AS MasterFixedAsset,
  JournalEntryItem.FixedAsset AS FixedAsset,
  JournalEntryItem.AssetValueDate AS AssetValueDate,
  JournalEntryItem.AssetTransactionType AS AssetTransactionType,
  JournalEntryItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  JournalEntryItem.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  JournalEntryItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  JournalEntryItem.GroupFixedAsset AS GroupFixedAsset,
  JournalEntryItem.AssetClass AS AssetClass,
  JournalEntryItem.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  JournalEntryItem.PartnerFixedAsset AS PartnerFixedAsset,
  JournalEntryItem.CostEstimate AS CostEstimate,
  cast( JournalEntryItem.InventorySpecialStockValnType as fis_invtryspclstockvalntype_d preserving type ) AS InventorySpecialStockValnType,
  JournalEntryItem.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
  JournalEntryItem.IsSupplierStockValuation AS IsSupplierStockValuation,
  JournalEntryItem.InventorySpecialStockType AS InventorySpecialStockType,
  JournalEntryItem.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  JournalEntryItem.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  cast( JournalEntryItem.InvtrySpclStockWBSElmntIntID as fis_invspstock_wbsint_no_conv preserving type ) AS InvtrySpclStockWBSElmntIntID,
  cast( JournalEntryItem.InventorySpclStockWBSElement as fis_invspstock_wbs preserving type ) AS InventorySpclStockWBSElement,
  JournalEntryItem.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  JournalEntryItem.InventoryValuationType AS InventoryValuationType,
  JournalEntryItem.ValuationArea AS ValuationArea,
  JournalEntryItem.MaterialLedgerProcessType AS MaterialLedgerProcessType,
  JournalEntryItem.MaterialLedgerCategory AS MaterialLedgerCategory,
  JournalEntryItem.SlsPriceAmountInCoCodeCrcy AS SlsPriceAmountInCoCodeCrcy,
  JournalEntryItem.ProductPriceControl AS ProductPriceControl,
  JournalEntryItem.SenderCompanyCode AS SenderCompanyCode,
  JournalEntryItem.SenderGLAccount AS SenderGLAccount,
  JournalEntryItem.SenderAccountAssignment AS SenderAccountAssignment,
  JournalEntryItem.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  JournalEntryItem.ControllingObject AS ControllingObject,
  JournalEntryItem.CostOriginGroup AS CostOriginGroup,
  JournalEntryItem.OriginSenderObject AS OriginSenderObject,
  JournalEntryItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  JournalEntryItem.ControllingObjectDebitType AS ControllingObjectDebitType,
  JournalEntryItem.OffsettingAccount AS OffsettingAccount,
  JournalEntryItem.OffsettingAccountType AS OffsettingAccountType,
  JournalEntryItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  JournalEntryItem.LineItemIsCompleted AS LineItemIsCompleted,
  JournalEntryItem.PersonnelNumber AS PersonnelNumber,
  JournalEntryItem.ControllingObjectClass AS ControllingObjectClass,
  JournalEntryItem.PartnerCompanyCode AS PartnerCompanyCode,
  JournalEntryItem.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  JournalEntryItem.OriginCostCenter AS OriginCostCenter,
  JournalEntryItem.OriginProfitCenter AS OriginProfitCenter,
  JournalEntryItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  JournalEntryItem.OriginProduct AS OriginProduct,
  JournalEntryItem.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  JournalEntryItem.AccountAssignment AS AccountAssignment,
  JournalEntryItem.AccountAssignmentType AS AccountAssignmentType,
  JournalEntryItem.CostCtrActivityType AS CostCtrActivityType,
  JournalEntryItem.OrderID AS OrderID,
  JournalEntryItem.OrderCategory AS OrderCategory,
  JournalEntryItem.WBSElementInternalID AS WBSElementInternalID,
  JournalEntryItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  cast( JournalEntryItem.WBSElement as fis_wbs preserving type ) AS WBSElement,
  JournalEntryItem.ProjectInternalID AS ProjectInternalID,
  JournalEntryItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  JournalEntryItem.WorkPackage AS WorkPackage,
  JournalEntryItem.Project AS Project,
  JournalEntryItem.OperatingConcern AS OperatingConcern,
  JournalEntryItem.ProjectNetwork AS ProjectNetwork,
  JournalEntryItem.RelatedNetworkActivity AS RelatedNetworkActivity,
  JournalEntryItem.BusinessProcess AS BusinessProcess,
  JournalEntryItem.CostObject AS CostObject,
  JournalEntryItem.BillableControl AS BillableControl,
  JournalEntryItem.CostAnalysisResource AS CostAnalysisResource,
  JournalEntryItem.CustomerServiceNotification AS CustomerServiceNotification,
  JournalEntryItem.ServiceDocumentType AS ServiceDocumentType,
  JournalEntryItem.ServiceDocument AS ServiceDocument,
  JournalEntryItem.ServiceDocumentItem AS ServiceDocumentItem,
  JournalEntryItem.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  JournalEntryItem.PartnerServiceDocument AS PartnerServiceDocument,
  JournalEntryItem.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  JournalEntryItem.ServiceContractType AS ServiceContractType,
  JournalEntryItem.ServiceContract AS ServiceContract,
  JournalEntryItem.ServiceContractItem AS ServiceContractItem,
  JournalEntryItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  JournalEntryItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  JournalEntryItem.ProviderContract AS ProviderContract,
  JournalEntryItem.ProviderContractItem AS ProviderContractItem,
  JournalEntryItem.RevenueAccountingContract AS RevenueAccountingContract,
  JournalEntryItem.PerformanceObligation AS PerformanceObligation,
  JournalEntryItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  JournalEntryItem.PartnerAccountAssignment AS PartnerAccountAssignment,
  JournalEntryItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  JournalEntryItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  cast(JournalEntryItem.PartnerOrder as fis_par_aufnr_depre preserving type ) AS PartnerOrder,
  JournalEntryItem.PartnerOrder_2 AS PartnerOrder_2,
  JournalEntryItem.PartnerOrderCategory AS PartnerOrderCategory,
  cast( JournalEntryItem.PartnerWBSElement as fis_partner_wbs preserving type ) AS PartnerWBSElement,
  cast( JournalEntryItem.PartnerProject as fis_part_project preserving type ) AS PartnerProject,
  JournalEntryItem.PartnerSalesDocument AS PartnerSalesDocument,
  JournalEntryItem.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  JournalEntryItem.PartnerProjectNetwork AS PartnerProjectNetwork,
  JournalEntryItem.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  JournalEntryItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  JournalEntryItem.PartnerCostObject AS PartnerCostObject,
  JournalEntryItem.WorkItem AS WorkItem,
  JournalEntryItem.BillingDocumentType AS BillingDocumentType,
  JournalEntryItem.SalesOrganization AS SalesOrganization,
  JournalEntryItem.DistributionChannel AS DistributionChannel,
  JournalEntryItem.OrganizationDivision AS OrganizationDivision,
  JournalEntryItem.SoldMaterial AS SoldMaterial,
  JournalEntryItem.SoldProduct AS SoldProduct,
  JournalEntryItem.MaterialGroup AS MaterialGroup,
  JournalEntryItem.SoldProductGroup AS SoldProductGroup,
  JournalEntryItem.CustomerGroup AS CustomerGroup,
  JournalEntryItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  JournalEntryItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  JournalEntryItem.SalesDistrict AS SalesDistrict,
  JournalEntryItem.BillToParty AS BillToParty,
  JournalEntryItem.ShipToParty AS ShipToParty,
  JournalEntryItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  JournalEntryItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  JournalEntryItem.CashLedgerAccount AS CashLedgerAccount,
  JournalEntryItem.FinancialManagementArea AS FinancialManagementArea,
  JournalEntryItem.CommitmentItem AS CommitmentItem,
  JournalEntryItem.FundsCenter AS FundsCenter,
  JournalEntryItem.FundedProgram AS FundedProgram,
  JournalEntryItem.Fund AS Fund,
  JournalEntryItem.GrantID AS GrantID,
  JournalEntryItem.BudgetPeriod AS BudgetPeriod,
  JournalEntryItem.PartnerFund AS PartnerFund,
  JournalEntryItem.PartnerGrant AS PartnerGrant,
  JournalEntryItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  JournalEntryItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  JournalEntryItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  JournalEntryItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  JournalEntryItem.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  JournalEntryItem.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  JournalEntryItem.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  JournalEntryItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  JournalEntryItem.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  JournalEntryItem.SponsoredProgram AS SponsoredProgram,
  JournalEntryItem.SponsoredClass AS SponsoredClass,
  JournalEntryItem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  JournalEntryItem.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  JournalEntryItem.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  JournalEntryItem.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  JournalEntryItem.FinancialServicesBranch AS FinancialServicesBranch,
  JournalEntryItem.FinancialDataSource AS FinancialDataSource,
  JournalEntryItem.JointVenture AS JointVenture,
  JournalEntryItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  JournalEntryItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  JournalEntryItem.JointVenturePartner AS JointVenturePartner,
  JournalEntryItem.JointVentureBillingType AS JointVentureBillingType,
  JournalEntryItem.JointVentureEquityType AS JointVentureEquityType,
  JournalEntryItem.JointVentureProductionDate AS JointVentureProductionDate,
  JournalEntryItem.JointVentureBillingDate AS JointVentureBillingDate,
  JournalEntryItem.JointVentureOperationalDate AS JointVentureOperationalDate,
  JournalEntryItem.CutbackRun AS CutbackRun,
  JournalEntryItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  JournalEntryItem.PartnerVenture AS PartnerVenture,
  JournalEntryItem.PartnerEquityGroup AS PartnerEquityGroup,
  JournalEntryItem.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  JournalEntryItem.CutbackAccount AS CutbackAccount,
  JournalEntryItem.CutbackCostObject AS CutbackCostObject,
  JournalEntryItem.REBusinessEntity AS REBusinessEntity,
  JournalEntryItem.RealEstateBuilding AS RealEstateBuilding,
  JournalEntryItem.RealEstateProperty AS RealEstateProperty,
  JournalEntryItem.RERentalObject AS RERentalObject,
  JournalEntryItem.RealEstateContract AS RealEstateContract,
  JournalEntryItem.SettlementReferenceDate AS SettlementReferenceDate,
  JournalEntryItem.REPartnerBusinessEntity AS REPartnerBusinessEntity,
  JournalEntryItem.RealEstatePartnerBuilding AS RealEstatePartnerBuilding,
  JournalEntryItem.RealEstatePartnerProperty AS RealEstatePartnerProperty,
  JournalEntryItem.REPartnerRentalObject AS REPartnerRentalObject,
  JournalEntryItem.RealEstatePartnerContract AS RealEstatePartnerContract,
  JournalEntryItem.REPartnerServiceChargeKey AS REPartnerServiceChargeKey,
  JournalEntryItem.REPartnerSettlementUnitID AS REPartnerSettlementUnitID,
  JournalEntryItem.PartnerSettlementReferenceDate AS PartnerSettlementReferenceDate,
  JournalEntryItem.AccrualObjectType AS AccrualObjectType,
  JournalEntryItem.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  JournalEntryItem.AccrualObject AS AccrualObject,
  JournalEntryItem.AccrualSubobject AS AccrualSubobject,
  JournalEntryItem.AccrualItemType AS AccrualItemType,
  JournalEntryItem.AccrualReferenceObject AS AccrualReferenceObject,
  JournalEntryItem.AccrualValueDate AS AccrualValueDate,
  JournalEntryItem.FinancialValuationObjectType AS FinancialValuationObjectType,
  JournalEntryItem.FinancialValuationObject AS FinancialValuationObject,
  JournalEntryItem.FinancialValuationSubobject AS FinancialValuationSubobject,
  JournalEntryItem.NetDueDate AS NetDueDate,
  JournalEntryItem.CreditRiskClass AS CreditRiskClass,
  JournalEntryItem.WorkCenterInternalID AS WorkCenterInternalID,
  JournalEntryItem.OrderOperation AS OrderOperation,
  JournalEntryItem.OrderItem AS OrderItem,
  JournalEntryItem.PartnerOrderItem AS PartnerOrderItem,
  JournalEntryItem.OrderSuboperation AS OrderSuboperation,
  JournalEntryItem.Equipment AS Equipment,
  JournalEntryItem.Assembly AS Assembly,
  JournalEntryItem.MaintenanceActivityType AS MaintenanceActivityType,
  JournalEntryItem.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  JournalEntryItem.MaintPriorityType AS MaintPriorityType,
  JournalEntryItem.MaintPriority AS MaintPriority,
  JournalEntryItem.SuperiorOrder AS SuperiorOrder,
  JournalEntryItem.ProductGroup AS ProductGroup,
  JournalEntryItem.MaintenanceOrderIsPlanned AS MaintenanceOrderIsPlanned,
  JournalEntryItem.JrnlEntryItemMigrationSource AS JrnlEntryItemMigrationSource,
  cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) AS NumberOfItems,
  JournalEntryItem._FunctionalCurrency AS _FunctionalCurrency,
  JournalEntryItem._ReferenceQuantityUnit AS _ReferenceQuantityUnit,
  JournalEntryItem._AccountAssignmentType AS _AccountAssignmentType,
  JournalEntryItem._CustomerCompany AS _CustomerCompany,
  JournalEntryItem._SupplierCompany AS _SupplierCompany,
  JournalEntryItem._BusinessTransactionCategory AS _BusinessTransactionCategory,
  JournalEntryItem._TaxCountry AS _TaxCountry,
  JournalEntryItem._PartnerMasterFixedAsset AS _PartnerMasterFixedAsset,
  JournalEntryItem._PartnerFixedAsset AS _PartnerFixedAsset,
  JournalEntryItem._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  JournalEntryItem._CashLedgerAccount AS _CashLedgerAccount,
  JournalEntryItem._FundedProgram AS _FundedProgram,
  JournalEntryItem._Grant AS _Grant,
  JournalEntryItem._PartnerGrant AS _PartnerGrant,
  JournalEntryItem._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  JournalEntryItem._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  JournalEntryItem._PubSecBudgetAccount AS _PubSecBudgetAccount,
  JournalEntryItem._PubSecBudgetCnsmpnDate AS _PubSecBudgetCnsmpnDate,
  JournalEntryItem._PubSecBudgetCnsmpnFsclPeriod AS _PubSecBudgetCnsmpnFsclPeriod,
  JournalEntryItem._PubSecBudgetCnsmpnFsclYear AS _PubSecBudgetCnsmpnFsclYear,
  JournalEntryItem._PubSecBudgetCnsmpnType AS _PubSecBudgetCnsmpnType,
  JournalEntryItem._PubSecBudgetCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType,
  JournalEntryItem._ConsolidationUnit AS _ConsolidationUnit,
  JournalEntryItem._PartnerConsolidationUnit AS _PartnerConsolidationUnit,
  JournalEntryItem._Company AS _Company,
  JournalEntryItem._ConsolidationChartOfAccounts AS _ConsolidationChartOfAccounts,
  JournalEntryItem._CnsldtnFinancialStatementItem AS _CnsldtnFinancialStatementItem,
  JournalEntryItem._CnsldtnSubitemCategory AS _CnsldtnSubitemCategory,
  JournalEntryItem._CnsldtnSubitem AS _CnsldtnSubitem,
  JournalEntryItem._ProviderContract AS _ProviderContract,
  JournalEntryItem._ProviderContractItem AS _ProviderContractItem,
  cast( '' as fis_brgru_glaccount) AS GLAccountAuthorizationGroup,
  cast( '' as fis_brgru_supplier) AS SupplierBasicAuthorizationGrp,
  cast( '' as fis_brgru_customer) AS CustomerBasicAuthorizationGrp,
  cast( '' as fis_brgru_acctgdoctype) AS AcctgDocTypeAuthorizationGroup,
  cast( '' as aufart) AS OrderType,
  cast( '' as auart) AS SalesOrderType
FROM I_JournalEntryItem AS JournalEntryItem
;