SAP WTADAB Additionals: Documents Table data and field list

WTADAB is a standard SAP Table which is used to store Additionals: Documents data in SAP systems, such as SAP R/3, S/4HANA, 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. .

WTADAB table Technical Details:

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the WTADAB table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ADDIBELNRDocument number for additional ADDI_BELNRCHAR10ALPHAADDI_BELNR
ADDIPOSNRItem number of an additional ADDI_POSNRNUMC6NUM6
ADDISTUNRAdditionals: step number ADDI_STUNRNUMC4NUM4
LFDNRKey for transaction data for additionals ADDI_WTKEYNUMC4ADDI_WTKEY
ADDIKEYKey for transaction data for additionals ADDI_WTKEYNUMC4ADDI_WTKEY
HANDLEGlobally unique identifier (linked to time segment, etc) TSEGGUIDCHAR22SYSUUID_22
ADDIRDIDAdditionals: Header document no. of the reference document ADDI_RDIDCHAR10CHAR10
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MATNRMENGEQuantity of material used in the reference document ADDI_MATQUQUAN13(3) MENG13
MATNRMEINSAdditionals: Unit of measurement from reference document ADDI_UNITRUNIT3Assigned to domainCUNITMEINS
ADDICLINTInternal class number for assigning additionals ADDI_CLINTNUMC10KLAHCLINT
ADDIMATMaterial number for additional ADDI_MATNRCHAR18MARAMATN1MATNR
ADDIVKMESales unit of the material ADDI_VKMEUNIT3T006CUNITMEINS
ADDIFMProcedure for additionals ADDI_FMCHAR4TWTFMADDI_FM
ADDIINVOCBill-to party for additional ordered from an external source ADDI_INVOCCHAR1ADDI_INVOC
ADDIPRASSUsage indicator for additionals in promotions ADDI_PRASSCHAR1ADDI_PRASS
ADDICALCPrice calculation control ADDI_CALCCHAR1ADDI_CALC
ADDIMATCUExternal description of the additional ADDI_MATCUCHAR35IDNEX
ADDIFMCUCustomer procedure for additionals ADDI_FMCUCHAR4Assigned to domainADDI_FM
ADDIAPPLApplication for triggering follow-up actions for additionals ADDI_APPLCHAR2ADDI_APPL
ADDIEVENTEvent that triggers follow-up actions for additionals ADDI_EVENTCHAR1ADDI_EVENT
ADDISTATUSStatus of an additional ADDI_STATUSINT410ADDI_STATUS
ADDIOPERFollow-up action for procedure for additionals ADDI_OPERCHAR2TWT_ACTIONCHAR2
ADDIDATEExecution date for follow-up action ADDI_DATEDATS8DATS
ADDIDELIDAdditionals: Delivery date ADDI_DELIDDATS8DATS
ADDIIDOCDAdditionals IDoc: Usage date for data ADDI_IDOCDDATS8DATS
ADDIIDOCNIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
ADDIEBELNAdditionals: Document number for purchasing document ADDI_EBELNCHAR10Assigned to domainALPHAEBELN
ADDIEBELPAdditionals: Item number of purchasing document ADDI_EBELPNUMC5Assigned to domainEBELP
ADDIKSCHLAdditionals: Message type for deliveries ADDI_KSCHLCHAR4CHAR4
ADDIWERKSAdditionals: Plant to which the reference document belongs ADDI_WERKSCHAR4Assigned to domainWERKS
ADDIKUNNRAdditionals: Customer to whom the reference document belongs ADDI_KUNNRCHAR10Assigned to domainALPHAKUNNR
ADDIMENGEQuantity of the additional used ADDI_ORDQUQUAN13(3) MENG13
ADDILIFNRAdditionals vendor ADDI_LIFNRCHAR10Assigned to domainALPHALIFNR
ADDIFRMCUSTSLS-related data FRM_SERVICE_DATACHAR35
ADDISIDOCCreation status for additionals IDoc ADDIS_IDOCCHAR1ADDIS_1
ADDISIDOCFBAdditionals: IDoc status in the sub-system ADDIS_IDOCFBCHAR1ADDIS_2
ADDISSUPPStatus for determination of additionals vendor ADDIS_SUPPCHAR1ADDIS_SUPP
ADDISPOOKStatus of purchase order for additionals ADDIS_POOKCHAR1ADDIS_POOK
ADDISBAPIStatus of request for additionals IDoc via BAPI ADDIS_BAPICHAR1ADDIS_1
ADDISORDPStatus of inclusion of additionals data in PO printout ADDIS_ORDPCHAR1ADDIS_1
ADDISWEKZStatus for goods receipt for higher-level material ADDIS_WEKZCHAR1ADDIS_2
ADDISDELDeletion status of the reference document item ADDIS_DELCHAR1ADDIS_1
ADDISFRMCUSTStatus of the SLS service ADDIS_FRMCUSTCHAR1ADDIS_1
USERNAMEAdditionals: User who created data record ADDI_USER1CHAR12Assigned to domainXUBNAME
DATECRDate on which the data record was inserted ADDI_DATE1DATS8DATS
TIMECRTime at which the data record was inserted ADDI_TIME1TIMS6TIME
USNAMMODAdditionals: User who has changed data record ADDI_USER2CHAR12Assigned to domainXUBNAME
DATEMODDate on which the data record was last changed ADDI_DATE2DATS8DATS
TIMEMODTime at which data record was last changed ADDI_TIME2TIMS6TIME
.INCLU--AP 0
UEBPOHigher-Level Item in Purchasing Documents UEBPONUMC5Assigned to domainEBELP
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
KSCHLIDOCCondition type KSCHACHAR4Assigned to domainKSCHLVKS
KBETRIDOCRate (condition amount or percentage) KBETRCURR11(2) WERTV6
WAERSIDOCCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
CONDCHECKSUMIDOCHash Value (160 Bits) HASH160CHAR40
AMF_N_FLAGItem Processing via Function NEW WRF_AMF_N_FLAGCHAR1XFELD
AMF_A_FLAGItem Processing via Function ADD WRF_AMF_A_FLAGCHAR1XFELD
AMF_C_FLAGItem Processing via Function CHANGE WRF_AMF_C_FLAGCHAR1XFELD
AMF_S_FLAGItem Processing via Function SUBSTITUTE WRF_AMF_S_FLAGCHAR1XFELD
UPTYPSubitem Category, Purchasing Document UPTYPCHAR1Assigned to domainUPTYP
CREATE_IDOC_DATDate of IDoc Generation WRF_IDOC_CREATE_DATDATS8DATS
IDOC_PRICE_DATCondition Date of IDoc WRF_IDOC_PRICE_DATDATS8DATS

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 table
DATA: 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 as

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