PSHLP_ALV_MATERIAL_ST SAP (Material ALV UI) Structure details

Dictionary Type: Structure
Description: Material ALV UI




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




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

PSHLP_ALV_MATERIAL_ST 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 "Material ALV UI" 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_PSHLP_ALV_MATERIAL_ST TYPE PSHLP_ALV_MATERIAL_ST.

The PSHLP_ALV_MATERIAL_ST table consists of various fields, each holding specific information or linking keys about Material ALV UI data available in SAP. These include MATNR (Material Number), WERKS (Plant), MENGE (Requirement quantity of the component), EINHEIT (Base Unit of Measure).. 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 (Deep)


SAP PSHLP_ALV_MATERIAL_ST 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
POSNRBOM item number APOSNCHAR4NUMCVSPOSN
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MENGERequirement quantity of the component CO_MENGEQUAN13(3) MENGV13
EINHEITBase Unit of Measure MEINSUNIT3T006CUNITMEINS
MFLICProcurement indicator CN_MFLICCHAR3TCNMFCN_MFLIC
POSTPItem Category (Bill of Material) POSTPCHAR1T418POSTP
AUDISPReservation Relevance/Generation of Purchase Requisition AUDISP_PLUSCHAR1AUDISP
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
SERNRBOM explosion number SERNRCHAR8SNUMSERNR
MATXTMaterial Description (Short Text) MAKTXCHAR40TEXT40
SORTFSort String SORTPCHAR10CHAR10
BDTERRequirement Date for the Component BDTERDATS8DATUM
SCHED_STARTScheduling aligned with activity start date SCHED_STARTCHAR1XFELD
SCHED_ENDScheduling aligned with activity finish date SCHED_ENDCHAR1XFELD
KZMPFManual Maintenance of Requirement Date KZMPFCHAR1XFELD
NLFZVLead-time offset for operation CS_NLFZVDEC3NLFZT
NLFMVUnit for lead-time offset for operation CS_NLFMVUNIT3T006CUNITMEINS
VERTIMRP Distribution Key SA_VERTLCHAR4T437VSA_VERTL
INFNRNumber of Purchasing Info Record INFNRCHAR10EINAALPHAINFNRINFMEIN_C
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
GRP_INDCollective Purchase Requisition Indicator PS_GRP_INDCHAR20Assigned to domainPS_GRP_IND
LTEXTLong Text Exists AUFLTEXTCHAR1XFELD
PSPELWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
KDAUFSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
ASSEMBLYMaterial number of higher-level assembly BAUGRCHAR18Assigned to domainMATN1MATNR
STLTYBOM category STLTYCHAR1STLTY
MAINBOMAssembly BAGRPCHAR18Assigned to domainMATN1MATNR
MAINTYBOM category STLTYCHAR1STLTY
BRTDATEFixed key date BRUTRDATS8DATUM
SANKAIndicator for Relevancy to Costing CK_SELKZCHAR1TCK08CK_SELKZ
KZEKLIndicator: Unit costing exists KZEKLCHAR1XFELD
KZFIXIndicator: Purchasing info record data are fixed CN_KZFIXCHAR1XFELD
XWAOKGoods Movement for Reservation Allowed XWAOKCHAR1XFELD
KZEARFinal Issue for This Reservation KZEARCHAR1XFELD
SCHGTIndicator: Bulk Material SCHGTCHAR1XFELD
RGEKZIndicator: Backflush RGEKZCHAR1XFELD
VORABInd: Preliminary order VORABKZCHAR1XFELD
STRECKEInd.: Third-party requisition STRECKECHAR1XFELD
XFEHLMissing Part XFEHLCHAR1XFELD
FLG_PURSIndicator: Purchase order exists FLG_PURSCHAR1KREUZ
KZKFGConfigurable Material KZKFGCHAR1XFELD
DUMPSPhantom item indicator DUMPSCHAR1XFELD
KZAUSDiscontinuation type AUSLFCHAR1AUSLF
ALPOSAlternative item indicator ALTPSCHAR1XFELD
SPLKZBatch key CHSPLITCHAR1CHSPLIT
CHARGBatch Number CHARG_DCHAR10MCHACHARGCHA
PRCTYPEProcurement Type NW_PRCTYPECHAR40TEXT40
XLOEKItem is Deleted XLOEKCHAR1XFELD
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
ENMNGQuantity Withdrawn ENMNGQUAN13(3) MENG13
FLMNGShortfall quantity of the component in the order FLMNGQUAN13(3) MENG13
VMENGConfirmed quantity for availability check in SKU VMENGQUAN15(3) MENG15
WEMNG_CMPQuantity of Goods Received WEMNGQUAN13(3) MENG13
TECHSParameter Variant/Standard Variant TECHSCHAR12TECHS
CELLTAB 0
COLOR_TAB 0
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR

Key field Non-key field



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

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

How to access SAP table PSHLP_ALV_MATERIAL_ST

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