| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/X164 | Name of Items in Field Selection Definitions | 4 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
2 | /OPT/Y164 | Name of Items in Field Selection Definitions | 4 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
3 | /OPT/Z164 | Name of Items in Field Selection Definitions | 4 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
4 | /ORS/TMODP | Name of Items in Field Selection Definitions | 4 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
5 | J_3RFREP_ADP_X | XML Data Provider Parameters of Reporting Object | 6 | MODIF | Value Modifier | int | 10 | 0 | | |
6 | P2RC_CHVS | HR-CH: Payroll result insurance | 11 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
7 | T510L | Step Table | 3 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
8 | T510Y | Special Rules for Wage Type Generation | 2 | MODIF | Modifier T510Y | nvarchar | 2 | 0 | | |
9 | T512C | Wage Types to be Distributed | 2 | MODIF | Country Grouping | nvarchar | 2 | 0 | | |
10 | T555S | PDC Record Type Conversion | 2 | MODIF | Modifier for PDC PC upload | nvarchar | 2 | 0 | | |
11 | T5A7S | Switch Table for PCALZ Checks | 2 | MODIF | Organizational Grouping for PCALZ Check | nvarchar | 5 | 0 | | |
12 | T5CS7_CE | HR-CH-CE: Grouping for Insurances CE | 4 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
13 | T5D0C | Absence Distribution | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
14 | T5D1N | Calculation of HI Amount | 2 | MODIF | HI modifier | nvarchar | 2 | 0 | | |
15 | T5D1U | SI Processing | 3 | MODIF | SI Modifier | nvarchar | 2 | 0 | | |
16 | T77KZGR | Parameters for Grossing Up Taxes and Contributions | 3 | MODIF | Grouping for Gross-Up | nvarchar | 2 | 0 | | |
17 | T7AE16 | Absence Distribution UAE | 5 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
18 | T7KW09 | Absence Distribution Kuwait | 5 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
19 | T7OM28 | Absence Distribution Oman | 5 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
20 | T7QA16 | Absence Distribution Qatar | 5 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
21 | T7RU51AV_P | Relation between Year and WType for income for this year | 3 | MODIF | Calculation Modifier | nvarchar | 4 | 0 | | |
22 | T7RU554S | Additional property of SocInsurance Absence Types | 6 | MODIF | Calculation Modifier | nvarchar | 4 | 0 | | |
23 | T7RU_DISCEND | Determine End Dates of Disciplinary Measures | 4 | MODIF | Personal Modifier | nvarchar | 4 | 0 | | |
24 | T7SA16 | Absence Distribution KSA | 5 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
25 | T7SAPBS31 | Absence Distribution KSA Public Sector | 6 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
26 | T7SAPBS32 | Absence Distribution KSA Public Sector | 6 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
27 | T7SI04 | Absence valuation rule additional properties | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
28 | TBLP_MODO | Items in Field Selection Definitions | 2 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
29 | TBLP_MODP | Name of Items in Field Selection Definitions | 3 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
30 | TMODO | Items in Field Selection Definitions | 2 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
31 | TMODP | Name of Items in Field Selection Definitions | 3 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
TOPActual CostingMaterial Ledger |
32 | MLPP | Material Ledger Document: Posting Periods and Quantities | 15 | MODIF | Type of BOM item | nvarchar | 1 | 0 | | |
TOPApplications |
33 | MDG_ECC_CUST_FG | Attribution Entity/DB/Modification group (Customer) | 8 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
TOPAustria |
34 | T5A0P | Personnel Area/Subarea AT | 10 | MODIF | Grouping for Multiple Assignment of Municipal Tax | nvarchar | 5 | 0 | | |
35 | T5A9M | Multiple Assignment for Municipal Tax | 2 | MODIF | Grouping for Multiple Assignment of Municipal Tax | nvarchar | 5 | 0 | | |
36 | T5A9N | Multiple Assignment for Municipal Tax (Name) | 2 | MODIF | Grouping for Multiple Assignment of Municipal Tax | nvarchar | 5 | 0 | | |
TOPBrazil |
37 | T7BR0A | Split of absence valuation periods | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
38 | T7BR0F | Third-party payment assignment | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
39 | T7BR4C | Wage types for leave valuation | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
40 | T7BRWT | Assignment of wage types for absence in double | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPCanada |
41 | T5K0C | Absence Breakdown | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
42 | T5KYR | Association of wage type with registration number, Canada | 3 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
43 | T5UBX_GTL_AWART | Processing group for absence types | 5 | MODIF | Text | nvarchar | 2 | 0 | | |
44 | T5UBX_GTL_SUBTY | Processing group definition for Beneficiaries | 4 | MODIF | Text | nvarchar | 2 | 0 | | |
TOPConstruction Industry |
45 | T5DB9 | Construction Pay Evaluation Records for Social Fund Proc. | 11 | MODIF | Modification Status for Evaluation Records SFP Construction | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
46 | TFK004M | Field name allocation in FI-CA -> FI field selection item | 1 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
TOPCustomer Enhancements |
47 | CUATEXTS | Modifications of GUI Interface: Menu Texts Changed by Cust. | 9 | MODIF | Function is flagged for user modification | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
48 | TMODU | Cross Reference Field Name - MODIF1 | 2 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
TOPGreat Britain |
49 | T5G_ERPEN | Absence Valuation | 3 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPHong Kong |
50 | T7HK2N | Source of pre-prorated calc. base for retirement plan | 3 | MODIF | Retirement plan grouping for pre-prorated calc. base | nvarchar | 2 | 0 | | |
TOPIndonesia |
51 | T7ID0A | Absence Split Assignment | 3 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
52 | T7ID0L | Continued Absence Linking | 3 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPInformation System |
53 | TCNDB | Profile: Database parameters in Project Info System | 33 | MODIF | Checkbox | nvarchar | 1 | 0 | | |
54 | TCNDB_PSJT | Profile: as TCNDB, only for verification of LDB PSJ!! | 33 | MODIF | Checkbox | nvarchar | 1 | 0 | | |
TOPIreland |
55 | T7IEA | Irish PRSI Calculation and Absence Valuation | 3 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPItaly |
56 | T5ITI8 | Old evalution basis for absences | 3 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
57 | T5ITI9 | Table to split AB | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
58 | T5ITIN0 | INAIL table to update group data | 15 | MODIF | | nvarchar | 1 | 0 | | |
59 | T5ITIN1 | Contribution INAIL table | 12 | MODIF | | nvarchar | 1 | 0 | | |
60 | T5ITIQ | Evalution rules for reimbursements and integrations | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
61 | T5ITIR | Maximum number of days for integration and reimbursement | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
62 | T5ITIT | Special parameters for grace | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
63 | T5ITIU | General parameters for grace | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPKorea |
64 | T7KRS2 | Separation payment average calculation period | 5 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
65 | T7KRS6 | Cumulation method | 4 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
66 | T7KRS8 | Service period calculation method | 4 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
TOPLoans Management |
67 | TDA12 | Loans master data field control | 2 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
68 | TDCONDVER_FP | Condition Verfier: Field Item Customizing | 2 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
TOPMDG Business Partner Central Part |
69 | MDG_ECC_BPFLDMAP | Mapping of CVI-structures to modif-groups | 6 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
TOPMDG Supplier Central Parts |
70 | MDG_BS_SUPPL_FG | Attribution Entity/DB/Modification group (Supplier) | 8 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
TOPNorway |
71 | T5VA6 | Norwegian absence evaluation rules | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPPayroll |
72 | T5T0C | Partitioning of absences | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
73 | T7BG0C | Partitioning of absences | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
74 | T7SI0C | Partitioning of absences | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
75 | T7SK0C | Partitioning of absences | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
76 | T7UAADP | | 3 | MODIF | ??????????? ??? ????????? ????????? | nvarchar | 2 | 0 | | |
77 | T7UAD1 | | 3 | MODIF | | nvarchar | 2 | 0 | | |
TOPPayroll General Parts |
78 | T510J | Constant Valuations | 3 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
79 | T51D1 | Limits for Deductions | 3 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
80 | T7CCE_CUM_RT_PER | Cumulate Wage Types from RT in RT_PERSON | 4 | MODIF | Employee Grouping for Wage Type Cumulation in RT_PERSON | nvarchar | 2 | 0 | | |
TOPPegging, Grouping, and Distribution |
81 | TBLP_MODU | Cross Reference Field Name - MODIF1 | 2 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |
TOPPersonnel Administration |
82 | T7CO02 | Social insurance general parameters | 3 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
83 | T7CO07 | Absence general configuration | 4 | MODIF | Grouper by employee type | nvarchar | 2 | 0 | | |
84 | T7CO21 | Provision calculation parameters | 2 | MODIF | Grouper by employee type | nvarchar | 2 | 0 | | |
85 | T7CO22 | Calculation functions | 2 | MODIF | Grouper by employee type | nvarchar | 2 | 0 | | |
86 | T7CO25 | Calculation parameters for social benefits | 2 | MODIF | Grouper by employee type | nvarchar | 2 | 0 | | |
87 | T7CO26 | Employee grouping for calculation types | 2 | MODIF | Grouper by employee type | nvarchar | 2 | 0 | | |
88 | T7CO27 | Output item for settlement calculation and provisions | 2 | MODIF | Grouper by employee type | nvarchar | 2 | 0 | | |
89 | T7CO29 | Basics for benefits calculation | 2 | MODIF | Grouper by employee type | nvarchar | 2 | 0 | | |
90 | T7CO33 | Concept by which the payments are advanced | 2 | MODIF | Grouper by employee type | nvarchar | 2 | 0 | | |
TOPPersonnel Management |
91 | /BKC/S21_CUSREX | C&T! - Definition of user exits for comparison programs | 2 | MODIF | C&T! - Modifier for user exits | nvarchar | 2 | 0 | | |
92 | /BKC/S21_CUSREXT | C&T! - Texts of user exits of comparison programs | 2 | MODIF | C&T! - Modifier for user exits | nvarchar | 2 | 0 | | |
93 | /BKC/S21_FLD_MAP | C&T! - Field mapping for data transfer | 2 | MODIF | C&T! - Modifier for field mapping | nvarchar | 2 | 0 | | |
94 | /BKC/S21_TAB_MAP | C&T! - Table mapping for data transfer | 2 | MODIF | C&T! - Modifier for table mapping | nvarchar | 2 | 0 | | |
95 | /BKC/S21_USREX | C&T! - Definition of user exits for data conversion | 2 | MODIF | C&T! - Modifier for user exits | nvarchar | 2 | 0 | | |
96 | /BKC/S21_USREX_T | C&T! - Texts of user exits (copy programs) | 2 | MODIF | C&T! - Modifier for user exits | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
97 | T510P | Premium Table | 2 | MODIF | Personnel subarea grouping for premiums | nvarchar | 2 | 0 | | |
98 | T554C | Absence Valuation | 3 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
99 | T555Y | Processing Type/Time Type According to Att./Absence Class | 3 | MODIF | Time type determination group | nvarchar | 2 | 0 | | |
100 | T555Z | Time Type Determination | 3 | MODIF | Time type determination group | nvarchar | 2 | 0 | | |
101 | T569R | Earliest Recalculation Dates for Time Management | 2 | MODIF | Modifier for determining earliest recalculation date | nvarchar | 2 | 0 | | |
102 | T599Y | Convert External Wage Types | 3 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
103 | T599Z | Time Wage Types to Third-Party Systems | 3 | MODIF | Payroll Modifier | nvarchar | 2 | 0 | | |
TOPPublic sector Sweden |
104 | T5S0Q_CE | Absence split rules for SNABC | 2 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPReuse Services for Country Development |
105 | T599E | Time-Dependent Rounding for Operation RNDC | 9 | MODIF | Field parameter | nvarchar | 5 | 0 | | |
TOPRussia |
106 | T7RUG0 | HR: Garnishment Order Types | 16 | MODIF | Garnishment Grouping | nvarchar | 2 | 0 | | |
107 | T7RUG3 | Rules for Calculation of Garnishment Order Types | 2 | MODIF | Garnishment Grouping | nvarchar | 2 | 0 | | |
108 | T7RUGV | Rules for Calculation of garnishment order type | 3 | MODIF | Garnishment Grouping | nvarchar | 2 | 0 | | |
109 | T7RUT_XAB | Cover processing to refine AB in RUNAB | 6 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPSAP Query |
110 | AQGTB | SAP Query: Texts for User Groups | 4 | MODIF | SAP Query (S): Modification number | nvarchar | 4 | 0 | | |
111 | AQGTQ | SP Query: Texts for Queries | 6 | MODIF | SAP Query (S): Modification number | nvarchar | 4 | 0 | | |
112 | AQGTS | SAP Query: Texts for Functional Areas | 5 | MODIF | SAP Query (S): Modification number | nvarchar | 4 | 0 | | |
113 | AQLTQ | SP Query: Texts for Queries | 7 | MODIF | SAP Query (S): Modification number | nvarchar | 4 | 0 | | |
114 | AQLTS | SAP Query: Texts for Functional Areas | 6 | MODIF | SAP Query (S): Modification number | nvarchar | 4 | 0 | | |
TOPSingapore |
115 | T5R3A | HR-SG: AWS Union Subscription Rates | 3 | MODIF | HR-SG: Modifier for AWS union subscription rate | nvarchar | 1 | 0 | | |
TOPSocial Insurance |
116 | T5D18 | Processing of Assessment Thresholds | 3 | MODIF | SI Modifier | nvarchar | 2 | 0 | | |
TOPSwitzerland |
117 | T5CS7 | HR-CH: Premium Rates for Insurance | 4 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
118 | T5CS8 | HR-CH: Texts for Contribution Rates for Insurance | 5 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
119 | T5CSC | HR-CH: Payroll Unit: Voluntary Accident Insurance | 6 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
120 | T5CSD | HR-CH: Payroll Unit - Sickness Indemnity Insurance | 6 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
121 | T5CSI | Grouping for Insurances | 2 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
122 | T5CSIT | Grouping for Social Insurance Switzerland | 3 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
123 | T5CSX | HR-CH: Payroll unit: Customer insurance 1 | 6 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
124 | T5CSY | HR-CH: Payroll unit: Customer insurance 2 | 6 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
125 | T5CSZ | HR-CH: Payroll unit: Customer insurance 3 | 6 | MODIF | Insurance grouping | nvarchar | 2 | 0 | | |
TOPTaiwan |
126 | T7TW50 | Rate for multiple payment | 4 | MODIF | Employee grouping for multiple payment | nvarchar | 2 | 0 | | |
127 | T7TWAB | Absence Split Assignment | 3 | MODIF | Employee Grouping for Absence Valuation | nvarchar | 2 | 0 | | |
TOPTransaction Manager |
128 | TMODV | Field Selection: Assign Fields to Field Groups | 2 | MODIF | Modification group 1 | nvarchar | 3 | 0 | | |