TXW_S_VBRK SAP (Retrieve VBRK from archive) Table details
Dictionary Type: Table
Description: Retrieve VBRK from archive
Description: Retrieve VBRK from archive
Table field list including key, data, relationships and ABAP select examples
TXW_S_VBRK is a standard SAP Table which is used to store Retrieve VBRK from archive data and is available within R/3 SAP systems depending on the version and release level.
The TXW_S_VBRK table consists of various fields, each holding specific information or linking keys about Retrieve VBRK from archive data available in SAP. These include TXW_VBELN (Billing Document), MANDT (Client), BUKRS (Company Code), BELNR (Accounting 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_VBRK 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 | |
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 | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
EXPKZ | Export indicator | EXPKZ | CHAR | 1 | EXPKZ | ||||
FKART | Billing Type | FKART | CHAR | 4 | Assigned to domain | FKART | |||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
FKSTO | Billing document is cancelled | FKSTO | CHAR | 1 | XFELD | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | Assigned to domain | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | Assigned to domain | KALSM | |||
KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
KUNRG | Payer | KUNRG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
SFAKN | Cancelled billing document number | SFAKN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
NETWR | Value of invoice | TXW_NETWR | CHAR | 16 | CHAR16 | ||||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
BSTNK_VF | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
LAND1 | Country of Destination | LLAND | CHAR | 3 | Assigned to domain | LAND1 | VLL | ||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | Assigned to domain | EXNUM | |||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
STCEG_H | Origin of sales tax ID number | STCEG_H | CHAR | 1 | STCEG_H | ||||
STCEG_L | Country of Sales Tax ID Number | STCEG_L | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
XEGDR | Indicator: Triangular deal within the EU ? | XEGDR | CHAR | 1 | XFELD | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
KURRF | Exchange rate for FI postings | TXW_KURRF | CHAR | 12 | CHAR12 | ||||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
TAXK1 | Tax classification 1 for customer | TAXK1 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK2 | Tax classification 2 for customer | TAXK2 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK5 | Tax classification 5 for customer | TAXK5 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK6 | Tax classification 6 for customer | TAXK6 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK7 | Tax classification 7 for customer | TAXK7 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK8 | Tax classification 8 for customer | TAXK8 | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXK9 | Tax classification 9 for customer | TAXK9 | CHAR | 1 | Assigned to domain | TAXKD |
Key field | Non-key field |
How do I retrieve data from SAP table TXW_S_VBRK using ABAP code
The following ABAP code Example will allow you to do a basic selection on TXW_S_VBRK to SELECT all data from the tableDATA: WA_TXW_S_VBRK TYPE TXW_S_VBRK.
SELECT SINGLE *
FROM TXW_S_VBRK
INTO CORRESPONDING FIELDS OF WA_TXW_S_VBRK
WHERE...
How to access SAP table TXW_S_VBRK
Within an ECC or HANA version of SAP you can also view further information about TXW_S_VBRK 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