R_InsurPlcySurchrgDiscTP_2

DDL: R_INSURPLCYSURCHRGDISCTP_2 Type: view_entity TRANSACTIONAL
28 Fields 2 Data Sources 2 Associations

Surcharge Discount - TP

R_InsurPlcySurchrgDiscTP_2 is a Transactional CDS View that provides data about "Surcharge Discount - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyHghstVersPerAppl, I_InsurPlcySurchrgDiscVersion) and exposes 28 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyHghstVersPerAppl HighestVersion inner
I_InsurPlcySurchrgDiscVersion SurchargeDiscount from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[1..1] E_InsurPolicySurchargeDiscount _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID and $projection.InsurPlcySurchargeDiscID = _Extension.InsurPlcySurchargeDiscID

Annotations (12)

NameValueLevelField
EndUserText.label Surcharge Discount - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name InsurPolicySurchargeDiscount view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix SDC view
AbapCatalog.extensibility.allowNewDatasources false view
Metadata.ignorePropagatedAnnotations true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcySurchrgDiscVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcySurchrgDiscVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcySurchrgDiscVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcySurchrgDiscVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcySurchrgDiscVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID I_InsurPlcySurchrgDiscVersion InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID I_InsurPlcySurchrgDiscVersion InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyUndrwrtgDcsnRiskID I_InsurPlcySurchrgDiscVersion InsurPlcyUndrwrtgDcsnRiskID UndWritDecision
KEY InsurPlcySurchargeDiscID I_InsurPlcySurchrgDiscVersion InsurPlcySurchargeDiscID Sur./Disc. No.
InsurPlcyOrderNumber I_InsurPlcySurchrgDiscVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyJrnlNmbr I_InsurPlcySurchrgDiscVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcySurchrgDiscVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcySurchrgDiscVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcySurchrgDiscTemplate I_InsurPlcySurchrgDiscVersion InsurPlcySurchrgDiscTemplate Surcharge/Discount Template
InsurPlcySurchargeDiscStrtDate I_InsurPlcySurchrgDiscVersion InsurPlcySurchargeDiscStrtDate Surcharge/Discount Start
InsurPlcySurchargeDiscEndDate I_InsurPlcySurchrgDiscVersion InsurPlcySurchargeDiscEndDate Surcharge/Discount End
InsurPlcySurchrgDiscBaseAmtPct I_InsurPlcySurchrgDiscVersion InsurPlcySurchrgDiscBaseAmtPct Relative Value
InsurPlcySurchargeDiscAmount I_InsurPlcySurchrgDiscVersion InsurPlcySurchargeDiscAmount Srch./Disc.Amt
InsurPlcySurchrgDiscAmtType I_InsurPlcySurchrgDiscVersion InsurPlcySurchrgDiscAmtType Reference Value
InsurPlcySurchrgDiscAmtUnit I_InsurPlcySurchrgDiscVersion InsurPlcySurchrgDiscAmtUnit Calculatn Type
InsurPlcySurchargeDiscTypeID I_InsurPlcySurchrgDiscVersion InsurPlcySurchargeDiscTypeID Surch/Disc.Type
InsurPlcySurchrgDiscCurrency I_InsurPlcySurchrgDiscVersion InsurPlcySurchrgDiscCurrency Currency
InsurPlcyBusinessObject I_InsurPlcySurchrgDiscVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcySurchrgDiscVersion LastChangeDateTime Timestamp
InsurPlcyBusProcessNumerator I_InsurPlcySurchrgDiscVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyBusProcType I_InsurPlcySurchrgDiscVersion InsurPlcyBusProcType Bus. Process
_Currency
_Policy _Policy

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_InsurPlcySurchrgDiscTP_2.
-- 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_InsurPlcySurchrgDiscTP_2 AS
SELECT
  SurchargeDiscount.InsurPlcyUUID AS InsurPlcyUUID,
  SurchargeDiscount.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  SurchargeDiscount.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  SurchargeDiscount.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  SurchargeDiscount.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  SurchargeDiscount.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  SurchargeDiscount.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  SurchargeDiscount.InsurPlcyUndrwrtgDcsnRiskID AS InsurPlcyUndrwrtgDcsnRiskID,
  SurchargeDiscount.InsurPlcySurchargeDiscID AS InsurPlcySurchargeDiscID,
  SurchargeDiscount.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  SurchargeDiscount.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  SurchargeDiscount.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  SurchargeDiscount.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  SurchargeDiscount.InsurPlcySurchrgDiscTemplate AS InsurPlcySurchrgDiscTemplate,
  SurchargeDiscount.InsurPlcySurchargeDiscStrtDate AS InsurPlcySurchargeDiscStrtDate,
  SurchargeDiscount.InsurPlcySurchargeDiscEndDate AS InsurPlcySurchargeDiscEndDate,
  SurchargeDiscount.InsurPlcySurchrgDiscBaseAmtPct AS InsurPlcySurchrgDiscBaseAmtPct,
  SurchargeDiscount.InsurPlcySurchargeDiscAmount AS InsurPlcySurchargeDiscAmount,
  SurchargeDiscount.InsurPlcySurchrgDiscAmtType AS InsurPlcySurchrgDiscAmtType,
  SurchargeDiscount.InsurPlcySurchrgDiscAmtUnit AS InsurPlcySurchrgDiscAmtUnit,
  SurchargeDiscount.InsurPlcySurchargeDiscTypeID AS InsurPlcySurchargeDiscTypeID,
  SurchargeDiscount.InsurPlcySurchrgDiscCurrency AS InsurPlcySurchrgDiscCurrency,
  SurchargeDiscount.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  SurchargeDiscount.LastChangeDateTime AS LastChangeDateTime,
  SurchargeDiscount.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  SurchargeDiscount.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  SurchargeDiscount. _Currency AS _Currency
FROM I_InsurPlcySurchrgDiscVersion AS SurchargeDiscount
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN E_InsurPolicySurchargeDiscount AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND InsurPlcySurchargeDiscID = _Extension.InsurPlcySurchargeDiscID  -- association [1..1]
;

Learn More