A_InsurClmSubrogationItem

DDL: A_INSURCLMSUBROGATIONITEM Type: view_entity CONSUMPTION

Claim Subrogation Item

A_InsurClmSubrogationItem is a Consumption CDS View that provides data about "Claim Subrogation Item" in SAP S/4HANA. It reads from 1 data source (R_InsurClmSubrogationItemTP) and exposes 14 fields with key fields InsurClmActive, InsuranceClaim, InsurClmSubrogationItemUUID. It is exposed through 1 OData service (API_INSURANCECLAIM).

Data Sources (1)

SourceAliasJoin Type
R_InsurClmSubrogationItemTP R_InsurClmSubrogationItemTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Claim Subrogation Item view
AbapCatalog.extensibility.elementSuffix ICL view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 1000 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 InsurClaimSubrogationItem_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_INSURANCECLAIM API_INSURANCECLAIM V4 C2 C1

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmSubrogationItemUUID InsurClmSubrogationItemUUID
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmSubrogationUUID InsurClmSubrogationUUID
InsurClmSubclm InsurClmSubclm Subclaim
InsurClmSubrogationResAmount InsurClmSubrogationResAmount
InsurClaimSubrogationCurrency InsurClaimSubrogationCurrency
InsurClmSubrogationItemNumber InsurClmSubrogationItemNumber
InsurClmSubrogationItmCompId InsurClmSubrogationItmCompId
InsurClmRsrvPendingAmount InsurClmRsrvPendingAmount
InsurClmSubrogationStatusText InsurClmSubrogationStatusText

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_InsurClmSubrogationItem.
-- 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_InsurClmSubrogationItem AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmSubrogationItemUUID,
  ChangedOnDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmSubrogationUUID,
  InsurClmSubclm,
  InsurClmSubrogationResAmount,
  InsurClaimSubrogationCurrency,
  InsurClmSubrogationItemNumber,
  InsurClmSubrogationItmCompId,
  InsurClmRsrvPendingAmount,
  InsurClmSubrogationStatusText
FROM R_InsurClmSubrogationItemTP
;