I_BOOOpCharacteristicChgSt

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_BOOOpCharacteristicChgSt.
-- 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: IPPBOOOPCHARCCS

CREATE VIEW I_BOOOpCharacteristicChgSt AS
SELECT
  plas.BillOfOperationsType AS BillOfOperationsType,
  plas.BillOfOperationsGroup AS BillOfOperationsGroup,
  plas.BillOfOperationsVariant AS BillOfOperationsVariant,
  plas.BillOfOperationsSequence AS BillOfOperationsSequence,
  plas.BOOOperationInternalID AS BOOOperationInternalID,
  plas.BOOSqncOpAssgmtIntVersionCntr AS BOOSqncOpAssgmtIntVersionCntr,
  _BOOCharcUnion.BOOCharacteristic AS BOOCharacteristic,
  _BOOCharcUnion.BOOCharacteristicVersion AS BOOCharacteristicVersion,
  _BOOCharcUnion.ChangeNumber AS ChangeNumber,
  case when _BOOCharcUnion.IsDeleted <> ' ' then _BOOCharcUnion.IsDeleted when plas.IsDeleted <> ' ' then plas.IsDeleted else plas.IsImplicitlyDeleted end as IsDeleted AS IsImplicitlyDeletedendasIsDeleted,
  InspectionMethodPlant,
  InspectionMethod,
  InspectionMethodVersion,
  InspSpecImportanceCode,
  InspectorQualification,
  InspectionSpecificationPlant,
  InspectionSpecification,
  InspectionSpecificationVersion,
  BOOCharcHasInspSpecReference,
  QltyMstrDataAuthorizationGroup,
  InspSpecControlIndicators,
  InspSpecIsQuantitative,
  InspSpecCharacteristicType,
  InspSpecIsMeasuredValueRqd,
  InspSpecIsSelectedSetRequired,
  InspSpecIsUpperLimitRequired,
  InspSpecIsLowerLimitRequired,
  InspSpecIsTargetValueInLimit,
  InspectionScope,
  InspSpecIsLongTermInspection,
  InspSpecRecordingType,
  InspResultIsDocumentationRqd,
  InspSpecCharcCategory,
  InspSpecIsSampleQtyAdditive,
  InspSpecIsDestructive,
  InspSpecResultCalculation,
  InspSpecIsSamplingProcedRqd,
  InspSpecIsScrapRelevant,
  InspSpecHasFixedCtrlIndicators,
  InspSpecIsTestEquipmentRqd,
  InspSpecIsDefectsRecgAutomatic,
  InspSpecIsChgDocRequired,
  InspSpecIsControlChartUsed,
  InspSpecPrintControl,
  InspToleranceSpecification,
  InspSpecDecimalPlaces,
  InspectionSpecificationUnit,
  InspSpecHasTargetValue,
  InspSpecHasUpperLimit,
  InspSpecHasLowerLimit,
  InspSpecDefectCodeGrpRejection,
  InspSpecDefectCodeRejection,
  InspSpecDefectCodeGrpRjcnUpper,
  InspSpecDefectCodeRjcnUpper,
  InspSpecDefectCodeGrpRjcnLower,
  InspSpecDefectCodeRjcnLower,
  SelectedCodeSet,
  SelectedCodeSetPlant,
  InspSpecAdditionalCatalog2,
  InspSpecAdditionalSelectedSet2,
  InspSpecAdditionalCodeGroup2,
  InspSpecAddlSeldCodeSetPlant2,
  InspSpecAdditionalCatalog3,
  InspSpecAdditionalSelectedSet3,
  InspSpecAdditionalCodeGroup3,
  InspSpecAddlSeldCodeSetPlant3,
  InspSpecAdditionalCatalog4,
  InspSpecAdditionalSelectedSet4,
  InspSpecAdditionalCodeGroup4,
  InspSpecAddlSeldCodeSetPlant4,
  InspSpecAdditionalCatalog5,
  InspSpecAdditionalSelectedSet5,
  InspSpecAdditionalCodeGroup5,
  InspSpecAddlSeldCodeSetPlant5,
  SamplingProcedure,
  InspCharacteristicSampleUnit,
  BOOCharcSampleQuantity,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  InspectionSpecificationText,
  _BOOCharcUnion.CreatedByUser AS CreatedByUser,
  _BOOCharcUnion.CreationDate AS CreationDate,
  _BOOCharcUnion.LastChangedByUser AS LastChangedByUser,
  _BOOCharcUnion.LastChangeDate AS LastChangeDate,
  _BOOCharcUnion.BillOfOperationsVersion AS BillOfOperationsVersion,
  plas._BillOfOperationsType AS _BillOfOperationsType,
  plas._BillOfOperationsGroup AS _BillOfOperationsGroup,
  plas._BillOfOperations AS _BillOfOperations,
  plas._BillOfOperationsSequence AS _BillOfOperationsSequence,
  plas._BOOOperationInternalID AS _BOOOperationInternalID
FROM I_BOOCharcInspSpecUnion AS _BOOCharcUnion
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS plas ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BOOOperationCharacteristic AS _BOOOperationCharacteristic ON BillOfOperationsType = _BOOOperationCharacteristic.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationCharacteristic.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOOperationCharacteristic.BillOfOperationsVariant AND BillOfOperationsSequence = _BOOOperationCharacteristic.BillOfOperationsSequence AND BOOOperationInternalID = _BOOOperationCharacteristic.BOOOperationInternalID AND BOOCharacteristic = _BOOOperationCharacteristic.BOOCharacteristic  -- association [1..1]
LEFT OUTER JOIN I_BOOSqncOperationAssgmtChgSt AS _BOOSqncOperationAssgmtChgSt ON BillOfOperationsType = _BOOSqncOperationAssgmtChgSt.BillOfOperationsType AND BillOfOperationsGroup = _BOOSqncOperationAssgmtChgSt.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOSqncOperationAssgmtChgSt.BillOfOperationsVariant AND BillOfOperationsSequence = _BOOSqncOperationAssgmtChgSt.BillOfOperationsSequence AND BOOOperationInternalID = _BOOSqncOperationAssgmtChgSt.BOOOperationInternalID AND BOOSqncOpAssgmtIntVersionCntr = _BOOSqncOperationAssgmtChgSt.BOOSqncOpAssgmtIntVersionCntr  -- association [1..1]
LEFT OUTER JOIN I_BOOCharacteristic AS _BOOCharacteristic ON BillOfOperationsType = _BOOCharacteristic.BillOfOperationsType AND BillOfOperationsGroup = _BOOCharacteristic.BillOfOperationsGroup AND BOOOperationInternalID = _BOOCharacteristic.BOOOperationInternalID AND BOOCharacteristic = _BOOCharacteristic.BOOCharacteristic  -- association [1..1]
;