SAP OPS_ADDRESS Address details structure Table data and field list

OPS_ADDRESS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Address details structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_OPS_ADDRESS TYPE OPS_ADDRESS.

The OPS_ADDRESS table consists of various fields, each holding specific information or linking keys about Address details structure data available in SAP. These include MANDT (Client), NAME1 (Name 1), NAME2 (Name 2), NAME3 (Name 3)... 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. .

OPS_ADDRESS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

SAP OPS_ADDRESS structure 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 OPS_ADDRESS 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
NAME1	Name 1	AD_NAME1	CHAR	40			TEXT40
NAME2	Name 2	AD_NAME2	CHAR	40			TEXT40
NAME3	Name 3	AD_NAME3	CHAR	40			TEXT40
NAME4	Name 4	AD_NAME4	CHAR	40			TEXT40
CITY1	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
CITY2	District	AD_CITY2	CHAR	40			TEXT40		CITY_PART
POST_CODE1	City postal code	AD_PSTCD1	CHAR	10			CHAR10
POST_CODE2	PO Box Postal Code	AD_PSTCD2	CHAR	10			CHAR10
COUNTRY	Country Key	LAND1	CHAR	3	T005		LAND1	LND
REGION	STATE (State, Province, County)	REGIO	CHAR	3	T005S		REGIO
STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
PO_BOX	PO Box	AD_POBX	CHAR	10			CHAR10
LANGU	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
TEL_NUMBER	First telephone no.: dialling code+number	AD_TLNMBR1	CHAR	30			CHAR30
FAX_NUMBER	First fax no.: dialling code+number	AD_FXNMBR1	CHAR	30			CHAR30
TLX_NUMBER	Telex number	AD_TLXNMBR	CHAR	30			TEXT30
TTX_NUMBER	Teletex number	AD_TTXNMBR	CHAR	30			TEXT30
SORT1	Search Term 1	AD_SORT1	CHAR	20			CHAR20
NAME_LIST	Name for list displays	I_NAME_LST	CHAR	35			NAME
REMARK	Address notes	AD_REMARK1	CHAR	50			TEXT50
TZONSP	Time Zone for Partner	TZONSP	CHAR	6	TTZZ		TZNZONE
DATUM	System Date	SYDATUM	DATS	8			SYDATS
UZEIT	System Time	SYUZEIT	TIMS	6			SYTIME
HOUSE_NUM1	House Number	AD_HSNM1	CHAR	10			TEXT10
FENUM	Notification Print Item Number	FENUM	NUMC	4			NUMC4	IFE

Key field

Non-key field

< OPSYS_GRPS - Syntax groups of operating systems OPS_AFFHD_PDF - Structure of the PRTs in Orders >

How do I retrieve data from SAP structure OPS_ADDRESS using ABAP code?

As OPS_ADDRESS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on OPS_ADDRESS as there is no data to select.

How to access SAP table OPS_ADDRESS

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

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