SAP table WVFB (DRS Interface, Intermediate Buffer, Order Item FM)
SAP table WVFB has 3 primary key fields being MANDT,WGSREQN,WGSREQP.
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
*
MANDT
WGSREQN
Document number of store order document buffer
CHAR
10
0
*
WGSREQN
WGSREQP
Item number of inbound document buffer
NUMC
5
0
*
WGSREQP
WBTYP
Default doc. category, store order inbound - replenishment
CHAR
1
0
VWWSBTYPVO
Create PO, otherwise error will occur
1
Create purchase requisition, otherwise error will occur
2
Create PO, if error occurs create PReq., otherwise error
3
Pur. Order
4
Delivery
7
Sales order
8
PO copy (no message to external supplier)
A
Warehouse order if stock exists, otherwise third-party order
B
Warehouse order, but third-party order for large qties
C
Stock on-hand, if avail.; otherwise other DC; otherw. direct
ACTION
Sales promotion code for the item
CHAR
3
0
WVFB_ACTION
BUKRS
Company Code
CHAR
4
0
*
BUKRS
BSTYP
Purchasing Document Category
CHAR
1
0
BSTYP
A
Request for quotation
B
Purchase requisition
C
Central Contract
F
Purchase order
I
Info record
K
Contract
L
Scheduling agreement
N
Central Request for Quotation
O
Quotation
Q
Service entry sheet
R
Request for Quotation
S
Simplified service entry sheet
T
Central Quotation
W
Source list
BSART
Purchasing Document Type
CHAR
4
0
*
ESART
LIFNR
Vendor's account number
CHAR
10
0
*
ELIFN
ZTERM
Terms of payment key
CHAR
4
0
DZTERM
EKORG
Purchasing organization
CHAR
4
0
*
EKORG
EKGRP
Purchasing Group
CHAR
3
0
*
BKGRP
DISPO
MRP Controller
CHAR
3
0
*
DISPO
AFNAM
Name of requisitioner/requester
CHAR
12
0
AFNAM
WAERS
Currency Key
CUKY
5
0
*
WAERS
WKURS
Exchange Rate
DEC
9
5
WKURS
KUNNR
Customer Number
CHAR
10
0
*
KUNNR
RESWK
Supplying (issuing) plant in case of stock transport order
CHAR
4
0
*
RESWK
KONNR
Number of principal purchase agreement
CHAR
10
0
*
KONNR
MATNR
Material Number
CHAR
40
0
*
MATNR
EMATN
Material number
CHAR
40
0
*
EMATNR
WERKS
Plant
CHAR
4
0
*
EWERK
BEDNR
Requirement tracking number
CHAR
35
0
BEDNR_EXT
MATKL
Material Group
CHAR
9
0
*
MATKL
IDNLF
Material Number Used by Supplier
CHAR
35
0
IDNLF
MENGE
Purchase Order Quantity
QUAN
13
3
BSTMG
MEINS
Purchase Order Unit of Measure
UNIT
3
0
*
BSTME
PSTYP
Item category in purchasing document
CHAR
1
0
*
PSTYP
LMEIN
Base Unit of Measure
UNIT
3
0
*
LAGME
EAN11
International Article Number (EAN/UPC)
CHAR
18
0
EAN11
AKTNR
Promotion
CHAR
10
0
*
WAKTION
EINDT
Item delivery date
DATS
8
0
EINDT
UZEIT
Delivery Date Time-Spot
TIMS
6
0
LZEIT
BEDAT
Order date of schedule line
DATS
8
0
ETBDT
VSTAT
DRS FM interface - processing status
CHAR
1
0
VSTATUS
POSNRI
SI FM Interface: Internal item no.
NUMC
10
0
POSNRI
KNTTP
Account Assignment Category
CHAR
1
0
*
WVFBKNTTP
KOSTL
Cost center
CHAR
10
0
*
WVFBKOSTL
LTSNR
Supplier Subrange
CHAR
6
0
*
LTSNR
LGORT
Storage Location
CHAR
4
0
WVFBLGORT
WVFBSORT
Sort in step 2
CHAR
1
0
WVFBSORT
WVFB_NO_WF
No workflow
CHAR
1
0
WVFB_NO_WF
WVFBSTEP
Execution step
CHAR
1
0
WVFBSTEP
WVFBCALL
Calling program
CHAR
1
0
WVFBCALL
WVFBPARTEXIST
Input partner definitions exist
CHAR
1
0
WVFBPARTEXIST
WVFBCONDEXIST
Condition_exist
CHAR
1
0
WVFBCONDEXIST
USRC1
User field format character for release strategy
CHAR
20
0
USRC1
USRC2
User field format character for release strategy
CHAR
20
0
USRC1
USRN1
User field numeric for release strategy
NUMC
10
0
USRN1
USRN2
User field numeric for release strategy
NUMC
10
0
USRN1
VSTEL
Shipping point
CHAR
4
0
*
WVFBVSTEL
LPRIO
Delivery priority
NUMC
2
0
*
WVFBLPRIO
ROUTE
Route
CHAR
6
0
*
WVFBROUTE
SPDNR
Carrier
CHAR
10
0
*
WVFBSPDNR
VKORG
Sales organization
CHAR
4
0
*
WVFBVKORG
VTWEG
Distribution channel
CHAR
2
0
*
WVFBVTWEG
SPART
Division
CHAR
2
0
*
WVFBSPART
VKBUR
Sales office
CHAR
4
0
*
VKBUR
VKGRP
Sales group
CHAR
3
0
*
VKGRP
AUART
Sales Document Type
CHAR
4
0
*
AUART
RETPO
Returns Item
CHAR
1
0
RETPO
I_BELNR
Document number of store order document buffer
CHAR
10
0
*
WGSREQN
I_POSNR
Item number of inbound document buffer
NUMC
5
0
*
WGSREQP
E_BELNR
Object key
CHAR
70
0
SWO_TYPEID
E_POSNR
Document Item in Follow-On Document for Store Order