Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
laujerry
Creator
Creator

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

1 Reply
Anonymous
Not applicable

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