Welcome Back :
SAP Consultants, whether they're part of an in-house team or external advisors, leverage an extensive array of tools and resources to achieve their objectives. Specifically, for tasks related to SAP Warranty Management, it requires a unique set of resources to seamlessly integrate SAP Warranty with iMRO, alongside other essential modules such as Finance and Supply Chain Management / EWM, ensuring flawless operation.
Find the Right SAP Table
Implementing SAP ACS Warranty Management can be quite the challenge, primarily due to the overwhelming number of SAP tables it utilizes. This complexity often leaves SAP Consultants in a lurch, struggling to pinpoint the exact SAP ECC or S/4Hana tables required for their tasks. That's why we created a list of all the tables in a standard SAP system you will typically need to know about.
Of course, SAP ECC and S/4Hana has many more tables, along the lines of 10s of thousands, that's why this highly specialized list of tables is useful to help you quickly find the relevant tables. You will just to remember the T Codes (SE11, SE16N, config, and others) to get to these and start working on them.
SAP Business Process Related Blogs of Interest
The SCN SAP Community Network, formerly known as the SAP Developer Network, is an invaluable resource for diving deep into discussions on specific topics. It's where SAP consultants share their expertise through blogs, instructional guides, and by responding to inquiries related to 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.
The SAP Automotive Dealer Portal, leveraging SAP Fiori for an intuitive customer and dealer experience, is a crucial component of a comprehensive Warranty Management solution. This Portal, aptly named to reflect its origins in the automotive sector, was originally designed for the Automotive industry. However, its versatility shines through its adaptability to a wide array of what SAP calls discrete industries: including Automotive, Aerospace & Defense, Medical Equipment, Mining, Transportation, Oil & Gas, and Construction Equipment OEMs, in short, all manufacturing and complex complex industries in general.
The original Portal was powered by SAP WebDynpro. The new Portal is powered by SAP Fiori: enhancing operations for many SAP customers, with our teams having successfully guided multiple Dealer Portal initiatives across the finish line.
SAP Warranty Related ECC Tables:
SAP experts dedicated to setting up SAP Service, Maintenance and Warranty Management, will find themselves navigating through
MM, SD, PP/PM/CS, FICO (Finance and Controlling), also IM - Inventory Management and EWM modules. Below is a curated collection of database tables that will prove invaluable in this endeavor.
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:
