A_InsurancePolicySearchPolicy

DDL: A_INSURANCEPOLICYSEARCHPOLICY Type: view_entity CONSUMPTION
19 Fields 1 Data Sources

Insurance Policy Search

A_InsurancePolicySearchPolicy is a Consumption CDS View that provides data about "Insurance Policy Search" in SAP S/4HANA. It reads from 1 data source (R_InsurPlcySrchPolicyTP) and exposes 19 fields with key field InsurPlcyUUID.

Data Sources (1)

SourceAliasJoin Type
R_InsurPlcySrchPolicyTP R_InsurPlcySrchPolicyTP projection

Annotations (15)

NameValueLevelField
EndUserText.label Insurance Policy Search 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
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix POL view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.quota.maximumFields 608 view
AbapCatalog.extensibility.quota.maximumBytes 28160 view
OData.entityType.name InsurancePolicySearchPolicy_Type view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID Policy UUID
InsurPlcyApplUUID InsurPlcyApplUUID Policy UUID
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurancePolicy InsurancePolicy Policy Number
InsurPolicyStartDate InsurPolicyStartDate Policy Start
InsurancePolicyStartTime InsurancePolicyStartTime Time
InsurancePolicyStartTimeZone InsurancePolicyStartTimeZone Time Zone
InsurApplLifeCycSts InsurApplLifeCycSts Policy Status
InsurPlcyDistrChnl InsurPlcyDistrChnl Distrib.Channel
InsrrIDByInsrr InsrrIDByInsrr Company ID
InsurPlcySalesProductTemplate InsurPlcySalesProductTemplate SlsProdTempl.ID
InsuranceMasterPolicyNumber InsuranceMasterPolicyNumber Master Pol. No.
InsurPlcyExtApplNmbr InsurPlcyExtApplNmbr Ext. Appl.No.
InsurPlcyBusProcType InsurPlcyBusProcType Bus. Process
InsuranceApplicationStatus InsuranceApplicationStatus
InsurPlcyAuthznSlsProductGroup InsurPlcyAuthznSlsProductGroup Auth. Sales Prod. Module Group
virtualInsurPlcyNmbrOfContractsnumc3
virtualInsurPlcyHasResumeApplboolean

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_InsurancePolicySearchPolicy.
-- 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_InsurancePolicySearchPolicy AS
SELECT
  InsurPlcyUUID,
  InsurPlcyApplUUID,
  InsurPlcyJrnlNmbr,
  InsurPlcyJrnlEndNmbr,
  InsurancePolicy,
  InsurPolicyStartDate,
  InsurancePolicyStartTime,
  InsurancePolicyStartTimeZone,
  InsurApplLifeCycSts,
  InsurPlcyDistrChnl,
  InsrrIDByInsrr,
  InsurPlcySalesProductTemplate,
  InsuranceMasterPolicyNumber,
  InsurPlcyExtApplNmbr,
  InsurPlcyBusProcType,
  InsuranceApplicationStatus,
  InsurPlcyAuthznSlsProductGroup,
  virtual InsurPlcyNmbrOfContracts : numc3 AS virtualInsurPlcyNmbrOfContractsnumc3,
  virtual InsurPlcyHasResumeAppl : boolean AS virtualInsurPlcyHasResumeApplboolean
FROM R_InsurPlcySrchPolicyTP
;

Learn More