A_InsurancePolicySearchPolicy

DDL: A_INSURANCEPOLICYSEARCHPOLICY Type: view_entity CONSUMPTION Package: VDM_PM_PLCY_SEARCH_API
14 Fields 1 Data Sources 1 OData Services

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 14 fields with key field InsurPlcyUUID. It is exposed through 1 OData service (API_INSURANCEPOLICYSEARCH). Part of development package VDM_PM_PLCY_SEARCH_API.

Data Sources (1)

SourceAliasJoin Type
R_InsurPlcySrchPolicyTP R_InsurPlcySrchPolicyTP projection

Annotations (9)

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
OData.entityType.name InsurancePolicySearch_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_INSURANCEPOLICYSEARCH API_INSURANCEPOLICYSEARCH V4 C2 C1

Fields (14)

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
InsurPlcyStartDateTime InsurPlcyStartDateTime Policy Start
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.
InsurPlcyAuthznSlsProductGroup InsurPlcyAuthznSlsProductGroup Auth. Sales Prod. Module Group
virtualInsurPlcyNmbrOfContractsnumc3

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,
  InsurPlcyStartDateTime,
  InsurApplLifeCycSts,
  InsurPlcyDistrChnl,
  InsrrIDByInsrr,
  InsurPlcySalesProductTemplate,
  InsuranceMasterPolicyNumber,
  InsurPlcyExtApplNmbr,
  InsurPlcyAuthznSlsProductGroup,
  virtual InsurPlcyNmbrOfContracts : numc3 AS virtualInsurPlcyNmbrOfContractsnumc3
FROM R_InsurPlcySrchPolicyTP
;

Learn More