![]() |
Below is a list of useful SAP tables and a description of what they are used for.
EKKO � SAP Purchase Order documents
  EBELN � Purchase document number
EKPO - SAP Purchase Order document items
  EBELN � Purchase document number
  EBELP � Purchase item number
EBAN � Purchase requisition within SAP
  BANFN � Requisition number
  BNFPO � Requisition item number
LFA1 � Vendor master details
  LIFR � vendor number
MARA � Materials master data
  MATNR � Material number
MSEG � Material item details
  MBLNR - Number of Material Document
  MJAHR - Material Document Year
  ZEILE - Item in Material Document
MARC � material plant details
  MATNR - Material number
  WERKS - Plant number
MBEW � Material valuation
  MATNR - Material Number
  BWKEY - Valuation Area
  BWTAR - Valuation Type
KNA1 � Customer master data
  KUNNR � Customer number
KNVV � Customer sales data
  KUNNR - Customer Number
  VKORG - Sales Organization
  VTWEG - Distribution Channel
  SPART - Division
VBAK � Sales master data
  VBELN � Sales document number
VBAP � Sales item data
  VBELN - Sales document number
  POSNR -Sales document item
VBRK � Billing master data
  VBELN � Billing document number
VBRP - Billing item data
VBELN - Billing document number
POSNR -Billing document item
LIKP � SD deliver master data table
  VBLEN � Delivery number
LIPS � SD deliver item data
  VBLEN � Delivery number
  POSNR � Delivery item
BKPF � Accounting document master data
  BUKRS � Company code
  BELNR � Accounting document number
  GJAHR � Fiscal year
BSEG - Accounting document item data
  BUKRS � Company code
  BELNR � Accounting document number
  GJAHR � Fiscal year
  BUZEI � Accounting item
T001 � Company codes mater data table
  BUKRS � Company code
T001W - Plant and branches master table
  WERKS � Plant id
Note:Not keyed on company code (BURKS) so each plant/branch can be associated to any company code.
T000 � Client master table
  MANDT � Client code
ADRC - SAP Addresses master data
  ADDRNUMBER � Address number
PA0001 � HR 0001 infotype table (Org. Assignment)
  PERNR - Personnel number
  SUBTY - Subtype
  OBJPS - Object Identification
  SPRPS - Lock Indicator for HR Master Data Record
  ENDDA - End Date
  BEGDA - Start Date
  SEQNR - Number of Infotype Record with Same Key
AUFK � Order master data
  AUFNR � order number