SAP Table K7100003 stores data

  

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!


SAP K7100003 dictionary attributes

Object Name: K7100003
Dictionary Type: Structure
Description:


K7100003 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
GJAHRGJAHRNUMC4(0) Fiscal YearGJAHRGJRFB
PERIVPERIVCHAR2(0) *Fiscal Year VariantPERIVSAP
PERIOJAHRPERNUMC7(0) Period/yearJAHRPERKE
WRTTPRSVTYPENUMC3(0) *Value type for ReportingRSVTYPE
VERSIRKEVERSICHAR3(0) *Plan version (CO-PA)COVERSIPVSKE
VRGARRKE_VRGARCHAR1(0) *Record TypeVRGARVGAKE
CURTYPERSCURTYPECHAR2(0) Currency typeRSCURTYPE
VALUTYPVALUTYP_ACTNUMC1(0) ValuationVALUTYPVTP
ARTNRARTNRCHAR18(0) *Product numberMATNRMATKE
BRSCHBRSCHCHAR4(0) *Industry keyBRSCHVP
BUKRSBUKRSCHAR4(0) *Company CodeBUKRSBUKFBC_T001BUKRS
GSBERGSBERCHAR4(0) *Business AreaGSBERGSBFB
KOKRSKOKRSCHAR4(0) *Controlling AreaCACCDCACKS
KNDNRKUNDE_PACHAR10(0) *CustomerKUNNRVAG
BZIRKBZIRKCHAR6(0) *Sales districtBZIRKBZIV
KDGRPKDGRPCHAR2(0) *Customer groupKDGRPVKDV
KUKLAKUKLACHAR2(0) *Customer classificationKUKLAVP
LAND1LAND1_GPCHAR3(0) *Country KeyLAND1FBC_LAND1LAND1
WWPRCRKEG_WWPRCCHAR8(0) *Product categoryRKEG_WWPRCKE
PRCTRPRCTRCHAR10(0) *Profit CenterPRCTRPRCKEPRCTR_EMPTYPRCTR
REGIOREGIOCHAR3(0) *STATE (State, Province, County)REGIOFB
SPARTSPARTCHAR2(0) *DivisionSPARTSPAVC_SPARTSPART
WWSBURKEG_WWSBUCHAR8(0) *Strategic Bus.UnitRKEG_WWSBUKE
VKORGVKORGCHAR4(0) *Sales OrganizationVKORGVKOVC_VKORGVKORG
VKGRPVKGRPCHAR3(0) *Sales GroupVKGRPVKGV
VRTNRVRTNRNUMC8(0) Sales employeePERNRMCSPREMVPERNR
VTWEGVTWEGCHAR2(0) *Distribution ChannelVTWEGVTWVC_VTWEGVTWEG
MATKLMATKLCHAR9(0) *Material GroupMATKLMKLMGS_WBWGMATKL
WERKSWERKS_DCHAR4(0) *PlantWERKSWRKKCH_T001W_CWERKS
VVOQT_MERKE3_VVOQTUNIT3(0) *Un Ordered quantityMEINSMD
VVIQT_MERKE3_VVIQTUNIT3(0) *Un Invoiced quantityMEINSMD
REC_WAERSRKE_REC_WAERSCUKY5(0) *Currency of the data recordWAERS
VV100RKE2_VV100CURR15(2) Outgoing freightWERTV8KE
VV110RKE2_VV110CURR15(2) Accrued freightWERTV8KE
VV350RKE2_VV350CURR15(2) ScrapWERTV8KE
VV090RKE2_VV090CURR15(2) Accrued bonusWERTV8KE
VV220RKE2_VV220CURR15(2) Produc. Burn-in fixWERTV8KE
VV230RKE2_VV230CURR15(2) Produc. Burn-in varWERTV8KE
VV010RKE2_VV010CURR15(2) RevenueWERTV8KE
VVIQTRKE2_VVIQTQUAN15(3) Invoiced quantityMENGV15_3KE
VV170RKE2_VV170CURR15(2) Production Labor fixWERTV8KE
VV180RKE2_VV180CURR15(2) Production Labor varWERTV8KE
VV420RKE2_VV420CURR15(2) Research & Develop.WERTV8KE
VV240RKE2_VV240CURR15(2) Outside ProcessingWERTV8KE
VV160RKE2_VV160CURR15(2) Trading GoodsWERTV8KE
VV340RKE2_VV340CURR15(2) Input VariancesWERTV8KE
VVOQTRKE2_VVOQTQUAN15(3) Ordered quantityMENGV15_3KE
VV030RKE2_VV030CURR15(2) Customer discountWERTV8KE
VV320RKE2_VV320CURR15(2) Lot-size VarianceWERTV8KE
VV380RKE2_VV380CURR15(2) General Market.costsWERTV8KE
VV410RKE2_VV410CURR15(2) Marketing activitiesWERTV8KE
VV200RKE2_VV200CURR15(2) Produc. machine fixWERTV8KE
VV210RKE2_VV210CURR15(2) Produc. machine varWERTV8KE
VV150RKE2_VV150CURR15(2) Material InputWERTV8KE
VV250RKE2_VV250CURR15(2) Material OverheadWERTV8KE
VV040RKE2_VV040CURR15(2) Material discountWERTV8KE
VV300RKE2_VV300CURR15(2) Quant. Variance Mat.WERTV8KE
VV310RKE2_VV310CURR15(2) Quant. Variance ProdWERTV8KE
VV020RKE2_VV020CURR15(2) Quantity discountWERTV8KE
VV364RKE2_VV364CURR15(2) Mixed-price varianceWERTV8KE
VV290RKE2_VV290CURR15(2) Price varianceWERTV8KE
VV365RKE2_VV365CURR15(2) Price differencesWERTV8KE
VV400RKE2_VV400CURR15(2) Production costsWERTV8KE
VV190RKE2_VV190CURR15(2) Production SetupWERTV8KE
VV075RKE2_VV075CURR15(2) Actual Sales deduc.WERTV8KE
VV070RKE2_VV070CURR15(2) Accrued Sales deduc.WERTV8KE
VV360RKE2_VV360CURR15(2) Remaining VariancesWERTV8KE
VV280RKE2_VV280CURR15(2) Miscellaneous CostsWERTV8KE
VV060RKE2_VV060CURR15(2) Other rebatesWERTV8KE
VV330RKE2_VV330CURR15(2) Usage varianceWERTV8KE
VV130RKE2_VV130CURR15(2) Internal sales Comm.WERTV8KE
VV120RKE2_VV120CURR15(2) Dispatch packagingWERTV8KE
VV390RKE2_VV390CURR15(2) Distribution costsWERTV8KE
VV270RKE2_VV270CURR15(2) Sales OverheadWERTV8KE
VV370RKE2_VV370CURR15(2) Gen.Admin. costs CCAWERTV8KE
VV260RKE2_VV260CURR15(2) Administr. OverheadWERTV8KE
VV145RKE2_VV145CURR15(2) COGS alternativeWERTV8KE
VV140RKE2_VV140CURR15(2) Cost of goods soldWERTV8KE
VV480RKE2_VV480CURR15(2) MaintenanceWERTV8KE


View list of all tables