C_InspUsgDescCF

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_InspUsgDescCF.
-- 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: CINSPUSGDESCCF

CREATE VIEW C_InspUsgDescCF AS
SELECT
  _InspLot.InspectionLot AS InspectionLot,
  _InspLot._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  cast( concat_with_space (concat (cast (_InspLotAggrgn.InspCharRejectedCount as abap.char( 20 )),' / '),cast (_InspLotAggrgn.InspCharacteristicCount as abap.char( 20 )), 1) as vdm_inspcharcount ) AS InspCharCount,
  _InspLot._InspLotUsageDecision._UsageDecisionValuation._Text[1:Language=$session.system_language].InspLotUsgeDcsnValuationText AS InspLotUsgeDcsnValuationText,
  _InspLot._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  cast ( ' ' as abap.sstring( 1333 ) ) AS InspLotUsageDecisionLongText,
  cast(_InspLot.InspLotHasSubsets as xfeld) AS InspLotHasSubsets,
  cast(_InspLot.InspectionLotIsSkipped as vdm_qkzskiplot preserving type ) AS InspectionLotIsSkipped,
  'X' AS InspSubsetIsVisible,
  'X' AS InspStockPostingIsVisible,
  'X' AS InspLotIsCompletionForced,
  cast( 0 as abap.int1) AS NumberOfDefectsCriticality,
  cast( 0 as vdm_numberofdefects ) AS NumberOfDefects,
  ' ' AS IsCloudSystem,
  'X' AS IsAttachmentsEnabled,
  cast( _InspLotAggrgn.InspCharacteristicCount as vdm_inspcharacteristiccount preserving type ) AS InspCharacteristicCount,
  cast( _InspLotAggrgn.InspCharRejectedCount as vdm_inspcharrejectedcount preserving type ) AS InspCharRejectedCount,
  cast( _InspLotAggrgn.InspCharOpenCount as vdm_inspcharopencount preserving type ) AS InspCharOpenCount,
  cast((_InspLot.InspectionLotActualQuantity - _InspLot.InspLotQtyToBePosted) as vdm_insplotstkqtyposted) AS InspLotStkQtyPosted,
  cast(_InspLot.InspLotQtyToBePosted as vdm_insplotstkqtytobeposted) AS InspLotStkQtyToBePosted,
  _InspLot.Plant AS Plant,
  _InspLot.InspectionLotType AS InspectionLotType,
  _InspLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_InspectionLot AS _InspLot
LEFT OUTER JOIN I_InspectionLotAggregate AS _InspLotAggrgn ON InspectionLot = _InspLotAggrgn.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspLotUsageDecision AS _InspLotUsgeDcsn ON InspectionLot = _InspLotUsgeDcsn.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotWithStatus AS _InspectionLotWithStatus ON InspectionLot = _InspectionLotWithStatus.InspectionLot  -- association [1..1]
LEFT OUTER JOIN C_InspLotRsltRecgStatusT AS _InspLotRsltRecgStatusT ON InspLotRsltRecgStatus = _InspLotRsltRecgStatusT.InspLotRsltRecgStatus  -- association [0..1]
LEFT OUTER JOIN I_InspLotRsltRecgStatusText AS _InspLotRsltRecgStatusText ON InspLotRsltRecgStatus = _InspLotRsltRecgStatusText.InspLotRsltRecgStatus AND _InspLotRsltRecgStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_InspLotCompltnStatusText AS _InspLotCompltnStatusText ON InspLotCompltnStatus = _InspLotCompltnStatusText.InspLotCompltnStatus AND _InspLotCompltnStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_InspLotCompltnStatusT AS _InspLotCompltnStatusT ON InspLotCompltnStatus = _InspLotCompltnStatusT.InspLotCompltnStatus  -- association [0..1]
LEFT OUTER JOIN C_InspLotDefectCount AS _InspLotDefectCount ON InspectionLot = _InspLotDefectCount.InspectionLot  -- association [0..1]
;