1. Home
  2. Resources
  3. SAP Tables
  4. VFSI - Shipment Costs: Sub-item Data

SAP Table VFSI

Shipment Costs: Sub-item Data

VFSI (Shipment Costs: Sub-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 VFSI to other SAP tables.

VFSI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KNUMV Number of the document condition KNUMV CHAR 10 0
KPOSN Shipment cost subitem KPOSN_P NUMC 6 0
BERGL Calculation Base BERGL CHAR 1 0
NULL All
A Delivery
B Delivery item
C Handling units
D Shipment costs item
E Per handling unit
F Shipping unit including delivery item
O Document Item Quantity - Bulk Product Shipment (IS-Oil Only)
P Vehicle - Bulk Product Shipment (IS-Oil Only)
VHART Packaging Material Type VHIART TVTY CHAR 4 0
VBTYP 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
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
NETWR Net value of sub-item in currency of shipment cost item NETWR_U CURR 15 2
MWSBP Tax amount of sub-item in currency of shipment cost item MWSBP_U CURR 13 2
NETPR Net price NETPR CURR 11 2
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
MPROK Status manual price change MPROK CHAR 1 0
NULL No manual price change
A Manual price change carried out
B Condition manually deleted
C Manual price change released
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN T006 UNIT 3 0
UVPRS Incomplete with respect to pricing UVPRS CHAR 1 0
X Yes
NULL No
PRSOK Pricing is OK PRSOK CHAR 1 0
X Yes
NULL No
BASWR Tax base amount BASWR_P CURR 15 2
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
GARVZ Freight code set GARVZ TGAV CHAR 6 0
GTART Freight code GTART TGAR CHAR 12 0
GTKLS Freight class GTKLS CHAR 12 0
ACTIV Indicator: Subitem active SCDSUBACT CHAR 1 0
NULL Not active
X active
OIGLD_ITM TD-F Load/discharge quantity assignment item OIG_LDITM NUMC 4 0
OIGLDOCNUM TD-F number of load-relevant document OIG_LDOCNR CHAR 10 0
OIGLPOSNR TD-F load-relevant document item number for assignment OIG_LITEM NUMC 6 0
OIGLDOCTYP 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
OIGVEH_NR Vehicle Sequence Number in Shipment OIG_VEHNR NUMC 3 0
OIGVEHICLE TD Vehicle Number OIG_VHLNMR CHAR 10 0
OIGVEH_TYP TD vehicle type OIG_VHLTYP CHAR 4 0
OIGVEHMODE TD vehicle mode of transport OIG_VMOT CHAR 1 0
1 Road
2 Rail
3 Marine
4 Barge
5 Pipeline
OIGGROUP TD-Vehicle Classification Group OIG_CL_GRP CHAR 10 0

VFSI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VFSI GARVZ VFSI MANDT TGAV Freight Code Sets MANDT
VFSI GARVZ VFSI GARVZ TGAV Freight Code Sets GARVZ
VFSI GTART VFSI MANDT TGAR Freight Codes MANDT
VFSI GTART VFSI GARVZ TGAR Freight Codes GARVZ
VFSI GTART VFSI GTART TGAR Freight Codes GTART
VFSI KMEIN VFSI MANDT T006 Units of Measurement MANDT
VFSI KMEIN VFSI KMEIN T006 Units of Measurement MSEHI
VFSI MANDT VFSI MANDT T000 Clients MANDT
VFSI VHART VFSI MANDT TVTY Packaging Material Types MANDT
VFSI VHART VFSI VHART TVTY Packaging Material Types TRATY