sap table type and qlikview incremental load

[laujerry]

as far as i know that there are 3 kind of tables in sap: transparent, clustered and pooled

and we have to use special techniques when incremental-loading a cluster table (subselect)

so how do i identify that which table type a certain sap belongs to?

now i would like to implement the incremental load of table vbpa

so on the absence of create and update time field, from which table should i retrieve these info?

from vbak or vbap, or any other better // more proper solution?

thank you for you help

[Anonymous · Accepted solution]

Hi

In order to see the table type:

In SAP, go to SE11 - type in the table name

In the table details, go to "Technical Settings' - you will see beside the table name it's type (Cluster table, Pool table etc...)

Yaniv