T007A SAP (Tax Keys) Table details

Dictionary Type: Table
Description: Tax Keys




ABAP Code to SELECT data from T007A
Related tables to T007A
Access table T007A




Table field list including key, data, relationships and ABAP select examples

T007A is a standard SAP Table which is used to store Tax Keys data and is available within R/3 SAP systems depending on the version and release level.

The T007A table consists of various fields, each holding specific information or linking keys about Tax Keys data available in SAP. These include KALSM (Procedure (Pricing, Output Control, Acct. Det., Costing,...)), MWSKZ (Tax on sales/purchases code), PRUEF (Indicator: Error Message for Invalid Tax Amount ?), MWART (Tax Type).. 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 cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = T007S


SAP T007A 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
MANDTClient MANDTCLNT3T000MANDT
KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_DCHAR6T683KALSM
MWSKZTax on sales/purchases code MWSKZCHAR2MWSKZ
PRUEFIndicator: Error Message for Invalid Tax Amount ? PRUEF_007CHAR1XFELD
MWARTTax Type MWARTCHAR1MWART
XMSTUSingle-Character Indicator CHAR1CHAR1CHAR1
ZMWSKTarget Tax Code (for Deferred Tax) DZMWSKCHAR2T007AMWSKZ
EGRKZEU Code / Code EGRKZCHAR1EGRKZ
XSLTAIndicator: Tax code for sales taxes XSLTA_007ACHAR1XFELD
PROCDSAP internal product code (external interface) PROCD_TTXPCHAR10CHAR10
TXINDTax Category for US Taxes TXIND_007ACHAR1TXIND_007A
TXREL'Tax Relevant' Indicator (Only for External Tax System) TXREL_007ACHAR1TXREL_007A
LSTMLCountry for Tax Return LAND1_STMLCHAR3T005LAND1
J_1BUSAGETax Calculation: Material Usage J_1BTXMMUCHAR1J_1BTXSDU
J_1BISSTax Calculation: Service Without ICMS/IPI J_1BTXMMISCHAR1XFELD
J_1BTAXLW1Tax law: ICMS J_1BTAXLW1CHAR3J_1BATL1ALPHAJ_1BTAXLW1
J_1BTAXLW2Tax law: IPI J_1BTAXLW2CHAR3J_1BATL2ALPHAJ_1BTAXLW2
J_1BTXICEXICMS Stored as 'Exempt' Instead of 'Other Basis' J_1BTXICEXCHAR1XFELD
J_1BTXIPEXIPI Stored as 'Exempt' Instead of 'Other Basis' J_1BTXIPEXCHAR1XFELD
TOLERANCETolerance Percentage Rate for Tax Calculation TAX_TOLERANCEDEC3(1) PRZ21
ZMWSK_ESATarget Tax Code for Deferred EU Acquisition Tax, Output Tax DZMWEACHAR2T007AMWSKZ
ZMWSK_ESETarget Tax Code for Deferred EU Acquisition Tax, Input Tax DZMWEECHAR2T007AMWSKZ
NEWDEFTAXNew Deferred Tax Code: Yes/No NEWDEFTAXCHAR1XFELD
J_1BTAXLW4COFINS Tax Law J_1BTAXLW4CHAR3J_1BATL4AALPHAJ_1BTAXLW4
J_1BTAXLW5PIS Tax Law J_1BTAXLW5CHAR3J_1BATL5ALPHAJ_1BTAXLW5

Key field Non-key field



How do I retrieve data from SAP table T007A using ABAP code

The following ABAP code Example will allow you to do a basic selection on T007A to SELECT all data from the table
DATA: WA_T007A TYPE T007A.

SELECT SINGLE *
FROM T007A
INTO CORRESPONDING FIELDS OF WA_T007A
WHERE...

How to access SAP table T007A

Within an ECC or HANA version of SAP you can also view further information about T007A and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!