R_InsurPlcyCoinsurHeaderTP_3

DDL: R_INSURPLCYCOINSURHEADERTP_3 Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 3 Associations

Coinsurance Header - TP

R_InsurPlcyCoinsurHeaderTP_3 is a Transactional CDS View that provides data about "Coinsurance Header - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCoinsurHdrVersion) and exposes 23 fields with key fields InsurPlcyCoinsurHdrUUID, InsurPlcyCoinsurVersionID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCoinsurHdrVersion _CoinsuranceHeader from

Associations (3)

CardinalityTargetAliasCondition
[1..1] E_InsurPlcyCoInsurHdr _Extension $projection.InsurPlcyCoinsurHdrUUID = _Extension.InsurPlcyCoinsurHdrUUID and $projection.InsurPlcyCoinsurJournalNumber = _Extension.InsurPlcyCoinsurJournalNumber
[1..*] R_InsurPlcyDistrPlnRelshpTP_3 _DistributionPlan $projection.InsurPlcyCoinsurHdrDistrPlnID = _DistributionPlan.InsurPlcyDistributionPlanNmbr
[1..*] R_InsurPlcyCoinsurSgmtTP_3 _CoinsuranceShareSegment

Annotations (12)

NameValueLevelField
EndUserText.label Coinsurance Header - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name InsurPlcyCoInsurHdr view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix COH view
AbapCatalog.extensibility.allowNewDatasources false view
Metadata.ignorePropagatedAnnotations true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyCoinsurHdrUUID I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrUUID Distr.Plan GUID
KEY InsurPlcyCoinsurVersionID I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurVersionID Journal Number
InsurPlcyCoinsurHdrUUIDForEdit I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrUUID Distr.Plan GUID
InsurPlcyCoinsurVersIDForEdit I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurVersionID Journal Number
InsurPlcyCoinsurJournalNumber I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurJournalNumber Journal Number
InsurPlcyCoinsurHdrDistrPlnID I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrDistrPlnID Distr.Plan No.
InsurPlcyCoinsurHdrCoinsurType I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrCoinsurType Coins. Type
InsurPlcyCoinsurHdrLeaderID I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrLeaderID Leading
InsurPlcyCoinsurHdrAddrNumber I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrAddrNumber Address
InsurPlcyCoinsurHdrValdStrtDte I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrValdStrtDte Start Date
InsurPlcyCoinsurHdrValdEndDte I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrValdEndDte End Date
InsurPlcyCoinsurHdrReferenceID I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrReferenceID Reference No.
InsurPlcyCoinsurHdrEffctvDte I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrEffctvDte Effective Date
InsurPlcyCoinsurHdrTmplNmbr I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrTmplNmbr DistPl.Templ.No
InsurPlcyCoinsurHdrTmplText I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrTmplText DistrPlanTempl.
InsurPlcyCoinsurHdrJrnlEndNmbr I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrJrnlEndNmbr Journal End No.
InsurPlcyCoinsurHdrIsCancld I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrIsCancld Reversal
InsurPlcyCoinsurHdrLastChgdBy I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrLastChgdBy Last Changed By
LastChangeDateTime I_InsurPlcyCoinsurHdrVersion LastChangeDateTime Timestamp
InsurPlcyCoinsurHdrCreatedBy I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrCreatedBy Creator Name
InsurPlcyCoinsurHdrCrtedDteTme I_InsurPlcyCoinsurHdrVersion InsurPlcyCoinsurHdrCrtedDteTme UTC Time Stamp Entry
_CoinsuranceShareSegment _CoinsuranceShareSegment
_DistributionPlan _DistributionPlan

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_InsurPlcyCoinsurHeaderTP_3.
-- 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_InsurPlcyCoinsurHeaderTP_3 AS
SELECT
  _CoinsuranceHeader.InsurPlcyCoinsurHdrUUID AS InsurPlcyCoinsurHdrUUID,
  _CoinsuranceHeader.InsurPlcyCoinsurVersionID AS InsurPlcyCoinsurVersionID,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrUUID AS InsurPlcyCoinsurHdrUUIDForEdit,
  _CoinsuranceHeader.InsurPlcyCoinsurVersionID AS InsurPlcyCoinsurVersIDForEdit,
  _CoinsuranceHeader.InsurPlcyCoinsurJournalNumber AS InsurPlcyCoinsurJournalNumber,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrDistrPlnID AS InsurPlcyCoinsurHdrDistrPlnID,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrCoinsurType AS InsurPlcyCoinsurHdrCoinsurType,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrLeaderID AS InsurPlcyCoinsurHdrLeaderID,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrAddrNumber AS InsurPlcyCoinsurHdrAddrNumber,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrValdStrtDte AS InsurPlcyCoinsurHdrValdStrtDte,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrValdEndDte AS InsurPlcyCoinsurHdrValdEndDte,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrReferenceID AS InsurPlcyCoinsurHdrReferenceID,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrEffctvDte AS InsurPlcyCoinsurHdrEffctvDte,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrTmplNmbr AS InsurPlcyCoinsurHdrTmplNmbr,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrTmplText AS InsurPlcyCoinsurHdrTmplText,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrJrnlEndNmbr AS InsurPlcyCoinsurHdrJrnlEndNmbr,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrIsCancld AS InsurPlcyCoinsurHdrIsCancld,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrLastChgdBy AS InsurPlcyCoinsurHdrLastChgdBy,
  _CoinsuranceHeader.LastChangeDateTime AS LastChangeDateTime,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrCreatedBy AS InsurPlcyCoinsurHdrCreatedBy,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrCrtedDteTme AS InsurPlcyCoinsurHdrCrtedDteTme
FROM I_InsurPlcyCoinsurHdrVersion AS _CoinsuranceHeader
LEFT OUTER JOIN E_InsurPlcyCoInsurHdr AS _Extension ON InsurPlcyCoinsurHdrUUID = _Extension.InsurPlcyCoinsurHdrUUID AND InsurPlcyCoinsurJournalNumber = _Extension.InsurPlcyCoinsurJournalNumber  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyDistrPlnRelshpTP_3 AS _DistributionPlan ON InsurPlcyCoinsurHdrDistrPlnID = _DistributionPlan.InsurPlcyDistributionPlanNmbr  -- association [1..*]
LEFT OUTER JOIN R_InsurPlcyCoinsurSgmtTP_3 AS _CoinsuranceShareSegment ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More