Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

laujerry
Contributor

sap table type and qlikview incremental load

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

Tags (2)
1 Solution

Accepted Solutions
yfe
Contributor III

Re: sap table type and qlikview incremental load

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

1 Reply
yfe
Contributor III

Re: sap table type and qlikview incremental load

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