SAP Table V_T5B9P
Generated Table for View
V_T5B9P (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_T5B9P to other SAP tables.
V_T5B9P table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| WERKS | Personnel Area | PERSA | T500P | CHAR | 4 | 0 | ||
| BTRTL | Personnel Subarea | BTRTL_001P | CHAR | 4 | 0 | |||
| BEMAR | MARIBEL is relevant | BEMAR | CHAR | 1 | 0 | |||
| RSZNR | SI Registration Number (employer) (00011) | RSZNR | NUMC | 9 | 0 | |||
| RSZIN | SI-institution | RSZIN | CHAR | 4 | 0 | |||
| RVPIN | RVP-institution | RVPIN | CHAR | 4 | 0 | |||
| RVPAN | RVP-number | RVPAN | CHAR | 14 | 0 | |||
| TAXIN | Tax collecting institution | TAXI1 | CHAR | 4 | 0 | |||
| TAXAN | Tax institution number | TAXAN | CHAR | 14 | 0 | |||
| BEZIN | Minimum of existence - institution | BEZIN | CHAR | 4 | 0 | |||
| BEZAN | Minimum of existence number | BEZA1 | CHAR | 14 | 0 | |||
| VERIN | Thirth party insurance | VERIN | CHAR | 4 | 0 | |||
| VERAN | Insurance number | VERA2 | CHAR | 14 | 0 | |||
| GVRIN | Group insurance institution | GVRIN | CHAR | 4 | 0 | |||
| GVRAN | Group insurance institution number | GVRAN | CHAR | 14 | 0 | |||
| UVRIN | Accident insurance institution | UVRIN | CHAR | 4 | 0 | |||
| UVRAN | Accident insurance institution number | UVRAN | CHAR | 14 | 0 | |||
| VAKIN | Leave fund | VAKIN | CHAR | 4 | 0 | |||
| VAKAN | Leave fund number | VAKAN | CHAR | 14 | 0 | |||
| KCKIN | Child allowance fund | KCKIN | CHAR | 4 | 0 | |||
| KCKAN | Child allowance fund number | KCKAN | CHAR | 14 | 0 | |||
| MEDIN | Code "I.B.G.D." (plant medical service) | MEDIN | CHAR | 4 | 0 | |||
| MEDAN | I.B.G.D. number (plant medical service) | MEDAN | CHAR | 14 | 0 | |||
| XSRTX | Institution type 1 | XSRTX | T5B92 | NUMC | 4 | 0 | ||
| XINXX | Institution 1 | XINXX | CHAR | 4 | 0 | |||
| XANXX | Number institution 1 | XANXX | CHAR | 14 | 0 | |||
| YSRTY | Responsible person social insurance (type 2) | P12_YSRTY | CHAR | 4 | 0 | |||
| YINYY | BELCOTAX office seat | P12_YINYY | CHAR | 4 | 0 | |||
| YANYY | BELCOTAX number | P12_YANYY | CHAR | 14 | 0 | |||
| WSRTW | Payroll office number | WSRTW | CHAR | 4 | 0 | |||
| WINWW | Company Address | WINWW | CHAR | 4 | 0 | |||
| WANWW | Tax office number | WANWW | CHAR | 14 | 0 | |||
| SPRSL | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||
| BEGKR | Sender identification number | BEGKR | CHAR | 6 | 0 | |||
| SPTXT | Name of Language | SPTXT | CHAR | 16 | 0 | |||
| NAME1 | Personnel Area Text | PBTXT | CHAR | 30 | 0 | |||
| BTEXT | Personnel Subarea Text | BTRTX | CHAR | 15 | 0 | |||
| MOLGA | Country Grouping | MOLGA | T500L | CHAR | 2 | 0 | ||
| DIRNR | Provisional RSZNR of employer | P12_DIRNR | NUMC | 10 | 0 | |||
| DIMIN | Dimona sender address | P12_DIMIN | CHAR | 4 | 0 | |||
| DIMAN | Dimona sender identification number | P12_DIMAN | NUMC | 6 | 0 | |||
| SNPIN | Sender pension's declaration | P12_SENDPENSD | CHAR | 4 | 0 | |||
V_T5B9P foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| V_T5B9P | MANDT | V_T5B9P | MANDT | T000 | Clients | MANDT |
| V_T5B9P | MOLGA | V_T5B9P | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| V_T5B9P | SPRSL | V_T5B9P | SPRSL | T002 | Language Keys (Component BC-I18) | SPRAS |
| V_T5B9P | WERKS | V_T5B9P | WERKS | T500P | Personnel Areas | PERSA |
| V_T5B9P | WERKS | V_T5B9P | MANDT | T500P | Personnel Areas | MANDT |
| V_T5B9P | XSRTX | V_T5B9P | MANDT | T5B92 | Institutional Groups (B) | MANDT |
| V_T5B9P | XSRTX | V_T5B9P | XSRTX | T5B92 | Institutional Groups (B) | BESRT |
