SAP table T7PLT0 (Conversion table for GUS and ZUS codes for temporary workers)

SAP table T7PLT0 has 3 primary key fields being MANDT,MASSG,ENDDA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MASSG Reason for Action CHAR 2 0 MASSG
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
TEXT1 Text field - 60 characters CHAR 60 0 PPL_CHA60
TEXT2 Text field - 60 characters CHAR 60 0 PPL_CHA60
TEXT3 Text field - 60 characters CHAR 60 0 PPL_CHA60
TEXT4 Text field - 60 characters CHAR 60 0 PPL_CHA60
GUSCD GUS code for Z-01 form CHAR 2 0 PPL_GUSCD
ZUSCD ZUS code for ZWUA form CHAR 3 0 PPL_ZUSCD
WSIND Work statement indicator (department 3) CHAR 1 0 PPL_WSIND
TRMCD Employment termination mode CHAR 3 0 PPL_TRMCD
20R w/o term. by employee in conn. with plant trans.to other ER
21R as a result of non-agr. new terms prop. by ER on pl.takeover
22R by way of mutual agreement of parties
23R termination by employer
24R termination by employee
25R w/o termination by employer, violation of employee duties
26R w/o termination by employer, committing an offence
27R w/o termination by employer, loss of necessary authorization
28R upon elapse of time for which employment contract was made
29R upon completing work for which agreement was concluded
30R with red.not.per., under art.36(1)LC a. based on other acts
31R reinstatement and employment with another employer
32R w/o term. by employer, work incapacity longer than 3 months
33R w/o term. by employer, end of rehabilitation allowance
34R w/o term. by employer, excused absence longer than 1 month
35R w/o term. by employer, decision on harm.work imp. on health
36R w/o term. by employer, violation of duties by employer
37R acc. to spec. provisions other than specified with 4xx codes
38R appointment with another employer
39R dismissal
40R dismissal without notice
41R expiry of mandate
42R with juv.employees due to doct. dec. on work harm.to health
43R for reasons not rel. to employee, coll.red.-mutual agreement
44R for reasons not rel. to employee, coll. redund.-termination
45R for reasons not rel. to employee, ind. redund. - termination
46R for reasons not rel. to employee, ind.redund.-mutual agreem.
47W no return upon end of employment relationship by choice
48W death of employee
49W death of employer
50W temporary arrest
51W draft to professional military service
52W no return after dismissal from active military service
53W acc. to spec. provisions other than specified with 4xx codes
LTMCD Legal basis - code CHAR 3 0 PPL_LTMCD
400 art. 23 (1) sec. 4 of LC
401 art. 23 (1) sec. 5 of LC
402 art. 30 sec. 1 point 1 of LC
403 art. 30 sec. 1 point 2 of LC
404 art. 30 sec. 1 p. 3 in connection with art. 52 sec. 1 p.1 LC
405 art. 30 sec. 1 p. 3 in connection with art. 52 sec. 1 p.2 LC
406 art. 30 sec. 1 p. 3 in connection with art. 52 sec. 1 p.3 LC
407 art. 30 sec. 1 p. 4 of LC
408 art. 30 sec. 1 p. 5 of LC valid until 21.02.2016
409 art. 42 sec. 3 of LC
410 art. 48 sec. 2 of LC
411 art. 30 sec. 1 p. 3 in conn. with art. 53 sec. 1 p. 1(a) LC
412 art. 30 sec. 1 p. 3 in conn. with art. 53 sec. 1 p. 1(b) LC
413 art. 30 sec. 1 p. 3 in conn. with art. 53 sec. 1 p. 2 of LC
414 art. 30 sec. 1 p. 3 in conn. with art. 55 sec. 1 of LC
415 art. 30 sec. 1 p. 3 in conn. with art. 55 sec. 11 of LC
416 art. 68(3) of LC
417 art. 70 sec. 2 of LC
418 art. 70 sec. 3 of LC
419 art. 73 sec. 2 of LC
420 art. 201 sec. 2 of LC
421 art.30 sec.1 p.2 in conn.with art.1(1) of Sp.Term.Rules Act
422 art.30 sec.1 p.2 in conn.with art.10(1) of Sp.Term.Rules Act
423 art. 74 of LC
424 art. 63(1) sec. 1 of LC
425 art. 63(2) sec. 1 of LC
426 art. 66 sec. 1 of LC
427 art. 63 of LC in conn. with art.18(2) Prof.Sold.Mil.Serv.Act
428 art.63 of LC in conn.with art.122(1)Act on Gen.Def.Obl.in RP
429 art.30 sec.1 p.1 of LC in conn. with art.2(1)p.29 EmplPromAc
430 art.30 sec.1 p.2 of LC in conn.with art.2(1)p.29a EmplPromAc
431 art.30 sec.1 p.1 LC in conn. with art.2(1)p.29b EmplPromAct
432 art.30 sec.1 p.2 LC in conn. with art.2(1)p.29b EmplPromAct
433 art.30 sec.1 p.1 of LC in conn. with art.3 of EmplClProt Act
434 art.30 sec.1 p.2 of LC in conn. with art.3 of EmplClProt Act
435 art.30 sec.1 p.1 of LC in conn. with art.4 of EmplClProt Act
436 art.30 sec.1 p.2 of LC in conn. with art.4 of EmplClProt Act
437 art.30 sec.1 p.1 of LC in conn. with art.5 of EmplClProt Act
438 art.30 sec.1 p.2 of LC in conn. with art.5 of EmplClProt Act
439 art.30 sec.1 p.1 of LC in conn. with art.6 of EmplClProt Act
440 art.30 sec.1 p.2 of LC in conn. with art.6 of EmplClProt Act
441 art.30 sec.1 p.1 of LC in conn. with art.8 of EmplClProt Act
442 art.30 sec.1 p.2 of LC in conn. with art.8 of EmplClProt Act
443 art.30 sec.1 p.1 of LC in conn. with art.8a EmplClProt Act
444 art.30 sec.1 p.2 of LC in conn. with art.8a EmplClProt Act
445 art. 27 (1) p. 2 of Act on Probation Officers
446 art. 62 (1) point 2 of Act on State Labor Inspectorate
447 art. 71 (1) point 4 of Civil Service Act
448 art. 13 (1) point 2 of Act on Public Officers
449 art. 170 (1) p. 1 of Act introd. by State Fiscal Admin. Act
450 art. 97 (3) u. of Act intr. by State Property Man. Rules Act
451 art.30(1) p.1 LC in sp.per. in art.20 (1) p.1 a. p.2 TeachCh
452 art.30(1) p.2 LC in sp.per. in art.20 (1) p.1 a. p.2 TeachCh
453 art. 20(1) point 1 of Teacher's Charter
454 art. 20(1) point 2 of Teacher's Charter
455 art. 20 (5c) of Teacher's Charter
457 art. 20(7) point 1 of Teacher's Charter
458 art. 23(1) point 1 of Teacher's Charter
459 art. 23(4) point 1 of Teacher's Charter
460 art. 27(1) of Teacher's Charter
461 art. 225 cl. 1, 6 and 10 of act intr. Educational law
462 art. 225 cl. 7, point 1 of act intr. Educational law
463 art. 225 cl. 1 of act intr. Educational law
550 other legal ground
LTMTX Legal basis - other CHAR 72 0 PPL_LTMTX
TRMIN Initiative party CHAR 1 0 PPL_TRMIN
not indicated
1 employee
2 employer