A_InsurancePolicy_3

DDL: A_INSURANCEPOLICY_3 Type: view_entity CONSUMPTION
67 Fields 1 Data Sources

Policy

A_InsurancePolicy_3 is a Consumption CDS View that provides data about "Policy" in SAP S/4HANA. It reads from 1 data source (R_InsurancePolicyTP_3) and exposes 67 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID.

Data Sources (1)

SourceAliasJoin Type
R_InsurancePolicyTP_3 R_InsurancePolicyTP_3 projection

Annotations (11)

NameValueLevelField
EndUserText.label Policy view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
OData.entityType.name InsurancePolicy_Type view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix POL view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID InsurPlcyApplUUID Policy UUID
InsurPlcyUUIDForEdit InsurPlcyUUIDForEdit Policy UUID
InsurPlcyApplUUIDForEdit InsurPlcyApplUUIDForEdit Policy UUID
InsurPlcyInsurContr InsurPlcyInsurContr Contract Key
InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageID InsurPlcyCoverageID Coverage Key
InsurPlcyCoverageOptionID InsurPlcyCoverageOptionID Cov. Option Key
InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID Ins. Obj. No.
InsurPlcyUndrwrtgDcsnRiskID InsurPlcyUndrwrtgDcsnRiskID UndWritDecision
InsurPlcySubCvrgID InsurPlcySubCvrgID Subcoverage Key
InsurPlcyOrderNumber InsurPlcyOrderNumber Sequence Number
InsurancePolicy InsurancePolicy Policy Number
InsurPlcyBusProcType InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyBusProcEffectiveDate InsurPlcyBusProcEffectiveDate Effective Date
InsurApplSgntrDte InsurApplSgntrDte ApplicDate
InsurApplRcptDte InsurApplRcptDte App. Rec. Date
InsurPlcyIsRvslNotification InsurPlcyIsRvslNotification Reversal Notif.
InsurPlcyContrCanclnRsn InsurPlcyContrCanclnRsn Reversal Reason
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
InsurPlcyAuthznSlsProductGroup InsurPlcyAuthznSlsProductGroup Auth. Sales Prod. Module Group
InsurPlcyStartDateTime InsurPlcyStartDateTime Policy Start
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
InsurPlcyAcqnType InsurPlcyAcqnType Acq. Type
InsurPlcyBusinessObject InsurPlcyBusinessObject
PrdcssrInsurancePolicy PrdcssrInsurancePolicy Previous Policy
LastChangeDateTime LastChangeDateTime Timestamp
InsurPolicyCancellationStatus InsurPolicyCancellationStatus Policy Cancellation
InsurancePlcyPolicyIsCancelled InsurancePlcyPolicyIsCancelled Rev. Flag
InsurancePolicyNumberOld InsurancePolicyNumberOld Old Policy No.
InsurPlcyExchRateType InsurPlcyExchRateType Exch. rate type
InsurPlcyCrcy InsurPlcyCrcy Currency
InsurancePolicyNoteIdentifier InsurancePolicyNoteIdentifier Note Long Text
InsurPlcyExtApplNmbr InsurPlcyExtApplNmbr Ext. Appl.No.
InsurPlcyCommissionPostingCode InsurPlcyCommissionPostingCode Posting Text
InsurancePolicyDuplicateID InsurancePolicyDuplicateID Duplic. Policy
InsurancePolicyGenerationDate InsurancePolicyGenerationDate Generation Date
InsurPlcySrceOfGnrtnDteCode InsurPlcySrceOfGnrtnDteCode GenDetDate Srce
InsurancePolicyKey InsurancePolicyKey Policy Key
InsurPlcySrceDocStsDateTime InsurPlcySrceDocStsDateTime SD Status
InsurPlcyChangeOptionNumber InsurPlcyChangeOptionNumber AmndmntOptionNo
InsurPlcyChgOptnApplID InsurPlcyChgOptnApplID Application ID
InsurPlcyChangeOptionText InsurPlcyChangeOptionText Note
InsurancePolicyIsChangeOption InsurancePolicyIsChangeOption Chg.Opt. Yes/No
InsurPlcyHasPndgCommsnCase InsurPlcyHasPndgCommsnCase Pend.Comm.Case
InsurPlcyChangeOptionCategory InsurPlcyChangeOptionCategory Category
InsurMstrPlcyJrnlNmbr InsurMstrPlcyJrnlNmbr Jrnl No. MP
InsurMstrPlcySmplApplID InsurMstrPlcySmplApplID Sample Appl. MP
InsurPlcyChgOptnRsn InsurPlcyChgOptnRsn Reason
InsuranceMasterPolicyNumber InsuranceMasterPolicyNumber Master Pol. No.
InsurPlcyIsCoinsurPrtcpnt InsurPlcyIsCoinsurPrtcpnt Participation
InsurPlcyGnrtnDetnDte InsurPlcyGnrtnDetnDte GenDetermDate
InsurPlcyHasPolicyProcessing InsurPlcyHasPolicyProcessing Pol. Processing
InsurancePolicyShiftType InsurancePolicyShiftType Type of Shift
InsurancePolicySubjectCode InsurancePolicySubjectCode Subject
InsurancePolicyHasReassessment InsurancePolicyHasReassessment For Reassessmnt
InsurPlcyReassessmentNoteID InsurPlcyReassessmentNoteID ChangeRsnTxt ID
InsurPlcyPremWvrAnnulmentRsn InsurPlcyPremWvrAnnulmentRsn Annulm. Reason
InsurPlcyContractualDpndcySts InsurPlcyContractualDpndcySts Depend.Status

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_InsurancePolicy_3.
-- 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_InsurancePolicy_3 AS
SELECT
  InsurPlcyUUID,
  InsurPlcyApplUUID,
  InsurPlcyUUIDForEdit,
  InsurPlcyApplUUIDForEdit,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyCoverageOptionID,
  InsurPlcyInsuredObjectID,
  InsurPlcyUndrwrtgDcsnRiskID,
  InsurPlcySubCvrgID,
  InsurPlcyOrderNumber,
  InsurancePolicy,
  InsurPlcyBusProcType,
  InsurPlcyBusProcessNumerator,
  InsurPlcyBusProcEffectiveDate,
  InsurApplSgntrDte,
  InsurApplRcptDte,
  InsurPlcyIsRvslNotification,
  InsurPlcyContrCanclnRsn,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyJrnlNmbr,
  InsurPlcyAuthznSlsProductGroup,
  InsurPlcyStartDateTime,
  InsurPolicyStartDate,
  InsurancePolicyStartTime,
  InsurancePolicyStartTimeZone,
  InsurApplLifeCycSts,
  InsurPlcyDistrChnl,
  InsrrIDByInsrr,
  InsurPlcySalesProductTemplate,
  InsurPlcyAcqnType,
  InsurPlcyBusinessObject,
  PrdcssrInsurancePolicy,
  LastChangeDateTime,
  InsurPolicyCancellationStatus,
  InsurancePlcyPolicyIsCancelled,
  InsurancePolicyNumberOld,
  InsurPlcyExchRateType,
  InsurPlcyCrcy,
  InsurancePolicyNoteIdentifier,
  InsurPlcyExtApplNmbr,
  InsurPlcyCommissionPostingCode,
  InsurancePolicyDuplicateID,
  InsurancePolicyGenerationDate,
  InsurPlcySrceOfGnrtnDteCode,
  InsurancePolicyKey,
  InsurPlcySrceDocStsDateTime,
  InsurPlcyChangeOptionNumber,
  InsurPlcyChgOptnApplID,
  InsurPlcyChangeOptionText,
  InsurancePolicyIsChangeOption,
  InsurPlcyHasPndgCommsnCase,
  InsurPlcyChangeOptionCategory,
  InsurMstrPlcyJrnlNmbr,
  InsurMstrPlcySmplApplID,
  InsurPlcyChgOptnRsn,
  InsuranceMasterPolicyNumber,
  InsurPlcyIsCoinsurPrtcpnt,
  InsurPlcyGnrtnDetnDte,
  InsurPlcyHasPolicyProcessing,
  InsurancePolicyShiftType,
  InsurancePolicySubjectCode,
  InsurancePolicyHasReassessment,
  InsurPlcyReassessmentNoteID,
  InsurPlcyPremWvrAnnulmentRsn,
  InsurPlcyContractualDpndcySts
FROM R_InsurancePolicyTP_3
;

Learn More