I_RelCashFlowMD

DDL: I_RELCASHFLOWMD SQL: IRCFMD Type: view COMPOSITE
25 Fields 1 Data Sources

Release Cash Flows

I_RelCashFlowMD is a Composite CDS View that provides data about "Release Cash Flows" in SAP S/4HANA. It reads from 1 data source (I_CashFlow) and exposes 25 fields with key fields OriginSystem, OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier.

Data Sources (1)

SourceAliasJoin Type
I_CashFlow fqm_flow from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IRCFMD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Release Cash Flows view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY OriginSystem I_CashFlow OriginSystem LogSys: Formula
KEY OriginApplication I_CashFlow OriginApplication Origin Application
KEY OriginDocument I_CashFlow OriginDocument
KEY OriginTransaction I_CashFlow OriginTransaction
KEY OriginTransactionQualifier I_CashFlow OriginTransactionQualifier
KEY CashFlow I_CashFlow CashFlow
KEY ValidFrom I_CashFlow ValidFrom Vers.Valid From
KEY ValidTo I_CashFlow ValidTo Vers.Valid To
CompanyCode I_CashFlow CompanyCode Receiver Company Code
TransactionDate I_CashFlow TransactionDate Value Date
BankAccountInternalID I_CashFlow BankAccountInternalID Technical ID
TransactionCurrency I_CashFlow TransactionCurrency Transaction Currency
CertaintyLevel I_CashFlow CertaintyLevel
CashPlanningGroup I_CashFlow CashPlanningGroup Planning Group
PlanningLevel I_CashFlow PlanningLevel Planning Level
LiquidityItem I_CashFlow LiquidityItem Liquidity Item
AmountInTransactionCurrency I_CashFlow AmountInTransactionCurrency Pt Crcy Amt
ExpirationDate I_CashFlow ExpirationDate Expiratn Date
IsValid I_CashFlow IsValid Truth Value
CashReleaseStatus I_CashFlow CashReleaseStatus Release Status
_CompanyCode I_CashFlow _CompanyCode
_CashPlanningGroup I_CashFlow _CashPlanningGroup
_LiquidityItem I_CashFlow _LiquidityItem
_PlanningLevel I_CashFlow _PlanningLevel
_BankAccount I_CashFlow _BankAccount

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_RelCashFlowMD.
-- 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: IRCFMD

CREATE VIEW I_RelCashFlowMD AS
SELECT
  fqm_flow.OriginSystem AS OriginSystem,
  fqm_flow.OriginApplication AS OriginApplication,
  fqm_flow.OriginDocument AS OriginDocument,
  fqm_flow.OriginTransaction AS OriginTransaction,
  fqm_flow.OriginTransactionQualifier AS OriginTransactionQualifier,
  fqm_flow.CashFlow AS CashFlow,
  fqm_flow.ValidFrom AS ValidFrom,
  fqm_flow.ValidTo AS ValidTo,
  fqm_flow.CompanyCode AS CompanyCode,
  fqm_flow.TransactionDate AS TransactionDate,
  fqm_flow.BankAccountInternalID AS BankAccountInternalID,
  fqm_flow.TransactionCurrency AS TransactionCurrency,
  fqm_flow.CertaintyLevel AS CertaintyLevel,
  fqm_flow.CashPlanningGroup AS CashPlanningGroup,
  fqm_flow.PlanningLevel AS PlanningLevel,
  fqm_flow.LiquidityItem AS LiquidityItem,
  fqm_flow.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  fqm_flow.ExpirationDate AS ExpirationDate,
  fqm_flow.IsValid AS IsValid,
  fqm_flow.CashReleaseStatus AS CashReleaseStatus,
  fqm_flow._CompanyCode AS _CompanyCode,
  fqm_flow._CashPlanningGroup AS _CashPlanningGroup,
  fqm_flow._LiquidityItem AS _LiquidityItem,
  fqm_flow._PlanningLevel AS _PlanningLevel,
  fqm_flow._BankAccount AS _BankAccount
FROM I_CashFlow AS fqm_flow
;

Learn More