Query for vendor master data Table in SAP

• WSVD_DB_VNDR_PLT
  Table for SRS Vendor Master: Maint. Authorization for Store-Vendor
  Table Type : TRANSP
  Package : WOST
  Module : LO-SRS
• A109
  Table for Vendor hierarchy: vendor sub-range
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• BBP_SD_LOG
  Table for Vendor's Entries in Vendor List
  Table Type : TRANSP
  Package : BBP_BUPA_SUPPLIER
  Module : SRM-EBP-ADM

• KOTE012
  Table for Vendor Hierarchy: Vendor Sub-Range Rebate
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• MSID
  Table for Vendor Stock with Vendor
  Table Type : TRANSP
  Package : DIPCS
  Module : IS-AD-SSP
• MSIDH
  Table for Vendor Stock with Vendor - History
  Table Type : TRANSP
  Package : DIPCS
  Module : IS-AD-SSP
• MSIS
  Table for Vendor Stock with Vendor - Total
  Table Type : TRANSP
  Package : DIPCS
  Module : IS-AD-SSP
• VEN001
  Table for Business Partner: Vendor - Our Number at Vendor
  Table Type : TRANSP
  Package : BBP_BUPA
  Module : SRM-EBP
• 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
• CNV_20200_LFB1
  Table for Differences in vendor account master data
  Table Type : TRANSP
  Package : CNV_20200_CHECK
  Module : CA-EUR

• GHO_CUVD_OWN_MD
  Table for Customer/Vendor Ownership Master Data of Business partner
  Table Type : TRANSP
  Package : APPL_GHO_OWNERSHIP_DB
  Module : PP-PN-OWN
• J_1IMOVEND
  Table for Vendor Master Excise Additional Data
  Table Type : TRANSP
  Package : J1IN
  Module : FI-LOC
• LFB5
  Table for Vendor master (dunning data)
  Table Type : TRANSP
  Package : WLIFCORE
  Module : LO-MD-BP-VM
• LFM1
  Table for Vendor master record purchasing organization data
  Table Type : TRANSP
  Package : WLIF
  Module : CRM
• LFM2
  Table for Vendor Master Record: Purchasing Data
  Table Type : TRANSP
  Package : WLIF
  Module : CRM
• T079M
  Table for Vendor master data screen selection (purch.org.)
  Table Type : TRANSP
  Package : WLIFCORE
  Module : LO-MD-BP-VM
• TVENDCUST_SCGRT
  Table for Texts for Screen Groups for Customer and Vendor Master Data
  Table Type : TRANSP
  Package : FBK
  Module : CRM
• TXW_S_LFC1
  Table for Retrieve archived Vendor master (transaction figures) data
  Table Type : TRANSP
  Package : FTW1
  Module : CA-GTF-DRT
• FMFG_CCRFDDISP
  Table for CCR Fields to be "Display only" in Vendor Master Change
  Table Type : TRANSP
  Package : FMFG_CCR_E
  Module : PSM-FG
• FMFG_LFACCR
  Table for Vendor Master Central Contractor Registry (CCR)
  Table Type : TRANSP
  Package : FMFG_CCR_E
  Module : PSM-FG
• LFA1
  Table for Vendor Master (General Section)
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• LFAS
  Table for Vendor master (VAT registration numbers general section)
  Table Type : TRANSP
  Package : WLIFCORE
  Module : LO-MD-BP-VM
• LFAT
  Table for Vendor master record (tax groupings)
  Table Type : TRANSP
  Package : WLIFCORE
  Module : LO-MD-BP-VM
• LFB1
  Table for Vendor Master (Company Code)
  Table Type : TRANSP
  Package : WLIFCORE
  Module : LO-MD-BP-VM
• LFB1_KR
  Table for Vendor Master Enhancement for Korea
  Table Type : TRANSP
  Package : ID-FI-KR
  Module : CA-GTF-CSC
• LFBK
  Table for Vendor Master (Bank Details)
  Table Type : TRANSP
  Package : WLIFCORE
  Module : LO-MD-BP-VM
• LFBW
  Table for Vendor master record (withholding tax types) X
  Table Type : TRANSP
  Package : WLIFCORE
  Module : LO-MD-BP-VM
• LFC1
  Table for Vendor master (transaction figures)
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• LFC1_BAK
  Table for Vendor Master (Transaction Figures)
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• LFC3
  Table for Vendor master (special G/L transaction figures)
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• LFC3_BAK
  Table for Vendor Master (Special G/L Transaction Figures)
  Table Type : TRANSP
  Package : FBAS
  Module : CRM
• LFEI
  Table for Vendor Master: Preference for Import and Export
  Table Type : TRANSP
  Package : VEI
  Module : CRM
• LFLR
  Table for Vendor Master Record: Supply Regions
  Table Type : TRANSP
  Package : WLIF
  Module : CRM
• LFMC
  Table for Vendor master (short texts for condition types)
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• T078K
  Table for Transaction-dependent screen selection for vendor master
  Table Type : TRANSP
  Package : WLIFCORE
  Module : LO-MD-BP-VM
• TWIC1100
  Table for SRS Vendor Master: Basic Settings
  Table Type : TRANSP
  Package : WOST
  Module : LO-SRS
• TWIC1100CLNT
  Table for Cross-Plant Settings for Vendor Master Maintenance
  Table Type : TRANSP
  Package : WOST
  Module : LO-SRS
• FCML_NWG_CTYPE
  Table Data element for Master data type for NWG customizing master data item
• MDG_MDF_USAGE
  Table Data element for Master Data: How Master Data/Hierarchies Are Used
• CREQ_APPLICATION
  Table Data element for Request to Change Master Data: Linked Master Data Objects
• UG_ACCESS_MODE
  Table Data element for FIN Master Data: Mode for Accessing Master Data
• UG_MD_USAGE
  Table Data element for FIN Master Data: How Master Data/Hierarchies Are Used
• 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

Query for vendor master data 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.