VRESB SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
VRESB is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The VRESB table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include RSNUM (Number of Reservation/Dependent Requirement), RSPOS (Item Number of Reservation/Dependent Requirement), RSART (Record type), SPRAS (Language Key).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP VRESB table view 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 | T000 | MANDT | |||
| RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | RSNUM | RES | |||
| RSPOS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
| RSART | Record type | RSART | CHAR | 1 | RSART | ||||
| SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
| BDART | Requirement type | BDART | CHAR | 2 | BDART | BDA | |||
| RSSTA | Status of reservation | RSSTA | CHAR | 1 | STATR | ||||
| XLOEK | Item is Deleted | XLOEK | CHAR | 1 | XFELD | ||||
| XWAOK | Goods Movement for Reservation Allowed | XWAOK | CHAR | 1 | XFELD | ||||
| KZEAR | Final Issue for This Reservation | KZEAR | CHAR | 1 | XFELD | ||||
| XFEHL | Missing Part | XFEHL | CHAR | 1 | XFELD | ||||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
| CHARG | Batch Number | CHARG_D | CHAR | 10 | MCHA | CHARG | CHA | ||
| PLPLA | Distribution of Differences | PLPLA | CHAR | 10 | PLPLA | ||||
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
| BDTER | Requirement Date for the Component | BDTER | DATS | 8 | DATUM | ||||
| BDMNG | Requirement Quantity | BDMNG | QUAN | 13(3) | MENG13 | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
| FMENG | Quantity is Fixed | FMENG | CHAR | 1 | XFELD | ||||
| ENMNG | Quantity Withdrawn | ENMNG | QUAN | 13(3) | MENG13 | ||||
| ENWRT | Value Withdrawn | ENWRT | CURR | 13(2) | VWERT13 | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13(3) | MENG13 | ||||
| ERFME | Unit of Entry | ERFME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| PLNUM | Planned order number | PLNUM | CHAR | 10 | PLAF | ALPHA | PLNUM | PAF | |
| BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
| BNFPO | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | EBAN | BNFPO | BAP | ||
| AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
| BAUGR | Material number of higher-level assembly | BAUGR | CHAR | 18 | MARA | MATN1 | MATNR | ||
| SERNR | BOM explosion number | SERNR | CHAR | 8 | SNUM | SERNR | |||
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
| KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
| PROJN | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | PROJN | ||||
| BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | T156 | BWART | BWA | ||
| SAKNR | G/L Account Number | SAKNR | CHAR | 10 | ALPHA | SAKNR | SAK | C_SAKNR | |
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| UMWRK | Receiving/Issuing Plant | UMWRK | CHAR | 4 | T001W | WERKS | |||
| UMLGO | Receiving/Issuing Storage Location | UMLGO | CHAR | 4 | T001L | LGORT | |||
| NAFKZ | Indicator: follow-up material active/not active | NAFKZ | CHAR | 1 | XFELD | ||||
| NOMAT | Follow-Up/Original Material | NOMAT | CHAR | 18 | MARA | MATN1 | MATNR | ||
| NOMNG | Required quantity | NOMNG | QUAN | 13(3) | MENG13 | ||||
| POSTP | Item Category (Bill of Material) | POSTP | CHAR | 1 | T418 | POSTP | |||
| POSNR | BOM item number | APOSN | CHAR | 4 | NUMCV | SPOSN | |||
| ROMS1 | Size 1 | ROMS1 | QUAN | 13(3) | MENG13 | ||||
| ROMS2 | Size 2 | ROMS2 | QUAN | 13(3) | MENG13 | ||||
| ROMS3 | Size 3 | ROMS3 | QUAN | 13(3) | MENG13 | ||||
| ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ROMEN | Quantity of variable-size item | ROMEN | QUAN | 13(3) | MENG13 | ||||
| SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
| LMENG | Required quantity for mat.management in stockkeeping units | LMENG | QUAN | 13(3) | MENG13 | ||||
| ROHPS | Variable-sized item indicator | ROHPS | CHAR | 1 | XFELD | ||||
| RFORM | Formula key | RFORM | CHAR | 2 | T418F | RFORM | |||
| ROANZ | Number of variable-size items | ROANZ | QUAN | 13(3) | MENG13 | ||||
| FLMNG | Shortfall quantity of the component in the order | FLMNG | QUAN | 13(3) | MENG13 | ||||
| STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
| STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
| STLKN | BOM item node number | STLKN | NUMC | 8 | KNTNR | ||||
| STPOZ | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| LTXSP | Language: The long text was stored in this language | LTXSP | LANG | 1 | T002 | ISOLA | SPRAS | ||
| POTX1 | BOM Item Text (Line 1) | POTX1 | CHAR | 40 | TEXT40 | ||||
| POTX2 | BOM item text (line 2) | POTX2 | CHAR | 40 | TEXT40 | ||||
| SANKA | Indicator for Relevancy to Costing | CK_SELKZ | CHAR | 1 | TCK08 | CK_SELKZ | |||
| ALPOS | Alternative item indicator | ALTPS | CHAR | 1 | XFELD | ||||
| EWAHR | Usage probability in % (alternative item) | EWAHR | DEC | 3 | DEC3 | ||||
| AUSCH | Component scrap in percent | KAUSF | DEC | 5(2) | DEC3_2 | ||||
| AVOAU | Operation scrap | AVOAU | DEC | 5(2) | DEC3_2 | ||||
| NETAU | Indicator: Net scrap | NETAU | CHAR | 1 | XFELD | ||||
| NLFZT | Lead-time offset | NLFZT | DEC | 3 | NLFZT | ||||
| AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
| UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
| UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
| SORTF | Sort String | SORTP | CHAR | 10 | CHAR10 | ||||
| SBTER | Latest requirements date | SBTER | DATS | 8 | DATUM | ||||
| VERTI | MRP Distribution Key | SA_VERTL | CHAR | 4 | T437V | SA_VERTL | |||
| SCHGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
| UPSKZ | Indicator: sub-items exist | UPSKZ | CHAR | 1 | XFELD | ||||
| DBSKZ | Direct procurement indicator | DBSKZ | CHAR | 1 | DBSKZ | ||||
| TXTPS | Item text indicator | TXTPS | CHAR | 1 | XFELD | ||||
| DUMPS | Phantom item indicator | DUMPS | CHAR | 1 | XFELD | ||||
| BEIKZ | Material Provision Indicator | BEIKZ | CHAR | 1 | T417 | BEIKZ | |||
| ERSKZ | Indicator: spare part | ERSKZ | CHAR | 1 | T413 | ERSKZ | |||
| AUFST | Order level | AUFST | NUMC | 2 | AUFST | ||||
| AUFWG | Order path | AUFWG | NUMC | 2 | AUFWG | ||||
| BAUST | Assembly order level | BAUST | NUMC | 2 | AUFST | ||||
| BAUWG | Assembly order path | BAUWG | NUMC | 2 | AUFWG | ||||
| AUFPS | Order item number | AUFPS | CHAR | 2 | CHAR2 | ||||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
| EBELE | Delivery Schedule Line Counter | EETEN | NUMC | 4 | EKET | EETEN | |||
| KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
| KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
| PSPEL | WBS Element | PS_POSNR | NUMC | 8 | ABPSP | PS_POSNR | |||
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
| PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
| APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
| FLGAT | Sequence category | FOLGENART | CHAR | 1 | TCA07 | FLGAT | |||
| GPREIS | Price in component currency | PPCOMP | CURR | 15(2) | WERTV8 | ||||
| PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
| RGEKZ | Indicator: Backflush | RGEKZ | CHAR | 1 | XFELD | ||||
| EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
| ROKME | Unit of measure for variable-size component | ROKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
| MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
| ZEINR | Document number (without document management system) | DZEINR | CHAR | 22 | CHAR22 | ||||
| ZEIAR | Document type (without Document Management system) | DZEIAR | CHAR | 3 | ZEIAR | ||||
| BISMT | Old material number | BISMT | CHAR | 18 | BISMT | ||||
| ZEIVR | Document version (without Document Management system) | DZEIVR | CHAR | 2 | VERSI | ||||
| ZEIFO | Page format of document (without Document Management system) | DZEIFO | CHAR | 4 | DINFO | ||||
| AESZN | Document change number (without document management system) | AESZN | CHAR | 6 | AENUM | ||||
| BLATT | Page number of document (without Document Management system) | BLATT | CHAR | 3 | BLATT | ||||
| BLANZ | Number of sheets (without Document Management system) | BLANZ | NUMC | 3 | NUM3 | ||||
| MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 |
| Key field | Non-key field |
How do I retrieve data from SAP table VRESB using ABAP code
The following ABAP code Example will allow you to do a basic selection on VRESB to SELECT all data from the tableDATA: WA_VRESB TYPE VRESB.
SELECT SINGLE *
FROM VRESB
INTO CORRESPONDING FIELDS OF WA_VRESB
WHERE...
How to access SAP table VRESB
Within an ECC or HANA version of SAP you can also view further information about VRESB 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