SAP ABAP Table ENT5035 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT5035	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	MATALLGNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
4	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
5	WERKS	☑	EWERK	WERKS	CHAR	4	0	Plant	T001W
6	EKGRP	☑	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
7	WAERS	☑	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
8	BONUS	☑	WRBON	XFELD	CHAR	1	0	Indicator: Volume-Based Rebate
9	MGBON	☑	MGBON	XFELD	CHAR	1	0	Indicator: Quantity-Based Volume Rebate
10	MINBM	☑	MINBM	MENG13	QUAN	13	3	Minimum Purchase Order Quantity
11	NORBM	☑	NORBM	MENG13	QUAN	13	3	Standard Purchase Order Quantity
12	APLFZ	☑	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
13	UEBTO	☑	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
14	UEBTK	☑	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
15	UNTTO	☑	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
16	ANGNR	☑	ANGNR	ANGNR	CHAR	10	0	Quotation Number
17	ANGDT	☑	ANGDT	DATUM	DATS	8	0	Quotation Validity Date
18	ANFNR	☑	ANFNR	EBELN	CHAR	10	0	RFQ Number	EKKO
19	ANFPS	☑	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	EKPO
20	ABSKZ	☑	ABSKZ	XFELD	CHAR	1	0	Rejection Indicator
21	AMODV	☑	AMODV	DATUM	DATS	8	0	Amortization period from
22	AMODB	☑	AMODB	DATUM	DATS	8	0	Amortization period to
23	AMOBM	☑	AMOBM	MENG15	QUAN	15	3	Amortized planned quantity
24	AMOBW	☑	AMOBW	WERT15	CURR	15	2	Amortized planned value
25	AMOAM	☑	AMOAM	MENG15	QUAN	15	3	Amortized actual quantity
26	AMOAW	☑	AMOAW	WERT15	CURR	15	2	Amortized actual value
27	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
28	DATLB	☑	DATLB	DATUM	DATS	8	0	Date of Last PO or Sched. Agreement Document in Info Record
29	NETPR	☑	IPREI	WERT11	CURR	11	2	Net Price in Purchasing Info Record
30	PEINH	☑	EPEIN	DEC5	DEC	5	0	Price unit
31	BPRME	☑	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
32	PRDAT	☑	PRGBI	DATUM	DATS	8	0	Price Valid Until
33	BPUMZ	☑	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
34	BPUMN	☑	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
35	WEBRE	☑	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
36	LOEKZ	☑	ILOEE	XFELD	CHAR	1	0	Purch. info: Purch. organization data flagged for deletion
37	INFNR	☑	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
38	ESOKZ	☑	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
39	AMORS	☐	AMORS	XFELD	CHAR	1	0	Indicator: Amortization reset
40	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
41	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
42	MTXNO	☐	MTXNO	XFELD	CHAR	1	0	Material Master Record PO Text Not Relevant
43	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
44	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
45	EFFPR	☐	EFFPR	WERT11	CURR	11	2	Effective Price in Purchasing Info Record
46	EKKOL	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
47	SKTOF	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
48	KZABS	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
49	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
50	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
51	EBONU	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
52	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
53	EXPRF	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	T616
54	BSTAE	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	T163L
55	MEPRF	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
56	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
57	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
58	XERSN	☐	XERSN	XFELD	CHAR	1	0	No Evaluated Receipt Settlement (ERS)
59	EBON2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
60	EBON3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
61	EBONF	☐	EBONF	XFELD	CHAR	1	0	Item Not Relevant to Subseq. (Period-End Rebate) Settlement
62	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
63	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
64	BSTMA	☐	MAXBM	MENG13	QUAN	13	3	Maximum Purchase Order Quantity
65	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	RDPR
66	MEGRU	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group	TWMEG
67	J_1BNBM	☐	J_1BNBMCO1	STEUC	CHAR	16	0	Brazilian NCM Code	T604F

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5035	ANFNR	EKKO	EBELN	REF	1	N
2	ENT5035	ANFPS	EKPO	EBELP	REF	1	N
3	ENT5035	BPRME	T006	MSEHI	REF	1	CN
4	ENT5035	BSTAE	T163L	BSTAE	REF	1	CN
5	ENT5035	BWTAR	T149D	BWTAR	REF	1	N
6	ENT5035	EBELN	EKKO	EBELN	REF	1	N
7	ENT5035	EBELP	EKPO	EBELP	REF	1	N
8	ENT5035	EKGRP	T024	EKGRP	REF	1	1
9	ENT5035	EKORG	T024E	EKORG	KEY	1	1
10	ENT5035	EVERS	T027A	EVERS	REF	1	N
11	ENT5035	EXPRF	T616	EXPRF	REF	1	CN
12	ENT5035	INCO1	TINC	INCO1	REF	1	N
13	ENT5035	INFNR	EINA	INFNR	KEY	1	CN
14	ENT5035	J_1BNBM	T604F	STEUC
15	ENT5035	LIFNR	LFA1	LIFNR	REF	1	CN
16	ENT5035	MANDT	T000	MANDT	KEY	1	1
17	ENT5035	MATALLGNR	MARA	MATNR	REF	1	CN
18	ENT5035	MEGRU	TWMEG	MEGRU	KEY	C	CN
19	ENT5035	MWSKZ	T007A	MWSKZ	KEY	1	CN
20	ENT5035	RDPRF	RDPR	RDPRF	KEY	C	CN
21	ENT5035	VERID	MKAL	VERID	REF	1	N
22	ENT5035	WAERS	TCURC	WAERS	REF	1	1
23	ENT5035	WERKS	T001W	WERKS	KEY	1	1

History

Last changed by/on	SAP	20130529
SAP Release Created in