SAP Table

T001 Company Codes

SAP table T001 is a fundamental table in the SAP ERP system that stores general company data. This table contains essential information about the organizational structure of a company, specifically at the company code level. Each entry in T001 represents a company code, which is a unique identifier for an independent accounting entity within the SAP system.

SAP table T001 has 2 primary key fields being MANDT,BUKRS.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

T001 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyBUKRS Company Code CHAR 4 0 BUKRS
BUTXT Name of Company Code or Company CHAR 25 0 BUTXT
ORT01 City CHAR 25 0 ORT01
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
WAERS Currency Key CUKY 5 0 TCURC WAERS
SPRAS Language Key LANG 1 0 T002 SPRAS
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
WAABW Maximum exchange rate deviation in percent NUMC 2 0 WAABW_001
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
KOKFI Allocation Indicator CHAR 1 0 KOKFI
RCOMP Company CHAR 6 0 T880 RCOMP_D
ADRNR Address CHAR 10 0 ADRNR
STCEG VAT Registration Number CHAR 20 0 STCEG
FIKRS Financial Management Area CHAR 4 0 FM01 FIKRS
XFMCO Indicator: Project Cash Management active? CHAR 1 0 XFMCO
XFMCB Indicator: Cash Budget Management Active CHAR 1 0 XFMCB
XFMCA Activate Update in Funds Management CHAR 1 0 XFMCA
TXJCD Jurisdiction for tax calculation - tax jurisdiction code CHAR 15 0 TXJCD_NSTX
FMHRDATE Funds center can be assigned to an account in HR from DATS 8 0 FM_HRDATE
XTEMPLT Company code is a template CHAR 1 0 FINS_XTEMPLT
TRANSIT_PLANT Transit Plant CHAR 4 0 FINS_TRANSIT_PLANT
BUVAR Company Code Variant (Screen) CHAR 1 0 BUVAR
FDBUK Cash Management and Forecast Company Code CHAR 4 0 T001 FDBUK
XFDIS Indicator: Cash Management Activated? CHAR 1 0 XFDIS
XVALV Indicator: Propose Current Date As Value Date? CHAR 1 0 XVALV
XSKFN Indicator: Discount base amount is the net value CHAR 1 0 XSKFN
KKBER Credit control area CHAR 4 0 T014 KKBER
XMWSN Indicator: Base amount for tax is net of discount ? CHAR 1 0 XMWSN
MREGL Rules for Copying from the Sample Account for G/L Accounts CHAR 4 0 T004R MREGL
XGSBE Indicator: Business Area Financial Statements Required? CHAR 1 0 XGSBE
XGJRV Indicator: Propose Fiscal Year? CHAR 1 0 XGJRV
XKDFT Indicator: Post Translations for Exchange Rate Differences? CHAR 1 0 XKDFT
XPROD Indicator: Productive Company Code? CHAR 1 0 XPROD_001
XEINK Indicator: Purchase Account Processing Is Active CHAR 1 0 XEINK
XJVAA Indicator: JVA Active CHAR 1 0 JV_ACTIVE
XVVWA Indicator: Financial Assets Management Active CHAR 1 0 XVVWA
XSLTA Indicator: No Exchange Rate Difference When Clearing in LC CHAR 1 0 XSLTA
XFDMM Indicator: Updating MM in Cash Mgmt/Forecast Activated? CHAR 1 0 XFDMM
XFDSD Indicator: Updating SD in Cash Mgmt/Forecast Activated? CHAR 1 0 XFDSD
XEXTB Indicator: Company Code Is in Another System CHAR 1 0 XEXTB
EBUKR Original Key of the Company Code CHAR 4 0 EBUKR_001
KTOP2 Alternative Chart of Accounts CHAR 4 0 T004 KTOP2
UMKRS Taxes on Sales/Purchases Group CHAR 4 0 T007F UMKRS
BUKRS_GLOB Name of global company code CHAR 6 0 T001O BUKRS_GLOB
FSTVA Field Status Variant CHAR 4 0 T004V FSTVA
OPVAR Posting Period Variant CHAR 4 0 T010O OPVAR
XCOVR Indicator: hedge request active CHAR 1 0 XCOVR
TXKRS Foreign Currency Translation for Tax Items CHAR 1 0 TXKRS
WFVAR Workflow Variant CHAR 4 0 VBWF01 WFVAR
XBBBF G/L account authorization check in inventory management CHAR 1 0 XBBBF
XBBBE G/L account authorization check in PO/scheduling agreement CHAR 1 0 XBBBE
XBBBA G/L account authorization check in purchase requisitions CHAR 1 0 XBBBA
XBBKO G/L account authorization check in contracts CHAR 1 0 XBBKO
XSTDT Indicator: Document Date As the Basis for Tax Determination CHAR 1 0 XSTDT_001
MWSKV Input Tax Code for Non-Taxable Transactions CHAR 2 0 * MWSKZ_NSTV
MWSKA Output Tax Code for Non-Taxable Transactions CHAR 2 0 * MWSKZ_NSTA
IMPDA Foreign Trade: Import Data Control in MM Purchase Orders CHAR 1 0 IMPDATEN
XNEGP Indicator: Negative Postings Permitted CHAR 1 0 XNEGP_ACT
XKKBI Indicator: Can Credit Control Area Be Overwritten? CHAR 1 0 XKKBI
WT_NEWWT Indicator: Extended Withholding Tax Active CHAR 1 0 WT_NEWWT
PP_PDATE Procedure for Setting the Posting Date CHAR 1 0 PP_PDATE
INFMT Inflation Method CHAR 4 0 J_1AINFMET J_1AINFME_
FSTVARE Funds Reservation Field Status Variant CHAR 4 0 TREV FSTVARE
KOPIM Foreign trade: Import data copying control for GR CHAR 1 0 KOPIM
DKWEG Foreign Trade: Screen ctrl of imp.data f. MM-goods rececipt CHAR 1 0 DKWEG
OFFSACCT Method for Offsetting Account Determination NUMC 1 0 GOFFSACCT
BAPOVAR Additional settings variant for bus.area financial statemnts CHAR 2 0 TGSB_CUS BAPOVAR
XCOS Cost of Sales Accounting Status CHAR 1 0 XCOS
XCESSION Accounts Receivable Pledging Active CHAR 1 0 X_CESSION
XSPLT Enable Amount Split CHAR 1 0 BSPLT
SURCCM Surcharge Calculation Method CHAR 1 0 J_1ISURC
DTPROV Document Type for Provisions for Taxes on Services Received CHAR 2 0 T003 J_1IPROV
DTAMTC Document Type for Journal Voucher (Amount Correction) CHAR 2 0 T003 J_1IAMTC
DTTAXC Document Type for Journal Voucher (Tax Code Correction) CHAR 2 0 T003 J_1ITAXC
DTTDSP Document Type for Remittance Challans CHAR 2 0 T003 J_1ITDSTYP
DTAXR Deferred Tax Rule CHAR 4 0 T007DT DTAXR
XVATDATE Tax Reporting Date Active in Documents CHAR 1 0 XVATDATE
PST_PER_VAR Manage Variant of Posting Period for Company Code/Ledger CHAR 1 0 FAGL_POST_PER_VAR
XBBSC G/L account authorization check in shopping cart CHAR 1 0 /SRMERP/XBBSC
F_OBSOLETE Hide Entry in Value Help CHAR 1 0 FI_OBSOLETE_F4
FM_DERIVE_ACC Activate Account Assignment Derivation in Funds Management CHAR 1 0 FM_DERIVE_ACC
/ Relationships

T001 foreign keys.

The T001 table is interconnected with numerous other SAP tables, which facilitates comprehensive data management and operational efficiency across different modules. Some of the most important connections include:

  • T001K (Company Code - Chart of Accounts): Links company codes to their respective charts of accounts, ensuring proper financial data categorization.
  • T001L (Company Code - Currency): Stores information about the local currency used by each company code.
  • T001W (Plants/Branches): Connects company codes to plant data, which is essential for material management and logistics processes.
  • SKA1 (G/L Account Master - Chart of Accounts): Ensures that general ledger accounts are accurately linked to the company codes through the chart of accounts.
  • BKPF (Accounting Document Header): Associates financial documents with the relevant company codes, enabling accurate financial reporting and auditing.

Understanding the role of table T001 and its connections with other tables is essential for managing organizational and financial data in an SAP ERP system. This table is a cornerstone for various business processes, ensuring that company-specific data is organized, consistent, and accessible.

Table Field Check Table Description Check Field
T001 BUKRS_GLOB T001O Cross-System Company Codes MANDT
T001 DTAMTC T003 Document Types MANDT
T001 DTAXR T007DT Deferred Tax Rules MANDT
T001 DTPROV T003 Document Types MANDT
T001 DTTAXC T003 Document Types MANDT
T001 DTTDSP T003 Document Types MANDT
T001 FDBUK T001 Company Codes BUKRS
T001 FIKRS FM01 Financial Management Areas FIKRS
T001 FSTVA T004V Field Status Variant MANDT
T001 FSTVARE TREV Field Status Variant for Funds Reservation MANDT
T001 FSTVARE TREV Field Status Variant for Funds Reservation FSTVARE
T001 INFMT J_1AINFMET Inflation Methods LAND1
T001 KKBER T014 Credit control areas KKBER
T001 KTOP2 T004 Directory of Charts of Accounts MANDT
T001 KTOP2 T004 Directory of Charts of Accounts KTOPL
T001 KTOPL T004 Directory of Charts of Accounts MANDT
T001 LAND1 T005 Countries MANDT
T001 LAND1 T005 Countries LAND1
T001 MANDT T000 Clients MANDT
T001 MREGL T004R Rules index for sample accounts MANDT
T001 OPVAR T010O Posting Period Variants MANDT
T001 PERIV T009 Fiscal Year Variants MANDT
T001 PERIV T009 Fiscal Year Variants PERIV
T001 RCOMP T880 Global Company Data (for KONS Ledger) MANDT
T001 RCOMP T880 Global Company Data (for KONS Ledger) RCOMP
T001 UMKRS T007F Taxes on Sales/Purchases Groups UMKRS
T001 WAERS TCURC Currency Codes MANDT
T001 WAERS TCURC Currency Codes WAERS
T001 WFVAR VBWF01 Company Code-Dependent Release Data MANDT
Back to SAP tables