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.
Find the Right SAP Table
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 SAP ECC (SAP ERP Central Component) tables they need. That's why we created a list of all the tables in a SAP system you will typically need to know about. Of course, SAP ECC (some but not all of these exist in the SAP ERP) 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.
SAP Automotive Dealer Portal- a SAP Fiori based customer and dealer portal solution,- an important application 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 is 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 Warranty Related 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 | Purchase Requisition Data | BANFN, BNFPO, BADAT, MATNR |
EINA | Purchase Info. Record | General Data |
EINE | Purchase Info. Record | Purchase Organization 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, MSEG-CHARG |
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 Document | |
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 | |
CEPC | Profit Center |
Other SAP System areas of concern
Other topics of course play a big role leveraging above tables, such as BAPIs, SE19 BADIs, User Exits, SE 37 Call Function function modules, SE24 Classes and Methods, data domains, RFCs, Screens, SAP configuration tables, own custom configuration tables, the focus on this page is to elevate relevant table names and help with references for those that wonder in the valley of ... hopefully light ... and need a quick lookup.
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: