R_WBSBillOfMaterialItemDraft

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_WBSBillOfMaterialItemDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_WBSBillOfMaterialItemDraft AS
SELECT
  cast( billofmaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  HeaderChangeDocument,
  Material,
  Plant,
  DraftUUID,
  ParentDraftUUID,
  BillOfMaterialItemUUID,
  BillOfMaterialHeaderUUID,
  BOMItemInternalChangeCount,
  ValidityStartDate,
  ValidityEndDate,
  EngineeringChangeDocument,
  EngineeringChangeDocForEdit,
  BillOfMaterialVariantUsage,
  ChgToEngineeringChgDocument,
  InheritedNodeNumberForBOMItem,
  BOMItemRecordCreationDate,
  BOMItemCreatedByUser,
  BOMItemLastChangeDate,
  BOMItemLastChangedByUser,
  BillOfMaterialComponent,
  BillOfMaterialItemCategory,
  BillOfMaterialItemNumber,
  BillOfMaterialItemUnit,
  BillOfMaterialItemQuantity,
  IsAssembly,
  IsSubItem,
  BOMItemSorter,
  BOMItemHasFixedQuantity,
  PurchasingGroup,
  Currency,
  MaterialComponentPrice,
  IdentifierBOMItem,
  MaterialPriceUnitQty,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  IsNetScrap,
  VariableSizeItemQuantity,
  cast( variablesizecompunitofmeasure as msehi preserving type ) AS VariableSizeCompUnitOfMeasure,
  cast(quantityvariablesizeitem as romen preserving type ) AS QuantityVariableSizeItem,
  FormulaKey,
  ComponentDescription,
  BOMItemDescription,
  BOMItemText2,
  MaterialGroup,
  DocumentType,
  DocNumber,
  DocumentVersion,
  DocumentPart,
  ClassNumber,
  ClassType,
  ResultingItemCategory,
  DependencyObjectNumber,
  BillOfMaterialItemObjectType,
  IsClassificationRelevant,
  IsBulkMaterial,
  BOMItemIsSparePart,
  BOMItemIsSalesRelevant,
  IsProductionRelevant,
  BOMItemIsPlantMaintRelevant,
  BOMItemIsCostingRelevant,
  IsEngineeringRelevant,
  SpecialProcurementType,
  IsBOMRecursiveAllowed,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  IsMaterialProvision,
  BOMIsRecursive,
  DocumentIsCreatedByCAD,
  DistrKeyCompConsumption,
  DeliveryDurationInDays,
  Creditor,
  CostElement,
  Size1,
  Size2,
  Size3,
  UnitOfMeasureForSize1To3,
  GoodsReceiptDuration,
  PurchasingOrganization,
  RequiredComponent,
  MultipleSelectionAllowed,
  ProdOrderIssueLocation,
  MaterialIsCoProduct,
  ExplosionType,
  AlternativeItemGroup,
  AlternativeItemPriority,
  AlternativeItemStrategy,
  UsageProbabilityPercent,
  FollowUpGroup,
  DiscontinuationGroup,
  IsConfigurableBOM,
  ReferencePoint,
  LeadTimeOffset,
  ProductionSupplyArea,
  IsDeleted,
  IsALE,
  BillOfMaterialItmNTEIdentifier,
  ProductIsConfigurable,
  IsBulkMaterialComponent,
  ProductExternalID,
  SalesOrder,
  SalesOrderItem,
  IsPhantomItem,
  LastChangeDateTime,
  PreliminaryComponent,
  VariableSizeItemIsHidden,
  ClassDetailsIsHidden,
  NonStockItemDetailsIsHidden,
  DocumentItemDetailsIsHidden,
  IsItemDraftModified,
  BillOfMaterialIsSubitemHidden,
  DraftEntityOperationCode,
  DraftAdministrativeDataUUID,
  DraftFieldChanges,
  HasActiveEntity,
  DraftEntityLastChangeDateTime,
  DraftEntityCreationDateTime,
  IsPMAssemblyRelevant
FROM stpo_d AS BillOfMaterialItemDraft
;