Material master query Table in SAP

• AQGQCAT
  Table for SAP Query: Query Catalog
  Table Type : TRANSP
  Package : SQUE
  Module : BC-SRV-QUE
• AQGQSTRUC
  Table for SAP Query: Query / Structure Assignment
  Table Type : TRANSP
  Package : SQUE
  Module : BC-SRV-QUE
• AQHTMLRAW
  Table for SAP Query: HTML Templates for Query
  Table Type : TRANSP
  Package : SQUE
  Module : BC-SRV-QUE

• AQHTMLTMPL
  Table for SAP Query: HTML Templates for Query (Language-dependent)
  Table Type : TRANSP
  Package : SQUE
  Module : BC-SRV-QUE
• AQLQCAT
  Table for SAP Query: Query Catalog
  Table Type : TRANSP
  Package : SQUE
  Module : BC-SRV-QUE
• AQLQSTRUC
  Table for SAP Query: Query / Structure Assignment
  Table Type : TRANSP
  Package : SQUE
  Module : BC-SRV-QUE
• AQRDB
  Table for SAP Query: Runtime Objects for Query Reports
  Table Type : TRANSP
  Package : SQUE
  Module : BC-SRV-QUE
• ESH_QL_QLOGQ
  Table for Query Log: Query Contents
  Table Type : TRANSP
  Package : S_ESH_ENG_QUERY_LOGGING
  Module : BC-EIM-ESH
• IQQCATDB
  Table for InfoSet Query API: Query Catalog
  Table Type : TRANSP
  Package : SISQ
  Module : BC-SRV-QUE
• IQQCATDBX
  Table for InfoSet Query API: Query Catalog (Text)
  Table Type : TRANSP
  Package : SISQ
  Module : BC-SRV-QUE
• RSEQ_DIR
  Table for Query/Easy Query Assignment
  Table Type : TRANSP
  Package : BW_BICS_EQ
  Module : BW-BEX-OT-BICS-EQ
• RSQRDB
  Table for SAP Query: Runtime Objects for Query Reports
  Table Type : TRANSP
  Package : RSQBW
  Module : BW-WHM-DBA

• /BCV/C_QVIEWQA
  Table for Assignment of Query to Query View
  Table Type : TRANSP
  Package : /BCV/UIF
  Module : CA-EPT-BCV
• /BOBF/TUI_QRYPAR
  Table for Contains the Query Parameters' of Query Variants
  Table Type : TRANSP
  Package : /BOBF/TEST_UI
  Module : AP-RC-BOF-TST
• /SLOAP/QUERY
  Table for SLOAS: BI-Query information table
  Table Type : TRANSP
  Package : /SLOAP/APPLICATION
  Module : CA-EUR
• MVGD
  Table for Material master/product group material version
  Table Type : TRANSP
  Package : MGVERS
  Module : LO-MD-MM
• OIFORCAM
  Table for Conversion of article master to material master data (ALE)
  Table Type : TRANSP
  Package : OIF
  Module : CRM
• A101
  Table for SOrg/DstCh/Material-Main Item/Material Pricing Group
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A102
  Table for SOrg/DstCh/Material Pricing Group-Main Item/Material
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A265
  Table for Standard Dummy Customer/Document Type/Material Grp/Material
  Table Type : TRANSP
  Package : MEC_VKON
  Module : IS-EC
• A266
  Table for Standard Dummy Customer/Material Group/Material Number
  Table Type : TRANSP
  Package : MEC_VKON
  Module : IS-EC
• CAD_PARTS
  Table for Table for Assignment of Standard Material to Material Nos
  Table Type : TRANSP
  Package : CA
  Module : CA-CAD
• J_1IMODDET
  Table for Modvat Determination Table (Input Material->Output Material)
  Table Type : TRANSP
  Package : J1IN
  Module : FI-LOC
• KOTG401
  Table for GG: Listing - Material entered / Material
  Table Type : TRANSP
  Package : HT_VKON
  Module : IS-HT

• KOTR012
  Table for Receiving Material + Sending Material
  Table Type : TRANSP
  Package : VBDRV
  Module : LO-BM
• KOTR013
  Table for Receiving Material Type + Sending Material Type
  Table Type : TRANSP
  Package : VBDRV
  Module : LO-BM
• MVOP
  Table for Material data material versions
  Table Type : TRANSP
  Package : MGVERS
  Module : LO-MD-MM
• OIRAMATHANDGRP
  Table for Material handling group material assignment (IS-Oil SSR)
  Table Type : TRANSP
  Package : OIR
  Module : IS-OIL-DS-SSR
• T023S
  Table for Base Material Group/Hierarchy Material Assignment
  Table Type : TRANSP
  Package : WWGR
  Module : CRM
• T8APP_GLPCM
  Table for EC-PCA: Plan Costs from Material Costing for Rep. Material
  Table Type : TRANSP
  Package : KE1
  Module : CRM
• WRF_PRICAT_002
  Table for Assign External Material Group - SAP Material Group
  Table Type : TRANSP
  Package : WRF_VPRI_IN
  Module : SD-EDI
• WSDT_MAT_MTART
  Table for Material Type available in Material Creation
  Table Type : TRANSP
  Package : WSD_CS_DDIC
  Module : SD-MD-MM-CS
• /SAPCEM/MATERIAL
  Table for Material Assignment to Appropriate Catalog
  Table Type : TRANSP
  Package : /SAPCEM/DDIC
  Module : IS-EC-CEM
• A075
  Table for Master Conditions for SRV with Material Group
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• COMC_R3_FIELDS
  Table for Assignment of R/3 material master fields to CFOP tax classif
  Table Type : TRANSP
  Package : COM_LOC_BRAZIL
  Module : CA-GTF-CSC
• CONT01_MARA
  Table for Container Table for Material Master
  Table Type : TRANSP
  Package : CBZID
  Module : PS
• DVM01
  Table for R/2-R/3 Link: R/3 Input Data for Material Master
  Table Type : TRANSP
  Package : VL
  Module : CRM
• DVM02
  Table for R/2-R/3 Link: R/3 Input Data Material Master Stor. Locations
  Table Type : TRANSP
  Package : VX
  Module : LE-SHP-GF
• J_1AINFMBW
  Table for Material Master - Inflation
  Table Type : TRANSP
  Package : J1AI
  Module : CA-GTF-CSC
• J_7LC48
  Table for REA Data Filter: Field Definition Charact. Material Master
  Table Type : TRANSP
  Package : J7LR
  Module : IS-REA-COR
• J_7LC49
  Table for REA Data Filter: Material Master Characteristic Values
  Table Type : TRANSP
  Package : J7LR
  Module : IS-REA-COR
• J_7LM06
  Table for REA Article Master: Bills of Material
  Table Type : TRANSP
  Package : J7LR
  Module : IS-REA-COR
• J_7LV06
  Table for REA Packaging Master Data: Bills of Material
  Table Type : TRANSP
  Package : J7LR
  Module : IS-REA-COR
• MAEX
  Table for Material Master: Legal Control
  Table Type : TRANSP
  Package : MG
  Module : CRM
• MAMT
  Table for Material Master Texts per Unit of Measure and Text ID
  Table Type : TRANSP
  Package : MGA
  Module : CRM
• MAPE
  Table for Material Master: Export Control File
  Table Type : TRANSP
  Package : MG
  Module : CRM
• MAPEWG
  Table for Material master: Preference determination: Cross-plant
  Table Type : TRANSP
  Package : VEI
  Module : CRM
• MARCH
  Table for Material Master C Segment: History
  Table Type : TRANSP
  Package : MGA
  Module : CRM
• MARDH
  Table for Material Master Storage Location Segment: History
  Table Type : TRANSP
  Package : MGA
  Module : CRM
• MASSUSRPRF
  Table for Material Master User Settings: Screen Reference "User"
  Table Type : TRANSP
  Package : MASS
  Module : CA-GTF-MS
• MAW1
  Table for Material Master: Default Fields and Special Retail Fields
  Table Type : TRANSP
  Package : MG
  Module : CRM
• AQS_QUNAME
  Table Data element for SAP Query (S): Query name
• AQ_QUNAME
  Table Data element for SAP Query: Query name / QuickView name
• AQS_QUNUMB
  Table Data element for SAP Query (S): Query number
• IQQNAME
  Table Data element for InfoSet Query: Query Name
• IQLTYPE
  Table Data element for InfoSet Query: Query List Type
• RSZWEBQDENABLED
  Table Data element for Query: May Be Edited with Web Query Designer
• RSZ_USE_STARTVIEW
  Table Data element for Replace by query: Use query start view for replacement
• SMO_QUERY
  Table Data element for Mobile Query check - complete query
• HREXP_QUERY_NAME
  Table Data element for SAP Query (S): Query Name
• AQL_QUERY
  Table Data element for SAP Query (L): Query name (old)
• /BOFU/QUERY
  Table Data element for Query
• WISP_REFART
  Table Data element for Indicator: Material Reference from Material Master

Material master query related terms

Definitions

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.

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.