WTADAB SAP (Additionals: Documents) Table details
Dictionary Type: Table
Description: Additionals: Documents
Description: Additionals: Documents
Table field list including key, data, relationships and ABAP select examples
WTADAB is a standard SAP Table which is used to store Additionals: Documents data and is available within R/3 SAP systems depending on the version and release level.
The WTADAB table consists of various fields, each holding specific information or linking keys about Additionals: Documents data available in SAP. These include ADDIBELNR (Document number for additional), ADDIPOSNR (Item number of an additional), ADDISTUNR (Additionals: step number), LFDNR (Key for transaction data for additionals).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP WTADAB 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 | |||
ADDIBELNR | Document number for additional | ADDI_BELNR | CHAR | 10 | ALPHA | ADDI_BELNR | |||
ADDIPOSNR | Item number of an additional | ADDI_POSNR | NUMC | 6 | NUM6 | ||||
ADDISTUNR | Additionals: step number | ADDI_STUNR | NUMC | 4 | NUM4 | ||||
LFDNR | Key for transaction data for additionals | ADDI_WTKEY | NUMC | 4 | ADDI_WTKEY | ||||
ADDIKEY | Key for transaction data for additionals | ADDI_WTKEY | NUMC | 4 | ADDI_WTKEY | ||||
HANDLE | Globally unique identifier (linked to time segment, etc) | TSEGGUID | CHAR | 22 | SYSUUID_22 | ||||
ADDIRDID | Additionals: Header document no. of the reference document | ADDI_RDID | CHAR | 10 | CHAR10 | ||||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MATNRMENGE | Quantity of material used in the reference document | ADDI_MATQU | QUAN | 13(3) | MENG13 | ||||
MATNRMEINS | Additionals: Unit of measurement from reference document | ADDI_UNITR | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ADDICLINT | Internal class number for assigning additionals | ADDI_CLINT | NUMC | 10 | KLAH | CLINT | |||
ADDIMAT | Material number for additional | ADDI_MATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
ADDIVKME | Sales unit of the material | ADDI_VKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
ADDIFM | Procedure for additionals | ADDI_FM | CHAR | 4 | TWTFM | ADDI_FM | |||
ADDIINVOC | Bill-to party for additional ordered from an external source | ADDI_INVOC | CHAR | 1 | ADDI_INVOC | ||||
ADDIPRASS | Usage indicator for additionals in promotions | ADDI_PRASS | CHAR | 1 | ADDI_PRASS | ||||
ADDICALC | Price calculation control | ADDI_CALC | CHAR | 1 | ADDI_CALC | ||||
ADDIMATCU | External description of the additional | ADDI_MATCU | CHAR | 35 | IDNEX | ||||
ADDIFMCU | Customer procedure for additionals | ADDI_FMCU | CHAR | 4 | Assigned to domain | ADDI_FM | |||
ADDIAPPL | Application for triggering follow-up actions for additionals | ADDI_APPL | CHAR | 2 | ADDI_APPL | ||||
ADDIEVENT | Event that triggers follow-up actions for additionals | ADDI_EVENT | CHAR | 1 | ADDI_EVENT | ||||
ADDISTATUS | Status of an additional | ADDI_STATUS | INT4 | 10 | ADDI_STATUS | ||||
ADDIOPER | Follow-up action for procedure for additionals | ADDI_OPER | CHAR | 2 | TWT_ACTION | CHAR2 | |||
ADDIDATE | Execution date for follow-up action | ADDI_DATE | DATS | 8 | DATS | ||||
ADDIDELID | Additionals: Delivery date | ADDI_DELID | DATS | 8 | DATS | ||||
ADDIIDOCD | Additionals IDoc: Usage date for data | ADDI_IDOCD | DATS | 8 | DATS | ||||
ADDIIDOCN | IDoc number | EDI_DOCNUM | NUMC | 16 | EDI_DOCNUM | DCN | |||
ADDIEBELN | Additionals: Document number for purchasing document | ADDI_EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
ADDIEBELP | Additionals: Item number of purchasing document | ADDI_EBELP | NUMC | 5 | Assigned to domain | EBELP | |||
ADDIKSCHL | Additionals: Message type for deliveries | ADDI_KSCHL | CHAR | 4 | CHAR4 | ||||
ADDIWERKS | Additionals: Plant to which the reference document belongs | ADDI_WERKS | CHAR | 4 | Assigned to domain | WERKS | |||
ADDIKUNNR | Additionals: Customer to whom the reference document belongs | ADDI_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
ADDIMENGE | Quantity of the additional used | ADDI_ORDQU | QUAN | 13(3) | MENG13 | ||||
ADDILIFNR | Additionals vendor | ADDI_LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
ADDIFRMCUST | SLS-related data | FRM_SERVICE_DATA | CHAR | 35 | |||||
ADDISIDOC | Creation status for additionals IDoc | ADDIS_IDOC | CHAR | 1 | ADDIS_1 | ||||
ADDISIDOCFB | Additionals: IDoc status in the sub-system | ADDIS_IDOCFB | CHAR | 1 | ADDIS_2 | ||||
ADDISSUPP | Status for determination of additionals vendor | ADDIS_SUPP | CHAR | 1 | ADDIS_SUPP | ||||
ADDISPOOK | Status of purchase order for additionals | ADDIS_POOK | CHAR | 1 | ADDIS_POOK | ||||
ADDISBAPI | Status of request for additionals IDoc via BAPI | ADDIS_BAPI | CHAR | 1 | ADDIS_1 | ||||
ADDISORDP | Status of inclusion of additionals data in PO printout | ADDIS_ORDP | CHAR | 1 | ADDIS_1 | ||||
ADDISWEKZ | Status for goods receipt for higher-level material | ADDIS_WEKZ | CHAR | 1 | ADDIS_2 | ||||
ADDISDEL | Deletion status of the reference document item | ADDIS_DEL | CHAR | 1 | ADDIS_1 | ||||
ADDISFRMCUST | Status of the SLS service | ADDIS_FRMCUST | CHAR | 1 | ADDIS_1 | ||||
USERNAME | Additionals: User who created data record | ADDI_USER1 | CHAR | 12 | Assigned to domain | XUBNAME | |||
DATECR | Date on which the data record was inserted | ADDI_DATE1 | DATS | 8 | DATS | ||||
TIMECR | Time at which the data record was inserted | ADDI_TIME1 | TIMS | 6 | TIME | ||||
USNAMMOD | Additionals: User who has changed data record | ADDI_USER2 | CHAR | 12 | Assigned to domain | XUBNAME | |||
DATEMOD | Date on which the data record was last changed | ADDI_DATE2 | DATS | 8 | DATS | ||||
TIMEMOD | Time at which data record was last changed | ADDI_TIME2 | TIMS | 6 | TIME | ||||
.INCLU--AP | 0 | ||||||||
UEBPO | Higher-Level Item in Purchasing Documents | UEBPO | NUMC | 5 | Assigned to domain | EBELP | |||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
KSCHLIDOC | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
KBETRIDOC | Rate (condition amount or percentage) | KBETR | CURR | 11(2) | WERTV6 | ||||
WAERSIDOC | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CONDCHECKSUMIDOC | Hash Value (160 Bits) | HASH160 | CHAR | 40 | |||||
AMF_N_FLAG | Item Processing via Function NEW | WRF_AMF_N_FLAG | CHAR | 1 | XFELD | ||||
AMF_A_FLAG | Item Processing via Function ADD | WRF_AMF_A_FLAG | CHAR | 1 | XFELD | ||||
AMF_C_FLAG | Item Processing via Function CHANGE | WRF_AMF_C_FLAG | CHAR | 1 | XFELD | ||||
AMF_S_FLAG | Item Processing via Function SUBSTITUTE | WRF_AMF_S_FLAG | CHAR | 1 | XFELD | ||||
UPTYP | Subitem Category, Purchasing Document | UPTYP | CHAR | 1 | Assigned to domain | UPTYP | |||
CREATE_IDOC_DAT | Date of IDoc Generation | WRF_IDOC_CREATE_DAT | DATS | 8 | DATS | ||||
IDOC_PRICE_DAT | Condition Date of IDoc | WRF_IDOC_PRICE_DAT | DATS | 8 | DATS |
Key field | Non-key field |
How do I retrieve data from SAP table WTADAB using ABAP code
The following ABAP code Example will allow you to do a basic selection on WTADAB to SELECT all data from the tableDATA: WA_WTADAB TYPE WTADAB.
SELECT SINGLE *
FROM WTADAB
INTO CORRESPONDING FIELDS OF WA_WTADAB
WHERE...
How to access SAP table WTADAB
Within an ECC or HANA version of SAP you can also view further information about WTADAB 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