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.