ISH_PICKLIST_ITEM SAP (IS-H: Pick List Item) Structure details
Dictionary Type: Structure
Description: IS-H: Pick List Item
Description: IS-H: Pick List Item
ABAP Code to SELECT data from ISH_PICKLIST_ITEM
Related tables to ISH_PICKLIST_ITEM
Access table ISH_PICKLIST_ITEM
Related tables to ISH_PICKLIST_ITEM
Access table ISH_PICKLIST_ITEM
Structure field list including key, data, relationships and ABAP select examples
ISH_PICKLIST_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 "IS-H: Pick List Item" 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_ISH_PICKLIST_ITEM TYPE ISH_PICKLIST_ITEM.
The ISH_PICKLIST_ITEM table consists of various fields, each holding specific information or linking keys about IS-H: Pick List Item data available in SAP. These include RSPOS (Item Number of Reservation/Dependent Requirement), USNAM (User Name), VERFU (Availability of Material), KOSTL (Cost Center).. 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 ISH_PICKLIST_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 |
| RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
| RSPOS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
| USNAM | User Name | ISH_USNAM | CHAR | 12 | Assigned to domain | XUBNAME | |||
| VERFU | Availability of Material | ISH_VERFU | CHAR | 4 | Assigned to domain | ICON | |||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
| KTEXT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
| WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| KZEAR | Final Issue for This Reservation | KZEAR | CHAR | 1 | XFELD | ||||
| AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
| MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
| MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| MTEXT | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
| LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
| LTEXT | Description of Storage Location | LGOBE | CHAR | 16 | TEXT16 | ||||
| LOPOS | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
| LGPLA | Storage Bin | LGPLA | CHAR | 10 | Assigned to domain | LGPLA | LGP | LAG1 | |
| XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
| CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
| BDTER | Requirement Date for the Component | BDTER | DATS | 8 | DATUM | ||||
| BDMNG | Requirement Quantity | BDMNG | QUAN | 13(3) | MENG13 | ||||
| ENMNG | Quantity Withdrawn | ENMNG | QUAN | 13(3) | MENG13 | ||||
| DIMNG | Difference Quantity Pick List | ISH_DIMNG | QUAN | 13(3) | MENG13 | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| VMENG | Available Quantity of a Material | ISH_VMENG | QUAN | 13(3) | MENG13 | ||||
| VMEIN | Unit of Measure of Available Quantity | ISH_VMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| KOMNG | Picked Quantity | ISH_KOMNG | QUAN | 13(3) | MENG13 | ||||
| KOMEI | Unit of Measure of Picked Quantity | ISH_KOMEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| WAUSG | Checkbox 'Goods issue' | ISH_WAUSG | CHAR | 1 | CHAR1 | ||||
| ENTKO | 'Final Issue' Checkbox | ISH_ENTKO | CHAR | 1 | CHAR1 | ||||
| EXPRE | Express indicator pick list | ISH_EXPRE | CHAR | 1 | CHAR1 | ||||
| ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13(3) | MENG13 | ||||
| ERFME | Unit of Entry | ERFME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| VISIBLE | IS-H: Boolean Data Type for TRUE (='1') and FALSE (='0') | ISH_TRUE_FALSE | CHAR | 1 | ISH_TRUE_FALSE | ||||
| SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
| AVAIL | Availability Indicator | 0 | |||||||
| VERFU_TXT | Availability of Material | ISH_VERFU_TXT | CHAR | 20 | TEXT20 | ||||
| HIDE | IS-H: Boolean Data Type for ON (= 'X') and OFF (= ' ') | ISH_ON_OFF | CHAR | 1 | ISH_ON_OFF | ||||
| NOPRINT | IS-H: Boolean Data Type for ON (= 'X') and OFF (= ' ') | ISH_ON_OFF | CHAR | 1 | ISH_ON_OFF | ||||
| KOMNG_MEINS | Picked Quantity | ISH_KOMNG | QUAN | 13(3) | MENG13 | ||||
| ALV_KEY | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
| LINE | Vertical Cursor Position | SYCUROW | INT4 | 10 | SYST_SHORT | ||||
| GSMNG | All Requisitions for this Material | 0 | |||||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
| ABLAD | IS-H: Unloading Point | ISH_MABLAD | CHAR | 25 | TEXT25 | ||||
| SIGN_ICON | IS-H: Icon for Digital Signature Status | ISH_MM_SIGN_ICON | CHAR | 100 | |||||
| MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
| WEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | WEMPF | ||||
| VFDAT | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8 | DATUM | ||||
| GENAM | IS-H MM: Name of Approval Giver | ISH_MGENAM | CHAR | 12 | USNAM | ||||
| GEDAT | IS-H MM: Date of Approval | ISH_MGEDAT | DATS | 8 | RI_DATUM | ||||
| PRIO_URG | IS-H-MM: Requirement Urgency | ISH_PRIO_URG | NUMC | 2 | Assigned to domain | PRIO_URG | |||
| PRIO_REQ | IS-H-MM: Requirement Priority | ISH_PRIO_REQ | NUMC | 3 | Assigned to domain | PRIO_REQ |
| Key field | Non-key field |
How do I retrieve data from SAP structure ISH_PICKLIST_ITEM using ABAP code?
As ISH_PICKLIST_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 ISH_PICKLIST_ITEM as there is no data to select.How to access SAP table ISH_PICKLIST_ITEM
Within an ECC or HANA version of SAP you can also view further information about ISH_PICKLIST_ITEM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects