SAP ABAP Table T5N9A (Authority Addresses (NL))

Hierarchy

☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PA-PA-NL (Application Component) Netherlands
     ⤷ PB05 (Package) HR Master Data: Netherlands

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5N9A	Table Relationship Diagram
Short Description	Authority Addresses (NL)

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	T000
2	SOORT	☑	P05_SOORT	P05_SOORT	CHAR	2	0	Type of Authority	T5N9C
3	JUPER	☑	JUPER	JUPER	CHAR	4	0	Legal Person
4	INSTL	☑	P05_INSTL	P05_INSTL	CHAR	3	0	Authority
5	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	KNAAM	☐	P05_KNAAM	TEXT22	CHAR	22	0	Authority (Short Text)
8	LNAAM	☐	P05_LNAAM	TEXT40	CHAR	40	0	Authority (Name in Full)
9	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
10	HSNMR	☐	HSNMR	NUMC6	NUMC	6	0	House Number
11	POSTA	☐	POSTA	TEXT6	CHAR	6	0	Identification of an Apartment in a Building
12	LOCAT	☐	LOCAT	TEXT30	CHAR	30	0	2nd Address Line
13	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
14	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
15	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
16	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
17	FAXNR	☐	FAXNR	CHAR25	CHAR	25	0	Fax Number
18	KPERS	☐	KPERS	TEXT25	CHAR	25	0	Contact Person
19	ANSNR	☐	P05_ANSNR	CHAR20	CHAR	20	0	Registration Number
20	REKNR	☐	P05_REKNR	CHAR18	CHAR	18	0	Bank Account / Giro Account Number
21	AFDLG	☐	P05_AFDLG	TEXT25	CHAR	25	0	Department

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5N9A	LAND1	T005	LAND1
2	T5N9A	MANDT	T000	MANDT	KEY	1	CN
3	T5N9A	SOORT	T5N9C	SOORT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in