P_FQMFLOWCASHPOS

@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PFQMFLOWCASHPOS'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey: true
define view P_FQMFLOWCASHPOS
  as select from fqm_flow
    inner join   P_FQMFLWCATKFIGCSHPOS as flowcat on fqm_flow.flow_category = flowcat.FlowCategory
{
  key fqm_flow.origin_system             as OriginSystem,
  key fqm_flow.origin_application        as OriginApplication,
  key fqm_flow.origin_document_id        as OriginDocument,
  key fqm_flow.origin_transaction_id     as OriginTransaction,
  key fqm_flow.origin_trans_qualifier    as OriginTransQualifier,
  key fqm_flow.origin_flow_id            as CashFlow,
  key fqm_flow.valid_from                as ValidFrom,
  key fqm_flow.valid_to                  as ValidTo,
  key fqm_flow.flow_id,

      // general fields

      fqm_flow.flg_actual                as IsValid,
      fqm_flow.origin_system_rl          as OriginSystemRl,
      fqm_flow.origin_application_rl     as OriginApplicationRl,
      fqm_flow.origin_document_id_rl     as OriginDocumentRl,
      fqm_flow.origin_transaction_id_rl  as OriginTransactionRl,
      fqm_flow.origin_trans_qualifier_rl as OriginTransQualifierRl,
      fqm_flow.origin_flow_id_rl         as OriginFlowIdRl,

      fqm_flow.create_user               as CreatedByUser,
      fqm_flow.create_timestamp          as CreationDateTime,
      fqm_flow.last_update_user          as LastChangedByUser,
      fqm_flow.last_update_timestamp     as LastChangeDateTime,
      fqm_flow.owner                     as Owner,
      fqm_flow.certainty_level           as CertaintyLevel,
      fqm_flow.transaction_date          as TransactionDate,
      fqm_flow.flow_category             as FlowCategory,
      fqm_flow.flow_type                 as FlowType,
      fqm_flow.rel_status,

      fqm_flow.company_code              as CompanyCode,
      @Semantics.amount.currencyCode: 'CURRENCY'
      fqm_flow.amount                    as Amount,
      @Semantics.currencyCode: true
      fqm_flow.currency                  as Currency,
      @Semantics.amount.currencyCode: 'BASECURRENCY'
      fqm_flow.base_amount               as BaseAmount,
      @Semantics.currencyCode: true
      fqm_flow.base_currency             as BaseCurrency,

      // accounting fields

      fqm_flow.fi_document_number        as AccountingDocument,
      fqm_flow.fi_document_line_item     as AccountingDocumentItem,
      fqm_flow.fi_fiscal_year            as FiscalYear,
      fqm_flow.fi_fiscal_period          as FiscalPeriod,
      fqm_flow.fi_document_type          as AccountingDocumentType,
      fqm_flow.payment_method            as PaymentMethodCode,
      fqm_flow.fi_account                as GLAccount,
      fqm_flow.fi_account_type           as FinancialAccountType,
      fqm_flow.planning_level            as PlanningLevel,
      fqm_flow.planning_group            as PlanningGroup,
      fqm_flow.fi_item_text              as DocumentItemText,
      fqm_flow.fi_post_date              as PostingDate,
      fqm_flow.fi_value_date             as ValueDate,
      fqm_flow.fi_due_date,

      // trm fields

      fqm_flow.trm_product_type          as ProductType,
      fqm_flow.trm_transaction_type      as FinancialTransactionType,
      fqm_flow.trm_activity_category     as TrmActivityCategory,
      fqm_flow.trm_security_id           as SecurityClass,
      fqm_flow.trm_security_account      as TrmSecurityAccount,
      fqm_flow.trm_portfolio             as Portfolio,
      fqm_flow.contract_number           as ContractNumber,

      // bank fields

      fqm_flow.house_bank                as HouseBank,
      fqm_flow.house_bank_account        as HouseBankAccount,
      //      case when fqm_flow.bank_account_id = ''

      //        then cast('0000000000' as fclm_bam_acc_id)

      //        else fqm_flow.bank_account_id end                             as BankAccountId,

      fqm_flow.bank_account_id           as BankAccountId,

      // account assignment

      fqm_flow.customer_number           as Customer,
      fqm_flow.vendor_number             as Vendor,
      fqm_flow.partner                   as Partner,
      fqm_flow.material                  as Material,
      fqm_flow.business_area             as BusinessArea,
      fqm_flow.profit_center             as ProfitCenter,
      fqm_flow.project                   as Project,
      fqm_flow.cost_center               as CostCenter,
      fqm_flow.trading_partner           as PartnerCompany,
      fqm_flow.liquidity_item            as LiquidityItem,
      fqm_flow.segment                   as Segment,
      fqm_flow.assigned_company_code     as AssignedCompanyCode,
      fqm_flow.internal_reference        as DocumentReferenceID,
      fqm_flow.characteristics           as Characteristics,
      fqm_flow.assignment                as AssignmentReference,
      fqm_flow.fund                      as Fund,
      fqm_flow.grant_nbr                 as GrantID,

      // memo record fields

      fqm_flow.internal_reference        as BankStatementShortKey,
      fqm_flow.cmm_bs_num_eb             as BankStatementItem,
      fqm_flow.cmm_state,
      fqm_flow.cmm_offset_account,
      fqm_flow.cmm_offset_accid,
      fqm_flow.assigned_company_code     as cmm_offset_company_code,
      fqm_flow.fi_value_date             as cmm_offset_value_date,
      fqm_flow.cmm_offset_housebank,
      fqm_flow.cmm_offset_housebankaccount,
      fqm_flow.cmm_statistics_indicator,

      // cash request fields

      fqm_flow.following_companycode,
      fqm_flow.following_account,
      fqm_flow.following_bankdetail,
      @Semantics.currencyCode: true
      fqm_flow.following_currency,
      fqm_flow.following_housebank,
      fqm_flow.following_housebankaccount,
      @Semantics.amount.currencyCode: 'FOLLOWING_CURRENCY'
      fqm_flow.amount_in_folcur,
      fqm_flow.cashrequest_id,
      fqm_flow.cashrequest_status,
      fqm_flow.buy_sell_indicator,
      fqm_flow.instrument_category,
      fqm_flow.cq_assignment,
      fqm_flow.cq_characteristics,
      fqm_flow.cq_internal_reference,
      fqm_flow.mmk_invest_borrow
}
where
      fqm_flow.deleted          = ''
  and fqm_flow.transaction_date < '99991231';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FQMFLWCATKFIGCSHPOS",
"FQM_FLOW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/