I_CashFlowTrainingData

DDL: I_CASHFLOWTRAININGDATA SQL: ICSHFLWTRNDATA Type: view COMPOSITE

training data for DALI ML

I_CashFlowTrainingData is a Composite CDS View that provides data about "training data for DALI ML" in SAP S/4HANA. It reads from 1 data source (I_CashFlow) and exposes 31 fields with key fields OriginApplication, OriginDocument, OriginTransaction, OriginTransactionQualifier, CashFlow.

1 data source(s) 31 fields

Data Sources (1)

SourceAliasJoin Type
I_CashFlow flow from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICSHFLWTRNDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label training data for DALI ML view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
Keys
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
LiquidityItem
CompanyCode I_CashFlow CompanyCode
TransactionDate
CertaintyLevel I_CashFlow CertaintyLevel
Currency I_CashFlow TransactionCurrency
PlanningLevel I_CashFlow PlanningLevel
CashPlanningGroup I_CashFlow CashPlanningGroup
GLAccount I_CashFlow GLAccount
BusinessPartner I_CashFlow BusinessPartner
Customer I_CashFlow Customer
Supplier I_CashFlow Supplier
PartnerCompany I_CashFlow PartnerCompany
CostCenter I_CashFlow CostCenter
ProfitCenter I_CashFlow ProfitCenter
Segment I_CashFlow Segment
BusinessArea I_CashFlow BusinessArea
Material I_CashFlow Material
WBSElement I_CashFlow WBSElementInternalID
HouseBankelseendasHouseBank
PaymentMethod I_CashFlow PaymentMethod
FinancialAccountType I_CashFlow FinancialAccountType
FinancialTransactionType I_CashFlow FinancialTransactionType
BankAccountInternalID I_CashFlow BankAccountInternalID
AccountingDocument I_CashFlow AccountingDocument 
@AbapCatalog.sqlViewName: 'ICSHFLWTRNDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'training data for DALI ML'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel: {
    usageType.sizeCategory: #XXL,
    usageType.serviceQuality: #X,
    usageType.dataClass: #MIXED}
define view I_CashFlowTrainingData
  as select from I_CashFlow as flow
{
------- Keys, Not for Features -------
  key flow.OriginSystem,
  key flow.OriginApplication,
  key flow.OriginDocument,
  key flow.OriginTransaction,
  key flow.OriginTransactionQualifier,
  key flow.CashFlow,
------------------------------------------------------------
  flow.LiquidityItem,
  
  case
    when flow.DocumentItemText = ''
        then flow.DocumentItemText
    else ''
  end as DocumentItemText,  //NfF    

  
  flow.CompanyCode,
  
  cast ('19000101' as fqm_transaction_date) as TransactionDate,
//  case

//    when flow.TransactionDate = ''

//        then flow.TransactionDate

//    else cast ''

//  end as TransactionDate,   //NfF

  
  flow.CertaintyLevel,
  
  flow.TransactionCurrency         as Currency,
  
  case
    when flow.AmountInTransactionCurrency = 0
        then flow.AmountInTransactionCurrency 
    else 0
  end                               as AmountInTransactionCurrency,    //NfF

  
  flow.PlanningLevel,
  
  flow.CashPlanningGroup,

  flow.GLAccount,
  
  flow.BusinessPartner,

  flow.Customer,

  flow.Supplier,

  flow.PartnerCompany,

  flow.CostCenter,

  flow.ProfitCenter,

  flow.Segment,

  flow.BusinessArea,

  flow.Material,

  flow.WBSElementInternalID         as WBSElement,

  case
    when flow.HouseBank = ''
        then flow.HouseBank 
    else ''
  end                               as HouseBank,    //NfF

  
  case
    when flow.HouseBankAccount = ''
        then flow.HouseBankAccount 
    else ''
  end                               as HouseBankAccount,    //NfF


  flow.PaymentMethod,

  flow.FinancialAccountType,

  flow.FinancialTransactionType,  
  
//      flow.CashFlowType,


//      _LiquidityItem.CashFlowDirection,


  flow.BankAccountInternalID,
  
  flow.AccountingDocument       //NfF

  
//      /* Associations */

//      _LiquidityItem

}
where
  flow.LiquidityItem <> ''
//  and (OriginApplication <> 'CMMRD' or OriginApplication <> 'BSEGV')

  ;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASHFLOW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More