SAP table V_TEWACTION (Generated Table for View)

SAP table V_TEWACTION has 3 primary key fields being MANDT,APPLICATION,CLASS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
APPLICATION Application CHAR 30 0 TEWAPPLICATION WB2_APPLICATION
CLASS Class CHAR 30 0 WB2_CLASS
OPERATION Operation in SAP System CHAR 2 0 WB2_OPERATION
Create
A Display
B Change
C Delete
D Cancel
E Enter a new item in an existing document
F Visual Action as Subscreen in Trading Execution Workbench
OPERATION_TYPE Classification of Subsequent Action CHAR 2 0 WB2_OPERATION_TYPE
Online transaction
A Background (No Entries)
B As Subscreen in TEW
SOURCE_DOC Document Type CHAR 2 0 WB2_DOC_TYPE
## Not used and is not written to database
* All Document Categories
1 Pricing Document (Internal)
A Sales Order
A1 Credit Memo Request
A2 Debit Memo Request
A3 RFQ/Inquiry
A4 Quotation
A5 Scheduling Agreement (SD)
A6 Returns
A7 Independent Requirements Plan
B Contract (SD)
C Purchase Order
D Delivery
E Inbound Delivery
E1 Return Delivery for Order
F Supplier Billing Document
G Goods Receipt
H Invoice Verification
I Accounting Document
J Settlement Document
J1 Supplier Settlement List
J2 Customer Settlement List
J3 Settlement Document List
K Invoice
K1 Credit Memo
K2 Debit Memo
K3 Invoice Reversal
K4 Credit Memo Reversal
K5 Pro Forma Invoice
K6 Invoice List
K7 Credit Memo List
K8 Internal Settlement, Invoice
K9 Internal Settlement, Credit Memo
L Goods Issue
L1 Goods Movement
M Picking
N Contract (MM)
O RFQ (MM)
P Scheduling Agreement (MM)
Q Trading Contract
Q1 Sales-Side Trading Contract (Only WBGT Entries for BW)
R Nomination
S1 Held Goods Reciept Document (Purchase Order)
S2 Held Goods Reciept Document (Inbound Delivery)
SH Shadow
T Forward Exchange Transaction
U1 Handling Unit
V1 Difference Calculation
W Period End Valuation: Invoice
W1 Period End Valuation: Credit Memo
W3 Period End Valuation: Invoice Reversal
W4 Period End Valuation: Credit Memo Reversal
W8 Period End Valuation: Intercompany Invoice
W9 Period End Valuation: Intercompany Credit Memo
XX Undefined Document Type
Z0 For cust.enhancements
Z1 For cust.enhancements
Z2 For cust.enhancements
Z3 For cust.enhancements
Z4 For cust.enhancements
Z5 For cust.enhancements
Z6 For cust.enhancements
Z7 For cust.enhancements
Z8 For cust.enhancements
Z9 For cust.enhancements
ZA For cust.enhancements
ZB For cust.enhancements
ZC For cust.enhancements
ZD For cust.enhancements
ZE For cust.enhancements
ZF For cust.enhancements
ZG For cust.enhancements
ZH For cust.enhancements
ZI For cust.enhancements
ZJ For cust.enhancements
ZK For cust.enhancements
ZL For cust.enhancements
ZM For cust.enhancements
ZN For cust.enhancements
ZO For cust.enhancements
ZP For cust.enhancements
ZQ For cust.enhancements
ZR For cust.enhancements
ZS For cust.enhancements
ZT For cust.enhancements
ZU For cust.enhancements
ZV For cust.enhancements
ZW For cust.enhancements
ZX For cust.enhancements
ZY For cust.enhancements
ZZ For cust.enhancements
TARGET_DOC Document Type CHAR 2 0 WB2_DOC_TYPE
## Not used and is not written to database
* All Document Categories
1 Pricing Document (Internal)
A Sales Order
A1 Credit Memo Request
A2 Debit Memo Request
A3 RFQ/Inquiry
A4 Quotation
A5 Scheduling Agreement (SD)
A6 Returns
A7 Independent Requirements Plan
B Contract (SD)
C Purchase Order
D Delivery
E Inbound Delivery
E1 Return Delivery for Order
F Supplier Billing Document
G Goods Receipt
H Invoice Verification
I Accounting Document
J Settlement Document
J1 Supplier Settlement List
J2 Customer Settlement List
J3 Settlement Document List
K Invoice
K1 Credit Memo
K2 Debit Memo
K3 Invoice Reversal
K4 Credit Memo Reversal
K5 Pro Forma Invoice
K6 Invoice List
K7 Credit Memo List
K8 Internal Settlement, Invoice
K9 Internal Settlement, Credit Memo
L Goods Issue
L1 Goods Movement
M Picking
N Contract (MM)
O RFQ (MM)
P Scheduling Agreement (MM)
Q Trading Contract
Q1 Sales-Side Trading Contract (Only WBGT Entries for BW)
R Nomination
S1 Held Goods Reciept Document (Purchase Order)
S2 Held Goods Reciept Document (Inbound Delivery)
SH Shadow
T Forward Exchange Transaction
U1 Handling Unit
V1 Difference Calculation
W Period End Valuation: Invoice
W1 Period End Valuation: Credit Memo
W3 Period End Valuation: Invoice Reversal
W4 Period End Valuation: Credit Memo Reversal
W8 Period End Valuation: Intercompany Invoice
W9 Period End Valuation: Intercompany Credit Memo
XX Undefined Document Type
Z0 For cust.enhancements
Z1 For cust.enhancements
Z2 For cust.enhancements
Z3 For cust.enhancements
Z4 For cust.enhancements
Z5 For cust.enhancements
Z6 For cust.enhancements
Z7 For cust.enhancements
Z8 For cust.enhancements
Z9 For cust.enhancements
ZA For cust.enhancements
ZB For cust.enhancements
ZC For cust.enhancements
ZD For cust.enhancements
ZE For cust.enhancements
ZF For cust.enhancements
ZG For cust.enhancements
ZH For cust.enhancements
ZI For cust.enhancements
ZJ For cust.enhancements
ZK For cust.enhancements
ZL For cust.enhancements
ZM For cust.enhancements
ZN For cust.enhancements
ZO For cust.enhancements
ZP For cust.enhancements
ZQ For cust.enhancements
ZR For cust.enhancements
ZS For cust.enhancements
ZT For cust.enhancements
ZU For cust.enhancements
ZV For cust.enhancements
ZW For cust.enhancements
ZX For cust.enhancements
ZY For cust.enhancements
ZZ For cust.enhancements
SELECTION_TYPE Selection Type for Source Documents CHAR 1 0 WB2_SELECTION_TYPE
Header
A Item
B Single Header
C Single Item
TCODE Original Transaction Code of Action Class CHAR 20 0 TSTC WB2_TCODE
TEXT Description Text CHAR 40 0 WB2_TEXT

V_TEWACTION foreign key relationships

Table Field Check Table Check Field
0 V_TEWACTION APPLICATION TEWAPPLICATION Application MANDT
0 V_TEWACTION APPLICATION TEWAPPLICATION Application APPLICATION
1 V_TEWACTION MANDT T000 Clients MANDT
0 V_TEWACTION TCODE TSTC SAP Transaction Codes TCODE