I_ProdStrucVariantMaterial

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_ProdStrucVariantMaterial.
-- 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: IPSVARMATERIAL

CREATE VIEW I_ProdStrucVariantMaterial AS
SELECT
  pvcmpd.pvguid AS ProductStructureVariantUUID,
  pvcmpd.pvcdcnt AS ProdStrucVarBasicDataChgState,
  _Variant.ProdStrucVariantUniqueID AS ProdStrucVariantUniqueID,
  _Product.Product AS Material,
  case when pvcmpp.pvguid is null then pvcmpd.quant else pvcmpp.quant_fix end as ProductStructureVariantQty AS quant_fixendasProductStructureVariantQty,
  pvcmpd.qunit AS ProductStructureVariantUnit,
  _Product.AuthorizationGroup AS MaterialAuthorizationGroup,
  _Product._Text AS _Text,
  _Variant.ProductStructureGnrcObjType AS ProductStructureGnrcObjType
FROM pvcmpd
LEFT OUTER JOIN I_Product AS _Product ON pvcmpd.cmpid = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProdStrucVariantBasic AS _Variant ON ProductStructureVariantUUID = _Variant.ProductStructureVariantUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdStrucLogAccMActive AS _LogAccMObjectTypeActive ON productstructuregnrcobjtype = _LogAccMObjectTypeActive.LogAccMObjectType  -- association [0..1]
LEFT OUTER JOIN I_ProdStrucObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON prodstrucvariantuniqueid = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND productstructuregnrcobjtype = _LogAccMObjSecureIDAssgmt.LogAccMObjectType  -- association [0..1]
LEFT OUTER JOIN I_ProdStrucObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON prodstrucvariantuniqueid = _LogAccMObjectUserAuthzn.LogAccMObjectID AND productstructuregnrcobjtype = _LogAccMObjectUserAuthzn.LogAccMObjectType  -- association [0..*]
;