Welcome Back :

SAP Consultants, whether internal or external to an organization, rely on a wide variety of resources to get their job done.  When it comes to SAP ACS Warranty Management related work, it takes very special resources to get the SAP Programs and SAP applications to work correctly.  Because the implementation of SAP ACS Warranty Management involves the creation of many SAP tables, it is often difficult for SAP Consultants to find the right tables they need.  That's why we create a list of all the tables in a SAP system you will typically need to know about.  Of course, SAP ECC has many more tables, but that's why this highly specialized list of tables is necessary.  To help you quickly find the relevant tables.  You will just to remember the T Codes (SE11 and SE80) to get to these and start working on them.

SAP Business Process Related Blogs of Interest 

ERP Genie - great site for SAP related content

SCN SAP Community Network, previously called the SAP Developer Network. Great place to read up on discussions on particular issues. This is were SAP consultants publish blogs, how-to's, and answer messages from SAP projects. On SCN, we have an article out on the

SAP Automotive Dealer Portal- a customer and dealer portal solution,- an important component of a end-to-end warranty solution. The name Automotive Dealer Portal implies the solution is for the automotive industry. And that is correct, it initiated from the industry solution, and easily applicable to most other discrete industries, such as A&D, manufacturing, construction equipment. WebDynpro based, the Dealer Portal is running at several SAP customers. We helped several Dealer Portal projects go live.  

SAP ECC Tables:

SAP Consultants configuring SAP Service, Maintenance and Warranty Management will be working in MM, SD, PP/PM/CS  and FICO (FI/CO) modules.  The following list of database tables will be handy to know about.

MM (Materials Management) MODULE

SAP Consultants configuring SAP Service, iMRO, MRO, Sales, and Warranty Management, etc., as well as specifying FRICE enhancements, will normally be dealing with these tables and key fields.

The Procurement Cycle consists of Purchase Requisition (PR), Request for Quotation (RFQ) (Vendor Evaluation), Purchase Order (PO) Goods Receipt Note (GRN), and Invoice Verification Data to FI.

Tables and Important Fields:

Table Description Key Fields
LFA1 Vendor Data LIFNR
LFB1

Company Code Segment : Vendor Data

LIFNR, BUKRS
LFC1 FI Related Vendor Data  LIFNR, BELNR
LFM1 Pur. Orgn. Related Vendor Data  LIFNR, EKORG
MARA Material Master MATNR
MARC Material Master with Plant Data  MATNR, WERKS
MARD Material Master with Storage Location Data  MATNR, LGORT, WERKS
MAKT Material Master Material Descriptions MATNR, MATKL
MBEW Material Valuation Data  MATNR, BWTAR
MVKE Material Master : Sales related  
MDKP, MDTB MRP Related Data Header  
MCHA, MCHB Material Batches Header, Item MATNR, WERKS, LGORT, CHARG
EBAN  Pur. Req. Data  BANFN, BNFPO, BADAT, MATNR
EINA  Purchase Info. Record General Data
EINE  Purchase Info. Record  pur. Orgn. Data
ELBK, ELBN, ELBP   Vendor Evaluation Related  
EKKO  PO Data Header EBELN, BSTYP, BSART
EKPO  PO Data Item EBELN, EBELP, MATNR
MKPF  GRN Data   EBELN, BLDAT, BUDAT, XBLNR, BKTXT
MSEG  GRN Data Item MBLNR, BWART, LIFNR, MATNR, EBELN
EQUK  Quota Header  QUNUM, MATNR
EQUP  Quota Item  QUNUM, QUPOS, LIFNR
EKBE  PO History Data  EBELN, EBELP, BELNR, BLDAT, MATNR, VGABE
EKBZ  PO History with Delivery Costs  EBELN, BELNR, LIFNR, XBLNR
EKET  Schedule lines data of a PO  EBELN, EINDT, SLFDT
EKES  Vendor Confirmations Data  EBELN, EBTYP, EINDT, XBLNR
T163F  Confirmation Texts  EBTYP, EBTXT
T156  Movement Types BWARE
T024  Purchasing  
T024E  Purchase  
T163  Item Category’s in Purchasing PSTYP
T149D  Valuation  
T134  Material  
FVLK  Delivery  
STKO, STPO  BOM related Data  
STPU, STPN, STST, STZU  BOM Related  
RKPF, RBKP, RSEG  MM – FI Related  
KONO, KONH   Pricing  
T006  Basic Unit Of  
     

SD - SALES & DISTRIBUTION MODULE RELATED TABLES :

 

Sales cycle consists of: Enquiry, Quotation, Sales Order, Delivery (Picking, Packing, Post Goods Issue and Shipment), Invoicing, and Billing Data release to FI and CO.

Table Description Key Fields
VBAK  Sales Document Header VBELN
VBAP  Sales Document Item Data  VBELN, POSNR, MATNR, ARKTX, CHARG
Enquiry,    
Type    
LIKP  Delivery Table Header Data  VBELN, LFART, KUNNR, WADAT, INCOL
LIPS  Delivery Table Item Data  VBELN, POSNR, WERKS, LGORT, MATNR, VGBEL
LIPS    
VTTK  Shipment Table Header Data TKNUM
VTTP  Shipment Table Item Data  TKNUM, TPNUM, VBELN
VBRK  Billing Table Header Data  VBELN, FKART, BELNF
VBRP  Billing Table Item Data  VBELN, POSNR, FKIMG, NEWR, VGBEL, VGPOS
  (VERP – AUBEL = VBAK- VBELN, VBRP – VBEL = LIKP – VBELN)  
VBUK  All Sales Documents status & Admn. Data header (VBELN, VBELN, VBTYP
VBTYP
VBTYP = ‘C’ (Sales Order) VBTYP = ‘L’(Delivery) VBTYP = ‘M’(Invoice)
 
VBUP  Sales Documents status & Admin. Data(Item) VBELN
VBEP  Sales Document Schedule Lines Data  VBELN, POSNR, EDATU, WMENG
VBKD  To get sales related Business data like Payment terms etc. VBELN
VBFA  Sales Document flow data VBELV, VBELN, POSNV, VBTYP
VBPA  Partner functions Data VBELN, PARVW, KUNNR, LIFNR
TVLKT  Delivery Type: Texts LFART, VTEXT
KNA1, KNB1, KNC1   Customer Master Data and Other Partner’s Data  KUNNR, NAME1,LAND1
KNVK  Customer Master Contact Person PARNR, KUNNR
KNVV  Customer Master Sales  
LFA1, LFB1, LFC1  Vendor Master Data(To get Transporter data) To get Transporter data
MARA, MARC, MARD  Material Master Data Basic, Plant, St. Location Views
TVKO  Sales VKORG
TVKOV  Distribution VTWEG
TVTA   SPART
TVKBZ  Sales VKBUR
TVBVK  Sales VKGRP
T077D  Customer Account KTOKD
T001W   WERKS
T001L  Storage LGORT
TWLAD  To get address of Storage Location and Plant LGORT, ADRNR
TVAU  Sales Document (Order), Order Types Order Types
KONV  Condition Types (pricing)   KNUMV, KSCHL, KWETR
T685T  Condition Types  
ADRC  To get Addresses of  
VBBE, VBBS  Sales Requirements  
VBKA  Sales Activities  
VBPV  Sales Document Product  

 

PP / PM / CS

SAP Consultants configuring SAP PP and or PM which is somewhat underlying the CS Customer Service module, as well as specifying FRICE enhancements, will normally be dealing with these tables and key fields. 

Table Description Key Fields  
AFKO  PP Order Header  
AFPO  PP Order Item  
AFVV  Order Operations Data  
AFVC  Operations within an  
AFRU  Order Completion  
CSLA  Activity Types Master  
CSLT  Activity Types  
KAKO  Capacity Header  
CRHD  Work Center Header  
AUFK  Order Master  
AFIH  Maintenance Order  
AUFM Goods Movement For  
EQUI  Equipment Master  
EQKT  Equipment  
ILOA  PM Object  
T024I  Maintenance Planner  
T357  Plant  
IFLO  Functional Location  
IHSG  Permits in  
IHGNS  Permit segment in  
T357G_T  Permit  
RESB  Reservation / Dependent  
V_EQUI  View for Equipment  
VIAUFKS  View for Order and Equipment  
CAVFVD  Work Center  
VIQMEL  Notification Header  
VIQMFEL  PM Notification  
VIQMMA, VIQMSM   Views for Activities and  

 

Master Warranty Tables (CS / PM)

SAP Consultants configuring service/maintenance and warranty modules PM, CS, and LO-WTY, as well as specifying FRICE enhancements, will normally be dealing with these tables and key fields: 

Table Description Key Fields
BGMK  Master Warranty Header  
BGMT  Master Warranty Text  
BGMS  Master Warranty Position  
BGMZ  Master Warranty Position Counter  

 

FI / CO (Finance)

SAP Consultants configuring finance modules FI and CO, as well as specifying FRICE enhancements, will normally be dealing with these tables and key fields: 

 

Table Description Key Fields
T001  Company  
T002  Language  
T003  FI Document  
T004  Chart Of  
T005  Country  
T007A  Tax  
T012  House  
TKA01  Controlling  
SKA1, SKB1  G/L Account Master  
SKAT   G/L Accounts  
KNBK  Customer Master(Bank Bank Details
LFBK  Vendor Master (Bank Bank Details
BKPF  Accounting Doc.  
BSEG  Accounting Doc. Item(Cluster Cluster Table
BSIS  G/L Open  
BSAS  G/L Closed  
BSID  Customer Open Items (Account Receivables) Account Receivables
BSAD  Customer Closed Items (Account Receivables)  
BSIK  Vendor Open Items (Accounts Payable) Account Payables
BSAK  Vendor Closed Items(Account Account Payables
BKPF and BSEG  BKPF and BSEG Tables consists of data from BSIS, BSAS, BSID, BSAD, BSIK, and BSAK tables.  
BSET  Tax  
BSEC  One Time Vendor  
CSKS  Cost Center  
CSKT  Cost Center  
CSSK  Cost Center/ Cost Element  
GLPCA  EC-PCA: Actual Line  
GLPCT  EC-PCA: Totals  
COEP  Co-Object Line Items by  
COST  Co-Object Price  
CSSL  Cost Center- Activity  
CRCO  Work Center- Cost Center  
CSLA  Activity Types LSTAR
CSKB  Cost Elements (KSTAR, KSTAR, KOKRS
COSS  Cost Totals (OBJNR, OBJNR, KSTAR
COBL  Coding  
CEPC  Profit Center Master  
BNKA  Master Records of  
TBSL  Posting  
KEKO  Product Costing Header  
ANLH  Main Asset  
ANLA, ANLB, ANLC  Segment Assets Masters  

 

Have more complex SAP Service (MRO), Sales, and Warranty configuration requirements? 

Then our team of experts is available. All you have to do to take advantage of it is to press the button below and request your initial and pro-bono consultation:

Request an Initial FREE Consultation