SAP ECROSSREFNO Reference Number for IDoc Table data and field list

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

The ECROSSREFNO table consists of various fields, each holding specific information or linking keys about Reference Number for IDoc data available in SAP. These include INT_CROSSREFNO (IDE: internal cross reference number), INT_UI (Internal key for point of delivery), KEYDATE (End of billing period), CROSSREFNO (IDE: cross reference 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. .

ECROSSREFNO 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)

SAP ECROSSREFNO 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 ECROSSREFNO 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
INT_CROSSREFNO	IDE: internal cross reference number	INT_CROSSREFNO	CHAR	12
INT_UI	Internal key for point of delivery	INT_UI	CHAR	22	Assigned to domain		INT_POD
KEYDATE	End of billing period	ENDABRPE	DATS	8			DATUM
CROSSREFNO	IDE: cross reference number	CROSSREFNO	CHAR	30
ABRDATS	Scheduled Billing Date	ABRDATS	DATS	8			DATUM	ABRDATS
CANCEL	Indicators	KENNZX	CHAR	1			KENNZX
CREATED_FROM	Process That Created the Entry in the Table	CREATED_FROM	CHAR	1			CREATED_FROM
VERTRAG	Contract	VERTRAG	CHAR	10	Assigned to domain	ALPHA	VERTRAG	VTG	EVER
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
AEDAT	Changed On	AEDAT	DATS	8			DATUM
AENAM	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
BELNR	Number of a billing document	E_BELNR	CHAR	12		ALPHA	E_BELNR	BEL	ERCH
CRN_REV	IDE: cross reference number	CROSSREFNO	CHAR	30

Key field

Non-key field

< ECRM_TEMP_OBJ - CRM Integration: Clipboard for Technical Objects ECRP_DEF - OBSOLETE - >

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

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

SELECT SINGLE *
FROM ECROSSREFNO
INTO CORRESPONDING FIELDS OF WA_ECROSSREFNO
WHERE...

How to access SAP table ECROSSREFNO

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

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