P_MfgInspCharcHistory

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_MfgInspCharcHistory.
-- 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: PMFGICHISTORY

CREATE VIEW P_MfgInspCharcHistory AS
SELECT
  InspCharHistory.InspectionLot AS InspectionLot,
  InspCharHistory.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspCharHistory.InspectionCharacteristic AS InspectionCharacteristic,
  InspCharHistory.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspCharHistory.InspResultValueInternalID AS InspResultValueInternalID,
  InspCharHistory.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  InspCharHistory.ChangeDocument AS ChangeDocument,
  InspCharHistory.MfgExecDocumentCategory AS MfgExecDocumentCategory,
  InspCharHistory.ManufacturingOrder AS ManufacturingOrder,
  InspectionCharacteristic.ProductionOrderOperationActy AS ProductionOrderOperationActy,
  InspectionCharacteristic.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  cast(InspectionCharacteristic.InspSpecDecimalPlaces + InspCharHistory.InspResultNrOfAddlDcmlsPlaces as qdiff_dec_places) AS InspSpecDecimalPlaces,
  InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  OpActyInstceNtwkElmnt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceNtwkElmnt._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OpActyInstceNtwkElmnt.OrderInternalID AS OrderInternalID,
  OpActyInstceNtwkElmnt.OrderOperationInternalID AS OrderOperationInternalID,
  OrderOperationBasic.Operation_2 AS Operation,
  OrderOperationBasic.Sequence AS Sequence,
  OrderOperationBasic.OperationText AS OperationText,
  OrderOperationBasic.WorkCenterInternalID AS WorkCenterInternalID,
  'A' AS WorkCenterTypeCode,
  OrderOperationBasic.Plant AS Plant,
  cast('2' as mpe_oan_segment_type preserving type) AS OpActyNtwkSegmentType,
  OpActyInstceNtwkElmnt.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  OpActyInstceNtwkElmnt.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OpActyInstceNtwkElmnt.OperationActivity AS OperationActivity,
  OpActyInstceNtwkElmnt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyInstceNtwkElmnt.StatusAndActionSchema AS StatusAndActionSchema,
  InspCharHistory.CreatedByUser AS CreatedByUser,
  InspCharHistory.CreationDate AS CreationDate,
  InspCharHistory.CreationTime AS CreationTime,
  InspCharHistory.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  cast(0 as qmittelwrt) AS InspectionResultMeanValue,
  cast('' as qcodegrp) AS CharacteristicAttributeCodeGrp,
  cast('' as qcode) AS CharacteristicAttributeCode,
  cast(0 as qmesswert) AS InspectionResultMeasuredValue,
  cast('' as qattribut) AS InspectionResultAttribute,
  cast('' as qmbewertg) AS InspectionValuationResult,
  InspCharHistory.ShopFloorItem AS ShopFloorItem,
  ShopFloorItemStatus.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  cast('MPE_EXEC_SFO' as msgid) AS SystemMessageIdentification,
  70 AS MfgExecHistMsgVarblField1,
  75 AS MfgExecHistMsgVarblField4,
  InspCharcRsltLongText.InspectionResultLongText AS InspectionResultLongText
FROM P_MfgInspCharHistoryAll AS InspCharHistory
INNER JOIN I_LogisticsOrderBasic AS LogisticsOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionCharacteristic AS InspectionCharacteristic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS OrderOperationBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyInstceNtwkElmntBasic AS OpActyInstceNtwkElmnt ON /* join condition not captured in parsed metadata */
;