C_InsurClmChangeHeaderTP

DDL: C_INSURCLMCHANGEHEADERTP Type: view_entity CONSUMPTION
44 Fields 1 Data Sources 3 Associations

Update Claim Header

C_InsurClmChangeHeaderTP is a Consumption CDS View that provides data about "Update Claim Header" in SAP S/4HANA. It reads from 1 data source (I_InsurClmChangeHeaderTP) and exposes 44 fields with key fields InsuranceClaim, InsurClaimUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmChangeHeaderTP I_InsurClmChangeHeaderTP projection

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_InsurClmBPQuickView _BPDetails $projection.InsurancePolicyholder = _BPDetails.BusinessPartner
[1..1] C_InsurClmPolicyInquiry _ContractOvw $projection.InsuranceClaim = _ContractOvw.InsuranceClaim and $projection.InsuranceContract = _ContractOvw.InsuranceContract
[1..1] I_Region _RegionText _RegionText.Country = $projection.Country and _RegionText.Region = $projection.Region

Annotations (8)

NameValueLevelField
EndUserText.label Update Claim Header view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey InsuranceClaim view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClaimUUID InsurClaimUUID
InsuranceContract InsuranceContract Contract
InsurClmContractStartDateTime InsurClmContractStartDateTime
InsurClmContractEndDateTime InsurClmContractEndDateTime
InsurClmPolicyProduct InsurClmPolicyProduct Policy Product
InsurClmDateOfLoss InsurClmDateOfLoss Date of Loss
ChangedOnDateTime ChangedOnDateTime Last Changed At
InsurClmLossLocAddressID InsurClmLossLocAddressID Loss Location
InsurClmCauseOfLoss InsurClmCauseOfLoss Cause of Loss
InsurClmIncdntType InsurClmIncdntType Incident Type
InsurClmComplexity InsurClmComplexity Complexity
InsurClmLifeCycSts InsurClmLifeCycSts Status
InsurClmStatReason InsurClmStatReason Status Reason
InsurClmStatReasonText InsurClmStatReasonText
InsurClmIncdntTypeName InsurClmIncdntTypeName
InsurClaimBundle InsurClaimBundle Claim Bundle
InsurClmComplexityName InsurClmComplexityName
InsurClmType InsurClmType Claim Type
InsurClmTypeGeneration InsurClmTypeGeneration Generation
InsurClmTypeVers InsurClmTypeVers Clm Type Versn
InsurClmAuthznGrp InsurClmAuthznGrp AuthGroup (VIP)
InsurClmLifeCycStsName InsurClmLifeCycStsName
InsurClmPolicyHolderName InsurClmPolicyHolderName
InsurancePolicyholder InsurancePolicyholder BusPartner
InsurClmPlcyProdName InsurClmPlcyProdName
InsurancePolicy InsurancePolicy Policy Number
FullName FullName Name
StreetName StreetName Text
HouseNumber HouseNumber House Number
CityName CityName Name
Region Region Venue Region
PostalCode PostalCode Postal Code
Country Country Venue: Ctry/Reg
InsurClmVehiclePlateNumber InsurClmVehiclePlateNumber
InsurClmLiabilityRate InsurClmLiabilityRate
InsurClmCauseOfLossName InsurClmCauseOfLossName
InsurClmDescriptionOfLossLoc InsurClmDescriptionOfLossLoc Description of Loss Location
InsurClmIncidentDetailsText InsurClmIncidentDetailsText Incident Details
InsurClmImageURL InsurClmImageURL
InsurClmCriticalityCat InsurClmCriticalityCat
_BPDetails _BPDetails
_ContractOvw _ContractOvw
_RegionText _RegionText

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_InsurClmChangeHeaderTP.
-- 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_InsurClmChangeHeaderTP AS
SELECT
  InsuranceClaim,
  InsurClaimUUID,
  InsuranceContract,
  InsurClmContractStartDateTime,
  InsurClmContractEndDateTime,
  InsurClmPolicyProduct,
  InsurClmDateOfLoss,
  ChangedOnDateTime,
  InsurClmLossLocAddressID,
  InsurClmCauseOfLoss,
  InsurClmIncdntType,
  InsurClmComplexity,
  InsurClmLifeCycSts,
  InsurClmStatReason,
  InsurClmStatReasonText,
  InsurClmIncdntTypeName,
  InsurClaimBundle,
  InsurClmComplexityName,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmAuthznGrp,
  InsurClmLifeCycStsName,
  InsurClmPolicyHolderName,
  InsurancePolicyholder,
  InsurClmPlcyProdName,
  InsurancePolicy,
  FullName,
  StreetName,
  HouseNumber,
  CityName,
  Region,
  PostalCode,
  Country,
  InsurClmVehiclePlateNumber,
  InsurClmLiabilityRate,
  InsurClmCauseOfLossName,
  InsurClmDescriptionOfLossLoc,
  InsurClmIncidentDetailsText,
  InsurClmImageURL,
  InsurClmCriticalityCat
FROM I_InsurClmChangeHeaderTP
LEFT OUTER JOIN C_InsurClmBPQuickView AS _BPDetails ON InsurancePolicyholder = _BPDetails.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_InsurClmPolicyInquiry AS _ContractOvw ON InsuranceClaim = _ContractOvw.InsuranceClaim AND InsuranceContract = _ContractOvw.InsuranceContract  -- association [1..1]
LEFT OUTER JOIN I_Region AS _RegionText ON _RegionText.Country = Country AND _RegionText.Region = Region  -- association [1..1]
;

Learn More