SAP table CPSTOCK (Result list for stock information for MSA)

SAP table CPSTOCK has 4 primary key fields being MANDT,VKORG,VTWEG,MATNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
MATNR Material Number CHAR 40 0 MARA MATNR
FLAG Critical Flag CHAR 1 0 CRM_CPB_CRITICAL_FLAG
A okay
B critical
C very critical
E error
VALUE1 Critical stock value QUAN 13 3 CRM_CBP_MARGINAL_VALUE1
VALUE2 Very critical stock value QUAN 13 3 CRM_CBP_MARGINAL_VALUE2
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
AEDAT Last Changed On DATS 8 0 AEDAT
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS

CPSTOCK foreign key relationships

Table Field Check Table Check Field
0 CPSTOCK LOGSYS TBDLS Logical system LOGSYS
1 CPSTOCK MANDT T000 Clients MANDT
0 CPSTOCK MATNR MARA General Material Data MANDT
0 CPSTOCK MATNR MARA General Material Data MATNR
1 CPSTOCK MEINS T006 Units of Measurement MANDT
1 CPSTOCK MEINS T006 Units of Measurement MSEHI
0 CPSTOCK VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 CPSTOCK VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 CPSTOCK VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 CPSTOCK VTWEG TVTW Organizational Unit: Distribution Channels VTWEG