| 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 | LBLNI | Entry Sheet Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | LBLNI | Allow NULL? |
| 3 | LBLNE | External Entry Sheet Number | nvarchar | 16 | 0 | CHAR | (N' ') | No | | LBLNE1 | Allow NULL? |
| 4 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 5 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 6 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AEDAT | Allow NULL? |
| 7 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 8 | SBNAMAG | Person Responsible (Internally) | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SBNAMAG | Allow NULL? |
| 9 | SBNAMAN | Person Responsible (Externally) | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SBNAMAN | Allow NULL? |
| 10 | DLORT | Location Where Service Was Performed | nvarchar | 25 | 0 | CHAR | (N' ') | No | | DLORT | Allow NULL? |
| 11 | LBLDT | Price Reference Date of Entry Sheet | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | LBLDT | Allow NULL? |
| 12 | LZVON | Period | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | LZVON | Allow NULL? |
| 13 | LZBIS | End of period | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | LZBIS | Allow NULL? |
| 14 | LWERT | Value of Services | decimal | 11 | 2 | CURR | ((0)) | No | | LWERT | |
| 15 | UWERT | Portion from Unplanned Services | decimal | 11 | 2 | CURR | ((0)) | No | | NETWR_UNG | |
| 16 | UNPLV | Portion Unplanned Value Without Reference to Contract | decimal | 11 | 2 | CURR | ((0)) | Yes | | UNPLV | |
| 17 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | WAERS | Allow NULL? |
| 18 | PACKNO | Package number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | ESLH | PACKNO | Allow NULL? |
| 19 | TXZ01 | Short Text of Service Entry Sheet | nvarchar | 40 | 0 | CHAR | (N' ') | No | | TXZ01_ESSR | Allow NULL? |
| 20 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | EKKO | EBELN | Allow NULL? |
| 21 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | EKPO | EBELP | Allow NULL? |
| 22 | LOEKZ | Deletion indicator in entry sheet | char | 1 | 0 | CHAR | (N' ') | No | | LOEKZ_ESSR | Allow NULL? |
| 23 | KZABN | Acceptance indicator | char | 1 | 0 | CHAR | (N' ') | No | | KZABN | Allow NULL? |
| 24 | FINAL | Indicator: Final Entry Sheet | char | 1 | 0 | CHAR | (N' ') | No | | FINAL | Allow NULL? |
| 25 | FRGGR | Release group | nvarchar | 2 | 0 | CHAR | (N' ') | No | T16FG | FRGGR | Allow NULL? |
| 26 | FRGSX | Release Strategy | nvarchar | 2 | 0 | CHAR | (N' ') | No | T16FS | FRGSX | Allow NULL? |
| 27 | FRGKL | Release indicator: Entry sheet | char | 1 | 0 | CHAR | (N' ') | No | | FRGKL | Allow NULL? |
| 28 | FRGZU | Release status | nvarchar | 8 | 0 | CHAR | (N' ') | No | | FRGZU | Allow NULL? |
| 29 | FRGRL | Release Not Yet Completely Effected | char | 1 | 0 | CHAR | (N' ') | No | | FRGRL | Allow NULL? |
| 30 | F_LOCK | Block Release of Entry Sheet | char | 1 | 0 | CHAR | (N' ') | Yes | | F_LOCK | Allow NULL? |
| 31 | PWWE | Points score for quality of services | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWWE | |
| 32 | PWFR | Points score for on-time delivery | decimal | 3 | 0 | DEC | ((0)) | Yes | | MC_PWFR | |
| 33 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT_SRV | Allow NULL? |
| 34 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_SRV | Allow NULL? |
| 35 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR_SRV1 | Allow NULL? |
| 36 | BKTXT | Document Header Text | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | BKTXT_SRV | Allow NULL? |
| 37 | KNTTP | Account Assignment Category | char | 1 | 0 | CHAR | (N' ') | Yes | T163K | KNTTP | Allow NULL? |
| 38 | KZVBR | Consumption Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | KZVBR | Allow NULL? |
| 39 | NETWR | Net Value of Entry Sheet | decimal | 11 | 2 | CURR | ((0)) | Yes | | NETWR_ESSR | |
| 40 | BANFN | Purchase Requisition Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BANFN_ESSR | Allow NULL? |
| 41 | BNFPO | Item number of purchase requisition | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | EBAN | BNFPO_ESSR | Allow NULL? |
| 42 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | MPLA | WARPL | Allow NULL? |
| 43 | WAPOS | Maintenance item | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | WAPOS | Allow NULL? |
| 44 | ABNUM | Maintenance Plan Call Number | int | 10 | 0 | INT4 | ((0)) | Yes | | ABNUM | Allow NULL? |
| 45 | FKNUM | Shipment Cost Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VFKK | FKNUM | Allow NULL? |
| 46 | FKPOS | Shipment costs item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | VFKP | FKPOS | Allow NULL? |
| 47 | USER1 | Technical Reference Field for External Entry Sheet Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ESSR_D | Allow NULL? |
| 48 | USER2 | User field: Service entry sheet | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | USR_ESSR | Allow NULL? |
| 49 | NAVNW | Non-deductible input tax | decimal | 11 | 2 | CURR | ((0)) | Yes | | NAVNW_SRV | |
| 50 | SPEC_NO | Number of a Set of Model Service Specifications | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SPEC_NO | Allow NULL? |
| 51 | CUOBJ | Configuration (internal object number) | nvarchar | 18 | 0 | NUMC | (N'000000000000000000') | Yes | | CUOBJ | Allow NULL? |
| 52 | LEMIN | Returns Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SRVRET | Allow NULL? |
