A_InsurClmWrkrsCompnItm

DDL: A_INSURCLMWRKRSCOMPNITM Type: view_entity CONSUMPTION
31 Fields 1 Data Sources 1 OData Services

Claim Workers Compensation Item

A_InsurClmWrkrsCompnItm is a Consumption CDS View that provides data about "Claim Workers Compensation Item" in SAP S/4HANA. It reads from 1 data source (R_InsurClmWrkrsCompnItmTP) and exposes 31 fields with key fields InsurClmActive, InsuranceClaim, InsurClmSubclm, InsurClmWrkrsCompnSqncNmbr, InsurClmWrkrsCompnDetSqncNmbr. It is exposed through 1 OData service (API_INSURANCECLAIM).

Data Sources (1)

SourceAliasJoin Type
R_InsurClmWrkrsCompnItmTP R_InsurClmWrkrsCompnItmTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Claim Workers Compensation Item 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 InsurClmWrkrsCompnItm_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_INSURANCECLAIM API_INSURANCECLAIM V4 C2 C1

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmSubclm InsurClmSubclm Subclaim
KEY InsurClmWrkrsCompnSqncNmbr InsurClmWrkrsCompnSqncNmbr
KEY InsurClmWrkrsCompnDetSqncNmbr InsurClmWrkrsCompnDetSqncNmbr
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmWrkrsCompnItmCat InsurClmWrkrsCompnItmCat
InsurClmWrkrsCompnCurrency InsurClmWrkrsCompnCurrency
InsClmWrkrsCompnAvgWklyWageAmt InsClmWrkrsCompnAvgWklyWageAmt
InsurClmWrkrsCompnMinBnftAmt InsurClmWrkrsCompnMinBnftAmt
InsurClmWrkrsCompnMaxBnftAmt InsurClmWrkrsCompnMaxBnftAmt
InsurClmWrkrCompnWeekPaytAmt InsurClmWrkrCompnWeekPaytAmt
InsurClmWrkrsCompnPaytOffstAmt InsurClmWrkrsCompnPaytOffstAmt
InsurClmWrkrsCompnNmbrOfWeeks InsurClmWrkrsCompnNmbrOfWeeks
InsClmWrkrsCompnNmbrOfDaysRmng InsClmWrkrsCompnNmbrOfDaysRmng
InsurClmWrkrCompnPrtlPaytAmt InsurClmWrkrCompnPrtlPaytAmt
InsurClmWrkrsCompnBnftOffstAmt InsurClmWrkrsCompnBnftOffstAmt
InsurClmWrkrsCompnRtactvAmt InsurClmWrkrsCompnRtactvAmt
InsClmRecrrgPaytStrtDte InsClmRecrrgPaytStrtDte Valid From
InsClmRecrrgPaytEndDte InsClmRecrrgPaytEndDte Valid To
InsurClmWrkrsCompnTotPaytAmt InsurClmWrkrsCompnTotPaytAmt
InsurClmWrkrsCompnBurialAmt InsurClmWrkrsCompnBurialAmt
InsurClmWrkrsCompnTranspAmt InsurClmWrkrsCompnTranspAmt
InsurClmWrkrsCompnLumpSumAmt InsurClmWrkrsCompnLumpSumAmt
InsurClmWrkrsCompnTotAmt InsurClmWrkrsCompnTotAmt
InsurClmWrkrsCompnMaxChildAge InsurClmWrkrsCompnMaxChildAge
InsClmWrkrsCompnMaxStudentAge InsClmWrkrsCompnMaxStudentAge
InsClmWrkrsCompnSchedldPerdQty InsClmWrkrsCompnSchedldPerdQty
InsurClmWrkrsCompnSchedldUnit InsurClmWrkrsCompnSchedldUnit

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_InsurClmWrkrsCompnItm.
-- 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_InsurClmWrkrsCompnItm AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmWrkrsCompnSqncNmbr,
  InsurClmWrkrsCompnDetSqncNmbr,
  ChangedOnDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmWrkrsCompnItmCat,
  InsurClmWrkrsCompnCurrency,
  InsClmWrkrsCompnAvgWklyWageAmt,
  InsurClmWrkrsCompnMinBnftAmt,
  InsurClmWrkrsCompnMaxBnftAmt,
  InsurClmWrkrCompnWeekPaytAmt,
  InsurClmWrkrsCompnPaytOffstAmt,
  InsurClmWrkrsCompnNmbrOfWeeks,
  InsClmWrkrsCompnNmbrOfDaysRmng,
  InsurClmWrkrCompnPrtlPaytAmt,
  InsurClmWrkrsCompnBnftOffstAmt,
  InsurClmWrkrsCompnRtactvAmt,
  InsClmRecrrgPaytStrtDte,
  InsClmRecrrgPaytEndDte,
  InsurClmWrkrsCompnTotPaytAmt,
  InsurClmWrkrsCompnBurialAmt,
  InsurClmWrkrsCompnTranspAmt,
  InsurClmWrkrsCompnLumpSumAmt,
  InsurClmWrkrsCompnTotAmt,
  InsurClmWrkrsCompnMaxChildAge,
  InsClmWrkrsCompnMaxStudentAge,
  InsClmWrkrsCompnSchedldPerdQty,
  InsurClmWrkrsCompnSchedldUnit
FROM R_InsurClmWrkrsCompnItmTP
;

Learn More