| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | * | MATNR | Allow NULL? |
| 3 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | WERKS_D | Allow NULL? |
| 4 | OBJTY | Object types of the CIM resource | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CR_OBJTY | Allow NULL? |
| 5 | OBJID | Object ID of the resource | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | CR_OBJID | Allow NULL? |
| 6 | ZAEHL | Internal counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CIM_COUNT | Allow NULL? |
| 7 | OBJTY_V | Object types of the CIM resource | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CR_OBJTY | Allow NULL? |
| 8 | OBJID_V | Object ID of the resource | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | CR_OBJID | Allow NULL? |
| 9 | KZKBL | Indicator: Create load records for prod. resources/tools | char | 1 | 0 | CHAR | (N' ') | Yes | | KZKBL | Allow NULL? |
| 10 | STEUF | Control key for management of production resources/tools | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | STEUF | Allow NULL? |
| 11 | STEUF_REF | Control key cannot be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_STKZR | Allow NULL? |
| 12 | FGRU1 | Grouping key 1 for production resources/tools | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FGRUA | Allow NULL? |
| 13 | FGRU2 | Grouping key 2 for production resources/tools | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FGRUB | Allow NULL? |
| 14 | PLANV | Production resource/tool usage | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | FH_PLANV | Allow NULL? |
| 15 | KTSCH | Standard text key for production resources/tools | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | * | CF_KTSCH | Allow NULL? |
| 16 | KTSCH_REF | Reference Key Cannot be Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_KTKZR | Allow NULL? |
| 17 | BZOFFB | Reference date to start of production resource/tool usage | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BZOFFB | Allow NULL? |
| 18 | BZOFFB_REF | Start reference date cannot be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_BBKZR | Allow NULL? |
| 19 | OFFSTB | Offset to start of production resource/tool usage | decimal | 5 | 0 | QUAN | ((0)) | Yes | | OFFSTB | |
| 20 | EHOFFB | Offset unit for start of prod. resource/tool usage | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | EHOFFB | Allow NULL? |
| 21 | OFFSTB_REF | Offset to start cannot be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_OBKZR | Allow NULL? |
| 22 | BZOFFE | Reference date for end of production resource/tool usage | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BZOFFE | Allow NULL? |
| 23 | BZOFFE_REF | End reference date cannot be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_BEKZR | Allow NULL? |
| 24 | OFFSTE | Offset to finish of production resource/tool usage | decimal | 5 | 0 | QUAN | ((0)) | Yes | | OFFSTE | |
| 25 | EHOFFE | Offset unit for end of production resource/tool usage | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | EHOFFE | Allow NULL? |
| 26 | OFFSTE_REF | Offset to end cannot be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_OEKZR | Allow NULL? |
| 27 | MGFORM | Formula for calculating the total quantity of PRT | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | CF_MGFORM | Allow NULL? |
| 28 | MGFORM_REF | Formula for calculating the total quantity cannot be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_MFKZR | Allow NULL? |
| 29 | EWFORM | Formula for calculating the total usage value of PRT | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | CF_EWFORM | Allow NULL? |
| 30 | EWFORM_REF | Formula to calculate entire usage value cannot be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CF_EFKZR | Allow NULL? |
| 31 | PAR01 | First parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | CF_PAR01 | Allow NULL? |
| 32 | PAR02 | Second parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | CF_PAR02 | Allow NULL? |
| 33 | PAR03 | Third parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | CF_PAR03 | Allow NULL? |
| 34 | PAR04 | Fourth parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | CF_PAR04 | Allow NULL? |
| 35 | PAR05 | Fifth parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | CF_PAR05 | Allow NULL? |
| 36 | PAR06 | Sixth parameter (for formulas) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | CF_PAR06 | Allow NULL? |
| 37 | PARU1 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CF_PARUNIT | Allow NULL? |
| 38 | PARU2 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CF_PARUNIT | Allow NULL? |
| 39 | PARU3 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CF_PARUNIT | Allow NULL? |
| 40 | PARU4 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CF_PARUNIT | Allow NULL? |
| 41 | PARU5 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CF_PARUNIT | Allow NULL? |
| 42 | PARU6 | Parameter unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CF_PARUNIT | Allow NULL? |
| 43 | PARV1 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CF_PARVAL | |
| 44 | PARV2 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CF_PARVAL | |
| 45 | PARV3 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CF_PARVAL | |
| 46 | PARV4 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CF_PARVAL | |
| 47 | PARV5 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CF_PARVAL | |
| 48 | PARV6 | Parameter value | decimal | 9 | 3 | QUAN | ((0)) | Yes | | CF_PARVAL | |
