1. Home
  2. Resources
  3. SAP Tables
  4. JSBW_MED_PRODUCT_ATTR - IS-M: BW Structure for Media Product Extractor (L2 inc.MARA)

SAP Table JSBW_MED_PRODUCT_ATTR

IS-M: BW Structure for Media Product Extractor (L2 inc.MARA)

JSBW_MED_PRODUCT_ATTR (IS-M: BW Structure for Media Product Extractor (L2 inc.MARA)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JSBW_MED_PRODUCT_ATTR to other SAP tables.

Source: JSBW_MED_PRODUCT_ATTR (IS-M: BW Structure for Media Product Extractor (L2 inc.MARA))

JSBW_MED_PRODUCT_ATTR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
MATNR Material Number MATNR CHAR 18 0
ERSDA Created On ERSDA DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
LAEDA Date of Last Change LAEDA DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
VPSTA Maintenance status of complete material VPSTA CHAR 15 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
LVORM Flag Material for Deletion at Client Level LVOMA CHAR 1 0
X Yes
NULL No
MTART Material Type MTART CHAR 4 0
MBRSH Industry sector MBRSH CHAR 1 0
MATKL Material Group MATKL CHAR 9 0
BISMT Old material number BISMT CHAR 18 0
MEINS Base Unit of Measure MEINS UNIT 3 0
BSTME Purchase Order Unit of Measure BSTME UNIT 3 0
ZEINR Document number (without document management system) DZEINR CHAR 22 0
ZEIAR Document type (without Document Management system) DZEIAR CHAR 3 0
ZEIVR Document version (without Document Management system) DZEIVR CHAR 2 0
ZEIFO Page format of document (without Document Management system) DZEIFO CHAR 4 0
AESZN Document change number (without document management system) AESZN CHAR 6 0
BLATT Page number of document (without Document Management system) BLATT CHAR 3 0
BLANZ Number of sheets (without Document Management system) BLANZ NUMC 3 0
FERTH Production/inspection memo FERTH CHAR 18 0
FORMT Page Format of Production Memo FORMT CHAR 4 0
GROES Size/dimensions GROES CHAR 32 0
WRKST Basic Material WRKST CHAR 48 0
NORMT Industry Standard Description (such as ANSI or ISO) NORMT CHAR 18 0
LABOR Laboratory/design office LABOR CHAR 3 0
EKWSL Purchasing Value Key EKWSL CHAR 4 0
BRGEW Gross Weight BRGEW QUAN 13 3
NTGEW Net Weight NTGEW QUAN 13 3
GEWEI Weight Unit GEWEI UNIT 3 0
VOLUM Volume VOLUM QUAN 13 3
VOLEH Volume unit VOLEH UNIT 3 0
BEHVO Container requirements BEHVO CHAR 2 0
RAUBE Storage conditions RAUBE CHAR 2 0
TEMPB Temperature conditions indicator TEMPB CHAR 2 0
DISST Low-Level Code DISST CHAR 3 0
TRAGR Transportation Group TRAGR CHAR 4 0
STOFF Hazardous material number STOFF CHAR 18 0
SPART Division SPART CHAR 2 0
KUNNR Competitor WETTB CHAR 10 0
EANNR European Article Number (EAN) - obsolete!!!!! EANNR CHAR 13 0
WESCH Quantity: Number of GR/GI slips to be printed WESCH QUAN 13 3
BWVOR Procurement rule BWVOR CHAR 1 0
BWSCL Source of Supply BWSCL CHAR 1 0
SAISO Season Category SAISO CHAR 4 0
ETIAR Label type ETIAR CHAR 2 0
ETIFO Label form ETIFO CHAR 2 0
ENTAR Disposal type ENTAR CHAR 1 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
NUMTP Category of International Article Number (EAN) NUMTP CHAR 2 0
LAENG Length LAENG QUAN 13 3
BREIT Width BREIT QUAN 13 3
HOEHE Height HOEHE QUAN 13 3
MEABM Unit of Dimension for Length/Width/Height MEABM UNIT 3 0
PRDHA Product hierarchy PRODH_D CHAR 18 0
AEKLK Stock Transfer Net Change Costing CK_AEKLK CHAR 1 0
X Yes
NULL No
CADKZ CAD Indicator CADKZ CHAR 1 0
X Yes
NULL No
QMPUR QM in Procurement is Active QMPUR CHAR 1 0
X Yes
NULL No
ERGEW Allowed packaging weight ERGEW QUAN 13 3
ERGEI Unit of weight (allowed packaging weight) ERGEI UNIT 3 0
ERVOL Allowed packaging volume ERVOL QUAN 13 3
ERVOE Volume unit (allowed packaging volume) ERVOE UNIT 3 0
GEWTO Excess Weight Tolerance for Handling unit GEWTO DEC 3 1
VOLTO Excess Volume Tolerance of the Handling Unit VOLTO DEC 3 1
VABME Variable Purchase Order Unit Active VABME CHAR 1 0
NULL Not active
1 Active
2 Active with own price
KZREV Revision Level Has Been Assigned to the Material KZREV CHAR 1 0
X Yes
NULL No
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
VHART Packaging Material Type VHIART CHAR 4 0
FUELG Maximum level (by volume) FUELG DEC 3 0
STFAK Stacking factor STFAK INT2 5 0
MAGRV Material Group: Packaging Materials MAGRV CHAR 4 0
BEGRU Authorization Group BEGRU CHAR 4 0
DATAB Valid-From Date DATAB DATS 8 0
LIQDT Deletion date LIQDT DATS 8 0
SAISJ Season Year SAISJ CHAR 4 0
PLGTP Price Band Category PLGTP CHAR 2 0
MLGUT Empties Bill of Material W_MITLEERG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
EXTWG External Material Group EXTWG CHAR 18 0
SATNR Cross-Plant Configurable Material SATNR CHAR 18 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
KZKUP Indicator: Material can be co-product KZKUPMAT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZNFM Indicator: The material has a follow-up material KZNFM CHAR 1 0
X Yes
NULL No
PMATA Pricing Reference Material PMATN CHAR 18 0
MSTAE Cross-Plant Material Status MSTAE CHAR 2 0
MSTAV Cross-distribution-chain material status MSTAV CHAR 2 0
MSTDE Date from which the cross-plant material status is valid MSTDE DATS 8 0
MSTDV Date from which the X-distr.-chain material status is valid MSTDV DATS 8 0
TAKLV Tax classification of the material TAKLV CHAR 1 0
RBNRM Catalog Profile RBNR CHAR 9 0
MHDRZ Minimum Remaining Shelf Life MHDRZ DEC 4 0
MHDHB Total shelf life MHDHB DEC 4 0
MHDLP Storage percentage MHDLP DEC 3 0
INHME Content unit INHME UNIT 3 0
INHAL Net contents INHAL QUAN 13 3
VPREH Comparison price unit VPREH DEC 5 0
ETIAG IS-R Labeling: material grouping (deactivated in 4.0) ETIAG CHAR 18 0
INHBR Gross contents INHBR QUAN 13 3
CMETH Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
CUOBF Internal object number CUOBM NUMC 18 0
KZUMW Environmentally Relevant KZUMW CHAR 1 0
X Yes
NULL No
KOSCH Product allocation determination procedure KOSCH CHAR 18 0
SPROF Pricing profile for variants SPROF CHAR 1 0
NULL Variants priceable diff.; do not propose GMaterial as ref.
1 Variants priceable differently; propose GMaterial as ref.
2 All variants have the sales price of the generic material
NRFHG Material qualifies for discount in kind NRFHG CHAR 1 0
NULL Not eligible for discount in kind
1 Eligible for discount in kind for purchasing and sales
2 Eligible for discount in kind only for purchasing
3 Eligible for discount in kind only for sales
MFRPN Manufacturer Part Number MFRPN CHAR 40 0
MFRNR Number of a Manufacturer MFRNR CHAR 10 0
BMATN Number of firm's own (internal) inventory-managed material MPMAT CHAR 18 0
MPROF Manufacturer Part Profile MPROF CHAR 4 0
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
SAITY Rollout in a Season SAITY CHAR 2 0
PROFL Dangerous Goods Indicator Profile ADGE_PROFL CHAR 3 0
IHIVI Indicator: Highly Viscous ADGE_IHIVI CHAR 1 0
X Yes
NULL No
ILOOS Indicator: In Bulk/Liquid ADGE_ILOOS CHAR 1 0
X Yes
NULL No
SERLV Level of Explicitness for Serial Number SERLV CHAR 1 0
NULL Serialization within the stock material number
1 Keep equipment number and serial number synchronous
KZGVH Packaging Material is Closed Packaging KZGVH CHAR 1 0
X Yes
NULL No
XGCHP Indicator: Approved batch record required XGCHP CHAR 1 0
X Yes
NULL No
KZEFF Assign effectivity parameter values/ override change numbers CC_MTEFF CHAR 1 0
X Yes
NULL No
COMPL Material completion level CSCP_COMP_LVL NUMC 2 0
IPRKZ Period Indicator for Shelf Life Expiration Date DATTP CHAR 1 0
RDMHD Rounding rule for calculation of SLED RDMHD CHAR 1 0
NULL No rounding off
- Start of chosen period (week, month or year)
+ End of chosen period (week, month or year)
F Start of the following period (week, month, year)
PRZUS Indicator: Product composition printed on packaging PRZUS CHAR 1 0
X Yes
NULL No
MTPOS_MARA General item category group MTPOS_MARA CHAR 4 0
BFLME Generic Material with Logistical Variants BFLME CHAR 1 0
NULL Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
/CWM/XCWMAT Material Is Activated for Catch Weight /CWM/XCWMAT CHAR 1 0
X Yes
NULL No
/CWM/VALUM Valuation Unit of Measure /CWM/VALUM UNIT 3 0
/CWM/TOLGR Tolerance Group for Catch Weight Management /CWM/TOLGR CHAR 9 0
/CWM/TARA Checkbox XFELD CHAR 1 0
X Yes
NULL No
/CWM/TARUM Base Unit of Measure MEINS UNIT 3 0
NSNID NATO Stock Number DFPS_NSNID CHAR 9 0
COLOR_ATINN Internal Charactieristic Number for Color Characteristics WRF_COLOR_ATINN NUMC 10 0
SIZE1_ATINN Internal Char. Number for Characteristics for Main Sizes WRF_SIZE1_ATINN NUMC 10 0
SIZE2_ATINN Internal Char. Number for Characteristics for Second Sizes WRF_SIZE2_ATINN NUMC 10 0
COLOR Characteristic Value for Colors of Variants WRF_COLOR CHAR 18 0
SIZE1 Characteristic Value for Main Sizes of Variants WRF_SIZE1 CHAR 18 0
SIZE2 Characteristic Value for Second Size for Variants WRF_SIZE2 CHAR 18 0
FREE_CHAR Characteristic Value for Evaluation Purposes WRF_FREE_CHAR CHAR 18 0
CARE_CODE Care Codes (such as Washing Code, Ironing Code, etc.) WRF_CARE_CODE CHAR 16 0
BRAND_ID Brand WRF_BRAND_ID WRF_BRANDS CHAR 4 0
FIBER_CODE1 Fiber Code for Textiles (Component 1) WRF_FIBER_CODE_1 WRF_FIBER_CODES CHAR 3 0
FIBER_PART1 Percentage Share of Fiber (Component 1) WRF_FIBER_PART_1 NUMC 3 0
FIBER_CODE2 Fiber Code for Textiles (Component 2) WRF_FIBER_CODE_2 WRF_FIBER_CODES CHAR 3 0
FIBER_PART2 Percentage Share of Fiber (Component 2) WRF_FIBER_PART_2 NUMC 3 0
FIBER_CODE3 Fiber Code for Textiles (Component 3) WRF_FIBER_CODE_3 WRF_FIBER_CODES CHAR 3 0
FIBER_PART3 Percentage Share of Fiber (Component 3) WRF_FIBER_PART_3 NUMC 3 0
FIBER_CODE4 Fiber Code for Textiles (Component 4) WRF_FIBER_CODE_4 WRF_FIBER_CODES CHAR 3 0
FIBER_PART4 Percentage Share of Fiber (Component 4) WRF_FIBER_PART_4 NUMC 3 0
FIBER_CODE5 Fiber Code for Textiles (Component 5) WRF_FIBER_CODE_5 WRF_FIBER_CODES CHAR 3 0
FIBER_PART5 Percentage Share of Fiber (Component 5) WRF_FIBER_PART_5 NUMC 3 0
RPA_WGH1 Material group hierarchy level WWGHIE CHAR 18 0
RPA_WGH2 Material group hierarchy level WWGHIE CHAR 18 0
RPA_WGH3 Material group hierarchy level WWGHIE CHAR 18 0
RPA_WGH4 Material group hierarchy level WWGHIE CHAR 18 0
FASHGRD Fashion Grade FASHGRD CHAR 4 0

JSBW_MED_PRODUCT_ATTR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JSBW_MED_PRODUCT_ATTR BRAND_ID SYST MANDT WRF_BRANDS Markers MANDT
JSBW_MED_PRODUCT_ATTR BRAND_ID JSBW_MED_PRODUCT_ATTR BRAND_ID WRF_BRANDS Markers BRAND_ID
JSBW_MED_PRODUCT_ATTR FIBER_CODE1 SYST MANDT WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
JSBW_MED_PRODUCT_ATTR FIBER_CODE1 JSBW_MED_PRODUCT_ATTR FIBER_CODE1 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) FIBER_CODE
JSBW_MED_PRODUCT_ATTR FIBER_CODE2 SYST MANDT WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
JSBW_MED_PRODUCT_ATTR FIBER_CODE2 JSBW_MED_PRODUCT_ATTR FIBER_CODE2 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) FIBER_CODE
JSBW_MED_PRODUCT_ATTR FIBER_CODE3 SYST MANDT WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
JSBW_MED_PRODUCT_ATTR FIBER_CODE3 JSBW_MED_PRODUCT_ATTR FIBER_CODE3 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) FIBER_CODE
JSBW_MED_PRODUCT_ATTR FIBER_CODE4 SYST MANDT WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
JSBW_MED_PRODUCT_ATTR FIBER_CODE4 JSBW_MED_PRODUCT_ATTR FIBER_CODE4 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) FIBER_CODE
JSBW_MED_PRODUCT_ATTR FIBER_CODE5 SYST MANDT WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) MANDT
JSBW_MED_PRODUCT_ATTR FIBER_CODE5 JSBW_MED_PRODUCT_ATTR FIBER_CODE5 WRF_FIBER_CODES Fiber Codes for Textiles (e.g. Wool, Silk, Etc.) FIBER_CODE