SAP Table VFKNVB

Account Assignment Shipment Cost Item: (for logging)

VFKNVB (Account Assignment Shipment Cost Item: (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 VFKNVB to other SAP tables.

VFKNVB 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
UPDKZ Update indicator UPDKZ_D CHAR 1 0
VIM_MARKED Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
ACCT_CHECK Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed

VFKNVB foreign key relationships

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