WSAM_SHMAE_ITEM SAP (Fields of items in search result table) Structure details

Dictionary Type: Structure
Description: Fields of items in search result table




ABAP Code to SELECT data from WSAM_SHMAE_ITEM
Related tables to WSAM_SHMAE_ITEM
Access table WSAM_SHMAE_ITEM




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

WSAM_SHMAE_ITEM 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 "Fields of items in search result table" 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_WSAM_SHMAE_ITEM TYPE WSAM_SHMAE_ITEM.

The WSAM_SHMAE_ITEM table consists of various fields, each holding specific information or linking keys about Fields of items in search result table data available in SAP. These include CBP_NUM (Number of the item), MARKED (Checkbox), SHOW_CBP (Checkbox), IS_CBP (Checkbox).. 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 WSAM_SHMAE_ITEM 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
NUMNumber of the item WSAM_SHMAE_NUMNUMC6
CBP_NUMNumber of the item WSAM_SHMAE_NUMNUMC6
MARKEDCheckbox XFELDCHAR1XFELD
SHOW_CBPCheckbox XFELDCHAR1XFELD
IS_CBPCheckbox XFELDCHAR1XFELD
COMPLETEDCheckbox XFELDCHAR1XFELD
CBP_ITEMS_CONSTRUCTEDCheckbox XFELDCHAR1XFELD
QUANTITYQuantity entered in the enhanced material search WSAM_SHMAE_QUANTITYQUAN13(3) MENG13
QUANTITY_CHARSAP Retail Store: Quantity Field CHAR 10 WSAM_SHMAE_QTY_CHARCHAR10
QTY_UNITSales unit VRKMEUNIT3Assigned to domainCUNITMEINS
UNRESTRICTED_QUANValuated Unrestricted-Use Stock LABSTQUAN13(3) MENG13V
POS_QUANValuated Unrestricted-Use Stock LABSTQUAN13(3) MENG13V
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
REC_REQD_QTYQuantity received or quantity required MNG01QUAN13(3) MENGV13
SALES_UNITSales unit VRKMEUNIT3Assigned to domainCUNITMEINS
UNRES_MSG_INDSingle-Character Indicator CHAR1CHAR1CHAR1
UNRES_MESSAGESAP Retail Store: Text Field for Description (40 Characters) WSRS_DESCR_40CHAR40WSRS_DESCR_40
ATP_MSG_INDSingle-Character Indicator CHAR1CHAR1CHAR1
ATP_MESSAGESAP Retail Store: Text Field for Description (40 Characters) WSRS_DESCR_40CHAR40WSRS_DESCR_40
REC_REQD_QTY_ALTATP qty in alternative unit of measure WSAM_SHMAE_REC_REQD_QTY_ALTQUAN13(3) MENGV13
UNRES_QUAN_ALTUnrestricted qty in alternative unit of measure WSAM_SHMAE_UNRES_QUAN_ALTQUAN13(3) MENGV13
QTY_UNIT_ALTSales unit VRKMEUNIT3Assigned to domainCUNITMEINS
DLV_PLANT_INDDefault delivering plant indicator WSAM_SHMAE_DLV_PLANT_INDCHAR1WSAM_SHMAE_DLV_PLANT_IND
OWN_PLANT_INDOwn Plant delivery Indicator WSAM_SHMAE_OWN_PLANT_INDCHAR1XFELD
MAT_KEYLong material number for SAP Retail Store WSRS_MAT_KEYCHAR40WSRS_MAT_KEY
MATERIALMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
EAN_UPCInternational Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
VEND_MATMaterial Number Used by Vendor IDNLFCHAR35IDNEX
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
BISMTOld material number BISMTCHAR18BISMT
NUMTPCategory of International Article Number (EAN) NUMTPCHAR2Assigned to domainNUMTP
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SALES_PRICESales price WSAM_SHMAE_SALES_PRICECURR11(2) WERTV6
SP_CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
SP_PRICE_QTYCondition pricing unit KPEINDEC5KPEIN
SP_UNITSales unit VRKMEUNIT3Assigned to domainCUNITMEINS
PROM_PRICEPromotion price WSAM_SHMAE_PROM_PRICECURR11(2) WERTV6
PP_CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
PP_PRICE_QTYCondition pricing unit KPEINDEC5KPEIN
PP_UNITSales unit VRKMEUNIT3Assigned to domainCUNITMEINS
PP_VALID_TOField of type DATS DATSDATS8DATS
IS_PROM_PRICECheckbox XFELDCHAR1XFELD
PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
PLANT_NAMEName 1 AD_NAME1CHAR40TEXT40
MAINTAINEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
PAGENatural Number INT4INT410INT4
PREV_PAGE_INDCheckbox XFELDCHAR1XFELD
NEXT_PAGE_INDCheckbox XFELDCHAR1XFELD
CBP_NUM_MAINTAINEDNatural Number INT4INT410INT4
WAARTIndicates that material is a value-only material WAARTCHAR1XFELD
FILTER_PASSEDCheckbox XFELDCHAR1XFELD
LISTEDCheckbox XFELDCHAR1XFELD
INDEX_MT_PLANTNatural Number INT4INT410INT4
AUTH_SALES_PRICECheckbox XFELDCHAR1XFELD
AUTH_PROM_PRICECheckbox XFELDCHAR1XFELD
AUTH_RUL_PRICECheckbox XFELDCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure WSAM_SHMAE_ITEM using ABAP code?

As WSAM_SHMAE_ITEM 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 WSAM_SHMAE_ITEM as there is no data to select.

How to access SAP table WSAM_SHMAE_ITEM

Within an ECC or HANA version of SAP you can also view further information about WSAM_SHMAE_ITEM 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!