C_VariantConfigurationInstance

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 C_VariantConfigurationInstance.
-- 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 C_VariantConfigurationInstance AS
SELECT
  cast('' as ib_root) AS VarConfigurationRootInstance,
  VarConfigurationBusObjectKey,
  VarConfigurationBusObjectType,
  VarConfignInstceInternalID,
  VarConfignParInstceInternalID,
  VarConfignStatus,
  Product,
  Class,
  ClassType,
  BillOfMaterialItemCategory,
  BillOfMaterialItemNumber,
  IdentifierBOMItem,
  BOMItemHasFixedQuantity,
  BillOfMaterialItemQuantity,
  BillOfMaterialItemUnit,
  VariantConfigurationQuantity,
  VarConfignQuantityUnit,
  BOMItemIsSalesRelevant,
  MaterialIsConfigurable,
  FixedItemCategory,
  BillOfMaterialItemObjectType
FROM R_VarConfigurationInstanceTP
LEFT OUTER JOIN C_VarConfignCharacteristic AS _Characteristic ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_VarConfignVariantCondition AS _VariantCondition ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_VarConfignInstceCharcGroup AS _CharacteristicGroup ON /* condition not available in parsed metadata */  -- association [0..*]
;