SAP table COOMCO (Generated Table for View)

SAP table COOMCO has 18 primary key fields being MANDT,LEDNR,OBJNR,GJAHR,VERSN,BZOBJ,TVERS,KADKY,KALNR,KALKA,KKZMA,DIPA,BWVAR,KEART,KKZMM,KKZST,LOSFX,PATNR.

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
LEDNR Ledger for Controlling Objects CHAR 2 0 LEDNR
00 Standard ledger
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
VERSN Version CHAR 3 0 TKA09 VERSN
BZOBJ Reference Object CHAR 1 0 CK_OBJ
TVERS Costing Version NUMC 2 0 CK_TVERS
KADKY Costing Date (Key) DATS 8 0 CK_KADKY
KALNR Cost Estimate Number - Product Costing NUMC 12 0 CKHS CK_KALNR1
KALKA Costing Type CHAR 2 0 CK_KALKA
KKZMA Costs Entered Manually in Additive or Automatic Cost Est. CHAR 1 0 CK_KKZMA
DIPA Direct Partner Characteristic CHAR 1 0 CK_DIPA
1 Profit Center
2 Plant
3 Company Code
4 Business Area
5 Segmentation Unit
BWVAR Valuation Variant in Costing CHAR 3 0 CK_BWVAR
KEART Type of Cost Component Split for Product Costing CHAR 1 0 KEART
KKZMM Costs Were Entered Manually in an Additive Cost Estimate CHAR 1 0 KKZMM
KKZST Indicator Lower Level/Level CHAR 1 0 CK_STUFE
All
S Level
X Lower Level
LOSFX Link Field for Currency Type CHAR 1 0 CK_LOSFIX
PATNR Partner number for costing NUMC 6 0 NKPRTN
BIDAT Costing Date To DATS 8 0 CK_BIDAT
LOSGR Lot Size for Product Costing QUAN 13 3 CK_LOSGR
CPUDT Date on Which Cost Estimate Was Created DATS 8 0 CK_CPUDT
CPUTIME System Time TIMS 6 0 SYUZEIT
VKSTA Allocation Cost Element CHAR 10 0 CSKA VKSTA
KLVAR Costing Variant CHAR 4 0 TCK03 CK_KLVAR
TARKZ Price Indicator: Calculate Allocation Price CHAR 3 0 TKA10 TARKZ
KST001 Cost Field CURR 13 2 KSTEL
KST002 Cost Field CURR 13 2 KSTEL
KST003 Cost Field CURR 13 2 KSTEL
KST004 Cost Field CURR 13 2 KSTEL
KST005 Cost Field CURR 13 2 KSTEL
KST006 Cost Field CURR 13 2 KSTEL
KST007 Cost Field CURR 13 2 KSTEL
KST008 Cost Field CURR 13 2 KSTEL
KST009 Cost Field CURR 13 2 KSTEL
KST010 Cost Field CURR 13 2 KSTEL
KST011 Cost Field CURR 13 2 KSTEL
KST012 Cost Field CURR 13 2 KSTEL
KST013 Cost Field CURR 13 2 KSTEL
KST014 Cost Field CURR 13 2 KSTEL
KST015 Cost Field CURR 13 2 KSTEL
KST016 Cost Field CURR 13 2 KSTEL
KST017 Cost Field CURR 13 2 KSTEL
KST018 Cost Field CURR 13 2 KSTEL
KST019 Cost Field CURR 13 2 KSTEL
KST020 Cost Field CURR 13 2 KSTEL
KST021 Cost Field CURR 13 2 KSTEL
KST022 Cost Field CURR 13 2 KSTEL
KST023 Cost Field CURR 13 2 KSTEL
KST024 Cost Field CURR 13 2 KSTEL
KST025 Cost Field CURR 13 2 KSTEL
KST026 Cost Field CURR 13 2 KSTEL
KST027 Cost Field CURR 13 2 KSTEL
KST028 Cost Field CURR 13 2 KSTEL
KST029 Cost Field CURR 13 2 KSTEL
KST030 Cost Field CURR 13 2 KSTEL
KST031 Cost Field CURR 13 2 KSTEL
KST032 Cost Field CURR 13 2 KSTEL
KST033 Cost Field CURR 13 2 KSTEL
KST034 Cost Field CURR 13 2 KSTEL
KST035 Cost Field CURR 13 2 KSTEL
KST036 Cost Field CURR 13 2 KSTEL
KST037 Cost Field CURR 13 2 KSTEL
KST038 Cost Field CURR 13 2 KSTEL
KST039 Cost Field CURR 13 2 KSTEL
KST040 Cost Field CURR 13 2 KSTEL
KST041 Cost Field CURR 13 2 KSTEL
KST042 Cost Field CURR 13 2 KSTEL
KST043 Cost Field CURR 13 2 KSTEL
KST044 Cost Field CURR 13 2 KSTEL
KST045 Cost Field CURR 13 2 KSTEL
KST046 Cost Field CURR 13 2 KSTEL
KST047 Cost Field CURR 13 2 KSTEL
KST048 Cost Field CURR 13 2 KSTEL
KST049 Cost Field CURR 13 2 KSTEL
KST050 Cost Field CURR 13 2 KSTEL
KST051 Cost Field CURR 13 2 KSTEL
KST052 Cost Field CURR 13 2 KSTEL
KST053 Cost Field CURR 13 2 KSTEL
KST054 Cost Field CURR 13 2 KSTEL
KST055 Cost Field CURR 13 2 KSTEL
KST056 Cost Field CURR 13 2 KSTEL
KST057 Cost Field CURR 13 2 KSTEL
KST058 Cost Field CURR 13 2 KSTEL
KST059 Cost Field CURR 13 2 KSTEL
KST060 Cost Field CURR 13 2 KSTEL
KST061 Cost Field CURR 13 2 KSTEL
KST062 Cost Field CURR 13 2 KSTEL
KST063 Cost Field CURR 13 2 KSTEL
KST064 Cost Field CURR 13 2 KSTEL
KST065 Cost Field CURR 13 2 KSTEL
KST066 Cost Field CURR 13 2 KSTEL
KST067 Cost Field CURR 13 2 KSTEL
KST068 Cost Field CURR 13 2 KSTEL
KST069 Cost Field CURR 13 2 KSTEL
KST070 Cost Field CURR 13 2 KSTEL
KST071 Cost Field CURR 13 2 KSTEL
KST072 Cost Field CURR 13 2 KSTEL
KST073 Cost Field CURR 13 2 KSTEL
KST074 Cost Field CURR 13 2 KSTEL
KST075 Cost Field CURR 13 2 KSTEL
KST076 Cost Field CURR 13 2 KSTEL
KST077 Cost Field CURR 13 2 KSTEL
KST078 Cost Field CURR 13 2 KSTEL
KST079 Cost Field CURR 13 2 KSTEL
KST080 Cost Field CURR 13 2 KSTEL
KST081 Cost Field CURR 13 2 KSTEL
KST082 Cost Field CURR 13 2 KSTEL
KST083 Cost Field CURR 13 2 KSTEL
KST084 Cost Field CURR 13 2 KSTEL
KST085 Cost Field CURR 13 2 KSTEL
KST086 Cost Field CURR 13 2 KSTEL
KST087 Cost Field CURR 13 2 KSTEL
KST088 Cost Field CURR 13 2 KSTEL
KST089 Cost Field CURR 13 2 KSTEL
KST090 Cost Field CURR 13 2 KSTEL
KST091 Cost Field CURR 13 2 KSTEL
KST092 Cost Field CURR 13 2 KSTEL
KST093 Cost Field CURR 13 2 KSTEL
KST094 Cost Field CURR 13 2 KSTEL
KST095 Cost Field CURR 13 2 KSTEL
KST096 Cost Field CURR 13 2 KSTEL
KST097 Cost Field CURR 13 2 KSTEL
KST098 Cost Field CURR 13 2 KSTEL
KST099 Cost Field CURR 13 2 KSTEL
KST100 Cost Field CURR 13 2 KSTEL
KST101 Cost Field CURR 13 2 KSTEL
KST102 Cost Field CURR 13 2 KSTEL
KST103 Cost Field CURR 13 2 KSTEL
KST104 Cost Field CURR 13 2 KSTEL
KST105 Cost Field CURR 13 2 KSTEL
KST106 Cost Field CURR 13 2 KSTEL
KST107 Cost Field CURR 13 2 KSTEL
KST108 Cost Field CURR 13 2 KSTEL
KST109 Cost Field CURR 13 2 KSTEL
KST110 Cost Field CURR 13 2 KSTEL
KST111 Cost Field CURR 13 2 KSTEL
KST112 Cost Field CURR 13 2 KSTEL
KST113 Cost Field CURR 13 2 KSTEL
KST114 Cost Field CURR 13 2 KSTEL
KST115 Cost Field CURR 13 2 KSTEL
KST116 Cost Field CURR 13 2 KSTEL
KST117 Cost Field CURR 13 2 KSTEL
KST118 Cost Field CURR 13 2 KSTEL
KST119 Cost Field CURR 13 2 KSTEL
KST120 Cost Field CURR 13 2 KSTEL

COOMCO foreign key relationships

Table Field Check Table Check Field
0 COOMCO KALNR CKHS Header: Unit Costing (Control + Totals) MANDT
0 COOMCO KALNR CKHS Header: Unit Costing (Control + Totals) LEDNR
0 COOMCO KALNR CKHS Header: Unit Costing (Control + Totals) KALNR
0 COOMCO KALNR CKHS Header: Unit Costing (Control + Totals) KALKA
0 COOMCO KALNR CKHS Header: Unit Costing (Control + Totals) KADKY
0 COOMCO KALNR CKHS Header: Unit Costing (Control + Totals) TVERS
0 COOMCO KALNR CKHS Header: Unit Costing (Control + Totals) BWVAR
0 COOMCO KALNR CKHS Header: Unit Costing (Control + Totals) KKZMA
1 COOMCO KLVAR TCK03 Costing Variants MANDT
0 COOMCO MANDT T000 Clients MANDT
1 COOMCO OBJNR ONR00 General Object Number MANDT
0 COOMCO TARKZ TKA10 Master Data Table, Price Indicators MANDT
0 COOMCO TARKZ TKA10 Master Data Table, Price Indicators TARKZ
1 COOMCO VERSN TKA09 Basic Settings for Versions MANDT
1 COOMCO VERSN TKA09 Basic Settings for Versions KOKRS
1 COOMCO VERSN TKA09 Basic Settings for Versions VERSN
0 COOMCO VKSTA CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
0 COOMCO VKSTA CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL