name: "{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.BillOfMaterialsMD"
description: "This view contains Bill of Materials master data which includes comprehensive detail of parts, items, assemblies, sub-assemblies, etc. and other materials required to create a product. The granularity is Client(System), Material number, plant, BOM usage, Bill of Material, Alternate BOM, BOM category, BOM item number and internal counters."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Master Data"
fields:
  - name: "Client_MANDT"
    description: "Client (Mandant), PK"
  - name: "MaterialNumber_MATNR"
    description: "Material Number, PK"
  - name: "Plant_WERKS"
    description: "Plant, PK"
  - name: "BomUsage_STLAN"
    description: "BOM Usage, PK"
  - name: "BillOfMaterial_STLNR"
    description: "Bill of Material, PK"
  - name: "AlternativeBom_STLAL"
    description: "Alternative BOM, PK"
  - name: "BomCategory_STLTY"
    description: "BOM Category, PK"
  - name: "InternalCounter_STKOZ"
    description: "Internal Counter, PK"
  - name: "BomItemNodeNumber_STLKN"
    description: "BOM Item Node Number, PK"
  - name: "InternalCounter_STASZ"
    description: "Internal Counter, PK"
  - name: "InternalCounter_STPOZ"
    description: "Internal Counter, PK"
  - name: "FromLotSize_LOSVN"
    description: "From Lot Size"
  - name: "ToLotSize_LOSBS"
    description: "To Lot Size"
  - name: "Indicator_ConfiguredMaterial__materialVariant___CSLTY"
    description: "Indicator: Configured Material (material variant)"
  - name: "ValidFromDate_DATUV"
    description: "Valid-From Date"
  - name: "TechnicalStatusFrom_TECHV"
    description: "Tech Status From"
  - name: "ChangeNumber_AENNR"
    description: "Change Number"
  - name: "DeletionIndicator_LKENZ"
    description: "Deletion Indicator"
  - name: "DeletionFlagForBoms_LOEKZ"
    description: "Deletion Flag for BOMs"
  - name: "PreviousHeaderCounter_VGKZL"
    description: "Previous Header Counter"
  - name: "BaseUnitOfMeasureForBom_BMEIN"
    description: "Base Unit of Measure for BOM"
  - name: "BaseQuantity_BMENG"
    description: "Base Quantity"
  - name: "CadIndicator_CADKZ"
    description: "CAD Indicator"
  - name: "LaboratorydesignOffice_LABOR"
    description: "Laboratory/Design Office"
  - name: "LongTextLanguage_ForCreationOfAChangeDocument_LTXSP"
    description: "Long Text Language, for Creation of a Change Document"
  - name: "AlternativeBomText_STKTX"
    description: "Alternative BOM Text"
  - name: "BomStatus_STLST"
    description: "Bill Of Material status"
  - name: "PlantWhereBomOrAlternativevariantCreated_WRKAN"
    description: "Plant where BOM or alternative/variant Created"
  - name: "DateOfLastDateShift_DVDAT"
    description: "Date Of Last Date Shift"
  - name: "NameOfTheUserWhoCarriedOutTheDateShift_DVNAM"
    description: "Name Of The User Who Carried Out The Date Shift"
  - name: "DateShiftHierarchyIndicator_AEHLP"
    description: "Date Shift Hierarchy Indicator"
  - name: "AleIndicator_ALEKZ"
    description: "ALE Indicator"
  - name: "GlobalIdentificationOfABomHeaderChangeStatus_GUIDX"
    description: "Global Identification of a BOM Header Change Status"
  - name: "ValidToDate_VALID_TO"
    description: "Valid-to Date"
  - name: "ChangeNumberTo_ECN_TO"
    description: "Change Number To"
  - name: "SortKeyWithinALogicalItem_LPSRT"
    description: "Sort Key Within A Logical Item"
  - name: "PredecessorNode_VGKNT"
    description: "Predecessor Node"
  - name: "PreviousItemCounter_VGPZL"
    description: "Previous Item Counter"
  - name: "BomComponent_IDNRK"
    description: "BOM Component"
  - name: "IssuingPlant_PSWRK"
    description: "Issuing Plant"
  - name: "ItemCategory__billOfMaterial___POSTP"
    description: "Item Category (Bill of Material)"
  - name: "BomItemNumber_POSNR"
    description: "BOM Item Number"
  - name: "SortString_SORTF"
    description: "Sort String"
  - name: "ComponentUnitOfMeasure_MEINS"
    description: "Component Unit of Measure"
  - name: "ComponentQuantity_MENGE"
    description: "Component Quantity"
  - name: "FixedQty_FMENG"
    description: "Fixed Quantity"
  - name: "ComponentScrapInPercent_AUSCH"
    description: "Component Scrap in Percent"
  - name: "OperationScrap_AVOAU"
    description: "Operation Scrap"
  - name: "Indicator_NetScrap_NETAU"
    description: "Net Scrap Indicator"
  - name: "Indicator_BulkMaterial_SCHGT"
    description: "Indicator: Bulk Material"
  - name: "MaterialProvisionIndicator_BEIKZ"
    description: "Material Provision Indicator"
  - name: "Indicator_SparePart_ERSKZ"
    description: "Indicator: Spare Part"
  - name: "Indicator_ItemRelevantToSales_RVREL"
    description: "Indicator: Item Relevant to Sales"
  - name: "Indicator_ItemRelevantToProduction_SANFE"
    description: "Indicator: Item Relevant to Production"
  - name: "Indicator_ItemRelevantToPlantMaintenance_SANIN"
    description: "Indicator: Item Relevant to Plant maintenance"
  - name: "IndicatorForRelevancyToCosting_SANKA"
    description: "Indicator for Relevancy to costing"
  - name: "Indicator_ItemRelevantToEngineering_SANKO"
    description: "Indicator: Item Relevant to Engineering"
  - name: "Indicator_HighLevelConfiguration_SANVS"
    description: "Indicator: High Level configuration"
  - name: "PmAssemblyIndicator_STKKZ"
    description: "PM Assembly Indicator"
  - name: "Indicator_BomIsRecursive_REKRI"
    description: "Indicator: BOM is Recursive"
  - name: "Indicator_RecursivenessAllowed_REKRS"
    description: "Indicator: Recursiveness allowed"
  - name: "CadIndicator_CADPO"
    description: "CAD Indicator"
  - name: "FollowUpMaterialInBomItemNotInUse_NFMAT"
    description: "Follow-Up Material in BOM Item - NOT IN USE"
  - name: "LeadTimeOffset_NLFZT"
    description: "Lead-time Offset"
  - name: "DistributionKeyForComponentConsumption_VERTI"
    description: "Distribution Key for Component Consumption"
  - name: "Indicator_AlternativeItem_ALPOS"
    description: "Indiactor: Alternative item"
  - name: "UsageProbabilityInpct__alternativeItem___EWAHR"
    description: "Usage probability in Percent (Alternative Item)"
  - name: "PurchasingGroup_EKGRP"
    description: "Purchasing Group"
  - name: "DeliveryTimeInDays_LIFZT"
    description: "Delivery time in days"
  - name: "AccountNumberOfVendorOrCreditor_LIFNR"
    description: "Account Number of Vendor or Creditor"
  - name: "Price_PREIS"
    description: "Price"
  - name: "PriceUnit_PEINH"
    description: "Price Unit"
  - name: "CurrencyKey_WAERS"
    description: "Currency Key"
  - name: "CostElement_SAKTO"
    description: "Cost Element"
  - name: "NumberOfVariableSizeItems_ROANZ"
    description: "No of Variable-Size Items"
  - name: "Size1_ROMS1"
    description: "Size 1"
  - name: "Size2_ROMS2"
    description: "Size 2"
  - name: "Size3_ROMS3"
    description: "Size 3"
  - name: "UnitOfMeasureForSizes1To3_ROMEI"
    description: "Unit of Measure for sizes 1 to 3"
  - name: "QuantityOfVariableSizeItem_ROMEN"
    description: "Quantity of Variable-Size Item"
  - name: "FormulaKey_RFORM"
    description: "Formula Key for Variable-Size Items"
  - name: "Indicator_SubItemsExist_UPSKZ"
    description: "Indicator: Sub-Items Exist"
  - name: "Indicator_ItemInMoreThanOneAlternative_VALKZ"
    description: "Indicator: Item in More than one Alternative"
  - name: "BomItemText__line1___POTX1"
    description: "BOM Item Text (Line 1)"
  - name: "BomItemText__line2___POTX2"
    description: "BOM Item Text (Line 2)"
  - name: "ObjectType__bomItem___OBJTY"
    description: "Object Type (BOM Item)"
  - name: "MaterialGroup_MATKL"
    description: "Material Group"
  - name: "GoodsReceiptProcessingTimeInDays_WEBAZ"
    description: "Goods Receipt Processing Time in Days"
  - name: "DocumentType_DOKAR"
    description: "Document Type"
  - name: "DocumentNumber_DOKNR"
    description: "Document Number"
  - name: "DocumentVersion_DOKVR"
    description: "Document Version"
  - name: "DocumentPart_DOKTL"
    description: "Document Part"
  - name: "AverageMaterialPurityInpct_CSSTR"
    description: "Average Material Purity in %"
  - name: "ClassNumber_CLASS"
    description: "Class Number"
  - name: "ClassType_KLART"
    description: "Class Type"
  - name: "ResultingItemCategory_POTPR"
    description: "Resulting Item Category"
  - name: "SelectionIndicatorForConfigurableBoms_AWAKZ"
    description: "Selection indicator for Configurable BOMS"
  - name: "InstanceIndicator_INSKZ"
    description: "Instance Indicator"
  - name: "Indicator_NotDisplayedInConfigurationEditor_VCEKZ"
    description: "Indicator: Not Displayed in Configuration Editor"
  - name: "Indicator_NotDisplayedInSingleLevelConfiguration_VSTKZ"
    description: "Indicator: Not Displayed in Single-Level Configuration"
  - name: "Indicator_NotDisplayedInAutomaticConfiguration_VACKZ"
    description: "Indicator: Not Displayed in Automatic Configuration"
  - name: "PurchasingOrganization_EKORG"
    description: "Purchasing Organization"
  - name: "RequiredComponent_CLOBK"
    description: "Required Component"
  - name: "MultipleSelectionAllowed_CLMUL"
    description: "Multiple Selections Allowed"
  - name: "AlternativeDisplayFormat_CLALT"
    description: "Alternative Display Format"
  - name: "OrganizationalArea_CVIEW"
    description: "Organizational Area"
  - name: "NumberOfObjectWithAssignedDependencies_KNOBJ"
    description: "Number of Object with Assigned Dependencies"
  - name: "IssueLocationForProductionOrder_LGORT"
    description: "Issue Location for Production Order"
  - name: "Indicator_CoProduct_KZKUP"
    description: "Indicator: Co-product"
  - name: "IntraMaterial_INTRM"
    description: "Intra Material"
  - name: "Indicator_RestrictionsExist_TPEKZ"
    description: "Indicator: Restrictions exist"
  - name: "InheritedNodeNumberOfBomItem_STVKN"
    description: "Inherited Node Number of BOM Item"
  - name: "ExplosionType_DSPST"
    description: "Explosion Type"
  - name: "AlternativeItem_Strategy_ALPST"
    description: "Alternative Item: Strategy"
  - name: "AlternativeItem_RankingOrder_ALPRF"
    description: "Alternative Item: Ranking Order"
  - name: "AlternativeItem_Group_ALPGR"
    description: "Alternative Item: Group"
  - name: "Indicator_FollowUpItem_KZNFP"
    description: "Indicator: Follow-Up Item"
  - name: "FollowUpGroup_NFGRP"
    description: "Follow-Up Group"
  - name: "DiscontinuationGroup_NFEAG"
    description: "Discontinuation group"
  - name: "Indicator_ManualChangeToSalesOrderBom_KNDVB"
    description: "Indicator: Manual change to Sales Order BOM"
  - name: "Indicator_BomItemChangedselectedViaObjDependencies_KNDBZ"
    description: "Indicator: BOM item changed/selected via obj. dependencies"
  - name: "BomCategoryOfOriginalSalesOrderBomItem_KSTTY"
    description: "BOM category of original sales order BOM item"
  - name: "BillOfMaterialForOriginalSalesOrderBomItem_KSTNR"
    description: "Bill of material for original sales order BOM item"
  - name: "NodeNumberOfOriginalSalesOrderBomItem_KSTKN"
    description: "Item node of original sales order BOM item"
  - name: "CounterForOriginalSalesOrderBomItem_KSTPZ"
    description: "Counter for original sales order BOM item"
  - name: "ClassificationNumber_CLSZU"
    description: "Classification Number"
  - name: "Indicator_ClassificationAsSelectionCondition_KZCLB"
    description: "Indicator: Classification as Selection Condition"
  - name: "ProductionSupplyArea_PRVBE"
    description: "Production Supply Area"
  - name: "LeadTimeOffsetForOperation_NLFZV"
    description: "Lead-time Offset for Operation"
  - name: "UnitForLeadTimeOffsetForOperation_NLFMV"
    description: "Unit for Lead-time Offset for Operation"
  - name: "ItemGroup_IDPOS"
    description: "Item group"
  - name: "HistoryCounter_IDHIS"
    description: "History counter"
  - name: "ComponentVariant_IDVAR"
    description: "Component Variant"
  - name: "ExternalIdentificationOfAnItem_ITMID"
    description: "External Identification of an Item"
  - name: "TemporarilyNotUsed_GUID"
    description: "Temporarily not used"
  - name: "SpecialProcurementTypeForBomItem_ITSOB"
    description: "Special Procurement Type for BOM Item"
  - name: "ReferencePointForBomTransfer_RFPNT"
    description: "Reference Point for BOM Transfer"
  - name: "SegmentationMaintainedForBomComponents_SGT_CMKZ"
    description: "Segmentation Maintained for BOM Transfer"
  - name: "SegmentationValue_SGT_CATV"
    description: "Segmentation Value"
  - name: "DeviationValuesMaintainedForComponentAtVariantLevel_FSH_VMKZ"
    description: "Deviation values Maintained for Component at Variant Level"
  - name: "QuantityDistributionProfile_FSH_PGQR"
    description: "Quantity Distribution Profile"
  - name: "ReferenceToQuantityDistributionProfile_FSH_PGQRRF"
    description: "Reference to Quantity Distribution Profile"
  - name: "CriticalComponentIndicator_FSH_CRITICAL_COMP"
    description: "Critical Component Indicator"
  - name: "CrticalLevelOfAComponentInBom_FSH_CRITICAL_LEVEL"
    description: "Critical Level of a Component in BOM"
  - name: "FunctionIdentifier_FUNCID"
    description: "Function Identifier"
