T007A

Transparent Table Customizing Table
28 Fields 10 CDS Views

Tax Keys

T007A is an SAP database table in S/4HANA. Tax Keys. It contains 28 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
fac_ad_cds_t005 view left_outer Search Help CDS View for T005
FAC_AD_CDS_T007a view from Search Help CDS View for T007A
Finsv_Drf_Glaccount view left_outer General Ledger Account for Data Replication
I_JVATaxCodeCompanyCode view_entity inner BASIC Tax Code for Company Code
I_RELocalTaxMap view inner BASIC Local Tax Group
I_TaxCode view from BASIC Tax Code
P_TaxCategory_Union view from BASIC
P_TaxCode view from BASIC
SHSM_MMIV_TAX_CODE_NO_BUK view inner Selection method for VH ODATA_MMIV_TAX_CODE_NO_BUK
SHSM_MMIV_TAXCODE_SELECTION2 view from Second Level Selection of Tax Codes

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kalsm KALSM_D Procedure
KEY mwskz MWSKZ Tax Code
pruef PRUEF_007 Deviation Error
mwart MWART Tax Type
xmstu CHAR1 Single-Character Flag
zmwsk DZMWSK Target Tax Code
egrkz EGRKZ EU Code/Code
xslta XSLTA_007A Indicator: Tax Code for Sales Taxes
procd PROCD_TTXP Product Code
txind TXIND_007A Tax Category
txrel TXREL_007A Tax-Relevant
lstml LAND1_STML Reporting C/R
j_1busage J_1BTXMMU Usage
j_1biss J_1BTXMMIS Serv. w/o ICMS/IPI
j_1btaxlw1 J_1BTAXLW1 ICMS Law
j_1btaxlw2 J_1BTAXLW2 IPI Law
j_1btxicex J_1BTXICEX ICMS-exempt
j_1btxipex J_1BTXIPEX IPI-exempt
tolerance TAX_TOLERANCE Tol.Per.Rate
zmwsk_esa DZMWEA TgtTxCd OutpTax
zmwsk_ese DZMWEE TgtTxCd Inp.Tax
newdeftax NEWDEFTAX New Def. TaxCde
j_1btaxlw4 J_1BTAXLW4 COFINS Law
j_1btaxlw5 J_1BTAXLW5 PIS Law
xinact XINACT Inactive
mossc MOSSC OSS C/R
oss_classification FOT_OSS_CLASSIFICATION OSS Class.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Tax Keys
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T007A (
    MANDT,               -- Client [MANDT]
    KALSM,               -- Procedure [KALSM_D]
    MWSKZ,               -- Tax Code [MWSKZ]
    PRUEF,               -- Deviation Error [PRUEF_007]
    MWART,               -- Tax Type [MWART]
    XMSTU,               -- Single-Character Flag [CHAR1]
    ZMWSK,               -- Target Tax Code [DZMWSK]
    EGRKZ,               -- EU Code/Code [EGRKZ]
    XSLTA,               -- Indicator: Tax Code for Sales Taxes [XSLTA_007A]
    PROCD,               -- Product Code [PROCD_TTXP]
    TXIND,               -- Tax Category [TXIND_007A]
    TXREL,               -- Tax-Relevant [TXREL_007A]
    LSTML,               -- Reporting C/R [LAND1_STML]
    J_1BUSAGE,           -- Usage [J_1BTXMMU]
    J_1BISS,             -- Serv. w/o ICMS/IPI [J_1BTXMMIS]
    J_1BTAXLW1,          -- ICMS Law [J_1BTAXLW1]
    J_1BTAXLW2,          -- IPI Law [J_1BTAXLW2]
    J_1BTXICEX,          -- ICMS-exempt [J_1BTXICEX]
    J_1BTXIPEX,          -- IPI-exempt [J_1BTXIPEX]
    TOLERANCE,           -- Tol.Per.Rate [TAX_TOLERANCE]
    ZMWSK_ESA,           -- TgtTxCd OutpTax [DZMWEA]
    ZMWSK_ESE,           -- TgtTxCd Inp.Tax [DZMWEE]
    NEWDEFTAX,           -- New Def. TaxCde [NEWDEFTAX]
    J_1BTAXLW4,          -- COFINS Law [J_1BTAXLW4]
    J_1BTAXLW5,          -- PIS Law [J_1BTAXLW5]
    XINACT,              -- Inactive [XINACT]
    MOSSC,               -- OSS C/R [MOSSC]
    OSS_CLASSIFICATION,  -- OSS Class. [FOT_OSS_CLASSIFICATION]
    PRIMARY KEY (MANDT, KALSM, MWSKZ)
);

Learn More