SAP Table CPSTOCK
Result list for stock information for MSA
CPSTOCK (Result list for stock information for MSA) 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 CPSTOCK to other SAP tables.
CPSTOCK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||
| FLAG | Critical Flag | CRM_CPB_CRITICAL_FLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||
| VALUE1 | Critical stock value | CRM_CBP_MARGINAL_VALUE1 | QUAN | 13 | 3 | |||||||||||
| VALUE2 | Very critical stock value | CRM_CBP_MARGINAL_VALUE2 | QUAN | 13 | 3 | |||||||||||
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||||||
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 | 0 | ||||||||||
CPSTOCK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CPSTOCK | LOGSYS | CPSTOCK | LOGSYS | TBDLS | Logical system | LOGSYS |
| CPSTOCK | MANDT | CPSTOCK | MANDT | T000 | Clients | MANDT |
| CPSTOCK | MATNR | CPSTOCK | MANDT | MARA | General Material Data | MANDT |
| CPSTOCK | MATNR | CPSTOCK | MATNR | MARA | General Material Data | MATNR |
| CPSTOCK | MEINS | CPSTOCK | MANDT | T006 | Units of Measurement | MANDT |
| CPSTOCK | MEINS | CPSTOCK | MEINS | T006 | Units of Measurement | MSEHI |
| CPSTOCK | VKORG | CPSTOCK | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| CPSTOCK | VKORG | CPSTOCK | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| CPSTOCK | VTWEG | CPSTOCK | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| CPSTOCK | VTWEG | CPSTOCK | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
