SAP table CMDT_PC (Generic Master Record: Profit Center Enhancements)

SAP table CMDT_PC has 4 primary key fields being MANDT,OBJNR,DATBI,STATUS.

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
OBJNR Object number CHAR 22 0 CMDT J_OBJNR
DATBI Valid To Date DATS 8 0 DATBI
STATUS Activation Status of Generic Master Record CHAR 1 0 CMDT_STATUS
A Active
D Inactive: Delete
I Inactive: Create
U Inactive: Change
DATAB Valid-From Date DATS 8 0 DATAB
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
PRCTR Profit Center CHAR 10 0 KEO_PRCTR
KHINR Standard Hierarchy Area CHAR 12 0 CMDT_HIERAREA
VERAK Person responsible CHAR 20 0 RESP_PERS
VERAK_USER User Responsible CHAR 12 0 USR02 VERAK_USER
WAERS Currency Key CUKY 5 0 * WAERS
ABTEI Department CHAR 12 0 ABTEIL
LOCK_IND Lock indicator CHAR 1 0 LOCK_IND
LOCK_IND_PLAN Lock indicator - Plan CHAR 1 0 LOCK_IND_PL
PCA_TEMPLATE Template for Formula Planning in Profit Centers CHAR 10 0 * PCA_TEMPLATE
EEW_CEPC_PS_DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT

CMDT_PC foreign key relationships

Table Field Check Table Check Field
0 CMDT_PC KOKRS TKA01 Controlling Areas MANDT
1 CMDT_PC MANDT T000 Clients MANDT
0 CMDT_PC OBJNR CMDT Generic Master Record: General Header .INCLUDE
0 CMDT_PC OBJNR CMDT Generic Master Record: General Header MANDT
0 CMDT_PC OBJNR CMDT Generic Master Record: General Header OBJNR
0 CMDT_PC OBJNR CMDT Generic Master Record: General Header DATBI
1 CMDT_PC SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 CMDT_PC VERAK_USER USR02 Logon Data (Kernel-Side Use) BNAME