TXW_S_VBAP SAP (Retrieve VBAP from archive) Table details
Dictionary Type: Table
Description: Retrieve VBAP from archive
Description: Retrieve VBAP from archive
Table field list including key, data, relationships and ABAP select examples
TXW_S_VBAP is a standard SAP Table which is used to store Retrieve VBAP from archive data and is available within R/3 SAP systems depending on the version and release level.
The TXW_S_VBAP table consists of various fields, each holding specific information or linking keys about Retrieve VBAP from archive data available in SAP. These include TXW_VBELN (Sales Document), TXW_POSNR (Sales Document Item), MANDT (Client), VBELN (Sales and Distribution Document Number).. 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: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP TXW_S_VBAP 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 |
| TXW_MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| TXW_VBELN | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
| TXW_POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
| MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
| ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
| PRODH | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| SMENG | Scale quantity in base unit of measure | TXW_SMENG | CHAR | 16 | CHAR16 | ||||
| VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
| NETWR | Net value of the order item in document currency | TXW_NETBTR | CHAR | 16 | CHAR16 | ||||
| VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
| VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | Assigned to domain | POSNR | |||
| VGTYP | Document category of preceding SD document | VBTYP_V | CHAR | 1 | VBTYP | ||||
| BUKRS_VF | Company code to be billed | BUKRS_VF | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
| WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS |
| Key field | Non-key field |
How do I retrieve data from SAP table TXW_S_VBAP using ABAP code
The following ABAP code Example will allow you to do a basic selection on TXW_S_VBAP to SELECT all data from the tableDATA: WA_TXW_S_VBAP TYPE TXW_S_VBAP.
SELECT SINGLE *
FROM TXW_S_VBAP
INTO CORRESPONDING FIELDS OF WA_TXW_S_VBAP
WHERE...
How to access SAP table TXW_S_VBAP
Within an ECC or HANA version of SAP you can also view further information about TXW_S_VBAP 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