- Home
- Resources
- SAP Tables
- V_T5B9A - Generated Table for View
SAP Table V_T5B9A
Generated Table for View
V_T5B9A (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link V_T5B9A to other SAP tables.
Source: V_T5B9A (Generated Table for View)
V_T5B9A table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| SPRAS |
Language Key |
SPRAS |
T002
|
LANG |
|
1 |
0 |
|
| SOORT |
Institutional group |
BESRT |
T5B92
|
NUMC |
|
4 |
0 |
|
| INSTL |
Institution code |
INSTL |
|
CHAR |
|
4 |
0 |
|
| ENDDA |
End Date |
ENDDA |
|
DATS |
|
8 |
0 |
|
| BEGDA |
Start Date |
BEGDA |
|
DATS |
|
8 |
0 |
|
| TXT9B |
Text length 25 |
TEXT25 |
|
CHAR |
|
25 |
0 |
|
| NAAM1 |
Name |
NAAMA |
|
CHAR |
|
25 |
0 |
|
| ADRES |
House number and street |
STRAS |
|
CHAR |
|
30 |
0 |
|
| HSNMR |
House Number |
HSNMR |
|
NUMC |
|
6 |
0 |
|
| POSTA |
Identification of an Apartment in a Building |
POSTA |
|
CHAR |
|
6 |
0 |
|
| POSTK |
Postal Code |
PSTLZ |
|
CHAR |
|
10 |
0 |
|
| GEMEE |
City |
ORT01 |
|
CHAR |
|
25 |
0 |
|
| RSZBL |
Obsolete: SI/Belcotax country |
RSZBL |
T5B0F
|
CHAR |
|
4 |
0 |
|
| TELNR |
Telephone Number |
TELNR |
|
CHAR |
|
14 |
0 |
|
| FAXNR |
Telephone Number |
TELNR |
|
CHAR |
|
14 |
0 |
|
| BANKN |
Bank account number |
BANKN |
|
CHAR |
|
18 |
0 |
|
| BTWNR |
Tax number |
BTWNR |
|
NUMC |
|
15 |
0 |
|
| PERS1 |
Person to be contacted 1 |
PERS1 |
|
CHAR |
|
25 |
0 |
|
| PERSF |
Person to be contacted |
PERSF |
|
CHAR |
|
25 |
0 |
|
| HFDNR |
Key main address institution |
HFDNR |
|
CHAR |
|
4 |
0 |
|
| ADRCO |
Mailing address code |
ADRCO |
|
CHAR |
|
4 |
0 |
|
| BDHST |
Recognition of Difficulty or Reorganization (00952) |
BDHST |
|
CHAR |
|
1 |
0 |
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 |
Company insolvent |
BDFAL |
|
CHAR |
|
1 |
0 |
Possible values
|
| SPRSL |
Language Key |
SPRAS |
T002
|
LANG |
|
1 |
0 |
|
| SPTXT |
Name of Language |
SPTXT |
|
CHAR |
|
16 |
0 |
|
| TXT25 |
Text length 25 |
TEXT25 |
|
CHAR |
|
25 |
0 |
|
| TXTLD |
Text length 25 |
TEXT25 |
|
CHAR |
|
25 |
0 |
|
| PERNO |
Appointed person personnel number |
P12_PERNR |
|
NUMC |
|
8 |
0 |
|
| MOBNR |
Mobile Phone Number of Contact Person |
P12_MOBNR |
|
CHAR |
|
20 |
0 |
|
| EMAIL |
Email Address of Contact Person (00637) |
P12_EMAIL |
|
CHAR |
|
60 |
0 |
|
| TELNK |
Phone Number of Contact Person |
P12_TELNK |
|
CHAR |
|
20 |
0 |
|
| FAXNK |
Fax Number of Contact Person (00678) |
P12_FAXNK |
|
CHAR |
|
20 |
0 |
|
| DINNP |
SI no. of the interim employee user |
P12_DINNP |
|
NUMC |
|
10 |
0 |
|
| DIPBX |
P.O. Box Number |
P12_DIPBX |
|
CHAR |
|
3 |
0 |
|
| TRUST |
Trusteeship (00012) |
P12_TRUSTEESHIP |
|
NUMC |
|
1 |
0 |
Possible values
| 0 |
Period when company is not in trusteeship |
| 1 |
Period when company is in trusteeship |
|
| BEVAC |
Start Date of Vacation Period (00017) |
P12_BEVAC |
|
DATS |
|
8 |
0 |
|
| COMID |
Company ID (00014) |
P12_COMID |
|
NUMC |
|
10 |
0 |
|
V_T5B9A foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| V_T5B9A |
MANDT |
V_T5B9A |
MANDT |
T000 |
Clients |
MANDT |
| V_T5B9A |
RSZBL |
V_T5B9A |
MANDT |
T5B0F |
Country Codes & Nationalities (B) |
MANDT |
| V_T5B9A |
RSZBL |
V_T5B9A |
RSZBL |
T5B0F |
Country Codes & Nationalities (B) |
BELDK |
| V_T5B9A |
SOORT |
V_T5B9A |
MANDT |
T5B92 |
Institutional Groups (B) |
MANDT |
| V_T5B9A |
SOORT |
V_T5B9A |
SOORT |
T5B92 |
Institutional Groups (B) |
BESRT |
| V_T5B9A |
SPRAS |
V_T5B9A |
SPRAS |
T002 |
Language Keys (Component BC-I18) |
SPRAS |
| V_T5B9A |
SPRSL |
V_T5B9A |
SPRSL |
T002 |
Language Keys (Component BC-I18) |
SPRAS |
