P_ManageJournalEntryLedgerView

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Journal Entry Ledger View'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #MIXED
}

@VDM: {
  viewType: #COMPOSITE,
  private: true
}
define view entity P_ManageJournalEntryLedgerView

as select from I_GLAccountLineItemRawData as _Item 
  
  inner join   I_CoCodeLedgerSourceLedger as _LedgerSourceLedger  on  _Item .SourceLedger = _LedgerSourceLedger.SourceLedger
                                                                  and _Item .CompanyCode  = _LedgerSourceLedger.CompanyCode
{

  key cast( '' as fins_technical_ledger ) as TechnicalLedger,
  key _LedgerSourceLedger.Ledger as SourceLedger,
  key _Item.CompanyCode,
  key _Item.FiscalYear,
  key _Item.AccountingDocument,
  key _Item.LedgerGLLineItem,
      
      _Item.SourceLedger as Ledger,
      _Item.LedgerFiscalYear,
      _Item.GLRecordType,
      _Item.JrnlEntrAltvFYConsecutiveID,
      _Item.ControllingArea,
      _Item.BusinessTransactionCategory,
      _Item.BusinessTransactionType,
      _Item.ReferenceDocumentType,
      _Item.ReferenceDocumentContext,
      _Item.ReferenceDocument,
      _Item.ReferenceDocumentItem,
      _Item.ReferenceDocumentItemGroup,
      _Item.FinancialTransactionType,
      _Item.IsReversal,
      _Item.IsReversed,
      _Item.ReversalReferenceDocumentCntxt,
      _Item.ReversalReferenceDocument,
      _Item.IsSettlement,
      _Item.IsSettled,
      _Item.PredecessorReferenceDocCntxt,
      _Item.PredecessorReferenceDocItem,
      _Item.PredecessorReferenceDocType,
      _Item.PredecessorReferenceDocument,
      _Item.SourceReferenceDocument,
      _Item.SourceReferenceDocumentType,
      _Item.SourceReferenceDocumentItem,
      _Item.SourceReferenceDocumentCntxt,
      _Item.SourceLogicalSystem,
      _Item.SourceReferenceDocSubitem,
      _Item.IsCommitment,
      _Item.JrnlEntryItemObsoleteReason,
      _Item.GLBusinessTransactionType,
      _Item.LogicalSystem,
      _Item.GLAccount,
      _Item.ChartOfAccounts,
      _Item.CostCenter,
      _Item.ProfitCenter,
      _Item.FunctionalArea,
      _Item.BusinessArea,
      _Item.Segment,
      _Item.PartnerCostCenter,
      _Item.PartnerProfitCenter,
      _Item.PartnerFunctionalArea,
      _Item.PartnerBusinessArea,
      _Item.PartnerCompany,
      _Item.PartnerSegment,
      
      _Item.PrdcssrJournalEntryCompanyCode,
      _Item.PrdcssrJournalEntryFiscalYear,
      _Item.PredecessorJournalEntry,
      _Item.PredecessorJournalEntryItem,
      
      /// 

      // Amounts

      ///

      _Item.BalanceTransactionCurrency,
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }      
      _Item.AmountInBalanceTransacCrcy,
      
      _Item.TransactionCurrency,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      _Item.AmountInTransactionCurrency,
      
      _Item.CompanyCodeCurrency,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      _Item.AmountInCompanyCodeCurrency,
      
      _Item.GlobalCurrency,
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      _Item.AmountInGlobalCurrency,      
      
      _Item.FunctionalCurrency,
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      _Item.AmountInFunctionalCurrency,   
      
      _Item.FreeDefinedCurrency1,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      _Item.AmountInFreeDefinedCurrency1,
      
      _Item.FreeDefinedCurrency2,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      _Item.AmountInFreeDefinedCurrency2,
      
      _Item.FreeDefinedCurrency3,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      _Item.AmountInFreeDefinedCurrency3,
      
      _Item.FreeDefinedCurrency4,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      _Item.AmountInFreeDefinedCurrency4,
      
      _Item.FreeDefinedCurrency5,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      _Item.AmountInFreeDefinedCurrency5,
      
      _Item.FreeDefinedCurrency6,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      _Item.AmountInFreeDefinedCurrency6,
      
      _Item.FreeDefinedCurrency7,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      _Item.AmountInFreeDefinedCurrency7,
      
      _Item.FreeDefinedCurrency8,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      _Item.AmountInFreeDefinedCurrency8,    
      
      _Item.ControllingObjectCurrency,
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
      _Item.AmountInObjectCurrency,
      
      _Item.GrantCurrency,
      @Semantics: { amount : {currencyCode: 'GrantCurrency'} }
      _Item.AmountInGrantCurrency,
      
      /// 

      // Credit Amounts

      ///

      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInBalanceTransacCrcy
         else abap.curr'0.00'
      end as fis_cr_tsl) as CreditAmountInBalanceTransCrcy,      
      
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInTransactionCurrency
         else abap.curr'0.00'
      end as fis_cr_wsl) as CreditAmountInTransCrcy,
      
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInCompanyCodeCurrency
         else abap.curr'0.00'
      end as fis_cr_hsl) as CreditAmountInCoCodeCrcy,
      
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInGlobalCurrency
         else abap.curr'0.00'
      end as fis_cr_ksl) as CreditAmountInGlobalCrcy,
      
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFunctionalCurrency
         else abap.curr'0.00'
      end as fis_cr_amt_funccrcy) as CreditAmountInFunctionalCrcy,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency1
         else abap.curr'0.00'
      end as fis_cr_osl) as CreditAmountInFreeDfndCrcy1,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency2
         else abap.curr'0.00'
      end as fis_cr_vsl) as CreditAmountInFreeDfndCrcy2,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency3
         else abap.curr'0.00'
      end as fis_cr_bsl) as CreditAmountInFreeDfndCrcy3,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency4
         else abap.curr'0.00'
      end as fis_cr_csl) as CreditAmountInFreeDfndCrcy4,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency5
         else abap.curr'0.00'
      end as fis_cr_dsl) as CreditAmountInFreeDfndCrcy5,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency6
         else abap.curr'0.00'
      end as fis_cr_esl) as CreditAmountInFreeDfndCrcy6,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency7
         else abap.curr'0.00'
      end as fis_cr_fsl) as CreditAmountInFreeDfndCrcy7,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency8
         else abap.curr'0.00'
      end as fis_cr_gsl) as CreditAmountInFreeDfndCrcy8,         
      
      /// 

      // Debit Amounts

      ///

      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInBalanceTransacCrcy
         else abap.curr'0.00'
      end as fis_dr_tsl) as DebitAmountInBalanceTransCrcy,
      
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInTransactionCurrency
         else abap.curr'0.00'
      end as fis_dr_wsl) as DebitAmountInTransCrcy,
      
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInCompanyCodeCurrency
         else abap.curr'0.00'
      end as fis_dr_hsl) as DebitAmountInCoCodeCrcy,
      
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInGlobalCurrency
         else abap.curr'0.00'
      end as fis_dr_ksl) as DebitAmountInGlobalCrcy,
      
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFunctionalCurrency
         else abap.curr'0.00'
      end as fis_dr_amt_funccrcy) as DebitAmountInFunctionalCrcy,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency1
         else abap.curr'0.00'
      end as fis_dr_osl) as DebitAmountInFreeDfndCrcy1,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency2
         else abap.curr'0.00'
      end as fis_dr_vsl) as DebitAmountInFreeDfndCrcy2,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency3
         else abap.curr'0.00'
      end as fis_dr_bsl) as DebitAmountInFreeDfndCrcy3,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency4
         else abap.curr'0.00'
      end as fis_dr_csl) as DebitAmountInFreeDfndCrcy4,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency5 
         else abap.curr'0.00'
      end as fis_dr_dsl) as DebitAmountInFreeDfndCrcy5,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency6
         else abap.curr'0.00'
      end as fis_dr_esl) as DebitAmountInFreeDfndCrcy6,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency7
         else abap.curr'0.00'
      end as fis_dr_fsl) as DebitAmountInFreeDfndCrcy7,
      
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency8
         else abap.curr'0.00'
      end as fis_dr_gsl) as DebitAmountInFreeDfndCrcy8,    
      
      _Item.BaseUnit,
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      _Item.Quantity,   
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} } 
      _Item.FixedQuantity, 
      _Item.CostSourceUnit,
      @Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }  
      _Item.ValuationQuantity,
      
      @Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }  
      _Item.ValuationFixedQuantity,
      _Item.AdditionalQuantity1Unit,
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity1Unit'} }  
      _Item.AdditionalQuantity1,
      _Item.AdditionalQuantity2Unit,
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity2Unit'} } 
      _Item.AdditionalQuantity2,
      _Item.AdditionalQuantity3Unit,
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity3Unit'} }  
      _Item.AdditionalQuantity3,
      
      _Item.IncmpltSummableValnQtyUnt,
      @Semantics: { quantity : {unitOfMeasure: 'IncmpltSummableValnQtyUnt'} }  
      _Item.IncmpltSummableValnQty,
      @Semantics: { quantity : {unitOfMeasure: 'IncmpltSummableValnQtyUnt'} }  
      _Item.IncmpltSummableValnFxdQty,
      
      _Item.DebitCreditCode,
      
      _Item.ExchangeRateDate,
      _Item.FiscalPeriod,
      _Item.FiscalYearVariant,
      _Item.FiscalYearPeriod,
      _Item.PostingDate,
      _Item.DocumentDate,
      _Item.AccountingDocumentType,
      _Item.AccountingDocumentItem,
      _Item.AssignmentReference,
      _Item.AccountingDocumentCategory,
      _Item.PostingKey,
      _Item.TransactionTypeDetermination,
      _Item.SubLedgerAcctLineItemType,
      _Item.AccountingDocCreatedByUser,
      _Item.CreationDate,
      _Item.CreationDateTime,
      _Item.EliminationProfitCenter,
      _Item.OriginObjectType,
      _Item.GLAccountType,
      _Item.AlternativeGLAccount, 
      _Item.CountryChartOfAccounts,
      _Item.ConsolidationUnit,
      _Item.InvoiceReference,
      _Item.InvoiceReferenceFiscalYear,
      _Item.FollowOnDocumentType,
      _Item.InvoiceItemReference,
      _Item.PartnerConsolidationUnit,
      _Item.Company, 
      _Item.ConsolidationChartOfAccounts,
      _Item.CnsldtnFinancialStatementItem,
      _Item.CnsldtnSubitemCategory,
      _Item.CnsldtnSubitem,      
      _Item.ReferencePurchaseOrderCategory,
      _Item.PurchasingDocument,
      _Item.PurchasingDocumentItem,
      _Item.AccountAssignmentNumber,
      _Item.DocumentItemText,
      _Item.SalesDocument,
      _Item.SalesDocumentItem,
      _Item.Product,
      _Item.ProductGroup,
      _Item.Plant,
      _Item.Supplier,
      _Item.Customer,
      _Item.ServicesRenderedDate,
      _Item.PerformancePeriodStartDate,
      _Item.PerformancePeriodEndDate,
      _Item.FinancialAccountType,
      _Item.SpecialGLCode,
      _Item.TaxCode,
      _Item.TaxCountry,
      _Item.HouseBank,
      _Item.HouseBankAccount,
      @Semantics.booleanIndicator: true
      _Item.IsOpenItemManaged,
      _Item.ClearingDate,      
      _Item.ClearingJournalEntryFiscalYear,
      _Item.ClearingJournalEntry, 
      cast( ( case _Item.ClearingDate when '00000000' then ' '               
                                else 'X' 
            end ) as farp_xaugp preserving type ) as IsCleared,           
      _Item.ValueDate,     
      _Item.AssetDepreciationArea,
      _Item.MasterFixedAsset,
      _Item.FixedAsset,
      _Item.AssetValueDate,
      _Item.AssetTransactionType,
      _Item.AssetAcctTransClassfctn,
      _Item.DepreciationFiscalPeriod,
      _Item.GroupMasterFixedAsset,
      _Item.GroupFixedAsset,
      _Item.PartnerMasterFixedAsset,
      _Item.PartnerFixedAsset,
      _Item.AssetClass,
      _Item.CostEstimate,
      _Item.InventorySpecialStockValnType,
      _Item.InventorySpecialStockType,
      _Item.InventorySpclStkSalesDocument,
      _Item.InventorySpclStkSalesDocItm, 
      _Item.InvtrySpclStockWBSElmntIntID,
      _Item.InventorySpecialStockSupplier,
      _Item.InventoryValuationType,
      _Item.ValuationArea,  
      //cast( _Item._InvtrySpclStkWBSElmntBscData.WBSElementExternalID  as fis_invspstock_wbsext_no_conv ) as InvtrySpclStockWBSElmntExtID,    

      _Item.ProductPriceControl, 
      _Item.SenderGLAccount,    
      _Item.SenderAccountAssignment,
      _Item.SenderAccountAssignmentType,
      _Item.ControllingObject,
      _Item.CostOriginGroup,
      _Item.OriginSenderObject,
      cast(_Item.ControllingDebitCreditCode as fis_co_belkz_conv) as ControllingDebitCreditCode,
      _Item.ControllingObjectDebitType,
      _Item.QuantityIsIncomplete,
      _Item.OffsettingAccount,
      _Item.OffsettingAccountType,
      _Item.OffsettingChartOfAccounts,
      _Item.LineItemIsCompleted,
      _Item.PersonnelNumber,  
      _Item.BillableControl,
      _Item.ControllingObjectClass,
      _Item.PartnerCompanyCode,  
      _Item.PartnerControllingObjectClass,
      _Item.OriginCostCtrActivityType,
      _Item.OriginCostCenter,
      _Item.OriginProfitCenter,
      _Item.OriginProduct,
      _Item.VarianceOriginGLAccount,
      _Item.AccountAssignment,
      _Item.AccountAssignmentType,
      _Item.CostCtrActivityType,
      _Item.OrderID,
      _Item.OrderCategory,
      _Item.WBSElementInternalID,
      //cast( _Item._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) as WBSElementExternalID,

      _Item.PartnerWBSElementInternalID,
      //cast( _Item._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) as PartnerWBSElementExternalID,

      _Item.WorkPackage,
      _Item.ProjectInternalID,
      _Item.PartnerProjectInternalID,
      //cast( _Item._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) as PartnerProjectExternalID,

      //cast( _Item._ProjectBasicData.ProjectExternalID  as fis_projectext_no_conv ) as ProjectExternalID,

      _Item.OperatingConcern,
      _Item.ProjectNetwork,
      cast(_Item.RelatedNetworkActivity as fis_npvrg_conv) as RelatedNetworkActivity,
      _Item.BusinessProcess,
      _Item.CostObject,     
      _Item.CostAnalysisResource,
      _Item.CustomerServiceNotification,
      _Item.ServiceDocumentType,
      _Item.ServiceDocument,
      _Item.ServiceDocumentItem,
      _Item.PartnerServiceDocumentType,
      _Item.PartnerServiceDocument,
      _Item.PartnerServiceDocumentItem,
      _Item.ServiceContractType,
      _Item.ServiceContract,
      _Item.ServiceContractItem,  
      _Item.BusinessSolutionOrder,
      _Item.BusinessSolutionOrderItem,
      _Item.ProviderContract,
      _Item.ProviderContractItem,
      _Item.TimeSheetOvertimeCategory, 
      _Item.PartnerAccountAssignment,
      _Item.PartnerAccountAssignmentType,
      _Item.PartnerCostCtrActivityType,
      cast(_Item.PartnerOrder as fis_par_aufnr preserving type ) as PartnerOrder,
      _Item.PartnerOrderCategory,
      _Item.PartnerSalesDocument,
      _Item.PartnerSalesDocumentItem,
      _Item.PartnerProjectNetwork,
      cast(_Item.PartnerProjectNetworkActivity as fis_par_vornr_auf_conv) as PartnerProjectNetworkActivity,
      _Item.PartnerBusinessProcess,
      _Item.PartnerCostObject,
      _Item.WorkItem,   
      _Item.BillingDocumentType,
      _Item.SalesOrganization,
      _Item.DistributionChannel,
      _Item.OrganizationDivision,
      _Item.SoldProduct,
      _Item.SoldProductGroup,
      _Item.CustomerGroup,
      _Item.CustomerSupplierCountry,
      _Item.CustomerSupplierIndustry,
      _Item.SalesDistrict,
      _Item.BillToParty,  
      _Item.ShipToParty,
      _Item.CustomerSupplierCorporateGroup, 
      _Item.CashLedgerCompanyCode,
      _Item.CashLedgerAccount,
      _Item.FinancialManagementArea,
      _Item.FundsCenter,
      _Item.FundedProgram,
      _Item.Fund,
      _Item.GrantID,
      _Item.BudgetPeriod,
      _Item.PartnerFund,
      _Item.PartnerGrant,
      _Item.PartnerBudgetPeriod,
      _Item.PubSecBudgetAccount,
      _Item.PubSecBudgetAccountCoCode,  
      _Item.PubSecBudgetCnsmpnDate, 
      _Item.PubSecBudgetCnsmpnFsclYear,
      _Item.PubSecBudgetCnsmpnFsclPeriod,
      _Item.PubSecBudgetIsRelevant,
      _Item.PubSecBudgetCnsmpnType,
      _Item.PubSecBudgetCnsmpnAmtType,
      _Item.SponsoredProgram,
      _Item.SponsoredClass,      
      _Item.GteeMBudgetValidityNumber, 
      _Item.CommitmentItem,    
      _Item.JointVenture,
      _Item.JointVentureEquityGroup,
      _Item.JointVentureCostRecoveryCode,
      _Item.JointVenturePartner,
      _Item.JointVentureBillingType,
      _Item.JointVentureEquityType,
      _Item.JointVentureProductionDate,
      _Item.JointVentureBillingDate,
      _Item.JointVentureOperationalDate,
      _Item.CutbackRun,
      _Item.JointVentureAccountingActivity,
      _Item.SettlementReferenceDate,
      _Item.PartnerVenture,
      _Item.PartnerEquityGroup,
      _Item.SenderCostRecoveryCode,
      _Item.CutbackAccount,
      _Item.CutbackCostObject,
      _Item.REBusinessEntity,
      _Item.RealEstateBuilding,
      _Item.RealEstateProperty,
      _Item.RERentalObject,
      _Item.RealEstateContract,
      _Item.REServiceChargeKey,
      _Item.RESettlementUnitID,      
      _Item.AccrualObjectType,
      _Item.AccrualObjectLogicalSystem,
      _Item.AccrualObject,
      _Item.AccrualSubobject,
      _Item.AccrualItemType,
      _Item.AccrualReferenceObject,
      _Item.AccrualValueDate,
      _Item.FinancialValuationObjectType,    
      _Item.FinancialValuationObject,
      _Item.FinancialValuationSubobject,
      _Item.NetDueDate,
      _Item.CreditRiskClass,
      
      case  when ( _Item.AmountInTransactionCurrency  > 0 ) 
              and _Item.DebitCreditCode = 'H' then cast( 'X' as fis_xnegp preserving type )
            when ( _Item.AmountInTransactionCurrency  < 0 ) 
              and _Item.DebitCreditCode = 'S' then cast( 'X' as fis_xnegp preserving type )            
            else cast( ' ' as fis_xnegp preserving type ) end as IsNegativePosting,
      
      cast( ( case when ( _Item.AccountAssignmentType != 'OR' and _Item.AccountAssignmentType != 'OP' and _Item.AccountAssignmentType != 'OV' ) and _Item.OrderID != ''
             then 'X'
             else ' '
        end ) as fins_xaufnr_stat preserving type ) as IsStatisticalOrder,

      cast( ( case when ( _Item.AccountAssignmentType != 'KL' and _Item.AccountAssignmentType != 'KS' ) and _Item.CostCenter != ''
             then 'X'
             else ' '
        end ) as fins_xkostl_stat preserving type ) as IsStatisticalCostCenter,

      cast( ( case when _Item.AccountAssignmentType != 'VB' and _Item.SalesDocument != ''
             then 'X'
             else ' '
        end ) as fis_xkdpos_stat preserving type ) as IsStatisticalSalesDocument,

      cast( ( case when ( _Item.AccountAssignmentType != 'PR' ) and ( _Item.WBSElementInternalID != '00000000' )
             then 'X'
             else ' '
        end ) as fins_xps_posid_stat preserving type ) as WBSIsStatisticalWBSElement,
        
      cast(_Item.OrderOperation as vdm_vornr) as OrderOperation,    
      _Item.JrnlEntryItemMigrationSource,
      
      cast(_Item.FinancialServicesProductGroup as ffs_product_group preserving type) as FinancialServicesProductGroup,
      cast(_Item.FinancialServicesBranch as ffs_branch_id preserving type) as FinancialServicesBranch,
      cast(_Item.FinancialDataSource as ffs_datasource_id preserving type) as FinancialDataSource,
      
      cast(
        case _Item.AccountAssignmentType
          when 'EO' then _Item.AccountAssignment
          else ''
      end as rkeobjnr_char) as ProfitabilitySegment,
      
      _Item.RevenueAccountingContract,
      _Item.PerformanceObligation,      
      _Item.ComponentBreakdown,
      _Item.CompBreakdownScaleNumerator,
      
      cast('STANDARD' as abap.char( 10 )) as Source,
      '' as IsStatisticalDocument,
      //FOR DCL

      _Item._GLAccountInCompanyCode,
      _Item._Supplier,
      _Item._Order,
      _Item._Customer,
      _Item._AccountingDocumentType,
      _Item._ServiceDocument,
      _Item._SalesDocument
}

union all select from I_GLAccountLineItemRawData as _Item 
  
  inner join I_TechnicalLedger as _TechnicalLedger on _Item.SourceLedger = _TechnicalLedger.TechnicalLedger
{

  key _Item.SourceLedger as TechnicalLedger,
  key _TechnicalLedger.Ledger as SourceLedger,
  key _Item.CompanyCode,
  key _Item.FiscalYear,
  key _Item.AccountingDocument,
  key _Item.LedgerGLLineItem,
      
      _Item.SourceLedger as Ledger,
      _Item.LedgerFiscalYear,
      _Item.GLRecordType,
      _Item.JrnlEntrAltvFYConsecutiveID,
      _Item.ControllingArea,
      _Item.BusinessTransactionCategory,
      _Item.BusinessTransactionType,
      _Item.ReferenceDocumentType,
      _Item.ReferenceDocumentContext,
      _Item.ReferenceDocument,
      _Item.ReferenceDocumentItem,
      _Item.ReferenceDocumentItemGroup,
      _Item.FinancialTransactionType,
      _Item.IsReversal,
      _Item.IsReversed,
      _Item.ReversalReferenceDocumentCntxt,
      _Item.ReversalReferenceDocument,
      _Item.IsSettlement,
      _Item.IsSettled,
      _Item.PredecessorReferenceDocCntxt,
      _Item.PredecessorReferenceDocItem,
      _Item.PredecessorReferenceDocType,
      _Item.PredecessorReferenceDocument,
      _Item.SourceReferenceDocument,
      _Item.SourceReferenceDocumentType,
      _Item.SourceReferenceDocumentItem,
      _Item.SourceReferenceDocumentCntxt,
      _Item.SourceLogicalSystem,
      _Item.SourceReferenceDocSubitem,
      _Item.IsCommitment,
      _Item.JrnlEntryItemObsoleteReason,
      _Item.GLBusinessTransactionType,
      _Item.LogicalSystem,
      _Item.GLAccount,
      _Item.ChartOfAccounts,
      _Item.CostCenter,
      _Item.ProfitCenter,
      _Item.FunctionalArea,
      _Item.BusinessArea,
      _Item.Segment,
      _Item.PartnerCostCenter,
      _Item.PartnerProfitCenter,
      _Item.PartnerFunctionalArea,
      _Item.PartnerBusinessArea,
      _Item.PartnerCompany,
      _Item.PartnerSegment,
      
      _Item.PrdcssrJournalEntryCompanyCode,
      _Item.PrdcssrJournalEntryFiscalYear,
      _Item.PredecessorJournalEntry,
      _Item.PredecessorJournalEntryItem,
      
      /// 

      // Amounts

      ///

      _Item.BalanceTransactionCurrency,
      _Item.AmountInBalanceTransacCrcy,
      
      _Item.TransactionCurrency,
      _Item.AmountInTransactionCurrency,
      
      _Item.CompanyCodeCurrency,
      _Item.AmountInCompanyCodeCurrency,
      
      _Item.GlobalCurrency,
      _Item.AmountInGlobalCurrency,      
      
      _Item.FunctionalCurrency,
      _Item.AmountInFunctionalCurrency,   
      
      _Item.FreeDefinedCurrency1,
      _Item.AmountInFreeDefinedCurrency1,
      
      _Item.FreeDefinedCurrency2,
      _Item.AmountInFreeDefinedCurrency2,
      
      _Item.FreeDefinedCurrency3,
      _Item.AmountInFreeDefinedCurrency3,
      
      _Item.FreeDefinedCurrency4,
      _Item.AmountInFreeDefinedCurrency4,
      
      _Item.FreeDefinedCurrency5,
      _Item.AmountInFreeDefinedCurrency5,
      
      _Item.FreeDefinedCurrency6,
      _Item.AmountInFreeDefinedCurrency6,
      
      _Item.FreeDefinedCurrency7,
      _Item.AmountInFreeDefinedCurrency7,
      
      _Item.FreeDefinedCurrency8,
      _Item.AmountInFreeDefinedCurrency8,    
      
      _Item.ControllingObjectCurrency,
      _Item.AmountInObjectCurrency,
      
      _Item.GrantCurrency,
      _Item.AmountInGrantCurrency,
      
      /// 

      // Credit Amounts

      ///

      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInBalanceTransacCrcy
         else abap.curr'0.00'
      end as fis_cr_tsl) as CreditAmountInBalanceTransCrcy,      
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInTransactionCurrency
         else abap.curr'0.00'
      end as fis_cr_wsl) as CreditAmountInTransCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInCompanyCodeCurrency
         else abap.curr'0.00'
      end as fis_cr_hsl) as CreditAmountInCoCodeCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInGlobalCurrency
         else abap.curr'0.00'
      end as fis_cr_ksl) as CreditAmountInGlobalCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFunctionalCurrency
         else abap.curr'0.00'
      end as fis_cr_amt_funccrcy) as CreditAmountInFunctionalCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency1
         else abap.curr'0.00'
      end as fis_cr_osl) as CreditAmountInFreeDfndCrcy1,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency2
         else abap.curr'0.00'
      end as fis_cr_vsl) as CreditAmountInFreeDfndCrcy2,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency3
         else abap.curr'0.00'
      end as fis_cr_bsl) as CreditAmountInFreeDfndCrcy3,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency4
         else abap.curr'0.00'
      end as fis_cr_csl) as CreditAmountInFreeDfndCrcy4,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency5
         else abap.curr'0.00'
      end as fis_cr_dsl) as CreditAmountInFreeDfndCrcy5,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency6
         else abap.curr'0.00'
      end as fis_cr_esl) as CreditAmountInFreeDfndCrcy6,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency7
         else abap.curr'0.00'
      end as fis_cr_fsl) as CreditAmountInFreeDfndCrcy7,
      
      cast(case
         when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency8
         else abap.curr'0.00'
      end as fis_cr_gsl) as CreditAmountInFreeDfndCrcy8,         
      
      /// 

      // Debit Amounts

      ///

      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInBalanceTransacCrcy
         else abap.curr'0.00'
      end as fis_dr_tsl) as DebitAmountInBalanceTransCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInTransactionCurrency
         else abap.curr'0.00'
      end as fis_dr_wsl) as DebitAmountInTransCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInCompanyCodeCurrency
         else abap.curr'0.00'
      end as fis_dr_hsl) as DebitAmountInCoCodeCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInGlobalCurrency
         else abap.curr'0.00'
      end as fis_dr_ksl) as DebitAmountInGlobalCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFunctionalCurrency
         else abap.curr'0.00'
      end as fis_dr_amt_funccrcy) as DebitAmountInFunctionalCrcy,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency1
         else abap.curr'0.00'
      end as fis_dr_osl) as DebitAmountInFreeDfndCrcy1,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency2
         else abap.curr'0.00'
      end as fis_dr_vsl) as DebitAmountInFreeDfndCrcy2,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency3
         else abap.curr'0.00'
      end as fis_dr_bsl) as DebitAmountInFreeDfndCrcy3,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency4
         else abap.curr'0.00'
      end as fis_dr_csl) as DebitAmountInFreeDfndCrcy4,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency5 
         else abap.curr'0.00'
      end as fis_dr_dsl) as DebitAmountInFreeDfndCrcy5,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency6
         else abap.curr'0.00'
      end as fis_dr_esl) as DebitAmountInFreeDfndCrcy6,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency7
         else abap.curr'0.00'
      end as fis_dr_fsl) as DebitAmountInFreeDfndCrcy7,
      
      cast(case
         when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency8
         else abap.curr'0.00'
      end as fis_dr_gsl) as DebitAmountInFreeDfndCrcy8,    
      
      _Item.BaseUnit,
      _Item.Quantity,   
      _Item.FixedQuantity, 
      _Item.CostSourceUnit,
      _Item.ValuationQuantity,
      
      _Item.ValuationFixedQuantity,
      _Item.AdditionalQuantity1Unit,
      _Item.AdditionalQuantity1,
      _Item.AdditionalQuantity2Unit,
      _Item.AdditionalQuantity2,
      _Item.AdditionalQuantity3Unit,
      _Item.AdditionalQuantity3,
      
      _Item.IncmpltSummableValnQtyUnt,
      _Item.IncmpltSummableValnQty,
      _Item.IncmpltSummableValnFxdQty,
      
      _Item.DebitCreditCode,
      
      _Item.ExchangeRateDate,
      _Item.FiscalPeriod,
      _Item.FiscalYearVariant,
      _Item.FiscalYearPeriod,
      _Item.PostingDate,
      _Item.DocumentDate,
      _Item.AccountingDocumentType,
      _Item.AccountingDocumentItem,
      _Item.AssignmentReference,
      _Item.AccountingDocumentCategory,
      _Item.PostingKey,
      _Item.TransactionTypeDetermination,
      _Item.SubLedgerAcctLineItemType,
      _Item.AccountingDocCreatedByUser,
      _Item.CreationDate,
      _Item.CreationDateTime,
      _Item.EliminationProfitCenter,
      _Item.OriginObjectType,
      _Item.GLAccountType,
      _Item.AlternativeGLAccount, 
      _Item.CountryChartOfAccounts,
      _Item.ConsolidationUnit,
      _Item.InvoiceReference,
      _Item.InvoiceReferenceFiscalYear,
      _Item.FollowOnDocumentType,
      _Item.InvoiceItemReference,
      _Item.PartnerConsolidationUnit,
      _Item.Company, 
      _Item.ConsolidationChartOfAccounts,
      _Item.CnsldtnFinancialStatementItem,
      _Item.CnsldtnSubitemCategory,
      _Item.CnsldtnSubitem,      
      _Item.ReferencePurchaseOrderCategory,
      _Item.PurchasingDocument,
      _Item.PurchasingDocumentItem,
      _Item.AccountAssignmentNumber,
      _Item.DocumentItemText,
      _Item.SalesDocument,
      _Item.SalesDocumentItem,
      _Item.Product,
      _Item.ProductGroup,
      _Item.Plant,
      _Item.Supplier,
      _Item.Customer,
      _Item.ServicesRenderedDate,
      _Item.PerformancePeriodStartDate,
      _Item.PerformancePeriodEndDate,
      _Item.FinancialAccountType,
      _Item.SpecialGLCode,
      _Item.TaxCode,
      _Item.TaxCountry,
      _Item.HouseBank,
      _Item.HouseBankAccount,
      _Item.IsOpenItemManaged,
      _Item.ClearingDate,      
      _Item.ClearingJournalEntryFiscalYear,
      _Item.ClearingJournalEntry, 
      cast( ( case _Item.ClearingDate when '00000000' then ' '               
                                else 'X' 
            end ) as farp_xaugp preserving type ) as IsCleared,           
      _Item.ValueDate,     
      _Item.AssetDepreciationArea,
      _Item.MasterFixedAsset,
      _Item.FixedAsset,
      _Item.AssetValueDate,
      _Item.AssetTransactionType,
      _Item.AssetAcctTransClassfctn,
      _Item.DepreciationFiscalPeriod,
      _Item.GroupMasterFixedAsset,
      _Item.GroupFixedAsset,
      _Item.PartnerMasterFixedAsset,
      _Item.PartnerFixedAsset,
      _Item.AssetClass,
      _Item.CostEstimate,
      _Item.InventorySpecialStockValnType,
      _Item.InventorySpecialStockType,
      _Item.InventorySpclStkSalesDocument,
      _Item.InventorySpclStkSalesDocItm, 
      _Item.InvtrySpclStockWBSElmntIntID,
      _Item.InventorySpecialStockSupplier,
      _Item.InventoryValuationType,
      _Item.ValuationArea,  
      //cast( _Item._InvtrySpclStkWBSElmntBscData.WBSElementExternalID  as fis_invspstock_wbsext_no_conv ) as InvtrySpclStockWBSElmntExtID,    

      _Item.ProductPriceControl, 
      _Item.SenderGLAccount,    
      _Item.SenderAccountAssignment,
      _Item.SenderAccountAssignmentType,
      _Item.ControllingObject,
      _Item.CostOriginGroup,
      _Item.OriginSenderObject,
      cast(_Item.ControllingDebitCreditCode as fis_co_belkz_conv) as ControllingDebitCreditCode,
      _Item.ControllingObjectDebitType,
      _Item.QuantityIsIncomplete,
      _Item.OffsettingAccount,
      _Item.OffsettingAccountType,
      _Item.OffsettingChartOfAccounts,
      _Item.LineItemIsCompleted,
      _Item.PersonnelNumber,  
      _Item.BillableControl,
      _Item.ControllingObjectClass,
      _Item.PartnerCompanyCode,  
      _Item.PartnerControllingObjectClass,
      _Item.OriginCostCtrActivityType,
      _Item.OriginCostCenter,
      _Item.OriginProfitCenter,
      _Item.OriginProduct,
      _Item.VarianceOriginGLAccount,
      _Item.AccountAssignment,
      _Item.AccountAssignmentType,
      _Item.CostCtrActivityType,
      _Item.OrderID,
      _Item.OrderCategory,
      _Item.WBSElementInternalID,
      //cast( _Item._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) as WBSElementExternalID,

      _Item.PartnerWBSElementInternalID,
      //cast( _Item._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) as PartnerWBSElementExternalID,

      _Item.WorkPackage,
      _Item.ProjectInternalID,
      _Item.PartnerProjectInternalID,
      //cast( _Item._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) as PartnerProjectExternalID,

      //cast( _Item._ProjectBasicData.ProjectExternalID  as fis_projectext_no_conv ) as ProjectExternalID,

      _Item.OperatingConcern,
      _Item.ProjectNetwork,
      cast(_Item.RelatedNetworkActivity as fis_npvrg_conv) as RelatedNetworkActivity,
      _Item.BusinessProcess,
      _Item.CostObject,     
      _Item.CostAnalysisResource,
      _Item.CustomerServiceNotification,
      _Item.ServiceDocumentType,
      _Item.ServiceDocument,
      _Item.ServiceDocumentItem,
      _Item.PartnerServiceDocumentType,
      _Item.PartnerServiceDocument,
      _Item.PartnerServiceDocumentItem,
      _Item.ServiceContractType,
      _Item.ServiceContract,
      _Item.ServiceContractItem,  
      _Item.BusinessSolutionOrder,
      _Item.BusinessSolutionOrderItem,
      _Item.ProviderContract,
      _Item.ProviderContractItem,
      _Item.TimeSheetOvertimeCategory, 
      _Item.PartnerAccountAssignment,
      _Item.PartnerAccountAssignmentType,
      _Item.PartnerCostCtrActivityType,
      cast(_Item.PartnerOrder as fis_par_aufnr preserving type ) as PartnerOrder,
      _Item.PartnerOrderCategory,
      _Item.PartnerSalesDocument,
      _Item.PartnerSalesDocumentItem,
      _Item.PartnerProjectNetwork,
      cast(_Item.PartnerProjectNetworkActivity as fis_par_vornr_auf_conv) as PartnerProjectNetworkActivity,
      _Item.PartnerBusinessProcess,
      _Item.PartnerCostObject,
      _Item.WorkItem,   
      _Item.BillingDocumentType,
      _Item.SalesOrganization,
      _Item.DistributionChannel,
      _Item.OrganizationDivision,
      _Item.SoldProduct,
      _Item.SoldProductGroup,
      _Item.CustomerGroup,
      _Item.CustomerSupplierCountry,
      _Item.CustomerSupplierIndustry,
      _Item.SalesDistrict,
      _Item.BillToParty,  
      _Item.ShipToParty,
      _Item.CustomerSupplierCorporateGroup, 
      _Item.CashLedgerCompanyCode,
      _Item.CashLedgerAccount,
      _Item.FinancialManagementArea,
      _Item.FundsCenter,
      _Item.FundedProgram,
      _Item.Fund,
      _Item.GrantID,
      _Item.BudgetPeriod,
      _Item.PartnerFund,
      _Item.PartnerGrant,
      _Item.PartnerBudgetPeriod,
      _Item.PubSecBudgetAccount,
      _Item.PubSecBudgetAccountCoCode,  
      _Item.PubSecBudgetCnsmpnDate, 
      _Item.PubSecBudgetCnsmpnFsclYear,
      _Item.PubSecBudgetCnsmpnFsclPeriod,
      _Item.PubSecBudgetIsRelevant,
      _Item.PubSecBudgetCnsmpnType,
      _Item.PubSecBudgetCnsmpnAmtType,
      _Item.SponsoredProgram,
      _Item.SponsoredClass,      
      _Item.GteeMBudgetValidityNumber,
      _Item.CommitmentItem,    
      _Item.JointVenture,
      _Item.JointVentureEquityGroup,
      _Item.JointVentureCostRecoveryCode,
      _Item.JointVenturePartner,
      _Item.JointVentureBillingType,
      _Item.JointVentureEquityType,
      _Item.JointVentureProductionDate,
      _Item.JointVentureBillingDate,
      _Item.JointVentureOperationalDate,
      _Item.CutbackRun,
      _Item.JointVentureAccountingActivity,
      _Item.SettlementReferenceDate,
      _Item.PartnerVenture,
      _Item.PartnerEquityGroup,
      _Item.SenderCostRecoveryCode,
      _Item.CutbackAccount,
      _Item.CutbackCostObject,
      _Item.REBusinessEntity,
      _Item.RealEstateBuilding,
      _Item.RealEstateProperty,
      _Item.RERentalObject,
      _Item.RealEstateContract,
      _Item.REServiceChargeKey,
      _Item.RESettlementUnitID,      
      _Item.AccrualObjectType,
      _Item.AccrualObjectLogicalSystem,
      _Item.AccrualObject,
      _Item.AccrualSubobject,
      _Item.AccrualItemType,
      _Item.AccrualReferenceObject,
      _Item.AccrualValueDate,
      _Item.FinancialValuationObjectType,    
      _Item.FinancialValuationObject,
      _Item.FinancialValuationSubobject,
      _Item.NetDueDate,
      _Item.CreditRiskClass,
      
      case  when ( _Item.AmountInTransactionCurrency  > 0 ) 
              and _Item.DebitCreditCode = 'H' then cast( 'X' as fis_xnegp preserving type )
            when ( _Item.AmountInTransactionCurrency  < 0 ) 
              and _Item.DebitCreditCode = 'S' then cast( 'X' as fis_xnegp preserving type )            
            else cast( ' ' as fis_xnegp preserving type ) end as IsNegativePosting,
      
      cast( ( case when ( _Item.AccountAssignmentType != 'OR' and _Item.AccountAssignmentType != 'OP' and _Item.AccountAssignmentType != 'OV' ) and _Item.OrderID != ''
             then 'X'
             else ' '
        end ) as fins_xaufnr_stat preserving type ) as IsStatisticalOrder,

      cast( ( case when ( _Item.AccountAssignmentType != 'KL' and _Item.AccountAssignmentType != 'KS' ) and _Item.CostCenter != ''
             then 'X'
             else ' '
        end ) as fins_xkostl_stat preserving type ) as IsStatisticalCostCenter,

      cast( ( case when _Item.AccountAssignmentType != 'VB' and _Item.SalesDocument != ''
             then 'X'
             else ' '
        end ) as fis_xkdpos_stat preserving type ) as IsStatisticalSalesDocument,

      cast( ( case when ( _Item.AccountAssignmentType != 'PR' ) and ( _Item.WBSElementInternalID != '00000000' )
             then 'X'
             else ' '
        end ) as fins_xps_posid_stat preserving type ) as WBSIsStatisticalWBSElement,
        
      cast(_Item.OrderOperation as vdm_vornr) as OrderOperation,    
      _Item.JrnlEntryItemMigrationSource,
      
      cast(_Item.FinancialServicesProductGroup as ffs_product_group preserving type) as FinancialServicesProductGroup,
      cast(_Item.FinancialServicesBranch as ffs_branch_id preserving type) as FinancialServicesBranch,
      cast(_Item.FinancialDataSource as ffs_datasource_id preserving type) as FinancialDataSource,
      
      cast(
        case _Item.AccountAssignmentType
          when 'EO' then _Item.AccountAssignment
          else ''
      end as rkeobjnr_char) as ProfitabilitySegment,
      
      _Item.RevenueAccountingContract,
      _Item.PerformanceObligation,      
      _Item.ComponentBreakdown,
      _Item.CompBreakdownScaleNumerator,
      
      cast('TECHNICAL' as abap.char( 10 )) as Source,
      'X' as IsStatisticalDocument,
      //FOR DCL

      _Item._GLAccountInCompanyCode,
      _Item._Supplier,
      _Item._Order,
      _Item._Customer,
      _Item._AccountingDocumentType,
      _Item._ServiceDocument,
      _Item._SalesDocument
}