SAP TABLES

SAP Tables

Here are some of the important SAP Logistics Tables most commonly referred to

Enterprise structure 

Definition
T880 Company
T001 Company code
TKA01 Controlling area
T001W Plant / sales organisation
T499S Locations
TSPA Division
TVKO Sales organisation / company code
TVTW Distribution channel
TVBUR Sales office
TVKBT SALES OFFICE TEXT
TVKGR Sales group
TVGRT Sales group text 
T171T Sales district text
T001L Storage locations
T024E Purchasing organization
T3001 Warehouse number
TVST Shipping point
TVLA Loading point
TTDS Transportation
Assignment
CO TKA02 Assign company code to controlling area
LO T001K Assign plant (valuation area) to company code
SD TVKO Sales organisation / company code
TVKOV Distribution channel / sales organisation
TVKOS Division to sales organization
TVTA Sales area
TVKBZ Sales office to sales area
TVBVK Sales group to sales office
TVKWZ          Plants to sales organization
MM T024E Purchasing organization / company code
T024W Plant to Purchase organization 
T001K Link plant ( = valuation area) / company code
TVSWZ Shipping point to plant
T320 Assignment MM Storage Location to WM Warehouse




MASTER DATA :
Material master :
MARA MATERIAL MASTER
MAKT   Material text
MARC Material per plant / stock
MVKE Material master, sales data
MARD Storage location / stock
MSKA Sales order stock
MSPR Project stock
MARM Units of measure
MEAN International article number
PGMI         Planning material
  PROP         Forecast parameters
MAPR Link MARC <=> PROP
MBEW Material valuation
MVER Material consumption
MLGN Material / Warehouse number
MLGT Material / Storage type
MPRP Forecast profiles
MDTB MRP table
MDKP Header data for MRP document
MLAN Tax data material master
MTQSS Material master view: QM 
Sales and Distribution (SD) :
VBFA   Document flow (alg.)
VTFA    Flow shipping documents
Sales order :
VBAK Header data
VBAP  Item data
VBPA         Partners in sales order
VBKD Sales district data
VBEP         Data related to line items, delivery lines
Billing document :
VBRK       header data
VBRP  Item data
Shipping :
VTTK Shipment header
VTTP        Shipment item
VTTS        Stage in transport
VTSP       Stage in transport per shipment item
VTPA       Shipment partners
VEKP      Handling Unit - Header Table
VEPO      Packing: Handling Unit Item (Contents)
Delivery :
LIKP      Delivery header
LIPS       Delivery item
VBUK   Sales Document: Header Status and Administrative Data
VBUP   Sales Document: Item Status
Pricing :
KONH  Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order)
KOND
Contracts :
VEDA Contract data

Customer master data
KNA1 Customer master
KNB1 Customer / company
KNVV Customer sales data
KNBK Bank details
KNVH Customer hierarchy
KNVP Customer partners
KNVS Shipment data for customer
KNVK Contact persons
KNVI        Customer master tax indicator

       Vendor Master
LFA1         Vendor master
LFB1         Vendor per company code
LFB5  Vendor dunning data
LFM1 Purchasing organisation data
LFM2 Purchasing data
LFBK         Bank details

       Batches  
MCHA BATCHES
MCH1 Batches
MCHB Stock : batches

 Customer – material info record
  KNMT     Customer material info recor
  Bank Data
  BNKA      MASTER BANK DATA
Material Management (MM) :
Material document
MKPF material document
MSEG material document (item level)

Purchasing
EKKO Purchase document
EKPO Purchase document (item level)
EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item
EKET Delivery schedule
VETVG Delivery Due Index for Stock Transfer
EKES Order Acceptance/Fulfillment Confirmations
EKKN Account assignment in purchasing
EKAN Vendor address purchasing
EKPA Partner functions
EIPO Item export / import data
EINA Purchase info record (main data)
EINE Purchase info record (organizational data)
EORD Source list
EBAN Purchase requisition
EBKN Purchase Requisition Account Assignment


Warehouse Management (WM) :
Transfer requirement
LTBK Transfer requirement - header
LTBP Transfer requirement - item
Transfer order
LTAK Transfer order - header
LTAP Transfer order - item

Master data - stock positions
LQUA Quants

Inventory documents in WM
LINK Inventory document header
LINP Inventory document item
LINV Inventory data per quant




Leave a Comment

error: Content is protected !!