SAP ABAP Table OPS_ADDRESS (Address details structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IPRT (Package) Application Development R/3 Plant Maintenance Print

Basic Data

Table Category	INTTAB	Structure
Structure	OPS_ADDRESS	Table Relationship Diagram
Short Description	Address details structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Address
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
4	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
5	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
6	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
7	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
8	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
9	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
10	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
11	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
13	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
14	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
15	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
16	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
17	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
18	TLX_NUMBER	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
19	TTX_NUMBER	☐	AD_TTXNMBR	TEXT30	CHAR	30	0	Teletex number
20	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
21	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
22	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
23	TZONSP	☐	TZONSP	TZNZONE	CHAR	6	0	Time zone for partner	TTZZ
24	DATUM	☐	SYDATUM	SYDATS	DATS	8	0	System Date
25	UZEIT	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
26	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
27	FENUM	☐	FENUM	NUMC4	NUMC	4	0	Notification Print Item Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OPS_ADDRESS	COUNTRY	T005	LAND1
2	OPS_ADDRESS	LANGU	T002	SPRAS
3	OPS_ADDRESS	MANDT	T000	MANDT
4	OPS_ADDRESS	REGION	T005S	BLAND
5	OPS_ADDRESS	TZONSP	TTZZ	TZONE

History

Last changed by/on	SAP	20130529
SAP Release Created in	700