SAP ABAP Table UAB_S_INFOREC_DATA (Purchasing Info Records from R/3 (Extendable))

Hierarchy

☛ SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
   ⤷ FIN-BA (Application Component) Business Analytics
     ⤷ UA_COCO_ADAPTER (Package) Concurrent Costing: Adapter for Satellite Systems

Basic Data

Table Category	INTTAB	Structure
Structure	UAB_S_INFOREC_DATA	Table Relationship Diagram
Short Description	Purchasing Info Records from R/3 (Extendable)

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	.INCLUDE	☐				0	0	Temporary: Mass Import: Info Record Container
2	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
3	MAT_GRP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
4	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
5	SHORT_TEXT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
6	SORTED_BY	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
7	PO_UNIT	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
8	VEND_MAT	☐	IDNLF22	IDNEX22	CHAR	22	0	Material number used by vendor
9	SALES_PERS	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
10	TELEPHONE	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
11	REMINDER1	☐			DEC	3	0
12	REMINDER2	☐			DEC	3	0
13	REMINDER3	☐			DEC	3	0
14	CERT_NO	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
15	CERT_VALID	☐	DATS	DATS	DATS	8	0	Field of type DATS
16	CERT_CTRY	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
17	CERT_TYPE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
18	CUST_NO	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
19	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
20	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
21	VAR_ORD_UN	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
22	VEND_PART	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
23	SORT_NO	☐			NUMC	5	0
24	VEND_MATG	☐	CHAR18	CHAR18	CHAR	18	0	Field length 18
25	BACK_AGREE	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
26	SUPPL_FROM	☐	DATS	DATS	DATS	8	0	Field of type DATS
27	SUPPL_TO	☐	DATS	DATS	DATS	8	0	Field of type DATS
28	PRE_VENDOR	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
29	POINTS	☐			QUAN	13	0
30	POINT_UNIT	☐			UNIT	3	0
31	NORM_VEND	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
32	PO_UNIT_ISO	☐	BSTME_ISO	ISOCD_UNIT	CHAR	3	0	Order unit in ISO code	*
33	BASE_UOM_ISO	☐	MEINS_ISO	ISOCD_UNIT	CHAR	3	0	Base unit of measure in ISO code	*
34	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
35	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
36	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
37	.INCLUDE	☐				0	0	Temporary: Info Record
38	INFO_REC	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
39	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
40	INFO_TYPE	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
41	PLANT	☐	EWERK	WERKS	CHAR	4	0	Plant	*
42	DELETE_IND	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
43	CREATED_AT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
44	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
45	PUR_GROUP	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
46	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
47	BONUS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
48	BONUS_QTY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
49	MIN_PO_QTY	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
50	NRM_PO_QTY	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
51	PLND_DELRY	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
52	OVERDELTOL	☐	DEC03	DEC03	DEC	3	0	General work field with a length of 3 spaces
53	UNLIMITED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
54	UNDER_TOL	☐	DEC03	DEC03	DEC	3	0	General work field with a length of 3 spaces
55	QUOTATION	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
56	QUOT_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
57	RFQ_NO	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
58	RFQ_ITEM	☐	NUMC05	NUMC5	NUMC	5	0	Numeric field length 5
59	RFQ_CANC	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
60	AMORT_FROM	☐	DATS	DATS	DATS	8	0	Field of type DATS
61	AMORT_TO	☐	DATS	DATS	DATS	8	0	Field of type DATS
62	AMORT_QTY	☐			QUAN	15	0
63	AMORT_VAL	☐			DEC	23	0
64	AMORT_TQTY	☐			QUAN	15	0
65	AMORT_TVAL	☐			DEC	23	0
66	AMORT_RES	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
67	DOC_CAT	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
68	PO_NUMBER	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
69	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
70	LAST_PO	☐	DATS	DATS	DATS	8	0	Field of type DATS
71	NET_PRICE	☐			DEC	23	4
72	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
73	ORDERPR_UN	☐			UNIT	3	0
74	PRICE_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
75	CONV_NUM1	☐			DEC	5	0
76	CONV_DEN1	☐			DEC	5	0
77	NO_MATTEXT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
78	GR_BASEDIV	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
79	EFF_PRICE	☐			DEC	23	4
80	COND_GROUP	☐	CHAR04	CHAR4	CHAR	4	0	Data Type 4 Characters
81	NO_DISCT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
82	ACKN_REQD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
83	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
84	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
85	BON_GRP1	☐			CHAR	2	0
86	SHIPPING	☐			CHAR	2	0
87	EXP_IMP_P	☐			CHAR	5	0
88	CONF_CTRL	☐			CHAR	4	0
89	PRICEDATE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
90	INCOTERMS1	☐			CHAR	3	0
91	INCOTERMS2	☐			CHAR	28	0
92	NO_AUT_GR	☐			CHAR	1	0
93	BON_GRP2	☐			CHAR	2	0
94	BON_GRP3	☐			CHAR	2	0
95	NO_BON_ITM	☐			CHAR	1	0
96	MINREMLIFE	☐			DEC	4	0
97	VERSION	☐	VERID	VERID	CHAR	4	0	Production Version	*
98	MAX_PO_QTY	☐			QUAN	13	0
99	ROUND_PROF	☐			CHAR	4	0
100	UNIT_GROUP	☐			CHAR	4	0
101	BRAS_NBM	☐			CHAR	16	0
102	CURRENCY_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
103	ORDERPR_UN_ISO	☐			CHAR	3	0
104	ORIGIN_GROUP	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
105	DELCS	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')

History

Last changed by/on	SAP	20130529
SAP Release Created in	600