Module Codes and Table Cheatsheet

Quick reference for the codes and table names you’ll hear in conversation and need to look up constantly.

SAP module codes

Code Module
FI Financial Accounting
FI-GL General Ledger
FI-AP Accounts Payable
FI-AR Accounts Receivable
FI-AA Asset Accounting
FI-BL Bank Ledger
CO Controlling
CO-OM Overhead Management (cost centres)
CO-PC Product Costing
CO-PA Profitability Analysis
EC-PCA Profit Centre Accounting
TR / FSCM Treasury / Financial Supply Chain Management
MM Materials Management
MM-PUR Purchasing
MM-IM Inventory Management
MM-IV Invoice Verification
SD Sales and Distribution
LE Logistics Execution
WM / EWM Warehouse Management / Extended WM
TM Transportation Management
PP Production Planning
PP-PI Production Planning for Process Industries
PP-SFC Shop Floor Control
QM Quality Management
PM / EAM Plant Maintenance / Enterprise Asset Management
PS Project System
HCM / HR Human Capital Management
PA / OM / PT / PY Personnel Admin / Org Mgmt / Time / Payroll
CS Customer Service
GTS Global Trade Services
BW Business Warehouse
Basis Technical administration

Key SAP tables

Financial

| Table | Contents | |—|—| | ACDOCA | Universal Journal (S/4HANA) — the single line-item table | | BKPF / BSEG | Accounting document header / line items (ECC) | | BSID / BSAD | Customer open / cleared items | | BSIK / BSAK | Vendor open / cleared items | | SKA1 / SKB1 | GL account (chart level / company code level) | | T001 | Company codes | | TCURR | Exchange rates | | T001B | Posting period permissions | | ANLA / ANLC | Asset master / asset values |

Master data

| Table | Contents | |—|—| | MARA | Material general data | | MARC | Material plant data | | MARD | Material storage location data | | MBEW | Material valuation | | MVKE | Material sales data | | MAKT | Material descriptions | | KNA1 / KNB1 / KNVV | Customer general / company code / sales area | | LFA1 / LFB1 / LFM1 | Vendor general / company code / purchasing org | | BUT000 | Business Partner (S/4HANA) | | T001W | Plants | | CSKS | Cost centres | | CEPC | Profit centres |

Transactional

| Table | Contents | |—|—| | VBAK / VBAP | Sales order header / items | | VBEP | Sales order schedule lines | | VBFA | Document flow | | LIKP / LIPS | Delivery header / items | | VBRK / VBRP | Billing header / items | | EKKO / EKPO | Purchase order header / items | | EKET | PO schedule lines | | EKBE | PO history (receipts and invoices) | | EBAN | Purchase requisitions | | MKPF / MSEG | Material document header / items | | RESB | Reservations | | AFKO / AFPO | Production order header / items | | AFVC | Production order operations | | MAST / STPO | BOM link / BOM items | | PLKO / PLPO | Routing header / operations | | A*** / KONP | Condition tables / condition records | | CDHDR / CDPOS | Change documents (the audit trail) |

Common transaction codes

| Code | Function | |—|—| | FB01 / FB03 | Post / display GL document | | FB50 | Enter GL account document | | F-28 / F-53 | Incoming / outgoing payment | | FBL1N / FBL5N / FBL3N | Vendor / customer / GL line items | | F.01 | Financial statements | | MM01 / MM02 / MM03 | Create / change / display material | | XD01 / XK01 | Create customer / vendor | | BP | Business Partner (S/4HANA) | | ME21N / ME22N / ME23N | Create / change / display PO | | ME51N | Create purchase requisition | | MIGO | Goods movement | | MIRO | Invoice verification | | MB52 / MMBE | Stock overview | | VA01 / VA02 / VA03 | Create / change / display sales order | | VL01N | Create outbound delivery | | VF01 | Create billing document | | VK11 | Create condition record | | CO01 / CO02 | Create / change production order | | CO11N | Production confirmation | | MD01 / MD02 / MD04 | MRP run / single-item MRP / stock requirements list | | CS01 / CS03 | Create / display BOM | | CA01 | Create routing | | SE11 / SE16N | Data Dictionary / table display | | SE38 / SE80 | ABAP editor / object navigator | | SM37 | Job monitoring | | SM12 | Lock entries | | ST22 | Short dumps | | SU01 / PFCG | User maintenance / role maintenance | | SPRO | Configuration (IMG) | | SE10 / STMS | Transport organiser / transport management |

Common SAP movement types

Type Movement
101 / 102 Goods receipt for PO / reversal
103 / 105 GR into blocked stock / release from blocked
122 Return delivery to vendor
201 / 202 Goods issue to cost centre / reversal
261 / 262 Goods issue to production order / reversal
301 Plant to plant transfer, one step
311 Storage location transfer
321 Quality inspection to unrestricted
343 Blocked to unrestricted
501 Receipt without purchase order
551 Scrapping
561 Initial stock upload
601 Goods issue for delivery
641 Goods issue for stock transport order
701 / 702 Physical inventory adjustment

SAP posting keys

Key Posting
40 / 50 GL account debit / credit
01 / 11 Customer invoice / credit memo
15 Customer payment (credit)
21 / 31 Vendor credit memo / invoice
25 Vendor payment (debit)
70 / 75 Asset debit / credit

Dynamics 365 F&O key tables

Table Contents
GeneralJournalEntry / GeneralJournalAccountEntry Journal header / lines
MainAccount Chart of accounts
DimensionAttributeValueCombination Financial dimension combinations
CustTable / VendTable Customer / vendor master
CustTrans / VendTrans Customer / vendor transactions
InventTable / InventDim Item master / inventory dimensions
InventTrans Inventory transactions
SalesTable / SalesLine Sales order header / lines
PurchTable / PurchLine Purchase order header / lines
CustInvoiceJour / CustInvoiceTrans Sales invoice header / lines
VendInvoiceJour Vendor invoice journal
ProdTable / ProdBOM / ProdRoute Production order / BOM / route
BOMTable / BOMVersion BOM master / version
WMSJournalTable Warehouse journals
DirPartyTable Global address book party

NetSuite record types

Record Purpose
customer / vendor Entities
salesorder / purchaseorder Orders
invoice / vendorbill Bills
creditmemo / vendorcredit Credits
itemfulfillment / itemreceipt Fulfilment / receipt
inventoryitem / assemblyitem / noninventoryitem Items
journalentry GL
account Chart of accounts
transaction The unified transaction table (SuiteQL)
customrecord_* Custom records
workorder Manufacturing
subsidiary / department / class / location Org dimensions

Odoo key models

Model Purpose
res.partner Customers, vendors, contacts — the unified party
res.company Company / legal entity
res.currency / res.currency.rate Currencies and rates
product.template / product.product Product / variant
uom.uom Units of measure
account.account Chart of accounts
account.move / account.move.line Journal entry / line (also invoices)
account.payment Payments
account.tax Tax codes
sale.order / sale.order.line Sales order
purchase.order / purchase.order.line Purchase order
stock.picking / stock.move / stock.move.line Transfers and moves
stock.quant Stock on hand per location
stock.location / stock.warehouse Locations
mrp.bom / mrp.production / mrp.routing BOM / manufacturing order / routing
hr.employee Employee
project.project / project.task Projects
ir.model / ir.ui.view / ir.rule Metadata, views, record rules

ERPNext key DocTypes

DocType Purpose
Customer / Supplier Parties
Item / Item Price Items and pricing
Account Chart of accounts
GL Entry General ledger entries
Journal Entry Manual journals
Sales Order / Sales Invoice / Delivery Note O2C
Purchase Order / Purchase Invoice / Purchase Receipt P2P
Payment Entry Payments
Stock Entry / Stock Ledger Entry Inventory movements
Bin Stock balance per item per warehouse
BOM / Work Order / Job Card Manufacturing
Warehouse / Company / Cost Center Org structure
Batch / Serial No Traceability
Employee / Salary Slip HR and payroll
Version Automatic change history on every document

EDI transaction sets

X12 EDIFACT Meaning
850 ORDERS Purchase order
855 ORDRSP PO acknowledgement
860 ORDCHG PO change
856 DESADV Advance ship notice
810 INVOIC Invoice
820 REMADV Remittance advice
846 INVRPT Inventory advice
852 SLSRPT Product activity / POS data
830 DELFOR Planning schedule
862 DELJIT Shipping schedule (JIT)
214 IFTSTA Transport status
940 / 945 — Warehouse shipping order / advice
997 CONTRL Functional acknowledgement

ISO 20022 message types

Message Purpose
pain.001 Customer credit transfer initiation
pain.002 Payment status report
pain.008 Direct debit initiation
camt.052 Intraday account report
camt.053 Bank-to-customer statement
camt.054 Debit/credit notification

Next