WVFB SAP (DRS Interface, Intermediate Buffer, Order Item FM) Table details
Description: DRS Interface, Intermediate Buffer, Order Item FM
Table field list including key, data, relationships and ABAP select examples
WVFB is a standard SAP Table which is used to store DRS Interface, Intermediate Buffer, Order Item FM data and is available within R/3 SAP systems depending on the version and release level.
The WVFB table consists of various fields, each holding specific information or linking keys about DRS Interface, Intermediate Buffer, Order Item FM data available in SAP. These include WGSREQN (Document number of store order document buffer), WGSREQP (Item number of inbound document buffer), WBTYP (Default doc. category, store order inbound - replenishment), ACTION (Sales promotion code for the item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP WVFB table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
WGSREQN | Document number of store order document buffer | WGSREQN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | |
WGSREQP | Item number of inbound document buffer | WGSREQP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
WBTYP | Default doc. category, store order inbound - replenishment | VWWSBTYPVO | CHAR | 1 | VWWSBTYPVO | ||||
ACTION | Sales promotion code for the item | WVFB_ACTION | CHAR | 3 | EDIF1229A | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
BSART | Purchasing Document Type | ESART | CHAR | 4 | Assigned to domain | BSART | BSA | ||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
EKGRP | Purchasing Group | BKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | Assigned to domain | DISPO | DGR | HS_T024D | |
AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
WKURS | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | |||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
RESWK | Supplying (Issuing) Plant in Stock Transport Order | RESWK | CHAR | 4 | Assigned to domain | WERKS | |||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
EMATN | Material Number | EMATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
WERKS | Plant | EWERK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
BEDNR | Requirement tracking number | BEDNR_EXT | CHAR | 35 | CHAR35 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
MENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | Assigned to domain | PSTYP | |||
LMEIN | Base Unit of Measure | LAGME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
AKTNR | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
EINDT | Item Delivery Date | EINDT | DATS | 8 | DATUM | ||||
UZEIT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | UZEIT | ||||
BEDAT | Order date of schedule line | ETBDT | DATS | 8 | DATUM | ||||
VSTAT | DRS FM interface - processing status | VSTATUS | CHAR | 1 | VSTATUS | ||||
POSNRI | SI FM Interface: Internal item no. | POSNRI | NUMC | 10 | POSNRI | ||||
KNTTP | Account Assignment Category | WVFBKNTTP | CHAR | 1 | Assigned to domain | KNTTP | |||
KOSTL | Cost center | WVFBKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
LTSNR | Vendor Subrange | LTSNR | CHAR | 6 | Assigned to domain | LTSNR | |||
LGORT | Storage Location | WVFBLGORT | CHAR | 4 | CHAR4 | ||||
WVFBSORT | Sort in step 2 | WVFBSORT | CHAR | 1 | CHAR1 | ||||
WVFB_NO_WF | No workflow | WVFB_NO_WF | CHAR | 1 | CHAR1_X | ||||
WVFBSTEP | Execution step | WVFBSTEP | CHAR | 1 | CHAR1 | ||||
WVFBCALL | Calling program | WVFBCALL | CHAR | 1 | CHAR1 | ||||
WVFBPARTEXIST | Input partner definitions exist | WVFBPARTEXIST | CHAR | 1 | CHAR1 | ||||
WVFBCONDEXIST | Condition_exist | WVFBCONDEXIST | CHAR | 1 | CHAR1 | ||||
USRC1 | User field format character for release strategy | USRC1 | CHAR | 20 | CHAR20 | ||||
USRC2 | User field format character for release strategy | USRC1 | CHAR | 20 | CHAR20 | ||||
USRN1 | User field numeric for release strategy | USRN1 | NUMC | 10 | NUM10 | ||||
USRN2 | User field numeric for release strategy | USRN1 | NUMC | 10 | NUM10 | ||||
VSTEL | Shipping point | WVFBVSTEL | CHAR | 4 | Assigned to domain | VSTEL | VST | ||
LPRIO | Delivery priority | WVFBLPRIO | NUMC | 2 | Assigned to domain | LPRIO | |||
ROUTE | Route | WVFBROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
SPDNR | Carrier | WVFBSPDNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
VKORG | Sales organization | WVFBVKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | ||
VTWEG | Distribution channel | WVFBVTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | ||
SPART | Division | WVFBSPART | CHAR | 2 | Assigned to domain | SPART | SPA | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
I_BELNR | Document number of store order document buffer | WGSREQN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | |
I_POSNR | Item number of inbound document buffer | WGSREQP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
E_BELNR | Object key | SWO_TYPEID | CHAR | 70 | SWO_TYPEID | ||||
E_POSNR | Document Item in Follow-On Document for Store Order | WVFB_BELP | NUMC | 6 | Assigned to domain | POSNR | |||
E_OBJTYPE | Object Type | SWO_OBJTYP | CHAR | 10 | Assigned to domain | OJ_NAME | OBJ | ||
FREE | Free Item | UMSON | CHAR | 1 | XFELD | ||||
SEGNUM | Number of SAP segment | IDOCDSGNUM | NUMC | 6 | EDI_NUMBER | ||||
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
UPTYP | Subitem Category, Purchasing Document | UPTYP | CHAR | 1 | Assigned to domain | UPTYP | |||
HL_ITEM | Higher-Level Item in Purchasing Documents | UEBPO | NUMC | 5 | Assigned to domain | EBELP |
Key field | Non-key field |
How do I retrieve data from SAP table WVFB using ABAP code
The following ABAP code Example will allow you to do a basic selection on WVFB to SELECT all data from the tableDATA: WA_WVFB TYPE WVFB.
SELECT SINGLE *
FROM WVFB
INTO CORRESPONDING FIELDS OF WA_WVFB
WHERE...
How to access SAP table WVFB
Within an ECC or HANA version of SAP you can also view further information about WVFB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects