P_FQMFLOWCASHPOS

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_FQMFLOWCASHPOS.
-- 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: PFQMFLOWCASHPOS

CREATE VIEW P_FQMFLOWCASHPOS AS
SELECT
  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 CashFlow,
  fqm_flow.valid_from AS ValidFrom,
  fqm_flow.valid_to AS ValidTo,
  fqm_flow.flow_id AS flow_id,
  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 AS rel_status,
  fqm_flow.company_code AS CompanyCode,
  fqm_flow.amount AS Amount,
  fqm_flow.currency AS Currency,
  fqm_flow.base_amount AS BaseAmount,
  fqm_flow.base_currency AS BaseCurrency,
  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 AS fi_due_date,
  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,
  fqm_flow.house_bank AS HouseBank,
  fqm_flow.house_bank_account AS HouseBankAccount,
  fqm_flow.bank_account_id AS BankAccountId,
  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,
  fqm_flow.internal_reference AS BankStatementShortKey,
  fqm_flow.cmm_bs_num_eb AS BankStatementItem,
  fqm_flow.cmm_state AS cmm_state
FROM fqm_flow
INNER JOIN P_FQMFLWCATKFIGCSHPOS AS flowcat ON /* join condition not captured in parsed metadata */
;