I_RelCashFlowMD

DDL: I_RELCASHFLOWMD SQL: IRCFMD Type: view COMPOSITE

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.

1 data source(s) 25 fields

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
KEY OriginApplication I_CashFlow OriginApplication
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
KEY ValidTo I_CashFlow ValidTo
CompanyCode I_CashFlow CompanyCode
TransactionDate I_CashFlow TransactionDate
BankAccountInternalID I_CashFlow BankAccountInternalID
TransactionCurrency I_CashFlow TransactionCurrency
CertaintyLevel I_CashFlow CertaintyLevel
CashPlanningGroup I_CashFlow CashPlanningGroup
PlanningLevel I_CashFlow PlanningLevel
LiquidityItem I_CashFlow LiquidityItem
AmountInTransactionCurrency I_CashFlow AmountInTransactionCurrency
ExpirationDate I_CashFlow ExpirationDate
IsValid I_CashFlow IsValid
CashReleaseStatus I_CashFlow CashReleaseStatus
_CompanyCode I_CashFlow _CompanyCode
_CashPlanningGroup I_CashFlow _CashPlanningGroup
_LiquidityItem I_CashFlow _LiquidityItem
_PlanningLevel I_CashFlow _PlanningLevel
_BankAccount I_CashFlow _BankAccount 
@AbapCatalog.sqlViewName: 'IRCFMD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Release Cash Flows'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
    usageType.sizeCategory: #XXL,
    usageType.serviceQuality: #D,
    usageType.dataClass: #MIXED
}
define view I_RelCashFlowMD
  as select from I_CashFlow as fqm_flow
{
  key fqm_flow.OriginSystem,
  key fqm_flow.OriginApplication,
  key fqm_flow.OriginDocument,
  key fqm_flow.OriginTransaction,
  key fqm_flow.OriginTransactionQualifier,
  key fqm_flow.CashFlow,
  key fqm_flow.ValidFrom,
  key fqm_flow.ValidTo,
      fqm_flow.CompanyCode,
      fqm_flow.TransactionDate,
      fqm_flow.BankAccountInternalID,
      fqm_flow.TransactionCurrency,
      fqm_flow.CertaintyLevel,
      fqm_flow.CashPlanningGroup,
      fqm_flow.PlanningLevel,
      fqm_flow.LiquidityItem,
      fqm_flow.AmountInTransactionCurrency,
      fqm_flow.ExpirationDate,
      fqm_flow.IsValid,
      fqm_flow.CashReleaseStatus,
      fqm_flow._CompanyCode,
      fqm_flow._CashPlanningGroup,
      fqm_flow._LiquidityItem,
      fqm_flow._PlanningLevel,
      fqm_flow._BankAccount
}
where
      IsValid        = 'X'
  and ExpirationDate >= $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASHFLOW"
],
"ASSOCIATED":
[
"I_BANKACCOUNT",
"I_CASHPLANNINGGROUP",
"I_COMPANYCODE",
"I_LIQUIDITYITEM",
"I_PLANNINGLEVEL"
],
"BASE":
[
"I_CASHFLOW"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More