I_INS_ClaimItemGrpgProcedure

DDL: I_INS_CLAIMITEMGRPGPROCEDURE Type: view_entity TRANSACTIONAL
19 Fields 2 Data Sources 1 Associations

Claim Procedures

I_INS_ClaimItemGrpgProcedure is a Transactional CDS View that provides data about "Claim Procedures" in SAP S/4HANA. It reads from 2 data sources (I_INS_ClaimItemGroupingAssgmt, I_InsurClaimProcedure) and exposes 19 fields with key fields InsurClmActive, InsuranceClaim, InsuranceClaimProcedureUUID, InsurClmPaymentSubclaim, InsuranceClaimProcurementID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_INS_ClaimItemGroupingAssgmt ClaimAssign inner
I_InsurClaimProcedure Procedures from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_INS_ClaimServicesTP _InsuranceClaim $projection.InsurClmActive = _InsuranceClaim.InsurClmActive and $projection.InsuranceClaim = _InsuranceClaim.InsuranceClaim

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Claim Procedures view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive I_InsurClaimProcedure InsurClmActive Active/Suspense
KEY InsuranceClaim I_InsurClaimProcedure InsuranceClaim Claim Number
KEY InsuranceClaimProcedureUUID I_InsurClaimProcedure InsuranceClaimProcedureUUID UUID Procedure
KEY InsurClmPaymentSubclaim I_INS_ClaimItemGroupingAssgmt InsurClmPaymentSubclaim Subclaim
KEY InsuranceClaimProcurementID I_INS_ClaimItemGroupingAssgmt InsuranceClaimProcurementID ClaimItem Gpng
LastChangeDateTime I_InsurClaimProcedure LastChangeDateTime Timestamp
LastChangedByUser I_InsurClaimProcedure LastChangedByUser User Name
InsurClmDatabaseLineStatus I_InsurClaimProcedure InsurClmDatabaseLineStatus Status
InsurClmItemBenefitCatalogUUID I_InsurClaimProcedure InsurClmItemBenefitCatalogUUID Int. BC Item ID
InsurClmItemIdOfServiceCatalog I_InsurClaimProcedure InsurClmItemIdOfServiceCatalog Benef.Catalog
InsurClmItmBnftCatalogItemID I_InsurClaimProcedure InsurClmItmBnftCatalogItemID BenCtlg Item
InsuranceClaimProcedureNumber I_InsurClaimProcedure InsuranceClaimProcedureNumber Number
InsuranceClaimPatientNumber I_InsurClaimProcedure InsuranceClaimPatientNumber Person Treated
InsuranceClaimIsPrimProced I_InsurClaimProcedure InsuranceClaimIsPrimProced Prim.Procedure
InsurClmProcedPerfrmdDteTme I_InsurClaimProcedure InsurClmProcedPerfrmdDteTme Time Performed
InsurClmLocalizedSide I_InsurClaimProcedure InsurClmLocalizedSide Localization
InsurClmDeptOfHosp I_InsurClaimProcedure InsurClmDeptOfHosp Department
InsurClmIsUsdForGrpg I_InsurClaimProcedure InsurClmIsUsdForGrpg Used f.Grouping
_InsuranceClaim _InsuranceClaim

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 I_INS_ClaimItemGrpgProcedure.
-- 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 I_INS_ClaimItemGrpgProcedure AS
SELECT
  Procedures.InsurClmActive AS InsurClmActive,
  Procedures.InsuranceClaim AS InsuranceClaim,
  Procedures.InsuranceClaimProcedureUUID AS InsuranceClaimProcedureUUID,
  ClaimAssign.InsurClmPaymentSubclaim AS InsurClmPaymentSubclaim,
  ClaimAssign.InsuranceClaimProcurementID AS InsuranceClaimProcurementID,
  Procedures.LastChangeDateTime AS LastChangeDateTime,
  Procedures.LastChangedByUser AS LastChangedByUser,
  Procedures.InsurClmDatabaseLineStatus AS InsurClmDatabaseLineStatus,
  Procedures.InsurClmItemBenefitCatalogUUID AS InsurClmItemBenefitCatalogUUID,
  Procedures.InsurClmItemIdOfServiceCatalog AS InsurClmItemIdOfServiceCatalog,
  Procedures.InsurClmItmBnftCatalogItemID AS InsurClmItmBnftCatalogItemID,
  Procedures.InsuranceClaimProcedureNumber AS InsuranceClaimProcedureNumber,
  Procedures.InsuranceClaimPatientNumber AS InsuranceClaimPatientNumber,
  Procedures.InsuranceClaimIsPrimProced AS InsuranceClaimIsPrimProced,
  Procedures.InsurClmProcedPerfrmdDteTme AS InsurClmProcedPerfrmdDteTme,
  Procedures.InsurClmLocalizedSide AS InsurClmLocalizedSide,
  Procedures.InsurClmDeptOfHosp AS InsurClmDeptOfHosp,
  Procedures.InsurClmIsUsdForGrpg AS InsurClmIsUsdForGrpg
FROM I_InsurClaimProcedure AS Procedures
INNER JOIN I_INS_ClaimItemGroupingAssgmt AS ClaimAssign ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_INS_ClaimServicesTP AS _InsuranceClaim ON InsurClmActive = _InsuranceClaim.InsurClmActive AND InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
;

Learn More