I_CashRecnclnCashFlowBasic

DDL: I_CASHRECNCLNCASHFLOWBASIC SQL: ICFLOWBSC Type: view BASIC
21 Fields 1 Data Sources

Cash Reconciliation Cash Flow

I_CashRecnclnCashFlowBasic is a Basic CDS View that provides data about "Cash Reconciliation Cash Flow" in SAP S/4HANA. It reads from 1 data source (P_CashFlowCombn) and exposes 21 fields with key fields CashFlowID, ValidFrom.

Data Sources (1)

SourceAliasJoin Type
P_CashFlowCombn one_exposure from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICFLOWBSC view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private false view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Cash Reconciliation Cash Flow view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CashFlowID P_CashFlowCombn flow_id Flow ID
KEY ValidFrom P_CashFlowCombn ValidFrom Vers.Valid From
ExpirationDate P_CashFlowCombn ExpirationDate Expiratn Date
OriginDocument P_CashFlowCombn OriginDocument
BankStatementShortID
TransactionDate P_CashFlowCombn TransactionDate Value Date
AmountInTransactionCurrency P_CashFlowCombn AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency P_CashFlowCombn TransactionCurrency Transaction Currency
DocumentItemText P_CashFlowCombn DocumentItemText Text
BankAccountInternalID P_CashFlowCombn BankAccountInternalID Technical ID
CompanyCode P_CashFlowCombn CompanyCode Receiver Company Code
BankStatementItem P_CashFlowCombn BankStatementItem Memo Record No.
PlanningLevel P_CashFlowCombn PlanningLevel Planning Level
LiquidityItem P_CashFlowCombn LiquidityItem Liquidity Item
MemoRecordStatisticItem P_CashFlowCombn cmm_statistics_indicator Statistics Ind.
MemoRecordStatus P_CashFlowCombn cmm_state State
CertaintyLevel P_CashFlowCombn CertaintyLevel
IsValid P_CashFlowCombn IsValid Truth Value
CashReleaseStatus P_CashFlowCombn rel_status Release Status
AccountingDocument P_CashFlowCombn AccountingDocument Journal Entry
OriginApplication P_CashFlowCombn OriginApplication Origin Application

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_CashRecnclnCashFlowBasic.
-- 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: ICFLOWBSC

CREATE VIEW I_CashRecnclnCashFlowBasic AS
SELECT
  one_exposure.flow_id AS CashFlowID,
  one_exposure.ValidFrom AS ValidFrom,
  one_exposure.ExpirationDate AS ExpirationDate,
  one_exposure.OriginDocument AS OriginDocument,
  cast( one_exposure.BankStatementShortKey as kukey_eb ) AS BankStatementShortID,
  one_exposure.TransactionDate AS TransactionDate,
  one_exposure.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  one_exposure.TransactionCurrency AS TransactionCurrency,
  one_exposure.DocumentItemText AS DocumentItemText,
  one_exposure.BankAccountInternalID AS BankAccountInternalID,
  one_exposure.CompanyCode AS CompanyCode,
  one_exposure.BankStatementItem AS BankStatementItem,
  one_exposure.PlanningLevel AS PlanningLevel,
  one_exposure.LiquidityItem AS LiquidityItem,
  one_exposure.cmm_statistics_indicator AS MemoRecordStatisticItem,
  one_exposure.cmm_state AS MemoRecordStatus,
  one_exposure.CertaintyLevel AS CertaintyLevel,
  one_exposure.IsValid AS IsValid,
  one_exposure.rel_status AS CashReleaseStatus,
  one_exposure.AccountingDocument AS AccountingDocument,
  one_exposure.OriginApplication AS OriginApplication
FROM P_CashFlowCombn AS one_exposure
;

Learn More