Results for “cm_cmpt_grp”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMF.CM_CMPT_GRP is a Process Manufacturing Financials (GMF) table that stores cost component groups. Cost component groups are the containers used to organize and classify the individual cost components that make up a manufactured product's cost rollup. Because the table sits at the top of a parent/child hierarchy — where cost components belong to a group and groups carry a descriptive grouping — its metadata classification is hub-leaning within a Data Vault model. In practice this suggests modeling CM_CMPT_GRP as a hub, with CMPNT_GROUP as the business key, and treating the descriptive attributes (such as CMPNT_GROUP_DESC#1) as satellite data.

Key Information Stored

The table is defined on the GMF schema with 10 documented columns. The most significant are:

• CMPNT_GROUP#1 — The primary grouping identifier. It is the surrogate/business key of the table and is the single column in the unique index CM_CMPT_GRP_PK. The #1 suffix reflects the ETRM convention for the indexed key column.
• CMPNT_GROUP_DESC#1 — The descriptive name of the cost component group, used for reporting and user-facing selection.
• TEXT_CODE — Foreign key to CM_TEXT_HDR, linking the group to its text/description storage.
• TRANS_CNT — A transaction/counter column typically used for concurrency or audit tracking of changes to the row.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard EBS audit columns capturing who created and last updated the record and when.
• DELETE_MARK — The soft-delete indicator; rows with a non-zero mark are logically deleted and should normally be filtered out of active queries.

The surrogate primary key is therefore CMPNT_GROUP#1 (the CM_CMPT_GRP_PK unique index). The description column is a business-attribute candidate rather than a key, since descriptions are not guaranteed unique across the organization.

Common Use Cases and Queries

Cost component groups are referenced during cost rollup, cost analysis, and margin reporting. A typical lookup retrieves all active groups:

SELECT CMPNT_GROUP#1, CMPNT_GROUP_DESC#1
FROM   GMF.CM_CMPT_GRP
WHERE  DELETE_MARK = 0;

Joining the group to its member cost components is the most common reporting pattern, since components reference the group through CMPNT_GROUP:

SELECT m.CMPNT_GROUP, g.CMPNT_GROUP_DESC#1, m.*
FROM   GMF.CM_CMPT_MST m
JOIN   GMF.CM_CMPT_GRP g
       ON m.CMPNT_GROUP = g.CMPNT_GROUP#1
WHERE  g.DELETE_MARK = 0;

Analysts also use the TEXT_CODE join to CM_TEXT_HDR to pull long text descriptions associated with a group. All queries should respect DELETE_MARK and, where audit history matters, sort or filter on LAST_UPDATE_DATE.

Related Objects

• CM_TEXT_HDR — Referenced by CM_CMPT_GRP.TEXT_CODE; provides the text/description header for the group.
• CM_CMPT_MST — References this table via CMPNT_GROUP; the master cost component table that depends on the group definition.
• CM_CMPT_MST_B — References this table via CMPNT_GROUP; the billing/variant master component table that also depends on the group.

These relationships confirm CM_CMPT_GRP as the parent hub for cost component grouping, with CM_CMPT_MST and CM_CMPT_MST_B as the dependent child tables and CM_TEXT_HDR as its text-reference parent.