SAP table LISR (Planning Object Index for Forecast)

SAP table LISR has 4 primary key fields being MANDT,PLOBJ,VRSIO,KEYFNA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PLOBJ Planning object CHAR 18 0 PLOBJ
VRSIO Version number in the information structure CHAR 3 0 P44V VRSIO
KEYFNA Field name in the generated DDIC structure CHAR 30 0 * STFNA
PNUM1 Pointer: forecast parameters NUMC 10 0 PROP PNUM1
GSTRU Generated DDIC table for LIS, conditions, messages CHAR 30 0 * GSTRU
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
DATUM System Date DATS 8 0 SYDATUM
UZEIT System Time TIMS 6 0 SYUZEIT
BATCH Single-Character Flag CHAR 1 0 CHAR1

LISR foreign key relationships

Table Field Check Table Check Field
0 LISR MANDT T000 Clients MANDT
1 LISR PERIV T009 Fiscal Year Variants MANDT
1 LISR PERIV T009 Fiscal Year Variants PERIV
0 LISR PNUM1 PROP Forecast Parameters MANDT
0 LISR PNUM1 PROP Forecast Parameters HSNUM
0 LISR PNUM1 PROP Forecast Parameters VERSP
1 LISR VRSIO P44V Planning Versions MANDT
1 LISR VRSIO P44V Planning Versions VRSIO