SAP ABAP Table JSBW_MEDPROD_ATTR (IS-M: BW Structure for Media Product Extractor (Incl. MARA))
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M-IS (Application Component) Information System
⤷ JSBW (Package) IS-M: Link to Business Information Warehouse
⤷ IS-M-IS (Application Component) Information System
⤷ JSBW (Package) IS-M: Link to Business Information Warehouse
Basic Data
Table Category | INTTAB | Structure |
Structure | JSBW_MEDPROD_ATTR | Table Relationship Diagram |
Short Description | IS-M: BW Structure for Media Product Extractor (Incl. MARA) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Provider Structure for Material Master Data from MARA | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
4 | ERSDA | ERSDA | DATUM | DATS | 8 | 0 | Created On | ||
5 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
6 | LAEDA | LAEDA | DATUM | DATS | 8 | 0 | Date of Last Change | ||
7 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
8 | VPSTA | VPSTA | PSTAT | CHAR | 15 | 0 | Maintenance status of complete material | ||
9 | PSTAT | PSTAT_D | PSTAT | CHAR | 15 | 0 | Maintenance status | ||
10 | LVORM | LVOMA | XFELD | CHAR | 1 | 0 | Flag Material for Deletion at Client Level | ||
11 | MTART | MTART | MTART | CHAR | 4 | 0 | Material type | * | |
12 | MBRSH | MBRSH | MBRSH | CHAR | 1 | 0 | Industry sector | * | |
13 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
14 | BISMT | BISMT | BISMT | CHAR | 18 | 0 | Old material number | ||
15 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
16 | BSTME | BSTME | MEINS | UNIT | 3 | 0 | Order unit | * | |
17 | ZEINR | DZEINR | CHAR22 | CHAR | 22 | 0 | Document number (without document management system) | ||
18 | ZEIAR | DZEIAR | ZEIAR | CHAR | 3 | 0 | Document type (without Document Management system) | ||
19 | ZEIVR | DZEIVR | VERSI | CHAR | 2 | 0 | Document version (without Document Management system) | ||
20 | ZEIFO | DZEIFO | DINFO | CHAR | 4 | 0 | Page format of document (without Document Management system) | ||
21 | AESZN | AESZN | AENUM | CHAR | 6 | 0 | Document change number (without document management system) | ||
22 | BLATT | BLATT | BLATT | CHAR | 3 | 0 | Page number of document (without Document Management system) | ||
23 | BLANZ | BLANZ | NUM3 | NUMC | 3 | 0 | Number of sheets (without Document Management system) | ||
24 | FERTH | FERTH | FERTH | CHAR | 18 | 0 | Production/inspection memo | ||
25 | FORMT | FORMT | DINFO | CHAR | 4 | 0 | Page Format of Production Memo | ||
26 | GROES | GROES | CHAR32 | CHAR | 32 | 0 | Size/dimensions | ||
27 | WRKST | WRKST | WRKST | CHAR | 48 | 0 | Basic Material | * | |
28 | NORMT | NORMT | NORMT | CHAR | 18 | 0 | Industry Standard Description (such as ANSI or ISO) | ||
29 | LABOR | LABOR | LABOR | CHAR | 3 | 0 | Laboratory/design office | * | |
30 | EKWSL | EKWSL | EKWSL | CHAR | 4 | 0 | Purchasing Value Key | * | |
31 | BRGEW | BRGEW | MENG13 | QUAN | 13 | 3 | Gross weight | ||
32 | NTGEW | NTGEW | MENG13 | QUAN | 13 | 3 | Net weight | ||
33 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
34 | VOLUM | VOLUM | MENG13 | QUAN | 13 | 3 | Volume | ||
35 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
36 | BEHVO | BEHVO | BEHVO | CHAR | 2 | 0 | Container requirements | * | |
37 | RAUBE | RAUBE | RAUBE | CHAR | 2 | 0 | Storage conditions | * | |
38 | TEMPB | TEMPB | TEMPB | CHAR | 2 | 0 | Temperature conditions indicator | * | |
39 | DISST | DISST | DISST | CHAR | 3 | 0 | Low-level code | ||
40 | TRAGR | TRAGR | TRAGR | CHAR | 4 | 0 | Transportation Group | * | |
41 | STOFF | STOFF | STOFF | CHAR | 18 | 0 | Hazardous material number | * | |
42 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
43 | KUNNR | WETTB | KUNNR | CHAR | 10 | 0 | Competitor | * | |
44 | EANNR | EANNR | CHAR13 | CHAR | 13 | 0 | European Article Number (EAN) - obsolete!!!!! | ||
45 | WESCH | WESCH | MENG13 | QUAN | 13 | 3 | Quantity: Number of GR/GI slips to be printed | ||
46 | BWVOR | BWVOR | BWVOR | CHAR | 1 | 0 | Procurement rule | * | |
47 | BWSCL | BWSCL | BQSCL | CHAR | 1 | 0 | Source of Supply | * | |
48 | SAISO | SAISO | SAISO | CHAR | 4 | 0 | Season Category | * | |
49 | ETIAR | ETIAR | ETIAR | CHAR | 2 | 0 | Label type | * | |
50 | ETIFO | ETIFO | ETIFO | CHAR | 2 | 0 | Label form | * | |
51 | ENTAR | ENTAR | ENTAR | CHAR | 1 | 0 | Disposal type | * | |
52 | EAN11 | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
53 | NUMTP | NUMTP | NUMTP | CHAR | 2 | 0 | Category of International Article Number (EAN) | * | |
54 | LAENG | LAENG | MENG13 | QUAN | 13 | 3 | Length | ||
55 | BREIT | BREIT | MENG13 | QUAN | 13 | 3 | Width | ||
56 | HOEHE | HOEHE | MENG13 | QUAN | 13 | 3 | Height | ||
57 | MEABM | MEABM | MEINS | UNIT | 3 | 0 | Unit of Dimension for Length/Width/Height | * | |
58 | PRDHA | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | * | |
59 | AEKLK | CK_AEKLK | XFELD | CHAR | 1 | 0 | Stock transfer net change costing | ||
60 | CADKZ | CADKZ | XFELD | CHAR | 1 | 0 | CAD Indicator | ||
61 | QMPUR | QMPUR | XFELD | CHAR | 1 | 0 | QM in procurement is active | ||
62 | ERGEW | ERGEW | MENG13 | QUAN | 13 | 3 | Allowed packaging weight | ||
63 | ERGEI | ERGEI | MEINS | UNIT | 3 | 0 | Unit of weight (allowed packaging weight) | * | |
64 | ERVOL | ERVOL | MENG13 | QUAN | 13 | 3 | Allowed packaging volume | ||
65 | ERVOE | ERVOE | MEINS | UNIT | 3 | 0 | Volume unit (allowed packaging volume) | * | |
66 | GEWTO | GEWTO | PRZ21 | DEC | 3 | 1 | Excess weight tolerance for shipping unit | ||
67 | VOLTO | VOLTO | PRZ21 | DEC | 3 | 1 | Excess volume tolerance limit during packing | ||
68 | VABME | VABME | VABME | CHAR | 1 | 0 | Variable Purchase Order Unit Active | ||
69 | KZREV | KZREV | XFELD | CHAR | 1 | 0 | Indicator: revision level has been assigned to the material | ||
70 | KZKFG | KZKFG | XFELD | CHAR | 1 | 0 | Configurable Material | ||
71 | XCHPF | XCHPF | XFELD | CHAR | 1 | 0 | Batch management requirement indicator | ||
72 | VHART | VHIART | TRATY | CHAR | 4 | 0 | Shipping material type | * | |
73 | FUELG | FUELG | DEC3 | DEC | 3 | 0 | Filling level (by volume) | ||
74 | STFAK | STFAK | INT2 | INT2 | 5 | 0 | Stacking factor | ||
75 | MAGRV | MAGRV | MAGRV | CHAR | 4 | 0 | Material Group: Packaging Materials | * | |
76 | BEGRU | BEGRU | BEGRU | CHAR | 4 | 0 | Authorization Group | ||
77 | DATAB | DATAB | DATUM | DATS | 8 | 0 | Valid-From Date | ||
78 | LIQDT | LIQDT | DATUM | DATS | 8 | 0 | Deletion date | ||
79 | SAISJ | SAISJ | CJAHR | CHAR | 4 | 0 | Season Year | ||
80 | PLGTP | PLGTP | PLGTP | CHAR | 2 | 0 | Price band category | * | |
81 | MLGUT | W_MITLEERG | FLAG | CHAR | 1 | 0 | Empties Bill of Material | ||
82 | EXTWG | EXTWG | EXTWG | CHAR | 18 | 0 | External material group | * | |
83 | SATNR | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | * | |
84 | ATTYP | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
85 | KZKUP | KZKUPMAT | FLAG | CHAR | 1 | 0 | Indicator: Material can be co-product | ||
86 | KZNFM | KZNFM | XFELD | CHAR | 1 | 0 | Indicator: The material has a follow-up material | ||
87 | PMATA | PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | * | |
88 | MSTAE | MSTAE | MMSTA | CHAR | 2 | 0 | Cross-Plant Material Status | * | |
89 | MSTAV | MSTAV | VMSTA | CHAR | 2 | 0 | Cross-distribution-chain material status | * | |
90 | MSTDE | MSTDE | DATUM | DATS | 8 | 0 | Date from which the cross-plant material status is valid | ||
91 | MSTDV | MSTDV | DATUM | DATS | 8 | 0 | Date from which the X-distr.-chain material status is valid | ||
92 | TAKLV | TAKLV | TAXKM | CHAR | 1 | 0 | Tax Classification of Material | * | |
93 | RBNRM | RBNR | RBNR | CHAR | 9 | 0 | Report layout | * | |
94 | MHDRZ | MHDRZ | DEC4 | DEC | 4 | 0 | Minimum Remaining Shelf Life | ||
95 | MHDHB | MHDHB | DEC4 | DEC | 4 | 0 | Total shelf life | ||
96 | MHDLP | MHDLP | DEC3 | DEC | 3 | 0 | Storage percentage | ||
97 | INHME | INHME | MEINS | UNIT | 3 | 0 | Content unit | * | |
98 | INHAL | INHAL | MENG13 | QUAN | 13 | 3 | Net contents | ||
99 | VPREH | VPREH | PACK3 | DEC | 5 | 0 | Comparison price unit | ||
100 | ETIAG | ETIAG | ETIAG | CHAR | 18 | 0 | IS-R Labeling: material grouping (deactivated in 4.0) | * | |
101 | INHBR | INHBR | MENG13 | QUAN | 13 | 3 | Gross contents | ||
102 | CMETH | OIB_CMETH | OIB_CMETH | CHAR | 1 | 0 | Quantity Conversion Method | ||
103 | CUOBF | CUOBM | CUOBJ | NUMC | 18 | 0 | Internal object number | ||
104 | KZUMW | KZUMW | XFELD | CHAR | 1 | 0 | Indicator: Environmentally relevant | ||
105 | KOSCH | KOSCH | KOSCH | CHAR | 18 | 0 | Product allocation determination procedure | * | |
106 | SPROF | SPROF | SPROF | CHAR | 1 | 0 | Pricing profile for variants | ||
107 | NRFHG | NRFHG | NRFHG | CHAR | 1 | 0 | Material qualifies for discount in kind | ||
108 | MFRPN | MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number | ||
109 | MFRNR | MFRNR | LIFNR | CHAR | 10 | 0 | Manufacturer number | * | |
110 | BMATN | MPMAT | MATNR | CHAR | 18 | 0 | Number of firm's own (internal) inventory-managed material | * | |
111 | MPROF | MPROF | MPROF | CHAR | 4 | 0 | Mfr part profile | * | |
112 | KZWSM | KZWSO | KZWSO | CHAR | 1 | 0 | Units of measure usage | ||
113 | SAITY | SAITY | SAITY | CHAR | 2 | 0 | Categories of seasonal materials | * | |
114 | PROFL | ADGE_PROFL | ADGD_PROFL | CHAR | 3 | 0 | Dangerous goods indicator profile | * | |
115 | IHIVI | ADGE_IHIVI | X | CHAR | 1 | 0 | Indicator: Highly viscous | ||
116 | ILOOS | ADGE_ILOOS | X | CHAR | 1 | 0 | Indicator: In bulk/liquid | ||
117 | SERLV | SERLV | SERLV | CHAR | 1 | 0 | Level of Explicitness for Serial Number | ||
118 | KZGVH | KZGVH | XFELD | CHAR | 1 | 0 | Shipping material is closed packaging | ||
119 | XGCHP | XGCHP | XFELD | CHAR | 1 | 0 | Indicator: Approved batch record required | ||
120 | KZEFF | CC_MTEFF | XFELD | CHAR | 1 | 0 | Assign effectivity parameter values/ override change numbers | ||
121 | COMPL | CSCP_COMP_LVL | CSCP_COMP_LVL | NUMC | 2 | 0 | Material completion level | * | |
122 | IPRKZ | DATTP | DATTP | CHAR | 1 | 0 | Period Indicator for Shelf Life Expiration Date | ||
123 | RDMHD | RDMHD | RDMHD | CHAR | 1 | 0 | Rounding rule for calculation of SLED | ||
124 | PRZUS | PRZUS | XFELD | CHAR | 1 | 0 | Indicator: Product composition printed on packaging | ||
125 | MTPOS_MARA | MTPOS_MARA | MTPOS | CHAR | 4 | 0 | General item category group | * | |
126 | BFLME | BFLME | BFLME | CHAR | 1 | 0 | Generic Material with Logistical Variants | ||
127 | .INCLU--AP | 0 | 0 | Append MARA-NSNID | |||||
128 | NSNID | DFPS_NSNID | DFPS_NSNID | CHAR | 9 | 0 | NATO Stock Number | ||
129 | .INCLU--AP | 0 | 0 | Vendor Structure Enhancement: Fashion Fields for Mat. Master | |||||
130 | .INCLUDE | 0 | 0 | MARA Extension with New Fields: Seasonal Procurement | |||||
131 | COLOR_ATINN | WRF_COLOR_ATINN | ATINN | NUMC | 10 | 0 | Internal Charactieristic Number for Color Characteristics | * | |
132 | SIZE1_ATINN | WRF_SIZE1_ATINN | ATINN | NUMC | 10 | 0 | Internal Char. Number for Characteristics for Main Sizes | * | |
133 | SIZE2_ATINN | WRF_SIZE2_ATINN | ATINN | NUMC | 10 | 0 | Internal Char. Number for Characteristics for Second Sizes | * | |
134 | COLOR | WRF_COLOR | WRF_ATWRT | CHAR | 18 | 0 | Characteristic Value for Colors of Variants | ||
135 | SIZE1 | WRF_SIZE1 | WRF_ATWRT | CHAR | 18 | 0 | Characteristic Value for Main Sizes of Variants | ||
136 | SIZE2 | WRF_SIZE2 | WRF_ATWRT | CHAR | 18 | 0 | Characteristic Value for Second Size for Variants | ||
137 | FREE_CHAR | WRF_FREE_CHAR | WRF_ATWRT | CHAR | 18 | 0 | Characteristic Value for Evaluation Purposes | ||
138 | CARE_CODE | WRF_CARE_CODE | WRF_CARE_CODE | CHAR | 16 | 0 | Care Codes (such as Washing Code, Ironing Code, etc.) | ||
139 | BRAND_ID | WRF_BRAND_ID | WRF_BRAND_ID | CHAR | 4 | 0 | Brand | WRF_BRANDS | |
140 | FIBER_CODE1 | WRF_FIBER_CODE_1 | WRF_FIBER_CODE | CHAR | 3 | 0 | Fiber Code for Textiles (Component 1) | WRF_FIBER_CODES | |
141 | FIBER_PART1 | WRF_FIBER_PART_1 | WRF_FIBER_PART | NUMC | 3 | 0 | Percentage Share of Fiber (Component 1) | ||
142 | FIBER_CODE2 | WRF_FIBER_CODE_2 | WRF_FIBER_CODE | CHAR | 3 | 0 | Fiber Code for Textiles (Component 2) | WRF_FIBER_CODES | |
143 | FIBER_PART2 | WRF_FIBER_PART_2 | WRF_FIBER_PART | NUMC | 3 | 0 | Percentage Share of Fiber (Component 2) | ||
144 | FIBER_CODE3 | WRF_FIBER_CODE_3 | WRF_FIBER_CODE | CHAR | 3 | 0 | Fiber Code for Textiles (Component 3) | WRF_FIBER_CODES | |
145 | FIBER_PART3 | WRF_FIBER_PART_3 | WRF_FIBER_PART | NUMC | 3 | 0 | Percentage Share of Fiber (Component 3) | ||
146 | FIBER_CODE4 | WRF_FIBER_CODE_4 | WRF_FIBER_CODE | CHAR | 3 | 0 | Fiber Code for Textiles (Component 4) | WRF_FIBER_CODES | |
147 | FIBER_PART4 | WRF_FIBER_PART_4 | WRF_FIBER_PART | NUMC | 3 | 0 | Percentage Share of Fiber (Component 4) | ||
148 | FIBER_CODE5 | WRF_FIBER_CODE_5 | WRF_FIBER_CODE | CHAR | 3 | 0 | Fiber Code for Textiles (Component 5) | WRF_FIBER_CODES | |
149 | FIBER_PART5 | WRF_FIBER_PART_5 | WRF_FIBER_PART | NUMC | 3 | 0 | Percentage Share of Fiber (Component 5) | ||
150 | .INCLU--AP | 0 | 0 | Degree of Fashion Extension | |||||
151 | FASHGRD | FASHGRD | FASHGRD | CHAR | 4 | 0 | Fashion Grade | ||
152 | MPG_LFDNR | MPG_LFDNR | NUMC6 | NUMC | 6 | 0 | Sequence number of media issue within issue sequence |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JSBW_MEDPROD_ATTR | BRAND_ID | WRF_BRANDS | BRAND_ID | |||
2 | JSBW_MEDPROD_ATTR | FIBER_CODE1 | WRF_FIBER_CODES | FIBER_CODE | KEY | 1 | CN |
3 | JSBW_MEDPROD_ATTR | FIBER_CODE2 | WRF_FIBER_CODES | FIBER_CODE | KEY | 1 | CN |
4 | JSBW_MEDPROD_ATTR | FIBER_CODE3 | WRF_FIBER_CODES | FIBER_CODE | KEY | 1 | CN |
5 | JSBW_MEDPROD_ATTR | FIBER_CODE4 | WRF_FIBER_CODES | FIBER_CODE | KEY | 1 | CN |
6 | JSBW_MEDPROD_ATTR | FIBER_CODE5 | WRF_FIBER_CODES | FIBER_CODE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462 |