SAP FICO Tables

FICO related tables and structures

Purpose

This page will discuss SAP tables and structures used in SAP Finance. This can be used as a ready reference for writing FS or for data analysis.

  • Transaction code: SE16N can be used to view data in Table
  • Transaction code: SE11 can be used to view Table structure

Customer Master Data

Table/Structure Description
KNA1 Customer Master: General Data
KNB1 Customer Master: Company Code Data
KNB4 Customer Payment History
KNB5 Customer Master: Dunning data
KNBK Customer Master: Bank Details
KNBW Customer Master: Wwithholding tax types
KNKA Customer Master: Credit Mgmt.
KNKK Customer Master: Credit Control Area Data – credit limits
KNVA Customer Master: Loading/Unloading Points
KNVD Customer Master: Record sales request form/documents
KNVH Customer Hierarchies
KNVI Customer Master: Tax Indicator
KNVK Customer Master: Contact Partner
KNVL Customer Master: Licenses
KNVP Customer Master: Partner Functions
KNVS Customer Master: Shipping Data
KNVT Customer Master: Record Texts for Sales
KNVV Customer Master: Sales Data
KLPA Customer/Vendor Link

Vendor  Master Data

Table/Structure Description
LFA1 Vendor Master (General Section)
LFB1 Vendor Master (Company Code)
LFAS Vendor master (VAT registration numbers general section)
LFB5 Vendor master (dunning data)
LFBK Vendor Master (Bank Details)
LFBW Vendor master record (withholding tax types) X
LFM1 Vendor master record purchasing organization data
LFM2 Vendor Master Record: Purchasing Data
LFM2 Vendor Subrange
WYT1T Vendor Sub Range Description
WYT3 Partner Functions

 

Material Master Data

Table/Structure Description
MARA General Material Data
MVKE Sales Data for Material
MARC Plant Data for Material
MARD Storage Location Data for Material
MAKT Short texts
MARM Conversion factors
MVKE Sales data – for each sales organization and distribution channel
MLAN Sales data – for each country
MAEX Export licenses
MBEW Valuation data
MLGN Warehouse management inventory data
MLGT Warehouse management inventory type data
MVER Consumption data
MAPR Pointers for forecast data
MCHA Batches
MCH1 Cross-plant Batches
MCHB Batch stocks
KNMTK Header table – for increased performance
KNMT Data table

Customer Billing Document

Table/Structure Description
VBRK Billing: Header data
VBRP Billing: Item data

Vendor Invoice  Document

Table/Structure Description
RSEG Document Item: Incoming Invoice
RBKP Document Header: Invoice Receipt
BSIM Secondary Index, Documents for Material
RKWA Consignment Withdrawals
RBCO Document Item, Incoming Invoice, Account Assignment
RBKP_BLOCKED Logistics Invoice Verification: Blocked Invoices
RBKP_V Generierte Tabelle zu einem View
V_169P_MB Generierte Tabelle zu einem View
T149D Global Valuation Types
RBDRSEG Batch IV: Invoice Document Items

 

Bill of Material (BOM)

Table/Structure Description
MAST Material assignment to BOM
EQST Equipment assignment to BOM
KDST Sales order assignment to BOM
DOST Document assignment to BOM
STST Standard object assignment to BOM
TPST Functional location assignment to BOM
STKO BOM header data
STZU Time-independent STL data
STAS BOM item selection
STPO BOM item data
STPU BOM sub-item data

Sales and Purchasing Pricing

Table/Structure Description
KOMK Pricing Communications: Header (Structure)
KOMP Pricing Communication: Item (Structure)
KONV Conditions: Transaction Data
KONP Conditions: Item
KONH Conditions: Header
KOND Contracts
VEDA Contract Data

Output

Table/Structure Description
NAST Output: Message Status

Text

Table/Structure Description
STXH Texts: Header
STXL Texts: Line