SAP table VFSI (Shipment Costs: Sub-item Data)

SAP table VFSI has 3 primary key fields being MANDT,KNUMV,KPOSN.

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
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
KPOSN Shipment cost subitem NUMC 6 0 KPOSN_P
BERGL Calculation Base CHAR 1 0 BERGL
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 CHAR 4 0 TVTY VHIART
VBTYP 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)
VBELN Sales and Distribution Document Number CHAR 10 0 * VBELN
POSNR Item number of the SD document NUMC 6 0 * POSNR
NETWR Net value of sub-item in currency of shipment cost item CURR 15 2 NETWR_U
MWSBP Tax amount of sub-item in currency of shipment cost item CURR 13 2 MWSBP_U
NETPR Net Price CURR 11 2 NETPR
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
MPROK Status manual price change CHAR 1 0 MPROK
No manual price change
A Manual price change carried out
B Condition manually deleted
C Manual price change released
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit UNIT 3 0 T006 KMEIN
UVPRS Incomplete with respect to pricing CHAR 1 0 UVPRS
PRSOK Pricing is OK CHAR 1 0 PRSOK
BASWR Tax base amount CURR 15 2 BASWR_P
MWSKZ Tax on sales/purchases code CHAR 2 0 * MWSKZ
GARVZ Freight code set CHAR 6 0 TGAV GARVZ
GTART Freight code CHAR 12 0 TGAR GTART
GTKLS Freight class CHAR 12 0 GTKLS
ACTIV Indicator: Subitem active CHAR 1 0 SCDSUBACT
Not active
X active

VFSI foreign key relationships

Table Field Check Table Check Field
0 VFSI GARVZ TGAV Freight Code Sets MANDT
1 VFSI GTART TGAR Freight Codes MANDT
1 VFSI GTART TGAR Freight Codes GARVZ
1 VFSI GTART TGAR Freight Codes GTART
0 VFSI KMEIN T006 Units of Measurement MANDT
1 VFSI MANDT T000 Clients MANDT
0 VFSI VHART TVTY Packaging Material Types MANDT
0 VFSI VHART TVTY Packaging Material Types TRATY