I_NonFerrousChargeWeights

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_NonFerrousChargeWeights.
-- 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_NonFerrousChargeWeights AS
SELECT
  parnr AS NonFerrousBusinessPartner,
  matnr AS Material,
  kappl AS ConditionApplication,
  org AS NonFerrousOrganization,
  werks AS Plant,
  vtweg AS DistributionChannel,
  nes AS NonFerrousCode,
  vgw AS NonFerrousWeight,
  _NonFerrousMetalKey.BaseUnit AS BaseUnit,
  vge AS NonFerrousWgtBsRefQtyInBaseUoM,
  neb AS NonFerrousBaseCode
FROM /nfm/tvgw
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_NonFerrousMetalKeyVH AS _NonFerrousMetalKey ON NonFerrousCode = _NonFerrousMetalKey.NonFerrousCode  -- association [0..1]
LEFT OUTER JOIN I_NonFerrousBaseKeys AS _NonFerrousBaseKeys ON NonFerrousCode = _NonFerrousBaseKeys.NonFerrousCode AND NonFerrousBaseCode = _NonFerrousBaseKeys.NonFerrousBaseCode  -- association [0..1]
;