| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EQTYP | Equipment category | char | 1 | 0 | | | | Allow NULL? |
| 3 | REFTP | Equipment reference category | char | 1 | 0 | | | | Allow NULL? |
| 4 | NUMKI | Number range in the case of internal number assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | NUMKE | Number range in the case of external number assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | ZEIIN | Record usage history for equipment | char | 1 | 0 | | | | Allow NULL? |
| 7 | TPEIN | Installation at functional location permitted | char | 1 | 0 | | | | Allow NULL? |
| 8 | MSTKZ | Indicator for maintaining multi-lingual texts | char | 1 | 0 | | | | Allow NULL? |
| 9 | AEBKZ | Indicator showing equipment category with change documents | char | 1 | 0 | | | | Allow NULL? |
| 10 | PUEMA | No Alphanumeric Equipment Numbers | char | 1 | 0 | | | | Allow NULL? |
| 11 | STADY | Indicator for a fixed screen sequence | char | 1 | 0 | | | | Allow NULL? |
| 12 | STSMA | Status Profile | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | SDEQT | Equipment Category for Serial Numbers | char | 1 | 0 | | | | Allow NULL? |
| 14 | PARGR | Partner Determination Procedure | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | PARK1 | Partner Function for Current Customer in Serial Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | PARK2 | Partner Function for Equipment Vendor | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | PARK3 | Partner Function for Customer in Equipment Usage Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | PARK4 | Partner Function for Endcustomer in Equipment Usage Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | PARK5 | Partner Function for Operator in Equipment Usage Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | INFOW | Parameter ID Object Info | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | AMKNZ | Asset relevant indicator | char | 1 | 0 | | | | Allow NULL? |
| 22 | WFKNZ | Indicator: Generate Event for Workflow | char | 1 | 0 | | | | Allow NULL? |
| 23 | PASYN | Partner synchronization activated | char | 1 | 0 | | | | Allow NULL? |
| 24 | KZKSD | Serial data when maintaining equipment | char | 1 | 0 | | | | Allow NULL? |
| 25 | KONFKNZ | Configuration supported | char | 1 | 0 | | | | Allow NULL? |
| 26 | SDKNZ | Sales equipment | char | 1 | 0 | | | | Allow NULL? |
| 27 | FHMKZ | Equip. category relevant to production resources and tools | char | 1 | 0 | | | | Allow NULL? |
| 28 | ELSE_KNZ | Indicator: Other Data Active | char | 1 | 0 | | | | Allow NULL? |
| 29 | ISU_KNZ | IS-U data | char | 1 | 0 | | | | Allow NULL? |
| 30 | TSEGTP | Template | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | VIEW_PROF | View profile for tab index Customizing | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | NO_SER_ENQ | No Block when Assigning Serial Numbers | char | 1 | 0 | | | | Allow NULL? |
| 33 | BTMNS | Keep construction type and material number synchronous | char | 1 | 0 | | | | Allow NULL? |
| 34 | CC_KNZ | Configuration Control Data | char | 1 | 0 | | | | Allow NULL? |
| 35 | AEBKZ_INS | Equipment Type with Change Documents During Creation | char | 1 | 0 | | | | Allow NULL? |
| 36 | LFE_IND | Indicator: Object Belongs to Linear Asset Management | char | 1 | 0 | | | | Allow NULL? |
| 37 | J_3GBAUKNZ | CEM Equipment | char | 1 | 0 | | | | Allow NULL? |