SAP TABLES

 

 

	Tables in SAP Just a list of tables that come in handy. Sales orders Name Description Uses LIKP Shipped Lines header   LIPS Shipped Lines detail   VBAK Order header Every order (unless archiving) VBAP Table fields Every line item (unless archiving) VBBE Open sales order line items Great file, but be careful. Contents don't reflect orders that do not affect purchasing (go figure). VBEP Schedule line item   VBFA Document flow Let's you move from order to shipping document to invoice. VBUK Order status   VBUP Line item detail status   VBFK Invoicing header   VBFP Invoicing detail   Material Management Name Description Uses MARA Inventory Master MARC Plant Data MARD Current Inventory MAKT Descriptions MBEW Material Valuation T179 Product Hierarchy MVKE Sales data (materials) MKPF Material document Status code 'R' in VBFA Purchasing Name Description Uses EINA Purchasing inforecord by MATNR/LIFNR contains things like vendor material number and access key for EINE EINE Purchasing inforecord detail Contains minimum purchase, group, currency EKPO Purchase orders   EKET Scheduled lines   EKES Vendor confirmed lines         Forecasting Name Description Uses MAPR PROP PROW Classification Name Description Uses KSSK Material number to class KLAS Class description KSML Characteristic name CABN/CABNT Characteristic name description CAWN/CAWNT Characteristic name AUSP Numeric values Name Description Uses CAUFV Service order header AFPO Service order line Holds items that will create "reservations" RESB SM Reservations Materials needed for line Customer Data KNA1 Customer Master   KNVV Sales information   KNVP Partners (ship-to, etc)                       System tables Name Description Uses DD02T Table texts DD03L Table fields Lists the fields in a table DD04T Data element texts USR02 Valid user names Config tables (normally begin with "T") Name Description Uses T001 Client table T002 Languages T005 Region (Country) TCURR Currency and exchange rates TVAK Order type TVSB Shipping condition TVAGT Rejected reason for order line Other tables Name Description Uses STXH Text header STXL Text detail