I_BILLOFMATERIALTP

CDS View
70 Fields 4 CDS Views

Bill Of Material Transactional view

I_BILLOFMATERIALTP is a CDS View in S/4HANA. Bill Of Material Transactional view. It contains 70 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_BillOfMaterialTP view from CONSUMPTION Bill Of Material Consumption View
C_BOMItemGroupCreateForUI view_entity from CONSUMPTION Create Item Group
C_BOMWhereUsedHeader view from CONSUMPTION Header View for Material Where-Used
C_ProductBOM view from CONSUMPTION Consumption view for Product BOM

Fields (70)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 3
KEY BillOfMaterialCategory BillOfMaterialCategory 3
KEY BillOfMaterialVariant BillOfMaterialVariant 2
KEY BillOfMaterialVersion BillOfMaterialVersion 3
KEY EngineeringChangeDocument EngineeringChangeDocument 3
KEY Material Material 2
KEY Plant NewPlant,Plant 3
_SoldToParty _SoldToParty 1
AlternativeUnit AlternativeUnit 1
AssetIntelNetworkManufacturer AssetIntelNetworkManufacturer 2
AssetIntelNetworkTemplate AssetIntelNetworkTemplate 2
AssetIntelNetworkTrackingMode AssetIntelNetworkTrackingMode 2
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 2
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 2
BillOfMaterialStatus BillOfMaterialStatus 2
BillOfMaterialUUID BillOfMaterialUUID 2
BillOfMaterialVariantForEdit BillOfMaterialVariantForEdit 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 3
BillOfMaterialVersionForEdit BillOfMaterialVersionForEdit 2
BOMAlternativeText BOMAlternativeText 2
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant 2
BOMExplosionApplication BOMExplosionApplication 2
BOMGroup BOMGroup 2
BOMHeaderBaseUnit BOMHeaderBaseUnit,BOMUnitForEdit 3
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 2
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit,BOMQuantityForEdit 3
BOMHeaderText BOMHeaderText 2
BOMIsArchivedForDeletion BOMIsArchivedForDeletion 1
BOMIsConfigurable BOMIsConfigurable 1
BOMIsToBeDeleted BOMIsToBeDeleted 2
BOMPredecessorVersion BOMPredecessorVersion 2
BOMPrioritizedVersion BOMPrioritizedVersion 2
BOMUsagePriority BOMUsagePriority 2
BOMVersionStatus BOMVersionStatus 2
BOMVersionStatusDescription BOMVersionStatusDescription 2
ChangeRecord ChangeRecord 1
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 2
CreatedByUser CreatedByUser 2
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 2
EngineeringChangeDocForEdit EngineeringChangeDocForEdit 1
HeaderAttachmentKey HeaderAttachmentKey 2
HeaderValidityEndDate HeaderValidityEndDate 2
HeaderValidityStartDate HeaderValidityStartDate 2
IndicatorIsBOMChangedWithHist IndicatorIsBOMChangedWithHist 1
IsALE IsALE 2
IsConfiguredMaterial IsConfiguredMaterial 2
IsLatestBOMVersion IsLatestBOMVersion 2
IsMarkedForDeletion IsMarkedForDeletion 2
IsMultipleBOMAlt IsMultipleBOMAlt 2
IsVersionBillOfMaterial IsVersionBillOfMaterial 2
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
LongTextExists LongTextExists 1
LongTextLanguage LongTextLanguage 1
MaterialBOMObjectID MaterialBOMObjectID 2
MaterialForEdit MaterialForDisplay,MaterialForEdit 2
MaterialToLotSizeQuantity MaterialToLotSizeQuantity 2
MaterialType MaterialType 2
MatFromLotSizeQuantity MatFromLotSizeQuantity 2
PlantForEdit PlantForEdit 2
ProductGroup ProductGroup 1
ProductIsConfigurable ProductIsConfigurable 2
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RecordCreationDate RecordCreationDate 2
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
SelectedVariant SelectedVariant 1
SelectedVersion SelectedVersion 1
SoldToParty SoldToParty 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 Transactional view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLOFMATERIALTP (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    ENGINEERINGCHANGEDOCUMENT,
    MATERIAL,
    PLANT,
    _SOLDTOPARTY,
    ALTERNATIVEUNIT,
    ASSETINTELNETWORKMANUFACTURER,
    ASSETINTELNETWORKTEMPLATE,
    ASSETINTELNETWORKTRACKINGMODE,
    BILLOFMATERIALAUTHSNGRP,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALSTATUS,
    BILLOFMATERIALUUID,
    BILLOFMATERIALVARIANTFOREDIT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSIONFOREDIT,
    BOMALTERNATIVETEXT,
    BOMASSETNTWKHNDOVRISRELEVANT,
    BOMEXPLOSIONAPPLICATION,
    BOMGROUP,
    BOMHEADERBASEUNIT,
    BOMHEADERINTERNALCHANGECOUNT,
    BOMHEADERQUANTITYINBASEUNIT,
    BOMHEADERTEXT,
    BOMISARCHIVEDFORDELETION,
    BOMISCONFIGURABLE,
    BOMISTOBEDELETED,
    BOMPREDECESSORVERSION,
    BOMPRIORITIZEDVERSION,
    BOMUSAGEPRIORITY,
    BOMVERSIONSTATUS,
    BOMVERSIONSTATUSDESCRIPTION,
    CHANGERECORD,
    CHGTOENGINEERINGCHGDOCUMENT,
    CREATEDBYUSER,
    DOCUMENTISCREATEDBYCAD,
    ENGINEERINGCHANGEDOCFOREDIT,
    HEADERATTACHMENTKEY,
    HEADERVALIDITYENDDATE,
    HEADERVALIDITYSTARTDATE,
    INDICATORISBOMCHANGEDWITHHIST,
    ISALE,
    ISCONFIGUREDMATERIAL,
    ISLATESTBOMVERSION,
    ISMARKEDFORDELETION,
    ISMULTIPLEBOMALT,
    ISVERSIONBILLOFMATERIAL,
    LABORATORYORDESIGNOFFICE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LONGTEXTEXISTS,
    LONGTEXTLANGUAGE,
    MATERIALBOMOBJECTID,
    MATERIALFOREDIT,
    MATERIALTOLOTSIZEQUANTITY,
    MATERIALTYPE,
    MATFROMLOTSIZEQUANTITY,
    PLANTFOREDIT,
    PRODUCTGROUP,
    PRODUCTISCONFIGURABLE,
    PURCHASEORDERBYCUSTOMER,
    RECORDCREATIONDATE,
    SALESORDER,
    SALESORDERITEM,
    SELECTEDVARIANT,
    SELECTEDVERSION,
    SOLDTOPARTY,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALVARIANT, BILLOFMATERIALVERSION, ENGINEERINGCHANGEDOCUMENT, MATERIAL, PLANT)
);

Learn More