SAP table V_T5B9A (Generated Table for View)
SAP table V_T5B9A has 5 primary key fields being MANDT,SPRAS,SOORT,INSTL,ENDDA.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Language Key
LANG
1
0
T002
SPRAS
Institutional group
NUMC
4
0
T5B92
BESRT
Institution code
CHAR
4
0
INSTL
End Date
DATS
8
0
ENDDA
BEGDA
Start Date
DATS
8
0
BEGDA
TXT9B
Text length 25
CHAR
25
0
TEXT25
NAAM1
Name
CHAR
25
0
NAAMA
ADRES
Street and House Number
CHAR
30
0
STRAS
HSNMR
House Number
NUMC
6
0
HSNMR
POSTA
Identification of an Apartment in a Building
CHAR
6
0
POSTA
POSTK
Postal Code
CHAR
10
0
PSTLZ
GEMEE
City
CHAR
25
0
ORT01
RSZBL
Obsolete: SI/Belcotax country
CHAR
4
0
T5B0F
RSZBL
TELNR
Telephone Number
CHAR
14
0
TELNR
FAXNR
Telephone Number
CHAR
14
0
TELNR
BANKN
Bank account number
CHAR
18
0
BANKN
BTWNR
Tax number
NUMC
15
0
BTWNR
PERS1
Person to be contacted 1
CHAR
25
0
PERS1
PERSF
Person to be contacted
CHAR
25
0
PERSF
HFDNR
Key main address institution
CHAR
4
0
HFDNR
ADRCO
Mailing address code
CHAR
4
0
ADRCO
BDHST
Recognition of Difficulty or Reorganization (00952)
CHAR
1
0
BDHST
Possible values
0
Not in difficulty or reorganization
1
Company in difficulty
2
Company undergoing reorganization
3
Company is or was treated as a firm in difficulty
BDFAL
Obsolete: Company insolvent
CHAR
1
0
BDFAL
SPRSL
Language Key
LANG
1
0
T002
SPRAS
SPTXT
Name of Language
CHAR
16
0
SPTXT
TXT25
Text length 25
CHAR
25
0
TEXT25
TXTLD
Text length 25
CHAR
25
0
TEXT25
PERNO
Appointed person personnel number
NUMC
8
0
P12_PERNR
MOBNR
Mobile Phone Number of Contact Person
CHAR
20
0
P12_MOBNR
EMAIL
Email Address of Contact Person (00637)
CHAR
60
0
P12_EMAIL
TELNK
Phone Number of Contact Person
CHAR
20
0
P12_TELNK
FAXNK
Fax Number of Contact Person (00678)
CHAR
20
0
P12_FAXNK
DINNP
SI no. of the interim employee user
NUMC
10
0
P12_DINNP
DIPBX
P.O. Box Number
CHAR
3
0
P12_DIPBX
TRUST
Trusteeship (00012)
NUMC
1
0
P12_TRUSTEESHIP
Possible values
0
Period when company is not in trusteeship
1
Period when company is in trusteeship
BEVAC
Start Date of Vacation Period (00017)
DATS
8
0
P12_BEVAC
COMID
Company ID (00014)
NUMC
10
0
P12_COMID
V_T5B9A foreign key relationships
Table
Field
Check Table
Check Field
0 V_T5B9A
MANDT
T000 Clients
MANDT
1 V_T5B9A
RSZBL
T5B0F Country Codes & Nationalities (B)
MANDT
0 V_T5B9A
SOORT
T5B92 Institutional Groups (B)
MANDT
1 V_T5B9A
SPRAS
T002 Language Keys (Component BC-I18)
SPRAS