R_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 R_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.

CREATE VIEW R_BillOfMaterialDraft AS
SELECT
  cast( billofmaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  EngineeringChangeDocument,
  Material,
  Plant,
  DraftUUID,
  SalesOrder,
  SalesOrderItem,
  cast ( ' ' as /s4ppm/project_ele_id preserving type ) AS ProjectElement,
  cast( '00000000' as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  BillOfMaterialHeaderUUID,
  BillOfMaterialVariantUsage,
  EngineeringChangeDocForEdit,
  IsMultipleBOMAlt,
  BOMHeaderInternalChangeCount,
  BOMUsagePriority,
  BillOfMaterialAuthsnGrp,
  BOMVersionStatus,
  IsVersionBillOfMaterial,
  IsLatestBOMVersion,
  IsConfiguredMaterial,
  BOMTechnicalType,
  BOMGroup,
  BOMHeaderText,
  BOMAlternativeText,
  BillOfMaterialStatus,
  ValidityStartDate,
  ValidityEndDate,
  ChgToEngineeringChgDocument,
  IsMarkedForDeletion,
  IsALE,
  MatFromLotSizeQuantity,
  MaterialToLotSizeQuantity,
  BOMHeaderBaseUnit,
  BOMHeaderQuantityInBaseUnit,
  RecordCreationDate,
  LastChangeDate,
  LastChangedByUser,
  CreatedByUser,
  BOMIsToBeDeleted,
  DocumentIsCreatedByCAD,
  LaboratoryOrDesignOffice,
  BOMAssetNtwkHndovrIsRelevant,
  LastChangeDateTime,
  SoldToParty,
  PurchaseOrderByCustomer,
  IndicatorIsBOMWithDateHistory,
  IndicatorIsBOMChangedWithHist,
  AlternativeUnit,
  DefaultValidFromDate,
  BillOfMaterialHdrDetailsText,
  ProductDescription,
  PlantName,
  IsAttachmentsEnabled,
  QuantityInBaseUnitIsHidden,
  ProductIsConfigurable,
  MaterialType,
  MaterialName,
  MaterialBOMObjectID,
  LongTextLanguage,
  BOMPrioritizedVersion,
  BOMPredecessorVersion,
  BOMIsConfigurable,
  BOMIsArchivedForDeletion,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  bintohex( billofmaterialheaderuuid ) AS BillOfMaterialNoteIdentifier,
  BOMSelectedKeyDate,
  EngineeringChangeDocForCopy
FROM stko_d AS BillOfMaterialDraft
LEFT OUTER JOIN E_BillOfMaterialDraft AS _BillOfMaterialExtension ON BillOfMaterial = _BillOfMaterialExtension.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialExtension.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterialExtension.BillOfMaterialVariant AND BOMHeaderInternalChangeCount = _BillOfMaterialExtension.BOMHeaderInternalChangeCount AND DraftUUID = _BillOfMaterialExtension.DraftUUID  -- association [1..1]
;