I_BillOfMaterialItemDraftTP

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 I_BillOfMaterialItemDraftTP.
-- 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.
-- SQL view name: IBOMITEMDRAFTV2

CREATE VIEW I_BillOfMaterialItemDraftTP AS
SELECT
  stpo_draft.draftuuid AS DraftUUID,
  stpo_draft.parentdraftuuid AS ParentDraftUUID,
  stpo_draft.billofmaterial AS BillOfMaterial,
  stpo_draft.billofmaterialcategory AS BillOfMaterialCategory,
  stpo_draft.billofmaterialvariant AS BillOfMaterialVariant,
  stpo_draft.billofmaterialversion AS BillOfMaterialVersion,
  stpo_draft.billofmaterialitemnodenumber AS BillOfMaterialItemNodeNumber,
  stpo_draft.billofmaterialitemuuid AS BillOfMaterialItemUUID,
  stpo_draft.bomiteminternalchangecount AS BOMItemInternalChangeCount,
  stpo_draft.validitystartdate AS ValidityStartDate,
  stpo_draft.validityenddate AS ValidityEndDate,
  stpo_draft.engineeringchangedocument AS EngineeringChangeDocument,
  stpo_draft.chgtoengineeringchgdocument AS ChgToEngineeringChgDocument,
  stpo_draft.inheritednodenumberforbomitem AS InheritedNodeNumberForBOMItem,
  stpo_draft.bomitemrecordcreationdate AS BOMItemRecordCreationDate,
  stpo_draft.bomitemcreatedbyuser AS BOMItemCreatedByUser,
  stpo_draft.bomitemlastchangedate AS BOMItemLastChangeDate,
  stpo_draft.bomitemlastchangedbyuser AS BOMItemLastChangedByUser,
  stpo_draft.billofmaterialcomponent AS BillOfMaterialComponent,
  stpo_draft.billofmaterialitemcategory AS BillOfMaterialItemCategory,
  stpo_draft.billofmaterialitemnumber AS BillOfMaterialItemNumber,
  stpo_draft.billofmaterialitemunit AS BillOfMaterialItemUnit,
  stpo_draft.billofmaterialitemquantity AS BillOfMaterialItemQuantity,
  cast( stpo_draft.isassembly as stlkz preserving type) AS IsAssembly,
  stpo_draft.issubitem AS IsSubItem,
  stpo_draft.bomitemsorter AS BOMItemSorter,
  stpo_draft.fixedquantity AS FixedQuantity,
  stpo_draft.purchasinggroup AS PurchasingGroup,
  stpo_draft.currency AS Currency,
  stpo_draft.materialcomponentprice AS MaterialComponentPrice,
  stpo_draft.identifierbomitem AS IdentifierBOMItem,
  stpo_draft.materialpriceunitqty AS MaterialPriceUnitQty,
  stpo_draft.componentscrapinpercent AS ComponentScrapInPercent,
  stpo_draft.operationscrapinpercent AS OperationScrapInPercent,
  stpo_draft.isnetscrap AS IsNetScrap,
  stpo_draft.numberofvariablesizeitem AS NumberOfVariableSizeItem,
  stpo_draft.quantityvariablesizeitem AS QuantityVariableSizeItem,
  stpo_draft.formulakey AS FormulaKey,
  stpo_draft.bomitemdescription AS BOMItemDescription,
  stpo_draft.bomitemtext2 AS BOMItemText2,
  stpo_draft.materialgroup AS MaterialGroup,
  stpo_draft.documenttype AS DocumentType,
  stpo_draft.docnumber AS DocNumber,
  stpo_draft.documentversion AS DocumentVersion,
  stpo_draft.documentpart AS DocumentPart,
  stpo_draft.classnumber AS ClassNumber,
  stpo_draft.classtype AS ClassType,
  stpo_draft.resultingitemcategory AS ResultingItemCategory,
  stpo_draft.dependencyobjectnumber AS DependencyObjectNumber,
  stpo_draft.objecttype AS ObjectType,
  stpo_draft.isclassificationrelevant AS IsClassificationRelevant,
  stpo_draft.isbulkmaterial AS IsBulkMaterial,
  stpo_draft.isdeleted AS IsDeleted,
  stpo_draft.bomitemissparepart AS BOMItemIsSparePart,
  stpo_draft.bomitemissalesrelevant AS BOMItemIsSalesRelevant,
  stpo_draft.isproductionrelevant AS IsProductionRelevant,
  stpo_draft.bomitemisplantmaintrelevant AS BOMItemIsPlantMaintRelevant,
  stpo_draft.bomitemiscostingrelevant AS BOMItemIsCostingRelevant,
  stpo_draft.isengineeringrelevant AS IsEngineeringRelevant,
  stpo_draft.specialprocurementtype AS SpecialProcurementType,
  stpo_draft.bomisrecursive AS BOMIsRecursive,
  stpo_draft.operationleadtimeoffset AS OperationLeadTimeOffset,
  stpo_draft.opsleadtimeoffsetunit AS OpsLeadTimeOffsetUnit,
  stpo_draft.ismaterialprovision AS IsMaterialProvision,
  stpo_draft.isbomrecursiveallowed AS IsBOMRecursiveAllowed,
  stpo_draft.documentiscreatedbycad AS DocumentIsCreatedByCAD,
  stpo_draft.distrkeycompconsumption AS DistrKeyCompConsumption,
  stpo_draft.deliverydurationindays AS DeliveryDurationInDays,
  stpo_draft.creditor AS Creditor,
  stpo_draft.costelement AS CostElement,
  stpo_draft.isphantomitem AS IsPhantomItem,
  stpo_draft.size1 AS Size1,
  stpo_draft.size2 AS Size2,
  stpo_draft.size3 AS Size3,
  stpo_draft.unitofmeasureforsize1to3 AS UnitOfMeasureForSize1To3,
  stpo_draft.goodsreceiptduration AS GoodsReceiptDuration,
  stpo_draft.purchasingorganization AS PurchasingOrganization,
  stpo_draft.requiredcomponent AS RequiredComponent,
  stpo_draft.multipleselectionallowed AS MultipleSelectionAllowed,
  stpo_draft.prodorderissuelocation AS ProdOrderIssueLocation,
  stpo_draft.materialiscoproduct AS MaterialIsCoProduct,
  stpo_draft.explosiontype AS ExplosionType,
  stpo_draft.alternativeitemgroup AS AlternativeItemGroup,
  stpo_draft.followupgroup AS FollowUpGroup,
  stpo_draft.discontinuationgroup AS DiscontinuationGroup,
  stpo_draft.isconfigurablebom AS IsConfigurableBOM,
  stpo_draft.referencepoint AS ReferencePoint,
  stpo_draft.leadtimeoffset AS LeadTimeOffset,
  stpo_draft.productionsupplyarea AS ProductionSupplyArea,
  stpo_draft.isale AS IsALE,
  stko_draft.billofmaterialheaderuuid AS BillOfMaterialHeaderUUID
FROM stpo_draft_v2 AS stpo_draft
INNER JOIN stko_draft_v2 AS stko_draft ON /* join condition not captured in parsed metadata */
;