I_WrntyClaimHeaderActvVersion

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_WrntyClaimHeaderActvVersion.
-- 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: IWRNTYHDRACTVR

CREATE VIEW I_WrntyClaimHeaderActvVersion AS
SELECT
  WrntyClaimHeaderUUID,
  _WrntyClaimVersion.WrntyVersionUUID AS WrntyVersionUUID,
  WarrantyClaimNumber,
  WarrantyClaimType,
  WrntyClaimExternalNumber,
  WarrantyObjectType,
  WrntyExternalObjectNumber,
  Plant,
  IsArchived,
  WarrantyClaimChangeDateTime,
  WrntyClaimCreationDate,
  CreatedByUser,
  WrntyClaimChangedDate,
  LastChangedByUser,
  WrntyClaimHeaderText,
  WrntyClaimCreationTime,
  WrntyClaimSourceObjectNumber,
  WrntyClaimSource,
  WrntyClaimDamageDate,
  WrntyClaimRegistrationDate,
  WrntyClaimRepairDate,
  WrntyClaimRepairEndDate,
  WrntySupplierCoverageType,
  WrntySuplrClmProcessingStatus,
  WrntySuplrClaimRespPerson,
  WrntySupplierClaimGroup,
  WrntySupplierClaimIsClosed,
  WrntySupplierClaimClosedDate,
  WrntySupplier,
  WrntySupplierRole,
  WrntySupplierApplicationLog,
  WrntySuplrClmApplLogMessage,
  _WrntyClaimVersion.WrntyDocumentCondition AS WrntyDocumentCondition,
  _WrntyClaimVersion.WrntyPriceExchangeRateDate AS WrntyPriceExchangeRateDate,
  _WrntyClaimVersion.WrntyCurrencyCode AS WrntyCurrencyCode,
  _WrntyClaimVersion.WrntyDecisionCode AS WrntyDecisionCode,
  _WrntyClaimVersion.PurchasingOrganization AS PurchasingOrganization,
  _WrntyClaimVersion.SalesOrganization AS SalesOrganization,
  _WrntyClaimVersion.WarrantyClaimVersionCategory AS WarrantyClaimVersionCategory,
  _WrntyClaimVersion.DistributionChannel AS DistributionChannel,
  _WrntyClaimVersion.Division AS Division,
  _WrntyClaimVersion.WrntyBillingDocumentDate AS WrntyBillingDocumentDate,
  _WrntyClaimVersion.WrntyVersionNumber AS WrntyVersionNumber,
  _WrntyClaimVersion._Version.WarrantyVersionRprstvID AS WarrantyVersionRprstvID,
  Header.WarrantyCustomer AS WarrantyCustomer
FROM I_WrntyClaimHeader AS Header
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON _WrntyClaimVersion.SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_WrntyClaimActvVersion AS _WrntyClaimVersion ON WrntyClaimHeaderUUID = _WrntyClaimVersion.WrntyClaimHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimDecisionCode AS _DecisionCode ON _WrntyClaimVersion.WrntyDecisionCode = _DecisionCode.WarrantyClaimItemDecisionCode  -- association [1..1]
LEFT OUTER JOIN I_WarrantyClaimVersionCategory AS _ClaimCategory ON WarrantyClaimVersionCategory = _ClaimCategory.WarrantyClaimVersionCategory  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimSource AS _ClaimSource ON WrntyClaimSource = _ClaimSource.ClaimSource  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimCoverageType AS _ClaimCoverageType ON WrntySupplierCoverageType = _ClaimCoverageType.WrntyClaimCoverageType  -- association [1..1]
;