| 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 | KMBRND | Brand | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T2249 | RKESKMBRND | Allow NULL? |
| 42 | KMCATG | Business field | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T2248 | RKESKMCATG | Allow NULL? |
| 43 | KMHI01 | Customer hierarchy Level 1 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | HIEZU01 | Allow NULL? |
| 44 | KMHI02 | Customer hierarchy Level 2 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | HIEZU02 | Allow NULL? |
| 45 | KMHI03 | Customer hierarchy Level 3 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | HIEZU03 | Allow NULL? |
| 46 | KMKDGR | Customer group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T151 | KDGRP | Allow NULL? |
| 47 | KMLAND | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1_GP | Allow NULL? |
| 48 | KMMAKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | T023 | MATKL | Allow NULL? |
| 49 | KMNIEL | Nielsen ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNLS | NIELS | Allow NULL? |
| 50 | KMSTGE | Strategic Business Unit | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T2247 | RKESKMSTGE | Allow NULL? |
| 51 | KMVKBU | Sales Office | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVBUR | VKBUR | Allow NULL? |
| 52 | KMVKGR | Sales Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TVKGR | VKGRP | Allow NULL? |
| 53 | KMVTNR | Sales employee | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | VRTNR | Allow NULL? |
| 54 | KWSVME_ME | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | MEINS | Allow NULL? |
| 55 | KWABFK001 | Variance: Shipment Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWABFK | |
| 56 | KWABLG001 | Lot size variance | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWABLG | |
| 57 | KWABLK001 | Idle-Capacity Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWABLK | |
| 58 | KWABMG001 | Quantity Variance | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWABMG | |
| 59 | KWABPR001 | Price Variance | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWABPR | |
| 60 | KWABSG001 | Other variances | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWABSG | |
| 61 | KWABST001 | Resource-Usage Variance | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWABST | |
| 62 | KWAKRB001 | Spec. offer discount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWAKRB | |
| 63 | KWBONI001 | Bonuses | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWBONI | |
| 64 | KWBRUM001 | Gross sales | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWBRUM | |
| 65 | KWFKFX001 | Fixed Manufacturing Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWFKFX | |
| 66 | KWFKVA001 | Variable Production Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWFKVA | |
| 67 | KWFOEN001 | Research and Development | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWFOEN | |
| 68 | KWKDRB001 | Customer Discount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWKDRB | |
| 69 | KWKLFK001 | Accrued shipment costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWKLFK | |
| 70 | KWLOGI001 | Logistics | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWLOGI | |
| 71 | KWMAEK001 | Direct Material Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWMAEK | |
| 72 | KWMAGK001 | Material overhead costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWMAGK | |
| 73 | KWMARB001 | Material discount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWMARB | |
| 74 | KWMGRB001 | Quantity discount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWMGRB | |
| 75 | KWMKAD001 | Advertising | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWMKAD | |
| 76 | KWMKDP001 | Marketing Department | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWMKDP | |
| 77 | KWMKPR001 | Promotion | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWMKPR | |
| 78 | KWSKTO001 | Cash discount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWSKTO | |
| 79 | KWVERW001 | Administration Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWVERW | |
| 80 | KWVKPV001 | Sales commission | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWVKPV | |
| 81 | KWVSEK001 | Sales Special Direct Costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWVSEK | |
| 82 | KWVTAD001 | Sales field service | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWVTAD | |
| 83 | KWVTID001 | Sales office | decimal | 15 | 2 | CURR | ((0)) | Yes | | RKESKWVTID | |
| 84 | KWSVME001 | Sales quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | RKESKWSVME | |
