/SCMTMS/CV_ProductRoot

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 /SCMTMS/CV_ProductRoot.
-- 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: /SCMTMS/CV_PRDRT

CREATE VIEW /SCMTMS/CV_ProductRoot AS
SELECT
  cast( _Product.Product as /scmtms/mat_apn) AS internal_id,
  _Product.ProductUUID AS product_uuid,
  cast( _Product.IsMarkedForDeletion as lvorm ) AS lvorm,
  cast( _ProductSales.AllowedPackagingWeightQty as /scmtms/res_maxw ) AS maxw,
  cast( _ProductSales.AllowedPackagingWeightQtyUnit as meins ) AS maxw_uom,
  cast( _ProductSales.ExcessWeightTolerance as /scmtms/res_maxw_tol ) AS maxw_tol,
  cast( _ProductSales.AllowedPackagingVolumeQty as /scmtms/res_maxv ) AS maxv,
  cast( _ProductSales.AllowedPackagingVolumeQtyUnit as meins ) AS maxv_uom,
  cast( _ProductSales.ExcessVolumeTolerance as /scmtms/res_maxv_tol ) AS maxv_tol,
  cast( _ProductSales.PackagingMaterialType as /scmtms/res_pmtyp ) AS pmtyp,
  cast( _ProductSales.IsClosedPackagingMaterial as /scmtms/res_closed_pm ) AS closed_pm,
  cast( _Product.HasVariableTareWeight as /scmtms/res_tare_var ) AS tare_var,
  cast( _ProductSales.VolumeMaximumLevel as /scmtms/res_max_fill_up ) AS max_fill_up,
  cast( _Product.MaximumPackagingLength as /scmtms/res_maxl ) AS maxl,
  cast( _Product.MaximumPackagingHeight as /scmtms/res_maxh ) AS maxh,
  cast( _Product.MaximumPackagingWidth as /scmtms/res_maxb ) AS maxb,
  cast( _Product.UnitForMaxPackagingDimensions as meins ) AS maxdim_uom,
  cast( _Product.TransportationGroup as /scmtms/prod_transp_grp_cd ) AS tragr,
  _ProductSales.MaterialFreightGroup AS mfrgr,
  _Product.DangerousGoodsIndProfile AS dgprofl,
  _Product.CountryOfOrigin AS herkl,
  _Product.NetWeight AS ntgew,
  _Product.WeightUnit AS gewei,
  _Product._ProductSCM.PckgBuildingReferenceProduct AS rmatp_pb
FROM I_Product AS _Product
LEFT OUTER JOIN I_ProductSales AS _ProductSales ON _Product.Product = _ProductSales.Product  -- association [0..1]
;