SAP table VFKK (Shipment Costs: Header Data)

SAP table VFKK has 2 primary key fields being MANDT,FKNUM.

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
FKNUM Shipment Cost Number CHAR 10 0 FKNUM
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)
FKART Shipment cost type CHAR 4 0 TVTF FKART_T
STERM Leg determination CHAR 1 0 STERM
Blank: No legs to be determined
0 0: Only determine assignment of deliveries to stages
1 1: Legs determined according to departure point & itinerary
2 2: Prelim.leg per loading point, subsqnt leg per ship-to pty
3 3: Determine preliminary and subsequent leg by delivery note
4 4: As 1, but ship. type for prel. and subs. legs changeable
PRSDT Pricing date DATS 8 0 PRSDT_K
BUDAT Settlement date DATS 8 0 BUDAT_K
EXTI1 External identification 1 header CHAR 20 0 EXTI1_K
EXTI2 External identification 2 CHAR 20 0 EXTI2_K
STBER Status of calculation (shipment costs header data) CHAR 1 0 STBER_K
A Not calculated
B Partially calculated
C Fully calculated
STFRE Status of account determination (shipment costs header data) CHAR 1 0 STFRE_K
Not relevant for account assignment
A Account assignment not completed
B Account assignment partially completed
C Account assignment fully completed
STABR Status of transfer (shipment costs header data) CHAR 1 0 STABR_K
Not relevant for transfer
A Not transferred
B Partially transferred
C Fully transferred
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZET Time last change was made TIMS 6 0 AEZET

VFKK foreign key relationships

Table Field Check Table Check Field
0 VFKK FKART TVTF Shipment Cost Types MANDT
0 VFKK FKART TVTF Shipment Cost Types FKART
1 VFKK MANDT T000 Clients MANDT