SAP table IHSG (Object-Related Permits in Plant Maintenance)
SAP table IHSG has 3 primary key fields being MANDT,OBJNR,COUNTER.
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 | |
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |
| COUNTER | Counter for differentiation 6-digit | NUMC | 6 | 0 | I_COUNT | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| PMSOG | Permit Key | CHAR | 10 | 0 | T357G | PMSOG | |
| K_AF | Indicator: Valid for Order Release | CHAR | 1 | 0 | K_AF | ||
| K_AA | Indicator: Valid for Order Completion | CHAR | 1 | 0 | K_AA | ||
| K_DRUCK | Printout of Permit Papers | CHAR | 1 | 0 | K_DRUCK | ||
| K_PRO | Indicator: Permit Proposed During Processing | CHAR | 1 | 0 | K_PRO | ||
| KZLTX | Long Text for Permit | CHAR | 1 | 0 | KZLTG | ||
| EQUNR | Equipment Number | CHAR | 18 | 0 | EQUNR | ||
| TPLNR | Functional Location | CHAR | 30 | 0 | TPLNR | ||
| AUFNR | Order Number | CHAR | 12 | 0 | AUFNR | ||
| VORNR | Operation/Activity Number | CHAR | 4 | 0 | VORNR | ||
| K_OBJEKT | Indicator: For Which Object the Permit Was Created | CHAR | 1 | 0 | K_OBJEKT | ||
| IHASP | Language in Which the Piece of Equipment was Entered | LANG | 1 | 0 | T002 | EQASP | |
| K_NODEL | Changeability of Permits | CHAR | 1 | 0 | K_NODEL | ||
| K_SKIP | Relevance of Permit | CHAR | 1 | 0 | K_SKIP | ||
| K_ORIGIN | Indicator: Permit Origin in Order | CHAR | 1 | 0 | K_ORIGIN | ||
| CLASS | Class number | CHAR | 18 | 0 | KLASSE_D | ||
| LVORM | Deletion Indicator | CHAR | 1 | 0 | LVORM | ||
| PLNTY | Task List Type | CHAR | 1 | 0 | PLNTY | ||
| PLNNR | Key for Task List Group | CHAR | 8 | 0 | PLNNR | ||
| PLNAL | Group Counter | CHAR | 2 | 0 | PLNAL |
IHSG foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 IHSG | IHASP | T002 | Language Keys (Component BC-I18) | SPRAS |
| 1 IHSG | MANDT | T000 | Clients | MANDT |
| 0 IHSG | OBJNR | ONR00 | General Object Number | MANDT |
| 1 IHSG | PMSOG | T357G | Permits | MANDT |
| 1 IHSG | PMSOG | T357G | Permits | SOGEN |