R_INS_ClaimItemDiagnosisDraft

DDL: R_INS_CLAIMITEMDIAGNOSISDRAFT Type: view_entity BASIC
38 Fields 1 Data Sources

Claim Item Diagnosis - Draft

R_INS_ClaimItemDiagnosisDraft is a Basic CDS View that provides data about "Claim Item Diagnosis - Draft" in SAP S/4HANA. It reads from 1 data source (icldiagndraft3) and exposes 38 fields with key fields InsurClmActive, InsuranceClaim, InsurClmInjuredPersonNumber, InsurClmSubobjectCategory, InsurClmDmgdSubObject.

Data Sources (1)

SourceAliasJoin Type
icldiagndraft3 ICL_DiagnDraft from

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Claim Item Diagnosis - Draft view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewCompositions false view
AbapCatalog.extensibility.elementSuffix ICL view
AbapCatalog.extensibility.quota.maximumFields 500 view
AbapCatalog.extensibility.quota.maximumBytes 5000 view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive insurclmactive Active/Suspense
KEY InsuranceClaim insuranceclaim Claim Number
KEY InsurClmInjuredPersonNumber insurclminjuredpersonnumber Injured person
KEY InsurClmSubobjectCategory insurclmsubobjectcategory Subobject Cat.
KEY InsurClmDmgdSubObject insurclmdmgdsubobject Subobject
KEY InsurClmDiagnosisNmbr insurclmdiagnosisnmbr Diagnosis No.
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
InsurClmDatabaseLineStatus insurclmdatabaselinestatus Status
InsurClmCatalogCode insurclmcatalogcode Catalog
InsurClmDiagnosisCode Primary Diagn.
InsurClmBusinessPartner insurclmbusinesspartner Participant
InsurClmSecdryCtlgCode insurclmsecdryctlgcode Catalog
InsurClmSecdryDiagnCode Secondary Diag.
InsurClmPrevDiagnNmbr insurclmprevdiagnnmbr Diagnosis No.
InsurClmDiagnosisDescription insurclmdiagnosisdescription Diagnosis Desc.
InsuranceClaimDiagnosisEndDate insuranceclaimdiagnosisenddate End Date
InsurClmItemGroupingCategory insurclmitemgroupingcategory ClmItemGrpngCat
InsurClmDiagnosisSourceId insurclmdiagnosissourceid Diag.Srce ID
InsurClmDiagnosisTypeCode insurclmdiagnosistypecode Diagnosis Type
InsurClmLocalizedSide insurclmlocalizedside Localization
InsurClmSvrtyOfDiagnCode insurclmsvrtyofdiagncode Severity
InsurClmDiagnMorphologyCode insurclmdiagnmorphologycode Morphology
InsurClmDiagnExcoriationCode insurclmdiagnexcoriationcode Excoriation
InsurClmDiagnGuaranteeCode insurclmdiagnguaranteecode Certainty
InsurClmDeptOfHosp insurclmdeptofhosp Department
InsurClaimDiagnSequence insurclaimdiagnsequence Sequence
InsurClmSecdryLcldSide insurclmsecdrylcldside Localization 2
InsurClmIsUsdForGrpg insurclmisusdforgrpg Used f.Grouping
InsurClmAssignUUID insurclmassignuuid Link UUID
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_INS_ClaimItemDiagnosisDraft.
-- 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 R_INS_ClaimItemDiagnosisDraft AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmInjuredPersonNumber,
  InsurClmSubobjectCategory,
  InsurClmDmgdSubObject,
  InsurClmDiagnosisNmbr,
  DraftUUID,
  ParentDraftUUID,
  LastChangeDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmCatalogCode,
  cast( insurclmdiagnosiscode as char10 ) AS InsurClmDiagnosisCode,
  InsurClmBusinessPartner,
  InsurClmSecdryCtlgCode,
  cast( insurclmsecdrydiagncode as char10 ) AS InsurClmSecdryDiagnCode,
  InsurClmPrevDiagnNmbr,
  InsurClmDiagnosisDescription,
  InsuranceClaimDiagnosisEndDate,
  InsurClmItemGroupingCategory,
  InsurClmDiagnosisSourceId,
  InsurClmDiagnosisTypeCode,
  InsurClmLocalizedSide,
  InsurClmSvrtyOfDiagnCode,
  InsurClmDiagnMorphologyCode,
  InsurClmDiagnExcoriationCode,
  InsurClmDiagnGuaranteeCode,
  InsurClmDeptOfHosp,
  InsurClaimDiagnSequence,
  InsurClmSecdryLcldSide,
  InsurClmIsUsdForGrpg,
  InsurClmAssignUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM icldiagndraft3 AS ICL_DiagnDraft
;

Learn More