SAP VSAFIH_CN Version: Order header for plant maintenance Table
Overview
VSAFIH_CN is a standard SAP S/4HANA table that stores Version: Order header for plant maintenance data. There are total 55 fields in the VSAFIH_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSAFIH_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).
In addition, following links provide an overview of foreign key relationships, if any, that link VSAFIH_CN to other SAP tables and standard CDS views available based on VSAFIH_CN table in S/4HANA 2020.
Techincal Settings of VSAFIH_CN
Below are technical details of the table VSAFIH_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSAFIH_CN Fields
The following table gives you an overview of the fields available in VSAFIH_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| VSNMR | Number or description of a version | VSNMR | CHAR | 12 | |
| AUFNR | Order Number | AUFNR | CHAR | 12 | |
| ARTPR | Priority Type | ARTPR | T356A | CHAR | 2 |
| PRIOK | Priority | PRIOK | T356 | CHAR | 1 |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 |
| BAUTL | Assembly | BAUTL | MARA | CHAR | 40 |
| ILOAN | Location and account assignment for technical object | ILOAN | ILOA | CHAR | 12 |
| ILOAI | ILOA Individual | ILOAI | CHAR | 1 | |
| ANLZU | System Condition | ANLZU | T357M | CHAR | 1 |
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 |
| INGPR | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 |
| APGRP | Responsible Planner Group or Department | VAGRP | T024A | CHAR | 3 |
| PM_OBJTY | Object Type of CIM Resources for Work Center | PM_OBJTY | CHAR | 2 | |
| GEWRK | Object ID of the Work Center | LGWID | CRID | NUMC | 8 |
| KUNUM | Customer Number | KUNUM | KNA1 | CHAR | 10 |
| ANING | Name of Person Reponsible for System | ANING | CHAR | 12 | |
| GAUZT | Planned downtime in hours | GAUZT | FLTP | 16 | |
| GAUEH | Unit for Breakdown Duration | MAUEH | T006 | UNIT | 3 |
| ANLBD | Date until which the system is available | ANLBD | DATS | 8 | |
| ANLVD | Date from which the system is available | ANLVD | DATS | 8 | |
| ANLBZ | Time until which the system is available | ANLBZ | TIMS | 6 | |
| ANLVZ | Time from Which System is Available | ANLVZ | TIMS | 6 | |
| INSPK | Name of Person Responsible for Technical Inspection | INSPK | CHAR | 12 | |
| DATAN | Date of Technical Inspection | DATAN | DATS | 8 | |
| WARPL | Maintenance Plan | WARPL | MPLA | CHAR | 12 |
| ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | |
| WAPOS | Maintenance item | WAPOS | CHAR | 16 | |
| LAUFN | Order number | LAUFN | AUFK | CHAR | 12 |
| OBKNR | Object list number | OBJKNR | SER00 | INT8 | 19 |
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | T352R | CHAR | 8 |
| ADDAT | PM Order: Reference Date | ADDAT | DATS | 8 | |
| ADUHR | Time of Reference Date | ADUHR | TIMS | 6 | |
| IPHAS | Maintenance Processing Phase | PM_PHASE | CHAR | 1 | |
| ILART | Maintenance activity type | ILA | T353I | CHAR | 3 |
| QMNUM | Notification Number | QMNUM | QMEL | CHAR | 12 |
| HISDA | PM request: History date | HISDA | DATS | 8 | |
| AKKNZ | Order Category Indicator Plant Maintenance | AKKNZ | CHAR | 1 | |
| PLKNZ | Maintenance order planning indicator | AUF_PLKNZ | CHAR | 1 | |
| SERIALNR | Serial Number | GERNR | CHAR | 18 | |
| SERMAT | Material Number | MATNR | MARA | CHAR | 40 |
| DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | |
| SCREENTY | Scenario or Subscreen Category | SCRTP | TQBT | CHAR | 4 |
| ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | |
| RSUPG | Upgrade Order Indicator | RSUPG | CHAR | 1 | |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | |
| MAINTORDPERSONRESPONSIBLE | Person Responsible ID | EAMS_PERSON_RESPONSIBLE | CHAR | 12 | |
| MAINTORDOVRLPROCPHASE | Overall Process Phase | EAM_OSTAT_PHASE | CHAR | 2 | |
| MAINTORDOVRLPROCSUBPHASE | Overall Process Subphase | EAM_OSTAT_SPHASE | * | CHAR | 4 |
| /ISDFPS/OBJNR | Object number | J_OBJNR | * | CHAR | 22 |
| /ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | * | CHAR | 18 |
| /ISDFPS/MHIO_ADDATE | Completion Date for Call Object | MHIO_ADDAT | DATS | 8 | |
| /ISDFPS/MHIO_ADTIME | Completion Time for Call Object | MHIO_ADUHR | TIMS | 6 | |
| /ISDFPS/USERMODE | Scheduling determined by user | USERMOD | CHAR | 1 | |
| UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VSAFIH_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSAFIH_CN | ANLZU | C: CN | T357M |
| VSAFIH_CN | APGRP | C: CN | T024A |
| VSAFIH_CN | ARTPR | C: CN | T356A |
| VSAFIH_CN | BAUTL | C: CN | MARA |
| VSAFIH_CN | EQUNR | C: CN | EQUI |
| VSAFIH_CN | GAUEH | C: CN | T006 |
| VSAFIH_CN | GEWRK | C: CN | CRID |
| VSAFIH_CN | ILART | : | T353I |
| VSAFIH_CN | ILOAN | C: CN | ILOA |
| VSAFIH_CN | INGPR | C: CN | T024I |
| VSAFIH_CN | IWERK | C: CN | T399I |
| VSAFIH_CN | KUNUM | C: CN | KNA1 |
| VSAFIH_CN | LAUFN | C: CN | AUFK |
| VSAFIH_CN | OBKNR | : | SER00 |
| VSAFIH_CN | PRIOK | C: CN | T356 |
| VSAFIH_CN | QMNUM | : | QMEL |
| VSAFIH_CN | REVNR | : | T352R |
| VSAFIH_CN | SCREENTY | : | TQBT |
| VSAFIH_CN | SERMAT | : | MARA |
| VSAFIH_CN | WARPL | C: CN | MPLA |