Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Q: E-table vs F-table

Hi Experts,

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,

Mikael

replied

Hi

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:

Calculating size of CUBE & ODS

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

regards

gaurav

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question