SAP Tables

Table of Contents

SAP Tables

 

FI Enterprise Structure Tables

Table DescriptionTable
SAP Company CodeT001
Countries in SAPT005
Global Company DataT880
SAP Currency CodesTCURC
SAP Exchange RatesTCURR
GL Account GroupsT077S
Directory of Chart of AccountsT004
Fiscal Year variant in SAPT009
Credit Control Area in SAPT014
Directory of Charts of Accounts in SAPT004
Posting period Variants in SAPT010O
Permitted Posting PeriodsT001B
House Banks in SAPT012

 

SAP GL Tables

Table DescriptionTable
G/L Account Master (Chart of Accounts)SKA1
G/L account master (company code)SKB1
G/L Account Master Record (Chart of Accounts: Description)SKAT
Accounting Document HeaderBKPF
Accounting Document SegmentBSEG

 

SAP FI Accounting Documents

Table DescriptionTable
Accounting Document Header DataBKPF
Accounting Document line item dataBSEG
Accounting: Secondary index G/L AccountsBSIS
Accounting: Secondary G/L Accounts cleared itemsBSAS
Accounting: Secondary index CustomersBSID
Accounting: Secondary Customer cleared itemsBSAD
Accounting: Secondary index VendorsBSIK
Accounting: Secondary Vendors Cleared itemsBSAK
Tax Data Document line itemBSET

 

SAP Accounts Receivable Tables

Table DescriptionTable
General Data in Customer MasterKNA1
Customer Master (Company Code)KNB1
Customer Payment HistoryKNB4
Customer master (dunning data)KNB5
Customer Bank DetailsKNBK
Customer Master Partner FunctionsKNVP
Customer Master Sales DataKNVV

 

SAP Accounts Payable Tables

Table DescriptionTable
Vendor Master (General Section)LFA1
Vendor Master (Company Code)LFB1
Vendor Master (Bank Details)LFBK
Vendor master (dunning data)LFB5
Vendor master record purchasing organization dataLFM1
Vendor Master Record: Purchasing DataLFM2

 

SAP Controlling Tables

Table DescriptionTable
Profit Center Master Data TableCEPC
Texts for Profit Center Master DataCEPCT
Cost Center Master DataCSKS
Cost Center TextsCSKT
Cost Elements (Data Dependent on Chart of Accounts)CSKA
Cost Elements (Data Dependent on Controlling Area)CSKB
Cost Element TextsCSKU
CO Object: Line ItemCOEP
CO Object: Document HeaderCOBK
Orders master DataAUFK
Order Header Data – PP OrdersAFKO
Order Line item dataAFPO

    1. SAP Product Costing Tables
Table DescriptionTable
Controlling Areas AssignmentTKA01
Production Order Confirmation TableAFRU
Production Order Line Item TableAFPO
Material Valuation tableMBEW
Product Costing Header DataKEKO
Itemization Product CostingCKIS
Cost Components for Cost of Goods Mfd.KEPH

Leave a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!