A_InsurClmFNOLTravel

DDL: A_INSURCLMFNOLTRAVEL Type: view_entity CONSUMPTION

FNOL Travel

A_InsurClmFNOLTravel is a Consumption CDS View that provides data about "FNOL Travel" in SAP S/4HANA. It reads from 1 data source (R_InsurClmFNOLTravelTP) and exposes 30 fields with key fields InsuranceClaim, InsurClmDamagedObject, InsurClmDmgdSubObject, InsurClmSubobjectCategory.

Data Sources (1)

SourceAliasJoin Type
R_InsurClmFNOLTravelTP R_InsurClmFNOLTravelTP projection

Annotations (9)

NameValueLevelField
EndUserText.label FNOL Travel view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name InsurClmFNOLTravel_Type view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmDamagedObject InsurClmDamagedObject Damaged Object
KEY InsurClmDmgdSubObject InsurClmDmgdSubObject Subobject
KEY InsurClmSubobjectCategory InsurClmSubobjectCategory Subobject Cat.
CreationDateTime CreationDateTime Timestamp
InsuranceClaimChangedByUser InsuranceClaimChangedByUser User Name
ChangedOnDateTime ChangedOnDateTime Last Changed At
InsurClmDamageCategory InsurClmDamageCategory
InsurClmType InsurClmType Claim Type
InsurClmSubclmType InsurClmSubclmType
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmProbableLossAmount InsurClmProbableLossAmount
InsurClmProbableLossAmountCrcy InsurClmProbableLossAmountCrcy
InsurClmDamageDescription InsurClmDamageDescription
InsurClmTrvlStartDate InsurClmTrvlStartDate
InsurClmTrvlToDate InsurClmTrvlToDate
InsurClmTrvlBkgDate InsurClmTrvlBkgDate
InsurClmTrvlAccdtDate InsurClmTrvlAccdtDate
InsurClmTrvlPurposeCode InsurClmTrvlPurposeCode
InsurClmTripIsWithFamily InsurClmTripIsWithFamily
InsurClmTrvlDiagnosisCode InsurClmTrvlDiagnosisCode
InsurClmTrvlDiagnosisCodeName InsurClmTrvlDiagnosisCodeName
InsurClmPrepaidIsAffected InsurClmPrepaidIsAffected
InsurClmOriglTranspNumber InsurClmOriglTranspNumber
InsurClmRvrtTranspNumber InsurClmRvrtTranspNumber
InsurClmOriglArrvlDateTime InsurClmOriglArrvlDateTime
InsurClmActlArrvlDateTime InsurClmActlArrvlDateTime
InsurClmCauseOfIssue InsurClmCauseOfIssue
InsurClmCauseOfIssueCodeName InsurClmCauseOfIssueCodeName
_ClaimredirectedtoparentA_InsurClmFNOL

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 A_InsurClmFNOLTravel.
-- 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 A_InsurClmFNOLTravel AS
SELECT
  InsuranceClaim,
  InsurClmDamagedObject,
  InsurClmDmgdSubObject,
  InsurClmSubobjectCategory,
  CreationDateTime,
  InsuranceClaimChangedByUser,
  ChangedOnDateTime,
  InsurClmDamageCategory,
  InsurClmType,
  InsurClmSubclmType,
  InsurClmDatabaseLineStatus,
  InsurClmProbableLossAmount,
  InsurClmProbableLossAmountCrcy,
  InsurClmDamageDescription,
  InsurClmTrvlStartDate,
  InsurClmTrvlToDate,
  InsurClmTrvlBkgDate,
  InsurClmTrvlAccdtDate,
  InsurClmTrvlPurposeCode,
  InsurClmTripIsWithFamily,
  InsurClmTrvlDiagnosisCode,
  InsurClmTrvlDiagnosisCodeName,
  InsurClmPrepaidIsAffected,
  InsurClmOriglTranspNumber,
  InsurClmRvrtTranspNumber,
  InsurClmOriglArrvlDateTime,
  InsurClmActlArrvlDateTime,
  InsurClmCauseOfIssue,
  InsurClmCauseOfIssueCodeName
FROM R_InsurClmFNOLTravelTP
;