| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Mandant | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | PERNR | Personalnummer | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PA0003 | PERSNO | Allow NULL? |
| 3 | PLVAR | Planvariante | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778P | PLVAR | Allow NULL? |
| 4 | OTYPE | Objekttyp | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T778O | OTYPE | Allow NULL? |
| 5 | OBJID | Objekt-Id | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PLOGI | HROBJID | Allow NULL? |
| 6 | SUBTY | Subtyp | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SUBTYP | Allow NULL? |
| 7 | ISTAT | Planungsstatus | char | 1 | 0 | CHAR | (N' ') | Yes | T778S | ISTAT_D | Allow NULL? |
| 8 | BEGDA | Beginndatum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDATUM | Allow NULL? |
| 9 | ENDDA | Endedatum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDATUM | Allow NULL? |
| 10 | VARYF | Variationsfeld der Datei PLOG | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VARYF | Allow NULL? |
| 11 | SEQNR | Nummer eines Infotypsatzes bei gleichem Schlüssel | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SEQNR | Allow NULL? |
| 12 | INFTY | Infotyp | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | INFOTYP | Allow NULL? |
| 13 | OTJID | Konkatenation von Objekttyp und Objekt-ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | OTJID | Allow NULL? |
| 14 | AEDTM | Änderungsdatum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDTM | Allow NULL? |
| 15 | UNAME | Benutzername | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | USRNAME | Allow NULL? |
| 16 | REASN | Grund | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | REASN | Allow NULL? |
| 17 | HISTO | Historisierungskennzeichen | char | 1 | 0 | CHAR | (N' ') | Yes | | HISTO | Allow NULL? |
| 18 | ITXNR | Textbaustein zum Infotyp | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | ITXNR | Allow NULL? |
| 19 | MOLGA | Ländergruppierung | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T500L | MOLGA | Allow NULL? |
| 20 | TRFAR | Tarif-/Gehaltsart | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T510A | P_CPTYP | Allow NULL? |
| 21 | TRFGB | Tarif-/Gehaltsgebiet | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T510G | P_CPREG | Allow NULL? |
| 22 | TRFKZ | Gruppierung der Mitarbeiterkreise für Tarifregelung | char | 1 | 0 | CHAR | (N' ') | Yes | | TRFKZ | Allow NULL? |
| 23 | TRFG1 | Niedrigste zulässige Gruppe | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | P_CPGR1 | Allow NULL? |
| 24 | TRFG2 | Höchste zulässige Gruppe | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | P_CPGR2 | Allow NULL? |
| 25 | TRFS1 | Niedrigste zulässige Stufe | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P_CPLV1 | Allow NULL? |
| 26 | TRFS2 | Höchste zulässige Stufe | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P_CPLV2 | Allow NULL? |
| 27 | BUDG1 | Sollbezahlung von | decimal | 9 | 2 | CURR | ((0)) | Yes | | BUDG1 | |
| 28 | BUDG2 | Sollbezahlung bis | decimal | 9 | 2 | CURR | ((0)) | Yes | | BUDG2 | |
| 29 | CURCY | Währungsschlüssel | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 30 | MIDPT | Mittelwert | decimal | 11 | 2 | CURR | ((0)) | Yes | | MIDPT | |
| 31 | FREQU | Zeiteinheit für Vergütung | char | 1 | 0 | CHAR | (N' ') | Yes | T710F | CMP_FREQU | Allow NULL? |
| 32 | CPIND | Typ der Sollbezahlung | char | 1 | 0 | CHAR | (N' ') | Yes | | P_CPIND | Allow NULL? |
| 33 | CPMIN | Untergrenze der Tarif-/Gehaltsstufe | decimal | 13 | 2 | CURR | ((0)) | Yes | | P_SLMIN | |
| 34 | CPMAX | Obergrenze der Tarif-/Gehaltsstufe | decimal | 13 | 2 | CURR | ((0)) | Yes | | P_SLMAX | |
