cancel
Showing results for 
Search instead for 
Did you mean: 

table

Former Member
0 Kudos

please provide the list of table

specificly for RFQ

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

hi

Check the link to get all required tables and fields

http://www.erpgenie.com/abap/tables.htm

former_member581212
Active Contributor
0 Kudos

Hi,

-


Materials

MARA - Material Master: General data

MAKT - Material Master: Description

MARM - Material Master: Unit of Measure

MAPE - Material master: Export control file

MARC - Material master: Plant data

MARD - Material master: Storage location

MAST - Material link to BOM

MBEW - Material valuation

MLGN u2013 Material Master: WM Inventory

MLGT u2013 Material Master: WM Inventory type

MDIP - Material: MRP profiles (field contents)

MKOP - Consignment price segment (old versions of SAP)

EBEW - Valuation of sales order stock

QBEW - Valuation of project stock

MVER u2013 Material Master: Consumption <Plant>

DVER u2013 Material Master: Consumption <MRP Area>

MVKE u2013 Material Master: Sales <Sales Org, Distr Ch>

MLAN - Material Master: Tax indicator

MARC - Material Master: Plant data

MAPR u2013 Material Master: Forecast

MARD u2013 Material Master: Storage Location

MCH1 u2013 Material Master: X Plant Batches

MCHA u2013 Material Master: Batches

MCHB u2013 Material Master: Batch Stock

MDMA - MRP Area data

DBVM - MRP Planning File Entry: MRP Area

MOFF - Outstanding Material Master Records (Maintenance status)

MARCH - Material Master C Segment: History

MARDH - Material Master Storage Location Segment: History

MBEWH - Material Valuation: History

MCHBH - Batch Stocks: History

MKOLH - Special Stocks from Vendor: History

MSCAH - Sales Order Stock at Vendor: History

MSKAH - Sales Order Stock: History

MSKUH - Special Stocks at Customer: History

MSLBH - Special Stocks at Vendor: History

MSPRH - Project Stock: History

MSSAH - Total Sales Order Stocks: History

MSSQH - Total Project Stocks: History

Vendors

LFA1 - Vendor Master: General data

LFB1 - Vendor Master: Company data

LFM1 - Vendor Master: Purchasing Data (Purchasing organization)

LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range)

Purchasing

EBAN - Purchase requisition: items

EBKN - Purchase Requisition: account assignment

STXH - SAPScript Text Header

STXL - SAPScript Text Lines

EKKO - Purchasing document header

EKPO - Purchasing Document: Item

EKET - Purchasing Document: Delivery Schedules

MDBS - Material View of Order Item/Schedule Line (good to find open PO's)

EKKN - Account assignment in purchasing document

EORD - Purchasing Source List

EIPA - Order price history record

EKAB - Release documentation

EKBE - Purchasing document history

EKBZ - Purchasing document history: delivery costs

EKPB - "Material to be provided" item in purchasing document

ESKL - Account assignment specification for service line

ESKN - Account assignment in service package

ESLH - Service package header data

ESLL - Lines in service package

ESSR - Service entry sheet header data

ESUC - External services management: Unplanned limits for contract item

ESUH - External services management: unplanned service limits header data

ESUP - External services management: unplanned limits for service packages

ESUS - External services management: Unplanned limits for service types

EINA - Purchase Info Record: General

EINE - Purchasing info record: purchasing organization data

KONP - Condition Item

KONH - Condition Header

Inventory Management

ISEG - Physical inventory document items

MKPF - Material document: Header

MSEG - Material document: item

RKPF - Reservation: Header

RESB - Reservation: Item

Invoice Verification

BSIM - Secondary index: documents for material

MYMFT - FIFO results table

MYML - LIFO material layer

MYMLM - LIFO material layer (monthly)

MYMP - LIFO period stocks, single material

MYMP1 - Receipt data LIFO/FIFO valuation

MYPL - LIFO pool layer

MYPLM - LIFO pool layer (monthly)

RBCO - Document item, incoming invoice account assignment

RBDIFFKO - Invoice Verification: conditions

RBDIFFME - Invoice Verification: quantity differences

RBDRSEG - Invoice Verification batch: invoice document items

RBKP - Document header: incoming invoice

RBKPB - Invoice document header (batch invoice verification)

RBTX - Taxes:incoming invoice

RBVD - Invoice document: summarization data

RBVDMAT - Invoice Verification: summarization data, material

RBWT - Withholding tax:incoming invoice

RKWA - Consignment withdrawals

RSEG - Document item, incoming invoice

Customising and other master data

MDLV - MRP Areas

MDLG - MRP Areas - Storage Locations

MDLW - MRP Areas - Plants

MDLL - MRP Areas - Subcontractor

T023 - Material Groups

T024 - Purchasing groups

T030 - Standard Accounts Table (Automatic Account Determination)

T156 - Movement Type

T156T - Movement Type: Text

AUSP - Release Procedure: Strategy values (cl20n, cl24n)

AGR_USERS - Assignment of roles to users

CDHDR & CDPOS - Change history of master data and documents

EDID4 - EDI information

TSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93

TSTCT - Transaction codes TEXT

NAST - Message status

Award if helpfull

Thanks & Regards

Priyanka.P

Former Member
0 Kudos

Please check,

EKKO, EKPO, EKPT.

Regards,

Mahesh Wagh

Former Member
0 Kudos

Hello

JL23
Active Contributor
0 Kudos

RFQ is a purchasing document and will be archived with object MM_EKKO.

So you can execute DB15 enter there object MM_EKKO and you get a list of all related tables.

Former Member
0 Kudos

i am not able to find that in tc DB15

can you please provide the name of table for RFQ

JL23
Active Contributor
0 Kudos

after executing DB15

set the radio button to "tables from which data is archived"

then enter MM_EKKO in field tables in object.

then hit button Show objects.