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
  flow.OriginSystem AS OriginSystem,
  flow.OriginDocument AS OriginDocument,
  flow.OriginTransaction AS OriginTransaction,
  flow.OriginTransactionQualifier AS OriginTransactionQualifier,
  flow.CashFlow AS CashFlow,
  flow.ValidFrom AS ValidFrom,
  flow.ValidTo AS ValidTo,
  CashFlowScopeForAccounting,
  flow.CashFlowID AS CashFlowID,
  cast(flow.ValidFrom as abap.char(27)) AS CashFlowSnapshotValue,
  flow.IsValid AS IsValid,
  cast(flow.CreatedByUser as fclm_bam_created_by) AS CreatedByUser,
  flow.CreationDateTime AS CreationDateTime,
  cast(flow.LastChangedByUser as fclm_bam_lastchgby) AS LastChangedByUser,
  flow.LastChangeDateTime AS LastChangeDateTime,
  flow.CashTransactionOwner AS CashTransactionOwner,
  flow.CompanyCode AS CompanyCode,
  cast(flow.TransactionDate as valut preserving type ) AS TransactionDate,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.TransactionCurrency AS TransactionCurrency,
  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,
  flow.CashReleaseStatus AS CashReleaseStatus,
  cast(flow.AccountingDocument as fis_belnr preserving type ) AS AccountingDocument,
  cast(flow.AccountingDocumentItem as fclm_cp_buzei preserving type ) AS AccountingDocumentItem,
  flow.FiscalYear AS FiscalYear,
  flow.PostingFiscalPeriod AS PostingFiscalPeriod,
  flow.AccountingDocumentType AS AccountingDocumentType,
  flow.PaymentMethod AS PaymentMethod,
  flow.GLAccount AS GLAccount,
  flow.FinancialAccountType AS FinancialAccountType,
  flow.DocumentItemText AS DocumentItemText,
  cast(case when flow.PostingDate = '' then '00000000' else flow.PostingDate end as budat ) AS PostingDate,
  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,
  WBSElementInternalID,
  flow.PartnerCompany AS PartnerCompany,
  flow.CostCenter AS CostCenter,
  flow.Segment AS Segment,
  flow.LiquidityItem AS LiquidityItem,
  flow.SourceCompanyCode AS SourceCompanyCode,
  flow.Fund AS Fund,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  flow.GrantID AS GrantID,
  flow.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  flow.FinancialTransactionType AS FinancialTransactionType,
  flow.SecurityClass AS SecurityClass,
  flow.SecurityAccount AS SecurityAccount,
  flow.AssetContract AS AssetContract,
  flow.Portfolio AS Portfolio,
  ExpirationDate,
  flow.NetDueDate AS NetDueDate,
  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,
  BankAccountCurrency,
  OriginTransactionValue,
  OriginFlowID,
  OriginDocumentValue,
  BankStatementShortID,
  BankStatementItem
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
;