SAP ABAP View V_T5B9A (Institutions (B))
Hierarchy
☛
SAP_HRCBE (Software Component) Sub component SAP_HRCBE of SAP_HR
⤷ PA-PA-BE (Application Component) Belgium
⤷ PB12 (Package) HR Master Data: Belgium
⤷ PA-PA-BE (Application Component) Belgium
⤷ PB12 (Package) HR Master Data: Belgium
Basic Data
View Type | C | Maintenance View |
Maintenance View | V_T5B9A | |
Short Description | Institutions (B) | |
Root table | T5B9A | Institutions (B) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | T5B9A | T5B9A | ||
2 | T5B92 | T5B9A | SOORT | E |
3 | T002 | T5B9A | SPRSL | E |
4 | T002T | T002 | SPRSL | I |
5 | T5B9B | T5B92 | BESRT | I |
6 | T5B0F | T5B9A | RSZBL | E |
7 | T5B06 | T5B0F | BELDK | I |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | T5B9A | MANDT | MANDT | Client | |||
2 | SPRAS | T5B9A | SPRAS | S | SPRAS | Language Key | ||
3 | SOORT | T5B9A | SOORT | S | BESRT | Institutional group | ||
4 | INSTL | T5B9A | INSTL | INSTL | Institution code | |||
5 | ENDDA | T5B9A | ENDDA | ENDDA | End Date | |||
6 | BEGDA | T5B9A | BEGDA | BEGDA | Start Date | |||
7 | TXT9B | T5B9B | TXT25 | TEXT25 | Text length 25 | |||
8 | NAAM1 | T5B9A | NAAM1 | NAAMA | Name | |||
9 | ADRES | T5B9A | ADRES | STRAS | House number and street | |||
10 | HSNMR | T5B9A | HSNMR | HSNMR | House Number | |||
11 | POSTA | T5B9A | POSTA | POSTA | Identification of an Apartment in a Building | |||
12 | POSTK | T5B9A | POSTK | PSTLZ | Postal Code | |||
13 | GEMEE | T5B9A | GEMEE | ORT01 | City | |||
14 | RSZBL | T5B9A | RSZBL | RSZBL | Obsolete: SI/Belcotax country | |||
15 | TELNR | T5B9A | TELNR | TELNR | Telephone Number | |||
16 | FAXNR | T5B9A | FAXNR | TELNR | Telephone Number | |||
17 | BANKN | T5B9A | BANKN | BANKN | Bank account number | |||
18 | BTWNR | T5B9A | BTWNR | BTWNR | Tax number | |||
19 | PERS1 | T5B9A | PERS1 | PERS1 | Person to be contacted 1 | |||
20 | PERSF | T5B9A | PERSF | PERSF | Person to be contacted | |||
21 | HFDNR | T5B9A | HFDNR | HFDNR | Key main address institution | |||
22 | ADRCO | T5B9A | ADRCO | ADRCO | Mailing address code | |||
23 | BDHST | T5B9A | BDHST | BDHST | Recognition of Difficulty or Reorganization (00952) | |||
24 | BDFAL | T5B9A | BDFAL | BDFAL | Company insolvent | |||
25 | SPRSL | T5B9A | SPRSL | SPRAS | Language Key | |||
26 | SPTXT | T002T | SPTXT | SPTXT | Name of Language | |||
27 | TXT25 | T5B06 | TXT25 | TEXT25 | Text length 25 | |||
28 | TXTLD | T5B06 | TXT25 | TEXT25 | Text length 25 | |||
29 | PERNO | T5B9A | PERNO | P12_PERNR | Appointed person personnel number | |||
30 | MOBNR | T5B9A | MOBNR | P12_MOBNR | Mobile Phone Number of Contact Person | |||
31 | T5B9A | P12_EMAIL | Email Address of Contact Person (00637) | |||||
32 | TELNK | T5B9A | TELNK | P12_TELNK | Phone Number of Contact Person | |||
33 | FAXNK | T5B9A | FAXNK | P12_FAXNK | Fax Number of Contact Person (00678) | |||
34 | DINNP | T5B9A | DINNP | P12_DINNP | SI no. of the interim employee user | |||
35 | DIPBX | T5B9A | DIPBX | P12_DIPBX | P.O. Box Number | |||
36 | TRUST | T5B9A | TRUST | P12_TRUSTEESHIP | Trusteeship (00012) | |||
37 | BEVAC | T5B9A | BEVAC | P12_BEVAC | Start date of vacation period (00017) | |||
38 | COMID | T5B9A | COMID | P12_COMID | Company ID (00014) | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |