SAP ABAP Table /SRMERP/CCS_MAT (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | /SRMERP/CCS_MAT |
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 | SPRAS |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
| 3 | WERKS |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 4 | MATNR |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | ||
| 5 | MAKTX |
MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
| 6 | MAKTG |
MAKTG | CHAR40 | CHAR | 40 | 0 | Material description in upper case for matchcodes | ||
| 7 | MEINS |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
| 8 | MFRNR |
MFRNR | LIFNR | CHAR | 10 | 0 | Manufacturer number | LFA1 | |
| 9 | EKGRP |
EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
| 10 | BESKZ |
BESKZ | BESKZ | CHAR | 1 | 0 | Procurement Type | ||
| 11 | MMSTA |
MMSTA | MMSTA | CHAR | 2 | 0 | Plant-Specific Material Status | T141 | |
| 12 | MATKL |
MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
| 13 | VPRSV |
VPRSV | VPRSV | CHAR | 1 | 0 | Price control indicator | ||
| 14 | VERPR |
VERPR | WERT11V | CURR | 11 | 2 | Moving Average Price/Periodic Unit Price | ||
| 15 | STPRS |
STPRS | WERT11V | CURR | 11 | 2 | Standard price | ||
| 16 | PEINH |
PEINH | PACK3 | DEC | 5 | 0 | Price unit | ||
| 17 | BWKEY |
BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | T001K | |
| 18 | BWTAR |
BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /SRMERP/CCS_MAT | BWKEY |  T001K |
BWKEY |
KEY | 1 | CN |
| 2 | /SRMERP/CCS_MAT | EKGRP | T024 |
EKGRP |
REF | C | CN |
| 3 | /SRMERP/CCS_MAT | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 4 | /SRMERP/CCS_MAT | MATKL | T023 |
MATKL |
REF | C | CN |
| 5 | /SRMERP/CCS_MAT | MEINS | T006 |
MSEHI |
REF | 1 | CN |
| 6 | /SRMERP/CCS_MAT | MFRNR | LFA1 |
LIFNR |
|||
| 7 | /SRMERP/CCS_MAT | MMSTA | T141 |
MMSTA |
REF | C | CN |
| 8 | /SRMERP/CCS_MAT | SPRAS | T002 |
SPRAS |
KEY | 1 | CN |
| 9 | /SRMERP/CCS_MAT | WERKS | T001W |
WERKS |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in |
