R_InsurClmSrvcsReserveTP

DDL: R_INSURCLMSRVCSRESERVETP Type: view_entity TRANSACTIONAL
28 Fields 1 Data Sources

Claim Services Reserves TP

R_InsurClmSrvcsReserveTP is a Transactional CDS View that provides data about "Claim Services Reserves TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmReserve) and exposes 28 fields with key fields InsuranceClaim, InsurClmSubclm, InsurClmRsrvType, InsurClmReserveCurrency.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmReserve _Reserve from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Claim Services Reserves TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name InsuranceClaimsServices view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmReserve InsuranceClaim Claim Number
KEY InsurClmSubclm I_InsurClmReserve InsurClmSubclm Subclaim
KEY InsurClmRsrvType I_InsurClmReserve InsurClmRsrvType Resource Type
KEY InsurClmReserveCurrency I_InsurClmReserve InsurClmReserveCurrency Valuation Crcy
InsurClmReserveCurrencyChanged I_InsurClmReserve InsurClmReserveCurrency Valuation Crcy
InsurClmRsrvChangeTime I_InsurClmReserve InsurClmRsrvChangeTime
InsurClmChangeDate I_InsurClmReserve InsurClmChangeDate
GrossReserveAmount I_InsurClmReserve GrossReserveAmount Exptr f.ResType
PostingDate I_InsurClmReserve PostingDate Posting Date for GR
InsurClmRsrvMethodName I_InsurClmReserve InsurClmRsrvMethodName Validation Method
InsurClmRsrvMethodText I_InsurClmReserve InsurClmRsrvMethodText
InsurClmRsrvPendingAmount I_InsurClmReserve InsurClmRsrvPendingAmount Pending Reserve
InsurClmReserveChangeRsn I_InsurClmReserve InsurClmReserveChangeRsn ChangeReason
InsurClmSubclaimAssignUUID I_InsurClmReserve InsurClmSubclaimAssignUUID
InsurClmAssignUUID I_InsurClmReserve InsurClmAssignUUID Link UUID
InsuranceClaimChangedByUser InsuranceClaimChangedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmApprovedOnDateTime InsurClmApprovedOnDateTime
InsurClmReservePerUnitAmount InsurClmReservePerUnitAmount Amount per Unit
InsuranceClaimReserveQuantity InsuranceClaimReserveQuantity Number
InsurClmReserveQuantityUnit InsurClmReserveQuantityUnit Unit
InsurClmSubrogtnResSpndgAmount InsurClmSubrogtnResSpndgAmount Pending Reserve
InsurClmItmGrpRejectionReason InsurClmItmGrpRejectionReason Rejection Reasn
InsurClmIsReserveApproved InsurClmIsReserveApproved Approved
InsuranceClaimApprovedByName InsuranceClaimApprovedByName Checked By
_InsurClaim _InsurClaim
_ReserveType I_InsurClmReserve _ReserveType
_Subclaim I_InsurClmReserve _Subclaim

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_InsurClmSrvcsReserveTP.
-- 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_InsurClmSrvcsReserveTP AS
SELECT
  _Reserve.InsuranceClaim AS InsuranceClaim,
  _Reserve.InsurClmSubclm AS InsurClmSubclm,
  _Reserve.InsurClmRsrvType AS InsurClmRsrvType,
  _Reserve.InsurClmReserveCurrency AS InsurClmReserveCurrency,
  _Reserve.InsurClmReserveCurrency AS InsurClmReserveCurrencyChanged,
  _Reserve.InsurClmRsrvChangeTime AS InsurClmRsrvChangeTime,
  _Reserve.InsurClmChangeDate AS InsurClmChangeDate,
  _Reserve.GrossReserveAmount AS GrossReserveAmount,
  _Reserve.PostingDate AS PostingDate,
  _Reserve.InsurClmRsrvMethodName AS InsurClmRsrvMethodName,
  _Reserve.InsurClmRsrvMethodText AS InsurClmRsrvMethodText,
  _Reserve.InsurClmRsrvPendingAmount AS InsurClmRsrvPendingAmount,
  _Reserve.InsurClmReserveChangeRsn AS InsurClmReserveChangeRsn,
  _Reserve.InsurClmSubclaimAssignUUID AS InsurClmSubclaimAssignUUID,
  _Reserve.InsurClmAssignUUID AS InsurClmAssignUUID,
  InsuranceClaimChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmApprovedOnDateTime,
  InsurClmReservePerUnitAmount,
  InsuranceClaimReserveQuantity,
  InsurClmReserveQuantityUnit,
  InsurClmSubrogtnResSpndgAmount,
  InsurClmItmGrpRejectionReason,
  InsurClmIsReserveApproved,
  InsuranceClaimApprovedByName,
  _Reserve._ReserveType AS _ReserveType,
  _Reserve._Subclaim AS _Subclaim
FROM I_InsurClmReserve AS _Reserve
;

Learn More