| 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 | FKNUM | Shipment Cost Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | VFKK | FKNUM | Allow NULL? |
| 3 | FKPOS | Shipment costs item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | FKPOS | Allow NULL? |
| 4 | FKPTY | Item category shipment costs | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVFT | FKPTY | Allow NULL? |
| 5 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 6 | NETWR | Net value in currency of shipment cost item | decimal | 15 | 2 | CURR | ((0)) | Yes | | NETWR_P | |
| 7 | MWSBP | Tax amount in currency of shipment cost item | decimal | 13 | 2 | CURR | ((0)) | Yes | | MWSBP_P | |
| 8 | WAERS | Currency of the Shipment Cost Item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS_P | Allow NULL? |
| 9 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T007A | MWSKZ | Allow NULL? |
| 10 | PRSDT | Pricing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRSDT_P | Allow NULL? |
| 11 | BUDAT | Settlement date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_P | Allow NULL? |
| 12 | EXTI1 | External identification 1 Item | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | EXTI1_P | Allow NULL? |
| 13 | EXTI2 | External identification 2 Item | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | EXTI2_P | Allow NULL? |
| 14 | TPLST | Transportation planning point | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TTDS | TPLST | Allow NULL? |
| 15 | VSART | Shipping type for shipment stage | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T173 | VERSARTS | Allow NULL? |
| 16 | KALSM | Sales and Distribution: Pricing Procedure in Pricing | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSMASD | Allow NULL? |
| 17 | KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMV | Allow NULL? |
| 18 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 19 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T024E | EKORG | Allow NULL? |
| 20 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024 | BKGRP | Allow NULL? |
| 21 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EBELN | Allow NULL? |
| 22 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | EBELP | Allow NULL? |
| 23 | LBLNI | Entry Sheet Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LBLNI | Allow NULL? |
| 24 | PARVW | Partner Function | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TPAR | PARVW | Allow NULL? |
| 25 | TDLNR | Number of service agent | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | TDLNR_P | Allow NULL? |
| 26 | RECHS | Invoicing party for shipment cost item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | RECHST | Allow NULL? |
| 27 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | KURST | Allow NULL? |
| 28 | KOSTY | Cost type (shipment cost item) | char | 1 | 0 | CHAR | (N' ') | Yes | | KOSTY | Allow NULL? |
| 29 | REFTY | SD document category | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP | Allow NULL? |
| 30 | REBEL | Referenced document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REBEL | Allow NULL? |
| 31 | REPOS | Referenced document item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | REPOS_P | Allow NULL? |
| 32 | POSTX | Description for reference | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | POSTX | Allow NULL? |
| 33 | KNTTP | Account Assignment Category | char | 1 | 0 | CHAR | (N' ') | Yes | T163K | KNTTP | Allow NULL? |
| 34 | BKLAS | Valuation Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T025 | BWKLL | Allow NULL? |
| 35 | STBER | Status of calculation (shipment costs item data) | char | 1 | 0 | CHAR | (N' ') | Yes | | STBER_P | Allow NULL? |
| 36 | DTBER | Date of calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DTBER | Allow NULL? |
| 37 | UZBER | Time of calculation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZBER | Allow NULL? |
| 38 | STFRE | Status of account determination | char | 1 | 0 | CHAR | (N' ') | Yes | | STFRE_P | Allow NULL? |
| 39 | DTFRE | Date of account determination | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DTFRE | Allow NULL? |
| 40 | UZFRE | Time of account assignment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZFRE | Allow NULL? |
| 41 | STABR | Status of transfer (shipment costs item data) | char | 1 | 0 | CHAR | (N' ') | Yes | | STABR_P | Allow NULL? |
| 42 | DTABR | Date of settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DTABR_T | Allow NULL? |
| 43 | UZABR | Time of settlement | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZABR | Allow NULL? |
| 44 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 45 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 46 | ERZET | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 47 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 48 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 49 | AEZET | Time last change was made | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZET | Allow NULL? |
| 50 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TBDLS | LOGSYS | Allow NULL? |
| 51 | KSTAU | Cost distribution CO | char | 1 | 0 | CHAR | (N' ') | Yes | | KSTAU | Allow NULL? |
| 52 | TRFZNA | Tariff zone of point of departure | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TVFTZ | TRFZNA | Allow NULL? |
| 53 | TRFZNZ | Tariff zone of point of destination | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TVFTZ | TRFZNZ | Allow NULL? |
| 54 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TXJCD | Allow NULL? |
| 55 | BASWR | Tax base amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | BASWR_P | |
| 56 | SLAND1_A | Tax country departure | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | SLAND1_A | Allow NULL? |
| 57 | SLAND1_Z | Tax country destination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | SLAND1_Z | Allow NULL? |
| 58 | FKSTO | Shipment cost item already cancelled | char | 1 | 0 | CHAR | (N' ') | Yes | | FKSTO_P | Allow NULL? |
| 59 | KZWI1 | Subtotal 1 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI1 | |
| 60 | KZWI2 | Subtotal 2 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI2 | |
| 61 | KZWI3 | Subtotal 3 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI3 | |
| 62 | KZWI4 | Subtotal 4 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI4 | |
| 63 | KZWI5 | Subtotal 5 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI5 | |
| 64 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | CURR | ((0)) | Yes | | KZWI6 | |
