| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | IN_RECNO | IB: Unique record number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 3 | VALFR | IBase: Valid From | decimal | 15 | 0 | | | | |
| 4 | VALTO | IBase: Valid To | decimal | 15 | 0 | | | | |
| 5 | AENNR | Change Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | DELFLAG | Yes/No (X/ ) | char | 1 | 0 | | | | Allow NULL? |
| 7 | INSTANCE | IB: Component (instance) | nvarchar | 18 | 0 | | | | Allow NULL? |
| 8 | MLANG | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 9 | SORTF | Sort string | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | OBJNR | IB: Component reservation | nvarchar | 22 | 0 | | | | Allow NULL? |
| 11 | IBASE | IBase: Number of the Installed Base/IBase | nvarchar | 18 | 0 | | | | Allow NULL? |
| 12 | AMOUNT | Quantity field, length 13, with +/- sign | decimal | 13 | 3 | | | | |
| 13 | UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | TECHS | Technical status from | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | IN_OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 17 | IN_GUID | Globally Unique Identifier | varbinary | 16 | 0 | | | | |
| 18 | OBJECTTYP | IB: Object Type of Component Master Record | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | VOID | iBase: Void Komponente | char | 1 | 0 | | | | Allow NULL? |
| 20 | CSTATUS | Status of component(Instance)from configuration perspective | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | CUCOCNT | Internal counter | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | EXPERT | User as expert | char | 1 | 0 | | | | Allow NULL? |
| 23 | MAT_VARIANT | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 24 | ATAUT | Justification | char | 1 | 0 | | | | Allow NULL? |
| 25 | KLART | Class Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | CRNAM | User who created the object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | | | |
| 28 | UPNAM | Last user to change object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 29 | UPTIM | Time (UTC) at which the object was last changed | decimal | 15 | 0 | | | | |
