P_Fqmflow_CSH

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_CSH.
-- 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: PFQMFLOWCSH

CREATE VIEW P_Fqmflow_CSH AS
SELECT
  fqm_flow.flow_id AS FlowId,
  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,
  fqm_flow.amount AS Amount,
  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
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 OriginDocumentIdRl = _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 OriginFlowId = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN P_Fqmbankstatement AS _BankStatement ON BankStatementShortID = _BankStatement.BankStatementShortID AND BankStatementItem = _BankStatement.BankStatementItem  -- association [0..1]
;