| 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 | FUNCT | Function to be carried out by system | nvarchar | 3 | 0 | CHAR | (N' ') | No | | CO_FUNCT | Allow NULL? |
| 3 | OBART | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | J_OBART | Allow NULL? |
| 4 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | J_OBJNR | Allow NULL? |
| 5 | COUNTER | Counter for function preselection | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CO_CNT_FUNC | Allow NULL? |
| 6 | GROUP_NUM | Number of grouping of function preselections | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | CO_GROUP | Allow NULL? |
| 7 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 8 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 9 | REF_FUNCT | Function to be carried out by system | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CO_FUNCT | Allow NULL? |
| 10 | REF_OBART | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_OBART | Allow NULL? |
| 11 | REF_OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 12 | VERS_X | Simulation Order Created | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_VERS_X | Allow NULL? |
| 13 | COMP_X | Process step "Determine changes" executed | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_COMP_X | Allow NULL? |
| 14 | CHECK_X | Process Step: "Check Changes" Executed | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_CHECK_X | Allow NULL? |
| 15 | TRANS_X | Changes made | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_TRANS_X | Allow NULL? |
| 16 | EXPAND_FL | Procurement elements already searched for | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_EXPND | Allow NULL? |
| 17 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 18 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | VSNMR | Allow NULL? |
| 19 | COMPNUM | Unambiguous identification number of a comparison result | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | COMPNUM | Allow NULL? |
| 20 | USNAM | User name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USNAM | Allow NULL? |
| 21 | CPUTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 22 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 23 | ABGL_X | Change process is completed | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_ABGL_X | Allow NULL? |
| 24 | DATUV_OLD | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CCDAT | Allow NULL? |
| 25 | REF_COUNTER | Counter for function preselection | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CO_CNT_FUNC | Allow NULL? |
| 26 | OCMPF | Profile for OCM PP / PS | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | OCM_PROFILE | Allow NULL? |
| 27 | MAXCONFTYP | Type of conflict | char | 1 | 0 | NUMC | (N'0') | Yes | | OCM_CONF_TYP | Allow NULL? |
| 28 | LOGNUMBER | Application log: log number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BALOGNR | Allow NULL? |
| 29 | TSTMPS | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 30 | ERROR_COUNTER | Number of failed attempts (change process) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CO_ERROR_COUNTER | Allow NULL? |
| 31 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AENNR | Allow NULL? |
| 32 | LOG_HANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | BALLOGHNDL | Allow NULL? |