SAP ABAP Table V_TN1M20L (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | V_TN1M20L | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | HIERID | ISH_MMHID | ISH_MMHID | CHAR | 10 | 0 | IS-H MM: Hierarchy ID for hierarchic material entry | TNM20H | |
3 | NODE | ISH_MMNOD | ISH_MMNOD | CHAR | 10 | 0 | IS-H MM: Node in hierarchic material display | TNM20N | |
4 | POSNR | ISH_MMPNR | ISH_MMPNR | NUMC | 5 | 0 | IS-H MM: Hierarchic Material Entry | ||
5 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | TNM01 | |
6 | MATNR | ISH_MMATNR | MATNR | CHAR | 18 | 0 | IS-H: Material number for material requisition | MARC | |
7 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
8 | MTEXT | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
9 | SETID | ISH_MSETID | ISH_MSETID | CHAR | 8 | 0 | IS-H MM: Identification of a material set | NMSET | |
10 | MDTXT | ISH_MDTXT | TEXT80 | CHAR | 80 | 0 | IS-H: Medical Text for Material | ||
11 | VMENG | ISH_MVMENG | MENGV8 | QUAN | 15 | 3 | IS-H MM: Quantity Consumed | ||
12 | VMEIN | ISH_MVMEIN | MEINS | UNIT | 3 | 0 | IS-H MM: Quantity Consumed | ||
13 | KATID | ISH_MKATID | ISH_MKATID | CHAR | 8 | 0 | IS-H MM: Identification of a material catalog | NMKAT |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | V_TN1M20L | HIERID | TNM20H | HIERID | KEY | 1 | CN |
2 | V_TN1M20L | KATID | NMKAT | KATID | 1 | CN | |
3 | V_TN1M20L | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | V_TN1M20L | MATKL | T023 | MATKL | KEY | 1 | CN |
5 | V_TN1M20L | MATNR | MARC | MATNR | KEY | 1 | CN |
6 | V_TN1M20L | NODE | TNM20N | NODE | KEY | 1 | CN |
7 | V_TN1M20L | SETID | NMSET | SETID | KEY | 1 | CN |
8 | V_TN1M20L | WERKS | TNM01 | WERKS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |