SAP Table VAKPA_REF

Generated Table for View

VAKPA_REF (Generated Table for View) 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 VAKPA_REF to other SAP tables.

VAKPA_REF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
AUART Sales Document Type AUART TVAK CHAR 4 0
TRVOG Transaction group TRVOG CHAR 1 0
0 Sales order
1 Inquiry
2 Quotation
3 Scheduling agreement
4 Contract
5 Item proposal
6 Delivery
7 Billing documents
8 Proforma invoices
9 Sales activities
A Sales promotions
B Customer independent requirements
D Shipping notification
G Rough Goods Receipt
O Cost accounting: Variance calculation
KUNDE Partner number (KUNNR, LIFNR, or PERNR) KUNDE_D CHAR 10 0
PARVW Partner Function PARVW TPAR CHAR 2 0
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
DATAB Quotation or contract valid from DATAB_VI DATS 8 0
DATBI Quotation or contract valid to DATBI_VI DATS 8 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
ABRUF_PART Check partner authorizations ABRUF_PART CHAR 1 0
NULL No check
A Check partner authorized to release in contract
B Check Customer List Partner
GBSTK Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed

VAKPA_REF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VAKPA_REF AUART VAKPA_REF MANDT TVAK Sales Document Types MANDT
VAKPA_REF AUART VAKPA_REF AUART TVAK Sales Document Types AUART
VAKPA_REF KUNNR VAKPA_REF MANDT KNA1 General Data in Customer Master MANDT
VAKPA_REF KUNNR VAKPA_REF KUNNR KNA1 General Data in Customer Master KUNNR
VAKPA_REF MANDT VAKPA_REF MANDT T000 Clients MANDT
VAKPA_REF PARVW VAKPA_REF PARVW TPAR Business Partner: Functions PARVW
VAKPA_REF PARVW VAKPA_REF MANDT TPAR Business Partner: Functions MANDT
VAKPA_REF SPART VAKPA_REF MANDT TSPA Organizational Unit: Sales Divisions MANDT
VAKPA_REF SPART VAKPA_REF SPART TSPA Organizational Unit: Sales Divisions SPART
VAKPA_REF VBELN VAKPA_REF MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VAKPA_REF VBELN VAKPA_REF VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VAKPA_REF VKORG VAKPA_REF VKORG TVKO Organizational Unit: Sales Organizations VKORG
VAKPA_REF VKORG VAKPA_REF MANDT TVKO Organizational Unit: Sales Organizations MANDT
VAKPA_REF VTWEG VAKPA_REF MANDT TVTW Organizational Unit: Distribution Channels MANDT
VAKPA_REF VTWEG VAKPA_REF VTWEG TVTW Organizational Unit: Distribution Channels VTWEG