SAP WTADAB Additionals: Documents Table
Overview
WTADAB is a standard SAP S/4HANA table that stores Additionals: Documents data. There are total 63 fields in the WTADAB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WTADAB belongs to Additionals Management (LO-RFM-ADM) module and is located in the package IS-R: Additionals (WTAD).
In addition, following links provide an overview of foreign key relationships, if any, that link WTADAB to other SAP tables and standard CDS views available based on WTADAB table in S/4HANA 2020.
Techincal Settings of WTADAB
Below are technical details of the table WTADAB
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WTADAB Fields
The following table gives you an overview of the fields available in WTADAB
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| ADDIBELNR | Document number for additional | ADDI_BELNR | CHAR | 10 | |
| ADDIPOSNR | Item number of an additional | ADDI_POSNR | NUMC | 6 | |
| ADDISTUNR | Additionals: step number | ADDI_STUNR | NUMC | 4 | |
| LFDNR | Key for transaction data for additionals | ADDI_WTKEY | NUMC | 4 | |
| ADDIKEY | Key for transaction data for additionals | ADDI_WTKEY | NUMC | 4 | |
| HANDLE | Globally unique identifier (linked to time segment etc) | TSEGGUID | CHAR | 22 | |
| ADDIRDID | Additionals: Header document no. of the reference document | ADDI_RDID | CHAR | 10 | |
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| MATNRMENGE | Quantity of material used in the reference document | ADDI_MATQU | QUAN | 13 | |
| MATNRMEINS | Additionals: Unit of measurement from reference document | ADDI_UNITR | * | UNIT | 3 |
| ADDICLINT | Internal class number for assigning additionals | ADDI_CLINT | KLAH | NUMC | 10 |
| ADDIMAT | Material number for additional | ADDI_MATNR | MARA | CHAR | 40 |
| ADDIVKME | Sales unit of the material | ADDI_VKME | T006 | UNIT | 3 |
| ADDIFM | Procedure for additionals | ADDI_FM | TWTFM | CHAR | 4 |
| ADDIINVOC | Bill-to party for additional ordered from an external source | ADDI_INVOC | CHAR | 1 | |
| ADDIPRASS | Usage indicator for additionals in promotions | ADDI_PRASS | CHAR | 1 | |
| ADDICALC | Price calculation control | ADDI_CALC | CHAR | 1 | |
| ADDIMATCU | External description of the additional | ADDI_MATCU | CHAR | 35 | |
| ADDIFMCU | Customer procedure for additionals | ADDI_FMCU | * | CHAR | 4 |
| ADDIAPPL | Application for triggering follow-up actions for additionals | ADDI_APPL | CHAR | 2 | |
| ADDIEVENT | Event that triggers follow-up actions for additionals | ADDI_EVENT | CHAR | 1 | |
| ADDISTATUS | Status of an additional | ADDI_STATUS | INT4 | 10 | |
| ADDIOPER | Follow-up action for procedure for additionals | ADDI_OPER | TWT_ACTION | CHAR | 2 |
| ADDIDATE | Execution date for follow-up action | ADDI_DATE | DATS | 8 | |
| ADDIDELID | Additionals: Delivery date | ADDI_DELID | DATS | 8 | |
| ADDIIDOCD | Additionals IDoc: Usage date for data | ADDI_IDOCD | DATS | 8 | |
| ADDIIDOCN | IDoc number | EDI_DOCNUM | NUMC | 16 | |
| ADDIEBELN | Additionals: Document number for purchasing document | ADDI_EBELN | * | CHAR | 10 |
| ADDIEBELP | Additionals: Item number of purchasing document | ADDI_EBELP | * | NUMC | 5 |
| ADDIKSCHL | Additionals: Message type for deliveries | ADDI_KSCHL | CHAR | 4 | |
| ADDIWERKS | Additionals: Plant to which the reference document belongs | ADDI_WERKS | * | CHAR | 4 |
| ADDIKUNNR | Additionals: Customer to whom the reference document belongs | ADDI_KUNNR | * | CHAR | 10 |
| ADDIMENGE | Quantity of the additional used | ADDI_ORDQU | QUAN | 13 | |
| ADDILIFNR | Additionals Supplier | ADDI_LIFNR | * | CHAR | 10 |
| ADDISIDOC | Creation status for additionals IDoc | ADDIS_IDOC | CHAR | 1 | |
| ADDISIDOCFB | Additionals: IDoc status in the sub-system | ADDIS_IDOCFB | CHAR | 1 | |
| ADDISSUPP | Status for Determination of Additionals Supplier | ADDIS_SUPP | CHAR | 1 | |
| ADDISPOOK | Status of purchase order for additionals | ADDIS_POOK | CHAR | 1 | |
| ADDISBAPI | Status of request for additionals IDoc via BAPI | ADDIS_BAPI | CHAR | 1 | |
| ADDISORDP | Status of inclusion of additionals data in PO printout | ADDIS_ORDP | CHAR | 1 | |
| ADDISWEKZ | Status for goods receipt for higher-level material | ADDIS_WEKZ | CHAR | 1 | |
| ADDISDEL | Deletion status of the reference document item | ADDIS_DEL | CHAR | 1 | |
| ADDISFRMCUST | Status of the SLS service | ADDIS_FRMCUST | CHAR | 1 | |
| USERNAME | Additionals: User who created data record | ADDI_USER1 | * | CHAR | 12 |
| DATECR | Date on which the data record was inserted | ADDI_DATE1 | DATS | 8 | |
| TIMECR | Time at which the data record was inserted | ADDI_TIME1 | TIMS | 6 | |
| USNAMMOD | Additionals: User who has changed data record | ADDI_USER2 | * | CHAR | 12 |
| DATEMOD | Date on which the data record was last changed | ADDI_DATE2 | DATS | 8 | |
| TIMEMOD | Time at which data record was last changed | ADDI_TIME2 | TIMS | 6 | |
| UEBPO | Higher-Level Item in Purchasing Documents | UEBPO | * | NUMC | 5 |
| ATTYP | Material Category | ATTYP | CHAR | 2 | |
| KSCHLIDOC | Condition type | KSCHA | * | CHAR | 4 |
| KBETRIDOC | Condition Amount or Percentage | KBETR | CURR | 11 | |
| WAERSIDOC | Currency Key | WAERS | * | CUKY | 5 |
| AMF_N_FLAG | Item Processing via Function NEW | WRF_AMF_N_FLAG | CHAR | 1 | |
| AMF_A_FLAG | Item Processing via Function ADD | WRF_AMF_A_FLAG | CHAR | 1 | |
| AMF_C_FLAG | Item Processing via Function CHANGE | WRF_AMF_C_FLAG | CHAR | 1 | |
| AMF_S_FLAG | Item Processing via Function SUBSTITUTE | WRF_AMF_S_FLAG | CHAR | 1 | |
| UPTYP | Subitem Category Purchasing Document | UPTYP | * | CHAR | 1 |
| CREATE_IDOC_DAT | Date of IDoc Generation | WRF_IDOC_CREATE_DAT | DATS | 8 | |
| IDOC_PRICE_DAT | Condition Date of IDoc | WRF_IDOC_PRICE_DAT | DATS | 8 |
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 WTADAB
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WTADAB | ADDICLINT | C: CN | KLAH |
| WTADAB | ADDIFM | 1: CN | TWTFM |
| WTADAB | ADDIMAT | 1: CN | MARA |
| WTADAB | ADDIOPER | 1: CN | TWT_ACTION |
| WTADAB | ADDIVKME | 1: CN | T006 |
| WTADAB | MANDT | 1: CN | T000 |
| WTADAB | MATNR | 1: CN | MARA |