| 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 | T000 | MANDT | Allow NULL? |
| 2 | SAMMG | IS-M: Group Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | JHSAMMG | Allow NULL? |
| 3 | SMART | IS-M/AM: Group Type for Collective Processing | char | 1 | 0 | CHAR | (N' ') | Yes | TJH81S | ISPSMART | Allow NULL? |
| 4 | ERNAM | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 5 | ERDAT | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 6 | UZEIT | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 7 | SSAMG | | nvarchar | 10 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 8 | STTYP | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 9 | VBNUM | IS-M: Number of Documents Created | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | JHVBNUM | Allow NULL? |
| 10 | HWNUM | IS-M: Output quantity | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | JHMSGNUM | Allow NULL? |
| 11 | EMNUM | IS-M: Number of 'E' messages | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | JHEMNUM | Allow NULL? |
| 12 | WMNUM | IS-M: Number of 'W' outputs | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | JHWMNUM | Allow NULL? |
| 13 | SMNUM | IS-M: Number of 'S' Output | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | JHSMNUM | Allow NULL? |
| 14 | IMNUM | IS-M: Number of 'I' Type Output | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | JHIMNUM | Allow NULL? |
| 15 | BRTWK | IS-M: Sales Volume (Gross) of Collective Processing Run | decimal | 15 | 2 | CURR | ((0)) | Yes | | JHSBRTWK | |
| 16 | WAERK | IS-M: Collective Processing Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | JHSWAERK | Allow NULL? |
| 17 | BRGEW | Gross weight of all processed documents | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BRGEW_SG | |
| 18 | GEWEI | Weight Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | GEWEI | Allow NULL? |
| 19 | VOLUM | Volume of all processed documents | decimal | 13 | 3 | QUAN | ((0)) | Yes | | VOLUM_SG | |
| 20 | VOLEH | Volume unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VOLEH | Allow NULL? |
| 21 | PROGRAMM | ABAP Program Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | TRDIR | PROGNAME | Allow NULL? |
| 22 | SELSET | Variant Name | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | JHSELSET | Allow NULL? |
| 23 | BATCH | IS-M: Batch Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JHBATCH | Allow NULL? |
| 24 | ANZGP | Number of items read in collective processing | int | 10 | 0 | INT4 | ((0)) | Yes | | ANZGP | Allow NULL? |
| 25 | ANZGI | Number of indexes read in collective processing | int | 10 | 0 | INT4 | ((0)) | Yes | | ANZGI | Allow NULL? |
| 26 | UEBAR | IS-M: Transfer type | char | 1 | 0 | CHAR | (N' ') | Yes | TJH41 | JHUEBART | Allow NULL? |
| 27 | UEBTY | IS-M: Transfer Category | char | 1 | 0 | CHAR | (N' ') | Yes | TJH43 | JHUEBTYP | Allow NULL? |