SAP table CRVM_A (Link of PRT data to a material)

SAP table CRVM_A has 5 primary key fields being MANDT,OBJTY,OBJID,MATNR,WERKS.

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
OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
OBJID Object ID of the resource NUMC 8 0 CRID CR_OBJID
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 MARC WERKS_D

CRVM_A foreign key relationships

Table Field Check Table Check Field
0 CRVM_A MANDT T000 Clients MANDT
1 CRVM_A MATNR MARA General Material Data MANDT
1 CRVM_A MATNR MARA General Material Data MATNR
0 CRVM_A OBJID CRID CIM Resource - Entities MANDT
0 CRVM_A OBJID CRID CIM Resource - Entities OBJID
1 CRVM_A WERKS MARC Plant Data for Material MANDT
1 CRVM_A WERKS MARC Plant Data for Material MATNR
1 CRVM_A WERKS MARC Plant Data for Material WERKS