P_InsurOpenApplClauseLatest

DDL: P_INSUROPENAPPLCLAUSELATEST Type: view_entity COMPOSITE
11 Fields 1 Data Sources

P_InsurOpenApplClauseLatest is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_InsurOpenApplClause) and exposes 11 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyJrnlNmbr, InsurPlcyInsurContr, InsurPlcyCoveragePackageID.

Data Sources (1)

SourceAliasJoin Type
P_InsurOpenApplClause Clause from

Annotations (4)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID P_InsurOpenApplClause InsurPlcyApplUUID Policy UUID
KEY InsuranceApplication P_InsurOpenApplClause InsuranceApplication
KEY InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr P_InsurOpenApplClause InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID P_InsurOpenApplClause InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID P_InsurOpenApplClause InsurPlcyCoverageID Coverage Key
KEY InsurPlcySubCvrgID P_InsurOpenApplClause InsurPlcySubCvrgID Subcoverage Key
KEY InsurPlcyInsuredObjectID P_InsurOpenApplClause InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyClauseID P_InsurOpenApplClause InsurPlcyClauseID Clause ID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsurOpenApplClause InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyUUID P_InsurOpenApplClause InsurPlcyUUID Policy UUID

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 P_InsurOpenApplClauseLatest.
-- 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 P_InsurOpenApplClauseLatest AS
SELECT
  Clause.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  Clause.InsuranceApplication AS InsuranceApplication,
  max(Clause.InsurPlcyJrnlNmbr) AS InsurPlcyJrnlNmbr,
  Clause.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Clause.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Clause.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Clause.InsurPlcySubCvrgID AS InsurPlcySubCvrgID,
  Clause.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  Clause.InsurPlcyClauseID AS InsurPlcyClauseID,
  Clause.InsurPlcyContrDataDetnJrnlNmbr AS InsurPlcyContrDataDetnJrnlNmbr,
  Clause.InsurPlcyUUID AS InsurPlcyUUID
FROM P_InsurOpenApplClause AS Clause
;

Learn More