SAP table TIDX_PRICE_INDEX (Price Index Main Entity)

SAP table TIDX_PRICE_INDEX has 2 primary key fields being MANDT,INDEX_NAME.

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
INDEX_NAME Name of Price Index CHAR 15 0 TIDX_INDEX_NAME
INDEX_TEXT Index Text CHAR 30 0 TIDX_INDEX_TEXT
RATIO Index Base DEC 12 6 TIDX_RATIO
DAY_CONVENTION Days Method for Price Index NUMC 1 0 TIDX_DAY_CONVENTION
ROUNDING Rounding Rule for Price Index CHAR 2 0 TIDX_ROUNDING
02 Two decimal places
03 Three decimal places
04 Four decimal places
05 Five decimal places
06 Six decimal places
INTERPOLATION Interpolation Rule for Price Index CHAR 1 0 TIDX_INTERPOLATION
0 No Interpolation
1 Linear Interpolation of Danish Index-Linked Bonds
L Linear Interpolation
FREQUENCY Increment of Interpolation CHAR 1 0 TIDX_FREQUENCY
D Daily interpolation
PRICEINDEX_COMPOUND_FREQUENCY Compounding Frequency of Price Index Factors NUMC 3 0 TFM_PRICEINDEX_COMPOUNDFREQ
INDEX_FIX_DATE_DATESHIFT Working Day Shift for Calculation Day NUMC 1 0 TB_SVWERK
INDEX_FIX_DATE_SHIFTDAYS Number of Days for Relative Calculation of Value Date INT4 10 0 TB_AVGSTAG
SROUNDFACTOR Rounding Category of a Factor CHAR 1 0 TFM_SROUNDFACTOR
ROUNDDECFACTOR Number of Rounding Decimal Places for a Factor INT1 3 0 TFM_ROUNDDECFACTOR
SROUNDBASEFACTOR Rounding Category of a Base Factor CHAR 1 0 TFM_SROUNDBASEFACTOR
ROUNDDECBASEFACTOR Number of Rounding Decimal Places for a Base Factor INT1 3 0 TFM_ROUNDDECBASEFACTOR
SROUNDRATEFACTOR Rounding Category of Interest Factor CHAR 1 0 TFM_SROUNDRATEFACTOR
ROUNDDECRATEFACTOR Number of Rounding Decimal Places for Interest Factor INT1 3 0 TFM_ROUNDDECRATEFACTOR
SROUNDDAYFRACTION Day Fraction Rounding Category CHAR 1 0 TFM_SROUNDDAYFRACTION
ROUNDDECDAYFRACTION Number of Rounding Decimals for Day Fraction INT1 3 0 TFM_ROUNDDECDAYFRACTION
INDEX_INTERPOLATE Index Interpolation Method CHAR 4 0 TFM_INDEX_INTERPOLATE
Without Interpolation
EXP Exponential Interpolation
LIN Linear Interpolation
PRICEINDEX_APPLY Price Index Application Method CHAR 4 0 TFM_PRICEINDEX_APPLY
Price Index not Applied
BASE Price Index Applied on Base Amount
POST Price Index Applied on Index-Clean Amount