C_WrntyCustClaimHeaderVH

DDL: C_WRNTYCUSTCLAIMHEADERVH SQL: CWTYCUSTCLMHDRVH Type: view CONSUMPTION
11 Fields 2 Data Sources

Customer Claim Header

C_WrntyCustClaimHeaderVH is a Consumption CDS View that provides data about "Customer Claim Header" in SAP S/4HANA. It reads from 2 data sources (I_WrntyClaimHeader, I_WrntyClaimType) and exposes 11 fields with key field WarrantyClaimNumber.

Data Sources (2)

SourceAliasJoin Type
I_WrntyClaimHeader Header from
I_WrntyClaimType I_WrntyClaimType inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CWTYCUSTCLMHDRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey WarrantyClaimNumber view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Customer Claim Header view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY WarrantyClaimNumber WarrantyClaimNumber Claim Number
WarrantyCustomer WarrantyCustomer Customer
CustomerFullName _Customer CustomerFullName Customer Name
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
WrntyClaimExternalNumber I_WrntyClaimHeader WrntyClaimExternalNumber External Number
ObjectType I_WrntyClaimHeader WarrantyObjectType Object type
WrntyCustClmProcessingStatus I_WrntyClaimHeader WrntyCustClmProcessingStatus Processing Status
WarrantyClaimType I_WrntyClaimHeader WarrantyClaimType WtyClmType
WarrantyClaimVersionCategory I_WrntyClaimType WarrantyClaimVersionCategory Category
_Customer I_WrntyClaimHeader _Customer

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_WrntyCustClaimHeaderVH.
-- 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: CWTYCUSTCLMHDRVH

CREATE VIEW C_WrntyCustClaimHeaderVH AS
SELECT
  WarrantyClaimNumber,
  WarrantyCustomer,
  _Customer.CustomerFullName AS CustomerFullName,
  Plant,
  _Plant.PlantName AS PlantName,
  Header.WrntyClaimExternalNumber AS WrntyClaimExternalNumber,
  Header.WarrantyObjectType AS ObjectType,
  Header.WrntyCustClmProcessingStatus AS WrntyCustClmProcessingStatus,
  Header.WarrantyClaimType AS WarrantyClaimType,
  I_WrntyClaimType.WarrantyClaimVersionCategory AS WarrantyClaimVersionCategory,
  Header._Customer AS _Customer
FROM I_WrntyClaimHeader AS Header
INNER JOIN I_WrntyClaimType ON /* join condition not captured in parsed metadata */
;

Learn More