I_CashFlowByScopeForAccounting

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 I_CashFlowByScopeForAccounting.
-- 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: ICSHFLWSCPFI

CREATE VIEW I_CashFlowByScopeForAccounting AS
SELECT
  flow.OriginSystem AS OriginSystem,
  flow.OriginApplication AS OriginApplication,
  flow.OriginDocument AS OriginDocument,
  flow.OriginTransaction AS OriginTransaction,
  flow.OriginTransQualifier AS OriginTransactionQualifier,
  flow.CashFlow AS CashFlow,
  flow.ValidFrom AS ValidFrom,
  flow.ValidTo AS ValidTo,
  CashFlowScopeForAccounting,
  flow.flow_id AS CashFlowID,
  flow.IsValid AS IsValid,
  flow.CreatedByUser AS CreatedByUser,
  flow.CreationDateTime AS CreationDateTime,
  flow.LastChangedByUser AS LastChangedByUser,
  flow.LastChangeDateTime AS LastChangeDateTime,
  flow.Owner AS CashTransactionOwner,
  flow.CompanyCode AS CompanyCode,
  flow.TransactionDate AS TransactionDate,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.Currency AS TransactionCurrency,
  flow.Amount AS AmountInTransactionCurrency,
  case when CertaintyLevel = 'CSHRQ' then cast('' as fqm_currency) else flow.BaseCurrency end AS CompanyCodeCurrency,
  case when CertaintyLevel = 'CSHRQ' then cast(0 as fqm_amount) else flow.BaseAmount end AS AmountInCompanyCodeCurrency,
  flow.rel_status AS CashReleaseStatus,
  flow.AccountingDocument AS AccountingDocument,
  flow.AccountingDocumentItem AS AccountingDocumentItem,
  flow.FiscalYear AS FiscalYear,
  flow.FiscalPeriod AS PostingFiscalPeriod,
  flow.AccountingDocumentType AS AccountingDocumentType,
  flow.PaymentMethodCode AS PaymentMethod,
  flow.GLAccount AS GLAccount,
  flow.FinancialAccountType AS FinancialAccountType,
  flow.DocumentItemText AS DocumentItemText,
  flow.PostingDate AS PostingDate,
  flow.DocumentDate AS DocumentDate,
  flow.ValueDate AS ValueDate,
  flow.fi_due_date AS NetDueDate,
  flow.PlanningGroup AS CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  flow.MemoRecordExpirationDateTime AS MemoRecordExpirationDateTime,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.BankAccountId AS BankAccountInternalID,
  flow.Customer AS Customer,
  flow.Vendor AS Supplier,
  flow.Partner AS BusinessPartner,
  flow.Material AS Material,
  flow.BusinessArea AS BusinessArea,
  flow.ProfitCenter AS ProfitCenter,
  cast(flow.Project as ps_s4_pspnr) AS WBSElementInternalID,
  flow.PartnerCompany AS PartnerCompany,
  flow.CostCenter AS CostCenter,
  flow.Segment AS Segment,
  flow.LiquidityItem AS LiquidityItem,
  flow.AssignedCompanyCode AS SourceCompanyCode,
  flow.Fund AS Fund,
  flow.GrantID AS GrantID,
  flow.ProductType AS FinancialInstrumentProductType,
  flow.FinancialTransactionType AS FinancialTransactionType,
  flow.SecurityClass AS SecurityClass,
  flow.TrmSecurityAccount AS SecurityAccount,
  flow.ContractNumber AS AssetContract,
  flow.Portfolio AS Portfolio,
  flow.RelatedOriginApplication AS RelatedOriginApplication,
  flow.RelatedOriginTransactionID AS RelatedOriginTransactionID,
  case when ( flow.CertaintyLevel = 'MEMO' or flow.CertaintyLevel = 'INTRAM' ) and flow.fi_due_date > '00000000' then flow.fi_due_date else cast('99991231' as abap.dats) end as ExpirationDate AS datsendasExpirationDate,
  cast( flow.BankStatementShortKey as kukey_eb ) AS BankStatementShortID,
  flow.BankStatementItem AS BankStatementItem,
  flow.reconciled_eod AS CashFlowIsEndOfDayReconciled,
  flow.bundle_eod AS CshFlwEODayRecnclnBundle,
  flow.reconciled_intraday AS CashFlowIsIntradayReconciled,
  flow.bundle_intraday AS CshFlwIntrdayRecnclnBundle
FROM P_FqmFlowScope AS flow
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _SourceCompanyCode ON SourceCompanyCode = _SourceCompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CashPlanningGroup AS _CashPlanningGroup ON CashPlanningGroup = _CashPlanningGroup.CashPlanningGroup  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _PlanningLevel ON PlanningLevel = _PlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItem AS _LiquidityItem ON LiquidityItem = _LiquidityItem.LiquidityItem  -- association [0..1]
LEFT OUTER JOIN I_Glaccountwithaccountcurrency AS _GLAccount ON CompanyCode = _GLAccount.CompanyCode AND GLAccount = _GLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND FiscalYear = _AccountingDocument.FiscalYear AND AccountingDocument = _AccountingDocument.AccountingDocument  -- association [0..1]
;