SAP Financial Accounting (FI) Tables

TableDescriptionModule
A395Arg.: Country/Fisc.TypeFI
A396Arg.: Country/Fisc.Type/MaterialFI
A397Arg.: Tax relevant classificationFI
AGKOCleared AccountsFI
AVICAdvice CommunicationFI
AVIKPayment Advice HeaderFI
AVIPPayment Advice Line ItemFI
AVIRPayment Advice SubitemFI
AVITAdvice Header: User-Definable TextFI
BKDFDocument Header Supplement for Recurring EntryFI
Show More SAP FI Tables

SAP General Ledger Accounting Tables

TableDescriptionModule
ACAC_OBJECTSManual Accruals: Accrual ObjectsFI-GL
ACEDSASSGMTStandard Account Assignments for Accrual ObjectsFI-GL
ACEDSOHAccrual Subobject Header DataFI-GL
ACEDSOIItem Data for Accrual SubobjectFI-GL
ACEDSOI_ACCOUNTSAccounts for Accrual Postings per Accrual ItemFI-GL
ACEDSOPAccrual Subobject ParametersFI-GL
ACEOBJAccrual ObjectsFI-GL
ACEPSOHAccrual Subobject: Header Data in Posting ComponentFI-GL
ACEPSOIAccrual Item: Values in Posting ComponentFI-GL
ACEPSOITLine Items for Accrual Item in Accrual EngineFI-GL
ACEPSPPLOGLogical Periodic Accrual RunFI-GL

Full List of SAP General Ledger Accounting Tables


SAP Consolidation Tables

TableDescriptionModule
EWULC01FI-LC: LC ledgerFI-LC
EWULC02FI-LC: Ledgers for conversionFI-LC
EWULC03FI-LC: Companies for conversionFI-LC
EWULC04FI-LC: Settings for euro conversion adjustmentsFI-LC
FILCAFI-LC: Actual journal entry table with 2 object tablesFI-LC
FILCCFI-LC: Transaction-related fields for table FILCTFI-LC
FILCOFI-LC: Acct assign.fields (Object-TrPartner) for table FILCTFI-LC
FILCPFI-LC: Plan line items for object tableFI-LC
FILCTFI-LC: Global totals table with 2 object tablesFI-LC
GLS2IDXIndex table for FI-LC document clusterFI-LC
GLT2Consolidation totals tableFI-LC

Full List of SAP Consolidation Tables


SAP Accounts Payable Tables

TableDescriptionModule
BANKA_CUP_ITBank Account Number maintenance for CUP/CIG NumberFI-AP
CRACCPayment Cards: Account Assignments in Card Master RecordFI-AP
CRFILEHDPayment Card File: HeaderFI-AP
CRFILEPOSPayment Card File: Individual RecordsFI-AP
CRFILESTATPayment Card File: Status Information for Individual RecordsFI-AP
CRNUMPayment cards: Card master recordFI-AP
CUP_DOC_ITDocument relevant for CUP/CIG NumberFI-AP
CUP_T012K_ITHouse bank details for CUP/CIGFI-AP
FEDIWF1FI EDI: Person with signing authorityFI-AP
FIAPPTD_KUKEYID administrationFI-AP
FIPAY_T042_GTSSAP GTS Check - Activation in FIFI-AP

Full List of SAP Accounts Payable Tables


SAP Accounts Receivable Tables

TableDescriptionModule
BSIWIndex table for customer bills of exchange usedFI-AR
BSIXIndex table for customer bills of exchange usedFI-AR
CRMD_CCM_LINKLink from payment item to claim chargeback recovery in CRMFI-AR
FIALOGActivity logFI-AR
FSEPA_INST_CDLocal Instrument and Lead Times for SEPA Direct DebitsFI-AR
FSEPA_INST_SLPriority Rules for Local Instrument and Lead TimesFI-AR
FSEPA_REFTYPESEPA Mandate: Permitted Contract TypesFI-AR
FSEPA_REFTYPETSEPA Mandate: Text Table for Permitted Contract TypesFI-AR
KNKACustomer master credit management: Central dataFI-AR
KNKKCustomer master credit management: Control area dataFI-AR
KNKKF1Credit Management: FI Status DataFI-AR

Full List of SAP Accounts Receivable Tables


SAP Contract Accounts Receivable and Payable Tables

TableDescriptionModule
ARCH_FKKKOFI-CA doc: Header-oriented doc index for archiveFI-CA
ARCH_FKKOPFI-CA doc: Header-oriented doc index for archiveFI-CA
ARJ_1A101ARGENTINA: Legal rep.historical data for the daily reportsFI-CA
BCONTBusiness Partner ContactFI-CA
BCONTAContact ActivitiesFI-CA
BCONTAIAdditional Contact InformationFI-CA
BCONTAITAdditional Information: TextsFI-CA
BCONTAOAllowed Contact Objects (obsolete as of 4.51)FI-CA
BCONTAOTContact Object Types: Texts (obsolete as of 4.51)FI-CA
BCONTATContact Activities: TextsFI-CA
BCONTBPOBJTYPBusiness Partner Object TypeFI-CA

Full List of SAP Contract Accounts Receivable and Payable Tables


SAP Bank Accounting Tables

TableDescriptionModule
ACRELATIONRelationships in AccountingFI-BL
BSEGCDocument: Data on Payment Card PaymentsFI-BL
BUSPROC_FCT_FIEBFIEB: Function Modules for Business ProcessFI-BL
CCENQPayment cards: Primary table for lock object EFCCENQFI-BL
DFPAYGPayment date: GroupingFI-BL
DFPAYHTNote to Payee and Payment Advice Note TextsFI-BL
DFPAYMENT_KEY_IDContains ID for Payment Data KeyFI-BL
DFPAYVPayment Medium: Selection VariantsFI-BL
DFPM_AUTHPayment medium: Authorization Check Origin ActiveFI-BL
F111GGlobal Settings: Payment Program for Payment RequestsFI-BL
F111PARAM_MODIFYNote whether RF_F111_PARAMETERS_MODIFY_ONCE has already runFI-BL

Full List of SAP Bank Accounting Tables


SAP Asset Accounting Tables

TableDescriptionModule
AAACC_EXCLException Table for Account Assignment Settings in FI-AAFI-AA
AAACC_OBJAccount Assignment Settings in Asset AccountingFI-AA
AAACC_OBJ_ERRTypes of Error During Check of Acct Assignment in FI-AAFI-AA
ANARAsset TypesFI-AA
ANATAsset type textFI-AA
ANEAAsset Line Items for Proportional ValuesFI-AA
ANEKDocument Header Asset PostingFI-AA
ANEPAsset Line ItemsFI-AA
ANEVAsset downpymt settlementFI-AA
ANGAAsset catalog general dataFI-AA
ANGBAsset catalog deprec. areaFI-AA

Full List of SAP Asset Accounting Tables


SAP Lease Accounting Tables

TableDescriptionModule
FIEH_STATUSObject Status for Restart Exception HandlingFI-LA
FILA_GF_ITEMCHAHObject Data: Value ID Change Header InformationFI-LA
FILA_GF_ITEMDATAProcess DataFI-LA
FILA_GF_ITEMDOCSAssignment of Process - FI/CO Document NumbersFI-LA
FILA_GF_ITEMLINKAssignment of Objects to AssetsFI-LA
FILA_GF_ITEMPARMObject Data: Additional InformationFI-LA
FILA_GF_ITEMVALCObject Data: Changed Value IDsFI-LA
FILA_GF_ITEMVALSObject Data: Value IDs and their Values/ContentsFI-LA
FILA_GF_PROCINFOObject Data: Processing Info for ProcessFI-LA
FILA_MIG_RESTARTRestart Legacy Data Transfer for Lease AccountingFI-LA
FILA_MIG_SYNCSynchronization of CRM and LAE Legacy DataFI-LA

Full List of SAP Lease Accounting Tables


SAP Special Purpose Ledger Tables

TableDescriptionModule
ARC_IDX_ATIndex table for ACCTIT/ACCTHD/ACCTCR archivesFI-SL
ARC_IDX_ITArchive index table for FI-SL line itemsFI-SL
FAGL_CUS_GENINFONew General Ledger Accounting: Generation Status (Customer)FI-SL
GB01Classes for Boolean FormulasFI-SL
GB011Rule Manager: 2D Structures in the Boolean ClassesFI-SL
GB01CClasses for Boolean Formulas for CustomersFI-SL
GB02Valid ClassesFI-SL
GB02CCustomer Message IDs for ValidationsFI-SL
GB02TBoolean Logic: Text Table for Boolean ClassesFI-SL
GB03Validation/Substitution UserFI-SL
GB03TValidation/Substitution Application Area TextFI-SL

Full List of SAP Special Purpose Ledger Tables


SAP Retail Ledger Tables

TableDescriptionModule
PCRRETAILAActual line item tableFI-RL
PCRRETAILCObject Table 2FI-RL
PCRRETAILOObject Table 1FI-RL
PCRRETAILPPlan line items tableFI-RL
PCRRETAILTTotals TableFI-RL
PCRR_AS_AREACheck table for PCRRETAILT: Assortment Area RASAREA_7FI-RL
PCRR_AS_AREATCheck table for PCRRETAILT: Assortment Area RASAREA_7FI-RL

SAP Funds Management Tables

TableDescriptionModule
BPBKDoc.Header Controlling Obj.FI-FM
BPCGControlling Object, by YearFI-FM
BPCJControlling Object, by YearFI-FM
BPCKControlling objects, activated objectsFI-FM
BPDGTotal Values Entry DocumentFI-FM
BPDJAnnual Values Entry DocumentFI-FM
BPDKHeader Entry DocumentFI-FM
BPDKTHeader Text Entry DocumentFI-FM
BPDPPeriod Values Entry DocumentFI-FM
BPDZLine Entry DocumentFI-FM
BPDZTText Line Entry DocumentFI-FM

Full List of SAP Funds Management Tables


SAP Travel Management Tables

TableDescriptionModule
BTS_ERROR_CODESError Codes of SABRE/BTS-API ServerFI-TV
FITV_HINZ_WERB_BAdditional Amounts and Income-Related Expenses for ReceiptsFI-TV
FITV_HINZ_WERB_SAdditional Amounts and Income-Related ExpensesFI-TV
FITV_MEAL_ACCOMAdditional Amounts for Meals in Accommodations ReceiptsFI-TV
FITV_NOT_CH_TRKey Fields of Temp. Non-Changeable Trips/Duty AllocationFI-TV
FITV_REJECTRejected TripsFI-TV
FTPT_CARTravel Request Item - Car Rental ServiceFI-TV
FTPT_CAR_PREFRental car service preferences of a travel planFI-TV
FTPT_CSX_PROFILERelationship SAP Human Resources Number - Amadeua ProfileFI-TV
FTPT_FARE_COMPRate componentsFI-TV
FTPT_FARE_NOTERate RulesFI-TV

Full List of SAP Travel Management Tables


SAP Localization Tables

TableDescriptionModule
A151Dest. Ctry/Comm. codeFI-LOC
A373Country/Plant/MaterialFI-LOC
A374Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3MatFI-LOC
A375Country/Sales org./Region/PlntRegion/TaxCl2Cust/TaxCl.2MatFI-LOC
A376Country/Sales org./Region/PlntRegion/TaxCl4Cust/TaxCl.4MatFI-LOC
ATAFS_SIGNATORYAnnual Financial Statement Austria Signatory informationFI-LOC
BASE_TYPE_ITAssign Base Amount TypeFI-LOC
BEL_JOURNALBelgium : Sales/Purchase Journal Period BalancesFI-LOC
BUSTYPEType of BusinessFI-LOC
CDF_EXT_ITEM_LUCDF External Item LuxembourgFI-LOC
CIS_VF_EXTExtension Table for CIS Sub contractorsFI-LOC

Full List of SAP Localization Tables