I_WrntyCustClmActvVersionItem

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_WrntyCustClmActvVersionItem.
-- 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: IWTYCUSTCLMVNITM

CREATE VIEW I_WrntyCustClmActvVersionItem AS
SELECT
  Item.WrntyItemUUID AS WrntyItemUUID,
  ActiveVersion.WrntyClaimHeaderUUID AS WrntyClaimHeaderUUID,
  Item.WrntyVersionUUID AS WrntyVersionUUID,
  Item.WarrantyItemKey AS WarrantyItemKey,
  Item.WarrantyClaimItemNumber AS WarrantyClaimItemNumber,
  Item.WrntyControllingItemType AS WrntyControllingItemType,
  Item.WarrantyClaimItemDefectCode AS WarrantyClaimItemDefectCode,
  Item.WrntyClaimQuantity AS WrntyClaimQuantity,
  Item.QuantityUnit AS QuantityUnit,
  Item.WrntyCurrencyCode AS WrntyCurrencyCode,
  Item.WarrantyClaimItemDecisionCode AS WarrantyClaimItemDecisionCode,
  Item.WrntyClmPartsIsCausingDamage AS WrntyClmPartsIsCausingDamage,
  Item.WrntyClaimItemShortText AS WrntyClaimItemShortText,
  Item.WrntyClaimantClaimAmount AS WrntyClaimantClaimAmount,
  Item.WrntyReimburserClaimAmount AS WrntyReimburserClaimAmount,
  Item.WrntyReimburseApprovedAmount AS WrntyReimburseApprovedAmount,
  Item.WrntyClaimedApprovedAmount AS WrntyClaimedApprovedAmount,
  Item.Material AS Material,
  Item.WrntyReturnPartsFrmCustStatus AS WrntyReturnPartsFrmCustStatus,
  Item.WarrantyClaimItemTaxCode AS WarrantyClaimItemTaxCode,
  Item.WarrantyItemType AS WarrantyItemType,
  Item.WrntyItemCustRetPartsDate AS WrntyItemCustRetPartsDate,
  Item.WrntyItemSuplrRetPartsDate AS WrntyItemSuplrRetPartsDate,
  Item.WrntyItmCustRetPartsDelivDate AS WrntyItmCustRetPartsDelivDate,
  Item.WrntyItmSuplrRetPartsDelivDate AS WrntyItmSuplrRetPartsDelivDate,
  Item.WarrantyClaimCatalog AS WarrantyClaimCatalog,
  Item.WarrantyClaimItemPricingStatus AS WarrantyClaimItemPricingStatus,
  Item.WarrantyClaimChangeDateTime AS WarrantyClaimChangeDateTime,
  Item.WrntyClaimCreationDate AS WrntyClaimCreationDate,
  Item.CreatedByUser AS CreatedByUser,
  Item.WrntyClaimChangedDate AS WrntyClaimChangedDate,
  Item.LastChangedByUser AS LastChangedByUser,
  Item.WrntyClmItmDfltCndnType AS WrntyClmItmDfltCndnType,
  Item.WrntyDocumentCondition AS WrntyDocumentCondition,
  _WrntyClaimVersion.SalesOrganization AS SalesOrganization,
  _WrntyClaimVersion.WrntyPriceExchangeRateDate AS WrntyPriceExchangeRateDate,
  Item._LastChangedByUser AS _LastChangedByUser
FROM I_WrntyClaimItem AS Item
INNER JOIN I_WrntyCustClaimActvVersion AS ActiveVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WrntyClaimActvVersion AS _WrntyClaimVersion ON WrntyClaimHeaderUUID = _WrntyClaimVersion.WrntyClaimHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimHeader AS _WrntyClaimHeader ON WrntyClaimHeaderUUID = _WrntyClaimHeader.WrntyClaimHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_WrntyDefectCodeText AS _DefectCode ON WarrantyClaimItemDefectCode = _DefectCode.InspectionCode  -- association [1..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimDecisionCode AS _DecisionCode ON WarrantyClaimItemDecisionCode = _DecisionCode.WarrantyClaimItemDecisionCode  -- association [1..1]
LEFT OUTER JOIN I_WrntyClaimItemTypeText AS _ItemTypeText ON WarrantyItemType = _ItemTypeText.WarrantyItemType  -- association [1..*]
;