SAP Table VFKPVB

Shipment Costs: Item Data (for Logging)

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

VFKPVB 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
SLFREI Marking for transfer SLFREI CHAR 1 0
NULL do not transfer
X transfer
SLSTOR Marking for cancellation transfer SLSTOR CHAR 1 0
NULL do not cancel
X cancel
KPOSNL Condition item number KPOSN NUMC 6 0
STDAT Settlement date (cancellation transfer) STDAT_P DATS 8 0
VIM_MARKED Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
UPDKZ Update indicator UPDKZ_D CHAR 1 0
INCON CHAR 1 0
OIGSCAPPL TD-F Application of shipment cost document or item OIG_SCAPPL CHAR 1 0
NULL Standard SD-shipment
1 IS-Oil TD bulk shipment
9 OGSD Data Collation

VFKPVB foreign key relationships

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