SAP TPIS3 Assignmnt Table: Statistical Key Figures -> Value Categories Table data and field list

TPIS3 is a standard SAP Table which is used to store Assignmnt Table: Statistical Key Figures -> Value Categories data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TPIS3 table consists of various fields, each holding specific information or linking keys about Assignmnt Table: Statistical Key Figures -> Value Categories data available in SAP. These include APPL (User component), KOKRS (Controlling Area), ACPOS (Value category), LFDNR (Sequence Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

TPIS3 table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP TPIS3 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TPIS3 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
APPL	User component	PS_APPL	CHAR	2			PS_APPL
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
ACPOS	Value category	ACPOS	CHAR	14	TPIR2		ACPOS
LFDNR	Sequence Number	LFDNR	CHAR	3			LFDNR
STGRF	From Statistical Key Figure	STGRF	CHAR	6	TKA03		STAGR
STGRT	To statistical key figure	STGRT	CHAR	6	TKA03		STAGR
LINEX	Suppress line	KATEX	CHAR	1			KREUZ

Key field

Non-key field

< TPIRX - Control RPSCO Update TPITROWA - Table Painter line with attributes (int. for templates) >

How do I retrieve data from SAP table TPIS3 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TPIS3 to SELECT all data from the table
DATA: WA_TPIS3 TYPE TPIS3.

SELECT SINGLE *
FROM TPIS3
INTO CORRESPONDING FIELDS OF WA_TPIS3
WHERE...

How to access SAP table TPIS3

Within an ECC or HANA version of SAP you can also view further information about TPIS3 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).