R_InsurancePolicyAdjustmentD

DDL: R_INSURANCEPOLICYADJUSTMENTD Type: view_entity BASIC
91 Fields 1 Data Sources 1 Associations

Adjustment - Draft

R_InsurancePolicyAdjustmentD is a Basic CDS View that provides data about "Adjustment - Draft" in SAP S/4HANA. It reads from 1 data source (/pm0/abdrinfrd) and exposes 91 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/pm0/abdrinfrd /pm0/abdrinfrd from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurancePolicyAdjustmentD _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID and $projection.InsurPlcyAdjustmentID = _Extension.InsurPlcyAdjustmentID and $projection.DraftUUID = _Extension.DraftUUID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Adjustment - Draft view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix ADJ view
AbapCatalog.extensibility.allowNewDatasources false view

Fields (91)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID insurplcyuuid Policy UUID
KEY InsurPlcyApplUUID insurplcyappluuid 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 InsurPlcyAdjustmentID insurplcyadjustmentid Adjustment ID
KEY DraftUUID draftuuid UUID
InsurPlcyOrderNumber insurplcyordernumber Sequence Number
InsurPlcyBusProcType insurplcybusproctype Bus. Process
InsurPlcyBusProcessNumerator insurplcybusprocessnumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr insurplcyjrnlendnmbr Term. Jour. No.
InsurPlcyJrnlNmbr insurplcyjrnlnmbr Journal Number
InsurPlcyProductPackageID insurplcyproductpackageid Prod. Pckg. Key
InsurPlcyAdjmtIsCancelled insurplcyadjmtiscancelled Rev. Flag
InsurPlcyAdjmtStartDate insurplcyadjmtstartdate Adjustm.Start
InsurPlcyAdjmtEndDate insurplcyadjmtenddate Adjustment End Date
InsurPlcyAdjmtMaxAmount insurplcyadjmtmaxamount Max. Adj. Abs.
InsurPlcyAdjmtMinAmount insurplcyadjmtminamount Min. Adj. Abs.
InsurPlcyAdjmtIndexPercent insurplcyadjmtindexpercent Index Value (%)
InsurPlcyAdjmtMaxPctgRate insurplcyadjmtmaxpctgrate Max. Adjust. %
InsurPlcyAdjmtMinimumPercent insurplcyadjmtminimumpercent Min. Adjust. &
InsurPlcyAdjmtAmount insurplcyadjmtamount Adj. Amount
InsurPlcyAdjmtIncrAmtPercent insurplcyadjmtincramtpercent Adj. Rate in %
InsurPlcyAdjmtNrOfSqntlRjcn insurplcyadjmtnrofsqntlrjcn Adj. Inc. Ref.
InsurPlcyAdjmtNrOfTmeOpposed insurplcyadjmtnroftmeopposed No. Ad Inc. Ob.
InsurPlcyAdjmtLastNonRjcnDte insurplcyadjmtlastnonrjcndte Non-R. Adj.Inc.
InsurPlcyAdjmtIndexShare insurplcyadjmtindexshare IndxAdjShare %
InsurPlcyAdjmtFrequencyYear insurplcyadjmtfrequencyyear Adjust.Freq.(Y)
InsurPlcyAdjmtVariantType insurplcyadjmtvarianttype AdjustmVar. ID
InsurPlcyAdjustmentType insurplcyadjustmenttype Adjustment Type
InsurPlcyAdjmtPctgShrOfIndex insurplcyadjmtpctgshrofindex Share Index %
InsurPlcyAdjmtIncreaseBasis insurplcyadjmtincreasebasis Adj.Incr.Basis
InsurPlcyAdjmtIndexType insurplcyadjmtindextype Index Type
InsurPlcyAdjmtIndexGroup insurplcyadjmtindexgroup Index Group
InsurPlcyAdjmtPrevYrIndexValue insurplcyadjmtprevyrindexvalue PreviousYr Indx
InsurPlcyAdjmtStrtgIndexValue insurplcyadjmtstrtgindexvalue Starting Index
InsurPlcyAdjmtLastExectdDte insurplcyadjmtlastexectddte Date Ind. Comp.
InsurPlcyAdjmtStartAgeValue insurplcyadjmtstartagevalue StartingAge
InsurPlcyAdjmtExprtnAgeValue insurplcyadjmtexprtnagevalue Final Age
InsurPlcyAdjmtSuspnVariant insurplcyadjmtsuspnvariant Suspension Var.
InsurPlcyAdjmtThresholdValue insurplcyadjmtthresholdvalue ThreshValue (%)
InsurPlcyAdjmtNextCoverageDate insurplcyadjmtnextcoveragedate Next Adj. Cov.
InsurPlcyAdjmtIsPerformed insurplcyadjmtisperformed Perform Adj.
InsurPlcyAdjmtLastIdxStartDate insurplcyadjmtlastidxstartdate Last Index Levl
InsurPlcyAdjmtIsMnlIndThldVal insurplcyadjmtismnlindthldval Threshold Man.
InsurPlcyAdjmtCreateIndexType insurplcyadjmtcreateindextype Indx Adj. Type
InsurPlcyAdjmtSumInsrdContrAmt insurplcyadjmtsuminsrdcontramt SI Contr.Start
InsurPlcyAdjmtLastIndexValue insurplcyadjmtlastindexvalue Last IndexValue
InsurPlcyAdjmtIsModified insurplcyadjmtismodified Adjustment Ind.
InsurPlcyAdjmtTemplate insurplcyadjmttemplate Adjustment Cat.
InsurPlcyAdjmtIsSuspended insurplcyadjmtissuspended Suspend Adj.
InsurPlcyAdjmtStatus insurplcyadjmtstatus Adjustment Status
InsurPlcyAdjmtInitPremAmount insurplcyadjmtinitpremamount Initial Premium
InsurPlcyAdjmtCurrency insurplcyadjmtcurrency Currency
InsurPlcyAdjmtIdxCategory insurplcyadjmtidxcategory Index Type Cat.
InsurPlcyAdjmtCurIdxPos insurplcyadjmtcuridxpos Curr.Index Lvl
InsurPlcyAdjmtCurIdxAmount insurplcyadjmtcuridxamount Index Value
InsurPlcyAdjmtCurIncrPercent insurplcyadjmtcurincrpercent Increase Value
InsurPlcyAdjmtIdxValdStrtDte insurplcyadjmtidxvaldstrtdte Index Lvl Start
InsurPlcyAdjmtIdxValidEndDate insurplcyadjmtidxvalidenddate Index Level End
InsurPlcyAdjmtFirstIdxPosID insurplcyadjmtfirstidxposid StartIndexLevel
InsurPlcyAdjmtFirstIncrPercent insurplcyadjmtfirstincrpercent StartIncrVal(%)
InsurPlcyAdjmtFirstIndexAmount insurplcyadjmtfirstindexamount StrtIndVal(Abs)
InsurPlcyAdjmtFirstIdxStrtDte insurplcyadjmtfirstidxstrtdte StrtIndxLvl Str
InsurPlcyAdjmtFirstIdxEndDate insurplcyadjmtfirstidxenddate St.IndLevel End
InsurPlcyAdjmtLastIdxPosID insurplcyadjmtlastidxposid Last Index Lvl
InsurPlcyAdjmtLastIndexAmount insurplcyadjmtlastindexamount LastIndex (Abs)
InsurPlcyAdjmtLastIncrPercent insurplcyadjmtlastincrpercent LastIncrease(%)
InsurPlcyAdjmtLastValdStrtDte insurplcyadjmtlastvaldstrtdte LstIndxLvl Strt
InsurPlcyAdjmtLastValdEndDte insurplcyadjmtlastvaldenddte LstIndxLvl End
InsurPlcyAdjmtIsProgressive insurplcyadjmtisprogressive Prog.Adjustment
InsurPlcyAdjmtSuspendedReason insurplcyadjmtsuspendedreason Adj.Susp.Reason
InsurPlcyAdjmtSuspendedStrtDte insurplcyadjmtsuspendedstrtdte Adj.Lock Start
InsurPlcyAdjmtSuspendedEndDte insurplcyadjmtsuspendedenddte Adjstm.Lock End
InsurPlcyAdjmtNrOfSuspension insurplcyadjmtnrofsuspension Adj.Susp.Count
InsurPlcyAdjmtLastDate insurplcyadjmtlastdate Last Adjustment
InsurPlcyAdjmtIsTblTransferred insurplcyadjmtistbltransferred Table Transfer
InsurPlcyAdjmtIsIdxCompUsed insurplcyadjmtisidxcompused IdxComp. FS-PM
InsurPlcyAdjmtIdxIsChanged insurplcyadjmtidxischanged IndxLvl Changed
InsurPlcyAdjmtMaximumAge insurplcyadjmtmaximumage Max.Adjust.Age
InsurPlcyAdjmtMaxPeriodValue insurplcyadjmtmaxperiodvalue MaxAdjustmentPeriod
InsurPlcyAdjmtNextDate insurplcyadjmtnextdate Next Adjustment Date
LastChangeDateTime lastchangedatetime Timestamp
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_InsurancePolicyAdjustmentD.
-- 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 R_InsurancePolicyAdjustmentD AS
SELECT
  InsurPlcyUUID,
  InsurPlcyApplUUID,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyCoverageOptionID,
  InsurPlcyInsuredObjectID,
  InsurPlcyAdjustmentID,
  DraftUUID,
  InsurPlcyOrderNumber,
  InsurPlcyBusProcType,
  InsurPlcyBusProcessNumerator,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyJrnlNmbr,
  InsurPlcyProductPackageID,
  InsurPlcyAdjmtIsCancelled,
  InsurPlcyAdjmtStartDate,
  InsurPlcyAdjmtEndDate,
  InsurPlcyAdjmtMaxAmount,
  InsurPlcyAdjmtMinAmount,
  InsurPlcyAdjmtIndexPercent,
  InsurPlcyAdjmtMaxPctgRate,
  InsurPlcyAdjmtMinimumPercent,
  InsurPlcyAdjmtAmount,
  InsurPlcyAdjmtIncrAmtPercent,
  InsurPlcyAdjmtNrOfSqntlRjcn,
  InsurPlcyAdjmtNrOfTmeOpposed,
  InsurPlcyAdjmtLastNonRjcnDte,
  InsurPlcyAdjmtIndexShare,
  InsurPlcyAdjmtFrequencyYear,
  InsurPlcyAdjmtVariantType,
  InsurPlcyAdjustmentType,
  InsurPlcyAdjmtPctgShrOfIndex,
  InsurPlcyAdjmtIncreaseBasis,
  InsurPlcyAdjmtIndexType,
  InsurPlcyAdjmtIndexGroup,
  InsurPlcyAdjmtPrevYrIndexValue,
  InsurPlcyAdjmtStrtgIndexValue,
  InsurPlcyAdjmtLastExectdDte,
  InsurPlcyAdjmtStartAgeValue,
  InsurPlcyAdjmtExprtnAgeValue,
  InsurPlcyAdjmtSuspnVariant,
  InsurPlcyAdjmtThresholdValue,
  InsurPlcyAdjmtNextCoverageDate,
  InsurPlcyAdjmtIsPerformed,
  InsurPlcyAdjmtLastIdxStartDate,
  InsurPlcyAdjmtIsMnlIndThldVal,
  InsurPlcyAdjmtCreateIndexType,
  InsurPlcyAdjmtSumInsrdContrAmt,
  InsurPlcyAdjmtLastIndexValue,
  InsurPlcyAdjmtIsModified,
  InsurPlcyAdjmtTemplate,
  InsurPlcyAdjmtIsSuspended,
  InsurPlcyAdjmtStatus,
  InsurPlcyAdjmtInitPremAmount,
  InsurPlcyAdjmtCurrency,
  InsurPlcyAdjmtIdxCategory,
  InsurPlcyAdjmtCurIdxPos,
  InsurPlcyAdjmtCurIdxAmount,
  InsurPlcyAdjmtCurIncrPercent,
  InsurPlcyAdjmtIdxValdStrtDte,
  InsurPlcyAdjmtIdxValidEndDate,
  InsurPlcyAdjmtFirstIdxPosID,
  InsurPlcyAdjmtFirstIncrPercent,
  InsurPlcyAdjmtFirstIndexAmount,
  InsurPlcyAdjmtFirstIdxStrtDte,
  InsurPlcyAdjmtFirstIdxEndDate,
  InsurPlcyAdjmtLastIdxPosID,
  InsurPlcyAdjmtLastIndexAmount,
  InsurPlcyAdjmtLastIncrPercent,
  InsurPlcyAdjmtLastValdStrtDte,
  InsurPlcyAdjmtLastValdEndDte,
  InsurPlcyAdjmtIsProgressive,
  InsurPlcyAdjmtSuspendedReason,
  InsurPlcyAdjmtSuspendedStrtDte,
  InsurPlcyAdjmtSuspendedEndDte,
  InsurPlcyAdjmtNrOfSuspension,
  InsurPlcyAdjmtLastDate,
  InsurPlcyAdjmtIsTblTransferred,
  InsurPlcyAdjmtIsIdxCompUsed,
  InsurPlcyAdjmtIdxIsChanged,
  InsurPlcyAdjmtMaximumAge,
  InsurPlcyAdjmtMaxPeriodValue,
  InsurPlcyAdjmtNextDate,
  LastChangeDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM /pm0/abdrinfrd
LEFT OUTER JOIN E_InsurancePolicyAdjustmentD AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND InsurPlcyAdjustmentID = _Extension.InsurPlcyAdjustmentID AND DraftUUID = _Extension.DraftUUID  -- association [1..1]
;

Learn More