I_CashFlowItemTP

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_CashFlowItemTP.
-- 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.

CREATE VIEW I_CashFlowItemTP AS
SELECT
  flow.OriginSystem AS OriginSystem,
  OriginTransaction AS OriginTransactionValue,
  flow.OriginApplication AS OriginApplication,
  cast(flow.OriginDocument as fclm_cp_doc_id preserving type ) AS OriginDocument,
  cast(case when flow.CertaintyLevel = 'PYORD' then flow.CashFlow else flow.AccountingDocumentItem end as fqm_origin_flow_id) AS OriginFlowID,
  cast(flow.ValidFrom as abap.char(27)) AS CashFlowSnapshotValue,
  flow.TransactionDate AS TransactionDate,
  flow.OriginTransactionQualifier AS OriginTransactionQualifier,
  flow.CashFlowScopeForAccounting AS CashFlowScopeForAccounting,
  flow.OriginApplication AS SourceApplication,
  cast(flow.AccountingDocument as fclm_cp_doc_id ) AS OriginDocumentValue,
  flow.OriginTransaction AS OriginTransaction,
  case when flow.OriginApplication = 'CMMRD' and (flow.CertaintyLevel = 'MEMO' or flow.CertaintyLevel = 'CSHRQ' ) then flow.CashFlowID end AS CashFlowID,
  flow.ValidFrom AS ValidFrom,
  flow.ValidTo AS ValidTo,
  flow.CreatedByUser AS CreatedByUser,
  flow.LastChangedByUser AS LastChangedByUser,
  flow.LastChangeDateTime AS LastChangeDateTime,
  flow.IsValid AS IsValid,
  flow.CashTransactionOwner AS CashTransactionOwner,
  flow.CompanyCode AS CompanyCode,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.TransactionCurrency AS TransactionCurrency,
  flow.CompanyCodeCurrency AS CompanyCodeCurrency,
  flow.CashReleaseStatus AS CashReleaseStatus,
  cast(0 as fclm_cp_trans_amount) AS OpenAmountInTransCrcy,
  flow.FiscalYear AS FiscalYear,
  flow.AccountingDocument AS AccountingDocument,
  flow.AccountingDocumentItem AS AccountingDocumentItem,
  flow._AccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  _OperationalAcctgDocItem.PaymentMethod AS PaymentMethod,
  _OperationalAcctgDocItem.GLAccount AS GLAccount,
  _OperationalAcctgDocItem.DocumentItemText AS DocumentItemText,
  flow._AccountingDocument.PostingDate AS PostingDate,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  cast('0000' as fclm_revision preserving type ) AS BankAccountRevision,
  cast('' as abap.char(8)) AS BankStatementShortID,
  cast('' as abap.char(5)) AS BankStatementItem,
  ' ' AS Supplier,
  case when flow.CertaintyLevel = 'FIP2P' then flow.Customer end AS Customer,
  cast('' as bu_partner) AS BusinessPartner,
  cast('' as bukrs) AS SendingCompanyCode,
  ' ' AS PaymentOrigin,
  cast('' as bukrs) AS OffsettingCompanyCode,
  cast('' as fdlev) AS OffsettingPlanningLevel,
  cast('' as hkont) AS OffsettingAccount,
  cast('00000000' as fqm_transaction_date) AS OffsettingValueDate,
  cast('' as butxt) AS OffsettingCompanyCodeName,
  cast('' as etxtl) AS OffsettingPlanningLevelName,
  _PaymentOrder.PaymentRunDate AS PaymentRunDate,
  _PaymentOrder.PaymentRunID AS PaymentRunID,
  _PaymentOrder.DirectDebitPreNotification AS DirectDebitPreNotification,
  _PaymentOrderItem.OpenItemAccountNumber AS OpenItemAccountNumber,
  cast('' as vvsart) AS ProductType,
  cast('' as tb_sfhaart) AS FinancialTransactionType,
  cast('' as vvranlw) AS SecurityClass,
  cast('' as rldepo) AS SecurityAccount,
  cast('' as vertnr) AS AssetContract,
  cast('' as rportb) AS Portfolio,
  cast('' as abap.dats) AS ExpirationDate,
  cast('' as rassc ) AS PartnerCompany,
  cast('' as hbkid) AS HouseBank,
  cast('' as hktid ) AS HouseBankAccount,
  cast('' as fclm_bam_acc_id) AS BankAccountInternalID,
  cast('' as fclm_bank_acct_currency) AS BankAccountCurrency
LEFT OUTER JOIN I_CashFlowSubItemTP AS _SubItem ON OriginSystem = _SubItem.OriginSystem AND OriginTransactionValue = _SubItem.OriginTransactionValue AND OriginApplication = _SubItem.OriginApplication AND OriginDocument = _SubItem.OriginDocument AND OriginFlowID = _SubItem.OriginFlowID AND CashFlowSnapshotValue = _SubItem.CashFlowSnapshotValue AND TransactionDate = _SubItem.TransactionDate AND OriginTransactionQualifier = _SubItem.OriginTransactionQualifier AND CashFlowScopeForAccounting = _SubItem.CashFlowScopeForAccounting  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _AccTypeText ON FinancialAccountType = _AccTypeText.FinancialAccountType  -- association [0..1]
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_CertaintyLevelText AS _CertaintyLevelText ON CertaintyLevel = _CertaintyLevelText.CertaintyLevel  -- association [0..*]
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_PaymentBatchItem AS _PaymentBatchItem ON AccountingDocument = _PaymentBatchItem.AccountingDocument AND CompanyCode = _PaymentBatchItem.CompanyCode AND FiscalYear = _PaymentBatchItem.FiscalYear  -- 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_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_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 OriginTransactionValue = _PromiseToPay.DisputeCaseUUID AND CertaintyLevel = 'FIP2P'  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _PlanningLevel ON PlanningLevel = _PlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _FinancialAccountTypeText ON FinancialAccountType = _FinancialAccountTypeText.FinancialAccountType  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountText ON CompanyCode = _GLAccountText.CompanyCode AND glaccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON accountingdocumenttype = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
;