Follow us on LinkedIn for your next SAP project
← Back to Search

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.

VFKP table fields

Field Data element Checktable Datatype Length Decimals Possible values
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
REFTY
SD document category
 VBTYP
CHAR
 1 0
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
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
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
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
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
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 BUKRS T001
Company Codes
 BUKRS
VFKP BUKRS VFKP MANDT T001
Company Codes
 MANDT
VFKP EKGRP VFKP MANDT T024
Purchasing Groups
 MANDT
VFKP EKGRP VFKP EKGRP T024
Purchasing Groups
 EKGRP
VFKP EKORG VFKP MANDT T024E
Purchasing Organizations
 MANDT
VFKP EKORG VFKP EKORG T024E
Purchasing Organizations
 EKORG
VFKP FKNUM VFKP MANDT VFKK
Shipment Costs: Header Data
 MANDT
VFKP FKNUM VFKP FKNUM VFKK
Shipment Costs: Header Data
 FKNUM
VFKP FKPTY VFKP MANDT TVFT
Shipment Cost Item Categories
 MANDT
VFKP FKPTY VFKP FKPTY TVFT
Shipment Cost Item Categories
 FKPTY
VFKP KALSM 'A' T683
Pricing procedures
 KVEWE
VFKP KALSM 'F' T683
Pricing procedures
 KAPPL
VFKP KALSM VFKP KALSM T683
Pricing procedures
 KALSM
VFKP KALSM VFKP MANDT T683
Pricing procedures
 MANDT
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 MANDT T007A
Tax Keys
 MANDT
VFKP MWSKZ VFKP KALSM T007A
Tax Keys
 KALSM
VFKP MWSKZ VFKP MWSKZ T007A
Tax Keys
 MWSKZ
VFKP PARVW VFKP MANDT TPAR
Business Partner: Functions
 MANDT
VFKP PARVW VFKP PARVW TPAR
Business Partner: Functions
 PARVW
VFKP RECHS VFKP MANDT LFA1
Vendor Master (General Section)
 MANDT
VFKP RECHS VFKP RECHS LFA1
Vendor Master (General Section)
 LIFNR
VFKP SLAND1_A VFKP MANDT T005
Countries
 MANDT
VFKP SLAND1_A VFKP SLAND1_A T005
Countries
 LAND1
VFKP SLAND1_Z VFKP MANDT T005
Countries
 MANDT
VFKP SLAND1_Z VFKP SLAND1_Z T005
Countries
 LAND1
VFKP TDLNR VFKP MANDT LFA1
Vendor Master (General Section)
 MANDT
VFKP TDLNR VFKP TDLNR LFA1
Vendor Master (General Section)
 LIFNR
VFKP TPLST VFKP TPLST TTDS
Organizational Unit: Transportation Scheduling Point
 TPLST
VFKP TPLST VFKP MANDT TTDS
Organizational Unit: Transportation Scheduling Point
 MANDT
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 MANDT T173
Routes: Mode of Transport for Each Shipping Type
 MANDT
VFKP VSART VFKP VSART T173
Routes: Mode of Transport for Each Shipping Type
 VSART
VFKP WAERS VFKP WAERS TCURC
Currency Codes
 WAERS
VFKP WAERS VFKP MANDT TCURC
Currency Codes
 MANDT
VFKP WERKS VFKP MANDT T001W
Plants/Branches
 MANDT
VFKP WERKS VFKP WERKS T001W
Plants/Branches
 WERKS