I_CashFlowDeltaData

DDL: I_CASHFLOWDELTADATA SQL: ICASHFLWDEL Type: view BASIC

Delta Extraction Cash FLow

I_CashFlowDeltaData is a Basic CDS View (Cube) that provides data about "Delta Extraction Cash FLow" in SAP S/4HANA. It reads from 1 data source (fqm_flow) and exposes 9 fields with key fields CashFlowID, ValidFrom.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
fqm_flow fqm_flow from

Annotations (17)

NameValueLevelField
EndUserText.label Delta Extraction Cash FLow view
AbapCatalog.sqlViewName ICASHFLWDEL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CashFlowID fqm_flow flow_id
KEY ValidFrom fqm_flow valid_from
CompanyCode fqm_flow company_code
OriginSystem fqm_flow origin_system
OriginApplication fqm_flow origin_application
OriginDocument fqm_flow origin_document_id
OriginTransaction fqm_flow origin_transaction_id
OriginTransactionQualifier fqm_flow origin_trans_qualifier
CashFlow fqm_flow origin_flow_id 
//////////////////////////////////////////////////////////////////////////////

// Documentation: This view does not implement the logic for valid cash flows

// but simply for purpose of replicating fqm_flow data without much calculation

//////////////////////////////////////////////////////////////////////////////

@EndUserText.label: 'Delta Extraction Cash FLow' 
@AbapCatalog.sqlViewName: 'ICASHFLWDEL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY

@Analytics:{
    dataCategory: #CUBE,
    internalName: #LOCAL,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[
                  { 
                    table: 'FQM_FLOW',
                    role: #MAIN,
                    viewElement: ['CashFlowID', 'ValidFrom'],
                    tableElement: ['flow_id', 'valid_from']
                  }
                    ]
        }
    }
}

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.allowExtensions:true
@ObjectModel: { // representativeKey: 'CashFlowID',

                usageType.sizeCategory: #XXL,
                usageType.dataClass:  #TRANSACTIONAL,
                usageType.serviceQuality: #D,
                supportedCapabilities: [#ANALYTICAL_PROVIDER,
                                      //  #ANALYTICAL_DIMENSION, 

                                        #CDS_MODELING_ASSOCIATION_TARGET, 
                                        #CDS_MODELING_DATA_SOURCE,
                                        #EXTRACTION_DATA_SOURCE,
                                         #SQL_DATA_SOURCE],
                modelingPattern:  #ANALYTICAL_DIMENSION }

//@ObjectModel.sapObjectNodeType.name: 'CashFLow'   

define view I_CashFlowDeltaData
    as select from fqm_flow as fqm_flow
{
 key  fqm_flow.flow_id                   as CashFlowID,
 key  fqm_flow.valid_from                as ValidFrom,
 
      fqm_flow.company_code              as CompanyCode,
      fqm_flow.origin_system             as OriginSystem,
      fqm_flow.origin_application        as OriginApplication,
      fqm_flow.origin_document_id        as OriginDocument,
      fqm_flow.origin_transaction_id     as OriginTransaction,
      fqm_flow.origin_trans_qualifier    as OriginTransactionQualifier,
      fqm_flow.origin_flow_id            as CashFlow
      
  }

Learn More