SAP table TXW_S_VBRP (Retrieve VBRP from archive)

SAP table TXW_S_VBRP has 3 primary key fields being TXW_MANDT,TXW_VBELN,TXW_POSNR.

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