C_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 C_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.
-- SQL view name: CCCFITP

CREATE VIEW C_CashFlowItemTP AS
SELECT
  cast(flow.OriginSystem as fclm_cp_origin_system preserving type ) AS OriginSystem,
  cast(flow.OriginTransactionValue as fclm_cp_trans_id preserving type ) AS OriginTransactionValue,
  flow.OriginApplication AS OriginApplication,
  flow.OriginDocument AS OriginDocument,
  OriginFlowID,
  flow.CashFlowSnapshotValue AS CashFlowSnapshotValue,
  flow.TransactionDate AS TransactionDate,
  flow.OriginTransactionQualifier AS OriginTransactionQualifier,
  flow.CashFlowScopeForAccounting AS CashFlowScopeForAccounting,
  flow.ValidFrom AS ValidFrom,
  flow.CashFlowID AS CashFlowID,
  flow.ValidTo AS ValidTo,
  flow._SourceApplicationText[1:Language = $session.system_language].SourceApplicationText AS SourceApplicationText,
  flow.OriginDocumentValue AS OriginDocumentValue,
  flow.OriginDocumentValue AS RealEstateContract,
  OriginDocument AS CashMemoRecordID,
  flow.OriginDocumentValue AS PaymentRequest,
  flow.OriginTransaction AS OriginTransaction,
  flow.CashTransactionOwner AS CashTransactionOwner,
  flow.CompanyCode AS CompanyCode,
  flow._CompanyCode.CompanyCodeName AS CompanyCodeName,
  flow.CertaintyLevel AS CertaintyLevel,
  flow.AccountingDocument AS AccountingDocument,
  flow.AccountingDocument AS RefAccountingDocument,
  flow.AccountingDocumentItem AS AccountingDocumentItem,
  flow.BankAccountRevision AS BankAccountRevision,
  flow.FiscalYear AS FiscalYear,
  flow._AccountingDocument.DocumentDate AS DocumentDate,
  flow._AccountingDocument.TransactionCode AS TransactionCode,
  flow._AccountingDocument.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  flow.AccountingDocumentType AS AccountingDocumentType,
  cast(cast(cast(flow._AccountingDocument.FiscalPeriod as abap.int1) as abap.char( 3 )) as fclm_cp_monat preserving type) AS FiscalPeriod,
  flow.GLAccount AS GLAccount,
  flow.DocumentItemText AS CashJournalDocumentItemText,
  flow.PostingDate AS PostingDate,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow._CashPlanningGroupText[1:Language = $session.system_language].CashPlanningGroupDescription AS CashPlanningGroupDescription,
  flow.PlanningLevel AS PlanningLevel,
  flow._PlanningLevel._Text[1:Language = $session.system_language].PlanningLevelName AS PlanningLevelName,
  TransactionCurrency,
  Customer,
  flow.PaymentOrigin AS PaymentOrigin,
  PaymentRunDate,
  PaymentRunID,
  DirectDebitPreNotification,
  flow.FinancialAccountType AS FinancialAccountType,
  OpenItemAccountNumber,
  _PromiseToPay.LastPaymentDate AS LastPaymentDate,
  _PromiseToPay.NumberOfInstallments AS NumberOfInstallments,
  _PromiseToPay.PromiseToPayLevel AS PromiseToPayLevel,
  _PromiseToPay.PromisedAmount AS PromisedAmount,
  _PromiseToPay.Currency AS PromiseToPayCurrency,
  _PromiseToPay.Status AS PromiseToPayStatus,
  _PaymentBatchItem.PaymentBatch AS PaymentBatch,
  _PaymentBatchItem.PaymentBatchItem AS PaymentBatchItem,
  _PaymentBatchItem.PaymentBatchStatus AS PaymentBatchStatus,
  _PaymentBatchItem.PaymentBatchStatusText AS PaymentBatchStatusText,
  _PaymentBatchItem.PaymentBatchItemStatus AS PaymentBatchItemStatus,
  _PaymentBatchItem.PaymentBatchItemStatusText AS PaymentBatchItemStatusText,
  _PaymentBatchItem.PaymentBatchUrgency AS PaymentBatchUrgency,
  flow.CreatedByUser AS CreatedByUser,
  flow._CreatedBy.UserDescription AS CreatedByUserDescription,
  flow.LastChangedByUser AS LastChangedByUser,
  flow._ChangedBy.UserDescription AS LastChangedByUserFullName,
  cast(cast(0 as abap.curr(23,2)) as fclm_cp_trans_amount preserving type ) AS AmountInTransactionCurrency,
  cast(cast(0 as abap.curr(23,2)) as fclm_cp_trans_amount preserving type ) AS OpenAmountInTransCrcy,
  HouseBank,
  HouseBankAccount,
  flow.BankAccountInternalID AS BankAccountInternalID,
  BankAccountCurrency,
  cast('' as bankk) AS Bank,
  cast('' as banks) AS BankCountry,
  cast('' as swift) AS SWIFTCode,
  cast('' as banka) AS BankName,
  cast('' as fclm_bam_acc_num) AS BankAccountNumber,
  cast('' as fclm_bam_description) AS BankAccountDescription,
  cast('' as iban) AS IBAN,
  cast('' as fclm_bam_bk_acc_type_id) AS BankAccountType,
  cast('' as fclm_bam_bk_acc_type_desc) AS BankAccountTypeText,
  cast('' as fclm_cp_doc_id) AS SalesOrder,
  cast('' as fclm_cp_doc_id) AS SalesSchedulingAgreement,
  cast('' as fclm_cp_doc_id) AS PurchaseOrder,
  cast('' as fclm_cp_doc_id) AS PurchaseRequisition,
  cast('' as fclm_cp_doc_id) AS SchedulingAgreement
FROM I_CashFlowItemTP AS flow
LEFT OUTER JOIN C_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 [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..*]
;