I_DSD_SettlementQuantityDiff

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_DSD_SettlementQuantityDiff.
-- 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.

CREATE VIEW I_DSD_SettlementQuantityDiff AS
SELECT
  sld_doc_id AS DSD_SettlementDocument,
  matnr AS Material,
  quan_planned AS TargetQuantity,
  quan_checkout AS SettlementCheckOutQuantity,
  quan_diff AS SettlmtCheckOutDiffQuantity,
  quan_delivered AS SettlementDeliveryQuantity,
  quan_return AS SettlementReturnedQuantity,
  quan_checkin AS SettlementCheckInQuantity,
  quan_final_diff AS SettlementFinalDiffQuantity,
  uom_for_quan AS UnitOfMeasure,
  value_fin_diff AS QuantityDifferenceAmount,
  currency_fin_dif AS Currency,
  Plant,
  charg AS Batch,
  bwtar AS ValuationType,
  spec_return AS CtrlParamForQuantityDifference,
  co_diff_eval AS CheckOutDiffWithinTolerance,
  quan_checkin_pln AS SettlmtPlannedCheckInQuantity,
  quan_checkin_dif AS SettlementCheckInDiffQuantity,
  ci_diff_eval AS CheckInDiffWithinTolerance,
  quan_lc_init AS SettlementLoadingConfQuantity,
  quan_lc_init_dif AS SettlmtLoadgConfDiffQuantity,
  quan_rld_plan AS SettlmtPlannedReloadQuantity,
  quan_rld_ci AS SettlmtReloadCheckInQuantity,
  quan_rld_lc AS SettlmtRldLoadingConfQuantity,
  quan_rld_lc_diff AS SettlmtRldLoadgConfDiffQty,
  quan_rld_co AS SettlmtReloadCheckOutQuantity,
  quan_rld_co_diff AS SettlmtRldCheckOutDiffQuantity,
  lc_diff_eval AS LoadgConfDiffWithinTolerance,
  quan_final_plan AS SettlmtPlndCheckOutCheckInQty,
  quan_final AS SettlmtCheckOutCheckInQuantity,
  final_diff_eval AS FinalDifferenceWithinTolerance,
  tolgrp_id AS SettlementToleranceGroup
FROM /dsd/sl_sld_qbal AS _QuantityDifferences
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_DSD_DifferenceEvaluation AS _CheckOutEvaluation ON CheckOutDiffWithinTolerance = _CheckOutEvaluation.DifferenceEvaluation  -- association [0..1]
LEFT OUTER JOIN I_DSD_DifferenceEvaluation AS _CheckInEvaluation ON CheckInDiffWithinTolerance = _CheckInEvaluation.DifferenceEvaluation  -- association [0..1]
LEFT OUTER JOIN I_DSD_DifferenceEvaluation AS _ConfirmationEvaluation ON LoadgConfDiffWithinTolerance = _ConfirmationEvaluation.DifferenceEvaluation  -- association [0..1]
LEFT OUTER JOIN I_DSD_DifferenceEvaluation AS _FinalEvaluation ON FinalDifferenceWithinTolerance = _FinalEvaluation.DifferenceEvaluation  -- association [0..1]
LEFT OUTER JOIN I_DSD_TourControlParameter AS _ControlParameter ON CtrlParamForQuantityDifference = _ControlParameter.CtrlParamForQuantityDifference  -- association [0..1]
LEFT OUTER JOIN I_DSD_SettlementToleranceGroup AS _ToleranceGroup ON SettlementToleranceGroup = _ToleranceGroup.SettlementToleranceGroup  -- association [0..1]
;