| 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 | SES_NUMBER | Service Entry Sheet Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | /SAPBOQ/SES_NO | Allow NULL? |
| 3 | SHORT_TEXT | Service Entry Sheet - Header Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /SAPBOQ/SES_DESC | Allow NULL? |
| 4 | ORDER_NUMBER | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | VBELN | Allow NULL? |
| 5 | ITEM_NUMBER | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR | Allow NULL? |
| 6 | SUBSEQ_DOC | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | VBELN | Allow NULL? |
| 7 | SUBSEQ_POSNR | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN | Allow NULL? |
| 8 | PACKNO | Package number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | PACKNO | Allow NULL? |
| 9 | SESTYP | Service Entry Sheet Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | /SAPBOQ/SESTYP | /SAPBOQ/SESTYPE | Allow NULL? |
| 10 | STATUS | Service Entry Sheet Status | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPBOQ/SES_STAT | Allow NULL? |
| 11 | CREATE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 12 | ENTRY_TIME | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 13 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 14 | RELEASE_DATE | Release Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPBOQ/RELDT | Allow NULL? |
| 15 | RELEASE_TIME | Release Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /SAPBOQ/REL_TIME | Allow NULL? |
| 16 | RELEASED_BY | Released By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /SAPBOQ/RELBY | Allow NULL? |
| 17 | PRICE_PROC | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSM_D | Allow NULL? |
| 18 | REF_DOCUMENT | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | VBELN | Allow NULL? |
| 19 | REF_POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR | Allow NULL? |
