SAP ABAP Table /SRMERP/SQR_SC_ITM_POWL_ESS (Result data for ESS POWL Item Query)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR-SSP (Application Component) Self-Service Procurement
     ⤷ /SRMERP/CO_SC (Package) Shopping Cart Controller

Basic Data

Table Category	INTTAB	Structure
Structure	/SRMERP/SQR_SC_ITM_POWL_ESS	Table Relationship Diagram
Short Description	Result data for ESS POWL Item Query

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	OBJECT_ID	☐	/SRMERP/OBJECT_ID	/SRMERP/OBJECT_ID	CHAR	10	0	Object ID - Document Number
2	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
3	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
4	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	*
5	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
6	WAERS_I	☐	/SRMERP/CURRENCY	WAERS	CUKY	5	0	Currency	*
7	ITM_LIFEC_STATUS	☐	/SRMERP/SC_STATUS_ITM_LIFE_CYC	/SRMERP/SC_STATUS_ITM_LIFE_CYC	CHAR	2	0	Life Cycle of Shopping Cart Item
8	LFDAT	☐	LFDAT	DATUM	DATS	8	0	Delivery date
9	CREA_DATE_TIME_I	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
10	ITM_NO	☐	/SRMERP/SC_ITM_NO	INT4	INT4	10	0	Internal Shopping Cart Item Number
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
12	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
13	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
14	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
15	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
17	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
18	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	*
19	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
20	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
21	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	*
22	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
23	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
24	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
25	APPROVAL_STAT_I	☐	/SRMERP/STATUS_APPROVAL	/SRMERP/STATUS_APPROVAL	CHAR	2	0	Approval Status
26	DELIVERY_STAT_I	☐	/SRMERP/STATUS_DELIVERY	/SRMERP/STATUS_DELIVERY	CHAR	2	0	Delivery Status
27	CONSIST_STAT_I	☐	/SRMERP/STATUS_CONSISTENCY	/SRMERP/STATUS_CONSISTENCY	CHAR	2	0	Consistency Status
28	FOLLOW_ON_STAT_I	☐	/SRMERP/STATUS_FOLLOW_ON	/SRMERP/STATUS_FOLLOW_ON	CHAR	2	0	Follow-On Status
29	CANCELATN_STAT_I	☐	/SRMERP/STATUS_CANCELATION	/SRMERP/STATUS_CANCELATION	CHAR	2	0	Cancelation Status
30	LCHG_DATE_TIME_I	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
31	DB_KEY_H	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
32	DB_KEY_I	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
33	.INCLUDE	☐				0	0	Include Structure for Key Information
34	KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
35	PARENT_KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
36	ROOT_KEY	☐	/BOBF/CONF_KEY	/BOBF/CONF_KEY	RAW	16	0	NodeID
37	CREA_DATE_UI	☐			DATS	8	0
38	UNIT_PRICE	☐			SSTR	19	0
39	ORDER_QUANTITY	☐			SSTR	20	0
40	TOTAL_VALUE	☐			SSTR	26	0
41	DELETE_ALLOWED	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
42	DELETE	☐			SSTR	30	0
43	CANCEL_ALLOWED	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
44	CANCEL	☐			SSTR	30	0
45	NETFW	☐	NETFW	WERT7	CURR	13	2	Net Amount in Foreign Currency
46	COLOR	☐			STRG	0	0
47	LCHG_DATE_UI_I	☐			DATS	8	0
48	WERKS	☐	EWERKS	WERKS	CHAR	4	0	Plant for individual capacity	*
49	GSWRT	☐	GSWRT	WERT7	CURR	13	2	Total Value of Item
50	COLOR_APP	☐			STRG	0	0
51	COLOR_FOW	☐			STRG	0	0
52	COLOR_CONSIS	☐			STRG	0	0
53	CREA_UNAME_H	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
54	TOOLTIP	☐	POWL_TOOLT_TY		CHAR	100	0	Tooltip text

History

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