R_ManageJournalEntryItem

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Journal Entry Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

define view entity R_ManageJournalEntryItem
  as select from I_OperationalAcctgDocItem

{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key AccountingDocumentItem,

      ChartOfAccounts,
      ClearingDate,
      ClearingCreationDate,
      ClearingJournalEntry,

      PostingKey,
      FinancialAccountType,
      SpecialGLCode,
      SpecialGLTransactionType,
      DebitCreditCode,
      BusinessArea,
      PartnerBusinessArea,
      TaxCode,
      WithholdingTaxCode,
      TaxType,
      TransactionTypeDetermination,
      ValueDate,
      AssignmentReference,
      DocumentItemText,
      PartnerCompany,
      FinancialTransactionType,
      CorporateGroupAccount,
      PlanningLevel,
      ControllingArea,
      CostCenter,
      //ProjectInternalID,   -- to be retrieved later from WBS Element

      OrderID,
      BillingDocument,
      SalesDocument,
      SalesDocumentItem,
      ScheduleLine,
      ServiceDocumentType,
      ServiceDocument,
      ServiceDocumentItem,
      MasterFixedAsset,
      FixedAsset,
      AssetTransactionType,
      AssetValueDate,
      PersonnelNumber,
      IsSalesRelated,
      LineItemDisplayIsEnabled,
      @Semantics.booleanIndicator
      IsOpenItemManaged,
      IsNotCashDiscountLiable,
      IsAutomaticallyCreated,
      IsUsedInPaymentTransaction,
      OperationalGLAccount,
      GLAccount,
      Customer,
      Supplier,
      BranchAccount,
      IsBalanceSheetAccount,
      ProfitLossAccountType,
      SpecialGLAccountAssignment,
      DueCalculationBaseDate,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      CashDiscountBaseAmount,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      CashDiscountAmount,
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,
      PaymentMethod,
      PaymentBlockingReason,
      FixedCashDiscount,
      HouseBank,
      BPBankAccountInternalID,
      TaxDistributionCode1,
      TaxDistributionCode2,
      TaxDistributionCode3,
      InvoiceReference,
      InvoiceReferenceFiscalYear,
      InvoiceItemReference,
      FollowOnDocumentType,
      StateCentralBankPaymentReason,
      SupplyingCountry,
      InvoiceList,
      BillOfExchangeUsage,
      DunningKey,
      DunningBlockingReason,
      LastDunningDate,
      DunningLevel,
      DunningArea,
      WithholdingTaxCertificate,
      Product,
      Plant,
      PurchasingDocument,
      PurchasingDocumentItem,
      AccountAssignmentNumber,
      IsCompletelyDelivered,
      IsCompletelyDelivered as LineItemIsCompleted,
      MaterialPriceControl,
      ValuationArea,
      InventoryValuationType,
      VATRegistration,
      DelivOfGoodsDestCountry,
      PaymentDifferenceReason,
      ProfitCenter,
      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityGroup,
      TreasuryContractType,
      AssetContract,
      CashFlowType,
      TaxJurisdiction,
      REInternalFinNumber,
      SettlementReferenceDate,
      cast(CommitmentItem as fm_fipex) as CommitmentItem,
      CommitmentItemShortID,
      CostObject,
      ProjectNetwork,
      OrderInternalBillOfOperations,
      OrderIntBillOfOperationsItem,
      cast( WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
      _WBSElementBasicData.WBSElementExternalID,
      _WBSElementBasicData.WBSDescription,

      ProfitabilitySegment_2 as ProfitabilitySegment,
      JointVentureEquityType,
      IsEUTriangularDeal,
      CostOriginGroup,
      CompanyCodeCurrencyDetnMethod,
      ClearingIsReversed,
      PaymentMethodSupplement,
      AlternativeGLAccount,
      PartnerProfitCenter,
      Reference1IDByBusinessPartner,
      Reference2IDByBusinessPartner,
      IsNegativePosting,
      PaymentCardItem,
      PaymentCardPaymentSettlement,
      CreditControlArea,
      Reference3IDByBusinessPartner,
      DataExchangeInstruction1,
      DataExchangeInstruction2,
      DataExchangeInstruction3,
      DataExchangeInstruction4,
      Region,
      HasPaymentOrder,
      PaymentReference,
      TaxDeterminationDate,
      ClearingItem,
      BusinessPlace,
      TaxSection,
      CostCtrActivityType,
      @Semantics.booleanIndicator
      cast( case AcctsReceivablePledgingCode when '  ' then ' '
                                             else 'X'
      end as fis_cession_kz_ind preserving type ) as AccountsReceivableIsPledged,
      AcctsReceivablePledgingCode,
      BusinessProcess,
      FunctionalArea,
      CustomerIsInExecution,
      ClearingJournalEntryFiscalYear,
      LedgerGLLineItem,
      Segment,
      PartnerSegment,
      PartnerFunctionalArea,
      HouseBankAccount,
      CostElement,
      PaymentServiceProvider,
      PaymentRefByPaytSrvcProvider,
      SEPAMandate,
      ReferenceDocumentType,
      OriginalReferenceDocument,
      ReferenceDocumentLogicalSystem,
      AccountingDocumentItemRef,
      FiscalPeriod,
      AccountingDocumentCategory,
      PostingDate,
      DocumentDate,
      AccountingDocumentType,
      NetDueDate,
      CashDiscount1DueDate,
      CashDiscount2DueDate,
      OffsettingAccount,
      OffsettingAccountType,
      OffsettingChartOfAccounts,
      CashLedgerCompanyCode,
      CashLedgerAccount,
      _JournalEntry.FinancialManagementArea as FinancialManagementArea,
      FundsCenter,
      FundedProgram,
      Fund,
      GrantID,
      BudgetPeriod,
      PartnerFund,
      PartnerGrant,
      PartnerBudgetPeriod,
      PubSecBudgetAccount,
      PubSecBudgetAccountCoCode,

      CompanyCodeCurrency,

      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      AmountInCompanyCodeCurrency,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast(case DebitCreditCode  when 'H' then -AmountInCompanyCodeCurrency
                                 else abap.curr'0.00'
      end as fis_cr_hsl) as CreditAmountInCoCodeCrcy,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      cast(case DebitCreditCode  when 'S' then AmountInCompanyCodeCurrency
                                 else abap.curr'0.00'
      end as fis_dr_hsl) as DebitAmountInCoCodeCrcy,

      FunctionalCurrency,

      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      AmountInFunctionalCurrency,
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      cast(case DebitCreditCode  when 'H' then -AmountInFunctionalCurrency
                                 else abap.curr'0.00'
      end as fis_cr_amt_funccrcy) as CreditAmountInFunctionalCrcy,
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      cast(case DebitCreditCode  when 'S' then AmountInFunctionalCurrency
                                 else abap.curr'0.00'
      end as fis_dr_amt_funccrcy) as DebitAmountInFunctionalCrcy,

      TransactionCurrency,

      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      AmountInTransactionCurrency,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      cast(case DebitCreditCode  when 'H' then -AmountInTransactionCurrency
                                 else abap.curr'0.00'
      end as fis_cr_wsl) as CreditAmountInTransCrcy,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      cast(case DebitCreditCode  when 'S' then AmountInTransactionCurrency
                                 else abap.curr'0.00'
      end as fis_dr_wsl) as DebitAmountInTransCrcy,

      BalanceTransactionCurrency,

      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      AmountInBalanceTransacCrcy,
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      cast(case DebitCreditCode  when 'H' then -AmountInBalanceTransacCrcy
                                 else abap.curr'0.00'
      end as fis_cr_tsl) as CreditAmountInBalanceTransCrcy,
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      cast(case DebitCreditCode  when 'S' then AmountInBalanceTransacCrcy
                                 else abap.curr'0.00'
      end as fis_dr_tsl) as DebitAmountInBalanceTransCrcy,

      AdditionalCurrency1,

      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      AmountInAdditionalCurrency1,
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      cast(case DebitCreditCode  when 'H' then -AmountInAdditionalCurrency1
                                 else abap.curr'0.00'
      end as fis_dmbe2) as CreditAmountInAddlCrcy1,
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      cast(case DebitCreditCode  when 'S' then AmountInAdditionalCurrency1
                                 else abap.curr'0.00'
      end as fis_dmbe2) as DebitAmountInAddlCrcy1,

      AdditionalCurrency2,

      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      AmountInAdditionalCurrency2,
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      cast(case DebitCreditCode  when 'H' then -AmountInAdditionalCurrency2
                                 else abap.curr'0.00'
      end as fis_dmbe3) as CreditAmountInAddlCrcy2,
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      cast(case DebitCreditCode  when 'S' then AmountInAdditionalCurrency2
                                 else abap.curr'0.00'
      end as fis_dmbe3) as DebitAmountInAddlCrcy2,

      PaymentCurrency,

      @Semantics: { amount : {currencyCode: 'PaymentCurrency'} }
      AmountInPaymentCurrency,

      BaseUnit,

      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      case DebitCreditCode  when 'H' then cast(-Quantity as quan1_12)
                            when 'S' then cast( Quantity as quan1_12)
                            else cast( Quantity as quan1_12)
      end as Quantity,

      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      cast( Quantity as fis_absolute_quantity ) as AbsoluteQuantity,

      GoodsMovementEntryUnit,
      @Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} }
      QuantityInEntryUnit,

      PurchasingDocumentPriceUnit,
      @Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} }
      PurchaseOrderQty,
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      MaterialPriceUnitQty,

      EarmarkedFundsDocument,
      EarmarkedFundsDocumentItem,
      cast( PaytSlipWthRefReference as fac_mje_esrre preserving type ) as PaytSlipWthRefReference,
      TaxRateValidityStartDate,
      PaytSlipWthRefCheckDigit,
      PaytSlipWthRefSubscriber,
      PaymentReason,
      BranchCode,
      @Semantics: { amount : {currencyCode: 'PaymentCurrency'} }
      NetPaymentAmount,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      TaxBaseAmountInCoCodeCrcy,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      TaxBaseAmountInTransCrcy,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxAmount,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxExemptionAmt,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxBaseAmount,
      TaxCountry,
      @Semantics.booleanIndicator
      AddressAndBankIsSetManually,

      OplAcctgDocItmCntrySpcfcRef1,

      cast(FinancialServicesProductGroup as ffs_product_group preserving type) as FinancialServicesProductGroup,
      cast(FinancialServicesBranch as ffs_branch_id preserving type) as FinancialServicesBranch,
      cast(FinancialDataSource as ffs_datasource_id preserving type) as FinancialDataSource,
      CustomerGroup,
      CustomerSupplierCountry,
      CustomerSupplierIndustry,

      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      CashDiscountAmtInCoCodeCrcy,
      AccountingDocumentItemType,

      AlternativePayeePayer,
      DownPaymentIsNetProcedure,
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      TaxAmountInCoCodeCrcy,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      TaxAmount,


      //DCL

      cast( '' as anlkl)  as AssetClass

}

union all

select from I_AddlLedgerOplAcctgDocItem


{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key cast( substring( AccountingDocumentItem, 4, 3 ) as fis_buzei ) as AccountingDocumentItem,

      ChartOfAccounts,
      ClearingDate,
      ClearingCreationDate,
      ClearingJournalEntry,

      PostingKey,
      FinancialAccountType,
      cast( ' ' as fac_umskz preserving type )  as SpecialGLCode,
      cast( ' ' as farp_umsks preserving type ) as SpecialGLTransactionType,
      DebitCreditCode,
      BusinessArea,
      PartnerBusinessArea,
      TaxCode,
      WithholdingTaxCode,
      cast( ' ' as mwart) as TaxType,
      TransactionTypeDetermination,
      ValueDate,
      AssignmentReference,
      DocumentItemText,
      PartnerCompany,
      FinancialTransactionType,
      CorporateGroupAccount,
      cast( '  ' as fdlev) as PlanningLevel,
      ControllingArea,
      CostCenter,
      //ProjectInternalID,   -- to be retrieved later from WBS Element

      OrderID,
      cast( '' as vbeln_vf) as BillingDocument,
      cast( '' as vbeln_va) as SalesDocument,
      cast( '000000' as fis_posnr_va) as SalesDocumentItem,
      cast( '0000' as fis_etenr) as ScheduleLine,
      cast( '' as fco_srvdoc_type) as ServiceDocumentType,
      cast( '' as fco_srvdoc_id) as ServiceDocument,
      cast( '000000' as fco_srvdoc_item_id) as ServiceDocumentItem,
      MasterFixedAsset,
      FixedAsset,
      AssetTransactionType,
      cast ('00000000' as bzdat ) as AssetValueDate,
      cast( '00000000' as pernr_d) as PersonnelNumber,
      cast( '' as fis_xumsw) as IsSalesRelated,
      cast( '' as fis_xkres) as LineItemDisplayIsEnabled,
      IsOpenItemManaged,
      cast( '' as fis_xskrl) as IsNotCashDiscountLiable,
      IsAutomaticallyCreated,
      cast( '' as fis_xzahl) as IsUsedInPaymentTransaction,
      cast( '' as fis_op_saknr) as OperationalGLAccount,
      GLAccount,
      cast( '' as kunnr) as Customer,
      cast( '' as md_supplier) as Supplier,
      cast( '' as fis_filkd) as BranchAccount,
      IsBalanceSheetAccount,
      ProfitLossAccountType,
      cast( '' as fins_hzuon) as SpecialGLAccountAssignment,
      DueCalculationBaseDate,
      cast(0 as fis_skfbt) as CashDiscountBaseAmount,
      cast(0 as fis_wskto) as CashDiscountAmount,
      cast( '' as farp_dzterm) as PaymentTerms,
      cast( '0' as farp_dzbd1t) as CashDiscount1Days,
      cast( '0' as farp_dzbd2t) as CashDiscount2Days,
      cast( '000' as farp_dzbd3t) as NetPaymentDays,
      cast( '0'  as dzbd1p_farp) as CashDiscount1Percent,
      cast( '0'  as dzbd2p_farp) as CashDiscount2Percent,
      cast( '' as farp_schzw_bseg) as PaymentMethod,
      cast( '' as fis_dzlspr) as PaymentBlockingReason,
      cast( '' as fis_dzbfix) as FixedCashDiscount,
      cast( '' as farp_hbkid) as HouseBank,
      cast( '' as farp_bvtyp) as BPBankAccountInternalID,
      cast( '' as fis_mwsk1) as TaxDistributionCode1,
      cast( '' as fis_mwsk2) as TaxDistributionCode2,
      cast( '' as fis_mwsk3) as TaxDistributionCode3,
      InvoiceReference,
      InvoiceReferenceFiscalYear,
      InvoiceItemReference,
      FollowOnDocumentType,
      cast( '' as lzbkz) as StateCentralBankPaymentReason,
      cast( '' as fac_landl) as SupplyingCountry,
      cast( '' as fis_samnr) as InvoiceList,
      BillOfExchangeUsage,
      cast( '' as farp_mschl) as DunningKey,
      cast( '' as fis_mansp) as DunningBlockingReason,
      cast( '00000000' as farp_madat) as LastDunningDate,
      cast( '' as farp_mahns_d) as DunningLevel,
      cast( '' as farp_maber) as DunningArea,
      cast( '' as fis_wtcert) as WithholdingTaxCertificate,
      Product,
      Plant,
      cast( '' as fis_ebeln) as PurchasingDocument,
      cast( '' as fis_ebelp) as PurchasingDocumentItem,
      cast( '' as dzekkn) as AccountAssignmentNumber,
      cast( '' as fis_elikz) as IsCompletelyDelivered,
      cast( '' as fis_kblerlkz) as LineItemIsCompleted,
      cast( '' as fis_vprsv) as MaterialPriceControl,
      ValuationArea,
      InventoryValuationType,
      cast( '' as fis_stceg) as VATRegistration,
      cast( '' as egbld) as DelivOfGoodsDestCountry,
      cast( '' as fis_rstgr) as PaymentDifferenceReason,
      ProfitCenter,
      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityGroup,
      TreasuryContractType,
      AssetContract,
      CashFlowType,
      cast( '' as fis_txjcd) as TaxJurisdiction,
      REInternalFinNumber,
      SettlementReferenceDate,
      cast(CommitmentItem as fm_fipex) as CommitmentItem,
      CommitmentItemShortID,
      CostObject,
      ProjectNetwork,
      OrderInternalBillOfOperations,
      OrderIntBillOfOperationsItem,
      cast( WBSElementInternalID as fis_wbsint_no_conv ) as WBSElementInternalID,
      _WBSElementBasicData.WBSElementExternalID,
      _WBSElementBasicData.WBSDescription,

      ProfitabilitySegment_2 as ProfitabilitySegment,
      cast( '' as jv_etype_cds) as JointVentureEquityType,
      cast( '' as fis_xegdr) as IsEUTriangularDeal,
      cast( '' as hrkft) as CostOriginGroup,
      cast( '' as fac_hwmet) as CompanyCodeCurrencyDetnMethod,
      ClearingIsReversed,
      PaymentMethodSupplement,
      AlternativeGLAccount,
      PartnerProfitCenter,
      Reference1IDByBusinessPartner,
      Reference2IDByBusinessPartner,
      cast( '' as fis_xnegp) as IsNegativePosting,
      PaymentCardItem,
      PaymentCardPaymentSettlement,
      cast( '' as farp_kkber) as CreditControlArea,
      Reference3IDByBusinessPartner,
      cast( '00' as fis_dtat16) as DataExchangeInstruction1,
      cast( '00' as fis_dtat17) as DataExchangeInstruction2,
      cast( '00' as fis_dtat18) as DataExchangeInstruction3,
      cast( '00' as fis_dtat19) as DataExchangeInstruction4,
      cast( '' as regio) as Region,
      cast( '' as farp_xpypr) as HasPaymentOrder,
      cast( '' as farp_kidno) as PaymentReference,
      cast( '00000000' as fis_txdat) as TaxDeterminationDate,
      ClearingItem,
      BusinessPlace,
      TaxSection,
      CostCtrActivityType,
      cast( '' as fis_cession_kz) as AccountsReceivableIsPledged,
      cast( '' as fis_cession_kz_code) as AcctsReceivablePledgingCode,
      BusinessProcess,
      FunctionalArea,
      cast( '' as fis_gmvkzd) as CustomerIsInExecution,
      ClearingJournalEntryFiscalYear,
      cast( '' as fis_docln) as LedgerGLLineItem,
      Segment,
      PartnerSegment,
      PartnerFunctionalArea,
      cast( '' as fac_hktid) as HouseBankAccount,
      CostElement,
      cast( '' as farp_payment_srv_provider) as PaymentServiceProvider,
      cast( '' as farp_fps_transaction) as PaymentRefByPaytSrvcProvider,
      cast( '' as fis_sepa_mndid) as SEPAMandate,
      cast( '' as abap.char(5)) as ReferenceDocumentType,
      cast( '' as abap.char(20)) as OriginalReferenceDocument,
      cast( '' as abap.char(10)) as ReferenceDocumentLogicalSystem,
      cast( '0000000000' as fis_posnr_acc) as AccountingDocumentItemRef,
      cast( '' as fins_fiscalperiod) as FiscalPeriod, //BKPF

      AccountingDocumentCategory,
      cast( '00000000' as fis_budat) as PostingDate, //BKPF

      cast( '00000000' as fis_bldat) as DocumentDate, //BKPF

      cast( '' as farp_blart) as AccountingDocumentType, //BKPF

      NetDueDate,
      cast( '00000000' as farp_sk1dt) as CashDiscount1DueDate,
      cast( '00000000' as farp_sk2dt) as CashDiscount2DueDate,
      OffsettingAccount,
      OffsettingAccountType,
      OffsettingChartOfAccounts,
      CashLedgerCompanyCode,
      CashLedgerAccount,
      _JournalEntry.FinancialManagementArea as FinancialManagementArea,
      FundsCenter,
      FundedProgram,
      Fund,
      GrantID,
      BudgetPeriod,
      PartnerFund,
      PartnerGrant,
      PartnerBudgetPeriod,
      PubSecBudgetAccount,
      PubSecBudgetAccountCoCode,

      CompanyCodeCurrency,

      AmountInCompanyCodeCurrency,
      cast(case DebitCreditCode  when 'H' then -AmountInCompanyCodeCurrency
                                 else abap.curr'0.00'
      end as fis_cr_hsl) as CreditAmountInCoCodeCrcy,
      cast(case DebitCreditCode  when 'S' then AmountInCompanyCodeCurrency
                                 else abap.curr'0.00'
      end as fis_dr_hsl) as DebitAmountInCoCodeCrcy,

      FunctionalCurrency,

      AmountInFunctionalCurrency,
      cast(case DebitCreditCode  when 'H' then -AmountInFunctionalCurrency
                                 else abap.curr'0.00'
      end as fis_cr_tsl) as CreditAmountInFunctionalCrcy,
      cast(case DebitCreditCode  when 'S' then AmountInFunctionalCurrency
                                 else abap.curr'0.00'
      end as fis_dr_tsl) as DebitAmountInFunctionalCrcy,

      TransactionCurrency,

      AmountInTransactionCurrency,
      cast(case DebitCreditCode  when 'H' then -AmountInTransactionCurrency
                                 else abap.curr'0.00'
      end as fis_cr_wsl) as CreditAmountInTransCrcy,
      cast(case DebitCreditCode  when 'S' then AmountInTransactionCurrency
                                 else abap.curr'0.00'
      end as fis_dr_wsl) as DebitAmountInTransCrcy,

      BalanceTransactionCurrency,

      AmountInBalanceTransacCrcy,
      cast(case DebitCreditCode  when 'H' then -AmountInBalanceTransacCrcy
                                 else abap.curr'0.00'
      end as fis_cr_tsl) as CreditAmountInBalanceTransCrcy,
      cast(case DebitCreditCode  when 'S' then AmountInBalanceTransacCrcy
                                 else abap.curr'0.00'
      end as fis_dr_tsl) as DebitAmountInBalanceTransCrcy,

      AdditionalCurrency1,

      AmountInAdditionalCurrency1,
      cast(case DebitCreditCode  when 'H' then -AmountInAdditionalCurrency1
                                 else abap.curr'0.00'
      end as fis_dmbe2) as CreditAmountInAddlCrcy1,
      cast(case DebitCreditCode  when 'S' then AmountInAdditionalCurrency1
                                 else abap.curr'0.00'
      end as fis_dmbe2) as DebitAmountInAddlCrcy1,

      AdditionalCurrency2,

      AmountInAdditionalCurrency2,
      cast(case DebitCreditCode  when 'H' then -AmountInAdditionalCurrency2
                                 else abap.curr'0.00'
      end as fis_dmbe3) as CreditAmountInAddlCrcy2,
      cast(case DebitCreditCode  when 'S' then AmountInAdditionalCurrency2
                                 else abap.curr'0.00'
      end as fis_dmbe3) as DebitAmountInAddlCrcy2,

      cast( '     ' as abap.cuky(5)) as PaymentCurrency,

      cast( '0' as abap.curr( 23,2)) as AmountInPaymentCurrency,

      BaseUnit,

      case DebitCreditCode  when 'H' then cast(-Quantity as quan1_12)
                            when 'S' then cast( Quantity as quan1_12)
                            else cast( Quantity as quan1_12)
      end as Quantity,

      cast( Quantity as fis_absolute_quantity ) as AbsoluteQuantity,

      cast( '' as erfme) as GoodsMovementEntryUnit,
      cast( 0 as fis_quantityinentryunit) as  QuantityInEntryUnit,

      cast( '' as fis_bprme) as PurchasingDocumentPriceUnit,
      cast( 0 as fis_bpmng_long) as PurchaseOrderQty,

      cast( '0' as fis_peinh) as MaterialPriceUnitQty,

      EarmarkedFundsDocument,
      EarmarkedFundsDocumentItem,
      cast( '' as fac_mje_esrre) as PaytSlipWthRefReference,
      cast( '00000000' as fis_txdat_from) as TaxRateValidityStartDate,
      cast( '' as fis_esrpz) as PaytSlipWthRefCheckDigit,
      cast( '' as fis_esrnr) as PaytSlipWthRefSubscriber,
      cast( '' as farp_payt_rsn) as PaymentReason,
      cast( '' as bcode) as BranchCode,
      cast( 0 as fis_nebtr) as NetPaymentAmount,
      cast( 0 as hwbas_shl) as TaxBaseAmountInCoCodeCrcy,
      cast( 0 as fwbas_shl) as TaxBaseAmountInTransCrcy,
      cast( 0 as fis_qbshb) as WithholdingTaxAmount,
      cast( 0 as fis_qsfbt) as WithholdingTaxExemptionAmt,
      cast( 0 as fis_qsshb) as WithholdingTaxBaseAmount,
      cast( '' as fot_tax_country) as TaxCountry,
      cast( '' as farp_xcpdd preserving type ) as  AddressAndBankIsSetManually,

      cast('' as fac_glo_ref1) as OplAcctgDocItmCntrySpcfcRef1,

      cast('' as ffs_product_group) as FinancialServicesProductGroup,
      cast('' as ffs_branch_id) as FinancialServicesBranch,
      cast('' as ffs_datasource_id) as FinancialDataSource,
      cast('' as kdgrp) as CustomerGroup,
      cast('' as fis_land1_gp) as CustomerSupplierCountry,
      cast('' as fis_brsch) as CustomerSupplierIndustry,

      cast(0 as fis_sknto) as CashDiscountAmtInCoCodeCrcy,
      cast('' as buzid preserving type ) as AccountingDocumentItemType,

      cast('' as fis_empfb ) as AlternativePayeePayer,
      cast('' as xanet preserving type ) as DownPaymentIsNetProcedure,
      TaxAmountInCoCodeCrcy,
      TaxAmount,

      //DCL

      cast( '' as anlkl)         as AssetClass

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDLLEDGEROPLACCTGDOCITEM",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/