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 |