C_WrntyCustomerClaimVersionTP

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_WrntyCustomerClaimVersionTP.
-- 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_WrntyCustomerClaimVersionTP AS
SELECT
  WrntyClmCustVersion.WrntyVersionUUID AS WrntyVersionUUID,
  WrntyClmCustVersion.WrntyClaimHeaderUUID AS WrntyClaimHeaderUUID,
  WrntyClmCustVersion.WrntyVersionNumber AS WrntyVersionNumber,
  WrntyClmCustVersion.WarrantyClaimVersionCategory AS WarrantyClaimVersionCategory,
  WrntyClmCustVersion. WrntyDecisionCode AS WrntyDecisionCode,
  WrntyClmCustVersion.WarrantyClaimVersionPartner AS WarrantyClaimVersionPartner,
  _Supplier.SupplierName AS SupplierName,
  WrntyClmCustVersion.WarrantyClaimVersionIsActive AS WarrantyClaimVersionIsActive,
  WrntyClmCustVersion.WrntyBillingDocumentDate AS WrntyBillingDocumentDate,
  WrntyClmCustVersion.WrntyDocumentCondition AS WrntyDocumentCondition,
  WrntyClmCustVersion.WrntyCurrencyCode AS WrntyCurrencyCode,
  WrntyClmCustVersion.WrntyPriceExchangeRateDate AS WrntyPriceExchangeRateDate,
  WrntyClmCustVersion.WrntyExchangeRateForPrice AS WrntyExchangeRateForPrice,
  WrntyClmCustVersion.WrntyClmPrecedingVersionNmbr AS WrntyClmPrecedingVersionNmbr,
  WrntyClmCustVersion.SalesOrganization AS SalesOrganization,
  WrntyClmCustVersion.DistributionChannel AS DistributionChannel,
  WrntyClmCustVersion.Division AS Division,
  WrntyClmCustVersion.WrntyVersionForReversePosting AS WrntyVersionForReversePosting,
  WrntyClmCustVersion.PurchasingOrganization AS PurchasingOrganization,
  WrntyClmCustVersion.WarrantyVersionPricingStatus AS WarrantyVersionPricingStatus,
  WrntyClmCustVersion.WrntyVersIsReldForShipgToPart AS WrntyVersIsReldForShipgToPart,
  WrntyClmCustVersion.WarrantyClaimChangeDateTime AS WarrantyClaimChangeDateTime,
  WrntyClmCustVersion.WrntyClaimCreationDate AS WrntyClaimCreationDate,
  WrntyClmCustVersion.CreatedByUser AS CreatedByUser,
  WrntyClmCustVersion.WrntyClaimChangedDate AS WrntyClaimChangedDate,
  WrntyClmCustVersion.LastChangedByUser AS LastChangedByUser,
  virtual WrntyTotalLaborAmount : wty_sum_fr AS virtualWrntyTotalLaborAmountwty_sum_fr,
  virtual TotalNetAmount : netwr_ak AS virtualTotalNetAmountnetwr_ak,
  virtual WrntyClaimTaxAmount : wertv8 AS virtualWrntyClaimTaxAmountwertv8,
  WrntyClmCustVersion.WarrantyVersionRprstvID AS WarrantyVersionRprstvID,
  _WrntyClaimHeader._ResponsiblePerson.FullName AS FullName,
  _WrntyClaimHeader.Plant AS Plant,
  _WrntyClaimHeader.WarrantyObjectType AS WarrantyObjectType,
  _WrntyClaimHeader.WrntyExternalObjectNumber AS WrntyExternalObjectNumber,
  _WrntyClaimHeader.WrntyClaimDamageDate AS WrntyClaimDamageDate,
  _WrntyClaimHeader.WrntyClaimRepairDate AS WrntyClaimRepairDate,
  _WrntyClaimHeader.WrntyClaimRepairEndDate AS WrntyClaimRepairEndDate,
  _WrntyClaimHeader.WrntyClaimSourceObjectNumber AS WrntyClaimSourceObjectNumber,
  _WrntyClaimHeader.WrntyClaimSource AS WrntyClaimSource,
  _WrntyClaimHeader.WrntyClaimRegistrationDate AS WrntyClaimRegistrationDate
FROM R_WrntyClaimVersionTP
LEFT OUTER JOIN C_WrntyCustomerPricingElement AS _PricingElement ON WrntyClaimHeaderUUID = _PricingElement.WrntyClaimHeaderUUID AND WrntyVersionUUID = _PricingElement.WrntyVersionUUID  -- association [1..*]
;