SAP Table VFKN

Account Determination in Shipment Costs Item

VFKN (Account Determination in Shipment Costs Item) 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 VFKN to other SAP tables.

VFKN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FKNUM Shipment Cost Number FKNUM VFKP CHAR 10 0
FKPOS Shipment costs item FKPOS VFKP NUMC 6 0
LFNKN Sequential number of account assignment LFNKN NUMC 4 0
AEDAT Date on Which Record Was Created ERDAT DATS 8 0
NOACT Inactive account assignment specification NOACT CHAR 1 0
KFLAG Change flag: Purchasing (currently not used) EFLAG CHAR 1 0
X Yes
NULL No
NETWR Net value in currency of shipment cost item NETWR_P CURR 15 2
RETYP 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
SAKTO G/L Account Number SAKNR SKA1 CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
PROJNR WBS Element PS_POSNR PRPS NUMC 8 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
VBELP Sales Document Item POSNR_VA VBUP NUMC 6 0
ANLN1 Main Asset Number ANLN1 ANLH CHAR 12 0
ANLN2 Asset Subnumber ANLN2 ANLA CHAR 4 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KSTRG Cost Object KSTRG CKPH CHAR 12 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR AUFK CHAR 12 0
VORNR Operation/Activity Number VORNR CHAR 4 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
APLZL Internal counter CIM_COUNT NUMC 8 0
VPTNR Partner account number JV_PART KNA1 CHAR 10 0
FIPOS Commitment Item FIPOS FMFPO CHAR 14 0
RECID Recovery Indicator JV_RECIND T8JJ CHAR 2 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
FKBER Functional Area FKBER TFKB CHAR 16 0
WERKS Plant WERKS_D T001W CHAR 4 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
LSTAR Activity Type LSTAR CSLA CHAR 6 0
PRZNR Business Process CO_PRZNR CBPR CHAR 12 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0

VFKN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VFKN ANLN1 VFKN MANDT ANLH Main asset number MANDT
VFKN ANLN1 T001 BUKRS ANLH Main asset number BUKRS
VFKN ANLN1 VFKN ANLN1 ANLH Main asset number ANLN1
VFKN ANLN2 VFKN MANDT ANLA Asset Master Record Segment MANDT
VFKN ANLN2 T001 BUKRS ANLA Asset Master Record Segment BUKRS
VFKN ANLN2 VFKN ANLN1 ANLA Asset Master Record Segment ANLN1
VFKN ANLN2 VFKN ANLN2 ANLA Asset Master Record Segment ANLN2
VFKN AUFNR VFKN MANDT AUFK Order master data MANDT
VFKN AUFNR VFKN AUFNR AUFK Order master data AUFNR
VFKN FIPOS T001 FIKRS FMFPO FIFM: Commitment Item FIKRS
VFKN FIPOS VFKN FIPOS FMFPO FIFM: Commitment Item FIPOS
VFKN FIPOS VFKN AEDAT FMFPO FIFM: Commitment Item DATBIS
VFKN FIPOS VFKN MANDT FMFPO FIFM: Commitment Item MANDT
VFKN FKBER VFKN MANDT TFKB Functional areas MANDT
VFKN FKBER VFKN FKBER TFKB Functional areas FKBER
VFKN FKNUM VFKN MANDT VFKP Shipment Costs: Item Data MANDT
VFKN FKNUM VFKN FKNUM VFKP Shipment Costs: Item Data FKNUM
VFKN FKNUM VFKN FKPOS VFKP Shipment Costs: Item Data FKPOS
VFKN FKPOS VFKN MANDT VFKP Shipment Costs: Item Data MANDT
VFKN FKPOS VFKN FKNUM VFKP Shipment Costs: Item Data FKNUM
VFKN FKPOS VFKN FKPOS VFKP Shipment Costs: Item Data FKPOS
VFKN GSBER VFKN GSBER TGSB Business Areas GSBER
VFKN GSBER VFKN MANDT TGSB Business Areas MANDT
VFKN KOKRS VFKN MANDT TKA01 Controlling Areas MANDT
VFKN KOKRS VFKN KOKRS TKA01 Controlling Areas KOKRS
VFKN KOSTL VFKN MANDT CSKS Cost Center Master Data MANDT
VFKN KOSTL VFKN KOKRS CSKS Cost Center Master Data KOKRS
VFKN KOSTL VFKN KOSTL CSKS Cost Center Master Data KOSTL
VFKN KOSTL VFKN AEDAT CSKS Cost Center Master Data DATBI
VFKN KSTRG VFKN KSTRG CKPH Master Record: Cost Object ID Number KSTRG
VFKN KSTRG VFKN AEDAT CKPH Master Record: Cost Object ID Number DATBI
VFKN KSTRG VFKN MANDT CKPH Master Record: Cost Object ID Number MANDT
VFKN LSTAR VFKN MANDT CSLA Activity master MANDT
VFKN LSTAR VFKN KOKRS CSLA Activity master KOKRS
VFKN LSTAR VFKN LSTAR CSLA Activity master LSTAR
VFKN LSTAR * CSLA Activity master DATBI
VFKN MANDT VFKN MANDT T000 Clients MANDT
VFKN NPLNR VFKN NPLNR AUFK Order master data AUFNR
VFKN NPLNR VFKN MANDT AUFK Order master data MANDT
VFKN PRCTR VFKN MANDT CEPC Profit Center Master Data Table MANDT
VFKN PRCTR VFKN PRCTR CEPC Profit Center Master Data Table PRCTR
VFKN PRCTR VFKN AEDAT CEPC Profit Center Master Data Table DATBI
VFKN PRCTR VFKN KOKRS CEPC Profit Center Master Data Table KOKRS
VFKN PROJNR VFKN MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
VFKN PROJNR VFKN PROJNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
VFKN PRZNR VFKN MANDT CBPR CO-ABC: Activity Master Table MANDT
VFKN PRZNR VFKN KOKRS CBPR CO-ABC: Activity Master Table KOKRS
VFKN PRZNR VFKN PRZNR CBPR CO-ABC: Activity Master Table PRZNR
VFKN PRZNR * CBPR CO-ABC: Activity Master Table DATBI
VFKN PS_PSP_PNR VFKN MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
VFKN PS_PSP_PNR VFKN PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
VFKN RECID VFKP BUKRS T8JJ Recovery Indicator BUKRS
VFKN RECID VFKN RECID T8JJ Recovery Indicator RECID
VFKN RECID VFKN MANDT T8JJ Recovery Indicator MANDT
VFKN SAKTO VFKN SAKTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
VFKN SAKTO VFKN MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
VFKN SAKTO T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
VFKN VBELN VFKN MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VFKN VBELN VFKN VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VFKN VBELP VFKN VBELN VBUP Sales Document: Item Status VBELN
VFKN VBELP VFKN VBELP VBUP Sales Document: Item Status POSNR
VFKN VBELP VFKN MANDT VBUP Sales Document: Item Status MANDT
VFKN VPTNR VFKN MANDT KNA1 General Data in Customer Master MANDT
VFKN VPTNR VFKN VPTNR KNA1 General Data in Customer Master KUNNR
VFKN WERKS VFKN MANDT T001W Plants/Branches MANDT
VFKN WERKS VFKN WERKS T001W Plants/Branches WERKS