SAP ABAP Table PLM_MAT_SEARCH (PLM MyObjects: BUS1001 External Search MiniApp)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ LO-MD-MM (Application Component) Material Master
⤷ PLM_MATERIALS (Package) PLM Portals: Materials Management
⤷ LO-MD-MM (Application Component) Material Master
⤷ PLM_MATERIALS (Package) PLM Portals: Materials Management
Basic Data
Table Category | INTTAB | Structure |
Structure | PLM_MAT_SEARCH | Table Relationship Diagram |
Short Description | PLM MyObjects: BUS1001 External Search MiniApp |
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 | Transfer Structure for MyObjects | |||||
2 | PARENT | PLM_AMYO_NODE | PLM_AMYO_NODD | CHAR | 10 | 0 | Nodes in MyObjects (key) | ||
3 | OBJKEY | PLM_SWO_TYPEID | PLM_SWO_TYPEID | CHAR | 70 | 0 | Object Key | ||
4 | OBJTYPE | PLM_SWO_OBJTYP | PLM_OJ_NAME | CHAR | 10 | 0 | Object Type | ||
5 | LOGSYS | PLM_LOGSYS | PLM_LOGSYS | CHAR | 10 | 0 | Logical System | ||
6 | TEXT | PLM_AMYO_TEXT | PLM_PLM_AMYO_TEXT | CHAR | 132 | 0 | Text of a MyObjects Entry | ||
7 | POSI | PLM_AMYO_POS | INT4 | INT4 | 10 | 0 | Position Within a Node | ||
8 | TIMESTAMP | PLM_TIMESTAMP | PLM_TIMESTAMP | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
9 | .INCLUDE | 0 | 0 | PLM MyObjects: BUS1001 Internal Search MiniApp | |||||
10 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
11 | .INCLUDE | 0 | 0 | Material Get Detail - Material Data at Client Level | |||||
12 | MATL_DESC | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
13 | OLD_MAT_NO | BISMT | BISMT | CHAR | 18 | 0 | Old material number | ||
14 | MATL_TYPE | MTART | MTART | CHAR | 4 | 0 | Material type | T134 | |
15 | IND_SECTOR | MBRSH | MBRSH | CHAR | 1 | 0 | Industry sector | T137 | |
16 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
17 | MATL_GROUP | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
18 | PROD_HIER | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | T179 | |
19 | BASIC_MATL | WRKST_OLD | WRKST_OLD | CHAR | 14 | 0 | Basic material (basic constituent of a material) - obsolete | * | |
20 | STD_DESCR | NORMT | NORMT | CHAR | 18 | 0 | Industry Standard Description (such as ANSI or ISO) | ||
21 | LAB_DESIGN | LABOR | LABOR | CHAR | 3 | 0 | Laboratory/design office | T024L | |
22 | PROD_MEMO | FERTH | FERTH | CHAR | 18 | 0 | Production/inspection memo | ||
23 | PAGEFORMAT | FORMT | DINFO | CHAR | 4 | 0 | Page Format of Production Memo | ||
24 | CONTAINER | BEHVO | BEHVO | CHAR | 2 | 0 | Container requirements | T144 | |
25 | STOR_CONDS | RAUBE | RAUBE | CHAR | 2 | 0 | Storage conditions | T142 | |
26 | TEMP_CONDS | TEMPB | TEMPB | CHAR | 2 | 0 | Temperature conditions indicator | T143 | |
27 | BASE_UOM | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
28 | EAN_UPC | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
29 | EAN_CAT | NUMTP | NUMTP | CHAR | 2 | 0 | Category of International Article Number (EAN) | TNTP | |
30 | SIZE_DIM | GROES | CHAR32 | CHAR | 32 | 0 | Size/dimensions | ||
31 | GROSS_WT | BRGEW | MENG13 | QUAN | 13 | 3 | Gross weight | ||
32 | NET_WEIGHT | NTGEW | MENG13 | QUAN | 13 | 3 | Net weight | ||
33 | UNIT_OF_WT | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | T006 | |
34 | VOLUME | VOLUM | MENG13 | QUAN | 13 | 3 | Volume | ||
35 | VOLUMEUNIT | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | T006 | |
36 | LENGTH | LAENG | MENG13 | QUAN | 13 | 3 | Length | ||
37 | WIDTH | BREIT | MENG13 | QUAN | 13 | 3 | Width | ||
38 | HEIGHT | HOEHE | MENG13 | QUAN | 13 | 3 | Height | ||
39 | UNIT_DIM | MEABM | MEINS | UNIT | 3 | 0 | Unit of Dimension for Length/Width/Height | T006 | |
40 | MANU_MAT | MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number | ||
41 | MFR_NO | MFRNR | LIFNR | CHAR | 10 | 0 | Manufacturer number | LFA1 | |
42 | BASE_UOM_ISO | MEINS_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Base unit of measure in ISO code | T006I | |
43 | UNIT_OF_WT_ISO | GEWEI_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of weight in ISO code | T006I | |
44 | VOLUMEUNIT_ISO | VOLEH_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Volume unit in ISO code | T006I | |
45 | UNIT_DIM_ISO | MEABM_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit for length/breadth/height in ISO code | T006I | |
46 | CREATED_ON | ERSDA | DATUM | DATS | 8 | 0 | Created On | ||
47 | CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
48 | LAST_CHNGE | LAEDA | DATUM | DATS | 8 | 0 | Date of Last Change | ||
49 | CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
50 | MATL_CAT | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
51 | EMPTIESBOM | W_MITLEERG | FLAG | CHAR | 1 | 0 | Empties Bill of Material | ||
52 | BASIC_MATL_NEW | WRKST | WRKST | CHAR | 48 | 0 | Basic Material | TWSPR | |
53 | .INCLU--AP | 0 | 0 | Foreign Key Definitions | |||||
54 | MATDES | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PLM_MAT_SEARCH | BASE_UOM | T006 | MSEHI | |||
2 | PLM_MAT_SEARCH | BASE_UOM_ISO | T006I | ISOCODE | |||
3 | PLM_MAT_SEARCH | BASIC_MATL_NEW | TWSPR | WRKST | |||
4 | PLM_MAT_SEARCH | CONTAINER | T144 | BEHVO | |||
5 | PLM_MAT_SEARCH | DIVISION | TSPA | SPART | |||
6 | PLM_MAT_SEARCH | EAN_CAT | TNTP | NUMTP | |||
7 | PLM_MAT_SEARCH | IND_SECTOR | T137 | MBRSH | |||
8 | PLM_MAT_SEARCH | LAB_DESIGN | T024L | LABOR | |||
9 | PLM_MAT_SEARCH | MATL_GROUP | T023 | MATKL | |||
10 | PLM_MAT_SEARCH | MATL_TYPE | T134 | MTART | |||
11 | PLM_MAT_SEARCH | MFR_NO | LFA1 | LIFNR | |||
12 | PLM_MAT_SEARCH | PROD_HIER | T179 | PRODH | |||
13 | PLM_MAT_SEARCH | STOR_CONDS | T142 | RAUBE | |||
14 | PLM_MAT_SEARCH | TEMP_CONDS | T143 | TEMPB | |||
15 | PLM_MAT_SEARCH | UNIT_DIM | T006 | MSEHI | |||
16 | PLM_MAT_SEARCH | UNIT_DIM_ISO | T006I | ISOCODE | |||
17 | PLM_MAT_SEARCH | UNIT_OF_WT | T006 | MSEHI | |||
18 | PLM_MAT_SEARCH | UNIT_OF_WT_ISO | T006I | ISOCODE | |||
19 | PLM_MAT_SEARCH | VOLUMEUNIT | T006 | MSEHI | |||
20 | PLM_MAT_SEARCH | VOLUMEUNIT_ISO | T006I | ISOCODE |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |