SAP Table TXW_S_VBRP

Retrieve VBRP from archive

TXW_S_VBRP (Retrieve VBRP 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_VBRP to other SAP tables.

TXW_S_VBRP 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
TXW_POSNR Billing item POSNR_VF NUMC 6 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 Billing Document VBELN_VF CHAR 10 0
POSNR Billing item POSNR_VF NUMC 6 0
PSTYV Sales document item category PSTYV CHAR 4 0
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
VGTYP Document category of preceding SD document VBTYP_V 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
AUBEL Sales Document VBELN_VA CHAR 10 0
AUPOS Sales Document Item POSNR_VA NUMC 6 0
AUTYP 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
GSBER Business Area GSBER CHAR 4 0
KOKRS Controlling Area KOKRS CHAR 4 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
FBUDA Date on which services rendered FBUDA DATS 8 0
FKIMG Actual invoiced quantity TXW_FKIMG CHAR 16 0
KOWRR Statistical values KOWRR CHAR 1 0
NULL System will copy item to header totals
X No cumulation - Values cannot be used statistically
Y No cumulation - Values can be used statistically
LMENG Required quantity for mat.management in stockkeeping units TXW_LMENG CHAR 16 0
MATKL Material Group MATKL CHAR 9 0
MATNR Material Number MATNR CHAR 18 0
MEINS Base Unit of Measure MEINS UNIT 3 0
MWSBP Tax amount in document currency TXW_MWSBP CHAR 16 0
NETWR Net value of the billing item in document currency TXW_NETWRF CHAR 17 0
PRCTR Profit Center PRCTR CHAR 10 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
VRKME Sales Unit of Measure TXW_VRKME UNIT 3 0
WERKS Plant WERKS_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
KZWI1 Subtotal 1 from pricing procedure for condition TXW_KZWI1 CHAR 20 0
KZWI2 Subtotal 2 from pricing procedure for condition TXW_KZWI2 CHAR 20 0
KZWI3 Subtotal 3 from pricing procedure for condition TXW_KZWI3 CHAR 20 0
KZWI4 Subtotal 4 from pricing procedure for condition TXW_KZWI4 CHAR 20 0
KZWI5 Subtotal 5 from pricing procedure for condition TXW_KZWI5 CHAR 20 0
KZWI6 Subtotal 6 from pricing procedure for condition TXW_KZWI6 CHAR 20 0
PRODH Product hierarchy PRODH_D CHAR 18 0
TAXM1 Tax classification material TAXM1 CHAR 1 0
TAXM2 Tax classification 2 for material TAXM2 CHAR 1 0
TAXM3 Tax classification 3 for material TAXM3 CHAR 1 0
TAXM4 Tax Classification 4 Material TAXM4 CHAR 1 0
TAXM5 Tax classification 5 for material TAXM5 CHAR 1 0
TAXM6 Tax classification 6 for material TAXM6 CHAR 1 0
TAXM7 Tax classification 7 for material TAXM7 CHAR 1 0
TAXM8 Tax Classification 8 Material TAXM8 CHAR 1 0
TAXM9 Tax Classification 9 Material TAXM9 CHAR 1 0
LGORT Storage Location LGORT_D CHAR 4 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0