SAP table KLAH (Class Header Data)
SAP table KLAH has 2 primary key fields being MANDT,CLINT.
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 | |
| CLINT | Internal Class Number | NUMC | 10 | 0 | CLINT | ||
| KLART | Class Type | CHAR | 3 | 0 | TCLA | KLASSENART | |
| CLASS | Class number | CHAR | 18 | 0 | KLASSE_D | ||
| STATU | Class status | CHAR | 1 | 0 | TCLU | KLSTATUS | |
| KLAGR | Class Group | CHAR | 10 | 0 | TCLG | KLASSENGR | |
| BGRSE | Authorization group for finding objects | CHAR | 3 | 0 | BGRSE | ||
| BGRKL | Classification authorization group | CHAR | 3 | 0 | BGRKL | ||
| BGRKP | Class maintenance authorization group | CHAR | 3 | 0 | BGRKP | ||
| ANAME | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| ADATU | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| VNAME | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| VDATU | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| VONDT | Valid-From Date | DATS | 8 | 0 | VONDAT | ||
| BISDT | Valid-to date | DATS | 8 | 0 | BISDAT | ||
| ANZUO | Number of Assignments | NUMC | 5 | 0 | ANZUOR | ||
| PRAUS | Same classification | CHAR | 1 | 0 | GLKLAFZ | ||
| SICHT | Organizational Area | CHAR | 10 | 0 | ABTEILUNG | ||
| DOKNR | Document number | CHAR | 25 | 0 | DOKNR | ||
| DOKAR | Document Type | CHAR | 3 | 0 | DOKAR | ||
| DOKTL | Document Part | CHAR | 3 | 0 | DOKTL_D | ||
| DOKVR | Document Version | CHAR | 2 | 0 | DOKVR | ||
| DINKZ | DIN class indicator | CHAR | 1 | 0 | DINKEN | ||
| NNORM | Name of standards organization | CHAR | 10 | 0 | NORM | ||
| NORMN | Standard Number | CHAR | 20 | 0 | NORMNR | ||
| NORMB | Industry Standard Description | CHAR | 70 | 0 | NORMBE | ||
| NRMT1 | Standard title | CHAR | 70 | 0 | NORMTITEL | ||
| NRMT2 | Standard title | CHAR | 70 | 0 | NORMTITEL | ||
| AUSGD | Issue date | DATS | 8 | 0 | AUSGDT | ||
| VERSD | Version date | DATS | 8 | 0 | VERSDT | ||
| VERSI | Version Number | NUMC | 2 | 0 | VERSIO | ||
| LEIST | Characteristics table | CHAR | 20 | 0 | LEISTE | ||
| VERWE | Usage in superior classes | CHAR | 1 | 0 | VERWENDUNG | ||
| SPART | Division | CHAR | 2 | 0 | SPART | ||
| LREF3 | List object type for variable lists | CHAR | 3 | 0 | LISTOBJ | ||
| WWSKZ | Merchandize management system class type | CHAR | 1 | 0 | WWS_KLTYP | ||
| WWSSI | MMS view of collective material | CHAR | 1 | 0 | WWS_SICHT | ||
| POTPR | Resulting item category | CHAR | 1 | 0 | POTPR_CL | ||
| CLOBK | Required Component | CHAR | 1 | 0 | CLOBK | ||
| CLMUL | Multiple Selection Allowed | CHAR | 1 | 0 | CLMULT | ||
| CVIEW | Organizational Area | CHAR | 10 | 0 | ABTEILUNG | ||
| DISST | Low-Level Code | CHAR | 3 | 0 | DISST_CL | ||
| MEINS | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |
| CLMOD | Default Class Data - Can Be Overwritten in Component | CHAR | 1 | 0 | CLMOD | ||
| VWSTL | Can Be Used in Bills of Material | CHAR | 1 | 0 | VWSTL | ||
| VWPLA | Can Be Used in Task Lists | CHAR | 1 | 0 | VWPLA | ||
| CLALT | Alternative Display Format | CHAR | 1 | 0 | CLALT | ||
| LBREI | Total width of list | NUMC | 3 | 0 | LBREITE | ||
| BNAME | Block name | CHAR | 20 | 0 | BLNAME | ||
| MAXBL | Maximum display block for variable lists | CHAR | 18 | 0 | MAXBLOCK | ||
| KNOBJ | Number of Object with Assigned Dependencies | NUMC | 18 | 0 | KNOBJ | ||
| LOCLA | Local class | CHAR | 1 | 0 | LOCAL_CLASS | ||
| KATALOG | Name of External Catalog | CHAR | 30 | 0 | KATALOGNAME | ||
| KDOKAZ | Always Display Document for Class | CHAR | 1 | 0 | KDOKAZ | ||
| GENRKZ | Table for Finding Objects: To Be Generated=X, Generated=R | CHAR | 1 | 0 | GENRKZ | ||
| LASTCHANGEDDATETIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | DEC | 21 | 7 | TIMESTAMPL |
KLAH foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 KLAH | KLAGR | TCLG | Class Groups | MANDT |
| 0 KLAH | KLAGR | TCLG | Class Groups | KLAGR |
| 1 KLAH | KLART | TCLA | Class Types | MANDT |
| 0 KLAH | MANDT | T000 | Clients | MANDT |
| 1 KLAH | MEINS | T006 | Units of Measurement | MANDT |
| 1 KLAH | MEINS | T006 | Units of Measurement | MSEHI |
| 0 KLAH | STATU | TCLU | Class Status | MANDT |
| 0 KLAH | STATU | TCLU | Class Status | STATUS |