I_BILLOFMATERIALITEMTP

CDS View
80 Fields 6 CDS Views

Bill Of Material Item Transactional View

I_BILLOFMATERIALITEMTP is a CDS View in S/4HANA. Bill Of Material Item Transactional View. It contains 80 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_BillOfMaterialItemTP view from CONSUMPTION Bill Of Material Item Consumption View
C_BOMComponentVH view from CONSUMPTION BOM component
C_BOMwhereUsed view from CONSUMPTION Consumption View for Material Where-Used
C_ChgRecdObjPgBOMComponent view_entity from CONSUMPTION Bill Of Material Item Consumption
C_ProductBOMItem view from CONSUMPTION Product Master BOM Items
P_BOMItemLinks view inner COMPOSITE

Fields (80)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 2
KEY BillOfMaterialCategory BillOfMaterialCategory 3
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 3
KEY BillOfMaterialVariant BillOfMaterialVariant 3
KEY BillOfMaterialVersion BillOfMaterialVersion 3
KEY HeaderChangeDocument EngineeringChangeDocument,HeaderChangeDocument 4
KEY Material Material 3
KEY Plant Plant 3
BillOfMaterialComponent BillOfMaterialComponent 3
BillOfMaterialItemCategory BillOfMaterialItemCategory 2
BillOfMaterialItemNumber BillOfMaterialItemNumber 2
BillOfMaterialItemQuantity BillOfMaterialItemQuantity 3
BillOfMaterialItemUnit BillOfMaterialItemUnit 2
BillOfMaterialItemUUID BillOfMaterialItemUUID 3
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
BOMComponentForEdit BOMComponentForEdit 1
BOMIsRecursive BOMIsRecursive 1
BOMItemCreatedByUser BOMItemCreatedByUser 2
BOMItemDescription BOMItemDescription 3
BOMItemHasFixedQuantity BOMItemHasFixedQuantity 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 1
BOMItemIsCostingRelevant BOMItemIsCostingRelevant 1
BOMItemIsPlantMaintRelevant BOMItemIsPlantMaintRelevant 1
BOMItemIsSalesRelevant BOMItemIsSalesRelevant 1
BOMItemIsSparePart BOMItemIsSparePart 1
BOMItemLastChangeDate BOMItemLastChangeDate 2
BOMItemLastChangedByUser BOMItemLastChangedByUser 2
BOMItemRecordCreationDate BOMItemRecordCreationDate 2
BOMItemSorter BOMItemSorter 1
BOMItemText2 BOMItemText2 1
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 1
ComponentDescription ComponentDescription 2
ComponentScrapInPercent ComponentScrapInPercent 1
CostElement CostElement 1
Creditor Creditor 2
Currency Currency 1
DeliveryDurationInDays DeliveryDurationInDays 1
DependencyObjectNumber DependencyObjectNumber 1
DistrKeyCompConsumption DistrKeyCompConsumption 1
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 1
EngineeringChangeDocForEdit ChangeNumber,EngineeringChangeDocForEdit 2
EngineeringChangeDocument EngineeringChangeDocument 2
FixedQuantity FixedQuantity 1
FormulaKey FormulaKey 1
GoodsReceiptDuration GoodsReceiptDuration 1
IdentifierBOMItem IdentifierBOMItem 2
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 1
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 1
IsAssembly IsAssembly 2
IsBulkMaterial IsBulkMaterial 1
IsBulkMaterialComponent IsBulkMaterialComponent 1
IsClassificationRelevant IsClassificationRelevant 1
IsDeleted IsDeleted 1
IsEngineeringRelevant IsEngineeringRelevant 1
IsMaterialProvision IsMaterialProvision 1
IsNetScrap IsNetScrap 1
IsProductionRelevant IsProductionRelevant 1
IsSubItem IsSubItem 2
LongTextLanguage LongTextLanguage 1
MaterialComponentPrice MaterialComponentPrice 1
MaterialGroup MaterialGroup 1
MaterialPriceUnitQty MaterialPriceUnitQty 1
MultipleSelectionAllowed MultipleSelectionAllowed 1
NumberOfVariableSizeItem NumberOfVariableSizeItem 1
ObjectType ObjectType 1
OperationLeadTimeOffset OperationLeadTimeOffset 1
OperationScrapInPercent OperationScrapInPercent 1
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit 1
PreliminaryMaterial PreliminaryMaterial 2
ProductIsConfigurable ProductIsConfigurable 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
RequiredComponent RequiredComponent 1
ResultingItemCategory ResultingItemCategory 1
Size2 Size2 1
Size3 Size3 1
SpecialProcurementType SpecialProcurementType 1
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 1
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.

-- Bill Of Material Item Transactional View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLOFMATERIALITEMTP (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    HEADERCHANGEDOCUMENT,
    MATERIAL,
    PLANT,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMQUANTITY,
    BILLOFMATERIALITEMUNIT,
    BILLOFMATERIALITEMUUID,
    BILLOFMATERIALVARIANTUSAGE,
    BOMCOMPONENTFOREDIT,
    BOMISRECURSIVE,
    BOMITEMCREATEDBYUSER,
    BOMITEMDESCRIPTION,
    BOMITEMHASFIXEDQUANTITY,
    BOMITEMINTERNALCHANGECOUNT,
    BOMITEMISCOSTINGRELEVANT,
    BOMITEMISPLANTMAINTRELEVANT,
    BOMITEMISSALESRELEVANT,
    BOMITEMISSPAREPART,
    BOMITEMLASTCHANGEDATE,
    BOMITEMLASTCHANGEDBYUSER,
    BOMITEMRECORDCREATIONDATE,
    BOMITEMSORTER,
    BOMITEMTEXT2,
    CHGTOENGINEERINGCHGDOCUMENT,
    COMPONENTDESCRIPTION,
    COMPONENTSCRAPINPERCENT,
    COSTELEMENT,
    CREDITOR,
    CURRENCY,
    DELIVERYDURATIONINDAYS,
    DEPENDENCYOBJECTNUMBER,
    DISTRKEYCOMPCONSUMPTION,
    DOCUMENTISCREATEDBYCAD,
    ENGINEERINGCHANGEDOCFOREDIT,
    ENGINEERINGCHANGEDOCUMENT,
    FIXEDQUANTITY,
    FORMULAKEY,
    GOODSRECEIPTDURATION,
    IDENTIFIERBOMITEM,
    INHERITEDNODENUMBERFORBOMITEM,
    INHERITEDNODENUMBERVERSIONBOM,
    ISASSEMBLY,
    ISBULKMATERIAL,
    ISBULKMATERIALCOMPONENT,
    ISCLASSIFICATIONRELEVANT,
    ISDELETED,
    ISENGINEERINGRELEVANT,
    ISMATERIALPROVISION,
    ISNETSCRAP,
    ISPRODUCTIONRELEVANT,
    ISSUBITEM,
    LONGTEXTLANGUAGE,
    MATERIALCOMPONENTPRICE,
    MATERIALGROUP,
    MATERIALPRICEUNITQTY,
    MULTIPLESELECTIONALLOWED,
    NUMBEROFVARIABLESIZEITEM,
    OBJECTTYPE,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONSCRAPINPERCENT,
    OPSLEADTIMEOFFSETUNIT,
    PRELIMINARYMATERIAL,
    PRODUCTISCONFIGURABLE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    REQUIREDCOMPONENT,
    RESULTINGITEMCATEGORY,
    SIZE2,
    SIZE3,
    SPECIALPROCUREMENTTYPE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    VARIABLESIZECOMPUNITOFMEASURE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALITEMNODENUMBER, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, HEADERCHANGEDOCUMENT, MATERIAL, PLANT)
);

Learn More