I_InsurClmPlcySnpshtInsrdBuild

DDL: I_INSURCLMPLCYSNPSHTINSRDBUILD SQL: INSRDEBUILD Type: view BASIC
12 Fields 1 Data Sources 1 Associations

Versichertes Gebäude des Vertragsspiegels

I_InsurClmPlcySnpshtInsrdBuild is a Basic CDS View that provides data about "Versichertes Gebäude des Vertragsspiegels" in SAP S/4HANA. It reads from 1 data source (iclpolore) and exposes 12 fields with key fields InsuranceContract, InsurClmContractVersion, InsuranceClaimInsuredBuilding. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
iclpolore iclpolore from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InsuranceClaim _InsurClm $projection.InsuranceContract = _InsurClm.InsuranceClaim

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName INSRDEBUILD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Versichertes Gebäude des Vertragsspiegels view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InsuranceContract Policy Snapshot
KEY InsurClmContractVersion polvnr Contrct Counter
KEY InsuranceClaimInsuredBuilding insuredobj Vehicle
InsurClmBuildingTypeDesc restaten Description
InsurClmPrimaryMaterial rematerial Prim. material
InsurClmBuildingAddress address Subscription address
InsurClmPrptyConstructionYear constyear Constructn Year
InsurClmInsrdObjAreaQuantity rearea Area
InsurClmUnitAreaInsrdObj rearea_unit Unit of Measure
ChangedOnDateTime Created
LastChangedByUser changedby User Name
_InsurClm _InsurClm

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 I_InsurClmPlcySnpshtInsrdBuild.
-- 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: INSRDEBUILD

CREATE VIEW I_InsurClmPlcySnpshtInsrdBuild AS
SELECT
  cast(claim as icl_policy preserving type ) AS InsuranceContract,
  polvnr AS InsurClmContractVersion,
  insuredobj AS InsuranceClaimInsuredBuilding,
  restaten AS InsurClmBuildingTypeDesc,
  rematerial AS InsurClmPrimaryMaterial,
  address AS InsurClmBuildingAddress,
  constyear AS InsurClmPrptyConstructionYear,
  rearea AS InsurClmInsrdObjAreaQuantity,
  rearea_unit AS InsurClmUnitAreaInsrdObj,
  cast( changetime as icl_achangetime_fiori preserving type ) AS ChangedOnDateTime,
  changedby AS LastChangedByUser
FROM iclpolore
LEFT OUTER JOIN I_InsuranceClaim AS _InsurClm ON InsuranceContract = _InsurClm.InsuranceClaim  -- association [1..1]
;

Learn More