WRF_WTAD_AD_WL SAP (Additionals: Temporary Storage of Work Data) Table details
Dictionary Type: Table
Description: Additionals: Temporary Storage of Work Data
Description: Additionals: Temporary Storage of Work Data
ABAP Code to SELECT data from WRF_WTAD_AD_WL
Related tables to WRF_WTAD_AD_WL
Access table WRF_WTAD_AD_WL
Related tables to WRF_WTAD_AD_WL
Access table WRF_WTAD_AD_WL
Table field list including key, data, relationships and ABAP select examples
WRF_WTAD_AD_WL is a standard SAP Table which is used to store Additionals: Temporary Storage of Work Data data and is available within R/3 SAP systems depending on the version and release level.
The WRF_WTAD_AD_WL table consists of various fields, each holding specific information or linking keys about Additionals: Temporary Storage of Work Data data available in SAP. These include USERID (User Name), GUID (Unique Key), MATNR (Material Number), MAKTX (Material Description (Short Text)).. 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 (Deep)
SAP WRF_WTAD_AD_WL 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 | Assigned to domain | MANDT | |||
USERID | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
GUID | Unique Key | 0 | |||||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
ADDIBELNR | Document number for additional | ADDI_BELNR | CHAR | 10 | ALPHA | ADDI_BELNR | |||
ADDIPOSNR | Item number of an additional | ADDI_POSNR | NUMC | 6 | NUM6 | ||||
ADDIMAT | Material number for additional | ADDI_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
DATECR | Date of Additionals Document Creation | WRF_ADDI_DATE1 | DATS | 8 | DATS | ||||
ADDIIDOCD | Current Condition Date | WRF_ADDI_IDOCD | DATS | 8 | DATS | ||||
ADDIFM | Procedure for additionals | ADDI_FM | CHAR | 4 | Assigned to domain | ADDI_FM | |||
ADDILIFNR | Additionals vendor | ADDI_LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
ADDIKSCHL | Additionals: Message type for deliveries | ADDI_KSCHL | CHAR | 4 | CHAR4 | ||||
ADDIEBELN | Additionals: Document number for purchasing document | ADDI_EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
KSCHLIDOC | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
KBETRIDOC | Old Condition Value | WRF_OLD_KBETR | CURR | 11(2) | WERTV6 | ||||
WAERSIDOC | Old Currency Key | WRF_OLD_WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
NEWKBETR | New Condition Value | WRF_NEW_KBETR | CURR | 11(2) | WERTV6 | ||||
NEWWAERS | New Currency Key | WRF_NEW_WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
ADDIRDID | Purchase Order Number | WRF_ADDI_RDID | CHAR | 10 | CHAR10 | BES | |||
GUID_ALV | Unique Key | 0 | |||||||
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 | ||||
CHANGE_PRICE_DAT | Flag: Date on Which Price Is Determined Has Changed | WRF_ADDI_FLAG | CHAR | 1 | FLAG | ||||
ADDIMAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
ADDISTUNR | Additionals: step number | ADDI_STUNR | NUMC | 4 | NUM4 | ||||
LFDNR | Key for transaction data for additionals | ADDI_WTKEY | NUMC | 4 | ADDI_WTKEY | ||||
CHECKSUM | Hash Value (160 Bits) | HASH160 | CHAR | 40 | |||||
CONDCHECKSUMIDOC | Hash Value (160 Bits) | HASH160 | CHAR | 40 | |||||
ADDIVKME | Sales unit of the material | ADDI_VKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
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 | ||
ADDIMATKL | Material group for an additional | ADDI_MATKL | CHAR | 9 | Assigned to domain | MATKL | |||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
CHANGED_BY | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM |
Key field | Non-key field |
How do I retrieve data from SAP table WRF_WTAD_AD_WL using ABAP code
The following ABAP code Example will allow you to do a basic selection on WRF_WTAD_AD_WL to SELECT all data from the tableDATA: WA_WRF_WTAD_AD_WL TYPE WRF_WTAD_AD_WL.
SELECT SINGLE *
FROM WRF_WTAD_AD_WL
INTO CORRESPONDING FIELDS OF WA_WRF_WTAD_AD_WL
WHERE...
How to access SAP table WRF_WTAD_AD_WL
Within an ECC or HANA version of SAP you can also view further information about WRF_WTAD_AD_WL 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