| 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 | PALEDGER | Currency type for an operating concern | nvarchar | 2 | 0 | CHAR | (N' ') | No | TKEL | LEDBO | Allow NULL? |
| 3 | VRGAR | Record Type | char | 1 | 0 | CHAR | (N' ') | No | TVGA | RKE_VRGAR | Allow NULL? |
| 4 | VERSI | Plan version (CO-PA) | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKVS | RKEVERSI | Allow NULL? |
| 5 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | RKEOBJNR | Allow NULL? |
| 6 | PASUBNR | Profitability segment changes (CO-PA) | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RKESUBNR | Allow NULL? |
| 7 | BELNR | Document number of line item in Profitability Analysis | nvarchar | 10 | 0 | CHAR | (N' ') | No | | RKE_BELNR | Allow NULL? |
| 8 | PERBL | Fiscal year/period block | nvarchar | 7 | 0 | NUMC | (N'0000000') | No | | JAHRPERBL | Allow NULL? |
| 9 | HZDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 10 | USNAM | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFASSER | Allow NULL? |
| 11 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 12 | PAPAOBJNR | Partner profitability segment number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEPOBJ | Allow NULL? |
| 13 | PAPASUBNR | Changes to partner profitability segments (CO-PA) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RKEPSUBNR | Allow NULL? |
| 14 | KNDNR | Customer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNDE_PA | Allow NULL? |
| 15 | ARTNR | Product number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | ARTNR | Allow NULL? |
| 16 | FKART | Billing Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVFK | FKART | Allow NULL? |
| 17 | FRWAE | Foreign currency key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FRWAE | Allow NULL? |
| 18 | REC_WAERS | Currency of the data record | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | RKE_REC_WAERS | Allow NULL? |
| 19 | KAUFN | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | KDAUF | Allow NULL? |
| 20 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 21 | RKAUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | AUFNR | Allow NULL? |
| 22 | SKOST | Sender cost center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKS | SKOST | Allow NULL? |
| 23 | PRZNR | Sender Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | CBPR | SEPRZ | Allow NULL? |
| 24 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 25 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKA01 | KOKRS | Allow NULL? |
| 26 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 27 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 28 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 29 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWEG | Allow NULL? |
| 30 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPART | Allow NULL? |
| 31 | HRKFT | Origins (CO-PA) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RKEHERK | Allow NULL? |
| 32 | KSTAR | Cost Element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CSKA | KSTAR | Allow NULL? |
| 33 | PSPNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PRPS | PS_PSP_PNR | Allow NULL? |
| 34 | KSTRG | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | CKPH | KSTRG | Allow NULL? |
| 35 | RBELN | Reference document number for CO-PA line item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RKERFBELNR | Allow NULL? |
| 36 | RPOSN | Item number from reference document (CO-PA) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | RKERFPOSNR | Allow NULL? |
| 37 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CEPC | PRCTR | Allow NULL? |
| 38 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CEPC | PPRCTR | Allow NULL? |
| 39 | RKESTATU | Update status for CO-PA line items | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RKESTATU | Allow NULL? |
| 40 | TIMESTMP | Time created (Greenwich Meantime) | decimal | 16 | 0 | DEC | ((0)) | Yes | | RKE_HZSTMP | |
| 41 | KMATYP | Aircraft Type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T2209 | RKESKMATYP | Allow NULL? |
| 42 | KMDEST | Destination | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T2211 | RKESKMDEST | Allow NULL? |
| 43 | KMFLTN | Flight Number | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T2215 | RKESKMFLTN | Allow NULL? |
| 44 | KMFLTY | Flight Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T2216 | RKESKMFLTY | Allow NULL? |
| 45 | KMIATA | IATA Season | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T2207 | RKESKMIATA | Allow NULL? |
| 46 | KMLEGS | Route Segment | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | T2213 | RKESKMLEGS | Allow NULL? |
| 47 | KMOPDY | Day of Operation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T2208 | RKESKMOPDY | Allow NULL? |
| 48 | KMORIG | Departure Location | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T2212 | RKESKMORIG | Allow NULL? |
| 49 | KMROUT | Rotation | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T2210 | RKESKMROUT | Allow NULL? |
| 50 | KMZONE | Zone | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T2214 | RKESKMZONE | Allow NULL? |
| 51 | KWBLOK_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 52 | KWFLHR_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 53 | KWFLKM_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 54 | KWFUEL_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 55 | KWPAXS_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 56 | KWSEAT_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 57 | KWBKPZ_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 58 | KWBLKS001 | Revenue: Block seats | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWBLKS | |
| 59 | KWBLOK001 | Block Hours | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RKESKWBLOK | |
| 60 | KWCATR001 | Catering | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWCATR | |
| 61 | KWCRWK001 | Crew Expenses | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWCRWK | |
| 62 | KWDEPR001 | Depreciation | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWDEPR | |
| 63 | KWEURO001 | Overflight Fees | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWEURO | |
| 64 | KWEXLR001 | Excess Luggage | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWEXLR | |
| 65 | KWFLHR001 | Flight Hours | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RKESKWFLHR | |
| 66 | KWFLKM001 | Number of Kilometers Flown | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RKESKWFLKM | |
| 67 | KWFLSC001 | Flight cost of sales | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWFLSC | |
| 68 | KWFLSR001 | In Flight Sales | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWFLSR | |
| 69 | KWFRGR001 | Freight | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWFRGR | |
| 70 | KWFUEL001 | Fuel Consumption | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RKESKWFUEL | |
| 71 | KWFULK001 | Fuel Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWFULK | |
| 72 | KWINSR001 | Insurance | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWINSR | |
| 73 | KWIREG001 | FlightIrregularities | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWIREG | |
| 74 | KWLFEE001 | Landing Fees | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWLFEE | |
| 75 | KWPAXR001 | Passenger Revenue | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWPAXR | |
| 76 | KWPAXS001 | Number of Passengers | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RKESKWPAXS | |
| 77 | KWPXHD001 | Passenger Handling | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWPXHD | |
| 78 | KWRESV001 | Reservation Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWRESV | |
| 79 | KWSEAT001 | Number of Available Seats | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RKESKWSEAT | |
| 80 | KWVERW001 | Administration Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWVERW | |
| 81 | KWAGTK001 | Sales agent commissn | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWAGTK | |
| 82 | KWWTFX001 | Fixed Maintenance Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWWTFX | |
| 83 | KWWTVA001 | Variable Maintenance Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWWTVA | |
| 84 | KWCRGK001 | Crew Salaries | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWCRGK | |
| 85 | KWSMKT001 | Sales & Marketing | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWSMKT | |
| 86 | KWGRHD001 | Ground Handling | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWGRHD | |
| 87 | KWBKPZ001 | No. of block seats | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RKESKWBKPZ | |
