C_WrntySuplrClmActvVersItemTP

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