SAP Table TXW_S_VBRK

Retrieve VBRK from archive

TXW_S_VBRK (Retrieve VBRK from archive) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TXW_S_VBRK to other SAP tables.

TXW_S_VBRK table fields

Field Data element Checktable Datatype Length Decimals
TXW_MANDT Client MANDT CLNT 3 0
TXW_VBELN Billing Document VBELN_VF CHAR 10 0
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
MONAT Fiscal Period MONAT NUMC 2 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
WAERK SD Document Currency WAERK CUKY 5 0
VBUND Company ID of trading partner RASSC CHAR 6 0
EXPKZ Export indicator EXPKZ CHAR 1 0
FKART Billing Type FKART CHAR 4 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
FKSTO Billing document is cancelled FKSTO CHAR 1 0
X Yes
NULL No
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0
KUNAG Sold-to party KUNAG CHAR 10 0
KUNRG Payer KUNRG CHAR 10 0
SFAKN Cancelled billing document number SFAKN CHAR 10 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
NETWR Value of invoice TXW_NETWR CHAR 16 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWKEY Reference Key AWKEY CHAR 20 0
BSTNK_VF Customer purchase order number BSTKD CHAR 35 0
KNUMV Number of the document condition KNUMV CHAR 10 0
VKORG Sales Organization VKORG CHAR 4 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
LAND1 Country of Destination LLAND CHAR 3 0
LANDTX Tax departure country LANDTX CHAR 3 0
LOGSYS Logical system LOGSYS CHAR 10 0
EXNUM Number of foreign trade data in MM and SD documents EXNUM CHAR 10 0
STCEG VAT Registration Number STCEG CHAR 20 0
STCEG_H Origin of sales tax ID number STCEG_H CHAR 1 0
A Ship-to party
B Payer
C Sold-to party
D Payer (KNAS segment)
E Manually entered or changed
F Entered manually in order
G Own VAT reg. no. in dest. country
H Payer for tax receiving country from order
I Sold-to party for tax receiving country from order
J Sold to party (segment KNAS)
STCEG_L Country of Sales Tax ID Number STCEG_L CHAR 3 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
KURRF Exchange rate for FI postings TXW_KURRF CHAR 12 0
POPER Posting period POPER NUMC 3 0
TAXK1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAXK2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAXK3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAXK4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAXK5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAXK6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAXK7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAXK8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAXK9 Tax classification 9 for customer TAXK9 CHAR 1 0