A_InsurPlcyContractClause_2

DDL: A_INSURPLCYCONTRACTCLAUSE_2 Type: view_entity CONSUMPTION

Clause under Contract

A_InsurPlcyContractClause_2 is a Consumption CDS View that provides data about "Clause under Contract" in SAP S/4HANA. It reads from 1 data source (R_InsurPlcyContrClauseTP_2) and exposes 27 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyCoverageOptionID.

Data Sources (1)

SourceAliasJoin Type
R_InsurPlcyContrClauseTP_2 R_InsurPlcyContrClauseTP_2 projection

Annotations (15)

NameValueLevelField
EndUserText.label Clause under Contract view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name InsurPlcyContractClause_Type view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix CLS view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 1000 view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyUndrwrtgDcsnRiskID InsurPlcyUndrwrtgDcsnRiskID UndWritDecision
KEY InsurPlcySubCvrgID InsurPlcySubCvrgID Subcoverage Key
KEY InsurPlcyClauseID InsurPlcyClauseID Clause ID
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyClauseIsCanceled InsurPlcyClauseIsCanceled Rev. Flag
InsurPlcyIndivClauseAgrmtText InsurPlcyIndivClauseAgrmtText Ind. Cl. Agrmnt
InsurPlcyClauseDetailTextUUID InsurPlcyClauseDetailTextUUID Clause Long Text UUID
LongText LongText Text Name
TextObjectCategory TextObjectCategory Text object
TextObjectKey TextObjectKey Text Name
Language Language Report Text Language
InsurPlcyClauseType InsurPlcyClauseType Clause Type
InsurPlcyClauseStartDate InsurPlcyClauseStartDate Clause Start
InsurPlcyClauseEndDate InsurPlcyClauseEndDate Clause End
InsurPlcyClauseTemplate InsurPlcyClauseTemplate Clause
InsurPlcyClauseClauseNumber InsurPlcyClauseClauseNumber Clause Number
InsurancePolicyApplication InsurancePolicyApplication Application No.
InsurPlcyBusinessObject InsurPlcyBusinessObject
LastChangeDateTime LastChangeDateTime Timestamp

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_InsurPlcyContractClause_2.
-- 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_InsurPlcyContractClause_2 AS
SELECT
  InsurPlcyUUID,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyCoverageOptionID,
  InsurPlcyInsuredObjectID,
  InsurPlcyUndrwrtgDcsnRiskID,
  InsurPlcySubCvrgID,
  InsurPlcyClauseID,
  InsurPlcyJrnlNmbr,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyProductPackageID,
  InsurPlcyClauseIsCanceled,
  InsurPlcyIndivClauseAgrmtText,
  InsurPlcyClauseDetailTextUUID,
  LongText,
  TextObjectCategory,
  TextObjectKey,
  Language,
  InsurPlcyClauseType,
  InsurPlcyClauseStartDate,
  InsurPlcyClauseEndDate,
  InsurPlcyClauseTemplate,
  InsurPlcyClauseClauseNumber,
  InsurancePolicyApplication,
  InsurPlcyBusinessObject,
  LastChangeDateTime
FROM R_InsurPlcyContrClauseTP_2
;