SAP A442 Full Rate Excise Duty Company/Plant/Tax Group Table

Overview

A442 is a standard SAP S/4HANA table that stores Full Rate Excise Duty Company/Plant/Tax Group data. There are total 9 fields in the A442 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table A442 belongs to Tariffs, Duties and Permits (IS-OIL-DS-TDP) module and is located in the package TDP Tariffs, Duties and Permits (OIH).

In addition, following links provide an overview of foreign key relationships, if any, that link A442 to other SAP tables and standard CDS views available based on A442 table in S/4HANA 2020.

Techincal Settings of A442

Below are technical details of the table A442

  • Buffering switched on
  • Full table is passed to buffer
  • Storage type is Column Store

List of A442 Fields

The following table gives you an overview of the fields available in A442

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KAPPLApplicationKAPPLT681ACHAR2
KSCHLCondition typeKSCHAT685CHAR4
BUKRSCompany CodeBUKRST001CHAR4
WERKSPlantWERKS_DT001WCHAR4
OITAXGRPExcise Duty GroupOIH_TAXGRPOIH2CHAR2
DATBIValidity end date of the condition recordKODATBIDATS8
DATABValidity start date of the condition recordKODATABDATS8
KNUMHNumber of the Condition RecordKNUMHCHAR10

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for A442

Table NameFieldCardinalityCheck Table
A442BUKRS:T001
A442KAPPL:T681A
A442KSCHL:T685
A442MANDT:T000
A442OITAXGRP:OIH2
A442WERKS:T001W

Other References