TXW_S_VBRK SAP (Retrieve VBRK from archive) Table details

Dictionary Type: Table
Description: Retrieve VBRK from archive




ABAP Code to SELECT data from TXW_S_VBRK
Related tables to TXW_S_VBRK
Access table TXW_S_VBRK




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 empty
Display/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_MANDTClient MANDTCLNT3Assigned to domainMANDT
TXW_VBELNBilling Document VBELN_VFCHAR10Assigned to domainALPHAVBELNVF
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
MONATFiscal Period MONATNUMC2MONAT
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
WAERKSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
EXPKZExport indicator EXPKZCHAR1EXPKZ
FKARTBilling Type FKARTCHAR4Assigned to domainFKART
FKDATBilling date for billing index and printout FKDATDATS8DATUM
FKSTOBilling document is cancelled FKSTOCHAR1XFELD
INCO1Incoterms (Part 1) INCO1CHAR3Assigned to domainINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_DCHAR6Assigned to domainKALSM
KUNAGSold-to party KUNAGCHAR10Assigned to domainALPHAKUNNRVAG
KUNRGPayer KUNRGCHAR10Assigned to domainALPHAKUNNR
SFAKNCancelled billing document number SFAKNCHAR10Assigned to domainALPHAVBELNVF
VBTYPSD document category VBTYPCHAR1VBTYP
NETWRValue of invoice TXW_NETWRCHAR16CHAR16
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
AWKEYReference Key AWKEYCHAR20AWKEY
BSTNK_VFCustomer purchase order number BSTKDCHAR35BSTKD
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
LAND1Country of Destination LLANDCHAR3Assigned to domainLAND1VLL
LANDTXTax departure country LANDTXCHAR3Assigned to domainLAND1LND
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
EXNUMNumber of foreign trade data in MM and SD documents EXNUMCHAR10Assigned to domainEXNUM
STCEGVAT Registration Number STCEGCHAR20STCEG
STCEG_HOrigin of sales tax ID number STCEG_HCHAR1STCEG_H
STCEG_LCountry of Sales Tax ID Number STCEG_LCHAR3Assigned to domainLAND1LND
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
KURRFExchange rate for FI postings TXW_KURRFCHAR12CHAR12
POPERPosting period POPERNUMC3POPERPOPR
TAXK1Tax classification 1 for customer TAXK1CHAR1Assigned to domainTAXKD
TAXK2Tax classification 2 for customer TAXK2CHAR1Assigned to domainTAXKD
TAXK3Tax classification 3 for customer TAXK3CHAR1Assigned to domainTAXKD
TAXK4Tax Classification 4 Customer TAXK4CHAR1Assigned to domainTAXKD
TAXK5Tax classification 5 for customer TAXK5CHAR1Assigned to domainTAXKD
TAXK6Tax classification 6 for customer TAXK6CHAR1Assigned to domainTAXKD
TAXK7Tax classification 7 for customer TAXK7CHAR1Assigned to domainTAXKD
TAXK8Tax classification 8 for customer TAXK8CHAR1Assigned to domainTAXKD
TAXK9Tax classification 9 for customer TAXK9CHAR1Assigned to domainTAXKD

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!