I_BOMITEMHDRCHANGESTATE

CDS View
82 Fields 10 CDS Views

BOM Item with Header Changes

I_BOMITEMHDRCHANGESTATE is a CDS View in S/4HANA. BOM Item with Header Changes. It contains 82 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
A_BOMWhereUsed view from COMPOSITE Where Used List
I_BillOfMaterialItemAPITP view from TRANSACTIONAL Bill of Material Item (Transactional Processing)
I_BillOfMaterialItemAPITP_1 view_entity from TRANSACTIONAL Bill of Material Item (Transactional Processing)
I_BillOfMaterialItemTP view from TRANSACTIONAL Bill Of Material Item Transactional View
I_BOMItmObjDpnAssignment view from COMPOSITE BOM Item Dependency Assignment
I_Bomwhereused view from COMPOSITE Interface view for single level where used list
I_EngineeringRedlineBOMItem view_entity from COMPOSITE Bill of Material Item Redlining
P_SlowMoMatPredBOMCount view left_outer COMPOSITE
P_SlowMoMatPredBOMCounter view left_outer COMPOSITE
R_BillOfMaterialItemTP view_entity from TRANSACTIONAL Bill of Material Item

Fields (82)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 3
KEY BillOfMaterialCategory BillOfMaterialCategory 4
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 4
KEY BillOfMaterialItemUUID BillOfMaterialItemUUID 3
KEY BillOfMaterialVariant BillOfMaterialVariant,BillOfMaterialVariantForEdit 4
KEY BillOfMaterialVersion BillOfMaterialVersion,BillOfMaterialVersionForEdit 4
KEY HeaderChangeDocument HeaderChangeDocument 4
KEY Material Material,MaterialForEdit 4
KEY Plant Plant,PlantForEdit 4
_UnitOfMeasure _UnitOfMeasure 1
BillOfMaterialComponent BillOfMaterialComponent,BOMComponentForEdit 3
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 1
BillOfMaterialItemCategory BillOfMaterialItemCategory 3
BillOfMaterialItemNumber BillOfMaterialItemNumber 3
BillOfMaterialItemQuantity BillOfMaterialItemQuantity 3
BillOfMaterialItemUnit BillOfMaterialItemUnit 3
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BOMIsRecursive BOMIsRecursive 1
BOMItemCreatedByUser BOMItemCreatedByUser 1
BOMItemDescription BOMItemDescription 3
BOMItemHasFixedQuantity BOMItemHasFixedQuantity 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 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
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 1
ClassNumber ClassNumber 1
ClassType ClassType 1
ComponentScrapInPercent ComponentScrapInPercent 1
CostElement CostElement 1
Creditor Creditor 1
Currency Currency 1
DeliveryDurationInDays DeliveryDurationInDays 1
DependencyObjectNumber DependencyObjectNumber 1
DistrKeyCompConsumption DistrKeyCompConsumption 1
DocNumber DocNumber 1
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 1
DocumentPart DocumentPart 1
DocumentType DocumentType 1
DocumentVersion DocumentVersion 1
EngineeringChangeDocument EngineeringChangeDocForEdit,EngineeringChangeDocument 2
FixedQuantity FixedQuantity 1
FormulaKey FormulaKey 1
GoodsReceiptDuration GoodsReceiptDuration 1
IdentifierBOMItem IdentifierBOMItem 1
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 1
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 1
IsBulkMaterial IsBulkMaterial 1
IsClassificationRelevant IsClassificationRelevant 1
IsDeleted IsDeleted 1
IsEngineeringRelevant IsEngineeringRelevant 1
IsMaterialProvision IsMaterialProvision 1
IsNetScrap IsNetScrap 1
IsProductionRelevant IsProductionRelevant 1
IsSubItem IsSubItem 1
IsVersionBillOfMaterial IsVersionBillOfMaterial 1
LongTextLanguage LongTextLanguage 1
MaterialComponentPrice MaterialComponentPrice 1
MaterialGroup MaterialGroup 1
MaterialPriceUnitQty MaterialPriceUnitQty 1
NumberOfVariableSizeItem NumberOfVariableSizeItem,VariableSizeItemQuantity 1
ObjectType ObjectType 1
OperationLeadTimeOffset OperationLeadTimeOffset 1
OperationScrapInPercent OperationScrapInPercent 1
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit 1
PurchasingGroup PurchasingGroup 1
QuantityVariableSizeItem QuantityVariableSizeItem 1
ResultingItemCategory ResultingItemCategory 1
Size1 Size1 1
Size2 Size2 1
Size3 Size3 1
SpecialProcurementType SpecialProcurementType 1
UnitOfMeasureForVarSizeItem UnitOfMeasureForVarSizeItem 1
ValidityEndDate ValidityEndDate 4
ValidityStartDate ValidityStartDate 4
VariableSizeCompUnitOfMeasure VariableSizeCompUnitOfMeasure 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.

-- BOM Item with Header Changes
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BOMITEMHDRCHANGESTATE (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALITEMUUID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    HEADERCHANGEDOCUMENT,
    MATERIAL,
    PLANT,
    _UNITOFMEASURE,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMQUANTITY,
    BILLOFMATERIALITEMUNIT,
    BILLOFMATERIALVARIANTUSAGE,
    BOMISRECURSIVE,
    BOMITEMCREATEDBYUSER,
    BOMITEMDESCRIPTION,
    BOMITEMHASFIXEDQUANTITY,
    BOMITEMINTERNALCHANGECOUNT,
    BOMITEMISCOSTINGRELEVANT,
    BOMITEMISPLANTMAINTRELEVANT,
    BOMITEMISSALESRELEVANT,
    BOMITEMISSPAREPART,
    BOMITEMLASTCHANGEDATE,
    BOMITEMLASTCHANGEDBYUSER,
    BOMITEMRECORDCREATIONDATE,
    BOMITEMSORTER,
    BOMITEMTEXT2,
    CHGTOENGINEERINGCHGDOCUMENT,
    CLASSNUMBER,
    CLASSTYPE,
    COMPONENTSCRAPINPERCENT,
    COSTELEMENT,
    CREDITOR,
    CURRENCY,
    DELIVERYDURATIONINDAYS,
    DEPENDENCYOBJECTNUMBER,
    DISTRKEYCOMPCONSUMPTION,
    DOCNUMBER,
    DOCUMENTISCREATEDBYCAD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    ENGINEERINGCHANGEDOCUMENT,
    FIXEDQUANTITY,
    FORMULAKEY,
    GOODSRECEIPTDURATION,
    IDENTIFIERBOMITEM,
    INHERITEDNODENUMBERFORBOMITEM,
    INHERITEDNODENUMBERVERSIONBOM,
    ISBULKMATERIAL,
    ISCLASSIFICATIONRELEVANT,
    ISDELETED,
    ISENGINEERINGRELEVANT,
    ISMATERIALPROVISION,
    ISNETSCRAP,
    ISPRODUCTIONRELEVANT,
    ISSUBITEM,
    ISVERSIONBILLOFMATERIAL,
    LONGTEXTLANGUAGE,
    MATERIALCOMPONENTPRICE,
    MATERIALGROUP,
    MATERIALPRICEUNITQTY,
    NUMBEROFVARIABLESIZEITEM,
    OBJECTTYPE,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONSCRAPINPERCENT,
    OPSLEADTIMEOFFSETUNIT,
    PURCHASINGGROUP,
    QUANTITYVARIABLESIZEITEM,
    RESULTINGITEMCATEGORY,
    SIZE1,
    SIZE2,
    SIZE3,
    SPECIALPROCUREMENTTYPE,
    UNITOFMEASUREFORVARSIZEITEM,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VARIABLESIZECOMPUNITOFMEASURE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALITEMNODENUMBER, BILLOFMATERIALITEMUUID, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, HEADERCHANGEDOCUMENT, MATERIAL, PLANT)
);

Learn More