SAP Table V_T7PBS00TRF_DAT
Generated Table for View
V_T7PBS00TRF_DAT (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_T7PBS00TRF_DAT to other SAP tables.
V_T7PBS00TRF_DAT table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
MOLGA | Country Grouping | MOLGA | T500L | CHAR | 2 | 0 | ||
EVENT | Pay Scale Event Linked to a Key Date | P_99_PBS_EVENT | T7PBS00TRF_EVT | NUMC | 2 | 0 | ||
TRFAR | Pay scale type | TRFAR | T510 | CHAR | 2 | 0 | ||
TRFGB | Pay Scale Area | TRFGB | T510 | CHAR | 2 | 0 | ||
TRFKZ | ES grouping for collective agreement provision | TRFKZ | T510 | CHAR | 1 | 0 | ||
SET_DATE | Key Date for a Pay Scale Event (e.g. Standard Pay Increase) | P_99_PBS_DATE | DATS | 8 | 0 | |||
TRFGR_FROM | First Pay Scale Group in a Range of Pay Scale Groups | P_99_PBS_TRFRG_FROM | T510 | CHAR | 8 | 0 | ||
TRFGR_TO | Last Pay Scale Group in a Range of Pay Scale Groups | P_99_PBS_TRFRG_TO | T510 | CHAR | 8 | 0 | ||
PRZNT | Percentage or Factor | P_99_PBS_PRZNT | DEC | 7 | 4 | |||
CMTEXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | 0 | |||
LEGAL_BASIS | Legal Basis | P_99_PBS_LEGAL_BASIS | T7PBS00TRF_BAS | NUMC | 8 | 0 | ||
CMTEXT2 | Text, 40 Characters Long | TEXT40 | CHAR | 40 | 0 |
V_T7PBS00TRF_DAT foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
V_T7PBS00TRF_DAT | EVENT | V_T7PBS00TRF_DAT | MANDT | T7PBS00TRF_EVT | Pay Scale Events (Such as Standard Pay Increase) | MANDT |
V_T7PBS00TRF_DAT | EVENT | V_T7PBS00TRF_DAT | MOLGA | T7PBS00TRF_EVT | Pay Scale Events (Such as Standard Pay Increase) | MOLGA |
V_T7PBS00TRF_DAT | EVENT | V_T7PBS00TRF_DAT | EVENT | T7PBS00TRF_EVT | Pay Scale Events (Such as Standard Pay Increase) | EVENT |
V_T7PBS00TRF_DAT | LEGAL_BASIS | V_T7PBS00TRF_DAT | MOLGA | T7PBS00TRF_BAS | Legal Basis | MOLGA |
V_T7PBS00TRF_DAT | LEGAL_BASIS | V_T7PBS00TRF_DAT | LEGAL_BASIS | T7PBS00TRF_BAS | Legal Basis | LEGAL_BASIS |
V_T7PBS00TRF_DAT | LEGAL_BASIS | * | T7PBS00TRF_BAS | Legal Basis | ENDDA | |
V_T7PBS00TRF_DAT | LEGAL_BASIS | V_T7PBS00TRF_DAT | MANDT | T7PBS00TRF_BAS | Legal Basis | MANDT |
V_T7PBS00TRF_DAT | MANDT | V_T7PBS00TRF_DAT | MANDT | T000 | Clients | MANDT |
V_T7PBS00TRF_DAT | MOLGA | V_T7PBS00TRF_DAT | MOLGA | T500L | Personnel Country Grouping | MOLGA |
V_T7PBS00TRF_DAT | TRFAR | V_T7PBS00TRF_DAT | TRFKZ | T510 | Pay Scale Groups | TRFKZ |
V_T7PBS00TRF_DAT | TRFAR | V_T7PBS00TRF_DAT | TRFGR_FROM | T510 | Pay Scale Groups | TRFGR |
V_T7PBS00TRF_DAT | TRFAR | V_T7PBS00TRF_DAT | MANDT | T510 | Pay Scale Groups | MANDT |
V_T7PBS00TRF_DAT | TRFAR | * | T510 | Pay Scale Groups | TRFST | |
V_T7PBS00TRF_DAT | TRFAR | V_T7PBS00TRF_DAT | MOLGA | T510 | Pay Scale Groups | MOLGA |
V_T7PBS00TRF_DAT | TRFAR | ' ' | T510 | Pay Scale Groups | LGART | |
V_T7PBS00TRF_DAT | TRFAR | V_T7PBS00TRF_DAT | TRFAR | T510 | Pay Scale Groups | TRFAR |
V_T7PBS00TRF_DAT | TRFAR | * | T510 | Pay Scale Groups | ENDDA | |
V_T7PBS00TRF_DAT | TRFAR | V_T7PBS00TRF_DAT | TRFGB | T510 | Pay Scale Groups | TRFGB |
V_T7PBS00TRF_DAT | TRFGB | V_T7PBS00TRF_DAT | TRFGR_FROM | T510 | Pay Scale Groups | TRFGR |
V_T7PBS00TRF_DAT | TRFGB | V_T7PBS00TRF_DAT | MANDT | T510 | Pay Scale Groups | MANDT |
V_T7PBS00TRF_DAT | TRFGB | * | T510 | Pay Scale Groups | TRFST | |
V_T7PBS00TRF_DAT | TRFGB | V_T7PBS00TRF_DAT | MOLGA | T510 | Pay Scale Groups | MOLGA |
V_T7PBS00TRF_DAT | TRFGB | ' ' | T510 | Pay Scale Groups | LGART | |
V_T7PBS00TRF_DAT | TRFGB | V_T7PBS00TRF_DAT | TRFAR | T510 | Pay Scale Groups | TRFAR |
V_T7PBS00TRF_DAT | TRFGB | * | T510 | Pay Scale Groups | ENDDA | |
V_T7PBS00TRF_DAT | TRFGB | V_T7PBS00TRF_DAT | TRFGB | T510 | Pay Scale Groups | TRFGB |
V_T7PBS00TRF_DAT | TRFGB | V_T7PBS00TRF_DAT | TRFKZ | T510 | Pay Scale Groups | TRFKZ |
V_T7PBS00TRF_DAT | TRFGR_FROM | * | T510 | Pay Scale Groups | LGART | |
V_T7PBS00TRF_DAT | TRFGR_FROM | V_T7PBS00TRF_DAT | TRFAR | T510 | Pay Scale Groups | TRFAR |
V_T7PBS00TRF_DAT | TRFGR_FROM | * | T510 | Pay Scale Groups | ENDDA | |
V_T7PBS00TRF_DAT | TRFGR_FROM | V_T7PBS00TRF_DAT | TRFGB | T510 | Pay Scale Groups | TRFGB |
V_T7PBS00TRF_DAT | TRFGR_FROM | V_T7PBS00TRF_DAT | TRFKZ | T510 | Pay Scale Groups | TRFKZ |
V_T7PBS00TRF_DAT | TRFGR_FROM | V_T7PBS00TRF_DAT | TRFGR_FROM | T510 | Pay Scale Groups | TRFGR |
V_T7PBS00TRF_DAT | TRFGR_FROM | V_T7PBS00TRF_DAT | MANDT | T510 | Pay Scale Groups | MANDT |
V_T7PBS00TRF_DAT | TRFGR_FROM | * | T510 | Pay Scale Groups | TRFST | |
V_T7PBS00TRF_DAT | TRFGR_FROM | V_T7PBS00TRF_DAT | MOLGA | T510 | Pay Scale Groups | MOLGA |
V_T7PBS00TRF_DAT | TRFGR_TO | V_T7PBS00TRF_DAT | TRFGB | T510 | Pay Scale Groups | TRFGB |
V_T7PBS00TRF_DAT | TRFGR_TO | V_T7PBS00TRF_DAT | TRFKZ | T510 | Pay Scale Groups | TRFKZ |
V_T7PBS00TRF_DAT | TRFGR_TO | V_T7PBS00TRF_DAT | TRFGR_TO | T510 | Pay Scale Groups | TRFGR |
V_T7PBS00TRF_DAT | TRFGR_TO | V_T7PBS00TRF_DAT | MANDT | T510 | Pay Scale Groups | MANDT |
V_T7PBS00TRF_DAT | TRFGR_TO | * | T510 | Pay Scale Groups | TRFST | |
V_T7PBS00TRF_DAT | TRFGR_TO | V_T7PBS00TRF_DAT | MOLGA | T510 | Pay Scale Groups | MOLGA |
V_T7PBS00TRF_DAT | TRFGR_TO | * | T510 | Pay Scale Groups | LGART | |
V_T7PBS00TRF_DAT | TRFGR_TO | V_T7PBS00TRF_DAT | TRFAR | T510 | Pay Scale Groups | TRFAR |
V_T7PBS00TRF_DAT | TRFGR_TO | * | T510 | Pay Scale Groups | ENDDA | |
V_T7PBS00TRF_DAT | TRFKZ | V_T7PBS00TRF_DAT | TRFGR_FROM | T510 | Pay Scale Groups | TRFGR |
V_T7PBS00TRF_DAT | TRFKZ | V_T7PBS00TRF_DAT | MANDT | T510 | Pay Scale Groups | MANDT |
V_T7PBS00TRF_DAT | TRFKZ | * | T510 | Pay Scale Groups | TRFST | |
V_T7PBS00TRF_DAT | TRFKZ | V_T7PBS00TRF_DAT | MOLGA | T510 | Pay Scale Groups | MOLGA |
V_T7PBS00TRF_DAT | TRFKZ | ' ' | T510 | Pay Scale Groups | LGART | |
V_T7PBS00TRF_DAT | TRFKZ | V_T7PBS00TRF_DAT | TRFAR | T510 | Pay Scale Groups | TRFAR |
V_T7PBS00TRF_DAT | TRFKZ | * | T510 | Pay Scale Groups | ENDDA | |
V_T7PBS00TRF_DAT | TRFKZ | V_T7PBS00TRF_DAT | TRFGB | T510 | Pay Scale Groups | TRFGB |
V_T7PBS00TRF_DAT | TRFKZ | V_T7PBS00TRF_DAT | TRFKZ | T510 | Pay Scale Groups | TRFKZ |