P_Fqmflow_CSH

@VDM.private: true 
@VDM.viewType: #BASIC 
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@AbapCatalog.sqlViewName: 'PFQMFLOWCSH'
define view P_Fqmflow_CSH as select from fqm_flow
inner join P_FqmFlowTypeKeyFigure on fqm_flow.flow_type = P_FqmFlowTypeKeyFigure.FlowCategory
association [1..1] to I_CompanyCode             as _CompanyCode             on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_AccountingDocument      as _AccountingDocument      on $projection.OriginDocumentIdRl = _AccountingDocument.OriginalReferenceDocument and $projection.OriginApplication = _AccountingDocument.ReferenceDocumentType
association [0..1] to I_JournalEntry            as _JournalEntry            on $projection.CompanyCode = _JournalEntry.CompanyCode and  $projection.ReferenceDocument = _JournalEntry.AccountingDocument and $projection.FiscalYear = _JournalEntry.FiscalYear
association [0..1] to I_JournalEntryItem        as _JournalEntryItem        on $projection.ReferenceDocument = _JournalEntryItem.ReferenceDocument and $projection.ReferenceDocumentContext = _JournalEntryItem.ReferenceDocumentContext and $projection.LedgerGLLineItem = _JournalEntryItem.LedgerGLLineItem
association [0..1] to I_OperationalAcctgDocItem as _OperationalAcctgDocItem on $projection.CompanyCode = _OperationalAcctgDocItem.CompanyCode and $projection.ReferenceDocument = _OperationalAcctgDocItem.AccountingDocument and $projection.FiscalYear = _OperationalAcctgDocItem.FiscalYear and $projection.OriginFlowId = _OperationalAcctgDocItem.AccountingDocumentItem
association [0..1] to P_Fqmbankstatement        as _BankStatement           on $projection.BankStatementShortID = _BankStatement.BankStatementShortID and $projection.BankStatementItem = _BankStatement.BankStatementItem

{

key fqm_flow.flow_id as FlowId,
key fqm_flow.valid_from as ValidFrom,
fqm_flow.create_user as CreatedByUser,
fqm_flow.last_update_user as LastChangedByUser,
fqm_flow.create_timestamp as CreationDateTime,
fqm_flow.last_update_timestamp as LastChangeDateTime,
fqm_flow.origin_system as OriginSystem,
fqm_flow.origin_application as OriginApplication,
fqm_flow.origin_document_id as OriginDocumentId,
fqm_flow.origin_transaction_id as OriginTransactionId,
fqm_flow.origin_trans_qualifier as OriginTransQualifier,
fqm_flow.origin_flow_id as OriginFlowId,
fqm_flow.origin_system_rl as OriginSystemRl,
fqm_flow.origin_application_rl as OriginApplicationRl,
fqm_flow.origin_document_id_rl as OriginDocumentIdRl,
fqm_flow.origin_transaction_id_rl as OriginTransactionIdRl,
fqm_flow.origin_trans_qualifier_rl as OriginTransQualifierRl,
fqm_flow.origin_flow_id_rl as OriginFlowIdRl,
fqm_flow.certainty_level as CertaintyLevel,
fqm_flow.owner as Owner,
fqm_flow.transaction_date as TransactionDate,
fqm_flow.flow_category as FlowCategory,
fqm_flow.flow_type as FlowType,
fqm_flow.payment_method as PaymentMethodCode,
@Semantics.amount.currencyCode: 'CURRENCY' fqm_flow.amount as Amount,
@Semantics.currencyCode fqm_flow.currency as Currency,
fqm_flow.trm_product_type as ProductType,
fqm_flow.trm_transaction_type as TransactionType,
fqm_flow.trm_activity_category as TrmActivityCategory,
fqm_flow.trm_security_id as TrmSecurityId,
fqm_flow.trm_security_account as TrmSecurityAccount,
fqm_flow.trm_portfolio as TrmPortfolio,
fqm_flow.house_bank as HouseBank,
fqm_flow.house_bank_account as HouseBankAccount,
fqm_flow.bank_account_id as BankAccountId,
fqm_flow.company_code as CompanyCode,
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.planning_level as PlanningLevel,
fqm_flow.planning_group as PlanningGroup,
fqm_flow.contract_number as ContractNumber,
fqm_flow.contract_type as ContractType,
fqm_flow.assigned_company_code as AssignedCompanyCode,
fqm_flow.internal_reference as InternalReference,
fqm_flow.characteristics as Characteristics,
fqm_flow.assignment as Assignment,
P_FqmFlowTypeKeyFigure.KeyFigure as KeyFigure,
substring( fqm_flow.origin_document_id, 11, 8) as ReferenceDocumentContext,
substring( fqm_flow.origin_document_id, 1, 10) as ReferenceDocument,
substring( fqm_flow.origin_document_id, 15, 4) as FiscalYear,
concat( '000', fqm_flow.origin_flow_id) as LedgerGLLineItem,
substring( fqm_flow.origin_transaction_id, 1, 8) as BankStatementShortID,
substring( fqm_flow.origin_transaction_id, 9, 5) as BankStatementItem,
_CompanyCode,
_AccountingDocument,
_JournalEntry,
_JournalEntryItem,
_OperationalAcctgDocItem,
_BankStatement

}

where 
fqm_flow.deleted <> 'X' and
fqm_flow.flg_actual = 'X' and
fqm_flow.software_version <> 999 and 
fqm_flow.origin_application <> 'BKPF' and
fqm_flow.origin_application <> 'BKPFF' and
fqm_flow.origin_application <> 'RMRP';