1. Home
  2. Resources
  3. SAP Tables
  4. VFKP - Shipment Costs: Item Data

SAP Table VFKP

Shipment Costs: Item Data

VFKP (Shipment Costs: Item Data) 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 VFKP to other SAP tables.

Source: VFKP (Shipment Costs: Item Data)

VFKP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FKNUM Shipment Cost Number FKNUM VFKK CHAR 10 0
FKPOS Shipment costs item FKPOS NUMC 6 0
FKPTY Item category shipment costs FKPTY TVFT CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
NETWR Net value in currency of shipment cost item NETWR_P CURR 15 2
MWSBP Tax amount in currency of shipment cost item MWSBP_P CURR 13 2
WAERS Currency of the Shipment Cost Item WAERS_P TCURC CUKY 5 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
PRSDT Pricing date PRSDT_P DATS 8 0
BUDAT Settlement date BUDAT_P DATS 8 0
EXTI1 External identification 1 Item EXTI1_P CHAR 20 0
EXTI2 External identification 2 Item EXTI2_P CHAR 20 0
TPLST Transportation planning point TPLST TTDS CHAR 4 0
VSART Shipping type for shipment stage VERSARTS T173 CHAR 2 0
KALSM Sales and Distribution: Pricing Procedure in Pricing KALSMASD T683 CHAR 6 0
KNUMV Number of the document condition KNUMV CHAR 10 0
WERKS Plant WERKS_D T001W CHAR 4 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group BKGRP T024 CHAR 3 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
LBLNI Entry Sheet Number LBLNI CHAR 10 0
PARVW Partner Function PARVW TPAR CHAR 2 0
TDLNR Number of service agent TDLNR_P LFA1 CHAR 10 0
RECHS Invoicing party for shipment cost item RECHST LFA1 CHAR 10 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
KOSTY Cost type (shipment cost item) KOSTY CHAR 1 0
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 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
REBEL Referenced document REBEL CHAR 10 0
REPOS Referenced document item REPOS_P NUMC 6 0
POSTX Description for reference POSTX CHAR 40 0
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
BKLAS Valuation Class BWKLL T025 CHAR 4 0
STBER Status of calculation (shipment costs item data) STBER_P CHAR 1 0
A Not calculated
B Partially calculated
C Fully calculated
DTBER Date of calculation DTBER DATS 8 0
UZBER Time of calculation UZBER TIMS 6 0
STFRE Status of account determination STFRE_P CHAR 1 0
NULL Not relevant for account assignment
A Account assignment not completed
B Account assignment incomplete
C Account assignment fully completed
DTFRE Date of account determination DTFRE DATS 8 0
UZFRE Time of account assignment UZFRE TIMS 6 0
STABR Status of transfer (shipment costs item data) STABR_P CHAR 1 0
NULL Not relevant for transfer
A Not transferred
C Transferred
DTABR Date of settlement DTABR_T DATS 8 0
UZABR Time of settlement UZABR TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZET Time last change was made AEZET TIMS 6 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
KSTAU Cost distribution CO KSTAU CHAR 1 0
A Shipment costs item
B Delivery
C Delivery item
TRFZNA Tariff zone of point of departure TRFZNA TVFTZ CHAR 10 0
TRFZNZ Tariff zone of point of destination TRFZNZ TVFTZ CHAR 10 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
BASWR Tax base amount BASWR_P CURR 15 2
SLAND1_A Tax country departure SLAND1_A T005 CHAR 3 0
SLAND1_Z Tax country destination SLAND1_Z T005 CHAR 3 0
FKSTO Shipment cost item already cancelled FKSTO_P CHAR 1 0
X Yes
NULL No
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2

VFKP foreign key relationships

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