SAP table VRKPA (Sales Index: Bills by Partner Functions)

SAP table VRKPA has 12 primary key fields being MANDT,KUNDE,PARVW,VKORG,FKDAT,VTWEG,FKART,KUNNR,KUNAG,VBTYP,ERNAM,VBELN.

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 MANDT
KUNDE Partner number (KUNNR, LIFNR, or PERNR) CHAR 10 0 KUNDE_D
PARVW Partner Function CHAR 2 0 TPAR PARVW
VKORG Sales Organization CHAR 4 0 TVKO VKORG
FKDAT Billing Date DATS 8 0 FKDAT
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
FKART Billing Type CHAR 4 0 TVFK FKART
KUNNR Payer CHAR 10 0 KNA1 KUNRG
KUNAG Sold-to Party CHAR 10 0 KUNAG
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)
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
VBELN Billing Document CHAR 10 0 VBELN_VF
FKTYP Billing Category CHAR 1 0 FKTYP
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
S CRM Billing Document
U Billing request
W POS billing document
X Billing using general interface
ADRNR Address CHAR 10 0 ADRNR
ADRNR_RG Address nummer of the payer CHAR 10 0 ADRNR_RG
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR

VRKPA foreign key relationships

Table Field Check Table Check Field
0 VRKPA FKART TVFK Billing: Document Types MANDT
0 VRKPA FKART TVFK Billing: Document Types FKART
1 VRKPA KUNNR KNA1 General Data in Customer Master MANDT
1 VRKPA KUNNR KNA1 General Data in Customer Master KUNNR
0 VRKPA PARVW TPAR Business Partner: Functions PARVW
1 VRKPA VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 VRKPA VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 VRKPA VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 VRKPA VTWEG TVTW Organizational Unit: Distribution Channels VTWEG