SAP ABAP Table V_T5B9A (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_T5B9A	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
3	SOORT	☑	BESRT	BESRT	NUMC	4	0	Institutional group	T5B92
4	INSTL	☑	INSTL	P12_BVMUT	CHAR	4	0	Institution code
5	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	TXT9B	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
8	NAAM1	☐	NAAMA	TEXT25	CHAR	25	0	Name
9	ADRES	☐	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	POSTK	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
13	GEMEE	☐	ORT01	TEXT25	CHAR	25	0	City
14	RSZBL	☐	RSZBL	RSZLD	CHAR	4	0	Obsolete: SI/Belcotax country	T5B0F
15	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
16	FAXNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
17	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
18	BTWNR	☐	BTWNR	NUMC15	NUMC	15	0	Tax number
19	PERS1	☐	PERS1	NACHN	CHAR	25	0	Person to be contacted 1
20	PERSF	☐	PERSF	TEXT25	CHAR	25	0	Person to be contacted
21	HFDNR	☐	HFDNR	CHAR4	CHAR	4	0	Key main address institution
22	ADRCO	☐	ADRCO	CHAR4	CHAR	4	0	Mailing address code
23	BDHST	☐	BDHST	BDHST	CHAR	1	0	Recognition of Difficulty or Reorganization (00952)
24	BDFAL	☐	BDFAL	XFELD	CHAR	1	0	Company insolvent
25	SPRSL	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
26	SPTXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
27	TXT25	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
28	TXTLD	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
29	PERNO	☐	P12_PERNR	PERSNO	NUMC	8	0	Appointed person personnel number
30	MOBNR	☐	P12_MOBNR	CHAR20	CHAR	20	0	Mobile Phone Number of Contact Person
31	EMAIL	☐	P12_EMAIL	CHAR60	CHAR	60	0	Email Address of Contact Person (00637)
32	TELNK	☐	P12_TELNK	CHAR20	CHAR	20	0	Phone Number of Contact Person
33	FAXNK	☐	P12_FAXNK	CHAR20	CHAR	20	0	Fax Number of Contact Person (00678)
34	DINNP	☐	P12_DINNP	NUMC10	NUMC	10	0	SI no. of the interim employee user
35	DIPBX	☐	P12_DIPBX	CHAR3	CHAR	3	0	P.O. Box Number
36	TRUST	☐	P12_TRUSTEESHIP	P12_TRUSTEESHIP	NUMC	1	0	Trusteeship (00012)
37	BEVAC	☐	P12_BEVAC	DATUM	DATS	8	0	Start date of vacation period (00017)
38	COMID	☐	P12_COMID	NUMC10	NUMC	10	0	Company ID (00014)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_T5B9A	MANDT	T000	MANDT	KEY	1	CN
2	V_T5B9A	RSZBL	T5B0F	BELDK	KEY	1	CN
3	V_T5B9A	SOORT	T5B92	BESRT	KEY	1	CN
4	V_T5B9A	SPRAS	T002	SPRAS	KEY	1	CN
5	V_T5B9A	SPRSL	T002	SPRAS	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in