I_CashFlowItem

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_CashFlowItem.
-- 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: ICCFI

CREATE VIEW I_CashFlowItem AS
SELECT
  CashFlowScopeForAccounting,
  cast(flow.ValidFrom as abap.char(27)) AS CashFlowSnapshotValue,
  cast(flow.CreatedByUser as fclm_bam_created_by) AS CreatedByUser,
  cast(flow.LastChangedByUser as fclm_bam_lastchgby) AS LastChangedByUser,
  cast(flow.TransactionDate as valut preserving type ) AS TransactionDate,
  cast(flow.AmountInTransactionCurrency as fclm_cp_trans_amount preserving type ) AS AmountInTransactionCurrency,
  cast(flow.CompanyCodeCurrency as fclm_cp_local_waers preserving type ) AS CompanyCodeCurrency,
  cast(flow.AmountInCompanyCodeCurrency as fclm_cp_local_amount preserving type ) AS AmountInCompanyCodeCurrency,
  cast(flow.AccountingDocument as fis_belnr preserving type ) AS AccountingDocument,
  cast(flow.AccountingDocumentItem as fclm_cp_buzei preserving type ) AS AccountingDocumentItem,
  cast(case when flow.PostingDate = '' then '00000000' else flow.PostingDate end as budat ) AS PostingDate,
  WBSElementInternalID,
  ExpirationDate,
  case when flow.CertaintyLevel = 'PAYRQ' then flow.OriginTransactionQualifier when flow.CertaintyLevel = 'PYORD' then flow.CashFlow when flow.CashTransactionOwner = 'AGG' then flow.CashFlow else substring(flow.CashFlow, 1, 3) end as OriginFlowID AS CashFlow13endasOriginFlowID,
  cast(coalesce(_PromiseToPay.Currency,'') as bdm_promise_curr) AS PromiseToPayCurrency,
  OriginApplication,
  OriginDocument,
  OriginTransaction,
  OriginTransactionQualifier,
  CashFlow,
  ValidFrom,
  ValidTo,
  CashFlowID,
  IsValid,
  CreationDateTime,
  LastChangeDateTime,
  CashTransactionOwner,
  CertaintyLevel,
  BankAccountCurrency,
  CashReleaseStatus,
  PaymentMethod,
  SourceCompanyCode,
  FinancialInstrumentProductType,
  FinancialTransactionType,
  SecurityClass,
  SecurityAccount,
  AssetContract,
  Portfolio,
  NetDueDate,
  OriginTransactionValue,
  OriginFlowID,
  OriginDocumentValue,
  BankStatementShortID,
  BankStatementItem,
  flow.OriginSystem AS OriginSystem,
  flow.CompanyCode AS CompanyCode,
  flow.TransactionCurrency AS TransactionCurrency,
  flow.FiscalYear AS FiscalYear,
  flow.PostingFiscalPeriod AS PostingFiscalPeriod,
  flow.AccountingDocumentType AS AccountingDocumentType,
  flow.GLAccount AS GLAccount,
  flow.FinancialAccountType AS FinancialAccountType,
  flow.DocumentItemText AS DocumentItemText,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  flow.DocumentDate AS DocumentDate,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.BankAccountInternalID AS BankAccountInternalID,
  flow.Customer AS Customer,
  flow.Supplier AS Supplier,
  flow.BusinessPartner AS BusinessPartner,
  flow.Material AS Material,
  flow.BusinessArea AS BusinessArea,
  flow.ProfitCenter AS ProfitCenter,
  flow.PartnerCompany AS PartnerCompany,
  flow.CostCenter AS CostCenter,
  flow.Segment AS Segment,
  flow.LiquidityItem AS LiquidityItem,
  flow.Fund AS Fund,
  flow.GrantID AS GrantID,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea
FROM I_CashFlowByScopeForAccounting AS flow
LEFT OUTER JOIN I_CashReconciliationsFlow AS _ReconciliationStatus ON CashFlowID = _ReconciliationStatus.CashFlowID AND ValidFrom = _ReconciliationStatus.ValidFrom  -- association [0..*]
LEFT OUTER JOIN I_CashFlowByScopeForAccounting AS _PaymentRequest ON OriginApplication = _PaymentRequest.OriginApplication AND OriginDocument = _PaymentRequest.OriginDocument AND OriginSystem = _PaymentRequest.OriginSystem AND OriginTransaction = _PaymentRequest.OriginTransaction AND ValidFrom = _PaymentRequest.ValidFrom AND ValidTo = _PaymentRequest.ValidTo AND TransactionDate = _PaymentRequest.TransactionDate AND CashFlowScopeForAccounting = _PaymentRequest.CashFlowScopeForAccounting AND OriginTransactionQualifier <> _PaymentRequest.OriginTransactionQualifier AND _PaymentRequest.CashFlow = '' AND _PaymentRequest.CertaintyLevel = 'PAYRQ' AND CertaintyLevel = 'PAYRQ'  -- association [0..1]
LEFT OUTER JOIN I_PromiseToPay AS _PromiseToPay ON OriginTransaction = _PromiseToPay.DisputeCaseUUID AND CertaintyLevel = 'FIP2P'  -- association [0..1]
LEFT OUTER JOIN I_PaymentBatchItem AS _PaymentBatchItem ON AccountingDocument = _PaymentBatchItem.AccountingDocument AND CompanyCode = _PaymentBatchItem.CompanyCode AND FiscalYear = _PaymentBatchItem.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_Arbankstatement AS _BankStatement ON BankStatementShortID = _BankStatement.BankStatementShortID  -- association [0..1]
LEFT OUTER JOIN I_Arbankstatementitem AS _BankStatementItem ON BankStatementShortID = _BankStatementItem.BankStatementShortID AND BankStatementItem = _BankStatementItem.BankStatementItem  -- association [0..1]
LEFT OUTER JOIN I_PaymentOrder AS _PaymentOrder ON OriginDocument = _PaymentOrder.PaymentOrder AND CertaintyLevel = 'PYORD'  -- association [0..1]
LEFT OUTER JOIN I_PaymentOrderItem AS _PaymentOrderItem ON OriginDocument = _PaymentOrderItem.PaymentOrder AND CompanyCode = _PaymentOrderItem.CompanyCode AND AccountingDocument = _PaymentOrderItem.AccountingDocument AND FiscalYear = _PaymentOrderItem.FiscalYear AND AccountingDocumentItem = _PaymentOrderItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_FinancialAccountType AS _AccTypeText ON FinancialAccountType = _AccTypeText.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedBy ON LastChangedByUser = _ChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CashReleaseStatusText AS _CashReleaseStatus ON CashReleaseStatus = _CashReleaseStatus.CashReleaseStatus  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItemText AS _LiquidityItemText ON LiquidityItem = _LiquidityItemText.LiquidityItem  -- association [0..*]
LEFT OUTER JOIN I_CertaintyLevelText AS _CertaintyLevelText ON CertaintyLevel = _CertaintyLevelText.CertaintyLevel  -- association [0..*]
LEFT OUTER JOIN I_CashPlanningGroupText AS _CashPlanningGroupText ON CashPlanningGroup = _CashPlanningGroupText.CashPlanningGroup  -- association [0..*]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON PlanningLevel = _PlanningLevelText.PlanningLevel  -- association [0..*]
LEFT OUTER JOIN I_BankAccountText AS _BankAccountText ON BankAccountInternalID = _BankAccountText.BankAccountInternalID  -- association [0..*]
LEFT OUTER JOIN I_SourceApplicationText AS _SourceApplicationText ON OriginApplication = _SourceApplicationText.SourceApplication  -- association [0..*]
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]
LEFT OUTER JOIN I_Fund AS _Fund ON _Fund.FinancialManagementArea = _CompanyCode.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON _FundText.FinancialManagementArea = _CompanyCode.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
-- UNION ALL with additional select branch(es): P_UnrealizedCrcyDiffFilter
;