SAP table VFKP (Shipment Costs: Item Data)

SAP table VFKP has 3 primary key fields being MANDT,FKNUM,FKPOS.

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 VFKK FKNUM
FKPOS Shipment costs item NUMC 6 0 FKPOS
FKPTY Item category shipment costs CHAR 4 0 TVFT FKPTY
BUKRS Company Code CHAR 4 0 T001 BUKRS
NETWR Net value in currency of shipment cost item CURR 15 2 NETWR_P
MWSBP Tax amount in currency of shipment cost item CURR 13 2 MWSBP_P
WAERS Currency of the Shipment Cost Item CUKY 5 0 TCURC WAERS_P
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
PRSDT Pricing date DATS 8 0 PRSDT_P
BUDAT Settlement date DATS 8 0 BUDAT_P
EXTI1 External identification 1 Item CHAR 20 0 EXTI1_P
EXTI2 External identification 2 Item CHAR 20 0 EXTI2_P
TPLST Transportation planning point CHAR 4 0 TTDS TPLST
VSART Shipping type for shipment stage CHAR 2 0 T173 VERSARTS
KALSM Pricing Procedure in Pricing CHAR 6 0 T683 KALSMASD
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
WERKS Plant CHAR 4 0 T001W WERKS_D
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 BKGRP
EBELN Purchasing Document Number CHAR 10 0 * EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 * EBELP
LBLNI Entry Sheet Number CHAR 10 0 * LBLNI
PARVW Partner Function CHAR 2 0 TPAR PARVW
TDLNR Number of service agent CHAR 10 0 LFA1 TDLNR_P
RECHS Invoicing party for shipment cost item CHAR 10 0 LFA1 RECHST
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
KOSTY Cost type (shipment cost item) CHAR 1 0 KOSTY
A Shipment Header
B Shipment Leg
C Load Transfer Point
D Border Crossing Point
E Vehicle - Bulk Product Shipment (IS-Oil Only)
REFTY 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)
REBEL Referenced document CHAR 10 0 REBEL
REPOS Referenced document item NUMC 6 0 REPOS_P
POSTX Description for reference CHAR 40 0 POSTX
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
BKLAS Valuation Class CHAR 4 0 T025 BWKLL
STBER Status of calculation (shipment costs item data) CHAR 1 0 STBER_P
A Not calculated
B Partially calculated
C Fully calculated
DTBER Date of calculation DATS 8 0 DTBER
UZBER Time of calculation TIMS 6 0 UZBER
STFRE Status of account determination CHAR 1 0 STFRE_P
Not relevant for account assignment
A Account assignment not completed
B Account assignment incomplete
C Account assignment fully completed
DTFRE Date of account determination DATS 8 0 DTFRE
UZFRE Time of account assignment TIMS 6 0 UZFRE
STABR Status of transfer (shipment costs item data) CHAR 1 0 STABR_P
Not relevant for transfer
A Not transferred
C Transferred
DTABR Date of settlement DATS 8 0 DTABR_T
UZABR Time of settlement TIMS 6 0 UZABR
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
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
KSTAU Cost distribution CO CHAR 1 0 KSTAU
A Shipment costs item
B Delivery
C Delivery item
TRFZNA Tariff zone of point of departure CHAR 10 0 TVFTZ TRFZNA
TRFZNZ Tariff zone of point of destination CHAR 10 0 TVFTZ TRFZNZ
TXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
BASWR Tax base amount CURR 15 2 BASWR_P
SLAND1_A Tax country departure CHAR 3 0 T005 SLAND1_A
SLAND1_Z Tax country destination CHAR 3 0 T005 SLAND1_Z
FKSTO Shipment cost item already cancelled CHAR 1 0 FKSTO_P
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6

VFKP foreign key relationships

Table Field Check Table Check Field
0 VFKP BKLAS T025 Valuation Classes MANDT
0 VFKP BKLAS T025 Valuation Classes BKLAS
1 VFKP BUKRS T001 Company Codes BUKRS
0 VFKP EKGRP T024 Purchasing Groups EKGRP
1 VFKP EKORG T024E Purchasing Organizations EKORG
0 VFKP FKNUM VFKK Shipment Costs: Header Data MANDT
0 VFKP FKNUM VFKK Shipment Costs: Header Data FKNUM
1 VFKP FKPTY TVFT Shipment Cost Item Categories MANDT
1 VFKP FKPTY TVFT Shipment Cost Item Categories FKPTY
0 VFKP KALSM T683 Pricing procedures KAPPL
0 VFKP KALSM T683 Pricing procedures KALSM
1 VFKP KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
1 VFKP KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
0 VFKP KURST TCURV Exchange rate types for currency translation MANDT
0 VFKP KURST TCURV Exchange rate types for currency translation KURST
1 VFKP LOGSYS TBDLS Logical system LOGSYS
0 VFKP MANDT T000 Clients MANDT
1 VFKP MWSKZ T007A Tax Keys KALSM
1 VFKP MWSKZ T007A Tax Keys MWSKZ
0 VFKP PARVW TPAR Business Partner: Functions PARVW
1 VFKP RECHS LFA1 Supplier Master (General Section) MANDT
1 VFKP RECHS LFA1 Supplier Master (General Section) LIFNR
0 VFKP SLAND1_A T005 Countries MANDT
0 VFKP SLAND1_A T005 Countries LAND1
1 VFKP SLAND1_Z T005 Countries MANDT
1 VFKP SLAND1_Z T005 Countries LAND1
0 VFKP TDLNR LFA1 Supplier Master (General Section) MANDT
0 VFKP TDLNR LFA1 Supplier Master (General Section) LIFNR
1 VFKP TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 VFKP TRFZNA TVFTZ Tariff Zones for Shipment Costs MANDT
0 VFKP TRFZNA TVFTZ Tariff Zones for Shipment Costs TRFZN
1 VFKP TRFZNZ TVFTZ Tariff Zones for Shipment Costs MANDT
1 VFKP TRFZNZ TVFTZ Tariff Zones for Shipment Costs TRFZN
0 VFKP VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
0 VFKP VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
1 VFKP WAERS TCURC Currency Codes MANDT
1 VFKP WAERS TCURC Currency Codes WAERS
0 VFKP WERKS T001W Plants/Branches WERKS