A_InsuranceOpenApplication

DDL: A_INSURANCEOPENAPPLICATION Type: view_entity CONSUMPTION
58 Fields 1 Data Sources

Open Application

A_InsuranceOpenApplication is a Consumption CDS View that provides data about "Open Application" in SAP S/4HANA. It reads from 1 data source (R_InsurancePolicyTP_2) and exposes 58 fields with key field InsurPlcyUUID.

Data Sources (1)

SourceAliasJoin Type
R_InsurancePolicyTP_2 R_InsurancePolicyTP_2 projection

Annotations (15)

NameValueLevelField
EndUserText.label Open Application 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 InsuranceOpenApplication_Type view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix POL view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.quota.maximumFields 408 view
AbapCatalog.extensibility.quota.maximumBytes 8160 view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID Policy UUID
InsurancePolicy InsurancePolicy Policy Number
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
InsurPlcyAuthznSlsProductGroup InsurPlcyAuthznSlsProductGroup Auth. Sales Prod. Module Group
InsurPlcyIsReleasePolicy InsurPlcyIsReleasePolicy
InsurPlcyIsSavePolicy InsurPlcyIsSavePolicy
InsurPlcyIsCalctPolicy InsurPlcyIsCalctPolicy
InsurPlcyIsSmltePolicy InsurPlcyIsSmltePolicy
InsurPlcyIsCBCAmtSimulate InsurPlcyIsCBCAmtSimulate
InsurancePolicyLockKey InsurancePolicyLockKey
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
LongText LongText Text Name
TextObjectCategory TextObjectCategory Text object
TextObjectKey TextObjectKey Text Name
Language Language Report Text Language
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_InsuranceOpenApplication.
-- 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_InsuranceOpenApplication AS
SELECT
  InsurPlcyUUID,
  InsurancePolicy,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyJrnlNmbr,
  InsurPlcyAuthznSlsProductGroup,
  InsurPlcyIsReleasePolicy,
  InsurPlcyIsSavePolicy,
  InsurPlcyIsCalctPolicy,
  InsurPlcyIsSmltePolicy,
  InsurPlcyIsCBCAmtSimulate,
  InsurancePolicyLockKey,
  InsurPolicyStartDate,
  InsurancePolicyStartTime,
  InsurancePolicyStartTimeZone,
  InsurApplLifeCycSts,
  InsurPlcyDistrChnl,
  InsrrIDByInsrr,
  InsurPlcySalesProductTemplate,
  InsurPlcyAcqnType,
  InsurPlcyBusinessObject,
  PrdcssrInsurancePolicy,
  LastChangeDateTime,
  InsurPolicyCancellationStatus,
  InsurancePlcyPolicyIsCancelled,
  InsurancePolicyNumberOld,
  InsurPlcyExchRateType,
  InsurPlcyCrcy,
  InsurancePolicyNoteIdentifier,
  LongText,
  TextObjectCategory,
  TextObjectKey,
  Language,
  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_2
;

Learn More