I_InsurClmPaytItmAllwdCvrgType

DDL: I_INSURCLMPAYTITMALLWDCVRGTYPE Type: view COMPOSITE
11 Fields 4 Data Sources

Zulässige Deckungart für Zahlungsposten

I_InsurClmPaytItmAllwdCvrgType is a Composite CDS View that provides data about "Zulässige Deckungart für Zahlungsposten" in SAP S/4HANA. It reads from 4 data sources (I_InsurClmPaymentItem, I_InsurPlcyProdAllwdCvrgType, I_InsurPlcyProdAllwdCvrgType, I_InsurPlcyProdAllwdCvrgType) and exposes 11 fields with key fields InsuranceClaim, InsurClmSubclm, InsurClmPayt, InsurClmPaytItem, InsurClmCoverageType.

Data Sources (4)

SourceAliasJoin Type
I_InsurClmPaymentItem _PaymentItem from
I_InsurPlcyProdAllwdCvrgType _PermittedCoveTypeCountry left_outer
I_InsurPlcyProdAllwdCvrgType _PermittedCoveTypeRegion left_outer
I_InsurPlcyProdAllwdCvrgType _PermittedCoveTypeVersion left_outer

Annotations (9)

NameValueLevelField
EndUserText.label Zulässige Deckungart für Zahlungsposten view
AbapCatalog.sqlViewName IICLFOPAYICOVT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmPaymentItem InsuranceClaim Claim Number
KEY InsurClmSubclm I_InsurClmPaymentItem InsurClmSubclm Subclaim
KEY InsurClmPayt I_InsurClmPaymentItem InsurClmPayt Payment Number
KEY InsurClmPaytItem I_InsurClmPaymentItem InsurClmPaytItem Payment Item
KEY InsurClmCoverageType I_InsurClmPaymentItem InsurClmCoverageType Coverage Type
InsurBnftType I_InsurClmPaymentItem InsurBnftType Benefit Type
InsurClmVersionChangeTime _Claim InsurClmVersionChangeTime Read Time
InsurClmDateTimeOfLoss _Claim InsurClmDateTimeOfLoss
InsurClmContractLastRenewal _Claim InsurClmContractLastRenewal Last Renewal
InsurClmAuthznGrp _Claim InsurClmAuthznGrp AuthGroup (VIP)
InsurClmType _Claim InsurClmType Claim Type

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_InsurClmPaytItmAllwdCvrgType.
-- 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_InsurClmPaytItmAllwdCvrgType AS
SELECT
  _PaymentItem.InsuranceClaim AS InsuranceClaim,
  _PaymentItem.InsurClmSubclm AS InsurClmSubclm,
  _PaymentItem.InsurClmPayt AS InsurClmPayt,
  _PaymentItem.InsurClmPaytItem AS InsurClmPaytItem,
  _PaymentItem.InsurClmCoverageType AS InsurClmCoverageType,
  _PaymentItem.InsurBnftType AS InsurBnftType,
  _Claim.InsurClmVersionChangeTime AS InsurClmVersionChangeTime,
  _Claim.InsurClmDateTimeOfLoss AS InsurClmDateTimeOfLoss,
  _Claim.InsurClmContractLastRenewal AS InsurClmContractLastRenewal,
  _Claim.InsurClmAuthznGrp AS InsurClmAuthznGrp,
  _Claim.InsurClmType AS InsurClmType
FROM I_InsurClmPaymentItem AS _PaymentItem
LEFT OUTER JOIN I_InsurPlcyProdAllwdCvrgType AS _PermittedCoveTypeRegion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InsurPlcyProdAllwdCvrgType AS _PermittedCoveTypeCountry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InsurPlcyProdAllwdCvrgType AS _PermittedCoveTypeVersion ON /* join condition not captured in parsed metadata */
;

Learn More