sapdev logo background
sapdev logo sapdev logo
Comments

SAP Application specific database tables




Here is number of popular SAP tables by Area including the Technical Name and Description

Purchasing
EKKO - PO Header
EKPO - PO Item
    EBAN - Purchase requisition
    EKBE - History per Purchase doc.
    EKKN - Account Assignment in Purchasing Document
    EBKN - Purchase Requisition Account Assignment

Order data (Network) - IW32
AUFK - Order master data
AFKO - Order header data
AFPO - Order item data

AFVC - Operation within an order
AFVV - quantities/dates/values in the operation

EKKN - Find purchase document(EBELN,EBLP) linked to order(AUFNR)
EBKN - Purchase Requisition Account Assignment

Accounting
BKPF - Accounting Document Header
    BSEG - Accounting Document Segment
       CSKS - Cost Center Master Data
       PRPS - WBS master data
       AUFK - Order master data

    CEPC - Profit Center master data
    RBSELBEST - PO associated with aparked invoice

Line items (Rep: RPUDRIG0)
COVP - CO Object: Line Items (See FM HRGPBS_DRILL_READ_COVP)
COOI - Commitments Management: Line Items

PPDHD - Transfer to Accounting: Document Header
PPDIT - Transfer to Accounting: Lines in HR IDOCs
(See FM HRGPBS_DRILL_SELECT_POST_LINE)

Invoice data
EKKO - PO Header
    RSEG - Incoming invoice (Invoice doc, PO doc)
    RBKP - Invoice receipt

Project plan/WBS
PROJ - Project data
    PRPS - WBS
    PRHI - WBS breakdown within project

Sales
VBAK - Header
VBAP - Item
VBPA - Sales Document Partner

Shipment
VTTK - Shipment Header
VTTP - Shipment Item

Delivery
LIKP - Delivery Header
LIPS - Delivery item

Vendor
LFA1 - Vendor Master
LFB1 - Vendor Master (Company Code)

Customer
KNA1 - Customer Master
KNB1 - Customer Master (Company Code)

Material
MARA - Material data
MARC - Material Plant Details

HR
PNP - Get Pernr (Personnel data)
PCH - Get Objec

TEM
TEM table structure



comments powered by Disqus


Can't find something on ERPWorkbench? A quick search should fix that: