I_RECEIVABLESPAYABLESITEM

@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Receivables Payables Item'
@Analytics: { dataCategory: #FACT }
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IFIRECPAYITEM'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED

/////////////////////////////////////////////////////////////////////////////////////////////////////////

//

//  NO FURTHER DEVELOPMENT ANYMORE

//

//  use I_OperationalAcctgDocItem instead

//

/////////////////////////////////////////////////////////////////////////////////////////////////////////


define view I_ReceivablesPayablesItem
  as select from P_BSEG_COM

  association [0..1] to I_JournalEntry               as _JournalEntry               on  $projection.AccountingDocument = _JournalEntry.AccountingDocument
                                                                                    and $projection.CompanyCode        = _JournalEntry.CompanyCode
                                                                                    and $projection.FiscalYear         = _JournalEntry.FiscalYear

  association [0..1] to I_CompanyCode                as _CompanyCode                on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_PostingKey                 as _PostingKey                 on  $projection.PostingKey = _PostingKey.PostingKey
  association [0..1] to I_FinancialAccountType       as _FinancialAccountType       on  $projection.FinancialAccountType = _FinancialAccountType.FinancialAccountType
  association [0..1] to I_SpecialGLCode              as _SpecialGLCode              on  $projection.SpecialGLCode        = _SpecialGLCode.SpecialGLCode
                                                                                    and $projection.FinancialAccountType = _SpecialGLCode.FinancialAccountType

  association [0..1] to I_SpecialGLCode              as _TargetSpecialGLCode        on  $projection.TargetSpecialGLCode  = _TargetSpecialGLCode.SpecialGLCode
                                                                                    and $projection.FinancialAccountType = _TargetSpecialGLCode.FinancialAccountType

  association [0..1] to I_DebitCreditCode            as _DebitCreditCode            on  $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode
  association [0..1] to I_BusinessArea               as _BusinessArea               on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1] to I_BusinessArea               as _PartnerBusinessArea        on  $projection.PartnerBusinessArea = _PartnerBusinessArea.BusinessArea

  association [0..1] to I_Currency                   as _BalanceTransactionCurrency on  $projection.BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency
  association [0..1] to I_TaxType                    as _TaxType                    on  $projection.TaxType = _TaxType.TaxType
  association [0..1] to I_CompanyCode                as _PartnerCompany             on  $projection.PartnerCompany = _PartnerCompany.CompanyCode
  association [0..1] to I_FinancialTransactionType   as _FinancialTransactionType   on  $projection.FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType

  association [0..1] to I_GLAccount                  as _CorporateGroupAccount      on  $projection.CorporateGroupAccount = _CorporateGroupAccount.GLAccount
                                                                                    and $projection.CompanyCode           = _CorporateGroupAccount.CompanyCode

  association [0..1] to I_ControllingArea            as _ControllingArea            on  $projection.ControllingArea = _ControllingArea.ControllingArea

  association [0..*] to I_CostCenter                 as _CostCenter                 on  $projection.CostCenter      = _CostCenter.CostCenter
                                                                                    and $projection.ControllingArea = _CostCenter.ControllingArea

  association [0..1] to I_SalesDocumentItem          as _SalesDocumentItem          on  $projection.SalesDocument     = _SalesDocumentItem.SalesDocument
                                                                                    and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem

  association [0..1] to I_GLAccount                  as _GLAccount                  on  $projection.GLAccount   = _GLAccount.GLAccount
                                                                                    and $projection.CompanyCode = _GLAccount.CompanyCode

  association [0..1] to I_PaymentBlockingReason      as _PaymentBlockingReason      on  $projection.PaymentBlockingReason = _PaymentBlockingReason.PaymentBlockingReason

  association [0..1] to I_Country                    as _SupplyingCountry           on  $projection.SupplyingCountry = _SupplyingCountry.Country
  association [0..1] to I_BillOfExchangeUsage        as _BillOfExchangeUsage        on  $projection.BillOfExchangeUsage = _BillOfExchangeUsage.BillOfExchangeUsage
  association [0..1] to I_DunningKey                 as _DunningKey                 on  $projection.DunningKey = _DunningKey.DunningKey
  association [0..1] to I_DunningBlockingReasonCode  as _DunningBlockingReasonCode  on  $projection.DunningBlockingReason = _DunningBlockingReasonCode.DunningBlockingReason
  association [0..1] to I_DunningArea                as _DunningArea                on  $projection.CompanyCode = _DunningArea.CompanyCode
                                                                                    and $projection.DunningArea = _DunningArea.DunningArea
  association [0..1] to I_Material                   as _Material                   on  $projection.Material = _Material.Material

  association [0..1] to I_UnitOfMeasure              as _BaseUnit                   on  $projection.BaseUnit = _BaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _EntryUnit                  on  $projection.EntryUnit = _EntryUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _PurchaseOrderPriceUnit     on  $projection.PurchaseOrderPriceUnit = _PurchaseOrderPriceUnit.UnitOfMeasure

  association [0..1] to I_InventoryValuationType     as _InventoryValType           on  $projection.InventoryValuationType = _InventoryValType.InventoryValuationType
  association [0..1] to I_PaymentDifferenceReason    as _PaymentDifferenceReason    on  $projection.PaymentDifferenceReason = _PaymentDifferenceReason.PaymentDifferenceReason
                                                                                    and $projection.CompanyCode             = _PaymentDifferenceReason.CompanyCode

  association [0..*] to I_ProfitCenter               as _ProfitCenter               on  $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
                                                                                    and $projection.ControllingArea = _ProfitCenter.ControllingArea

  association [0..1] to I_GLAccount                  as _AlternativeGLAccount       on  $projection.AlternativeGLAccount = _AlternativeGLAccount.GLAccount
                                                                                    and $projection.CompanyCode          = _AlternativeGLAccount.CompanyCode

  association [0..*] to I_ProfitCenter               as _PartnerProfitCenter        on  $projection.PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter
                                                                                    and $projection.ControllingArea     = _PartnerProfitCenter.ControllingArea

  association [0..1] to I_CreditControlArea          as _CreditControlArea          on  $projection.CreditControlArea = _CreditControlArea.CreditControlArea
  association [0..1] to I_Currency                   as _PaymentCurrency            on  $projection.PaymentCurrency = _PaymentCurrency.Currency
  association [0..1] to I_CostCenterActivityType     as _CostCtrActivityType        on  $projection.CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType
                                                                                    and $projection.ControllingArea     = _CostCtrActivityType.ControllingArea
  association [0..1] to I_BusinessProcess            as _BusinessProcess            on  $projection.BusinessProcess = _BusinessProcess.BusinessProcess
                                                                                    and $projection.ControllingArea = _BusinessProcess.ControllingArea
  association [0..1] to I_FunctionalArea             as _FunctionalArea             on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea
  association [0..1] to I_Segment                    as _Segment                    on  $projection.Segment = _Segment.Segment
  association [0..1] to I_Segment                    as _PartnerSegment             on  $projection.PartnerSegment = _PartnerSegment.Segment
  association [0..1] to I_FunctionalArea             as _PartnerFunctionalArea      on  $projection.PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea

  association [0..1] to I_ReferenceDocumentType      as _RefDocType                 on  $projection.ReferenceDocumentType = _RefDocType.ReferenceDocumentType

  association [0..1] to I_AccountingDocumentCategory as _AcctDocCategory            on  $projection.AccountingDocumentCategory = _AcctDocCategory.AccountingDocumentCategory
  association [0..1] to I_Currency                   as _Currency                   on  $projection.TransactionCurrency = _Currency.Currency
  association [0..1] to I_AccountingDocumentType     as _AcctDocType                on  $projection.AccountingDocumentType = _AcctDocType.AccountingDocumentType
  association [0..1] to I_Currency                   as _CompanyCodeCurrency        on  $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency

  association [0..1] to I_Customer                   as _Customer                   on  $projection.Debtor = _Customer.Customer
  association [0..1] to I_Supplier                   as _Supplier                   on  $projection.Creditor = _Supplier.Supplier
  association [0..1] to I_FiscalYear                 as _FiscalYear                 on  $projection.FiscalYear        = _FiscalYear.FiscalYear
                                                                                    and $projection.FiscalYearVariant = _FiscalYear.FiscalYearVariant
  association [0..1] to I_FiscalYearVariant          as _FiscalYearVariant          on  $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant

{
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key bukrs                                 as CompanyCode,
      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_JournalEntryStdVH',
                     element: 'AccountingDocument' },
          additionalBinding: [{ localElement: 'CompanyCode',
                                element: 'CompanyCode' },
                              { localElement: 'FiscalYear',
                                element: 'FiscalYear' }]
        }]
        
      
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key cast( belnr as farp_belnr_d )         as AccountingDocument,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key gjahr                                 as FiscalYear,
  key cast( buzei as farp_buzei   )         as AccountingDocumentItem,

      @ObjectModel.foreignKey.association: '_FiscalYearVariant'
      _CompanyCode.FiscalYearVariant        as FiscalYearVariant,
      cast( augdt as farp_augdt )           as ClearingDate,
      cast( augcp as fis_augcp  )           as ClearingCreationDate,
      cast( augbl as farp_augbl )           as ClearingAccountingDocument,
      cast( bschl as farp_bschl )           as PostingKey,
      cast( koart as farp_koart )           as FinancialAccountType,
      cast( umskz as fac_umskz )            as SpecialGLCode,
      cast( umsks as farp_umsks )           as SpecialGLTransactionType,
      zumsk                                 as TargetSpecialGLCode,
      cast( shkzg as fis_shkzg )            as DebitCreditCode,
      cast( gsber as fis_rbusa )            as BusinessArea,
      cast( pargb as fis_pargb )            as PartnerBusinessArea,
      tax_country                           as TaxCountry,
      cast( mwskz as farp_mwskz )           as TaxCode,
      cast( qsskz as fac_qsskz )            as WithholdingTaxCode,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      cast( dmbtr_shl as fis_hsl )          as AmountInCompanyCodeCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      //    cast( wrbtr  as FAC_WRBTR  )        as AmountInTransactionCurrency,

      wrbtr_shl                             as AmountInTransactionCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
      //    cast( pswbt  as FARP_PSWBT )        as AmountInBalanceTransacCrcy,

      pswbt_shl                             as AmountInBalanceTransacCrcy,
      @Semantics.currencyCode: true
      cast( pswsl  as farp_pswsl )          as BalanceTransactionCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      mwsts_shl                             as TaxAmountInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      wmwst_shl                             as TaxAmount,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      fwbas_shl                             as TaxBaseAmountInTransCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      //    cast( hwbas as FAC_HWBAS )          as TaxBaseAmountInCoCodeCrcy,

      hwbas_shl                             as TaxBaseAmountInCoCodeCrcy,
      mwart                                 as TaxType,
      txgrp                                 as TaxItemGroup,
      ktosl                                 as TransactionTypeDetermination,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      //    cast( qsshb as FAC_QSSHB )          as WithholdingTaxBaseAmount,

      qsshb_shl                             as WithholdingTaxBaseAmount,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      bdiff_shl                             as ValuationDiffAmtInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode:'AdditionalCurrency1'
      bdif2_shl                             as ValuationDiffAmtInAddlCrcy1,
      valut                                 as ValueDate,
      cast( zuonr as fis_zuonr )            as AssignmentReference,
      cast( sgtxt as farp_sgtxt )           as DocumentItemText,
      vbund                                 as PartnerCompany,
      cast( bewar as fis_rmvct )            as FinancialTransactionType,
      altkt                                 as CorporateGroupAccount,
      fdlev                                 as PlanningLevel,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      fdwbt_shl                             as PlannedAmtInTransactionCrcy,
      kokrs                                 as ControllingArea,
      kostl                                 as CostCenter,
//      projn                                 as WBSElementInternalID,

      cast( projk as fis_wbsint_no_conv preserving type ) as WBSElementInternalID,
      aufnr                                 as OrderID,
      vbeln                                 as BillingDocument,
      vbel2                                 as SalesDocument,
      posn2                                 as SalesDocumentItem,
      eten2                                 as ScheduleLine,
      cast( anln1 as fis_anln1 )            as MasterFixedAsset,
      cast( anln2 as fis_anln2 )            as FixedAsset,
      cast( anbwa as fac_anbwa )            as AssetTransactionType,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    'PersonnelNumber'
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  'PersonnelNumber'
      pernr                                 as Employee,
      pernr                                 as PersonnelNumber,
      cast( xumsw as farp_xumsw )           as IsSalesRelated,
      xkres                                 as LineItemDisplayIsEnabled,
      xopvw                                 as IsOpenItemManaged,
      xcpdd                                 as AddressAndBankIsSetManually,
      xauto                                 as IsAutomaticallyCreated,
      xzahl                                 as IsUsedInPaymentTransaction,
      cast( hkont as fis_racct  )           as GLAccount,
      cast( kunnr as fis_kunnr  )           as Debtor,
      cast( lifnr as fis_lifnr  )           as Creditor,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    'BranchAccount'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'BranchAccount'
      cast( filkd as farp_filkd )           as Branch,
      cast( filkd as farp_filkd )           as BranchAccount,
      xbilk                                 as IsBalanceSheetAccount,
      gvtyp                                 as ProfitLossAccountType,
      cast( hzuon as fins_hzuon )           as SpecialGLAccountAssignment,
      zfbdt                                 as DueCalculationBaseDate,
      cast( zterm as farp_dzterm )          as PaymentTerms,
      cast( zbd1t as farp_dzbd1t )          as CashDiscount1Days,
      cast( zbd2t as farp_dzbd2t )          as CashDiscount2Days,
      cast( zbd3t as farp_dzbd3t )          as NetPaymentDays,
      zbd1p                                 as CashDiscount1Percent,
      zbd2p                                 as CashDiscount2Percent,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      //    cast( skfbt as FAC_SKFBT )          as CashDiscountBaseAmount,

      skfbt_shl                             as CashDiscountBaseAmount,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      sknto_shl                             as CashDiscountAmtInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      wskto_shl                             as CashDiscountAmount,
      cast( zlsch as farp_schzw_bseg )      as PaymentMethod,
      cast( zlspr as farp_dzlspr )          as PaymentBlockingReason,
      cast( zbfix as farp_dzbfix )          as FixedCashDiscount,
      hbkid                                 as HouseBank,
      mwsk1                                 as TaxDistributionCode1,
      mwsk2                                 as TaxDistributionCode2,
      mwsk3                                 as TaxDistributionCode3,
      cast( rebzg as farp_rebzg )           as InvoiceReference,
      rebzj                                 as InvoiceReferenceFiscalYear,
      cast( rebzz as fins_rebzz )           as InvoiceItemReference,
      cast( rebzt as farp_rebzt )           as FollowOnDocumentType,
      cast( lzbkz as fac_lzbkz )            as StateCentralBankPaymentReason,
      landl                                 as SupplyingCountry,
      cast( samnr as farp_samnr )           as InvoiceList,
      abper                                 as SettlementFiscalYearPeriod,
      cast( wverw as farp_wverw )           as BillOfExchangeUsage,
      cast( mschl as farp_mschl )           as DunningKey,
      //    cast( mansp as FARP_MANSP  )        as DunningBlockingReasonCode, //FieldGroup: DunningGroup

      cast( mansp as farp_mansp  )          as DunningBlockingReason, //FieldGroup: DunningGroup

      cast( madat as farp_madat )           as LastDunningDate, //FieldGroup: DunningGroup

      cast( manst as farp_mahns_d )         as DunningLevel,
      cast( maber as farp_maber )           as DunningArea,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'

      qbshb_shl                             as WithholdingTaxAmount,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      //    cast( qsfbt as FAC_QSFBT )          as WithholdingTaxExemptionAmt,

      qsfbt_shl                             as WithholdingTaxExemptionAmt,
      matnr                                 as Material,
      werks                                 as Plant,
      @DefaultAggregation:#SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      menge                                 as Quantity,
      @Semantics.unitOfMeasure: true
      meins                                 as BaseUnit,
      @DefaultAggregation:#SUM
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      erfmg                                 as QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      erfme                                 as EntryUnit,
      @DefaultAggregation:#SUM
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
      bpmng                                 as PurchaseOrderQty,
      @Semantics.unitOfMeasure: true
      bprme                                 as PurchaseOrderPriceUnit,
      cast( ebeln as farp_ebeln )           as PurchasingDocument,
      cast( ebelp as farp_ebelp )           as PurchasingDocumentItem,
      zekkn                                 as AccountAssignmentNumber,
      elikz                                 as IsCompletelyDelivered,
      vprsv                                 as MaterialPriceControl,
      peinh                                 as MaterialPriceUnitQty,
      bwkey                                 as ValuationArea,
      bwtar                                 as InventoryValuationType,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      rewrt_shl                             as InvoiceAmtInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      rewwr_shl                             as InvoiceAmountInFrgnCurrency,
      cast( stceg as farp_stceg )           as VATRegistration,
      egbld                                 as DelivOfGoodsDestCountry,
      eglld                                 as DelivOfGoodsOriginCountry,
      cast( rstgr as farp_rstgr )           as PaymentDifferenceReason,
      prctr                                 as ProfitCenter,
      vname                                 as JointVenture,
      recid                                 as JointVentureCostRecoveryCode,
      egrup                                 as JointVentureEquityGroup,
      vertt                                 as TreasuryContractType,
      vertn                                 as AssetContract,
      cast( vbewa as farp_sbewart  )        as CashFlowType,
      cast( txjcd as farp_txjcd )           as TaxJurisdiction,
      cast( imkey as farp_imkey )           as RealEstateObject,
      dabrz                                 as SettlementReferenceDate,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor:    'CommitmentItemShortID'
      @VDM.lifecycle.status:    #DEPRECATED
      @VDM.lifecycle.successor: 'CommitmentItemShortID'
      fipos                                              as  CommitmentItem,
      cast( fipos as fis_fipos_shortid preserving type ) as  CommitmentItemShortID,
      kstrg                                 as CostObject,
      nplnr                                 as ProjectNetwork,
      projk                                 as WBSElement,
      paobjnr                               as ProfitabilitySegment,
      etype                                 as JointVentureEquityType,
      xegdr                                 as IsEUTriangularDeal,
      hrkft                                 as CostOriginGroup,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      cast( dmbe2_shl  as dmbe2_farp  )     as AmountInAdditionalCurrency1,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      cast( dmbe3_shl   as dmbe3_farp )     as AmountInAdditionalCurrency2,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'FunctionalCurrency'
      fcsl_shl                              as AmountInFunctionalCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      bdif3_shl                             as ValuationDiffAmtInAddlCrcy2,
      cast( xragl as farp_xragl )           as ClearingIsReversed,
      cast( uzawe as farp_uzawe )           as PaymentMethodSupplement,
      cast( lokkt as fis_altkt_skb1 )       as AlternativeGLAccount,
      cast( fistl as farp_fistl )           as FundsCenter,
      geber                                 as Fund,
      pprct                                 as PartnerProfitCenter,
      cast( xref1 as farp_xref1 )           as Reference1IDByBusinessPartner,
      cast( xref2 as farp_xref2 )           as Reference2IDByBusinessPartner,
      //    cast( xnegp as FARP_XNEGP )         as IsNegativePosting,

      cast( rfzei as farp_rfzei_cc )        as PaymentCardItem,
      cast( ccbtc as farp_ccbtc )           as PaymentCardPaymentSettlement,

      kkber                                 as CreditControlArea,
      empfb                                 as AlternativePayeePayer,
      xref3                                 as Reference3IDByBusinessPartner,
      cast( dtws1 as farp_dtat16 )          as DataExchangeInstruction1,
      cast( dtws2 as farp_dtat17 )          as DataExchangeInstruction2,
      cast( dtws3 as farp_dtat18 )          as DataExchangeInstruction3,
      cast( dtws4 as farp_dtat19 )          as DataExchangeInstruction4,
      grirg                                 as Region,
      cast( xpypr as farp_xpypr )           as HasPaymentOrder,
      cast( kidno as farp_kidno )           as PaymentReference,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      absbt_shl                             as HedgedAmount,
      txdat                                 as TaxDeterminationDate,
      agzei                                 as ClearingItem,
      @Semantics.currencyCode: true
      cast( pycur as farp_pycur )           as PaymentCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'PaymentCurrency'
      //    cast( pyamt as FAC_PYAMT  )           as AmountInPaymentCurrency,

      pyamt_shl                             as AmountInPaymentCurrency,
      cast( bupla as farp_bupla )           as BusinessPlace,
      secco                                 as TaxSection,
      lstar                                 as CostCtrActivityType,
      cast( cession_kz as farp_cession_kz ) as AccountsReceivableIsPledged,
      prznr                                 as BusinessProcess,
      grant_nbr                             as GrantID,
      fkber_long                            as FunctionalArea,
      gmvkz                                 as CustomerIsInExecution,
      auggj                                 as ClearingDocFiscalYear,
      segment                               as Segment,
      psegment                              as PartnerSegment,
      pfkber                                as PartnerFunctionalArea,
      hktid                                 as HouseBankAccount,
      kstar                                 as CostElement,
      cast( awtyp as fis_awtyp )            as ReferenceDocumentType,
      awkey                                 as OriginalReferenceDocument,
      awsys                                 as ReferenceDocumentLogicalSystem,
      h_monat                               as FiscalPeriod,
      cast( h_bstat as farp_bstat_d )       as AccountingDocumentCategory,
      h_budat                               as PostingDate,
      h_bldat                               as DocumentDate,
      @Semantics.currencyCode: true
      h_waers                               as TransactionCurrency,
      cast( h_blart as farp_blart)          as AccountingDocumentType,
      @Semantics.currencyCode: true
      cast( h_hwaer as fis_hwaer )          as CompanyCodeCurrency,
      @Semantics.currencyCode: true
      cast( h_hwae2 as fis_hwae2 )          as AdditionalCurrency1,
      @Semantics.currencyCode: true
      cast( h_hwae3 as fis_hwae3 )          as AdditionalCurrency2,
      @Semantics.currencyCode: true
      cast( rfccur as fins_currf )          as FunctionalCurrency,
      cast( netdt as farp_netdt )           as NetDueDate,
      cast( sk1dt as farp_sk1dt )           as CashDiscount1DueDate,
      sk2dt                                 as CashDiscount2DueDate,
      gkont                                 as OffsettingAccount,
      gkart                                 as OffsettingAccountType,