SAP ABAP Table SRV_MDRV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SRV_MDRV	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	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number
3	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
4	EKGRP	☑	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
5	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
6	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
7	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
8	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
9	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	MARA
12	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
13	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
14	PLIFZ	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
15	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
16	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
17	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
18	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
19	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
20	BSTYP_K	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
21	LOEKZ_K	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
22	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
23	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
24	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
25	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
26	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
27	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
28	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
29	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
30	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
31	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
32	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	T161
33	LEBRE	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
34	MEMORY	☐	MEMER	XFELD	CHAR	1	0	Purchase order not yet complete
35	STATU	☐	ESTAK	ESTAK	CHAR	1	0	Status of Purchasing Document
36	MEMORYTYPE	☐	MEMORYTYPE	MM_MEMORYTYPE	CHAR	1	0	Category of Incompleteness

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SRV_MDRV	BSART	T161	BSART	REF	1	N
2	SRV_MDRV	EKGRP	T024	EKGRP	REF	1	N
3	SRV_MDRV	EKORG	T024E	EKORG	REF	1	N
4	SRV_MDRV	EMATN	MARA	MATNR	REF	1	N
5	SRV_MDRV	KNTTP	T163K	KNTTP	REF	1	N
6	SRV_MDRV	LGORT	T001L	LGORT	REF	1	N
7	SRV_MDRV	LIFNR	LFA1	LIFNR	REF	1	N
8	SRV_MDRV	MANDT	T000	MANDT	KEY	1	N
9	SRV_MDRV	MATKL	T023	MATKL	REF	1	N
10	SRV_MDRV	MATNR	MARA	MATNR	REF	1	N
11	SRV_MDRV	PACKNO	ESLH	PACKNO	KEY	1	N
12	SRV_MDRV	PSTYP	T163	PSTYP	REF	1	N
13	SRV_MDRV	RESWK	T001W	WERKS	REF	1	N
14	SRV_MDRV	SOBKZ	T148	SOBKZ	REF	1	N
15	SRV_MDRV	WAERS	TCURC	WAERS	REF	1	N
16	SRV_MDRV	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in