R_VarCnfHistlProductProfileTP

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 R_VarCnfHistlProductProfileTP.
-- 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 R_VarCnfHistlProductProfileTP AS
SELECT
  cast (substring( VariantConfigurationObject, 1, 40 ) as productnumber preserving type ) AS Product,
  VarConfigurationProfileName,
  ChangeNumber,
  ClassType,
  VarConfigurationProfileNumber,
  VarConfigurationProfileStatus,
  ValidityStartDate,
  ValidityEndDate,
  IsDeleted,
  BOMExplosionApplication,
  BOMExplosionLevel,
  VarConfigurationProfileProcess,
  VarCnfPrflOrderBOMFixatingMode,
  VarCnfProfilePriorityValue,
  ObjDpnAssignmentNumber,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  LastChangeDateTime
FROM I_VarCnfHistoricalProfileBasic
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN R_VarCnfProdPrflProcedAssgmtTP AS _ProcedureAssignment ON Product = _ProcedureAssignment.Product AND VarConfigurationProfileName = _ProcedureAssignment.VarConfigurationProfileName AND ObjDpnAssignmentNumber = _ProcedureAssignment.ObjDpnAssignmentNumber AND ValidityStartDate <= _ProcedureAssignment.ValidityEndDate AND ValidityEndDate >= _ProcedureAssignment.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN R_VarCnfProdPrflCstrtNetAsgtTP AS _ConstraintNetAssignment ON Product = _ConstraintNetAssignment.Product AND VarConfigurationProfileName = _ConstraintNetAssignment.VarConfigurationProfileName AND ObjDpnAssignmentNumber = _ConstraintNetAssignment.ObjDpnAssignmentNumber AND ValidityStartDate <= _ConstraintNetAssignment.ValidityEndDate AND ValidityEndDate >= _ConstraintNetAssignment.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN R_VarCnfProdPrflChGrpAsgtTP AS _CharacteristicGroupAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
;