I_WrntyClaimVersion

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_WrntyClaimVersion.
-- 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: IWRNTYCLMVRN

CREATE VIEW I_WrntyClaimVersion AS
SELECT
  pnguid AS WrntyVersionUUID,
  header_guid AS WrntyClaimHeaderUUID,
  cast(versn as wty_versn preserving type ) AS WrntyVersionNumber,
  kateg AS WarrantyClaimVersionCategory,
  v_rejcd AS WrntyDecisionCode,
  v_parnr AS WarrantyClaimVersionPartner,
  cast(v_parvw as parvw_unv preserving type ) AS WrntyClaimVersionPartnerRole,
  aktiv AS WarrantyClaimVersionIsActive,
  fkdat AS WrntyBillingDocumentDate,
  knumv AS WrntyDocumentCondition,
  v_crncy AS WrntyCurrencyCode,
  prsdt AS WrntyPriceExchangeRateDate,
  cast(kursk as fis_absolute_exchangerate preserving type) AS WrntyExchangeRateForPrice,
  prev_version AS WrntyNumberPrecedingVersion,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  reversal AS WrntyVersionForReversePosting,
  ekorg AS PurchasingOrganization,
  pricing_ok AS WarrantyVersionPricingStatus,
  compsend AS WrntyVersIsReldForShipgToPart,
  timstmp AS WarrantyClaimChangeDateTime,
  creadat AS WrntyClaimCreationDate,
  creaby AS CreatedByUser,
  chngdat AS WrntyClaimChangedDate,
  chngby AS LastChangedByUser,
  pntext AS WarrantyClaimVersionText,
  vers_representativeid AS WarrantyVersionRprstvID,
  _WrntyClaimHeader.WrntyCustClmProcessingStatus AS WrntyCustClmProcessingStatus,
  _WrntyClaimHeader.WrntySuplrClmProcessingStatus AS WrntySuplrClmProcessingStatus
FROM pnwtyv
LEFT OUTER JOIN I_WrntyClaimHeader AS _WrntyClaimHeader ON WrntyClaimHeaderUUID = _WrntyClaimHeader.WrntyClaimHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimHeader AS _Header ON WrntyClaimHeaderUUID = _Header.WrntyClaimHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimItem AS _WrntyClaimItem ON WrntyVersionUUID = _WrntyClaimItem.WrntyVersionUUID  -- association [1..*]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON WarrantyClaimVersionPartner = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON WarrantyClaimVersionPartner = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_WrntyClaimDecisionCode AS _DecisionCode ON WrntyDecisionCode = _DecisionCode.WarrantyClaimItemDecisionCode  -- association [1..1]
LEFT OUTER JOIN I_WarrantyClaimVersionCategory AS _VersionCategory ON WarrantyClaimVersionCategory = _VersionCategory.WarrantyClaimVersionCategory  -- association [1..1]
LEFT OUTER JOIN E_WarrantyClaimVersion AS _ExtensionWrntyVers ON WrntyVersionUUID = _ExtensionWrntyVers.WrntyVersionUUID  -- association [1..1]
;