WSD_MS_RESULT_STY SAP (Material search result structure) Structure details

Dictionary Type: Structure
Description: Material search result structure




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




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

WSD_MS_RESULT_STY 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 search result structure" 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_WSD_MS_RESULT_STY TYPE WSD_MS_RESULT_STY.

The WSD_MS_RESULT_STY table consists of various fields, each holding specific information or linking keys about Material search result structure data available in SAP. These include MATNR (Material Number), ERSDA (Created On), ERNAM (Name of Person who Created the Object), LAEDA (Date of Last Change).. 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 WSD_MS_RESULT_STY 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
BASIC 0
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
ERSDACreated On ERSDADATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
LAEDADate of Last Change LAEDADATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
VPSTAMaintenance status of complete material VPSTACHAR15PSTAT
PSTATMaintenance status PSTAT_DCHAR15PSTAT
LVORMFlag Material for Deletion at Client Level LVOMACHAR1XFELD
MTARTMaterial Type MTARTCHAR4MTARTMTA
MBRSHIndustry sector MBRSHCHAR1MBRSHMTP
MATKLMaterial Group MATKLCHAR9MATKLMKLS_WBWG
BISMTOld material number BISMTCHAR18BISMT
MEINSBase Unit of Measure MEINSUNIT3CUNITMEINS
BSTMEPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
ZEINRDocument number (without document management system) DZEINRCHAR22CHAR22
ZEIARDocument type (without Document Management system) DZEIARCHAR3ZEIAR
ZEIVRDocument version (without Document Management system) DZEIVRCHAR2VERSI
ZEIFOPage format of document (without Document Management system) DZEIFOCHAR4DINFO
AESZNDocument change number (without document management system) AESZNCHAR6AENUM
BLATTPage number of document (without Document Management system) BLATTCHAR3BLATT
BLANZNumber of sheets (without Document Management system) BLANZNUMC3NUM3
FERTHProduction/inspection memo FERTHCHAR18FERTH
FORMTPage Format of Production Memo FORMTCHAR4DINFO
GROESSize/dimensions GROESCHAR32CHAR32
WRKSTBasic Material WRKSTCHAR48WRKST
NORMTIndustry Standard Description (such as ANSI or ISO) NORMTCHAR18NORMT
LABORLaboratory/design office LABORCHAR3LABOR
EKWSLPurchasing Value Key EKWSLCHAR4EKWSL
BRGEWGross Weight BRGEWQUAN13(3) MENG13
NTGEWNet Weight NTGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3CUNITMEINS
VOLUMVolume VOLUMQUAN13(3) MENG13
VOLEHVolume unit VOLEHUNIT3CUNITMEINS
BEHVOContainer requirements BEHVOCHAR2BEHVO
RAUBEStorage conditions RAUBECHAR2RAUBE
TEMPBTemperature conditions indicator TEMPBCHAR2TEMPB
DISSTLow-Level Code DISSTCHAR3DISST
TRAGRTransportation Group TRAGRCHAR4TRAGR
STOFFHazardous material number STOFFCHAR18MATN1STOFFSTO
SPARTDivision SPARTCHAR2SPARTSPAC_SPART
KUNNRCompetitor WETTBCHAR10ALPHAKUNNRKUN
EANNREuropean Article Number (EAN) - obsolete!!!!! EANNRCHAR13CHAR13EAN
WESCHQuantity: Number of GR/GI slips to be printed WESCHQUAN13(3) MENG13
BWVORProcurement rule BWVORCHAR1BWVOR
BWSCLSource of Supply BWSCLCHAR1BQSCL
SAISOSeason Category SAISOCHAR4SAISOSAISO
ETIARLabel type ETIARCHAR2ETIAR
ETIFOLabel form ETIFOCHAR2ETIFO
ENTARDeactivated DUMMYENTARCHAR1CHAR1
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
NUMTPCategory of International Article Number (EAN) NUMTPCHAR2NUMTP
LAENGLength LAENGQUAN13(3) MENG13
BREITWidth BREITQUAN13(3) MENG13
HOEHEHeight HOEHEQUAN13(3) MENG13
MEABMUnit of Dimension for Length/Width/Height MEABMUNIT3CUNITMEINS
PRDHAProduct hierarchy PRODH_DCHAR18PRODHVPR
AEKLKStock Transfer Net Change Costing CK_AEKLKCHAR1XFELD
CADKZCAD Indicator CADKZCHAR1XFELD
QMPURQM in Procurement is Active QMPURCHAR1XFELD
ERGEWAllowed packaging weight ERGEWQUAN13(3) MENG13
ERGEIUnit of weight (allowed packaging weight) ERGEIUNIT3CUNITMEINS
ERVOLAllowed packaging volume ERVOLQUAN13(3) MENG13
ERVOEVolume unit (allowed packaging volume) ERVOEUNIT3CUNITMEINS
GEWTOExcess Weight Tolerance for Handling unit GEWTODEC3(1) PRZ21
VOLTOExcess Volume Tolerance of the Handling Unit VOLTODEC3(1) PRZ21
VABMEVariable Purchase Order Unit Active VABMECHAR1VABME
KZREVRevision Level Has Been Assigned to the Material KZREVCHAR1XFELD
KZKFGConfigurable Material KZKFGCHAR1XFELD
XCHPFBatch management requirement indicator XCHPFCHAR1XFELD
VHARTPackaging Material Type VHIARTCHAR4TRATY
FUELGMaximum level (by volume) FUELGDEC3DEC3
STFAKStacking factor STFAKINT25INT2
MAGRVMaterial Group: Packaging Materials MAGRVCHAR4MAGRV
BEGRUAuthorization Group BEGRUCHAR4BEGRU
DATABValid-From Date DATABDATS8DATUM
LIQDTDeletion date LIQDTDATS8DATUM
SAISJSeason Year SAISJCHAR4GJAHRCJAHRWMSAISJ
PLGTPPrice Band Category PLGTPCHAR2PLGTP
MLGUTEmpties Bill of Material W_MITLEERGCHAR1FLAG
EXTWGExternal Material Group EXTWGCHAR18EXTWG
SATNRCross-Plant Configurable Material SATNRCHAR18MATN1MATNR
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
KZKUPIndicator: Material can be co-product KZKUPMATCHAR1FLAG
KZNFMIndicator: The material has a follow-up material KZNFMCHAR1XFELD
PMATAPricing Reference Material PMATNCHAR18MATN1MATNRMAT
MSTAECross-Plant Material Status MSTAECHAR2MMSTA
MSTAVCross-distribution-chain material status MSTAVCHAR2VMSTA
MSTDEDate from which the cross-plant material status is valid MSTDEDATS8DATUM
MSTDVDate from which the X-distr.-chain material status is valid MSTDVDATS8DATUM
TAKLVTax classification of the material TAKLVCHAR1TAXKM
RBNRMCatalog Profile RBNRCHAR9RBNR
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
MHDHBTotal shelf life MHDHBDEC4DEC4
MHDLPStorage percentage MHDLPDEC3DEC3
INHMEContent unit INHMEUNIT3CUNITMEINS
INHALNet contents INHALQUAN13(3) MENG13
VPREHComparison price unit VPREHDEC5PACK3
ETIAGIS-R Labeling: material grouping (deactivated in 4.0) ETIAGCHAR18ETIAG
INHBRGross contents INHBRQUAN13(3) MENG13
CMETHQuantity Conversion Method OIB_CMETHCHAR1OIB_CMETH
CUOBFInternal object number CUOBMNUMC18CUOBJ
KZUMWEnvironmentally Relevant KZUMWCHAR1XFELD
KOSCHProduct allocation determination procedure KOSCHCHAR18KOSCH
SPROFPricing profile for variants SPROFCHAR1SPROF
NRFHGMaterial qualifies for discount in kind NRFHGCHAR1NRFHG
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
MFRNRNumber of a Manufacturer MFRNRCHAR10ALPHALIFNR
BMATNNumber of firm's own (internal) inventory-managed material MPMATCHAR18MATN1MATNRMAT
MPROFManufacturer Part Profile MPROFCHAR4MPROF
KZWSMUnits of measure usage KZWSOCHAR1KZWSO
SAITYRollout in a Season SAITYCHAR2SAITYWMSAITY
PROFLDangerous Goods Indicator Profile ADGE_PROFLCHAR3ADGD_PROFL
IHIVIIndicator: Highly Viscous ADGE_IHIVICHAR1X
ILOOSIndicator: In Bulk/Liquid ADGE_ILOOSCHAR1X
SERLVLevel of Explicitness for Serial Number SERLVCHAR1SERLV
KZGVHPackaging Material is Closed Packaging KZGVHCHAR1XFELD
XGCHPIndicator: Approved batch record required XGCHPCHAR1XFELD
KZEFFAssign effectivity parameter values/ override change numbers CC_MTEFFCHAR1XFELD
COMPLMaterial completion level CSCP_COMP_LVLNUMC2CSCP_COMP_LVL
IPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
RDMHDRounding rule for calculation of SLED RDMHDCHAR1RDMHD
PRZUSIndicator: Product composition printed on packaging PRZUSCHAR1XFELD
MTPOS_MARAGeneral item category group MTPOS_MARACHAR4MTPOS
BFLMEGeneric Material with Logistical Variants BFLMECHAR1BFLME
MATFIMaterial Is Locked MATFICHAR1XFELD
CMRELRelevant for Configuration Management DE_CM_RELEVANCE_FLAGCHAR1DO_CM_RELEVANCE_FLAG
BBTYPAssortment List Type BBTYPCHAR1BBTYPWBB
SLED_BBDExpiration Date SLED_BBDCHAR1SLED_BBD
GTIN_VARIANTGlobal Trade Item Number Variant GTIN_VARIANTCHAR2GTIN_VARIANT
GENNRMaterial Number of the Generic Material in Prepack Materials WSTR_SATNR_PPCHAR18MATN1MATNR
RMATPReference material for materials packed in same way PL_RMATPCHAR18MATN1MATNRMAT
GDS_RELEVANTIndicator: Global Data Synchronization-Relevant GDS_RELEVANTCHAR1XFELD
WEORAAcceptance At Origin WEORACHAR1XFELD
HUTYP_DFLTStandard HU Type CIFHUTYPDFCHAR4CHAR4
PILFERABLEPilferable CIFPILFRBLCHAR1XFELD
WHSTCWarehouse Storage Condition CIFWHSTCCHAR2CHAR2
WHMATGRWarehouse Material Group CIFWHMATGRCHAR4CHAR4
HNDLCODEHandling Indicator CIFHDLCODECHAR4CHAR4
HAZMATRelevant for Hazardous Substances CIFHAZMATCHAR1XFELD
HUTYPHandling Unit Type CIFHUTYPCHAR4CHAR4
TARE_VARVariable Tare Weight CIFTAREVARCHAR1XFELD
MAXCMaximum Allowed Capacity of Packaging Material CIFMAXCDEC15(3) DECV15_3
MAXC_TOLOvercapacity Tolerance of the Handling Unit CIFMAXCTOLDEC3(1) DEC2_1
MAXLMaximum Packing Length of Packaging Material CIFMAXLQUAN15(3) CIFQUAN15
MAXBMaximum Packing Width of Packaging Material CIFMAXBQUAN15(3) CIFQUAN15
MAXHMaximum Packing Height of Packaging Material CIFMAXHQUAN15(3) CIFQUAN15
MAXDIM_UOMUnit of Measure for Maximum Packing Length/Width/Height CIFMAXDUOMUNIT3CUNITMEINS
HERKLCountry of origin of the material HERKLCHAR3LAND1LND
MFRGRMaterial freight group MFRGRCHAR8MFRGR
QQTIMEQuarantine Period CIFQQTIMEQUAN3
QQTIMEUOMTime Unit for Quarantine Period CIFQQTIMEUOMUNIT3CUNITMEINS
QGRPQuality Inspection Group CIFQGRPCHAR4CIFQGRP
SERIALSerial Number Profile CIFSERIALCHAR4CIFSERIAL
PS_SMARTFORMForm Name CIFPSSFNAMECHAR30TDSFNAME
LOGUNITEWM CW: Logistics Unit of Measure CIFLOGUNITUNIT3CUNITMEINS
CWQRELEWM CW: Material Is a Catch Weight Material CIFCWQRELCHAR1XFELD
CWQPROCEWM CW: Catch Weight Profile for Entering CW Quantity CIFCWQPROCCHAR2CIFCWQPROC
CWQTOLGREWM-CW: Catch Weight Tolerance Group for EWM CIFCWQTOLGRCHAR9CIFCWQTOLGR
ADPROFAdjustment Profile CIFADPROFCHAR3CIFADPROF
IPMIPPRODUCTID for an Intellectual Property (CRM Product) CRM_PRODUCT_ID_IPCHAR40CRM_PRODUCT_ID
ALLOW_PMAT_IGNOVariant Price Allowed (for Material Master) WPM_ALLOW_PMAT_IGNO_MATCHAR1XFELD
MEDIUMMedium MEDIUCHAR6MEDIU
COMMODITYPhysical Commodity TBA_STOEFFCHENCHAR18TBA_STOEFFCHEN
ANIMAL_ORIGINIndicator: Contains Non-Textile Parts of Animal Origin WRF_ANIMAL_ORIGIN_FLAGCHAR1WRF_ANIMAL_ORIGIN_FLAG
TEXTILE_COMP_INDIndicator: New Textile Composition Function WRF_TEXTL_COMP_INDCHAR1WRF_TEXTL_COMP_IND
ANPANP Code J_1BANPNUMC9J_1BANP
.INCLU--AP 0
/BEV1/LULEINHLoading Units /BEV1/LULEINHNUMC8/BEV1/LULEINH
/BEV1/LULDEGRPLoading Unit Group: IS Beverage /BEV1/LULDEGRPCHAR3/BEV1/LULDEGRP
.INCLU--AP 0
/BEV1/NESTRUCCATStructure Category for Material Relationship /BEV1/NESTRUC_CATCHAR1/BEV1/NESTRUC_CAT
.INCLU--AP 0
/DSD/SL_TOLTYPTolerance Type ID /DSD/SL_TOLTYP_IDCHAR4/DSD/SL_TOLTYP_ID
.INCLU--AP 0
/DSD/SV_CNT_GRPCounting Group /DSD/SV_COUNT_GROUPCHAR10/DSD/SV_COUNT_GROUP
.INCLU--AP 0
/DSD/VC_GROUPDSD Grouping /DSD/VC_GROUPCHAR6/DSD/VC_GROUP
.INCLU--AP 0
/SAPMP/KADUCable Diameter /SAPMP/KADUDEC7(2) /SAPMP/DURCHME
/SAPMP/ABMEINUnit for Dimensions /SAPMP/ABMEINUNIT3CUNITMEINS
/SAPMP/KADPCable Diameter Allowance in Percent /SAPMP/KADPDEC5(2) /SAPMP/PROZENT
/SAPMP/BRADBending Factor /SAPMP/BRADDEC4/SAPMP/BRAD
/SAPMP/SPBIInner Width /SAPMP/SPBIDEC7(2) /SAPMP/DIMENS
/SAPMP/TRADOuter Diameter /SAPMP/TRADDEC7(2) /SAPMP/DURCHME
/SAPMP/KEDUCore Diameter /SAPMP/KEDUDEC7(2) /SAPMP/DURCHME
/SAPMP/SPTRLoad Capacity /SAPMP/SPTRQUAN13(3) /SAPMP/GEWICHT
/SAPMP/FBDKRun-Out Flange Thickness /SAPMP/FBDKDEC7(2) /SAPMP/DIMENS
/SAPMP/FBHKR-O Flange Height /SAPMP/FBHKDEC7(2) /SAPMP/DIMENS
/SAPMP/RILICoil Delivery /SAPMP/RILICHAR1XFELD
/SAPMP/FBAKRun-Out Flange /SAPMP/FBAKCHAR1XFELD
/SAPMP/AHOMaximum Number of Vertical Layers /SAPMP/AHONUMC3NUMC3
/SAPMP/MIFRRSmallest Permissible Reel Clearance for a Cable /SAPMP/MIFRRDEC7(2) /SAPMP/DIMENS
.INCLU--AP 0
/VSO/R_TILT_INDMaterial may be Tilted (Vehicle Space Optimization) /VSO/M_TILT_INDCHAR1/VSO/M_XFIELD
/VSO/R_STACK_INDStacking not Allowed (VSO) /VSO/M_STACK_INDCHAR1/VSO/M_XFIELD
/VSO/R_BOT_INDBottom Layer (Vehicle Space Optimization) /VSO/M_BOTTOM_INDCHAR1/VSO/M_XFIELD
/VSO/R_TOP_INDTop Layer (VSO) /VSO/M_TOP_INDCHAR1/VSO/M_XFIELD
/VSO/R_STACK_NOStacking Factor (Vehicle Space Optimization) /VSO/M_STACK_NONUMC3/VSO/M_STACK_NO
/VSO/R_PAL_INDLoad without Packaging Material (VSO) /VSO/M_PALLET_INDCHAR1/VSO/M_XFIELD
/VSO/R_PAL_OVR_DPermissible Overhang (Depth) of Packaging Material (VSO) /VSO/R_PAL_OVR_DQUAN13(3) MENG13
/VSO/R_PAL_OVR_WPermissible Overhang (Width) of Shipping Material (VSO) /VSO/R_PAL_OVR_WQUAN13(3) MENG13
/VSO/R_PAL_B_HTMaximum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_BIN_HGTQUAN13(3) MENG13
/VSO/R_PAL_MIN_HMinimum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_MIN_HTQUAN13(3) MENG13
/VSO/R_TOL_B_HTTolerance to Exceed the Max. Stacking Height (VSO) /VSO/R_TOL_BIN_HTQUAN13(3) MENG13
/VSO/R_NO_P_GVHNumber of Materials for each Closed PKM (VSO) /VSO/M_ANZ_PER_GVHNUMC2/VSO/M_ANZ_PER_GVH
/VSO/R_QUAN_UNITUnit of Measure Vehicle Space Optimization /VSO/R_QUAN_UNITUNIT3CUNIT/VSO/R_QUAN_UNIT/VSO/R_SH_T006_ME
/VSO/R_KZGVH_INDClosed Packaging Material Required (VSO) /VSO/M_KZGVH_INDCHAR1/VSO/M_XFIELD
.INCLU--AP 0
PACKCODEPackaging Code CBUNE_PACODECHAR10CBUND_PACOD
DG_PACK_STATUSDangerous Goods Packaging Status ADGE_DG_PACK_STATUSCHAR10CHAR10
.INCLU--AP 0
MCONDMaterial Condition Management DFPS_MCONDCHAR1DFPS_MCOND
RETDELCReturn Code DFPS_RETDELCCHAR1DFPS_RETDELC
LOGLEV_RETOReturn to Logistics Level DFPS_LOGLEV_RETOCHAR1DFPS_LOGLEV
NSNIDNATO Stock Number DFPS_NSNIDCHAR9DFPS_NSNID
.INCLU--AP 0
OVLPNOverlength Part Number ADSPC_OPNCHAR32ADSPC_OPN
.INCLU--AP 0
ADSPC_SPCSpare Part Class Code ADSPC_SPCNUMC1ADSPC_SPC
.INCLU--AP 0
VARIDGUID Variable Object Identification DI_VARIDRAW16SYSUUID
.INCLU--AP 0
MSBOOKPARTNOManufacturer Book Part Number /SAPHT/DRM_MSBOOKPARTCHAR18MATN1MATNRMAT1
.INCLU--AP 0
VTYPEVersion Category VERSIONTYPECHAR10VERSIONTYPE
VCHNRChange number material versions MGV_VCHNRCHAR12AENNRAENNRAEN
EVVALMaterial is Always Valid MGV_EVER_VALIDCHAR1XFELD
DVERSDefault Version MGV_MATNR_VALID_DEFAULTCHAR18MATN1MATNR
.INCLU--AP 0
DPCBTSingle-Unit Batch Def. Value MILL_DPCBTCHAR1MILL_DPCBT
XGRDTGoods Receipt to Posted Single-Unit Batch Allowed MILL_XGRDTCHAR1XFELD
.INCLU--AP 0
IMATNFFF class IMATNCHAR18MATN1MATNR
PICNUMSupersession chain number PIC_PICNUM_SUSCHAR18ALPHAPIC_PICNUMPIC_PICNUM
.INCLU--AP 0
BSTATCreation Status - Seasonal Procurement WRFBSTATCHAR2WRFBSTAT
.INCLU--AP 0
COLOR_ATINNInternal Charactieristic Number for Color Characteristics WRF_COLOR_ATINNNUMC10ATINNATINN
SIZE1_ATINNInternal Char. Number for Characteristics for Main Sizes WRF_SIZE1_ATINNNUMC10ATINNATINN
SIZE2_ATINNInternal Char. Number for Characteristics for Second Sizes WRF_SIZE2_ATINNNUMC10ATINNATINN
COLORCharacteristic Value for Colors of Variants WRF_COLORCHAR18WRF_ATWRT
SIZE1Characteristic Value for Main Sizes of Variants WRF_SIZE1CHAR18WRF_ATWRT
SIZE2Characteristic Value for Second Size for Variants WRF_SIZE2CHAR18WRF_ATWRT
FREE_CHARCharacteristic Value for Evaluation Purposes WRF_FREE_CHARCHAR18WRF_ATWRT
CARE_CODECare Codes (such as Washing Code, Ironing Code, etc.) WRF_CARE_CODECHAR16WRF_CARE_CODE
BRAND_IDBrand WRF_BRAND_IDCHAR4WRF_BRAND_ID
FIBER_CODE1Fiber Code for Textiles (Component 1) WRF_FIBER_CODE_1CHAR3FIBERWRF_FIBER_CODE
FIBER_PART1Percentage Share of Fiber (Component 1) WRF_FIBER_PART_1NUMC3WRF_FIBER_PART
FIBER_CODE2Fiber Code for Textiles (Component 2) WRF_FIBER_CODE_2CHAR3FIBERWRF_FIBER_CODE
FIBER_PART2Percentage Share of Fiber (Component 2) WRF_FIBER_PART_2NUMC3WRF_FIBER_PART
FIBER_CODE3Fiber Code for Textiles (Component 3) WRF_FIBER_CODE_3CHAR3FIBERWRF_FIBER_CODE
FIBER_PART3Percentage Share of Fiber (Component 3) WRF_FIBER_PART_3NUMC3WRF_FIBER_PART
FIBER_CODE4Fiber Code for Textiles (Component 4) WRF_FIBER_CODE_4CHAR3FIBERWRF_FIBER_CODE
FIBER_PART4Percentage Share of Fiber (Component 4) WRF_FIBER_PART_4NUMC3WRF_FIBER_PART
FIBER_CODE5Fiber Code for Textiles (Component 5) WRF_FIBER_CODE_5CHAR3FIBERWRF_FIBER_CODE
FIBER_PART5Percentage Share of Fiber (Component 5) WRF_FIBER_PART_5NUMC3WRF_FIBER_PART
.INCLU--AP 0
FASHGRDFashion Grade FASHGRDCHAR4FASHGRDH_FASHGRD
DESCR 0
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
PURCH 0
LIFNRVendor Account Number ELIFNCHAR10ALPHALIFNRLIFKRED_C
RELIFRegular Vendor RELIFCHAR1XFELD
LTSNRVendor Subrange LTSNRCHAR6LTSNR
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
LTSSFSort Sequence Number LTSSFNUMC5NUMC5
WGLIFVendor Material Group WGLIFCHAR18CHAR18
EKGRPPurchasing Group EKGRPCHAR3EKGRPEKG
EKORGPurchasing Organization EKORGCHAR4EKORGEKO
NETPRNet Price in Purchasing Info Record IPREICURR11(2) WERT11
PEINHPrice Unit EPEINDEC5DEC5
WAERSCurrency Key WAERSCUKY5WAERSFWS
PRDATPrice Valid Until PRGBIDATS8DATUM
APLFZPlanned Delivery Time in Days PLIFZDEC3DEC3
MEINSPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
NORBMStandard Purchase Order Quantity NORBMQUAN13(3) MENG13
GROSS_PRICEGross Purchasing Price WSD_GROSS_PUR_PRICECURR11(2) WERT11
GP_CURRENCYCurrency Key WAERSCUKY5WAERSFWS
GP_PRICE_QTYCondition pricing unit KPEINDEC5KPEIN
GP_UNITPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
NET_PRICEGross Purchasing Price WSD_GROSS_PUR_PRICECURR11(2) WERT11
NP_CURRENCYCurrency Key WAERSCUKY5WAERSFWS
NP_PRICE_QTYCondition pricing unit KPEINDEC5KPEIN
NP_UNITPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
NET_PRICE_VALUEGross Purchasing Price WSD_GROSS_PUR_PRICECURR11(2) WERT11
SALES 0
VKORGSales Organization VKORGCHAR4VKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2VTWEGVTWC_VTWEG
SALES_PRICEFinal price ENDPRCURR11(2) WERTV6
SP_CURRENCYCurrency Key WAERSCUKY5WAERSFWS
SP_PRICE_QTYCondition pricing unit KPEINDEC5KPEIN
SP_UNITSales unit VRKMEUNIT3CUNITMEINS
CUST_PRICECustomer expected price CSEPRCURR11(2) WERTV6
CP_CURRENCYCurrency Key WAERSCUKY5WAERSFWS
CP_PRICE_QTYCondition pricing unit KPEINDEC5KPEIN
CP_UNITSales unit VRKMEUNIT3CUNITMEINS
SALES_VALUENet Sales Value WSD_SALES_VALUECURR11(2) WERTV6
SALES_VALUE_CURRENCYCurrency Key WAERSCUKY5WAERSFWS
PLANT 0
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
NAMEName 1 AD_NAME1CHAR40TEXT40
LABSTValuated Unrestricted-Use Stock LABSTQUAN13(3) MENG13V
VRKMESales unit VRKMEUNIT3CUNITMEINS
MAINTAINEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
RANK_VALUESearch result rank value WSD_RANK_VALUEINT410
ROW_IDSearch result table row id. (For internal use Do not modify) WSD_MS_ROWIDINT410
PRICECATALOGPRICAT: Unique internal catalog number WSD_PRINBRCHAR10WSD_PRINBR
VALIDITY_BASEPrice Catalog Inbound Start of Validity Period WSD_PRIVALIDITYDATS8DATUM
MASTER_VARIANTMaster Variant Copy WSD_MASTER_VARIANTCHAR1CHAR1
VENDOR_SATNRPrice Catalog: Grouping Field: Generic Material Assignment WSD_VENDOR_SATNRCHAR20WSD_VENDOR_SATNR
CONF_MATLCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR

Key field Non-key field



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

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

How to access SAP table WSD_MS_RESULT_STY

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