Q: E-table vs F-table
I have a question regarding size of F-table and E-table. I have run the program SAP_INFOCUBE_DESIGNS and can see number of records in the different tables.
As I understand, the E-table are for compressed entries and F-table is the original. Is this correct?
In most cases this seems logical, but in some cases the E-table is much bigger than the F-table, how can this be?
Thank you in advance,
You can find the table related to InfoCube by following the below mention naming convention.
/BI<C OR DIGIT>/<TABLE CODE><INFOCUBE><DIMENSION>
<C or digit>: C = Customer-defined InfoCube
Digit = SAP-defined InfoCube
<table code>: D = Dimension table
E = Compressed fact table
F = Uncompressed fact table
<InfoCube>: The name of the InfoCube without leading digits (if any)
<dimension>: (only used for dimension tables)
P = Package dimension
U = Unit dimension
T = Time dimension
0-9, A, B, C = User-defined dimension tables
And you can find info about the size of infocube:
F table will be there.
But u cant find the data.All the data will be moved to E table after compression.
U can juz check it up by giving the name of the Cube
bic(cubename)f.. after the compression.
in RSRV, run the test: All elementary > database > Database Info about Infoprovider tables. Supply the name of your cube and execute it.
(Take a look: How to use SAP_INFOCUBE_DESIGNS)
After compression you will have only entries in the E table.
Take a look: http://help.sap.com/saphelp_nw2004s/helpdata/en/ca/aa6437e7a4080ee10000009b38f842/frameset.htm