Ready Reckoner for SAP Developers

www.sapyard.com
Share on Facebook5Share on LinkedIn5Tweet about this on TwitterShare on Google+0
Please Share!!

In one of the ABAP forum, a member suggested that we collate the frequently used transactions and tables which every ABAPer use in almost all projects. This page is for young developers like him who are curious as to what are the t-codes in other modules of SAP, where he did not get opportunity to work till then.

SD, MM, WM, PM, FI, CO etc or OTC, PTP, PTD, AR, AP, FPM etc are some of the common jargons used by consultants. You might need to google for the abbreviations of some of them. πŸ™‚

Coming back to the topic of the day. Let’s check those transactions and tables.

A. Master Data (which do not change very often)

1. Customer Master
T-codes:
XD01/02/03 – Create/Change/Display Customer

Tables:
KNA1 General Data in Customer Master
KNB1 Customer Master (Company Code)
KNVP Customer Master Partner Functions
KNVV Customer Master Sales Data
KNVS Customer Master Shipping Data

2. Vendor Master
T-codes:
XK01/02/03 – Create/Change/Display Vendor

Tables:
LFA1 Vendor Master (General Section)
LFB1 Vendor Master (Company Code)
LFBK Vendor Master (Bank Details)

3. Material Master
T-codes:
MM01/02/03 – Create/Change/Display Material

Tables:
MARA General Material Data
MAKT Material Descriptions
MARC Plant Data for Material
MARD Storage Location Data for Material
MARM Units of Measure for Material
MAST Material to BOM Link
MVKE Sales Data for Material

Other useful Master Data Tables
T001W Plants/Branches
T001 Company Codes
T001K Valuation area (Link between Plant and Company Code)

B. Transaction Data (which is created/changed/updated frequently)

SAP SD Overview for ABAPers

1) Sales and Distribution

Pre-sales and Sales
T-codes:
VA11/12/13/15N – Create/Change/Display/List Inquiry
VA21/22/23/25N – Create/Change/Display/List Quotation
VA01/02/03/05N – Create/Change/Display/List Sales Order
VA41/42/43/45N – Create/Change/Display/List Contract
VA31/32/33/35N – Create/Change/Display/List Scheduling Agreement

Tables:
VBAK Sales Document: Header Data
VBAP Sales Document: Item Data
VBFA Sales Document Flow
VBKD Sales Document: Business Data
VBPA Sales Document: Partner
VBEP Sales Document: Schedule Line Data
VAKPA Sales Index: Orders by Partner Function
VAPMA Sales Index: Order Items by Material

Pricing
T-codes:
VK11/12/13/15N – Create/Change/Display/ List Condition
VK03/04/05 – Create/Change/Display Condition Table

Tables:
KONH Conditions (Header)
KONP Conditions (Item)
KONV Conditions (Transaction Data)

Delivery
T-codes:
VL01/02/03N – Create Outbound Dlv. with Order Ref.
VL23N – Goods Issue (Background Processing)
VL21 – Post goods issue in background

Tables:
LIKP SD Document: Delivery Header Data
LIPS SD document: Delivery: Item data
VLKPA SD Index: Deliveries by Partner Functions
VLPMA SD Index: Delivery Items by Material

Shipment
T-codes:
VT01/02/03N – Create/Change/Display Shipment Doc

Tables:
VTTK Shipment Header
VTTP Shipment Item
VTFA Shipment Document Flow

Billing
T-codes:
VF01/02/03 – Create/Change/Display/List Billing Doc
VF04/VF05N – Maintain Billing Due List/Display List of Billing Documents

Tables:
VBRK Billing Document: Header Data
VBRP Billing Document: Item Data
VRKPA SD Index: Billing Documents by Partner Functions
VRPMA SD Index: Billing Items per Material

VBFA is one of the most important table which holds the document flow of SD Module

MM Overview for ABAPers Procurement Overview for ABAPers

2. Purchasing

T-codes:
ME41/42/43 – Create/Change/Display Request For Quotation
ME11/12/13 – Create/Change/Display Purchasing Info Record

Tables:
EINA Purchasing Info Record: General Data
EINE Purchasing Info Record: Purchasing Organization Data

T-codes:
ME51/52/53 – Create/Change/Display Purchase Requisition

Tables:
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment

T-codes:
ME21/22/23 – Create/Change/Display Purchase Order

Tables:
EKKO Purchasing Document Header
EKPO Purchasing Document Item
EKBE History per Purchasing Document

T-codes:
IW31/32/33 – Create/Change/Display Work Order

Tables:
AUFK Work Order master data
AFKO Work Order Header Data PP Orders
AFPO Order item
AFVC Operation within an order

T-codes:
MIGO – Goods Receipt Purchase Order

Tables:
MKPF Header: Material Document
MSEG Document Segment: Material

T-codes:
MIRO Invoice Receipt

Tables:
RBKP Document Header: Invoice Receipt
RSEG Document Item: Incoming Invoice

T-codes:
ME31/32/33K – Create/Change/Display Agreement

Tables: Same tables as PO but document type is ‘K’ for Agreement
EKKO Purchasing Document Header
EKPO Purchasing Document Item
EKBE History per Purchasing Document

T-Codes
MEK1/2/3 – Condition Records

3. Finance

Tables:
CEPC Profit Center Master Data Table
CSKS Cost Center Master
SKB1 G/L Account Master (Company Code)
SKA1 G/L Account Master (Chart of Accounts)

FI Overview for ABAPers

4. Accounting

T-codes:
FB01/02/03 – Post/Change/Display Document
FB03L – Display Document G/L view

Tables:
BKPF Accounting Document Header
BSEG Accounting Document Segment
BSIK Accounting: Secondary Index for Vendors
BSAK Accounting: Secondary Index for Vendors (Cleared Items)
BSIS Accounting: Secondary Index for G/L Accounts
BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items)
BSAD Accounting: Secondary Index for Customers (Cleared Items)
BSID Accounting: Secondary Index for Customers

 

Tip: How to remember these tables?

First 2 Characters: BS is common.

3rd Character:
A = Cleared
I = Open

4th Character:
K for Vendor
D for Customer
S for Accounting

How do I remember?
bsiK/bsaK = Vendor = xK03 (T-Code)
bsiD/bsaD = Customer = xD03 (T-Code)
bsiS/bsaS = G/L Account = Skb1/Ska1 (Tables)

T-codes:
FBL1N/2N – Vendor Line Item Display for Open/Cleared Items
FBL3N/4N – G/L Account Line Item Display for Open/Cleared Items
FBL5N/6N – Customer Line Item Display for Open/Cleared Items

Please note, this is not an exhaustive list. This is a small list of SAP transactions and tables which are commonly used by the developers. There are areas like equipment master, maintenance plans, production orders, service entry sheets etc which we also use in many projects, but we have deliberately not included them to maintain the brevity of the list.

If you feel, there are some other tables or transactions which you feel should be included in this list, please let us know. We would definitely add them.Β Please feel free to email us at mailsapyard@gmail.com or leave it in our comment section.

If you want to get updates about our new tweaks and tricks, please subscribe.

If you liked it, please share it. Thank you very much for your time!!

 

 

 

Image source : www.pilotpartners.com.au

Share on Facebook5Share on LinkedIn5Tweet about this on TwitterShare on Google+0
Please Share!!

About the Author

SAP Yard
SAP Yard
SAPYard is one stop page for all Technical Folks in SAP. You would find un-conventional explanations, tutorials, and tricks. Please like our Facebook Page and also join our LinkedIn Group.

2 Comments on "Ready Reckoner for SAP Developers"

  1. Raju: Nice collection. This will be very helpful for beginners.

Please help us improve. Please Shout Often & Loud!!