SAP table CSKR (Resource master record)

SAP table CSKR has 4 primary key fields being MANDT,KOKRS,RESRC,DATBI.

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
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
RESRC Resource CHAR 10 0 CO_RESSOURCE
DATBI Valid To Date DATS 8 0 DATBI
DATAB Valid-From Date DATS 8 0 DATAB
RTYPE Resource type CHAR 1 0 TYPE_RESSOURCE
B Resource is a base planning object
M Resource is a material
R Resource without reference to other objects
REINH Resource Unit UNIT 3 0 T006 MEINH_RESSOURCE
RKSTA Cost Element Under Which the Resource Can be Updated CHAR 10 0 CSKB KSTAR_RESSOURCE
WERKS Plant CHAR 4 0 T001W WERKS_D
MATNR Material Number CHAR 40 0 MARA MATNR
EXTNR Base Planning Object (External Number) CHAR 18 0 CKBS EXTNR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
USNAM Entered By CHAR 12 0 ERFNM
ERFDT Entered On DATS 8 0 ERFDT

CSKR foreign key relationships

Table Field Check Table Check Field
0 CSKR EKORG T024E Purchasing Organizations EKORG
1 CSKR EXTNR CKBS Base Planning Object - Unit Costing MANDT
1 CSKR EXTNR CKBS Base Planning Object - Unit Costing KOKRS
0 CSKR INFNR EINA Purchasing Info Record: General Data INFNR
1 CSKR KOKRS TKA01 Controlling Areas MANDT
0 CSKR MANDT T000 Clients MANDT
1 CSKR MATNR MARA General Material Data MANDT
1 CSKR MATNR MARA General Material Data MATNR
0 CSKR REINH T006 Units of Measurement MANDT
1 CSKR RKSTA CSKB Cost Elements (Data Dependent on Controlling Area) MANDT
1 CSKR RKSTA CSKB Cost Elements (Data Dependent on Controlling Area) KOKRS
1 CSKR RKSTA CSKB Cost Elements (Data Dependent on Controlling Area) KSTAR
1 CSKR RKSTA CSKB Cost Elements (Data Dependent on Controlling Area) DATBI
0 CSKR WERKS T001W Plants/Branches WERKS