Restrict data extraction

If you want to extract only a specific part of the table content, you can define data extraction conditions. You can limit the data volume to be extracted using a time stamp or integer value (e.g., a sequence).

To do so, specify the required conditions in the data source configuration using the condition element and the dataextractiontype attribute.

<datasource name="VBAP" type="JDBC" analysistype="DATA_ANALYTICS" dataextractiontype="TIME_BASED">

<realmtable tablename="VBAP">

<sourcetable tablename="VBAP2">

<condition logicaloperator="char_creationtimestamp" fieldname="AEDAT">

<value>yyyy-MM-dd</value>

</condition>

<sourcefield>AEDAT</sourcefield>

<sourcefield>ERDAT</sourcefield>

<sourcefield>ERNAM</sourcefield>

<sourcefield>ERZET</sourcefield>

<sourcefield>MATKL</sourcefield>

<sourcefield>MATNR</sourcefield>

<sourcefield>WERKS</sourcefield>

</sourcetable>

</realmtable>

...

</datasource>

The dataextractiontype attribute can have the following values in Data analytics data sources:

There is no check whether the data extraction condition used matches the data extraction type configured (dataextractiontype=). If the configuration is created using CTK, CTK ensures correct values. If the file is configured manually and a condition that does not match is used, an error may occur during data extraction.