T001 SAP (Company Codes) Table details
Dictionary Type: Table
Description: Company Codes
Description: Company Codes
Table field list including key, data, relationships and ABAP select examples
T001 is a standard SAP Table which is used to store Company Codes data and is available within R/3 SAP systems depending on the version and release level.
The T001 table consists of various fields, each holding specific information or linking keys about Company Codes data available in SAP. These include BUKRS (Company Code), BUTXT (Name of Company Code or Company), ORT01 (City), LAND1 (Country Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP T001 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
ORT01 | City | ORT01 | CHAR | 25 | TEXT25 | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
KTOPL | Chart of Accounts | KTOPL | CHAR | 4 | T004 | KTOPL | KPL | C_KTOPL | |
WAABW | Maximum exchange rate deviation in percent | WAABW_001 | NUMC | 2 | NUM02 | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
KOKFI | Allocation Indicator | KOKFI | CHAR | 1 | KOKFI | ||||
RCOMP | Company | RCOMP_D | CHAR | 6 | T880 | ALPHA | RCOMP | GCC | |
ADRNR | Address | ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FM01 | FIKRS | FIK | ||
XFMCO | Indicator: Project Cash Management active? | XFMCO | CHAR | 1 | XFELD | ||||
XFMCB | Indicator: Cash budget management active | XFMCB | CHAR | 1 | XFELD | ||||
XFMCA | Activate Update in Funds Management | XFMCA | CHAR | 1 | XFELD | ||||
TXJCD | Jurisdiction for tax calculation - tax jurisdiction code | TXJCD_NSTX | CHAR | 15 | Assigned to domain | TXJCD | |||
FMHRDATE | Funds center can be assigned to an account in HR from | FM_HRDATE | DATS | 8 | DATUM | ||||
BUVAR | Company Code Variant (Screen) | BUVAR | CHAR | 1 | BUVAR | ||||
FDBUK | Cash Management and Forecast Company Code | FDBUK | CHAR | 4 | T001 | BUKRS | |||
XFDIS | Indicator: Cash Management activated? | XFDIS | CHAR | 1 | XFELD | ||||
XVALV | Indicator: Propose current date as value date ? | XVALV | CHAR | 1 | XFELD | ||||
XSKFN | Indicator: Discount base amount is the net value | XSKFN | CHAR | 1 | XFELD | ||||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
XMWSN | Indicator: Base amount for tax is net of discount ? | XMWSN | CHAR | 1 | XFELD | ||||
MREGL | Rules for Copying from the Sample Account for G/L Accounts | MREGL | CHAR | 4 | T004R | MREGL | |||
XGSBE | Indicator: Business area financial statements required? | XGSBE | CHAR | 1 | XFELD | ||||
XGJRV | Indicator: Propose fiscal year ? | XGJRV | CHAR | 1 | XFELD | ||||
XKDFT | Indicator: Post translations for exchange rate differences ? | XKDFT | CHAR | 1 | XFELD | ||||
XPROD | Indicator: Productive company code? | XPROD_001 | CHAR | 1 | XFELD | ||||
XEINK | Indicator: Purchase Account Processing is Active | XEINK | CHAR | 1 | XFELD | ||||
XJVAA | Indicator: JVA Active | JV_ACTIVE | CHAR | 1 | XFELD | ||||
XVVWA | Indicator: Financial Assets Management active | XVVWA | CHAR | 1 | XFELD | ||||
XSLTA | Indicator: No ex.rate difference when clearing in local crcy | XSLTA | CHAR | 1 | XFELD | ||||
XFDMM | Indicator: Updating MM in Cash Mgmt/Forecast activated? | XFDMM | CHAR | 1 | XFELD | ||||
XFDSD | Indicator: Updating SD in Cash Mgmt/Forecast activated? | XFDSD | CHAR | 1 | XFELD | ||||
XEXTB | Indicator: Company code is in another system | XEXTB | CHAR | 1 | XFELD | ||||
EBUKR | Original Key of the Company Code | EBUKR_001 | CHAR | 4 | EBUKR | ||||
KTOP2 | Chart of Accounts According to Country Legislation | KTOP2 | CHAR | 4 | T004 | KTOPL | |||
UMKRS | Sales/Purchases Tax Group | UMKRS | CHAR | 4 | T007F | UMKRS | FI_UMKRS_COLL | ||
BUKRS_GLOB | Name of global company code | BUKRS_GLOB | CHAR | 6 | T001O | BUKRS_GLOB | |||
FSTVA | Field Status Variant | FSTVA | CHAR | 4 | T004V | FSTVA | |||
OPVAR | Posting Period Variant | OPVAR | CHAR | 4 | T010O | OPVAR | |||
XCOVR | Indicator: hedge request active | XCOVR | CHAR | 1 | XFELD | ||||
TXKRS | Foreign Currency Translation for Tax Items | TXKRS | CHAR | 1 | TXKRS | ||||
WFVAR | Workflow variant | WFVAR | CHAR | 4 | VBWF01 | WFVAR | |||
XBBBF | G/L account authorization check in inventory management | XBBBF | CHAR | 1 | XFELD | ||||
XBBBE | G/L account authorization check in PO/scheduling agreement | XBBBE | CHAR | 1 | XFELD | ||||
XBBBA | G/L account authorization check in purchase requisitions | XBBBA | CHAR | 1 | XFELD | ||||
XBBKO | G/L account authorization check in contracts | XBBKO | CHAR | 1 | XFELD | ||||
XSTDT | Indicator: Document date as the basis for tax determination | XSTDT_001 | CHAR | 1 | XFELD | ||||
MWSKV | Input Tax Code for Non-Taxable Transactions | MWSKZ_NSTV | CHAR | 2 | Assigned to domain | MWSKZ | |||
MWSKA | Output Tax Code for Non-Taxable Transactions | MWSKZ_NSTA | CHAR | 2 | Assigned to domain | MWSKZ | |||
IMPDA | Foreign Trade: Import Data Control in MM Purchase Orders | IMPDATEN | CHAR | 1 | IMPDATEN | ||||
XNEGP | Indicator: Negative Postings Permitted | XNEGP_ACT | CHAR | 1 | XFELD | ||||
XKKBI | Indicator: Can credit control area be overwritten? | XKKBI | CHAR | 1 | XFELD | ||||
WT_NEWWT | Indicator: Extended withholding tax active | WT_NEWWT | CHAR | 1 | XFELD | ||||
PP_PDATE | Procedure for Setting the Posting Date | PP_PDATE | CHAR | 1 | PP_PDATE | ||||
INFMT | Inflation Method | J_1AINFME_ | CHAR | 4 | J_1AINFMET | ALPHA | J_1AINFMET | ||
FSTVARE | Funds reservation field status var. | FSTVARE | CHAR | 4 | TREV | FSTVARE | |||
KOPIM | Foreign trade: Import data copying control for GR | KOPIM | CHAR | 1 | KOPIM | ||||
DKWEG | Foreign Trade: Screen ctrl of imp.data f. MM-goods rececipt | DKWEG | CHAR | 1 | DKWEG | ||||
OFFSACCT | Method for offsetting account determination | GOFFSACCT | NUMC | 1 | GPACCT | ||||
BAPOVAR | Additional settings variant for bus.area financial statemnts | BAPOVAR | CHAR | 2 | TGSB_CUS | BAPOVAR | |||
XCOS | Cost of sales accounting status | XCOS | CHAR | 1 | XCOS | ||||
XCESSION | Accounts Receivable Pledging Active | X_CESSION | CHAR | 1 | XFELD | ||||
XSPLT | Enable Amount Split | BSPLT | CHAR | 1 | XFELD | ||||
SURCCM | Surcharge Calculation Method | J_1ISURC | CHAR | 1 | J_1ISURC | ||||
DTPROV | Document Type for Provisions for Taxes on Services Received | J_1IPROV | CHAR | 2 | T003 | BLART | |||
DTAMTC | Document Type for Journal Voucher (Amount Correction) | J_1IAMTC | CHAR | 2 | T003 | BLART | |||
DTTAXC | Document Type for Journal Voucher (Tax Code Correction) | J_1ITAXC | CHAR | 2 | T003 | BLART | |||
DTTDSP | Document Type for Remittance Challans | J_1ITDSTYP | CHAR | 2 | T003 | BLART | |||
DTAXR | Deferred Tax Rule | DTAXR | CHAR | 4 | T007DT | DTAXR | |||
XVATDATE | Tax Reporting Date Active in Documents | XVATDATE | CHAR | 1 | XFELD | ||||
PST_PER_VAR | Manage Variant of Posting Period for Company Code/Ledger | FAGL_POST_PER_VAR | CHAR | 1 | XFELD | ||||
XBBSC | G/L account authorization check in shopping cart | /SRMERP/XBBSC | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
FM_DERIVE_ACC | Activate Account Assignment Derivation in Funds Management | FM_DERIVE_ACC | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table T001 using ABAP code
The following ABAP code Example will allow you to do a basic selection on T001 to SELECT all data from the tableDATA: WA_T001 TYPE T001.
SELECT SINGLE *
FROM T001
INTO CORRESPONDING FIELDS OF WA_T001
WHERE...
How to access SAP table T001
Within an ECC or HANA version of SAP you can also view further information about T001 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects