JSBW_MEDPROD_ATTR SAP (IS-M: BW Structure for Media Product Extractor (Incl. MARA)) Structure details

Dictionary Type: Structure
Description: IS-M: BW Structure for Media Product Extractor (Incl. MARA)




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




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

JSBW_MEDPROD_ATTR 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-M: BW Structure for Media Product Extractor (Incl. MARA)" 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_JSBW_MEDPROD_ATTR TYPE JSBW_MEDPROD_ATTR.

The JSBW_MEDPROD_ATTR table consists of various fields, each holding specific information or linking keys about IS-M: BW Structure for Media Product Extractor (Incl. MARA) data available in SAP. These include MANDT (Client), MATNR (Material Number), ERSDA (Created On), ERNAM (Name of Person who Created the Object).. 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 JSBW_MEDPROD_ATTR 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_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 MTARTCHAR4Assigned to domainMTARTMTA
MBRSHIndustry sector MBRSHCHAR1Assigned to domainMBRSHMTP
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
BISMTOld material number BISMTCHAR18BISMT
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
BSTMEPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
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 WRKSTCHAR48Assigned to domainWRKST
NORMTIndustry Standard Description (such as ANSI or ISO) NORMTCHAR18NORMT
LABORLaboratory/design office LABORCHAR3Assigned to domainLABOR
EKWSLPurchasing Value Key EKWSLCHAR4Assigned to domainEKWSL
BRGEWGross Weight BRGEWQUAN13(3) MENG13
NTGEWNet Weight NTGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
VOLUMVolume VOLUMQUAN13(3) MENG13
VOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
BEHVOContainer requirements BEHVOCHAR2Assigned to domainBEHVO
RAUBEStorage conditions RAUBECHAR2Assigned to domainRAUBE
TEMPBTemperature conditions indicator TEMPBCHAR2Assigned to domainTEMPB
DISSTLow-Level Code DISSTCHAR3DISST
TRAGRTransportation Group TRAGRCHAR4Assigned to domainTRAGR
STOFFHazardous material number STOFFCHAR18Assigned to domainMATN1STOFFSTO
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
KUNNRCompetitor WETTBCHAR10Assigned to domainALPHAKUNNRKUN
EANNREuropean Article Number (EAN) - obsolete!!!!! EANNRCHAR13CHAR13EAN
WESCHQuantity: Number of GR/GI slips to be printed WESCHQUAN13(3) MENG13
BWVORProcurement rule BWVORCHAR1Assigned to domainBWVOR
BWSCLSource of Supply BWSCLCHAR1Assigned to domainBQSCL
SAISOSeason Category SAISOCHAR4Assigned to domainSAISOSAISO
ETIARLabel type ETIARCHAR2Assigned to domainETIAR
ETIFOLabel form ETIFOCHAR2Assigned to domainETIFO
ENTARDisposal type ENTARCHAR1Assigned to domainENTAR
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
NUMTPCategory of International Article Number (EAN) NUMTPCHAR2Assigned to domainNUMTP
LAENGLength LAENGQUAN13(3) MENG13
BREITWidth BREITQUAN13(3) MENG13
HOEHEHeight HOEHEQUAN13(3) MENG13
MEABMUnit of Dimension for Length/Width/Height MEABMUNIT3Assigned to domainCUNITMEINS
PRDHAProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
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) ERGEIUNIT3Assigned to domainCUNITMEINS
ERVOLAllowed packaging volume ERVOLQUAN13(3) MENG13
ERVOEVolume unit (allowed packaging volume) ERVOEUNIT3Assigned to domainCUNITMEINS
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 VHIARTCHAR4Assigned to domainTRATY
FUELGMaximum level (by volume) FUELGDEC3DEC3
STFAKStacking factor STFAKINT25INT2
MAGRVMaterial Group: Packaging Materials MAGRVCHAR4Assigned to domainMAGRV
BEGRUAuthorization Group BEGRUCHAR4BEGRU
DATABValid-From Date DATABDATS8DATUM
LIQDTDeletion date LIQDTDATS8DATUM
SAISJSeason Year SAISJCHAR4GJAHRCJAHRWMSAISJ
PLGTPPrice Band Category PLGTPCHAR2Assigned to domainPLGTP
MLGUTEmpties Bill of Material W_MITLEERGCHAR1FLAG
EXTWGExternal Material Group EXTWGCHAR18Assigned to domainEXTWG
SATNRCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
KZKUPIndicator: Material can be co-product KZKUPMATCHAR1FLAG
KZNFMIndicator: The material has a follow-up material KZNFMCHAR1XFELD
PMATAPricing Reference Material PMATNCHAR18Assigned to domainMATN1MATNRMAT
MSTAECross-Plant Material Status MSTAECHAR2Assigned to domainMMSTA
MSTAVCross-distribution-chain material status MSTAVCHAR2Assigned to domainVMSTA
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 TAKLVCHAR1Assigned to domainTAXKM
RBNRMCatalog Profile RBNRCHAR9Assigned to domainRBNR
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
MHDHBTotal shelf life MHDHBDEC4DEC4
MHDLPStorage percentage MHDLPDEC3DEC3
INHMEContent unit INHMEUNIT3Assigned to domainCUNITMEINS
INHALNet contents INHALQUAN13(3) MENG13
VPREHComparison price unit VPREHDEC5PACK3
ETIAGIS-R Labeling: material grouping (deactivated in 4.0) ETIAGCHAR18Assigned to domainETIAG
INHBRGross contents INHBRQUAN13(3) MENG13
CMETHQuantity Conversion Method OIB_CMETHCHAR1OIB_CMETH
CUOBFInternal object number CUOBMNUMC18CUOBJ
KZUMWEnvironmentally Relevant KZUMWCHAR1XFELD
KOSCHProduct allocation determination procedure KOSCHCHAR18Assigned to domainKOSCH
SPROFPricing profile for variants SPROFCHAR1SPROF
NRFHGMaterial qualifies for discount in kind NRFHGCHAR1NRFHG
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
MFRNRNumber of a Manufacturer MFRNRCHAR10Assigned to domainALPHALIFNR
BMATNNumber of firm's own (internal) inventory-managed material MPMATCHAR18Assigned to domainMATN1MATNRMAT
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
KZWSMUnits of measure usage KZWSOCHAR1KZWSO
SAITYRollout in a Season SAITYCHAR2Assigned to domainSAITYWMSAITY
PROFLDangerous Goods Indicator Profile ADGE_PROFLCHAR3Assigned to domainADGD_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_LVLNUMC2Assigned to domainCSCP_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_MARACHAR4Assigned to domainMTPOS
BFLMEGeneric Material with Logistical Variants BFLMECHAR1BFLME
.INCLU--AP 0
MATNR_EXTExternal Long Material Number MATNR_EXTCHAR40MATNLMATNR_EXT
MATNR_VERSMaterial Version Number MATNR_VERSCHAR10MATNWMATNR_VERSMATVERS
MATNR_SELExternal Material Number Plus Version for Selection MATNR_SELCHAR51
.INCLU--AP 0
NSNIDNATO Stock Number DFPS_NSNIDCHAR9DFPS_NSNID
.INCLU--AP 0
COLOR_ATINNInternal Charactieristic Number for Color Characteristics WRF_COLOR_ATINNNUMC10Assigned to domainATINNATINN
SIZE1_ATINNInternal Char. Number for Characteristics for Main Sizes WRF_SIZE1_ATINNNUMC10Assigned to domainATINNATINN
SIZE2_ATINNInternal Char. Number for Characteristics for Second Sizes WRF_SIZE2_ATINNNUMC10Assigned to domainATINNATINN
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_BRANDSWRF_BRAND_ID
FIBER_CODE1Fiber Code for Textiles (Component 1) WRF_FIBER_CODE_1CHAR3WRF_FIBER_CODESFIBERWRF_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_2CHAR3WRF_FIBER_CODESFIBERWRF_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_3CHAR3WRF_FIBER_CODESFIBERWRF_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_4CHAR3WRF_FIBER_CODESFIBERWRF_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_5CHAR3WRF_FIBER_CODESFIBERWRF_FIBER_CODE
FIBER_PART5Percentage Share of Fiber (Component 5) WRF_FIBER_PART_5NUMC3WRF_FIBER_PART
.INCLU--AP 0
RPA_WGH1Material group hierarchy level WWGHIECHAR18KLASSEWGH
RPA_WGH2Material group hierarchy level WWGHIECHAR18KLASSEWGH
RPA_WGH3Material group hierarchy level WWGHIECHAR18KLASSEWGH
RPA_WGH4Material group hierarchy level WWGHIECHAR18KLASSEWGH
.INCLU--AP 0
FASHGRDFashion Grade FASHGRDCHAR4FASHGRDH_FASHGRD
.INCLU--AP 0
MPG_LFDNRSequence number of media issue within issue sequence MPG_LFDNRNUMC6NUMC6

Key field Non-key field



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

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

How to access SAP table JSBW_MEDPROD_ATTR

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