C_MfgExecDefectRecord

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 C_MfgExecDefectRecord.
-- 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: CMFGEXECDEFRECD

CREATE VIEW C_MfgExecDefectRecord AS
SELECT
  Defect.DefectInternalID AS DefectInternalID,
  Defect.DefectCategory AS DefectCategory,
  Defect.Plant AS Plant,
  ProductionOrder,
  cast( '' as boolean preserving type) AS IsEditable,
  Defect.DefectiveSingleUnit AS SerialNumber,
  Equipment.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  Defect.ProductionOrderOperation AS ProductionOrderOperation,
  MfgOrderOperation.MfgOrderOperationText AS MfgOrderOperationText,
  OAINE.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  DefectDecision._DefectDecisionVH._Text[1:Language=$session.system_language].MfgDefectDecisionName AS MfgDefectDecisionName,
  ProductionHold._ProductionHoldObjectType._Text[1:Language=$session.system_language].ProductionHoldObjectTypeName AS ProductionHoldObjectTypeName,
  DefectiveQuantity,
  OAINE.OpActyNtwkInstance AS OpActyNtwkInstance,
  OAINE.OpActyNtwkElement AS OpActyNtwkElement,
  ShopFloorItem.ShopFloorItem AS ShopFloorItem,
  OpActyInstanceStatusBasic.OpActyIsSeldForRtactvPostg AS OpActyIsSeldForRtactvPostg,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  MainWorkCenter,
  MainWorkCenterPlant,
  Defect.Material AS Material,
  Defect.BOMItemInstanceUUID AS BOMItemInstanceUUID,
  BillOfMaterialItem.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  BillOfMaterialItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  cast(DigitalMockUpCharcs.DgtlMockUpCharcsValue as dmu_tmxguid_char32) AS OriglDgtlMockUpCharcsCharUUID,
  Defect.Batch AS Batch,
  Batch.BatchBySupplier AS BatchBySupplier,
  Defect.ProducedMaterial AS ProducedMaterial,
  Defect.ProducedSerialNumber AS ProducedSerialNumber,
  cast('' as vmp_ref_des) AS ReferenceDesignatorName,
  Defect.BillOfMaterialCategory AS BillOfMaterialCategory,
  cast( Defect.BillOfMaterial as pph_stnum preserving type ) AS BillOfMaterialInternalID,
  Defect.BillOfMaterialVariant AS BillOfMaterialVariant,
  Defect.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  Defect.BOMItemInternalChangeCount AS BOMItemInternalChangeCount
FROM I_Defect_TP AS Defect
INNER JOIN I_DefectCategory AS DefectCategory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrderOperation AS MfgOrderOperation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Equipment AS Equipment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrdDefectDecision AS DefectDecision ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionHoldBasic AS ProductionHold ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyInstanceStatusBasic AS OpActyInstanceStatusBasic ON /* join condition not captured in parsed metadata */
;