C_WrntyCustClmActvVersItemTP

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_WrntyCustClmActvVersItemTP.
-- 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_WrntyCustClmActvVersItemTP AS
SELECT
  cast (WrntyItemUUID as wty_pvguid preserving type ) AS WrntyItemUUID,
  WrntyVersionUUID,
  WrntyClaimHeaderUUID,
  WarrantyItemKey,
  WarrantyClaimItemNumber,
  WrntyControllingItemType,
  WarrantyClaimItemDefectCode,
  WrntyClaimItemPriceCndnAmount,
  WrntyClaimItemPriceCndnCrcy,
  WrntyClmItmDfltCndnType AS ConditionType,
  WrntyClaimQuantity,
  QuantityUnit,
  WrntyCurrencyCode,
  WarrantyClaimItemDecisionCode,
  WarrantyClaimCatalog,
  WrntyClmPartsIsCausingDamage,
  WrntyClaimItemShortText,
  WrntyClaimantClaimAmount,
  WrntyClaimedApprovedAmount,
  Material,
  WrntyReturnPartsFrmCustStatus,
  WarrantyClaimItemTaxCode,
  WarrantyItemType,
  _ItemTypeVisibility.WrntyMaterialItemIsHidden AS WrntyMaterialItemIsHidden,
  _ItemTypeVisibility.WrntyItemIsHidden AS WrntyItemIsHidden,
  WarrantyClaimChangeDateTime,
  WrntyClaimCreationDate,
  CreatedByUser,
  WrntyClaimChangedDate,
  LastChangedByUser,
  WrntyDocumentCondition,
  WrntyPriceExchangeRateDate,
  WrntyItemCustRetPartsDate,
  WrntyItmCustRetPartsDelivDate,
  virtual TransactionCurrency : waerk AS virtualTransactionCurrencywaerk,
  virtual TotalNetAmount : netwr_ak AS virtualTotalNetAmountnetwr_ak,
  virtual WrntyClaimTaxAmount : wertv8 AS virtualWrntyClaimTaxAmountwertv8,
  virtual WarrantyClaimHasCreateHide : boolean AS virtualWarrantyClaimHasCreateHideboolean,
  _Material._Text.MaterialName as MaterialName : localized AS MaterialNameasMaterialNamelocalized,
  virtual NoteText : nte_cont AS virtualNoteTextnte_cont,
  virtual WrntyItemHiddenPart : abap_boolean AS virtualWrntyItemHiddenPartabap_boolean
FROM R_WrntyClaimItemTP
LEFT OUTER JOIN C_WrntyCustomerPricingElement AS _ItemPricingElement ON WrntyClaimHeaderUUID = _ItemPricingElement.WrntyClaimHeaderUUID AND WrntyVersionUUID = _ItemPricingElement.WrntyVersionUUID AND WrntyItemUUID = _ItemPricingElement.WrntyItemUUID  -- association [1..*]
;