I_InsurPlcyBasic
Insurance Policy
I_InsurPlcyBasic is a Basic CDS View that provides data about "Insurance Policy" in SAP S/4HANA. It reads from 1 data source (/pm0/abdapolicy) and exposes 52 fields with key fields InsurPlcyUUID, InsurPlcyJrnlNmbr, InsurPlcyJrnlEndNmbr.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| /pm0/abdapolicy | Policy | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Insurance Policy | view | |
| VDM.viewType | #BASIC | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| ObjectModel.representativeKey | InsurPlcyUUID | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Analytics.technicalName | IPPlcyBsc | view | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | I_InsurPlcyBasic_2 | view |
Fields (52)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InsurPlcyUUID | |||
| KEY | InsurPlcyJrnlNmbr | |||
| KEY | InsurPlcyJrnlEndNmbr | /pm0/abdapolicy | journalendno_id | Term. Jour. No. |
| InsurancePolicy | ||||
| InsurPlcyAuthznSlsProductGroup | ||||
| InsurPolicyStartDate | /pm0/abdapolicy | polbeg_dt | Policy Start | |
| InsurancePolicyStartTime | /pm0/abdapolicy | starttime_tm | Time | |
| InsurancePolicyStartTimeZone | /pm0/abdapolicy | starttimezone_tt | Time Zone | |
| InsurApplLifeCycSts | /pm0/abdapolicy | bostat_cd | Policy Status | |
| InsurPlcyDistrChnl | /pm0/abdapolicy | salech_cd | Distrib.Channel | |
| InsrrIDByInsrr | /pm0/abdapolicy | companykey_id | Company ID | |
| InsurPlcySalesProductTemplate | /pm0/abdapolicy | pm_id | Withh.Tax PM ID | |
| InsurPlcyAcqnType | /pm0/abdapolicy | acquistp_cd | Acq. Type | |
| InsurPlcyBusinessObject | /pm0/abdapolicy | bo_cd | Process.Status | |
| PrdcssrInsurancePolicy | /pm0/abdapolicy | policynrprdcssr_tt | Previous Policy | |
| LastChangeDateTime | /pm0/abdapolicy | change_ts | Time Stamp | |
| InsurPolicyCancellationStatus | /pm0/abdapolicy | noactive_ctrcts_fg | Policy Cancellation | |
| InsurancePlcyPolicyIsCancelled | /pm0/abdapolicy | cancel_fg | Reversal | |
| InsurancePolicyNumberOld | /pm0/abdapolicy | policynrold_tt | Old Policy No. | |
| InsurPlcyExchRateType | /pm0/abdapolicy | exchangerate_tp | Exch. rate type | |
| InsurPlcyCrcy | /pm0/abdapolicy | currency_id | Indx-Based Curr | |
| InsurancePolicyNoteIdentifier | ||||
| LongText | _LongText | LongText | Text Name | |
| TextObjectCategory | _LongText | TextObjectCategory | Text object | |
| TextObjectKey | _LongText | TextObjectKey | Text Name | |
| Language | _LongText | Language | Report Text Language | |
| InsurPlcyExtApplNmbr | /pm0/abdapolicy | pagno_id | Ext. Appl.No. | |
| InsurPlcyCommissionPostingCode | /pm0/abdapolicy | commisposttx_cd | Posting Text | |
| InsurancePolicyDuplicateID | /pm0/abdapolicy | dupol_id | Duplic. Policy | |
| InsurancePolicyGenerationDate | /pm0/abdapolicy | generation_dt | Generation Date | |
| InsurPlcySrceOfGnrtnDteCode | /pm0/abdapolicy | sourgenerdate_cd | GenDetDate Srce | |
| InsurancePolicyKey | /pm0/abdapolicy | polpolicy_id | Policy Key | |
| InsurPlcySrceDocStsDateTime | /pm0/abdapolicy | origstate_ts | SD Status | |
| InsurPlcyChangeOptionNumber | /pm0/abdapolicy | amnnr_tt | AmndmntOptionNo | |
| InsurPlcyChgOptnApplID | /pm0/abdapolicy | amdaplpol_id | Application ID | |
| InsurPlcyChangeOptionText | /pm0/abdapolicy | amendmemo_tt | Note | |
| InsurancePolicyIsChangeOption | /pm0/abdapolicy | amdoffer_fg | Chg.Opt. Yes/No | |
| InsurPlcyHasPndgCommsnCase | /pm0/abdapolicy | commispending_fg | Pend.Comm.Case | |
| InsurPlcyChangeOptionCategory | /pm0/abdapolicy | amdoffrreason_cd | Category | |
| InsurMstrPlcyJrnlNmbr | /pm0/abdapolicy | mpoljourno_id | Jrnl No. MP | |
| InsurMstrPlcySmplApplID | /pm0/abdapolicy | mpattern_id | Sample Appl. MP | |
| InsurPlcyChgOptnRsn | /pm0/abdapolicy | predef_text_cd | Reason | |
| InsuranceMasterPolicyNumber | /pm0/abdapolicy | mpolicy_nr | Master Pol. No. | |
| InsurPlcyIsCoinsurPrtcpnt | /pm0/abdapolicy | participation_fg | Participation | |
| InsurPlcyGnrtnDetnDte | /pm0/abdapolicy | generatio_det_dt | GenDetermDate | |
| InsurPlcyHasPolicyProcessing | /pm0/abdapolicy | polprocess_fg | Pol. Processing | |
| InsurancePolicyShiftType | /pm0/abdapolicy | shiftmode_cd | Type of Shift | |
| InsurancePolicySubjectCode | /pm0/abdapolicy | subjdplpol_cd | Subject | |
| InsurancePolicyHasReassessment | /pm0/abdapolicy | reassessment_fg | For Reassessmnt | |
| InsurPlcyReassessmentNoteID | /pm0/abdapolicy | reassessmemo_id | ChangeRsnTxt ID | |
| InsurPlcyPremWvrAnnulmentRsn | /pm0/abdapolicy | prmxmptendspe_cd | Annulm. Reason | |
| InsurPlcyContractualDpndcySts | /pm0/abdapolicy | dependstatus_id | 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 I_InsurPlcyBasic.
-- 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 I_InsurPlcyBasic AS
SELECT
cast( Policy.secpol_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
cast( Policy.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyJrnlNmbr,
Policy.journalendno_id AS InsurPlcyJrnlEndNmbr,
cast( Policy.policynr_tt as /pm0/vdm_policynr_tt preserving type ) AS InsurancePolicy,
cast( AuthSlsProductGroup.InsurPlcySalesProductGroup as /pm0/vdm_auth_slsproduct_group preserving type ) AS InsurPlcyAuthznSlsProductGroup,
Policy.polbeg_dt AS InsurPolicyStartDate,
Policy.starttime_tm AS InsurancePolicyStartTime,
Policy.starttimezone_tt AS InsurancePolicyStartTimeZone,
Policy.bostat_cd AS InsurApplLifeCycSts,
Policy.salech_cd AS InsurPlcyDistrChnl,
Policy.companykey_id AS InsrrIDByInsrr,
Policy.pm_id AS InsurPlcySalesProductTemplate,
Policy.acquistp_cd AS InsurPlcyAcqnType,
Policy.bo_cd AS InsurPlcyBusinessObject,
Policy.policynrprdcssr_tt AS PrdcssrInsurancePolicy,
Policy.change_ts AS LastChangeDateTime,
Policy.noactive_ctrcts_fg AS InsurPolicyCancellationStatus,
Policy.cancel_fg AS InsurancePlcyPolicyIsCancelled,
Policy.policynrold_tt AS InsurancePolicyNumberOld,
Policy.exchangerate_tp AS InsurPlcyExchRateType,
Policy.currency_id AS InsurPlcyCrcy,
cast( Policy.comment_id as /pm0/vdm_note_longtext_uuid preserving type ) AS InsurancePolicyNoteIdentifier,
_LongText.LongText AS LongText,
_LongText.TextObjectCategory AS TextObjectCategory,
_LongText.TextObjectKey AS TextObjectKey,
_LongText.Language AS Language,
Policy.pagno_id AS InsurPlcyExtApplNmbr,
Policy.commisposttx_cd AS InsurPlcyCommissionPostingCode,
Policy.dupol_id AS InsurancePolicyDuplicateID,
Policy.generation_dt AS InsurancePolicyGenerationDate,
Policy.sourgenerdate_cd AS InsurPlcySrceOfGnrtnDteCode,
Policy.polpolicy_id AS InsurancePolicyKey,
Policy.origstate_ts AS InsurPlcySrceDocStsDateTime,
Policy.amnnr_tt AS InsurPlcyChangeOptionNumber,
Policy.amdaplpol_id AS InsurPlcyChgOptnApplID,
Policy.amendmemo_tt AS InsurPlcyChangeOptionText,
Policy.amdoffer_fg AS InsurancePolicyIsChangeOption,
Policy.commispending_fg AS InsurPlcyHasPndgCommsnCase,
Policy.amdoffrreason_cd AS InsurPlcyChangeOptionCategory,
Policy.mpoljourno_id AS InsurMstrPlcyJrnlNmbr,
Policy.mpattern_id AS InsurMstrPlcySmplApplID,
Policy.predef_text_cd AS InsurPlcyChgOptnRsn,
Policy.mpolicy_nr AS InsuranceMasterPolicyNumber,
Policy.participation_fg AS InsurPlcyIsCoinsurPrtcpnt,
Policy.generatio_det_dt AS InsurPlcyGnrtnDetnDte,
Policy.polprocess_fg AS InsurPlcyHasPolicyProcessing,
Policy.shiftmode_cd AS InsurancePolicyShiftType,
Policy.subjdplpol_cd AS InsurancePolicySubjectCode,
Policy.reassessment_fg AS InsurancePolicyHasReassessment,
Policy.reassessmemo_id AS InsurPlcyReassessmentNoteID,
Policy.prmxmptendspe_cd AS InsurPlcyPremWvrAnnulmentRsn,
Policy.dependstatus_id AS InsurPlcyContractualDpndcySts
FROM /pm0/abdapolicy AS Policy
;Learn More
- S/4HANA CDS View Deprecation: What You Need to Know
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA