SAP CIF_IMPRO IMod Reference Table for Retail Promotion Table data and field list

CIF_IMPRO is a standard SAP Table which is used to store IMod Reference Table for Retail Promotion data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CIF_IMPRO table consists of various fields, each holding specific information or linking keys about IMod Reference Table for Retail Promotion data available in SAP. These include MATNR (Material Number), WERKS (Plant), SEGMENT (Segment Number for Integration Model APO Interface), POS (Item Number for Integration Model APO Interface)... 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. .

CIF_IMPRO table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP CIF_IMPRO 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 CIF_IMPRO 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	Assigned to domain		MANDT
MATNR	Material Number	MATNR	CHAR	18	MARA	MATN1	MATNR	MAT	S_MAT1
WERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
SEGMENT	Segment Number for Integration Model APO Interface	CIFIMSEG	NUMC	4			NUMC4
POS	Item Number for Integration Model APO Interface	CIFIMPOS	INT4	10			CIFIMPOS

Key field

Non-key field

< CIF_IMPRGK - key for cif_imprg CIF_IMPVBE - IMod Reference Table for Production Supply Area >

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

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

SELECT SINGLE *
FROM CIF_IMPRO
INTO CORRESPONDING FIELDS OF WA_CIF_IMPRO
WHERE...

How to access SAP table CIF_IMPRO

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

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