P_CashRequestFollowingFlows

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_CashRequestFollowingFlows.
-- 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: PCSHREQFLLW

CREATE VIEW P_CashRequestFollowingFlows AS
SELECT
  flwex.OriginSystem AS OriginSystem,
  flwex.OriginApplication AS OriginApplication,
  flwex.OriginDocument AS OriginDocument,
  flwex.OriginTransaction AS OriginTransaction,
  flwex.OriginTransQualifier AS OriginTransQualifier,
  flwex.CashFlow AS CashFlow,
  flwex.ValidFrom AS ValidFrom,
  flwex.ValidTo AS ValidTo,
  flwex.flow_id AS flow_id,
  flwex.IsValid AS IsValid,
  flwex.CreatedByUser AS CreatedByUser,
  flwex.CreationDateTime AS CreationDateTime,
  flwex.LastChangedByUser AS LastChangedByUser,
  flwex.LastChangeDateTime AS LastChangeDateTime,
  flwex.Owner AS Owner,
  flwex.CompanyCode AS CompanyCode,
  flwex.TransactionDate AS TransactionDate,
  flwex.CertaintyLevel AS CertaintyLevel,
  flwex.Currency AS TransactionCurrency,
  cast( flwex.Amount as fqm_amount ) AS AmountInTransactionCurrency,
  cast('' as fqm_currency) AS CompanyCodeCurrency,
  cast(0 as fqm_amount) AS AmountInCompanyCodeCurrency,
  flwex.rel_status AS rel_status,
  flwex.AccountingDocument AS AccountingDocument,
  flwex.AccountingDocumentItem AS AccountingDocumentItem,
  flwex.FiscalYear AS FiscalYear,
  flwex.FiscalPeriod AS FiscalPeriod,
  flwex.AccountingDocumentType AS AccountingDocumentType,
  flwex.GLAccount AS GLAccount,
  flwex.FinancialAccountType AS FinancialAccountType,
  flwex.PlanningGroup AS CashPlanningGroup,
  flwex.PlanningLevel AS PlanningLevel,
  flwex.PaymentMethodCode AS PaymentMethod,
  flwex.DocumentItemText AS DocumentItemText,
  flwex.PostingDate AS PostingDate,
  flwex.ValueDate AS ValueDate,
  flwex.HouseBank AS HouseBank,
  flwex.HouseBankAccount AS HouseBankAccount,
  flwex.BankAccountId AS BankAccountInternalID,
  flwex.Customer AS Customer,
  flwex.Vendor AS Vendor,
  flwex.Partner AS BusinessPartner,
  flwex.PartnerCompany AS PartnerCompany,
  flwex.Material AS Material,
  flwex.BusinessArea AS BusinessArea,
  flwex.ProfitCenter AS ProfitCenter,
  flwex.Project AS WBSElementInternalID,
  flwex.CostCenter AS CostCenter,
  flwex.Segment AS Segment,
  flwex.LiquidityItem AS LiquidityItem,
  flwex.AssignedCompanyCode AS SourceCompanyCode,
  flwex.Fund AS Fund,
  flwex.GrantID AS GrantID,
  flwex.ContractNumber AS ContractNumber,
  flwex.ProductType AS ProductType,
  flwex.FinancialTransactionType AS FinancialTransactionType,
  flwex.SecurityClass AS SecurityClass,
  flwex.TrmSecurityAccount AS TrmSecurityAccount,
  flwex.Portfolio AS Portfolio,
  flwex.BankStatementShortKey AS BankStatementShortKey,
  flwex.BankStatementItem AS BankStatementItem,
  flwex.cmm_state AS cmm_state,
  cashrequest_status AS CashRequestStatus,
  instrument_category AS InstrumentCategory,
  buy_sell_indicator AS BuySellIndicator,
  cq_assignment AS CashRequestAssignment,
  cq_characteristics AS CashRequestCharacteristics,
  cq_internal_reference AS CashRequestInternalReference
FROM P_FqmflowCASH AS flwex
;