Offline Notepad
View raw
Tables
(a) Organizational structure
-
Company code data table - T001 -
Plant data table - T00W -
Storage location data table - T001L -
Purchasing organization data table - T024E
(b) Material Master
-
General Data -MARA -
Plant data -MARC -
Storage Location -MARD -
Material Description -MARKT -
Unit of Measure - MARM -
Material Valuation - MBEW -
Material Master Status - MSTA -
Material Consumption -MVER -
Material Master sales data -MVKE - Material Master index for forecast - MAPR
(c) Vendor Master
-
Client level / General data - LFA1 -
Company code level data - LFB1 -
Purchasing Organization level data - LFM1 -
Bank data - LFBK
(d) Info Record
-
Client level / General data - EINA -
Purchasing data -EINE -
Conditional data - KONP
(e) Purchasing documents
-
(i) PO Header data -EKKO (ii) PO Line Item data - EKPO-
PR line item data - EBAN
-
(i) GR Material Document
(a) GR Header data - MKPF
(b) Line item data - MSEG
(ii) GR Accounting Document
(a) GR Header data - BKPF
(b) Line item data - BSEG
(i) Invoice Receipt
(a) IR Header Data -RBKP
(b) IR Line item data - RSEG
(ii) IR Accounting document
(a) IR Header Data - BKPF
(b) IR Line item data - BSEG
-
Vendor address of Purchasing documents - EKAN -
History of purchasing documents - EKBE -
History per Purchasing Document: Delivery Costs - EKBZ -
Delivery Schedules - EKET -
Account assignment in Purchasing document - EKKN -
Material Provided item in Purchasing document - EKBP - Shipping specific data on stock transfer - EKPV All entire purchasing documents (RFQ/PO/Contact/Scheduling Agreement)
Header data -EKKO
Item data -EKPO
Item condition data -KOMV
Conditions (Transaction Data) - KONV
See the below video:
Important details about T Code SE16 in SAP by Ganesh Padala
Logic to fetch Vendor Email address in SAP by Ganesh Padala