P_Fqmflow

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_Fqmflow.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PFQMFLOW

CREATE VIEW P_Fqmflow AS
SELECT
  fqm_flow.valid_from AS ValidFrom,
  fqm_flow.valid_to AS ValidTo,
  fqm_flow.create_user AS CreatedByUser,
  fqm_flow.last_update_user AS LastChangedByUser,
  fqm_flow.origin_system AS OriginSystem,
  fqm_flow.origin_application AS OriginApplication,
  fqm_flow.origin_document_id AS OriginDocument,
  fqm_flow.origin_transaction_id AS OriginTransaction,
  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 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.certainty_level AS CertaintyLevel,
  fqm_flow.transaction_date AS TransactionDate,
  fqm_flow.flow_category AS FlowCategory,
  fqm_flow.flow_type AS FlowType,
  fqm_flow.payment_method AS PaymentMethodCode,
  fqm_flow.fi_account AS GLAccount,
  sum(fqm_flow.amount) AS Amount,
  fqm_flow.currency AS Currency,
  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.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.assigned_company_code AS AssignedCompanyCode,
  fqm_flow.internal_reference AS DocumentReferenceID,
  fqm_flow.characteristics AS Characteristics,
  fqm_flow.assignment AS AssignmentReference,
  P_FqmFlowTypeKeyFigure.KeyFigure AS KeyFigure,
  case fqm_flow.origin_application when 'BKPF' then substring( fqm_flow.origin_document_id, 15, 4 ) when 'BKPFE' then substring( fqm_flow.origin_document_id, 15, 4 ) when 'BKPFF' then substring( fqm_flow.origin_document_id, 15, 4 ) when 'IBKPF' then substring( fqm_flow.origin_document_id, 15, 4 ) when 'BSEGV' then substring( fqm_flow.origin_document_id, 15, 4 ) when 'RMRP' then substring( fqm_flow.origin_document_id, 11, 4 ) else ' ' end as FiscalYear AS origin_document_id114elseendasFiscalYear
FROM fqm_flow
INNER JOIN P_FqmFlowTypeKeyFigure ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON OriginDocumentRl = _AccountingDocument.OriginalReferenceDocument AND OriginApplication = _AccountingDocument.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND ReferenceDocument = _JournalEntry.AccountingDocument AND FiscalYear = _JournalEntry.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_JournalEntryItem AS _JournalEntryItem ON ReferenceDocument = _JournalEntryItem.ReferenceDocument AND ReferenceDocumentContext = _JournalEntryItem.ReferenceDocumentContext AND LedgerGLLineItem = _JournalEntryItem.LedgerGLLineItem  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND ReferenceDocument = _OperationalAcctgDocItem.AccountingDocument AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN P_Fqmbankstatement AS _BankStatement ON BankStatementShortID = _BankStatement.BankStatementShortID AND BankStatementItem = _BankStatement.BankStatementItem  -- association [0..1]
;