In this post, I will try and describe everything you need to know about the SAP k7100003 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for K7100003 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from K7100003....Right lets get started!
Object Name: K7100003
Dictionary Type: Structure
Description:
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| GJAHR | GJAHR | NUMC | 4(0) | Fiscal Year | GJAHR | GJR | FB | |||||
| PERIV | PERIV | CHAR | 2(0) | * | Fiscal Year Variant | PERIV | SAP | |||||
| PERIO | JAHRPER | NUMC | 7(0) | Period/year | JAHRPER | KE | ||||||
| WRTTP | RSVTYPE | NUMC | 3(0) | * | Value type for Reporting | RSVTYPE | ||||||
| VERSI | RKEVERSI | CHAR | 3(0) | * | Plan version (CO-PA) | COVERSI | PVS | KE | ||||
| VRGAR | RKE_VRGAR | CHAR | 1(0) | * | Record Type | VRGAR | VGA | KE | ||||
| CURTYPE | RSCURTYPE | CHAR | 2(0) | Currency type | RSCURTYPE | |||||||
| VALUTYP | VALUTYP_ACT | NUMC | 1(0) | Valuation | VALUTYP | VTP | ||||||
| ARTNR | ARTNR | CHAR | 18(0) | * | Product number | MATNR | MAT | KE | ||||
| BRSCH | BRSCH | CHAR | 4(0) | * | Industry key | BRSCH | VP | |||||
| BUKRS | BUKRS | CHAR | 4(0) | * | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | ||
| GSBER | GSBER | CHAR | 4(0) | * | Business Area | GSBER | GSB | FB | ||||
| KOKRS | KOKRS | CHAR | 4(0) | * | Controlling Area | CACCD | CAC | KS | ||||
| KNDNR | KUNDE_PA | CHAR | 10(0) | * | Customer | KUNNR | VAG | |||||
| BZIRK | BZIRK | CHAR | 6(0) | * | Sales district | BZIRK | BZI | V | ||||
| KDGRP | KDGRP | CHAR | 2(0) | * | Customer group | KDGRP | VKD | V | ||||
| KUKLA | KUKLA | CHAR | 2(0) | * | Customer classification | KUKLA | VP | |||||
| LAND1 | LAND1_GP | CHAR | 3(0) | * | Country Key | LAND1 | FB | C_LAND1 | LAND1 | |||
| WWPRC | RKEG_WWPRC | CHAR | 8(0) | * | Product category | RKEG_WWPRC | KE | |||||
| PRCTR | PRCTR | CHAR | 10(0) | * | Profit Center | PRCTR | PRC | KE | PRCTR_EMPTY | PRCTR | ||
| REGIO | REGIO | CHAR | 3(0) | * | STATE (State, Province, County) | REGIO | FB | |||||
| SPART | SPART | CHAR | 2(0) | * | Division | SPART | SPA | V | C_SPART | SPART | ||
| WWSBU | RKEG_WWSBU | CHAR | 8(0) | * | Strategic Bus.Unit | RKEG_WWSBU | KE | |||||
| VKORG | VKORG | CHAR | 4(0) | * | Sales Organization | VKORG | VKO | V | C_VKORG | VKORG | ||
| VKGRP | VKGRP | CHAR | 3(0) | * | Sales Group | VKGRP | VKG | V | ||||
| VRTNR | VRTNR | NUMC | 8(0) | Sales employee | PERNR | MCS | PREMV | PERNR | ||||
| VTWEG | VTWEG | CHAR | 2(0) | * | Distribution Channel | VTWEG | VTW | V | C_VTWEG | VTWEG | ||
| MATKL | MATKL | CHAR | 9(0) | * | Material Group | MATKL | MKL | MG | S_WBWG | MATKL | ||
| WERKS | WERKS_D | CHAR | 4(0) | * | Plant | WERKS | WRK | KC | H_T001W_C | WERKS | ||
| VVOQT_ME | RKE3_VVOQT | UNIT | 3(0) | * | Un Ordered quantity | MEINS | MD | |||||
| VVIQT_ME | RKE3_VVIQT | UNIT | 3(0) | * | Un Invoiced quantity | MEINS | MD | |||||
| REC_WAERS | RKE_REC_WAERS | CUKY | 5(0) | * | Currency of the data record | WAERS | ||||||
| VV100 | RKE2_VV100 | CURR | 15(2) | Outgoing freight | WERTV8 | KE | ||||||
| VV110 | RKE2_VV110 | CURR | 15(2) | Accrued freight | WERTV8 | KE | ||||||
| VV350 | RKE2_VV350 | CURR | 15(2) | Scrap | WERTV8 | KE | ||||||
| VV090 | RKE2_VV090 | CURR | 15(2) | Accrued bonus | WERTV8 | KE | ||||||
| VV220 | RKE2_VV220 | CURR | 15(2) | Produc. Burn-in fix | WERTV8 | KE | ||||||
| VV230 | RKE2_VV230 | CURR | 15(2) | Produc. Burn-in var | WERTV8 | KE | ||||||
| VV010 | RKE2_VV010 | CURR | 15(2) | Revenue | WERTV8 | KE | ||||||
| VVIQT | RKE2_VVIQT | QUAN | 15(3) | Invoiced quantity | MENGV15_3 | KE | ||||||
| VV170 | RKE2_VV170 | CURR | 15(2) | Production Labor fix | WERTV8 | KE | ||||||
| VV180 | RKE2_VV180 | CURR | 15(2) | Production Labor var | WERTV8 | KE | ||||||
| VV420 | RKE2_VV420 | CURR | 15(2) | Research & Develop. | WERTV8 | KE | ||||||
| VV240 | RKE2_VV240 | CURR | 15(2) | Outside Processing | WERTV8 | KE | ||||||
| VV160 | RKE2_VV160 | CURR | 15(2) | Trading Goods | WERTV8 | KE | ||||||
| VV340 | RKE2_VV340 | CURR | 15(2) | Input Variances | WERTV8 | KE | ||||||
| VVOQT | RKE2_VVOQT | QUAN | 15(3) | Ordered quantity | MENGV15_3 | KE | ||||||
| VV030 | RKE2_VV030 | CURR | 15(2) | Customer discount | WERTV8 | KE | ||||||
| VV320 | RKE2_VV320 | CURR | 15(2) | Lot-size Variance | WERTV8 | KE | ||||||
| VV380 | RKE2_VV380 | CURR | 15(2) | General Market.costs | WERTV8 | KE | ||||||
| VV410 | RKE2_VV410 | CURR | 15(2) | Marketing activities | WERTV8 | KE | ||||||
| VV200 | RKE2_VV200 | CURR | 15(2) | Produc. machine fix | WERTV8 | KE | ||||||
| VV210 | RKE2_VV210 | CURR | 15(2) | Produc. machine var | WERTV8 | KE | ||||||
| VV150 | RKE2_VV150 | CURR | 15(2) | Material Input | WERTV8 | KE | ||||||
| VV250 | RKE2_VV250 | CURR | 15(2) | Material Overhead | WERTV8 | KE | ||||||
| VV040 | RKE2_VV040 | CURR | 15(2) | Material discount | WERTV8 | KE | ||||||
| VV300 | RKE2_VV300 | CURR | 15(2) | Quant. Variance Mat. | WERTV8 | KE | ||||||
| VV310 | RKE2_VV310 | CURR | 15(2) | Quant. Variance Prod | WERTV8 | KE | ||||||
| VV020 | RKE2_VV020 | CURR | 15(2) | Quantity discount | WERTV8 | KE | ||||||
| VV364 | RKE2_VV364 | CURR | 15(2) | Mixed-price variance | WERTV8 | KE | ||||||
| VV290 | RKE2_VV290 | CURR | 15(2) | Price variance | WERTV8 | KE | ||||||
| VV365 | RKE2_VV365 | CURR | 15(2) | Price differences | WERTV8 | KE | ||||||
| VV400 | RKE2_VV400 | CURR | 15(2) | Production costs | WERTV8 | KE | ||||||
| VV190 | RKE2_VV190 | CURR | 15(2) | Production Setup | WERTV8 | KE | ||||||
| VV075 | RKE2_VV075 | CURR | 15(2) | Actual Sales deduc. | WERTV8 | KE | ||||||
| VV070 | RKE2_VV070 | CURR | 15(2) | Accrued Sales deduc. | WERTV8 | KE | ||||||
| VV360 | RKE2_VV360 | CURR | 15(2) | Remaining Variances | WERTV8 | KE | ||||||
| VV280 | RKE2_VV280 | CURR | 15(2) | Miscellaneous Costs | WERTV8 | KE | ||||||
| VV060 | RKE2_VV060 | CURR | 15(2) | Other rebates | WERTV8 | KE | ||||||
| VV330 | RKE2_VV330 | CURR | 15(2) | Usage variance | WERTV8 | KE | ||||||
| VV130 | RKE2_VV130 | CURR | 15(2) | Internal sales Comm. | WERTV8 | KE | ||||||
| VV120 | RKE2_VV120 | CURR | 15(2) | Dispatch packaging | WERTV8 | KE | ||||||
| VV390 | RKE2_VV390 | CURR | 15(2) | Distribution costs | WERTV8 | KE | ||||||
| VV270 | RKE2_VV270 | CURR | 15(2) | Sales Overhead | WERTV8 | KE | ||||||
| VV370 | RKE2_VV370 | CURR | 15(2) | Gen.Admin. costs CCA | WERTV8 | KE | ||||||
| VV260 | RKE2_VV260 | CURR | 15(2) | Administr. Overhead | WERTV8 | KE | ||||||
| VV145 | RKE2_VV145 | CURR | 15(2) | COGS alternative | WERTV8 | KE | ||||||
| VV140 | RKE2_VV140 | CURR | 15(2) | Cost of goods sold | WERTV8 | KE | ||||||
| VV480 | RKE2_VV480 | CURR | 15(2) | Maintenance | WERTV8 | KE |