what is " L" Table ?

[Former Member]

Hi Experts,

Can any one let me know about the L - Table. In which data target we can find L - Table. What is the use of that table ?

In the last week i have faced one interview in that they have asked about this ?

Dont feel wrong about this i need all your help.

when i was go throughing the 360 Tab material in that i have seen this L - Table.

Thanks and Regards

Vara

[edwin_harpino]

hi Vara,

i think it's 'validity date' table in non cumulative cube (e.g stock infocube),

you can try se11 in bw, /bic/L* and f4 or /bi0/L*

http://help.sap.com/saphelp_nw2004s/helpdata/en/af/4e183824234d36e10000009b38f8cf/frameset.htm

For the non-cumulative values contained in the InfoCube, a validity table is created, in which the time interval is stored, for which the non-cumulative values are valid. Apart from the reference characteristic for time-based aggregation, which is always implicitly inserted in the validity table, this table can contain other additional characteristics

hope this helps.

[Former Member]

Hello

How r u ?

I have seen these "L" Tables in FI & HR related Cubes.

/BI0/L0FIAR_C03 - FI-AR: Separate posting

/BI0/L0PAPA_C02 - Manpower.

In these 2 tables i could find

MODEFROM CHAR 1 0 Mode for 'from' time

MODETO CHAR 1 0 Mode for 'to' time

The Values for these fields are " ", "F" & "R".

" " - Delta Update

"F" - Fixed Value

"R" - Relative to Current Date

****

On analyzing more on the Domain it says these are "Modes for the validity slice", something related to the Time. Also some SID fields are also there. Its Conformed its somewhere inbetween the Dimension and the Master Data Tables.

****

I do not know why it is used and other stuff about that.

Best Regards....

Sankar Kumar

+91 98403 47141