/SRMERP/SQ_SC_ITM_POWL_ESS SAP (Selection criteria for ESS POWL Item Query) Structure details

Dictionary Type: Structure
Description: Selection criteria for ESS POWL Item Query




ABAP Code to SELECT data from /SRMERP/SQ_SC_ITM_POWL_ESS
Related tables to /SRMERP/SQ_SC_ITM_POWL_ESS
Access table /SRMERP/SQ_SC_ITM_POWL_ESS




Structure field list including key, data, relationships and ABAP select examples

/SRMERP/SQ_SC_ITM_POWL_ESS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Selection criteria for ESS POWL Item Query" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_/SRMERP/SQ_SC_ITM_POWL_ESS TYPE /SRMERP/SQ_SC_ITM_POWL_ESS.

The /SRMERP/SQ_SC_ITM_POWL_ESS table consists of various fields, each holding specific information or linking keys about Selection criteria for ESS POWL Item Query data available in SAP. These include TXZ01 (Short Text), MENGE (Purchase Requisition Quantity), MEINS (Purchase Requisition Unit of Measure), NETWR (Net Value in Document Currency).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP /SRMERP/SQ_SC_ITM_POWL_ESS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
OBJECT_IDObject ID - Document Number /SRMERP/OBJECT_IDCHAR10/SRMERP/OBJECT_ID
TXZ01Short Text TXZ01CHAR40TEXT40
MENGEPurchase Requisition Quantity BAMNGQUAN13(3) MENG13
MEINSPurchase Requisition Unit of Measure BAMEIUNIT3Assigned to domainCUNITMEINS
NETWRNet Value in Document Currency NETWRCURR15(2) WERTV8
WAERS_ICurrency /SRMERP/CURRENCYCUKY5Assigned to domainWAERS
ITM_LIFEC_STATUSLife Cycle of Shopping Cart Item /SRMERP/SC_STATUS_ITM_LIFE_CYCCHAR2/SRMERP/SC_STATUS_ITM_LIFE_CYC
LFDATDelivery date LFDATDATS8DATUM
CREA_DATE_TIME_IUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
ITM_NOInternal Shopping Cart Item Number /SRMERP/SC_ITM_NOINT410INT4
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
NETPRNet Price in Purchasing Document (in Document Currency) BPREICURR11(2) WERT11
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
EKGRPPurchasing Group EKGRPCHAR3Assigned to domainEKGRPEKG
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
FLIEFFixed Vendor FLIEFCHAR10Assigned to domainALPHALIFNR
SRM_CONTRACT_IDCentral Contract SRM_CONTRACT_IDCHAR10ALPHABBP_BAPI_EBELNMMBSI_MEKK_CC
SRM_CONTRACT_ITMCentral Contract Item Number SRM_CONTRACT_ITEMNUMC10BBP_ITEMNO
LIFNRDesired Vendor WLIEFCHAR10Assigned to domainALPHALIFNR
INFNRNumber of Purchasing Info Record INFNRCHAR10Assigned to domainALPHAINFNRINFMEIN_C
KONNRNumber of Principal Purchase Agreement KONNRCHAR10Assigned to domainALPHAEBELNKTR
KTPNRItem Number of Principal Purchase Agreement KTPNRNUMC5Assigned to domainEBELP
APPROVAL_STAT_IApproval Status /SRMERP/STATUS_APPROVALCHAR2/SRMERP/STATUS_APPROVAL
DELIVERY_STAT_IDelivery Status /SRMERP/STATUS_DELIVERYCHAR2/SRMERP/STATUS_DELIVERY
CONSIST_STAT_IConsistency Status /SRMERP/STATUS_CONSISTENCYCHAR2/SRMERP/STATUS_CONSISTENCY
FOLLOW_ON_STAT_IFollow-On Status /SRMERP/STATUS_FOLLOW_ONCHAR2/SRMERP/STATUS_FOLLOW_ON
CANCELATN_STAT_ICancelation Status /SRMERP/STATUS_CANCELATIONCHAR2/SRMERP/STATUS_CANCELATION
LCHG_DATE_TIME_IUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
CREA_DATE_UI 0
CREA_UNAME_HUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
LCHG_DATE_UI_I Changed On0
PUR_REQ_NUMPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
PUR_REQ_ITMItem Number of Purchase Requisition BNFPONUMC5Assigned to domainBNFPOBAP
RES_NUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RES_ITMItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
PR_HELDGeneral Flag FLAGCHAR1FLAG
PO_HELDGeneral Flag FLAGCHAR1FLAG

Key field Non-key field



How do I retrieve data from SAP structure /SRMERP/SQ_SC_ITM_POWL_ESS using ABAP code?

As /SRMERP/SQ_SC_ITM_POWL_ESS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SRMERP/SQ_SC_ITM_POWL_ESS as there is no data to select.

How to access SAP table /SRMERP/SQ_SC_ITM_POWL_ESS

Within an ECC or HANA version of SAP you can also view further information about /SRMERP/SQ_SC_ITM_POWL_ESS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!