SAP ABAP Table TA23OFFICE_ADR (Sales Office Addresses)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP_ADDON (Package) Travel Planning Add-On

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TA23OFFICE_ADR	Table Relationship Diagram
Short Description	Sales Office Addresses

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	GDS	☑	RESERVATION_SYSTEM	FTPD_PROVIDER_CODE	CHAR	3	0	Reservation System	*
3	OFFICE	☑	OFFICE	FTPD_OFFICE_ID	CHAR	12	0	Sales Office	TA20OFFICE
4	ADDRESS_TYPE	☑	OFFICE_ADDRESS_TYPE	FTPD_OFFICE_ADDRESS_TYPE	CHAR	1	0	Sales Office Address: Address Type
5	NAME	☐	OFFICE_ADDRESS_NAME	TEXT60	CHAR	60	0	Sales Office Address: Address Name
6	STREETNBR	☐	OFFICE_ADDRESS_STREET	TEXT60	CHAR	60	0	Sales Office Address: Street/House Number
7	CITY	☐	OFFICE_ADDRESS_CITY	TEXT60	CHAR	60	0	Sales Office Address: City
8	PLZ	☐	OFFICE_ADDRESS_POSTCODE	TEXT10	CHAR	10	0	Sales Office Address: Postal Code (ZIP Code)
9	REGIO	☐	OFFICE_ADDRESS_REGIO	TEXT6	CHAR	6	0	Sales Office Address: Region/Area/Country

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA23OFFICE_ADR	OFFICE	TA20OFFICE	OFFICE	KEY	1	CN

History

Last changed by/on	SAP	20041006
SAP Release Created in	500