P_VarConfignInstanceOwner

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 P_VarConfignInstanceOwner.
-- 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: PVARCONFIGINSTOW

CREATE VIEW P_VarConfignInstanceOwner AS
SELECT
  Hrcy.InstalledBaseComponentRecordNo AS VarConfignInstanceRecordNo,
  Hrcy.IBaseStrucCompRecordNumber AS IBaseStrucCompRecordNumber,
  Hrcy.InstalledBaseComponent AS VariantConfigurationInstance,
  Hrcy.VariantConfigurationDate AS VariantConfigurationDate,
  ConfigOwner.InstalledBaseCompOwnrObjKey AS VarConfignInstceBusObjectKey,
  ConfigOwner.IBaseComponentOwnerObjectType AS VarConfignInstceBusObjectType,
  Hrcy.IBaseComponentRootInstance AS VarConfigurationRootInstance,
  Hrcy.IBaseComponentParentInstance AS VarConfigurationParentInstance,
  Hrcy.VarConfignInstanceObjectType AS VarConfignInstanceObjectType,
  Hrcy.InstalledBase AS IBase,
  Hrcy.ConfigurationProfileCounter AS ConfigurationProfileCounter,
  cast( 'X' as abap_boolean preserving type ) AS BusObjIsVarConfignOwner
FROM I_IBaseInstanceHierarchy AS Hrcy
INNER JOIN I_IBaseOwner AS ConfigOwner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ObjectNumberForProduct AS ObjNmbrMat ON ObjNmbrMat.IBaseInstanceObjectNumber = Hrcy.VariantConfignInstanceObject  -- association [0..1]
;