SAP ABAP Table /SRMERP/SQ_SC_ITM_POWL_ESS (Selection criteria 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/SQ_SC_ITM_POWL_ESS	Table Relationship Diagram
Short Description	Selection criteria 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	CREA_DATE_UI	☐			DATS	8	0
32	CREA_UNAME_H	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
33	LCHG_DATE_UI_I	☐			DATS	8	0
34	PUR_REQ_NUM	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
35	PUR_REQ_ITM	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
36	RES_NUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
37	RES_ITM	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
38	PR_HELD	☐	FLAG	FLAG	CHAR	1	0	General Flag
39	PO_HELD	☐	FLAG	FLAG	CHAR	1	0	General Flag

History

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