P_APLineItem_4

@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity P_APLineItem_4
  as
  //  posted credit items

  select from I_ReceivablesPayablesItem
{
  key I_ReceivablesPayablesItem.CompanyCode                                   as CompanyCode,
  key I_ReceivablesPayablesItem.AccountingDocument                            as AccountingDocument,
  key I_ReceivablesPayablesItem.FiscalYear                                    as FiscalYear,
  key I_ReceivablesPayablesItem.AccountingDocumentItem                        as AccountingDocumentItem,

      _JournalEntry.AccountingDocCreatedByUser                                as AccountingDocCreatedByUser,
      I_ReceivablesPayablesItem.AccountingDocumentCategory                    as AccountingDocumentCategory,
      I_ReceivablesPayablesItem._JournalEntry.AccountingDocumentCreationDate  as AccountingDocumentCreationDate,
      I_ReceivablesPayablesItem.AccountingDocumentType                        as AccountingDocumentType,
      I_ReceivablesPayablesItem.AccountsReceivableIsPledged                   as AccountsReceivableIsPledged,
      I_ReceivablesPayablesItem.AdditionalCurrency1                           as AdditionalCurrency1,
      I_ReceivablesPayablesItem.AdditionalCurrency2                           as AdditionalCurrency2,
      I_ReceivablesPayablesItem.AlternativeGLAccount                          as AlternativeGLAccount,
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      I_ReceivablesPayablesItem.AmountInAdditionalCurrency1                   as AmountInAdditionalCurrency1,
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      I_ReceivablesPayablesItem.AmountInAdditionalCurrency2                   as AmountInAdditionalCurrency2,
      @Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
      I_ReceivablesPayablesItem.AmountInBalanceTransacCrcy                    as AmountInBalanceTransacCrcy,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      I_ReceivablesPayablesItem.AmountInCompanyCodeCurrency                   as AmountInCompanyCodeCurrency,
      @Semantics.amount.currencyCode: 'FunctionalCurrency'
      I_ReceivablesPayablesItem.AmountInFunctionalCurrency                    as AmountInFunctionalCurrency,
      @Semantics.amount.currencyCode: 'PaymentCurrency'
      I_ReceivablesPayablesItem.AmountInPaymentCurrency                       as AmountInPaymentCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_ReceivablesPayablesItem.AmountInTransactionCurrency                   as AmountInTransactionCurrency,
      I_ReceivablesPayablesItem.AssetContract                                 as AssetContract,
      I_ReceivablesPayablesItem.AssignmentReference                           as AssignmentReference,
      I_ReceivablesPayablesItem.BalanceTransactionCurrency                    as BalanceTransactionCurrency,
      I_ReceivablesPayablesItem.BillingDocument                               as BillingDocument,
      I_ReceivablesPayablesItem.BillOfExchangeUsage                           as BillOfExchangeUsage,
      I_ReceivablesPayablesItem.BranchAccount                                 as Branch,
      I_ReceivablesPayablesItem.BusinessArea                                  as BusinessArea,
      I_ReceivablesPayablesItem.BusinessPlace                                 as BusinessPlace,
      I_ReceivablesPayablesItem.CashDiscount1Days                             as CashDiscount1Days,
      I_ReceivablesPayablesItem.CashDiscount1DueDate                          as CashDiscount1DueDate,
      I_ReceivablesPayablesItem.CashDiscount1Percent                          as CashDiscount1Percent,
      I_ReceivablesPayablesItem.CashDiscount2Days                             as CashDiscount2Days,
      I_ReceivablesPayablesItem.CashDiscount2Percent                          as CashDiscount2Percent,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_ReceivablesPayablesItem.CashDiscountAmount                            as CashDiscountAmount,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      I_ReceivablesPayablesItem.CashDiscountAmtInCoCodeCrcy                   as CashDiscountAmtInCoCodeCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_ReceivablesPayablesItem.CashDiscountBaseAmount                        as CashDiscountBaseAmount,
      I_ReceivablesPayablesItem.CashFlowType                                  as CashFlowType,
      I_ReceivablesPayablesItem.ClearingAccountingDocument                    as ClearingAccountingDocument,
      I_ReceivablesPayablesItem.ClearingDate                                  as ClearingDate,
      I_ReceivablesPayablesItem.ClearingDocFiscalYear                         as ClearingDocFiscalYear,
      I_ReceivablesPayablesItem.ClearingIsReversed                            as ClearingIsReversed,
      I_ReceivablesPayablesItem.CompanyCodeCurrency                           as CompanyCodeCurrency,
      I_ReceivablesPayablesItem.CostCenter                                    as CostCenter,
      I_ReceivablesPayablesItem.CreditControlArea                             as CreditControlArea,
      I_ReceivablesPayablesItem.AlternativePayeePayer                         as PayableAlternativePayee,
      I_ReceivablesPayablesItem.DataExchangeInstruction1                      as DataExchangeInstruction1,
      I_ReceivablesPayablesItem.DataExchangeInstruction2                      as DataExchangeInstruction2,
      I_ReceivablesPayablesItem.DataExchangeInstruction3                      as DataExchangeInstruction3,
      I_ReceivablesPayablesItem.DataExchangeInstruction4                      as DataExchangeInstruction4,
      I_ReceivablesPayablesItem.DebitCreditCode                               as DebitCreditCode,
      I_ReceivablesPayablesItem.DocumentDate                                  as DocumentDate,
      ' '                                                                     as DocumentIsArchived,
      I_ReceivablesPayablesItem.DocumentItemText                              as DocumentItemText,
      I_ReceivablesPayablesItem._JournalEntry.DocumentReferenceID             as DocumentReferenceID,
      I_ReceivablesPayablesItem.DueCalculationBaseDate                        as DueCalculationBaseDate,
      I_ReceivablesPayablesItem.DunningArea                                   as DunningArea,
      I_ReceivablesPayablesItem.DunningBlockingReason                         as DunningBlockingReason,
      I_ReceivablesPayablesItem.DunningLevel                                  as DunningLevel,
      I_ReceivablesPayablesItem.FinancialAccountType                          as FinancialAccountType,
      I_ReceivablesPayablesItem.FiscalPeriod                                  as FiscalPeriod,
      I_ReceivablesPayablesItem.FixedAsset                                    as FixedAsset,
      I_ReceivablesPayablesItem.FixedCashDiscount                             as FixedCashDiscount,
      I_ReceivablesPayablesItem.FollowOnDocumentType                          as FollowOnDocumentType,
      I_ReceivablesPayablesItem.StateCentralBankPaymentReason                 as StateCentralBankPaymentReason,
      I_ReceivablesPayablesItem.SupplyingCountry                              as SupplyingCountry,
      I_ReceivablesPayablesItem.FunctionalCurrency                            as FunctionalCurrency,
      I_ReceivablesPayablesItem.FundsCenter                                   as FundsCenter,
      I_ReceivablesPayablesItem.GLAccount                                     as GLAccount,
      I_ReceivablesPayablesItem.HasPaymentOrder                               as HasPaymentOrder,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_ReceivablesPayablesItem.HedgedAmount                                  as HedgedAmount,
      I_ReceivablesPayablesItem.HouseBankAccount                              as HouseBankAccount,
      I_ReceivablesPayablesItem.InvoiceList                                   as InvoiceList,
      I_ReceivablesPayablesItem.InvoiceReference                              as InvoiceReference,
      I_ReceivablesPayablesItem.IsSalesRelated                                as IsSalesRelated,
      I_ReceivablesPayablesItem.IsUsedInPaymentTransaction                    as IsUsedInPaymentTransaction,

      //      Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.

      //      The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.

      @Consumption.hidden: true
      cast ( 'BSEG_CREDIT_SIDE_BRANCH' as char30 )                            as ITEM_TYPE_BRANCH,
      I_ReceivablesPayablesItem.LastDunningDate                               as LastDunningDate,
      I_ReceivablesPayablesItem.MasterFixedAsset                              as MasterFixedAsset,
      I_ReceivablesPayablesItem.DunningKey                                    as DunningKey,
      I_ReceivablesPayablesItem.NetDueDate                                    as NetDueDate,
      I_ReceivablesPayablesItem.NetPaymentDays                                as NetPaymentDays,
      I_ReceivablesPayablesItem.OffsettingAccount                             as OffsettingAccount,
      I_ReceivablesPayablesItem.OffsettingAccountType                         as OffsettingAccountType,
      I_ReceivablesPayablesItem.OrderID                                       as OrderID,
      I_ReceivablesPayablesItem.PartnerCompany                                as PartnerCompany,
      I_ReceivablesPayablesItem.PaymentBlockingReason                         as PaymentBlockingReason,
      I_ReceivablesPayablesItem.PaymentCardItem                               as PaymentCardItem,
      I_ReceivablesPayablesItem.PaymentCardPaymentSettlement                  as PaymentCardPaymentSettlement,
      I_ReceivablesPayablesItem.PaymentCurrency                               as PaymentCurrency,
      I_ReceivablesPayablesItem.PaymentDifferenceReason                       as PaymentDifferenceReason,
      I_ReceivablesPayablesItem.PaymentMethod                                 as PaymentMethod,
      I_ReceivablesPayablesItem.PaymentMethodSupplement                       as PaymentMethodSupplement,
      I_ReceivablesPayablesItem.PaymentReference                              as PaymentReference,
      I_ReceivablesPayablesItem.PaymentTerms                                  as PaymentTerms,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_ReceivablesPayablesItem.PlannedAmtInTransactionCrcy                   as PlannedAmtInTransactionCrcy,
      I_ReceivablesPayablesItem.Plant                                         as Plant,
      I_ReceivablesPayablesItem.PostingDate                                   as PostingDate,
      I_ReceivablesPayablesItem.PostingKey                                    as PostingKey,
      I_ReceivablesPayablesItem.ProfitCenter                                  as ProfitCenter,
      I_ReceivablesPayablesItem.PurchasingDocument                            as PurchasingDocument,
      I_ReceivablesPayablesItem.PurchasingDocumentItem                        as PurchasingDocumentItem,
      I_ReceivablesPayablesItem.RealEstateObject                              as RealEstateObject,
      I_ReceivablesPayablesItem.Reference1IDByBusinessPartner                 as Reference1IDByBusinessPartner,
      I_ReceivablesPayablesItem.Reference2IDByBusinessPartner                 as Reference2IDByBusinessPartner,
      I_ReceivablesPayablesItem.Reference3IDByBusinessPartner                 as Reference3IDByBusinessPartner,
      I_ReceivablesPayablesItem.SalesDocument                                 as SalesDocument,
      I_ReceivablesPayablesItem.SalesDocumentItem                             as SalesDocumentItem,
      I_ReceivablesPayablesItem.ScheduleLine                                  as ScheduleLine,
      I_ReceivablesPayablesItem.SettlementReferenceDate                       as SettlementReferenceDate,
      ''                                                                      as SourceCompanyCode,
      I_ReceivablesPayablesItem.SpecialGLCode                                 as SpecialGLCode,
      I_ReceivablesPayablesItem.SpecialGLTransactionType                      as SpecialGLTransactionType,
      I_ReceivablesPayablesItem.Creditor                                      as Supplier,
      I_ReceivablesPayablesItem._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
      I_ReceivablesPayablesItem.TaxCode                                       as TaxCode,
      I_ReceivablesPayablesItem.TaxCountry                                    as TaxCountry,
      _JournalEntry.TaxReportingDate                                          as TaxReportingDate,
      I_ReceivablesPayablesItem.TaxSection                                    as TaxSection,
      I_ReceivablesPayablesItem.TransactionCurrency                           as TransactionCurrency,
      I_ReceivablesPayablesItem.TreasuryContractType                          as TreasuryContractType,
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      I_ReceivablesPayablesItem.ValuationDiffAmtInAddlCrcy1                   as ValuationDiffAmtInAddlCrcy1,
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      I_ReceivablesPayablesItem.ValuationDiffAmtInAddlCrcy2                   as ValuationDiffAmtInAddlCrcy2,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      I_ReceivablesPayablesItem.ValuationDiffAmtInCoCodeCrcy                  as ValuationDiffAmtInCoCodeCrcy,
      I_ReceivablesPayablesItem.ValueDate                                     as ValueDate,
      I_ReceivablesPayablesItem.WBSElement                                    as WBSElement,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_ReceivablesPayablesItem.WithholdingTaxAmount                          as WithholdingTaxAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_ReceivablesPayablesItem.WithholdingTaxBaseAmount                      as WithholdingTaxBaseAmount,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_ReceivablesPayablesItem.WithholdingTaxExemptionAmt                    as WithholdingTaxExemptionAmt,
      I_ReceivablesPayablesItem.BPBankAccountInternalID                       as BPBankAccountInternalID,
      I_ReceivablesPayablesItem.HouseBank                                     as HouseBank,
      I_ReceivablesPayablesItem.Debtor                                        as Debtor,
      cast( _JournalEntry.AdditionalCurrency1Role as fis_adl1_currole preserving type ) as AdditionalCurrency1Role,
      cast( _JournalEntry.AdditionalCurrency2Role as fis_adl2_currole preserving type ) as AdditionalCurrency2Role,
      I_ReceivablesPayablesItem.BranchCode                                    as BranchCode,
      I_ReceivablesPayablesItem.ReferenceDocumentType                         as ReferenceDocumentType,
      I_ReceivablesPayablesItem.OriginalReferenceDocument                     as OriginalReferenceDocument,
      I_ReceivablesPayablesItem.ReferenceDocumentLogicalSystem                as ReferenceDocumentLogicalSystem,
      I_ReceivablesPayablesItem.PaymentReason                                 as PaymentReason,
      I_ReceivablesPayablesItem.BillOfExchangeUsageDocument                   as BillOfExchangeUsageDocument,
      I_ReceivablesPayablesItem.BOEUsageDocFiscalYear                         as BOEUsageDocFiscalYear,
      I_ReceivablesPayablesItem.BOEUsageDocLineItem                           as BOEUsageDocLineItem,
      I_ReceivablesPayablesItem.JointVenture                                  as  JointVenture,
      I_ReceivablesPayablesItem.JointVentureCostRecoveryCode                  as  JointVentureCostRecoveryCode,
      I_ReceivablesPayablesItem.JointVentureBillingType                       as  JointVentureBillingType,
      I_ReceivablesPayablesItem.JointVentureEquityGroup                       as  JointVentureCorporateEquityGrp
}

where
      FinancialAccountType     = 'K'
  and not(
    AccountingDocumentCategory = 'D'
  ) //D = Recurring entry document

  and not(
    AccountingDocumentCategory = 'M'
  ) //M = Sample document


union all
//  posted debit items of mixed accounts

select from  I_ReceivablesPayablesItem

//  inner join P_APLineItem_5 as MixAcc1 on I_ReceivablesPayablesItem.Debtor = MixAcc1.Debtor

  inner join fap_mult_mix_acc as MixAcc1 on  I_ReceivablesPayablesItem.Debtor      = MixAcc1.debtor
                                         and I_ReceivablesPayablesItem.CompanyCode = MixAcc1.companycode
{
  key I_ReceivablesPayablesItem.CompanyCode                                   as  CompanyCode,
  key I_ReceivablesPayablesItem.AccountingDocument                            as  AccountingDocument,
  key I_ReceivablesPayablesItem.FiscalYear                                    as  FiscalYear,
  key I_ReceivablesPayablesItem.AccountingDocumentItem                        as  AccountingDocumentItem,

      I_ReceivablesPayablesItem._JournalEntry.AccountingDocCreatedByUser      as  AccountingDocCreatedByUser,
      I_ReceivablesPayablesItem.AccountingDocumentCategory                    as  AccountingDocumentCategory,
      I_ReceivablesPayablesItem._JournalEntry.AccountingDocumentCreationDate  as  AccountingDocumentCreationDate,
      I_ReceivablesPayablesItem.AccountingDocumentType                        as  AccountingDocumentType,
      I_ReceivablesPayablesItem.AccountsReceivableIsPledged                   as  AccountsReceivableIsPledged,
      I_ReceivablesPayablesItem.AdditionalCurrency1                           as  AdditionalCurrency1,
      I_ReceivablesPayablesItem.AdditionalCurrency2                           as  AdditionalCurrency2,
      I_ReceivablesPayablesItem.AlternativeGLAccount                          as  AlternativeGLAccount,      
      I_ReceivablesPayablesItem.AmountInAdditionalCurrency1                   as  AmountInAdditionalCurrency1,
      I_ReceivablesPayablesItem.AmountInAdditionalCurrency2                   as  AmountInAdditionalCurrency2,
      I_ReceivablesPayablesItem.AmountInBalanceTransacCrcy                    as  AmountInBalanceTransacCrcy,
      I_ReceivablesPayablesItem.AmountInCompanyCodeCurrency                   as  AmountInCompanyCodeCurrency,
      I_ReceivablesPayablesItem.AmountInFunctionalCurrency                    as  AmountInFunctionalCurrency,
      I_ReceivablesPayablesItem.AmountInPaymentCurrency                       as  AmountInPaymentCurrency,
      I_ReceivablesPayablesItem.AmountInTransactionCurrency                   as  AmountInTransactionCurrency,
      I_ReceivablesPayablesItem.AssetContract                                 as  AssetContract,
      I_ReceivablesPayablesItem.AssignmentReference                           as  AssignmentReference,
      I_ReceivablesPayablesItem.BalanceTransactionCurrency                    as  BalanceTransactionCurrency,
      I_ReceivablesPayablesItem.BillingDocument                               as  BillingDocument,
      I_ReceivablesPayablesItem.BillOfExchangeUsage                           as  BillOfExchangeUsage,
      I_ReceivablesPayablesItem.BranchAccount                                 as  Branch,
      I_ReceivablesPayablesItem.BusinessArea                                  as  BusinessArea,
      I_ReceivablesPayablesItem.BusinessPlace                                 as  BusinessPlace,
      I_ReceivablesPayablesItem.CashDiscount1Days                             as  CashDiscount1Days,
      I_ReceivablesPayablesItem.CashDiscount1DueDate                          as  CashDiscount1DueDate,
      I_ReceivablesPayablesItem.CashDiscount1Percent                          as  CashDiscount1Percent,
      I_ReceivablesPayablesItem.CashDiscount2Days                             as  CashDiscount2Days,
      I_ReceivablesPayablesItem.CashDiscount2Percent                          as  CashDiscount2Percent,
      I_ReceivablesPayablesItem.CashDiscountAmount                            as  CashDiscountAmount,
      I_ReceivablesPayablesItem.CashDiscountAmtInCoCodeCrcy                   as  CashDiscountAmtInCoCodeCrcy,
      I_ReceivablesPayablesItem.CashDiscountBaseAmount                        as  CashDiscountBaseAmount,
      I_ReceivablesPayablesItem.CashFlowType                                  as  CashFlowType,
      I_ReceivablesPayablesItem.ClearingAccountingDocument                    as  ClearingAccountingDocument,
      I_ReceivablesPayablesItem.ClearingDate                                  as  ClearingDate,
      I_ReceivablesPayablesItem.ClearingDocFiscalYear                         as  ClearingDocFiscalYear,
      I_ReceivablesPayablesItem.ClearingIsReversed                            as  ClearingIsReversed,
      I_ReceivablesPayablesItem.CompanyCodeCurrency                           as  CompanyCodeCurrency,
      I_ReceivablesPayablesItem.CostCenter                                    as  CostCenter,
      I_ReceivablesPayablesItem.CreditControlArea                             as  CreditControlArea,
      I_ReceivablesPayablesItem.AlternativePayeePayer                         as  PayableAlternativePayee,
      I_ReceivablesPayablesItem.DataExchangeInstruction1                      as  DataExchangeInstruction1,
      I_ReceivablesPayablesItem.DataExchangeInstruction2                      as  DataExchangeInstruction2,
      I_ReceivablesPayablesItem.DataExchangeInstruction3                      as  DataExchangeInstruction3,
      I_ReceivablesPayablesItem.DataExchangeInstruction4                      as  DataExchangeInstruction4,
      I_ReceivablesPayablesItem.DebitCreditCode                               as  DebitCreditCode,
      I_ReceivablesPayablesItem.DocumentDate                                  as  DocumentDate,
      ' '                                                                     as  DocumentIsArchived,
      I_ReceivablesPayablesItem.DocumentItemText                              as  DocumentItemText,
      I_ReceivablesPayablesItem._JournalEntry.DocumentReferenceID             as  DocumentReferenceID,
      I_ReceivablesPayablesItem.DueCalculationBaseDate                        as  DueCalculationBaseDate,
      I_ReceivablesPayablesItem.DunningArea                                   as  DunningArea,
      I_ReceivablesPayablesItem.DunningBlockingReason                         as  DunningBlockingReason,
      I_ReceivablesPayablesItem.DunningLevel                                  as  DunningLevel,
      I_ReceivablesPayablesItem.FinancialAccountType                          as  FinancialAccountType,
      I_ReceivablesPayablesItem.FiscalPeriod                                  as  FiscalPeriod,
      I_ReceivablesPayablesItem.FixedAsset                                    as  FixedAsset,
      I_ReceivablesPayablesItem.FixedCashDiscount                             as  FixedCashDiscount,
      I_ReceivablesPayablesItem.FollowOnDocumentType                          as  FollowOnDocumentType,
      I_ReceivablesPayablesItem.StateCentralBankPaymentReason                 as  StateCentralBankPaymentReason,
      I_ReceivablesPayablesItem.SupplyingCountry                              as  SupplyingCountry,
      I_ReceivablesPayablesItem.FunctionalCurrency                            as  FunctionalCurrency,
      I_ReceivablesPayablesItem.FundsCenter                                   as  FundsCenter,
      I_ReceivablesPayablesItem.GLAccount                                     as  GLAccount,
      I_ReceivablesPayablesItem.HasPaymentOrder                               as  HasPaymentOrder,
      I_ReceivablesPayablesItem.HedgedAmount                                  as  HedgedAmount,
      I_ReceivablesPayablesItem.HouseBankAccount                              as  HouseBankAccount,
      I_ReceivablesPayablesItem.InvoiceList                                   as  InvoiceList,
      I_ReceivablesPayablesItem.InvoiceReference                              as  InvoiceReference,
      I_ReceivablesPayablesItem.IsSalesRelated                                as  IsSalesRelated,
      I_ReceivablesPayablesItem.IsUsedInPaymentTransaction                    as  IsUsedInPaymentTransaction,

      //      Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.

      //      The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.

      'BSEG_DEBIT_SIDE_BRANCH'                                                as  ITEM_TYPE_BRANCH,
      I_ReceivablesPayablesItem.LastDunningDate                               as  LastDunningDate,
      I_ReceivablesPayablesItem.MasterFixedAsset                              as  MasterFixedAsset,
      I_ReceivablesPayablesItem.DunningKey                                    as  DunningKey,
      I_ReceivablesPayablesItem.NetDueDate                                    as  NetDueDate,
      I_ReceivablesPayablesItem.NetPaymentDays                                as  NetPaymentDays,
      I_ReceivablesPayablesItem.OffsettingAccount                             as  OffsettingAccount,
      I_ReceivablesPayablesItem.OffsettingAccountType                         as  OffsettingAccountType,
      I_ReceivablesPayablesItem.OrderID                                       as  OrderID,
      I_ReceivablesPayablesItem.PartnerCompany                                as  PartnerCompany,
      I_ReceivablesPayablesItem.PaymentBlockingReason                         as  PaymentBlockingReason,
      I_ReceivablesPayablesItem.PaymentCardItem                               as  PaymentCardItem,
      I_ReceivablesPayablesItem.PaymentCardPaymentSettlement                  as  PaymentCardPaymentSettlement,
      I_ReceivablesPayablesItem.PaymentCurrency                               as  PaymentCurrency,
      I_ReceivablesPayablesItem.PaymentDifferenceReason                       as  PaymentDifferenceReason,
      I_ReceivablesPayablesItem.PaymentMethod                                 as  PaymentMethod,
      I_ReceivablesPayablesItem.PaymentMethodSupplement                       as  PaymentMethodSupplement,
      I_ReceivablesPayablesItem.PaymentReference                              as  PaymentReference,
      I_ReceivablesPayablesItem.PaymentTerms                                  as  PaymentTerms,
      I_ReceivablesPayablesItem.PlannedAmtInTransactionCrcy                   as  PlannedAmtInTransactionCrcy,
      I_ReceivablesPayablesItem.Plant                                         as  Plant,
      I_ReceivablesPayablesItem.PostingDate                                   as  PostingDate,
      I_ReceivablesPayablesItem.PostingKey                                    as  PostingKey,
      I_ReceivablesPayablesItem.ProfitCenter                                  as  ProfitCenter,
      I_ReceivablesPayablesItem.PurchasingDocument                            as  PurchasingDocument,
      I_ReceivablesPayablesItem.PurchasingDocumentItem                        as  PurchasingDocumentItem,
      I_ReceivablesPayablesItem.RealEstateObject                              as  RealEstateObject,
      I_ReceivablesPayablesItem.Reference1IDByBusinessPartner                 as  Reference1IDByBusinessPartner,
      I_ReceivablesPayablesItem.Reference2IDByBusinessPartner                 as  Reference2IDByBusinessPartner,
      I_ReceivablesPayablesItem.Reference3IDByBusinessPartner                 as  Reference3IDByBusinessPartner,
      I_ReceivablesPayablesItem.SalesDocument                                 as  SalesDocument,
      I_ReceivablesPayablesItem.SalesDocumentItem                             as  SalesDocumentItem,
      I_ReceivablesPayablesItem.ScheduleLine                                  as  ScheduleLine,
      I_ReceivablesPayablesItem.SettlementReferenceDate                       as  SettlementReferenceDate,
      ''                                                                      as  SourceCompanyCode,
      I_ReceivablesPayablesItem.SpecialGLCode                                 as  SpecialGLCode,
      I_ReceivablesPayablesItem.SpecialGLTransactionType                      as  SpecialGLTransactionType,
      MixAcc1.supplier                                                        as  Supplier,
      I_ReceivablesPayablesItem._CompanyCode._Country.TaxCalculationProcedure as  TaxCalculationProcedure,
      I_ReceivablesPayablesItem.TaxCode                                       as  TaxCode,
      I_ReceivablesPayablesItem.TaxCountry                                    as  TaxCountry,
      I_ReceivablesPayablesItem._JournalEntry.TaxReportingDate                as  TaxReportingDate,
      I_ReceivablesPayablesItem.TaxSection                                    as  TaxSection,
      I_ReceivablesPayablesItem.TransactionCurrency                           as  TransactionCurrency,
      I_ReceivablesPayablesItem.TreasuryContractType                          as  TreasuryContractType,
      I_ReceivablesPayablesItem.ValuationDiffAmtInAddlCrcy1                   as  ValuationDiffAmtInAddlCrcy1,
      I_ReceivablesPayablesItem.ValuationDiffAmtInAddlCrcy2                   as  ValuationDiffAmtInAddlCrcy2,
      I_ReceivablesPayablesItem.ValuationDiffAmtInCoCodeCrcy                  as  ValuationDiffAmtInCoCodeCrcy,
      I_ReceivablesPayablesItem.ValueDate                                     as  ValueDate,
      I_ReceivablesPayablesItem.WBSElement                                    as  WBSElement,
      I_ReceivablesPayablesItem.WithholdingTaxAmount                          as  WithholdingTaxAmount,
      I_ReceivablesPayablesItem.WithholdingTaxBaseAmount                      as  WithholdingTaxBaseAmount,
      I_ReceivablesPayablesItem.WithholdingTaxExemptionAmt                    as  WithholdingTaxExemptionAmt,
      I_ReceivablesPayablesItem.BPBankAccountInternalID                       as  BPBankAccountInternalID,
      I_ReceivablesPayablesItem.HouseBank                                     as  HouseBank,
      I_ReceivablesPayablesItem.Debtor                                        as  Debtor,
      cast( I_ReceivablesPayablesItem._JournalEntry.AdditionalCurrency1Role as fis_adl1_currole preserving type ) as AdditionalCurrency1Role,
      cast( I_ReceivablesPayablesItem._JournalEntry.AdditionalCurrency2Role as fis_adl2_currole preserving type ) as AdditionalCurrency2Role,
      I_ReceivablesPayablesItem.BranchCode                                    as BranchCode,
      I_ReceivablesPayablesItem.ReferenceDocumentType                         as ReferenceDocumentType,
      I_ReceivablesPayablesItem.OriginalReferenceDocument                     as OriginalReferenceDocument,
      I_ReceivablesPayablesItem.ReferenceDocumentLogicalSystem                as ReferenceDocumentLogicalSystem,
      I_ReceivablesPayablesItem.PaymentReason                                 as PaymentReason,
      I_ReceivablesPayablesItem.BillOfExchangeUsageDocument                   as BillOfExchangeUsageDocument,
      I_ReceivablesPayablesItem.BOEUsageDocFiscalYear                         as BOEUsageDocFiscalYear,
      I_ReceivablesPayablesItem.BOEUsageDocLineItem                           as BOEUsageDocLineItem,
      I_ReceivablesPayablesItem.JointVenture                                  as  JointVenture,
      I_ReceivablesPayablesItem.JointVentureCostRecoveryCode                  as  JointVentureCostRecoveryCode,
      I_ReceivablesPayablesItem.JointVentureBillingType                       as  JointVentureBillingType,
      I_ReceivablesPayablesItem.JointVentureEquityGroup                       as  JointVentureCorporateEquityGrp
}
where
  (
      I_ReceivablesPayablesItem.FinancialAccountType     = 'D'
  )
  and not(
    I_ReceivablesPayablesItem.AccountingDocumentCategory = 'D'
  )
  and not //D = Recurring entry document

(
    I_ReceivablesPayablesItem.AccountingDocumentCategory = 'M'
  )
  and MixAcc1.debtor != ''

union all
//  parked credit items

select from I_ParkedOplAcctgDocPyblsItem

{
  key I_ParkedOplAcctgDocPyblsItem.CompanyCode,
  key I_ParkedOplAcctgDocPyblsItem.SourceAccountingDocument                      as AccountingDocument,
  key I_ParkedOplAcctgDocPyblsItem.SourceFiscalYear                              as FiscalYear,
  key I_ParkedOplAcctgDocPyblsItem.SourceAccountingDocumentItem                  as AccountingDocumentItem,
    
      _ParkedOplAcctgDocument.AccountingDocCreatedByUser                         as AccountingDocCreatedByUser,
      _ParkedOplAcctgDocument.AccountingDocumentCategory                         as AccountingDocumentCategory,
      _ParkedOplAcctgDocument.AccountingDocumentCreationDate                     as AccountingDocumentCreationDate,
      _ParkedOplAcctgDocument.AccountingDocumentType                             as AccountingDocumentType,
      '  '                                                                       as AccountsReceivableIsPledged,
      I_ParkedOplAcctgDocPyblsItem.AdditionalCurrency1                           as AdditionalCurrency1,
      I_ParkedOplAcctgDocPyblsItem.AdditionalCurrency2                           as AdditionalCurrency2,
      ' '                                                                        as AlternativeGLAccount,
      I_ParkedOplAcctgDocPyblsItem.AmountInAdditionalCurrency1                   as AmountInAdditionalCurrency1,
      I_ParkedOplAcctgDocPyblsItem.AmountInAdditionalCurrency2                   as AmountInAdditionalCurrency2,
      cast( 0 as fis_tsl )                                                       as AmountInBalanceTransacCrcy,
      I_ParkedOplAcctgDocPyblsItem.AmountInCompanyCodeCurrency                   as AmountInCompanyCodeCurrency,
      cast( 0 as fis_vfccur12 )                                                  as AmountInFunctionalCurrency,
      I_ParkedOplAcctgDocPyblsItem.AmountInPaymentCurrency                       as AmountInPaymentCurrency,
      I_ParkedOplAcctgDocPyblsItem.AmountInTransactionCurrency                   as AmountInTransactionCurrency,
      I_ParkedOplAcctgDocPyblsItem.AssetContract                                 as AssetContract,
      I_ParkedOplAcctgDocPyblsItem.AssignmentReference                           as AssignmentReference,
      cast( '     ' as pswsl )                                                   as BalanceTransactionCurrency,
      '          '                                                               as BillingDocument,
      ' '                                                                        as BillOfExchangeUsage,
      I_ParkedOplAcctgDocPyblsItem.BranchAccount                                 as Branch,
      I_ParkedOplAcctgDocPyblsItem.BusinessArea                                  as BusinessArea,
      I_ParkedOplAcctgDocPyblsItem.BusinessPlace                                 as BusinessPlace,
      I_ParkedOplAcctgDocPyblsItem.CashDiscount1Days                             as CashDiscount1Days,
      I_ParkedOplAcctgDocPyblsItem.CashDiscount1DueDate                          as CashDiscount1DueDate,
      I_ParkedOplAcctgDocPyblsItem.CashDiscount1Percent                          as CashDiscount1Percent,
      I_ParkedOplAcctgDocPyblsItem.CashDiscount2Days                             as CashDiscount2Days,
      I_ParkedOplAcctgDocPyblsItem.CashDiscount2Percent                          as CashDiscount2Percent,
      I_ParkedOplAcctgDocPyblsItem.CashDiscountAmount                            as CashDiscountAmount,
      I_ParkedOplAcctgDocPyblsItem.CashDiscountAmtInCoCodeCrcy                   as CashDiscountAmtInCoCodeCrcy,
      I_ParkedOplAcctgDocPyblsItem.CashDiscountBaseAmount                        as CashDiscountBaseAmount,
      I_ParkedOplAcctgDocPyblsItem.CashFlowType                                  as CashFlowType,
      '          '                                                               as ClearingAccountingDocument,
      '00000000'                                                                 as ClearingDate,
      '0000'                                                                     as ClearingDocFiscalYear,
      ' '                                                                        as ClearingIsReversed,
      I_ParkedOplAcctgDocPyblsItem.CompanyCodeCurrency                           as CompanyCodeCurrency,
      '          '                                                               as CostCenter,
      ''                                                                         as CreditControlArea,
      I_ParkedOplAcctgDocPyblsItem.AlternativePayeePayer                         as PayableAlternativePayee,
      I_ParkedOplAcctgDocPyblsItem.DataExchangeInstruction1                      as DataExchangeInstruction1,
      I_ParkedOplAcctgDocPyblsItem.DataExchangeInstruction2                      as DataExchangeInstruction2,
      I_ParkedOplAcctgDocPyblsItem.DataExchangeInstruction3                      as DataExchangeInstruction3,
      I_ParkedOplAcctgDocPyblsItem.DataExchangeInstruction4                      as DataExchangeInstruction4,
      I_ParkedOplAcctgDocPyblsItem.DebitCreditCode                               as DebitCreditCode,
      _ParkedOplAcctgDocument.DocumentDate                                       as DocumentDate,
      ' '                                                                        as DocumentIsArchived,
      I_ParkedOplAcctgDocPyblsItem.DocumentItemText                              as DocumentItemText,
      _ParkedOplAcctgDocument.DocumentReferenceID                                as DocumentReferenceID,
      I_ParkedOplAcctgDocPyblsItem.DueCalculationBaseDate                        as DueCalculationBaseDate,
      I_ParkedOplAcctgDocPyblsItem.DunningArea                                   as DunningArea,
      I_ParkedOplAcctgDocPyblsItem.DunningBlockingReason                         as DunningBlockingReason,
      I_ParkedOplAcctgDocPyblsItem.DunningLevel                                  as DunningLevel,
      'K'                                                                        as FinancialAccountType,
      _ParkedOplAcctgDocument.FiscalPeriod                                       as FiscalPeriod,
      '    '                                                                     as FixedAsset,
      I_ParkedOplAcctgDocPyblsItem.FixedCashDiscount                             as FixedCashDiscount,
      I_ParkedOplAcctgDocPyblsItem.FollowOnDocumentType                          as FollowOnDocumentType,
      I_ParkedOplAcctgDocPyblsItem.StateCentralBankPaymentReason                 as StateCentralBankPaymentReason,
      I_ParkedOplAcctgDocPyblsItem.SupplyingCountry                              as SupplyingCountry,
      cast( '     ' as fins_currf )                                              as FunctionalCurrency,
      I_ParkedOplAcctgDocPyblsItem.FundsCenter                                   as FundsCenter,
      I_ParkedOplAcctgDocPyblsItem.GLAccount                                     as GLAccount,
      ' '                                                                        as HasPaymentOrder,
      cast( 0 as absbt_farp )                                                    as HedgedAmount,
      I_ParkedOplAcctgDocPyblsItem.HouseBankAccount                              as HouseBankAccount,
      I_ParkedOplAcctgDocPyblsItem.InvoiceList                                   as InvoiceList,
      I_ParkedOplAcctgDocPyblsItem.InvoiceReference                              as InvoiceReference,
      I_ParkedOplAcctgDocPyblsItem.IsSalesRelated                                as IsSalesRelated,
      ' '                                                                        as IsUsedInPaymentTransaction,
      
      //      Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.

      //      The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.

      'VBSEGK_BRANCH'                                                            as ITEM_TYPE_BRANCH,
      I_ParkedOplAcctgDocPyblsItem.LastDunningDate                               as LastDunningDate,
      '            '                                                             as MasterFixedAsset,
      I_ParkedOplAcctgDocPyblsItem.DunningKey                                    as DunningKey,
      I_ParkedOplAcctgDocPyblsItem.NetDueDate                                    as NetDueDate,
      I_ParkedOplAcctgDocPyblsItem.NetPaymentDays                                as NetPaymentDays,
      '          '                                                               as OffsettingAccount,
      ' '                                                                        as OffsettingAccountType,
      '            '                                                             as OrderID,
      _ParkedOplAcctgDocument.PartnerCompany                                     as PartnerCompany,
      I_ParkedOplAcctgDocPyblsItem.PaymentBlockingReason                         as PaymentBlockingReason,
      '000'                                                                      as PaymentCardItem,
      '          '                                                               as PaymentCardPaymentSettlement,
      I_ParkedOplAcctgDocPyblsItem.PaymentCurrency                               as PaymentCurrency,
      I_ParkedOplAcctgDocPyblsItem.PaymentDifferenceReason                       as PaymentDifferenceReason,
      I_ParkedOplAcctgDocPyblsItem.PaymentMethod                                 as PaymentMethod,
      I_ParkedOplAcctgDocPyblsItem.PaymentMethodSupplement                       as PaymentMethodSupplement,
      I_ParkedOplAcctgDocPyblsItem.PaymentReference                              as PaymentReference,
      I_ParkedOplAcctgDocPyblsItem.PaymentTerms                                  as PaymentTerms,
      I_ParkedOplAcctgDocPyblsItem.PlannedAmtInTransactionCrcy                   as PlannedAmtInTransactionCrcy,
      '    '                                                                     as Plant,
      _ParkedOplAcctgDocument.PostingDate                                        as PostingDate,
      I_ParkedOplAcctgDocPyblsItem.PostingKey                                    as PostingKey,
      '          '                                                               as ProfitCenter,
      '          '                                                               as PurchasingDocument,
      '00000'                                                                    as PurchasingDocumentItem,
      '        '                                                                 as RealEstateObject,
      I_ParkedOplAcctgDocPyblsItem.Reference1IDByBusinessPartner                 as Reference1IDByBusinessPartner,
      I_ParkedOplAcctgDocPyblsItem.Reference2IDByBusinessPartner                 as Reference2IDByBusinessPartner,
      I_ParkedOplAcctgDocPyblsItem.Reference3IDByBusinessPartner                 as Reference3IDByBusinessPartner,
      '          '                                                               as SalesDocument,
      '000000'                                                                   as SalesDocumentItem,
      '0000'                                                                     as ScheduleLine,
      I_ParkedOplAcctgDocPyblsItem.SettlementReferenceDate                       as SettlementReferenceDate,
      I_ParkedOplAcctgDocPyblsItem.SourceCompanyCode                             as SourceCompanyCode,
      I_ParkedOplAcctgDocPyblsItem.SpecialGLCode                                 as SpecialGLCode,
      I_ParkedOplAcctgDocPyblsItem.SpecialGLTransactionType                      as SpecialGLTransactionType,
      I_ParkedOplAcctgDocPyblsItem.Supplier                                      as Supplier,
      I_ParkedOplAcctgDocPyblsItem._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
      I_ParkedOplAcctgDocPyblsItem.TaxCode                                       as TaxCode,
      I_ParkedOplAcctgDocPyblsItem.TaxCountry                                    as TaxCountry,
      _ParkedOplAcctgDocument.TaxReportingDate                                   as TaxReportingDate,
      I_ParkedOplAcctgDocPyblsItem.TaxSection                                    as TaxSection,
      I_ParkedOplAcctgDocPyblsItem.TransactionCurrency                           as TransactionCurrency,
      I_ParkedOplAcctgDocPyblsItem.TreasuryContractType                          as TreasuryContractType,
      cast( 0 as fis_bdif2 )                                                     as ValuationDiffAmtInAddlCrcy1,
      cast( 0 as fis_bdif3 )                                                     as ValuationDiffAmtInAddlCrcy2,
      cast( 0 as fis_bdiff )                                                     as ValuationDiffAmtInCoCodeCrcy,
      I_ParkedOplAcctgDocPyblsItem.ValueDate                                     as ValueDate,
      '00000000'                                                                 as WBSElement,
      I_ParkedOplAcctgDocPyblsItem.WithholdingTaxAmount                          as WithholdingTaxAmount,
      I_ParkedOplAcctgDocPyblsItem.WithholdingTaxBaseAmount                      as WithholdingTaxBaseAmount,
      I_ParkedOplAcctgDocPyblsItem.WithholdingTaxExemptionAmt                    as WithholdingTaxExemptionAmt,
      I_ParkedOplAcctgDocPyblsItem.BPBankAccountInternalID                       as BPBankAccountInternalID,
      I_ParkedOplAcctgDocPyblsItem.HouseBank                                     as HouseBank,
      '          '                                                               as Debtor,
      _ParkedOplAcctgDocument.AdditionalCurrency1Role                            as AdditionalCurrency1Role,
      _ParkedOplAcctgDocument.AdditionalCurrency2Role                            as AdditionalCurrency2Role,
      I_ParkedOplAcctgDocPyblsItem.BranchCode                                    as BranchCode,
      _ParkedOplAcctgDocument.ReferenceDocumentType                              as ReferenceDocumentType,
      _ParkedOplAcctgDocument.OriginalReferenceDocument                          as OriginalReferenceDocument,
      _ParkedOplAcctgDocument.ReferenceDocumentLogicalSystem                     as ReferenceDocumentLogicalSystem,
      I_ParkedOplAcctgDocPyblsItem.PaymentReason                                 as PaymentReason,
      '          '                                                               as BillOfExchangeUsageDocument,
      '    '                                                                     as BOEUsageDocFiscalYear,
      '   '                                                                      as BOEUsageDocLineItem,
      I_ParkedOplAcctgDocPyblsItem.JointVenture                                  as JointVenture,
      '  '                                                                       as JointVentureCostRecoveryCode,
      I_ParkedOplAcctgDocPyblsItem.JointVentureBillingType                       as JointVentureBillingType,
      I_ParkedOplAcctgDocPyblsItem.JointVentureEquityGroup                       as JointVentureCorporateEquityGrp   

}

union all
//  parked debit items of mixed accounts

select from  I_ParkedOplAcctgDocRblsItem

//  inner join P_APLineItem_5 as MixAcc2 on I_ParkedOplAcctgDocRblsItem.Customer = MixAcc2.Debtor

  inner join fap_mult_mix_acc as MixAcc2 on  I_ParkedOplAcctgDocRblsItem.Customer    = MixAcc2.debtor
                                         and I_ParkedOplAcctgDocRblsItem.CompanyCode = MixAcc2.companycode
{
  key I_ParkedOplAcctgDocRblsItem.CompanyCode,   
  key I_ParkedOplAcctgDocRblsItem.SourceAccountingDocument                       as AccountingDocument,
  key I_ParkedOplAcctgDocRblsItem.SourceFiscalYear                               as FiscalYear,
  key I_ParkedOplAcctgDocRblsItem.SourceAccountingDocumentItem                   as AccountingDocumentItem,

      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.AccountingDocCreatedByUser      as AccountingDocCreatedByUser,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.AccountingDocumentCategory      as AccountingDocumentCategory,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.AccountingDocumentCreationDate  as AccountingDocumentCreationDate,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.AccountingDocumentType          as AccountingDocumentType,
      '  '                                                                       as AccountsReceivableIsPledged,
      I_ParkedOplAcctgDocRblsItem.AdditionalCurrency1                            as AdditionalCurrency1,
      I_ParkedOplAcctgDocRblsItem.AdditionalCurrency2                            as AdditionalCurrency2,
      ' '                                                                        as AlternativeGLAccount,
      I_ParkedOplAcctgDocRblsItem.AmountInAdditionalCurrency1                    as AmountInAdditionalCurrency1,
      I_ParkedOplAcctgDocRblsItem.AmountInAdditionalCurrency2                    as AmountInAdditionalCurrency2,
      cast( 0 as fis_tsl )                                                       as AmountInBalanceTransacCrcy,
      I_ParkedOplAcctgDocRblsItem.AmountInCompanyCodeCurrency                    as AmountInCompanyCodeCurrency,
      cast( 0 as fis_vfccur12 )                                                  as AmountInFunctionalCurrency,
      I_ParkedOplAcctgDocRblsItem.AmountInPaymentCurrency                        as AmountInPaymentCurrency,
      I_ParkedOplAcctgDocRblsItem.AmountInTransactionCurrency                    as AmountInTransactionCurrency,
      I_ParkedOplAcctgDocRblsItem.AssetContract                                  as AssetContract,
      I_ParkedOplAcctgDocRblsItem.AssignmentReference                            as AssignmentReference,
      cast( '     ' as pswsl )                                                   as BalanceTransactionCurrency,
      '          '                                                               as BillingDocument,
      ' '                                                                        as BillOfExchangeUsage,
      I_ParkedOplAcctgDocRblsItem.BranchAccount                                  as Branch,
      I_ParkedOplAcctgDocRblsItem.BusinessArea                                   as BusinessArea,
      I_ParkedOplAcctgDocRblsItem.BusinessPlace                                  as BusinessPlace,
      I_ParkedOplAcctgDocRblsItem.CashDiscount1Days                              as CashDiscount1Days,
      I_ParkedOplAcctgDocRblsItem.CashDiscount1DueDate                           as CashDiscount1DueDate,
      I_ParkedOplAcctgDocRblsItem.CashDiscount1Percent                           as CashDiscount1Percent,
      I_ParkedOplAcctgDocRblsItem.CashDiscount2Days                              as CashDiscount2Days,
      I_ParkedOplAcctgDocRblsItem.CashDiscount2Percent                           as CashDiscount2Percent,
      I_ParkedOplAcctgDocRblsItem.CashDiscountAmount                             as CashDiscountAmount,
      I_ParkedOplAcctgDocRblsItem.CashDiscountAmtInCoCodeCrcy                    as CashDiscountAmtInCoCodeCrcy,
      I_ParkedOplAcctgDocRblsItem.CashDiscountBaseAmount                         as CashDiscountBaseAmount,
      I_ParkedOplAcctgDocRblsItem.CashFlowType                                   as CashFlowType,
      '          '                                                               as ClearingAccountingDocument,
      '00000000'                                                                 as ClearingDate,
      '0000'                                                                     as ClearingDocFiscalYear,
      ' '                                                                        as ClearingIsReversed,
      I_ParkedOplAcctgDocRblsItem.CompanyCodeCurrency                            as CompanyCodeCurrency,
      '          '                                                               as CostCenter,
      I_ParkedOplAcctgDocRblsItem.CreditControlArea                              as CreditControlArea,
      I_ParkedOplAcctgDocRblsItem.AlternativePayeePayer                          as PayableAlternativePayee,
      I_ParkedOplAcctgDocRblsItem.DataExchangeInstruction1                       as DataExchangeInstruction1,
      I_ParkedOplAcctgDocRblsItem.DataExchangeInstruction2                       as DataExchangeInstruction2,
      I_ParkedOplAcctgDocRblsItem.DataExchangeInstruction3                       as DataExchangeInstruction3,
      I_ParkedOplAcctgDocRblsItem.DataExchangeInstruction4                       as DataExchangeInstruction4,
      I_ParkedOplAcctgDocRblsItem.DebitCreditCode                                as DebitCreditCode,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.DocumentDate           as DocumentDate,
      ' '                                                                        as DocumentIsArchived,
      I_ParkedOplAcctgDocRblsItem.DocumentItemText                               as DocumentItemText,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.DocumentReferenceID    as DocumentReferenceID,
      I_ParkedOplAcctgDocRblsItem.DueCalculationBaseDate                         as DueCalculationBaseDate,
      I_ParkedOplAcctgDocRblsItem.DunningArea                                    as DunningArea,
      I_ParkedOplAcctgDocRblsItem.DunningBlockingReason                          as DunningBlockingReason,
      I_ParkedOplAcctgDocRblsItem.DunningLevel                                   as DunningLevel,
      'D'                                                                        as FinancialAccountType,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.FiscalPeriod           as FiscalPeriod,
      '    '                                                                     as FixedAsset,
      ' '                                                                        as FixedCashDiscount,
      I_ParkedOplAcctgDocRblsItem.FollowOnDocumentType                           as FollowOnDocumentType,
      I_ParkedOplAcctgDocRblsItem.StateCentralBankPaymentReason                  as StateCentralBankPaymentReason,
      I_ParkedOplAcctgDocRblsItem.SupplyingCountry                               as SupplyingCountry,
      cast( '     ' as fins_currf )                                              as FunctionalCurrency,
      I_ParkedOplAcctgDocRblsItem.FundsCenter                                    as FundsCenter,
      I_ParkedOplAcctgDocRblsItem.GLAccount                                      as GLAccount,
      ' '                                                                        as HasPaymentOrder,
      cast( 0 as absbt_farp )                                                    as HedgedAmount,
      I_ParkedOplAcctgDocRblsItem.HouseBankAccount                               as HouseBankAccount,
      I_ParkedOplAcctgDocRblsItem.InvoiceList                                    as InvoiceList,
      I_ParkedOplAcctgDocRblsItem.InvoiceReference                               as InvoiceReference,
      I_ParkedOplAcctgDocRblsItem.IsSalesRelated                                 as IsSalesRelated,
      ' '                                                                        as IsUsedInPaymentTransaction,

      //      Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.

      //      The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.

      'VBSEGD_BRANCH'                                                            as ITEM_TYPE_BRANCH,
      I_ParkedOplAcctgDocRblsItem.LastDunningDate                                as LastDunningDate,
      '            '                                                             as MasterFixedAsset,
      I_ParkedOplAcctgDocRblsItem.DunningKey                                     as DunningKey,
      I_ParkedOplAcctgDocRblsItem.NetDueDate                                     as NetDueDate,
      I_ParkedOplAcctgDocRblsItem.NetPaymentDays                                 as NetPaymentDays,
      '          '                                                               as OffsettingAccount,
      ' '                                                                        as OffsettingAccountType,
      '            '                                                             as OrderID,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.PartnerCompany         as PartnerCompany,
      I_ParkedOplAcctgDocRblsItem.PaymentBlockingReason                          as PaymentBlockingReason,
      '000'                                                                      as PaymentCardItem,
      '          '                                                               as PaymentCardPaymentSettlement,
      I_ParkedOplAcctgDocRblsItem.PaymentCurrency                                as PaymentCurrency,
      I_ParkedOplAcctgDocRblsItem.PaymentDifferenceReason                        as PaymentDifferenceReason,
      I_ParkedOplAcctgDocRblsItem.PaymentMethod                                  as PaymentMethod,
      I_ParkedOplAcctgDocRblsItem.PaymentMethodSupplement                        as PaymentMethodSupplement,
      I_ParkedOplAcctgDocRblsItem.PaymentReference                               as PaymentReference,
      I_ParkedOplAcctgDocRblsItem.PaymentTerms                                   as PaymentTerms,
      I_ParkedOplAcctgDocRblsItem.PlannedAmtInTransactionCrcy                    as PlannedAmtInTransactionCrcy,
      '    '                                                                     as Plant,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.PostingDate            as PostingDate,
      I_ParkedOplAcctgDocRblsItem.PostingKey                                     as PostingKey,
      '          '                                                               as ProfitCenter,
      '          '                                                               as PurchasingDocument,
      '00000'                                                                    as PurchasingDocumentItem,
      '        '                                                                 as RealEstateObject,
      I_ParkedOplAcctgDocRblsItem.Reference1IDByBusinessPartner                  as Reference1IDByBusinessPartner,
      I_ParkedOplAcctgDocRblsItem.Reference2IDByBusinessPartner                  as Reference2IDByBusinessPartner,
      I_ParkedOplAcctgDocRblsItem.Reference3IDByBusinessPartner                  as Reference3IDByBusinessPartner,
      '          '                                                               as SalesDocument,
      '000000'                                                                   as SalesDocumentItem,
      '0000'                                                                     as ScheduleLine,
      '00000000'                                                                 as SettlementReferenceDate,
      I_ParkedOplAcctgDocRblsItem.SourceCompanyCode                              as SourceCompanyCode,
      I_ParkedOplAcctgDocRblsItem.SpecialGLCode                                  as SpecialGLCode,
      I_ParkedOplAcctgDocRblsItem.SpecialGLTransactionType                       as SpecialGLTransactionType,
      MixAcc2.supplier                                                           as Supplier,
      I_ParkedOplAcctgDocRblsItem._CompanyCode._Country.TaxCalculationProcedure  as TaxCalculationProcedure,
      I_ParkedOplAcctgDocRblsItem.TaxCode                                        as TaxCode,
      I_ParkedOplAcctgDocRblsItem.TaxCountry                                     as TaxCountry,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.TaxReportingDate       as TaxReportingDate,
      I_ParkedOplAcctgDocRblsItem.TaxSection                                     as TaxSection,
      I_ParkedOplAcctgDocRblsItem.TransactionCurrency                            as TransactionCurrency,
      I_ParkedOplAcctgDocRblsItem.TreasuryContractType                           as TreasuryContractType,
      cast( 0 as fis_bdif2 )                                                     as ValuationDiffAmtInAddlCrcy1,
      cast( 0 as fis_bdif3 )                                                     as ValuationDiffAmtInAddlCrcy2,
      cast( 0 as fis_bdiff )                                                     as ValuationDiffAmtInCoCodeCrcy,
      I_ParkedOplAcctgDocRblsItem.ValueDate                                      as ValueDate,
      '00000000'                                                                 as WBSElement,
      cast( 0 as fis_qbshb )                                                     as WithholdingTaxAmount,
      cast( 0 as fis_qsshb )                                                     as WithholdingTaxBaseAmount,
      cast( 0 as fis_qsfbt )                                                     as WithholdingTaxExemptionAmt,
      I_ParkedOplAcctgDocRblsItem.BPBankAccountInternalID                        as BPBankAccountInternalID,
      I_ParkedOplAcctgDocRblsItem.HouseBank                                      as HouseBank,
      I_ParkedOplAcctgDocRblsItem.Customer                                       as Debtor,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.AdditionalCurrency1Role               as AdditionalCurrency1Role,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.AdditionalCurrency2Role               as AdditionalCurrency2Role,
      I_ParkedOplAcctgDocRblsItem.BranchCode                                                    as BranchCode,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.ReferenceDocumentType                 as ReferenceDocumentType,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.OriginalReferenceDocument             as OriginalReferenceDocument,
      I_ParkedOplAcctgDocRblsItem._ParkedOplAcctgDocument.ReferenceDocumentLogicalSystem        as ReferenceDocumentLogicalSystem,
      I_ParkedOplAcctgDocRblsItem.PaymentReason                                  as PaymentReason,
      '          '                                                               as BillOfExchangeUsageDocument,
      '    '                                                                     as BOEUsageDocFiscalYear,
      '   '                                                                      as BOEUsageDocLineItem,
      I_ParkedOplAcctgDocRblsItem.JointVenture                                   as JointVenture,
      '  '                                                                       as JointVentureCostRecoveryCode,
      I_ParkedOplAcctgDocRblsItem.JointVentureBillingType                        as JointVentureBillingType,
      I_ParkedOplAcctgDocRblsItem.JointVentureEquityGroup                        as JointVentureCorporateEquityGrp   
}
where
  MixAcc2.debtor != ''

union all

select from P_APLineItem_7
{
  key P_APLineItem_7.CompanyCode                                    as CompanyCode,
  key P_APLineItem_7.AccountingDocument                             as AccountingDocument,
  key P_APLineItem_7.FiscalYear                                     as FiscalYear,
  key P_APLineItem_7.AccountingDocumentItem                         as AccountingDocumentItem,

      '            '                                                as AccountingDocCreatedByUser,
      P_APLineItem_7.AccountingDocumentCategory                     as AccountingDocumentCategory,
      P_APLineItem_7.CreationDate                                   as AccountingDocumentCreationDate,
      P_APLineItem_7.AccountingDocumentType                         as AccountingDocumentType,
      '  '                                                          as AccountsReceivableIsPledged,
      P_APLineItem_7._AdditionalCompanyCurrency.AdditionalCurrency1 as AdditionalCurrency1,
      P_APLineItem_7._AdditionalCompanyCurrency.AdditionalCurrency2 as AdditionalCurrency2,
      ' '                                                           as AlternativeGLAccount,
      P_APLineItem_7.AmountInAdditionalCurrency1                    as AmountInAdditionalCurrency1,
      P_APLineItem_7.AmountInAdditionalCurrency2                    as AmountInAdditionalCurrency2,
      P_APLineItem_7.AmountInBalanceTransacCrcy                     as AmountInBalanceTransacCrcy,
      P_APLineItem_7.AmountInCompanyCodeCurrency                    as AmountInCompanyCodeCurrency,
      cast( 0 as fis_vfccur12 )                                     as AmountInFunctionalCurrency,
      P_APLineItem_7.AmountInPaymentCurrency                        as AmountInPaymentCurrency,
      P_APLineItem_7.AmountInTransactionCurrency                    as AmountInTransactionCurrency,
      P_APLineItem_7.AssetContract                                  as AssetContract,
      P_APLineItem_7.AssignmentReference                            as AssignmentReference,
      P_APLineItem_7.BalanceTransactionCurrency                     as BalanceTransactionCurrency,
      '          '                                                  as BillingDocument,
      ' '                                                           as BillOfExchangeUsage,
      P_APLineItem_7.Branch                                         as Branch,
      P_APLineItem_7.BusinessArea                                   as BusinessArea,
      P_APLineItem_7.BusinessPlace                                  as BusinessPlace,
      P_APLineItem_7.CashDiscount1Days                              as CashDiscount1Days,
      '00000000'                                                    as CashDiscount1DueDate,
      P_APLineItem_7.CashDiscount1Percent                           as CashDiscount1Percent,
      P_APLineItem_7.CashDiscount2Days                              as CashDiscount2Days,
      P_APLineItem_7.CashDiscount2Percent                           as CashDiscount2Percent,
      P_APLineItem_7.CashDiscountAmount                             as CashDiscountAmount,
      P_APLineItem_7.CashDiscountAmtInCoCodeCrcy                    as CashDiscountAmtInCoCodeCrcy,
      P_APLineItem_7.CashDiscountBaseAmount                         as CashDiscountBaseAmount,
      P_APLineItem_7.CashFlowType                                   as CashFlowType,
      P_APLineItem_7.ClearingAccountingDocument                     as ClearingAccountingDocument,
      P_APLineItem_7.ClearingDate                                   as ClearingDate,
      P_APLineItem_7.ClearingDocFiscalYear                          as ClearingDocFiscalYear,
      P_APLineItem_7.ClearingIsReversed                             as ClearingIsReversed,
      _CompanyCode.Currency                                         as CompanyCodeCurrency,
      P_APLineItem_7.CostCenter                                     as CostCenter,
      ''                                                            as CreditControlArea,
      P_APLineItem_7.PayableAlternativePayee                        as PayableAlternativePayee,
      P_APLineItem_7.DataExchangeInstruction1                       as DataExchangeInstruction1,
      P_APLineItem_7.DataExchangeInstruction2                       as DataExchangeInstruction2,
      P_APLineItem_7.DataExchangeInstruction3                       as DataExchangeInstruction3,
      P_APLineItem_7.DataExchangeInstruction4                       as DataExchangeInstruction4,
      P_APLineItem_7.DebitCreditCode                                as DebitCreditCode,
      P_APLineItem_7.DocumentDate                                   as DocumentDate,
      P_APLineItem_7.DocumentIsArchived                             as DocumentIsArchived,
      P_APLineItem_7.DocumentItemText                               as DocumentItemText,
      P_APLineItem_7.DocumentReferenceID                            as DocumentReferenceID,
      P_APLineItem_7.DueCalculationBaseDate                         as DueCalculationBaseDate,
      P_APLineItem_7.DunningArea                                    as DunningArea,
      P_APLineItem_7.DunningBlockingReason                          as DunningBlockingReason,
      P_APLineItem_7.DunningLevel                                   as DunningLevel,
      'K'                                                           as FinancialAccountType,
      P_APLineItem_7.FiscalPeriod                                   as FiscalPeriod,
      P_APLineItem_7.FixedAsset                                     as FixedAsset,
      P_APLineItem_7.FixedCashDiscount                              as FixedCashDiscount,
      P_APLineItem_7.FollowOnDocumentType                           as FollowOnDocumentType,
      P_APLineItem_7.StateCentralBankPaymentReason                  as StateCentralBankPaymentReason,
      P_APLineItem_7.SupplyingCountry                               as SupplyingCountry,
      cast( '     ' as fins_currf )                                 as FunctionalCurrency,
      P_APLineItem_7.FundsCenter                                    as FundsCenter,
      P_APLineItem_7.GLAccount                                      as GLAccount,
      P_APLineItem_7.HasPaymentOrder                                as HasPaymentOrder,
      cast( 0 as absbt_farp )                                       as HedgedAmount,
      P_APLineItem_7.HouseBankAccount                               as HouseBankAccount,
      P_APLineItem_7.InvoiceList                                    as InvoiceList,
      P_APLineItem_7.InvoiceReference                               as InvoiceReference,
      ' '                                                           as IsSalesRelated,
      P_APLineItem_7.IsUsedInPaymentTransaction                     as IsUsedInPaymentTransaction,

      //      Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.

      //      The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.

      'BSAK_BCK_BRANCH'                                             as ITEM_TYPE_BRANCH,
      P_APLineItem_7.LastDunningDate                                as LastDunningDate,
      P_APLineItem_7.MasterFixedAsset                               as MasterFixedAsset,
      P_APLineItem_7.DunningKey                                     as DunningKey,
      '00000000'                                                    as NetDueDate,
      P_APLineItem_7.NetPaymentDays                                 as NetPaymentDays,
      '          '                                                  as OffsettingAccount,
      ' '                                                           as OffsettingAccountType,
      P_APLineItem_7.OrderID                                        as OrderID,
      P_APLineItem_7.PartnerCompany                                 as PartnerCompany,
      P_APLineItem_7.PaymentBlockingReason                          as PaymentBlockingReason,
      '000'                                                         as PaymentCardItem,
      '          '                                                  as PaymentCardPaymentSettlement,
      P_APLineItem_7.PaymentCurrency                                as PaymentCurrency,
      P_APLineItem_7.PaymentDifferenceReason                        as PaymentDifferenceReason,
      P_APLineItem_7.PaymentMethod                                  as PaymentMethod,
      P_APLineItem_7.PaymentMethodSupplement                        as PaymentMethodSupplement,
      P_APLineItem_7.PaymentReference                               as PaymentReference,
      P_APLineItem_7.PaymentTerms                                   as PaymentTerms,
      cast( 0 as fis_fdwbt )                                        as PlannedAmtInTransactionCrcy,
      '    '                                                        as Plant,
      P_APLineItem_7.PostingDate                                    as PostingDate,
      P_APLineItem_7.PostingKey                                     as PostingKey,
      P_APLineItem_7.ProfitCenter                                   as ProfitCenter,
      P_APLineItem_7.PurchasingDocument                             as PurchasingDocument,
      P_APLineItem_7.PurchasingDocumentItem                         as PurchasingDocumentItem,
      P_APLineItem_7.RealEstateObject                               as RealEstateObject,
      P_APLineItem_7.Reference1IDByBusinessPartner                  as Reference1IDByBusinessPartner,
      P_APLineItem_7.Reference2IDByBusinessPartner                  as Reference2IDByBusinessPartner,
      P_APLineItem_7.Reference3IDByBusinessPartner                  as Reference3IDByBusinessPartner,
      '          '                                                  as SalesDocument,
      '000000'                                                      as SalesDocumentItem,
      '0000'                                                        as ScheduleLine,
      P_APLineItem_7.SettlementReferenceDate                        as SettlementReferenceDate,
      ''                                                            as SourceCompanyCode,
      P_APLineItem_7.SpecialGLCode                                  as SpecialGLCode,
      P_APLineItem_7.SpecialGLTransactionType                       as SpecialGLTransactionType,
      P_APLineItem_7.Supplier                                       as Supplier,
      P_APLineItem_7._CompanyCode._Country.TaxCalculationProcedure  as TaxCalculationProcedure,
      P_APLineItem_7.TaxCode                                        as TaxCode,
      P_APLineItem_7.TaxCountry                                     as TaxCountry,
      '        '                                                    as TaxReportingDate,
      P_APLineItem_7.TaxSection                                     as TaxSection,
      P_APLineItem_7.TransactionCurrency                            as TransactionCurrency,
      P_APLineItem_7.TreasuryContractType                           as TreasuryContractType,
      P_APLineItem_7.ValuationDiffAmtInAddlCrcy1                    as ValuationDiffAmtInAddlCrcy1,
      P_APLineItem_7.ValuationDiffAmtInAddlCrcy2                    as ValuationDiffAmtInAddlCrcy2,
      P_APLineItem_7.ValuationDiffAmtInCoCodeCrcy                   as ValuationDiffAmtInCoCodeCrcy,
      '00000000'                                                    as ValueDate,
      P_APLineItem_7.WBSElement                                     as WBSElement,
      P_APLineItem_7.WithholdingTaxAmount                           as WithholdingTaxAmount,
      P_APLineItem_7.WithholdingTaxBaseAmount                       as WithholdingTaxBaseAmount,
      P_APLineItem_7.WithholdingTaxExemptionAmt                     as WithholdingTaxExemptionAmt,
      P_APLineItem_7.BPBankAccountInternalID                        as BPBankAccountInternalID,
      P_APLineItem_7.HouseBank                                      as HouseBank,
      '          '                                                  as Debtor,
      _AdditionalCompanyCurrency.AdditionalCurrency1Role,
      _AdditionalCompanyCurrency.AdditionalCurrency2Role,
      '     '                                                       as BranchCode,
      P_APLineItem_7.ReferenceDocumentType                          as ReferenceDocumentType,
      P_APLineItem_7.OriginalReferenceDocument                      as OriginalReferenceDocument,
      P_APLineItem_7.ReferenceDocumentLogicalSystem                 as ReferenceDocumentLogicalSystem,
      '    '                                                        as PaymentReason,
      '          '                                                  as BillOfExchangeUsageDocument,
      '    '                                                        as BOEUsageDocFiscalYear,
      '   '                                                         as BOEUsageDocLineItem,
      '      '                                                      as JointVenture,
      '  '                                                          as JointVentureCostRecoveryCode,
      '  '                                                          as JointVentureBillingType,
      '   '                                                         as JointVentureCorporateEquityGrp  
}

union all

select from P_APLineItem_6

{
  key P_APLineItem_6.CompanyCode                                    as CompanyCode,
  key P_APLineItem_6.AccountingDocument                             as AccountingDocument,
  key P_APLineItem_6.FiscalYear                                     as FiscalYear,
  key P_APLineItem_6.AccountingDocumentItem                         as AccountingDocumentItem,

      '            '                                                as AccountingDocCreatedByUser,
      P_APLineItem_6.AccountingDocumentCategory                     as AccountingDocumentCategory,
      P_APLineItem_6.CreationDate                                   as AccountingDocumentCreationDate,
      P_APLineItem_6.AccountingDocumentType                         as AccountingDocumentType,
      P_APLineItem_6.AccountsReceivableIsPledged                    as AccountsReceivableIsPledged,
      P_APLineItem_6._AdditionalCompanyCurrency.AdditionalCurrency1 as AdditionalCurrency1,
      P_APLineItem_6._AdditionalCompanyCurrency.AdditionalCurrency2 as AdditionalCurrency2,
      ' '                                                           as AlternativeGLAccount,
      P_APLineItem_6.AmountInAdditionalCurrency1                    as AmountInAdditionalCurrency1,
      P_APLineItem_6.AmountInAdditionalCurrency2                    as AmountInAdditionalCurrency2,
      P_APLineItem_6.AmountInBalanceTransacCrcy                     as AmountInBalanceTransacCrcy,
      P_APLineItem_6.AmountInCompanyCodeCurrency                    as AmountInCompanyCodeCurrency,
      cast( 0 as fis_vfccur12 )                                     as AmountInFunctionalCurrency,
      P_APLineItem_6.AmountInPaymentCurrency                        as AmountInPaymentCurrency,
      P_APLineItem_6.AmountInTransactionCurrency                    as AmountInTransactionCurrency,
      P_APLineItem_6.AssetContract                                  as AssetContract,
      P_APLineItem_6.AssignmentReference                            as AssignmentReference,
      P_APLineItem_6.BalanceTransactionCurrency                     as BalanceTransactionCurrency,
      P_APLineItem_6.BillingDocument                                as BillingDocument,
      P_APLineItem_6.BillOfExchangeUsage                            as BillOfExchangeUsage,
      P_APLineItem_6.Branch                                         as Branch,
      P_APLineItem_6.BusinessArea                                   as BusinessArea,
      P_APLineItem_6.BusinessPlace                                  as BusinessPlace,
      P_APLineItem_6.CashDiscount1Days                              as CashDiscount1Days,
      '00000000'                                                    as CashDiscount1DueDate,
      P_APLineItem_6.CashDiscount1Percent                           as CashDiscount1Percent,
      P_APLineItem_6.CashDiscount2Days                              as CashDiscount2Days,
      P_APLineItem_6.CashDiscount2Percent                           as CashDiscount2Percent,
      P_APLineItem_6.CashDiscountAmount                             as CashDiscountAmount,
      P_APLineItem_6.CashDiscountAmtInCoCodeCrcy                    as CashDiscountAmtInCoCodeCrcy,
      P_APLineItem_6.CashDiscountBaseAmount                         as CashDiscountBaseAmount,
      P_APLineItem_6.CashFlowType                                   as CashFlowType,
      P_APLineItem_6.ClearingAccountingDocument                     as ClearingAccountingDocument,
      P_APLineItem_6.ClearingDate                                   as ClearingDate,
      P_APLineItem_6.ClearingDocFiscalYear                          as ClearingDocFiscalYear,
      P_APLineItem_6.ClearingIsReversed                             as ClearingIsReversed,
      _CompanyCode.Currency                                         as CompanyCodeCurrency,
      P_APLineItem_6.CostCenter                                     as CostCenter,
      P_APLineItem_6.CreditControlArea                              as CreditControlArea,
      P_APLineItem_6.PayableAlternativePayee                        as PayableAlternativePayee,
      P_APLineItem_6.DataExchangeInstruction1                       as DataExchangeInstruction1,
      P_APLineItem_6.DataExchangeInstruction2                       as DataExchangeInstruction2,
      P_APLineItem_6.DataExchangeInstruction3                       as DataExchangeInstruction3,
      P_APLineItem_6.DataExchangeInstruction4                       as DataExchangeInstruction4,
      P_APLineItem_6.DebitCreditCode                                as DebitCreditCode,
      P_APLineItem_6.DocumentDate                                   as DocumentDate,
      P_APLineItem_6.DocumentIsArchived                             as DocumentIsArchived,
      P_APLineItem_6.DocumentItemText                               as DocumentItemText,
      P_APLineItem_6.DocumentReferenceID                            as DocumentReferenceID,
      P_APLineItem_6.DueCalculationBaseDate                         as DueCalculationBaseDate,
      P_APLineItem_6.DunningArea                                    as DunningArea,
      P_APLineItem_6.DunningBlockingReason                          as DunningBlockingReason,
      P_APLineItem_6.DunningLevel                                   as DunningLevel,
      'D'                                                           as FinancialAccountType,
      P_APLineItem_6.FiscalPeriod                                   as FiscalPeriod,
      P_APLineItem_6.FixedAsset                                     as FixedAsset,
      P_APLineItem_6.FixedCashDiscount                              as FixedCashDiscount,
      P_APLineItem_6.FollowOnDocumentType                           as FollowOnDocumentType,
      P_APLineItem_6.StateCentralBankPaymentReason                  as StateCentralBankPaymentReason,
      P_APLineItem_6.SupplyingCountry                               as SupplyingCountry,
      cast( '     ' as fins_currf )                                 as FunctionalCurrency,
      P_APLineItem_6.FundsCenter                                    as FundsCenter,
      P_APLineItem_6.GLAccount                                      as GLAccount,
      P_APLineItem_6.HasPaymentOrder                                as HasPaymentOrder,
      P_APLineItem_6.HedgedAmount                                   as HedgedAmount,
      P_APLineItem_6.HouseBankAccount                               as HouseBankAccount,
      P_APLineItem_6.InvoiceList                                    as InvoiceList,
      P_APLineItem_6.InvoiceReference                               as InvoiceReference,
      ' '                                                           as IsSalesRelated,
      P_APLineItem_6.IsUsedInPaymentTransaction                     as IsUsedInPaymentTransaction,

      //      Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.

      //      The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.

      'BSAD_BCK_BRANCH'                                             as ITEM_TYPE_BRANCH,
      P_APLineItem_6.LastDunningDate                                as LastDunningDate,
      P_APLineItem_6.MasterFixedAsset                               as MasterFixedAsset,
      P_APLineItem_6.DunningKey                                     as DunningKey,
      '00000000'                                                    as NetDueDate,
      P_APLineItem_6.NetPaymentDays                                 as NetPaymentDays,
      '          '                                                  as OffsettingAccount,
      ' '                                                           as OffsettingAccountType,
      P_APLineItem_6.OrderID                                        as OrderID,
      P_APLineItem_6.PartnerCompany                                 as PartnerCompany,
      P_APLineItem_6.PaymentBlockingReason                          as PaymentBlockingReason,
      P_APLineItem_6.PaymentCardItem                                as PaymentCardItem,
      P_APLineItem_6.PaymentCardPaymentSettlement                   as PaymentCardPaymentSettlement,
      P_APLineItem_6.PaymentCurrency                                as PaymentCurrency,
      P_APLineItem_6.PaymentDifferenceReason                        as PaymentDifferenceReason,
      P_APLineItem_6.PaymentMethod                                  as PaymentMethod,
      P_APLineItem_6.PaymentMethodSupplement                        as PaymentMethodSupplement,
      P_APLineItem_6.PaymentReference                               as PaymentReference,
      P_APLineItem_6.PaymentTerms                                   as PaymentTerms,
      cast( 0 as fis_fdwbt )                                        as PlannedAmtInTransactionCrcy,
      '    '                                                        as Plant,
      P_APLineItem_6.PostingDate                                    as PostingDate,
      P_APLineItem_6.PostingKey                                     as PostingKey,
      P_APLineItem_6.ProfitCenter                                   as ProfitCenter,
      '          '                                                  as PurchasingDocument,
      '00000'                                                       as PurchasingDocumentItem,
      P_APLineItem_6.RealEstateObject                               as RealEstateObject,
      P_APLineItem_6.Reference1IDByBusinessPartner                  as Reference1IDByBusinessPartner,
      P_APLineItem_6.Reference2IDByBusinessPartner                  as Reference2IDByBusinessPartner,
      P_APLineItem_6.Reference3IDByBusinessPartner                  as Reference3IDByBusinessPartner,
      P_APLineItem_6.SalesDocument                                  as SalesDocument,
      P_APLineItem_6.SalesDocumentItem                              as SalesDocumentItem,
      P_APLineItem_6.ScheduleLine                                   as ScheduleLine,
      P_APLineItem_6.SettlementReferenceDate                        as SettlementReferenceDate,
      ''                                                            as SourceCompanyCode,
      P_APLineItem_6.SpecialGLCode                                  as SpecialGLCode,
      P_APLineItem_6.SpecialGLTransactionType                       as SpecialGLTransactionType,
      P_APLineItem_6.Supplier                                       as Supplier,
      P_APLineItem_6._CompanyCode._Country.TaxCalculationProcedure  as TaxCalculationProcedure,
      P_APLineItem_6.TaxCode                                        as TaxCode,
      P_APLineItem_6.TaxCountry                                     as TaxCountry,
      '        '                                                    as TaxReportingDate,
      P_APLineItem_6.TaxSection                                     as TaxSection,
      P_APLineItem_6.TransactionCurrency                            as TransactionCurrency,
      P_APLineItem_6.TreasuryContractType                           as TreasuryContractType,
      P_APLineItem_6.ValuationDiffAmtInAddlCrcy1                    as ValuationDiffAmtInAddlCrcy1,
      P_APLineItem_6.ValuationDiffAmtInAddlCrcy2                    as ValuationDiffAmtInAddlCrcy2,
      P_APLineItem_6.ValuationDiffAmtInCoCodeCrcy                   as ValuationDiffAmtInCoCodeCrcy,
      '00000000'                                                    as ValueDate,
      P_APLineItem_6.WBSElement                                     as WBSElement,
      cast( 0 as fis_qbshb )                                        as WithholdingTaxAmount,
      cast( 0 as fis_qsshb )                                        as WithholdingTaxBaseAmount,
      cast( 0 as fis_qsfbt )                                        as WithholdingTaxExemptionAmt,
      P_APLineItem_6.BPBankAccountInternalID                        as BPBankAccountInternalID,
      P_APLineItem_6.HouseBank                                      as HouseBank,
      P_APLineItem_6.Debtor                                         as Debtor,
      _AdditionalCompanyCurrency.AdditionalCurrency1Role,
      _AdditionalCompanyCurrency.AdditionalCurrency2Role,
      '     '                                                       as BranchCode,
      P_APLineItem_6.ReferenceDocumentType                          as ReferenceDocumentType,
      P_APLineItem_6.OriginalReferenceDocument                      as OriginalReferenceDocument,
      P_APLineItem_6.ReferenceDocumentLogicalSystem                 as ReferenceDocumentLogicalSystem,
      '    '                                                        as PaymentReason,
      '          '                                                  as BillOfExchangeUsageDocument,
      '    '                                                        as BOEUsageDocFiscalYear,
      '   '                                                         as BOEUsageDocLineItem,
      '      '                                                      as JointVenture,
      '  '                                                          as JointVentureCostRecoveryCode,
      '  '                                                          as JointVentureBillingType,
      '   '                                                         as JointVentureCorporateEquityGrp  
};