I_Billofmaterialdraft

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_Billofmaterialdraft.
-- 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: IBOMDETAILSDRAFT

CREATE VIEW I_Billofmaterialdraft AS
SELECT
  stko_draft.draftuuid AS DraftUUID,
  stko_draft.billofmaterialheaderuuid AS BillOfMaterialHeaderUUID,
  stko_draft.material AS Material,
  stko_draft.plant AS Plant,
  stko_draft.billofmaterialvariantusage AS BillOfMaterialVariantUsage,
  stko_draft.billofmaterialcategory AS BillOfMaterialCategory,
  stko_draft.billofmaterial AS BillOfMaterial,
  stko_draft.billofmaterialvariant AS BillOfMaterialVariant,
  stko_draft.matfromlotsizequantity AS MatFromLotSizeQuantity,
  cast( stko_draft.mattolotsizequantity as losbs preserving type ) AS MatToLotSizeQuantity,
  stko_draft.ismultiplebomalt AS IsMultipleBOMAlt,
  stko_draft.bomheaderinternalchangecount AS BOMHeaderInternalChangeCount,
  stko_draft.isconfiguredmaterial AS IsConfiguredMaterial,
  stko_draft.bomprioritizedversion AS BOMPrioritizedVersion,
  stko_draft.bomexplosionapplication AS BOMExplosionApplication,
  stko_draft.bomusagepriority AS BOMUsagePriority,
  stko_draft.billofmaterialauthsngrp AS BillOfMaterialAuthsnGrp,
  cast ( stko_draft.bomtechnicaltype as tetyp_d preserving type ) AS BOMTechnicalType,
  stko_draft.bomgroup AS BOMGroup,
  stko_draft.bomheadertext AS BOMHeaderText,
  stko_draft.bomalternativetext AS BOMAlternativeText,
  stko_draft.billofmaterialstatus AS BillOfMaterialStatus,
  stko_draft.headervaliditystartdate AS HeaderValidityStartDate,
  stko_draft.headervalidityenddate AS HeaderValidityEndDate,
  stko_draft.engineeringchangedocument AS EngineeringChangeDocument,
  stko_draft.chgtoengineeringchgdocument AS ChgToEngineeringChgDocument,
  stko_draft.ismarkedfordeletion AS IsMarkedForDeletion,
  stko_draft.documentiscreatedbycad AS DocumentIsCreatedByCAD,
  stko_draft.laboratoryordesignoffice AS LaboratoryOrDesignOffice,
  stko_draft.isale AS IsALE,
  stko_draft.bomheaderbaseunit AS BOMHeaderBaseUnit,
  stko_draft.bomheaderquantityinbaseunit AS BOMHeaderQuantityInBaseUnit,
  stko_draft.recordcreationdate AS RecordCreationDate,
  stko_draft.lastchangedate AS LastChangeDate,
  stko_draft.createdbyuser AS CreatedByUser,
  stko_draft.lastchangedbyuser AS LastChangedByUser,
  stko_draft.bomistobedeleted AS BOMIsToBeDeleted,
  stko_draft.isheaderdraftmodified AS IsHeaderDraftModified,
  stko_draft.isactiveentity AS IsActiveEntity,
  stko_draft.hasactiveentity AS HasActiveEntity,
  stko_draft.hasdraftentity AS HasDraftEntity,
  stko_draft.billofmaterialversion AS BillOfMaterialVersion,
  stko_draft.bomversionstatus AS BOMVersionStatus,
  cast('' as val_text) AS BOMVersionStatusDescription,
  stko_draft.isversionbillofmaterial AS IsVersionBillOfMaterial,
  stko_draft.islatestbomversion AS IsLatestBOMVersion
FROM stko_draft
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialVariantUsage ON BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage AND _BillOfMaterialVariantUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;