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.

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
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
X Yes
NULL No
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
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 RSZBL T5B0F Country Codes & Nationalities (B) BELDK
V_T5B9A RSZBL V_T5B9A MANDT T5B0F Country Codes & Nationalities (B) MANDT
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