on 05-16-2008 6:47 AM
I need to read data at the database level from a cluster table. That is to say, I want to decompress the VARDATA column that is in
the database table and interpreet it with my own code.
I've read all the SAP help documents on the subject, and I have created a test Table Cluster (the physical object) and associated test Cluster Tables (the logical tables) with the Table Cluster, but the data is compressed at the at the database level and incomprehensible.
I realize one can use ABAP and OPEN SQL to read the table, because that goes through the SAP database interface. I could
also call a BAPI from an external program, but I don't want to do that.
I need to read the data directly from the database without going through the SAP database interface or calling any SAP code. I
am willing to write the required code in another language, I just need to know how the data is compressed in the cluster, so I can
decompress it.
1. Does anyone know how to decode the information stored in a table cluster WITHOUT using SAP code?
2. If no one knows how to do (1), does anyone know what compression algorithm SAP uses when storing data in the table cluster?
3. Is there a specification or layout that explains exactly how the VARDATA column in a table cluster is structured, so that once I
decompress it, I can figure out what data belonged to which table and column?
If you even have a guess as to the compression algorithm or layout of VARDATA, I would be interested to hear it.
Thank You,
Larry Smith
I need to read data at the database level from a cluster table. That is to say, I want to decompress the VARDATA column that is in the database table and interpreet it with my own code.
You cant. (full stop)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
The question is still open, waiting for points to be awarded. Fidel's answer didn't really help. I already know that I currently can't read the cluster, that's why I posted the question.
I would think SAP uses a known compression algorithm for the clusters, so the most important thing is finding out what the algorithm is, and finding out if SAP does anything weird to the compression headers.
Someone has to know out there!
Thank You,
Larry Smith
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.