SAP Table A004 stores Materialdata

  

In this post, I will try and describe everything you need to know about the SAP a004 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 A004 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 A004....Right lets get started!


SAP A004 dictionary attributes

Object Name: A004
Dictionary Type: Pooled table
Description: Material


A004 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
KAPPLKAPPLCHAR2(0) T681AApplicationKAPPLKAPVF
KSCHLKSCHACHAR4(0) T685Condition typeKSCHLVKSVF
VKORGVKORGCHAR4(0) TVKOSales OrganizationVKORGVKOVC_VKORGVKORG
VTWEGVTWEGCHAR2(0) TVTWDistribution ChannelVTWEGVTWVC_VTWEGVTWEG
MATNRMATNRCHAR18(0) MARAMaterial NumberMATNRMATMGS_MAT1MATNR
DATBIKODATBIDATS8(0) Validity end date of the condition recordDATUMVF
DATABKODATABDATS8(0) Validity start date of the condition recordDATUMVF
KNUMHKNUMHCHAR10(0) Condition record numberKNUMBVF


View list of all tables