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/StructureDescription
KNA1Customer Master: General Data
KNB1Customer Master: Company Code Data
KNB4Customer Payment History
KNB5Customer Master: Dunning data
KNBKCustomer Master: Bank Details
KNBWCustomer Master: Wwithholding tax types
KNKACustomer Master: Credit Mgmt.
KNKKCustomer Master: Credit Control Area Data – credit limits
KNVACustomer Master: Loading/Unloading Points
KNVDCustomer Master: Record sales request form/documents
KNVHCustomer Hierarchies
KNVICustomer Master: Tax Indicator
KNVKCustomer Master: Contact Partner
KNVLCustomer Master: Licenses
KNVPCustomer Master: Partner Functions
KNVSCustomer Master: Shipping Data
KNVTCustomer Master: Record Texts for Sales
KNVVCustomer Master: Sales Data
KLPACustomer/Vendor Link

Vendor  Master Data

Table/StructureDescription
LFA1Vendor Master (General Section)
LFB1Vendor Master (Company Code)
LFASVendor master (VAT registration numbers general section)
LFB5Vendor master (dunning data)
LFBKVendor Master (Bank Details)
LFBWVendor master record (withholding tax types) X
LFM1Vendor master record purchasing organization data
LFM2Vendor Master Record: Purchasing Data
LFM2Vendor Subrange
WYT1TVendor Sub Range Description
WYT3Partner Functions

 

Material Master Data

Table/StructureDescription
MARAGeneral Material Data
MVKESales Data for Material
MARCPlant Data for Material
MARDStorage Location Data for Material
MAKTShort texts
MARMConversion factors
MVKESales data – for each sales organization and distribution channel
MLANSales data – for each country
MAEXExport licenses
MBEWValuation data
MLGNWarehouse management inventory data
MLGTWarehouse management inventory type data
MVERConsumption data
MAPRPointers for forecast data
MCHABatches
MCH1Cross-plant Batches
MCHBBatch stocks
KNMTKHeader table – for increased performance
KNMTData table

Customer Billing Document

Table/StructureDescription
VBRKBilling: Header data
VBRPBilling: Item data

Vendor Invoice  Document

Table/StructureDescription
RSEGDocument Item: Incoming Invoice
RBKPDocument Header: Invoice Receipt
BSIMSecondary Index, Documents for Material
RKWAConsignment Withdrawals
RBCODocument Item, Incoming Invoice, Account Assignment
RBKP_BLOCKEDLogistics Invoice Verification: Blocked Invoices
RBKP_VGenerierte Tabelle zu einem View
V_169P_MBGenerierte Tabelle zu einem View
T149DGlobal Valuation Types
RBDRSEGBatch IV: Invoice Document Items

 

Bill of Material (BOM)

Table/StructureDescription
MASTMaterial assignment to BOM
EQSTEquipment assignment to BOM
KDSTSales order assignment to BOM
DOSTDocument assignment to BOM
STSTStandard object assignment to BOM
TPSTFunctional location assignment to BOM
STKOBOM header data
STZUTime-independent STL data
STASBOM item selection
STPOBOM item data
STPUBOM sub-item data

Sales and Purchasing Pricing

Table/StructureDescription
KOMKPricing Communications: Header (Structure)
KOMPPricing Communication: Item (Structure)
KONVConditions: Transaction Data
KONPConditions: Item
KONHConditions: Header
KONDContracts
VEDAContract Data

Output

Table/StructureDescription
NASTOutput: Message Status

Text

Table/StructureDescription
STXHTexts: Header
STXLTexts: Line