SAP table TXW_S_VBRK (Retrieve VBRK from archive)

SAP table TXW_S_VBRK has 2 primary key fields being TXW_MANDT,TXW_VBELN.

Field Description Data Type Length Decimals Checktable Data Element
TXW_MANDT Client CLNT 3 0 MANDT
TXW_VBELN Billing Document CHAR 10 0 VBELN_VF
MANDT Client CLNT 3 0 * MANDT
BUKRS Company Code CHAR 4 0 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
MONAT Fiscal period NUMC 2 0 MONAT
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
XBLNR Reference Document Number CHAR 16 0 XBLNR1
WAERK SD Document Currency CUKY 5 0 * WAERK
VBUND Company ID of Trading Partner CHAR 6 0 * RASSC
EXPKZ Export indicator CHAR 1 0 EXPKZ
FKART Billing Type CHAR 4 0 * FKART
FKDAT Billing Date DATS 8 0 FKDAT
FKSTO Billing document is canceled CHAR 1 0 FKSTO
INCO1 Incoterms (Part 1) CHAR 3 0 * INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 * KALSM_D
KUNAG Sold-to Party CHAR 10 0 * KUNAG
KUNRG Payer CHAR 10 0 * KUNRG
SFAKN Number of canceled billing document CHAR 10 0 SFAKN
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NETWR Value of invoice CHAR 31 0 TXW_NETWR
AWTYP Reference procedure CHAR 5 0 * AWTYP
AWKEY Reference Key CHAR 20 0 AWKEY
BSTNK_VF Customer Reference CHAR 35 0 BSTKD
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
VKORG Sales Organization CHAR 4 0 VKORG
ZTERM Terms of payment key CHAR 4 0 DZTERM
LAND1 Destination Country/Region CHAR 3 0 * LLAND
LANDTX Tax Departure Country/Region CHAR 3 0 * LANDTX
LOGSYS Logical system CHAR 10 0 * LOGSYS
EXNUM Number of foreign trade data in MM and SD documents CHAR 10 0 EXNUM
STCEG VAT Registration Number CHAR 20 0 STCEG
STCEG_H Origin of Sales Tax ID Number CHAR 1 0 STCEG_H
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/Region of Sales Tax ID Number CHAR 3 0 * STCEG_L
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
KURRF Exchange rate for FI postings CHAR 12 0 TXW_KURRF
POPER Posting period NUMC 3 0 POPER
TAXK1 Tax Classification 1 for Customer CHAR 1 0 * TAXK1
TAXK2 Tax Classification 2 for Customer CHAR 1 0 * TAXK2
TAXK3 Tax Classification 3 for Customer CHAR 1 0 * TAXK3
TAXK4 Tax Classification 4 for Customer CHAR 1 0 * TAXK4
TAXK5 Tax Classification 5 for Customer CHAR 1 0 * TAXK5
TAXK6 Tax Classification 6 for Customer CHAR 1 0 * TAXK6
TAXK7 Tax Classification 7 for Customer CHAR 1 0 * TAXK7
TAXK8 Tax Classification 8 for Customer CHAR 1 0 * TAXK8
TAXK9 Tax Classification 9 for Customer CHAR 1 0 * TAXK9