WSPO_ITEM SAP (SAP Retail Store PO: Item Data) Structure details

Dictionary Type: Structure
Description: SAP Retail Store PO: Item Data




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




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

WSPO_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 PO: Item Data" 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_WSPO_ITEM TYPE WSPO_ITEM.

The WSPO_ITEM table consists of various fields, each holding specific information or linking keys about SAP Retail Store PO: Item Data data available in SAP. These include HL_ITEM (Higher-Level Item in Purchasing Documents), DELETE_IND (Deletion Indicator in Purchasing Document), EXISTS_IN_DB (Checkbox), ITEM_CAT (Item Category in Purchasing Document).. 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 WSPO_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
PO_ITEMItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
HL_ITEMHigher-Level Item in Purchasing Documents UEBPONUMC5Assigned to domainEBELP
DELETE_INDDeletion Indicator in Purchasing Document ELOEKCHAR1ELOEK
EXISTS_IN_DBCheckbox XFELDCHAR1XFELD
ITEM_CATItem Category in Purchasing Document PSTYPCHAR1Assigned to domainPSTYP
ITEM_CAT_DESCRText for Item Category PTEXT_DCHAR20TEXT20
SI_CATSubitem Category, Purchasing Document UPTYPCHAR1Assigned to domainUPTYP
RET_ITEMReturns Item RETPOCHAR1XFELD
NO_MORE_GR'Delivery Completed' Indicator ELIKZCHAR1XFELD
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
EAN_UPC_MANUALCheckbox XFELDCHAR1XFELD
VEND_MATMaterial Number Used by Vendor IDNLFCHAR35IDNEX
MAT_KEY_TYPED_INCheckbox XFELDCHAR1XFELD
MAT_KEY_MISSINGCheckbox XFELDCHAR1XFELD
SHORT_TEXTShort Text TXZ01CHAR40TEXT40
PLANTPlant EWERKCHAR4Assigned to domainWERKSWRK
PLANT_NAME1Name 1 AD_NAME1CHAR40TEXT40
PLANT_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
QUANTITYPurchase Order Quantity BSTMGQUAN13(3) MENG13
QUANTITY_CHARSAP Retail Store: Quantity Field CHAR 17 WSRS_QTY_CHARCHAR17
QUANTITY_ORIGPurchase Order Quantity BSTMGQUAN13(3) MENG13
PO_UNITPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
PO_UNIT_CHARSAP Retail Store: Output Display of Unit of Measure WSRS_UNIT_CHARCHAR3
PO_UNIT_ORIGPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
QTY_GM_HISTQuantity MENGE_DQUAN13(3) MENG13
QTY_GMQuantity MENGE_DQUAN13(3) MENG13
QTY_GM_CHARSAP Retail Store: Quantity Field CHAR 17 WSRS_QTY_CHARCHAR17
OVER_DLV_TOLOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UNLIMITED_DLVIndicator: Unlimited Overdelivery Allowed UEBTKCHAR1XFELD
UNDER_DLV_TOLUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
DELIV_DATEItem Delivery Date EINDTDATS8DATUM
DELIV_DATE_CHARSAP Retail Store: Output Format of a Date WSRS_DATE_CHARCHAR10
DELIV_DATE_MANUALCheckbox XFELDCHAR1XFELD
NET_VALUENet Order Value in PO Currency BWERTCURR13(2) WERT7
GROSS_VALUEGross order value in PO currency BBWERTCURR13(2) WERT7
VALUESAP Retail Store: Value of Purchase Order Item WSPO_ITEM_VALUECURR13(2) WERT7
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
ORDER_REASONReason for Ordering BSGRUCHAR3BSGRU
ORDREA_DESCRSAP Retail Store: Text Field for Description (40 Characters) WSRS_DESCR_40CHAR40WSRS_DESCR_40
ORDREA_MANUALCheckbox XFELDCHAR1XFELD
NUMB_SCHED_LINESNatural Number INT4INT410INT4
DOC_NUMBER_SDSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
ITM_NUMBER_SDSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
MATL_CATMaterial Category ATTYPCHAR2ATTYPMTY
STATISTICItem is statistical STAPOCHAR1XFELD
SI_EXISTSubitems Exist UPVORCHAR1CHAR1
GR_INDGoods Receipt Indicator WEPOSCHAR1XFELD
IR_INDInvoice Receipt Indicator REPOSCHAR1XFELD
FINAL_INVFinal Invoice Indicator EREKZCHAR1XFELD
NO_ROUNDINGIndicator: suppress rounding in purchase order item NO_ROUNDINGCHAR1XFELD
MULTI_SCHED_OKCheckbox XFELDCHAR1XFELD
EAN_UPC_SLCTInternational Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
DUMMY_FIELDDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



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

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

How to access SAP table WSPO_ITEM

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