TXW_S_VBRP SAP (Retrieve VBRP from archive) Table details
Dictionary Type: Table
Description: Retrieve VBRP from archive
Description: Retrieve VBRP from archive
Table field list including key, data, relationships and ABAP select examples
TXW_S_VBRP is a standard SAP Table which is used to store Retrieve VBRP from archive data and is available within R/3 SAP systems depending on the version and release level.
The TXW_S_VBRP table consists of various fields, each holding specific information or linking keys about Retrieve VBRP from archive data available in SAP. These include TXW_VBELN (Billing Document), TXW_POSNR (Billing item), MANDT (Client), BUKRS (Company Code).. 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_VBRP 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 | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
| TXW_POSNR | Billing item | POSNR_VF | NUMC | 6 | Assigned to domain | POSNR | |||
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
| VBELN | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
| POSNR | Billing item | POSNR_VF | NUMC | 6 | Assigned to domain | POSNR | |||
| PSTYV | Sales document item category | PSTYV | CHAR | 4 | Assigned to domain | PSTYV | |||
| 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 | ||||
| AUBEL | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
| AUPOS | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
| AUTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
| ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
| FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
| FKIMG | Actual invoiced quantity | TXW_FKIMG | CHAR | 16 | CHAR16 | ||||
| KOWRR | Statistical values | KOWRR | CHAR | 1 | KOWRR | ||||
| LMENG | Required quantity for mat.management in stockkeeping units | TXW_LMENG | CHAR | 16 | CHAR16 | ||||
| MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
| MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| MWSBP | Tax amount in document currency | TXW_MWSBP | CHAR | 16 | CHAR16 | ||||
| NETWR | Net value of the billing item in document currency | TXW_NETWRF | CHAR | 17 | CHAR17 | ||||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| VRKME | Sales Unit of Measure | TXW_VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
| KZWI1 | Subtotal 1 from pricing procedure for condition | TXW_KZWI1 | CHAR | 20 | CHAR20 | ||||
| KZWI2 | Subtotal 2 from pricing procedure for condition | TXW_KZWI2 | CHAR | 20 | CHAR20 | ||||
| KZWI3 | Subtotal 3 from pricing procedure for condition | TXW_KZWI3 | CHAR | 20 | CHAR20 | ||||
| KZWI4 | Subtotal 4 from pricing procedure for condition | TXW_KZWI4 | CHAR | 20 | CHAR20 | ||||
| KZWI5 | Subtotal 5 from pricing procedure for condition | TXW_KZWI5 | CHAR | 20 | CHAR20 | ||||
| KZWI6 | Subtotal 6 from pricing procedure for condition | TXW_KZWI6 | CHAR | 20 | CHAR20 | ||||
| PRODH | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
| TAXM1 | Tax classification material | TAXM1 | CHAR | 1 | Assigned to domain | TAXKM | |||
| TAXM2 | Tax classification 2 for material | TAXM2 | CHAR | 1 | Assigned to domain | TAXKM | |||
| TAXM3 | Tax classification 3 for material | TAXM3 | CHAR | 1 | Assigned to domain | TAXKM | |||
| TAXM4 | Tax Classification 4 Material | TAXM4 | CHAR | 1 | Assigned to domain | TAXKM | |||
| TAXM5 | Tax classification 5 for material | TAXM5 | CHAR | 1 | Assigned to domain | TAXKM | |||
| TAXM6 | Tax classification 6 for material | TAXM6 | CHAR | 1 | Assigned to domain | TAXKM | |||
| TAXM7 | Tax classification 7 for material | TAXM7 | CHAR | 1 | Assigned to domain | TAXKM | |||
| TAXM8 | Tax Classification 8 Material | TAXM8 | CHAR | 1 | Assigned to domain | TAXKM | |||
| TAXM9 | Tax Classification 9 Material | TAXM9 | CHAR | 1 | Assigned to domain | TAXKM | |||
| LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ |
| Key field | Non-key field |
How do I retrieve data from SAP table TXW_S_VBRP using ABAP code
The following ABAP code Example will allow you to do a basic selection on TXW_S_VBRP to SELECT all data from the tableDATA: WA_TXW_S_VBRP TYPE TXW_S_VBRP.
SELECT SINGLE *
FROM TXW_S_VBRP
INTO CORRESPONDING FIELDS OF WA_TXW_S_VBRP
WHERE...
How to access SAP table TXW_S_VBRP
Within an ECC or HANA version of SAP you can also view further information about TXW_S_VBRP 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