SAP Table VRKPA

Sales Index: Bills by Partner Functions

VRKPA (Sales Index: Bills by Partner Functions) 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 VRKPA to other SAP tables.

VRKPA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KUNDE Partner number (KUNNR, LIFNR, or PERNR) KUNDE_D CHAR 10 0
PARVW Partner Function PARVW TPAR CHAR 2 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
FKDAT Billing date for billing index and printout FKDAT DATS 8 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
FKART Billing Type FKART TVFK CHAR 4 0
KUNNR Payer KUNRG KNA1 CHAR 10 0
KUNAG Sold-to party KUNAG CHAR 10 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
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
VBELN Billing Document VBELN_VF CHAR 10 0
FKTYP Billing category FKTYP CHAR 1 0
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
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
ADRNR Address ADRNR CHAR 10 0
ADRNR_RG Address nummer of the payer ADRNR_RG CHAR 10 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0

VRKPA foreign key relationships

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