P_NVrsEngBOMAllProdnPlntCRChck

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 P_NVrsEngBOMAllProdnPlntCRChck.
-- 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: PNVRSEBOMCRCHECK

CREATE VIEW P_NVrsEngBOMAllProdnPlntCRChck AS
SELECT
  NonVersEngBOMAcrossAllPlant.BillOfMaterial AS BillOfMaterial,
  NonVersEngBOMAcrossAllPlant.BillOfMaterialCategory AS BillOfMaterialCategory,
  NonVersEngBOMAcrossAllPlant.BillOfMaterialVariant AS BillOfMaterialVariant,
  NonVersEngBOMAcrossAllPlant.Material AS Material,
  NonVersEngBOMAcrossAllPlant.Plant AS Plant,
  NonVersEngBOMAcrossAllPlant.ProductionPlant AS ProductionPlant,
  NonVersEngBOMAcrossAllPlant.BillOfMaterialVersion AS BillOfMaterialVersion,
  NonVersEngBOMAcrossAllPlant.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  NonVersEngBOMAcrossAllPlant.BOMAlternativeText AS BOMAlternativeText,
  NonVersEngBOMAcrossAllPlant.BOMGroup AS BOMGroup,
  NonVersEngBOMAcrossAllPlant.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  NonVersEngBOMAcrossAllPlant.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  NonVersEngBOMAcrossAllPlant.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  NonVersEngBOMAcrossAllPlant.BOMHeaderText AS BOMHeaderText,
  NonVersEngBOMAcrossAllPlant.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  NonVersEngBOMAcrossAllPlant.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  NonVersEngBOMAcrossAllPlant.BOMTechnicalType AS BOMTechnicalType,
  NonVersEngBOMAcrossAllPlant.BOMUsagePriority AS BOMUsagePriority,
  NonVersEngBOMAcrossAllPlant.BOMVersionStatus AS BOMVersionStatus,
  NonVersEngBOMAcrossAllPlant.EBOMType AS EBOMType,
  NonVersEngBOMAcrossAllPlant.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  NonVersEngBOMAcrossAllPlant.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  NonVersEngBOMAcrossAllPlant.BillOfMaterialStatus AS BillOfMaterialStatus,
  NonVersEngBOMAcrossAllPlant.BillOfMaterialUUID AS BillOfMaterialUUID,
  NonVersEngBOMAcrossAllPlant.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  NonVersEngBOMAcrossAllPlant.CreatedByUser AS CreatedByUser,
  NonVersEngBOMAcrossAllPlant.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  NonVersEngBOMAcrossAllPlant.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  NonVersEngBOMAcrossAllPlant.HeaderValidityEndDate AS HeaderValidityEndDate,
  NonVersEngBOMAcrossAllPlant.HeaderValidityStartDate AS HeaderValidityStartDate,
  NonVersEngBOMAcrossAllPlant.IsALE AS IsALE,
  NonVersEngBOMAcrossAllPlant.IsConfiguredMaterial AS IsConfiguredMaterial,
  NonVersEngBOMAcrossAllPlant.IsLatestBOMVersion AS IsLatestBOMVersion,
  NonVersEngBOMAcrossAllPlant.IsMarkedForDeletion AS IsMarkedForDeletion,
  NonVersEngBOMAcrossAllPlant.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  NonVersEngBOMAcrossAllPlant.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  NonVersEngBOMAcrossAllPlant.RecordCreationDate AS RecordCreationDate,
  NonVersEngBOMAcrossAllPlant.LastChangeDate AS LastChangeDate,
  NonVersEngBOMAcrossAllPlant.LastChangedByUser AS LastChangedByUser,
  NonVersEngBOMAcrossAllPlant.MatFromLotSizeQuantity AS MatFromLotSizeQuantity,
  NonVersEngBOMAcrossAllPlant.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  NonVersEngBOMAcrossAllPlant.LastChgStForBOMItm AS LastChgStForBOMItm,
  AssociatedCR.ChangeRecord AS ChangeRecord,
  AssociatedCR.ChangeRecordUUID AS ChangeRecordUUID,
  AssociatedCR.ChgRecdEngEffectiveDate AS ChgRecdEngEffectiveDate,
  LatestEffectvDteFromCRforEBOM.LatestEngEffctvDte AS LatestEngEffctvDte,
  NonVersEngBOMAcrossAllPlant._BillOfMaterialItem AS _BillOfMaterialItem,
  NonVersEngBOMAcrossAllPlant._BillOfMaterialVariantUsage AS _BillOfMaterialVariantUsage,
  NonVersEngBOMAcrossAllPlant._UnitOfMeasure AS _UnitOfMeasure
FROM P_NonVrsEngBOMAcrsAllProdnPlnt AS NonVersEngBOMAcrossAllPlant
LEFT OUTER JOIN P_NVrsEngBOMWithOpenCRAssgnmnt AS AssociatedCR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_EngBOMEngEffctvDteFrmChgRecd AS LatestEffectvDteFromCRforEBOM ON /* join condition not captured in parsed metadata */
;