P_CashFlowCombn

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_CashFlowCombn.
-- 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: PCSHFLWCOMBN

CREATE VIEW P_CashFlowCombn 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,
  flwex.Amount AS AmountInTransactionCurrency,
  flwex.BaseCurrency AS CompanyCodeCurrency,
  flwex.BaseAmount 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.fi_due_date AS fi_due_date,
  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,
  case when ( flwex.CertaintyLevel = 'MEMO' or flwex.CertaintyLevel = 'INTRAM' ) and flwex.fi_due_date > '00000000' then flwex.fi_due_date else cast('99991231' as abap.dats) end as ExpirationDate AS datsendasExpirationDate,
  cashrequest_status AS CashRequestStatus,
  instrument_category AS InstrumentCategory,
  buy_sell_indicator AS BuySellIndicator,
  cq_assignment AS CashRequestAssignment,
  cq_characteristics AS CashRequestCharacteristics,
  cast('99991231' as abap.dats) AS ExpirationDate,
  CashRequestInternalReference
FROM P_FqmflowCASH AS flwex
-- UNION ALL with additional select branch(es): P_CashRequestFollowingFlows
;