WISO_ITEM SAP (SAP Retail Store: IAC Consumer Order. Subscr. Item Display) Structure details

Dictionary Type: Structure
Description: SAP Retail Store: IAC Consumer Order. Subscr. Item Display




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




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

WISO_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 "SAP Retail Store: IAC Consumer Order. Subscr. Item Display" 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_WISO_ITEM TYPE WISO_ITEM.

The WISO_ITEM table consists of various fields, each holding specific information or linking keys about SAP Retail Store: IAC Consumer Order. Subscr. Item Display data available in SAP. These include ITM_NUMBER (Sales Document Item), PO_ITM_NO (SAP Retail Store Sales Order: Handle Sales Document Item), MATERIAL (Material Number), SHORT_TEXT (Short text for sales order item).. 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 WISO_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
ITM_NUMBERSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
PO_ITM_NOSAP Retail Store Sales Order: Handle Sales Document Item W_WISO_HANDLE_POSEXCHAR6ALPHAPOSEX
MATERIALMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
SHORT_TEXTShort text for sales order item ARKTXCHAR40TEXT40
UNITUnit of Measure for Display MEINHUNIT3Assigned to domainCUNITMEINS
QUAN_REQQuantity MENGE_DQUAN13(3) MENG13
QUAN_AVAILQuantity MENGE_DQUAN13(3) MENG13
PRICE_ITM_SUMSAP Retail Store Sales Order: Item Value W_WISO_PRICE_ITM_SUMCURR15(2) WERTV8
CURRSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
NET_VALUENet value of the order item in document currency NETWR_APCURR15(2) WERTV8
TAX_AMOUNTTax amount in document currency MWSBPCURR13(2) WERTV7
DLV_DATESchedule line date EDATUDATS8DATUM
NUMB_DLVSSAP Store Order: Number of delivery schedules/deliveries W_NUMB_DLVSNUMC4NUMC4
PLANT_DLVPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
REA_FOR_REReason for rejection of quotations and sales orders ABGRU_VACHAR2Assigned to domainABGRU_VA
REL_FOR_BIRelevant for Billing FKRELCHAR1FKREL
.INCLU--AP 0
HG_LV_ITEMHigher-level item in bill of material structures UEPOSNUMC6Assigned to domainPOSNR
UNAVAIL_FLAGCheckbox XFELDCHAR1XFELD
THIRD_PTYIndicates direct delivery W_THIRD_PTYCHAR1XFELD
NAME_PLANT_DLVName 1 AD_NAME1CHAR40TEXT40
CITY_PLANT_DLVCity AD_CITY1CHAR40TEXT40CLCITYNAME
ITEM_CATEGSales document item category PSTYVCHAR4Assigned to domainPSTYV
PO_ITEM_CATItem Category in Purchasing Document PSTYPCHAR1Assigned to domainPSTYP
PO_ITEM_CAT_DESCText for Item Category PTEXT_DCHAR20TEXT20
REA_FOR_RE_DESCRDescription BEZEI40CHAR40TEXT40
MSG_FLAGCheckbox XFELDCHAR1XFELD
.INCLU--AP 0
MAT_ID_INPUTSAP Retail Store: Store Order: Material Identifier W_WISO_MAT_ID_INPUTCHAR40W_WISO_MAT_ID_INPUT
EAN_UPCInternational Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
T184_KEYField of length 16 CHAR16CHAR16CHAR16
ITMCAT_MANUALCheckbox XFELDCHAR1XFELD
ITEM_CATEG_DESCRDescription BEZEI20CHAR20TEXT20
DLV_CLLCTIndicates delivery/ collection W_DLV_CLLCTCHAR1CHAR01
DLV_CLLCT_MANUALCheckbox XFELDCHAR1XFELD
SHIP_POINTShipping Point/Receiving Point VSTELCHAR4Assigned to domainVSTELVST
DLV_GROUPDelivery group (items are delivered together) GRKORNUMC3GRKOR
PLANT_MANUALCheckbox XFELDCHAR1XFELD
MARKEDCheckbox XFELDCHAR1XFELD
QUAN_REF_OPENOpen reference quantity ORFMNGQUAN13(3) MENG13
REA_RE_MANUALCheckbox XFELDCHAR1XFELD
ITEM_CATEG_AUTOSales document item category PSTYVCHAR4Assigned to domainPSTYV
ITEM_CATItem category group from material master MTPOSCHAR4Assigned to domainMTPOS
SCHED_TYPESchedule line category ETTYPCHAR2Assigned to domainETTYP
INCO1Incoterms (Part 1) INCO1CHAR3Assigned to domainINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
EXISTS_IN_DBCheckbox XFELDCHAR1XFELD
MAT_ENTRDMaterial entered MATWACHAR18Assigned to domainMATN1MATNRMAT
.INCLU--AP 0
REF_DOCDocument number of the reference document VGBELCHAR10Assigned to domainALPHAVBELN
REF_DOC_ITItem number of the reference item VGPOSNUMC6Assigned to domainPOSNR
SUBTOTAL_1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
SUBTOTAL_2Subtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
SUBTOTAL_3Subtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
SUBTOTAL_4Subtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
SUBTOTAL_5Subtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
SUBTOTAL_6Subtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
BOM_NOBill of material STNUMCHAR8NUMCVSTNUMSTLNR
ITUSAGEIDID for higher-level item usage UEPVWCHAR1UEPVW
AUTO_GENERATEDCheckbox XFELDCHAR1XFELD
QUAN_REQ_ORIGQuantity MENGE_DQUAN13(3) MENG13
MATDETERIDID for material determination PROSACHAR1PROSA
SUBSTREASONReason for material substitution SUGRDCHAR4Assigned to domainSUGRDVDG
CONSUMPTConsumption Posting KZVBRCHAR1KZVBR
WBS_ELEMWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
ITMCAT_ACCPTCheckbox XFELDCHAR1XFELD
SCHEDTYP_ACCPTCheckbox XFELDCHAR1XFELD
BILL_BLOCKBilling block for item FAKSP_APCHAR2Assigned to domainFAKSP
DUMMY_FIELDDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



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

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

How to access SAP table WISO_ITEM

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