I_CHGIMPACTBOMITEM
Bill of Material Items
I_CHGIMPACTBOMITEM is a CDS View in S/4HANA. Bill of Material Items. It contains 34 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ChgImpactBOMItem | view | from | CONSUMPTION | Change Impact Engineering Bill Of Material Items |
Fields (34)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfMaterial | BillOfMaterial | 1 |
| KEY | BillOfMaterialCategory | BillOfMaterialCategory | 1 |
| KEY | BillOfMaterialItemNodeNumber | BillOfMaterialItemNodeNumber | 1 |
| KEY | BillOfMaterialVariant | BillOfMaterialVariant | 1 |
| KEY | BillOfMaterialVersion | BillOfMaterialVersion | 1 |
| KEY | BOMItemInternalChangeCount | BOMItemInternalChangeCount | 1 |
| BillOfMaterialComponent | BillOfMaterialComponent | 1 | |
| BillOfMaterialItemCategory | BillOfMaterialItemCategory | 1 | |
| BillOfMaterialItemNumber | BillOfMaterialItemNumber | 1 | |
| BillOfMaterialItemQuantity | BillOfMaterialItemQuantity | 1 | |
| BillOfMaterialItemUnit | BillOfMaterialItemUnit | 1 | |
| BillOfMaterialItemUUID | BillOfMaterialItemUUID | 1 | |
| BOMItemCreatedByUser | BOMItemCreatedByUser | 1 | |
| BOMItemDescription | BOMItemDescription | 1 | |
| BOMItemIsCostingRelevant | BOMItemIsCostingRelevant | 1 | |
| BOMItemIsPlantMaintRelevant | BOMItemIsPlantMaintRelevant | 1 | |
| BOMItemIsSalesRelevant | BOMItemIsSalesRelevant | 1 | |
| BOMItemIsSparePart | BOMItemIsSparePart | 1 | |
| BOMItemLastChangeDate | BOMItemLastChangeDate | 1 | |
| BOMItemLastChangedByUser | BOMItemLastChangedByUser | 1 | |
| BOMItemRecordCreationDate | BOMItemRecordCreationDate | 1 | |
| BOMItemSorter | BOMItemSorter | 1 | |
| BOMItemText2 | BOMItemText2 | 1 | |
| ComplexAssemblyType | ComplexAssemblyType | 1 | |
| EffectivityType | EffectivityType | 1 | |
| EngineeringChangeDocument | EngineeringChangeDocument | 1 | |
| FixedQuantity | FixedQuantity | 1 | |
| InheritedNodeNumberForBOMItem | InheritedNodeNumberForBOMItem | 1 | |
| InheritedNodeNumberVersionBOM | InheritedNodeNumberVersionBOM | 1 | |
| IsMaterialUnitized | IsMaterialUnitized | 1 | |
| MaterialPriceUnitQty | MaterialPriceUnitQty | 1 | |
| Plant | Plant | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Bill of Material Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGIMPACTBOMITEM (
BILLOFMATERIAL,
BILLOFMATERIALCATEGORY,
BILLOFMATERIALITEMNODENUMBER,
BILLOFMATERIALVARIANT,
BILLOFMATERIALVERSION,
BOMITEMINTERNALCHANGECOUNT,
BILLOFMATERIALCOMPONENT,
BILLOFMATERIALITEMCATEGORY,
BILLOFMATERIALITEMNUMBER,
BILLOFMATERIALITEMQUANTITY,
BILLOFMATERIALITEMUNIT,
BILLOFMATERIALITEMUUID,
BOMITEMCREATEDBYUSER,
BOMITEMDESCRIPTION,
BOMITEMISCOSTINGRELEVANT,
BOMITEMISPLANTMAINTRELEVANT,
BOMITEMISSALESRELEVANT,
BOMITEMISSPAREPART,
BOMITEMLASTCHANGEDATE,
BOMITEMLASTCHANGEDBYUSER,
BOMITEMRECORDCREATIONDATE,
BOMITEMSORTER,
BOMITEMTEXT2,
COMPLEXASSEMBLYTYPE,
EFFECTIVITYTYPE,
ENGINEERINGCHANGEDOCUMENT,
FIXEDQUANTITY,
INHERITEDNODENUMBERFORBOMITEM,
INHERITEDNODENUMBERVERSIONBOM,
ISMATERIALUNITIZED,
MATERIALPRICEUNITQTY,
PLANT,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALITEMNODENUMBER, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, BOMITEMINTERNALCHANGECOUNT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA