MATNR Field in SAP | Material Number Data Element using tables

MATNR is a data element in SAP used for storing Material Number data in table fields. Here is it basic details and list of tables using this MATNR field in SAP.

Data Element : MATNR
Description : Material Number
Data Type :CHAR

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

List of Tables using MATNR Field

Table	Note
A001	Not Used in Standard
A004	Material
A005	Customer/Material
A006	Price List Type/Currency/Material
A010	Additional Selling Plant/Material
A017	Material Info Record (Plant-Specific)
A018	Material Info Record
A021	Vendor/Material/Unit of Measure
A022	Material/Unit of Measure
A023	Additional Selling Plant/Material/Unit of Measure
A024	Distribution Channel/Material/Unit of Measure
A032	Price group/Material
A049	Market Price for Material
A052	Invoicing Party (Specific to Info Record)
A055	Sales conditions sample structure for pricing
A057	Variants
A065	Customer Hierarchy/Material
A066	Info record per order unit
A067	Plant Info Record per Order Unit
A070	EAN per Plant
A071	Material per Plant
A072	EAN per SOrg/DstCh
A073	Material per SOrg/DstCh
A074	Plant/Preference Zone/Material
A075	Master Conditions for SRV with Material Group
A083	Vendor Conditions with Plant
A084	Vendor Conditions without Plant
A089	SD Document/Material
A090	SD Document/Item/Material
A091	Wage Type Surcharge at Plant Level
A092	Wage Type Surcharge without Plant
A093	Wage Type Surcharge - General
A100	SOrg/DstCh/Material_MainItem/Material
A102	SOrg/DstCh/Material Pricing Group-Main Item/Material
A108	Vendor Hierarchy / Material
A117	Tax Exemption - Customer/Material
A118	"Empties" Prices (Material-Dependent)
A121	Legal Control: Values for Calculating Foreign Percentage
A133	Mixed Taxes, Domestic
A141	Dependent on material and receiver profit center
A142	Dependent on material
A144	Sales Deal Basic Data
A145	Sales Deal - Customer/Material
A148	Product Hierarchy
A150	Dest. Ctry/Material
A152	Sales Org./Dist. Channel/Plant/Material/Sales Unit/Customer
A153	Sales Org./Distribution Channel/Plant/Sales Unit/Customer
A154	SalesOrg./Dist.Channel/PriceList/Material/SalesUnit/Customer
A155	Sales Org./Dist. Channel/Price List/Material/Sales Unit
A160	Plant Info Record: Variants
A161	Info Record: Variants
A163	Number/Material
A172	Campaign ID/Material
A180	Country/Preference Zone/Cross-Plant Grouping
A184	ACRN ID/Material/Version Number/Priority
A185	Order no./Item/Configuration no./Material/Preference zone
A254	Customer or Goods Recipient/Equipment/Material
A256	Customer/Catalog Group 2/Material
A265	Standard Dummy Customer/Document Type/Material Grp/Material
A266	Standard Dummy Customer/Material Group/Material Number
A267	Customer or Goods Recipient/Equipment Type/Material
A273	Sales org./Distr. chl/Division/Material/Customer/Item
A274	Sales org./Distr. chl/Division/Material/Item
A275	Material/Agreement Data for ATO/MTS Components
A276	Agreement Data and status with agreement search
A278	ETM Material / Activity Type
A279	ETM Goods Recipient/Material/Activity Type
A303	SD doc./Item/Material/CompMat/CompSup/CompType
A304	Material with release status
A305	Customer/material with release status
A306	Price list category/currency/material with release status
A310	Duty Rate Customs Exemption: Importing Ctry/Code/Material
A315	Cust.Duty Anti-dumping: Import/Code/Orig.ctry/Manu./Exp./Mat
A325	Duties Pharma. Products: Import country/Code/CAS/Material
A330	Preferential Cust.Duties: Imp.ctry/Orig.ctry/Ship.ctry/Matl
A335	Quota Duty Rate: Imp.ctry/Code/Orig.ctry/Proc./Mat/Quota
A343	BR: SubstituiÃ§ao TributÃ¡ria from SD
A349	Land/ST/MATNR
A358	Country/Plant/Ctrl code/Material
A360	Location / Service type / Material - Street price
A361	LocationID/Material - Street price
A363	Plant/Vendor/Material
A364	Trading Contract/Vendor/Material
A365	Trading Contract/Vendor/Material
A367	Country/Plant/Region/Material
A373	Country/Plant/Material
A383	Category/Partner/Material
A384	Category/Material
A385	Sales Org./DChann./Division/Material/Status/Proc.Status
A396	Arg.: Country/Fisc.Type/Material
A402	SalesOrg/DistribCh/SDContractNo/Material
A403	SalesOrg/DistribCh/SDContractNo/Plant/Material
A404	Customer/Material/Plant
A405	ContractNr/Well/WC/Material (obsolete -> replaced by A416)
A406	Plant/material
A410	Customer/ Plant/ Material/ Base Product
A411	ContractNr/MP ID/Material (obsolete -> replaced by A438)
A412	Vendor/Plant/Material/Base Product
A416	PRA Pricing - Contract, Well, Well Completion, Material
A417	ContractNr/Material (obsolete -> replaced by A440)
A422	DRC: Sales Area/Material/Wide Area Pricing
A429	DRC: Sales Area/Material/State License Fee Zone
A430	DRC: Sales Area/Material/DRC Country
A431	DRC: Sales Area/Material/DRC Region
A432	DRC: Sales Area/Material/DRC Country/DRC Region
A436	Agreement data in combination with Agreement search
A437	Material/Customer/Agreement data
A438	PRA Pricing - Contract, Measurement Point, Material
A439	Material/Agreement data
A440	PRA Pricing - Contract, Material
A441	CRP Pricing with COND CODE
A444	Two-step transfer with tracking sign
A445	Material
ABS_IV_KEYFI_ITM	Absolute Key Figures at Item Level
ACCTIT	Compressed Data from FI/CO Document
AD01DLI	Dynamic items (DI)
AD01WIP_MAT_RCAT	WIP revenue category determination by Material
AD01WIP_REV	WIP Details
ADPIC_HOLD_MIGO	Store BADI goitem for MIGO hold / restore functionality
ADPIC_HOLD_MPN	Store MPN subitems for MIGO hold / restore functionality
AFFW	Goods Movements with Errors from Confirmations
AFFWPRO	Log of deleted AFFW entries
AFIH	Maintenance order header
AFKO	Order Header Data PP Orders
ALE_BATCHES_RECP	Received Batches
ALE_BATCHES_SENT	Sent Batches
ALE_MCHA_OBJECT	Batches to be distributed from dec. WM
ANEK	Document Header Asset Posting
AUAA	Settlement Document: Receiver Segment
AUBF	Document Flow SAP Retail (Allocation Table, Promotions...)
AUBSI	Worklist for PO (Follow-on Document Generation)
AUFM	Goods movements for order
AUKAI	Worklist for Sales Orders (FBG)
AUPO	Allocation Table Document Item
AUUMI	Worklist for Stock Transport Orders (Follow-on Doc. Gen.)
AUVDI	Worklist for Deliveries (Follow-on Doc. Generation)
AUWEI	Index, Adjust Alloc Tbl After Entering Doc.
BAD_CUBIN	BAD - Configuration Values
BAD_CUCFG	BAD - Configuration Data IDs
BAD_CUCHARTXT	BAD - Configuration Values
BAD_CUINS	BAD - Instance of Configuration
BAD_CUPRT	BAD - Item: Part of data
BAD_CUVAL	BAD - Configuration Values
BAD_CUVALTXT	BAD - Configuration Values
BAD_CUVARC	BAD - Variant Condition
BAPIPIC	Product info (screens) for ATP information in the internet
BLPK	Document log header
BNMAT	Assignment of Material No.-Number Range for Batch No. Assgmt
BORRTFI	Regular tour determinatin (route schedule inbound delivery)
BSEG	Accounting Document Segment
BSEG_ADD	Entry View of Accounting Document for Additional Ledgers
BSIM	Secondary Index, Documents for Material
BSIM_BAK	Secondary Index, Documents for Material
CABN_EXCL	Characteristics That Are Excluded for Type Matching
CAD_PARTS	Table for Assignment of Standard Material to Material Nos
CCDUTDGRELLKEY	DG: Dummy Table for Lock Obj. on Log. Key for CCDUTDGREL
CCGLT_AUDH	EHS: Audit Data Header Entry
CCGLT_MTLD	EHS: Labeling Data for a Material
CCGLT_MTLS	EHS: Label Definition for a Material
CCGLT_PRTREQ_HDR	EHS: Print Request Header Table
CCGLT_PR_HDR_UT2	EHS: Print Request Header Table Test Data for Unit Test
CCMHOLE	Structure Gap Table
CCRCC_BW	EHS: Maintenance of Bonded Warehouses
CCRCT_CALC	EHS: Calculated Average
CCRCT_CO	EHS: Confirmed Consumed Quantities
CCRCT_COPL	EHS: Planned Consumed Quantities
CCRCT_CU	EHS: Customer List - Header Data
CCRCT_EHS_COMP	EHS: Composition (EH&S Data)
CCRCT_EHS_WL	EHS: Worklist of Changed Materials
CCRCT_LOCK	EHS: Blocked Documents
CCRCT_OR	Material Business Partner Only Representative Assignment
CCRCT_PR	EHS: Confirmed Produced Quantities
CCRCT_PRPL	EHS: Planned Produced Quantities
CCRCT_PU	EHS: Confirmed Purchased Quantities
CCRCT_PUPL	EHS: Planned Purchased Quantities
CCRCT_SO	EHS: Confirmed Sold Quantities
CCRCT_SOPL	EHS: Planned Sold Quantities
CDBD_DELIVERY_H	Table for storing the delivery header details
CDBD_DELIVERY_I	Table to store the delivery items
CDBD_GM_I	Material Document Item Table
CDBD_PO_I	Purchase Order item - CDB table
CDBD_PR_H	Purchase Requisition header - CDB table
CDBD_PR_I	Purchase Requisition item - CDB table
CDBD_STOCK	Van Stock details for Plant, Storage location and material
CDESK_BBOX	CDESK: Table for Saving Bounding Boxes
CECOEP	CO-PA Account Based Line Items
CEERROR	CO-PA: Incorrect records from SD
CFB_BACKFLUSH	Backflush of Batches
CFB_KALM_TMP	TMP Save / CK40N Selected Materials
CFB_VERID_MRP	Release/Lock Production Version for Mat. Req. Planning
CFB_WEIGH_LIST	Database of Weigh List
CHBSMWB	Web related info to models
CHVW	Table CHVW for Batch Where-Used List
CHVW_ARC_3	Archive Index: Batch Where-Used Data by Plant, Mat., Batches
CHVW_INC	Batch Where-Used List- N:M Assignment for Order
CHVW_INC_PUR	Batch Where-Used List - N:M Assignment Table - Purch. Order
CHVW_PRE	Preliminary Batch Where-used List According to Order/PO