SAP ABAP Table VRESB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VRESB	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RSNUM	☑	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
3	RSPOS	☑	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
4	RSART	☑	RSART	RSART	CHAR	1	0	Record type
5	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
6	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
7	RSSTA	☐	RSSTA	STATR	CHAR	1	0	Status of reservation
8	XLOEK	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
9	XWAOK	☐	XWAOK	XFELD	CHAR	1	0	Goods movement for reservation allowed
10	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
11	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
12	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
13	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
14	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
15	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
16	PLPLA	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
17	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
18	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
19	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
20	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
22	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
23	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
24	ENWRT	☐	ENWRT	VWERT13	CURR	13	2	Value Withdrawn
25	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
27	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
28	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
29	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
30	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
31	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
32	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	MARA
33	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
34	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
35	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
36	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
37	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
38	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
39	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
40	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
41	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
42	UMLGO	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location	T001L
43	NAFKZ	☐	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
44	NOMAT	☐	NOMAT	MATNR	CHAR	18	0	Follow-Up/Original Material	MARA
45	NOMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
46	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
47	POSNR	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
48	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
49	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
50	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
51	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	T006
52	ROMEN	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
53	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
54	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
55	ROHPS	☐	ROHPS	XFELD	CHAR	1	0	Variable-sized item indicator
56	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	T418F
57	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
58	FLMNG	☐	FLMNG	MENG13	QUAN	13	3	Shortfall quantity of the component in the order
59	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
60	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
61	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
62	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
63	LTXSP	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	T002
64	POTX1	☐	POTX1	TEXT40	CHAR	40	0	BOM Item Text (Line 1)
65	POTX2	☐	POTX2	TEXT40	CHAR	40	0	BOM Item Text (Line 2)
66	SANKA	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	TCK08
67	ALPOS	☐	ALTPS	XFELD	CHAR	1	0	Alternative item indicator
68	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
69	AUSCH	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
70	AVOAU	☐	AVOAU	DEC3_2	DEC	5	2	Operation Scrap
71	NETAU	☐	NETAU	XFELD	CHAR	1	0	Indicator: Net Scrap
72	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
73	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
74	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
75	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
76	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
77	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
78	VERTI	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
79	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
80	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
81	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
82	TXTPS	☐	TXTPS	XFELD	CHAR	1	0	Item text indicator
83	DUMPS	☐	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
84	BEIKZ	☐	BEIKZ	BEIKZ	CHAR	1	0	Material Provision Indicators	T417
85	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	T413
86	AUFST	☐	AUFST	AUFST	NUMC	2	0	Order level
87	AUFWG	☐	AUFWG	AUFWG	NUMC	2	0	Order path
88	BAUST	☐	BAUST	AUFST	NUMC	2	0	Assembly order level
89	BAUWG	☐	BAUWG	AUFWG	NUMC	2	0	Assembly order path
90	AUFPS	☐	AUFPS	CHAR2	CHAR	2	0	Order item number
91	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
92	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
93	EBELE	☐	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	EKET
94	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
95	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
96	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element
97	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
98	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
99	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
100	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
101	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
102	FLGAT	☐	FOLGENART	FLGAT	CHAR	1	0	Sequence category	TCA07
103	GPREIS	☐	PPCOMP	WERTV8	CURR	15	2	Price in component currency
104	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
105	RGEKZ	☐	RGEKZ	XFELD	CHAR	1	0	Indicator: Backflush
106	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
107	ROKME	☐	ROKME	MEINS	UNIT	3	0	Unit of measure for variable-size component	T006
108	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
109	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
110	ZEINR	☐	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
111	ZEIAR	☐	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
112	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
113	ZEIVR	☐	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
114	ZEIFO	☐	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
115	AESZN	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
116	BLATT	☐	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
117	BLANZ	☐	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
118	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VRESB	AENNR	AENR	AENNR	REF	C	CN
2	VRESB	AUFNR	AUFK	AUFNR	REF	C	CN
3	VRESB	BAUGR	MARA	MATNR	REF	C	CN
4	VRESB	BEIKZ	T417	BEIKZ	REF	C	CN
5	VRESB	BNFPO	EBAN	BNFPO	REF	C	CN
6	VRESB	BWART	T156	BWART	REF	1	CN
7	VRESB	CHARG	MCHA	CHARG	REF	C	CN
8	VRESB	EBELE	EKET	ETENR	KEY	1	CN
9	VRESB	EBELN	EKKO	EBELN	KEY	1	CN
10	VRESB	EBELP	EKPO	EBELP	KEY	1	CN
11	VRESB	EKGRP	T024	EKGRP	REF	C	CN
12	VRESB	ERFME	T006	MSEHI	REF	C	CN
13	VRESB	ERSKZ	T413	ERSKZ	REF	C	CN
14	VRESB	FLGAT	TCA07	FLGAT	REF	C	CN
15	VRESB	GSBER	TGSB	GSBER	REF	C	CN
16	VRESB	KDAUF	VBUK	VBELN	REF	C	CN
17	VRESB	KNTTP	T163K	KNTTP	KEY	1	CN
18	VRESB	LGORT	T001L	LGORT	REF	C	CN
19	VRESB	LTXSP	T002	SPRAS	REF	C	CN
20	VRESB	MANDT	T000	MANDT	KEY	1	CN
21	VRESB	MATKL	T023	MATKL	REF	C	CN
22	VRESB	MATNR	MARA	MATNR	REF	1	CN
23	VRESB	MEINS	T006	MSEHI	REF	1	CN
24	VRESB	MTART	T134	MTART	REF	1	CN
25	VRESB	NOMAT	MARA	MATNR	REF	C	CN
26	VRESB	OBJNR	ONR00	OBJNR	REF	C	1
27	VRESB	PLNUM	PLAF	PLNUM	REF	C	CN
28	VRESB	POSTP	T418	POSTP	REF	C	CN
29	VRESB	RFORM	T418F	RFORM	REF	C	CN
30	VRESB	ROKME	T006	MSEHI	REF	C	CN
31	VRESB	ROMEI	T006	MSEHI	REF	C	CN
32	VRESB	SANKA	TCK08	SELKZ	KEY	1	CN
33	VRESB	SERNR	SNUM	SERNR		C	CN
34	VRESB	SOBKZ	T148	SOBKZ	REF	C	CN
35	VRESB	SPRAS	T002	SPRAS	KEY	1	CN
36	VRESB	UMLGO	T001L	LGORT	REF	C	CN
37	VRESB	UMWRK	T001W	WERKS	REF	C	CN
38	VRESB	VERTI	T437V	VERTL	REF	C	CN
39	VRESB	WAERS	TCURC	WAERS	REF	1	CN
40	VRESB	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in