R_InsurPlcyMnlSettlmtAmountTP

DDL: R_INSURPLCYMNLSETTLMTAMOUNTTP Type: view_entity TRANSACTIONAL
30 Fields 2 Data Sources 3 Associations

Manual Settlement Amt - TP

R_InsurPlcyMnlSettlmtAmountTP is a Transactional CDS View that provides data about "Manual Settlement Amt - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyMnlSettlmtVersion, I_InsurPlcyHghstVersPerAppl) and exposes 30 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyMnlSettlmtVersion _ManualSettelment from
I_InsurPlcyHghstVersPerAppl HighestVersion inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[0..*] R_InsurPlcyMnlPostgTxDetnTP _ManualPostingTaxDetn $projection.InsurPlcyUUIDForEdit = _ManualPostingTaxDetn.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _ManualPostingTaxDetn.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _ManualPostingTaxDetn.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _ManualPostingTaxDetn.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _ManualPostingTaxDetn.InsurPlcyCoverageID and $projection.InsPlcyMnlSettlmtAmtIDForEdit = _ManualPostingTaxDetn.InsurPlcyMnlSettlmtAmtID
[1..1] E_InsurPlcyMnlSettlementAmount _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyPremiumJournalNumber = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyPremJournalEndNumber = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyMnlSettlmtAmtID = _Extension.InsurPlcyMnlSettlmtAmtID

Annotations (11)

NameValueLevelField
EndUserText.label Manual Settlement Amt - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name InsPlcyMnlSettlementAmount view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MSA view
Metadata.ignorePropagatedAnnotations true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyMnlSettlmtVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyMnlSettlmtVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyMnlSettlmtVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyMnlSettlmtVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyMnlSettlmtVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyMnlSettlmtAmtID I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmtID Manual Posting
InsurPlcyUUIDForEdit I_InsurPlcyMnlSettlmtVersion InsurPlcyUUID Policy UUID
InsurPlcyApplUUIDForEdit I_InsurPlcyMnlSettlmtVersion InsurPlcyApplUUID Policy UUID
InsurPlcyInsurContrForEdit I_InsurPlcyMnlSettlmtVersion InsurPlcyInsurContr Contract Key
InsurPlcyCvPcgIDForEdit I_InsurPlcyMnlSettlmtVersion InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageIDForEdit I_InsurPlcyMnlSettlmtVersion InsurPlcyCoverageID Coverage Key
InsPlcyMnlSettlmtAmtIDForEdit I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmtID Manual Posting
InsurPlcyOrderNumber I_InsurPlcyMnlSettlmtVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyMnlSettlmtVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyMnlSettlmtVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyPremJournalEndNumber I_InsurPlcyMnlSettlmtVersion InsurPlcyPremJournalEndNumber Term. Jour. No.
InsurPlcyPremiumJournalNumber I_InsurPlcyMnlSettlmtVersion InsurPlcyPremiumJournalNumber Journal Number
InsurPlcyProductPackageID I_InsurPlcyMnlSettlmtVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyMnlSettlmtAmtIsCancld I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmtIsCancld Rev. Flag
InsurPlcyMnlSettlmtAmtFrmDte I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmtFrmDte Settlement From
InsurPlcyMnlSettlmtAmtToDte I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmtToDte Settlement To
InsurPlcyMnlSettlmtAmtIsSetld I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmtIsSetld Settled Contr.
InsurPlcyMnlSettlmtAmtIsRlvt I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmtIsRlvt Commission-Rel.
InsurPlcyMnlSettlmtAmtCrcy I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmtCrcy Currency
InsurPlcyMnlSettlmtAmt I_InsurPlcyMnlSettlmtVersion InsurPlcyMnlSettlmtAmt Man.Stt.Amount
InsurPlcyBusinessObject I_InsurPlcyMnlSettlmtVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyMnlSettlmtVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyMnlSettlmtVersion _Currency
_ManualPostingTaxDetn _ManualPostingTaxDetn
_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_InsurPlcyMnlSettlmtAmountTP.
-- 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_InsurPlcyMnlSettlmtAmountTP AS
SELECT
  _ManualSettelment.InsurPlcyUUID AS InsurPlcyUUID,
  _ManualSettelment.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  _ManualSettelment.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  _ManualSettelment.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  _ManualSettelment.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  _ManualSettelment.InsurPlcyMnlSettlmtAmtID AS InsurPlcyMnlSettlmtAmtID,
  _ManualSettelment.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  _ManualSettelment.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  _ManualSettelment.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  _ManualSettelment.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  _ManualSettelment.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  _ManualSettelment.InsurPlcyMnlSettlmtAmtID AS InsPlcyMnlSettlmtAmtIDForEdit,
  _ManualSettelment.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  _ManualSettelment.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  _ManualSettelment.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  _ManualSettelment.InsurPlcyPremJournalEndNumber AS InsurPlcyPremJournalEndNumber,
  _ManualSettelment.InsurPlcyPremiumJournalNumber AS InsurPlcyPremiumJournalNumber,
  _ManualSettelment.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  _ManualSettelment.InsurPlcyMnlSettlmtAmtIsCancld AS InsurPlcyMnlSettlmtAmtIsCancld,
  _ManualSettelment.InsurPlcyMnlSettlmtAmtFrmDte AS InsurPlcyMnlSettlmtAmtFrmDte,
  _ManualSettelment.InsurPlcyMnlSettlmtAmtToDte AS InsurPlcyMnlSettlmtAmtToDte,
  _ManualSettelment.InsurPlcyMnlSettlmtAmtIsSetld AS InsurPlcyMnlSettlmtAmtIsSetld,
  _ManualSettelment.InsurPlcyMnlSettlmtAmtIsRlvt AS InsurPlcyMnlSettlmtAmtIsRlvt,
  _ManualSettelment.InsurPlcyMnlSettlmtAmtCrcy AS InsurPlcyMnlSettlmtAmtCrcy,
  _ManualSettelment.InsurPlcyMnlSettlmtAmt AS InsurPlcyMnlSettlmtAmt,
  _ManualSettelment.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  _ManualSettelment.LastChangeDateTime AS LastChangeDateTime,
  _ManualSettelment._Currency AS _Currency
FROM I_InsurPlcyMnlSettlmtVersion AS _ManualSettelment
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 R_InsurPlcyMnlPostgTxDetnTP AS _ManualPostingTaxDetn ON InsurPlcyUUIDForEdit = _ManualPostingTaxDetn.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ManualPostingTaxDetn.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _ManualPostingTaxDetn.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _ManualPostingTaxDetn.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _ManualPostingTaxDetn.InsurPlcyCoverageID AND InsPlcyMnlSettlmtAmtIDForEdit = _ManualPostingTaxDetn.InsurPlcyMnlSettlmtAmtID  -- association [0..*]
LEFT OUTER JOIN E_InsurPlcyMnlSettlementAmount AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyPremiumJournalNumber = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyPremJournalEndNumber = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyMnlSettlmtAmtID = _Extension.InsurPlcyMnlSettlmtAmtID  -- association [1..1]
;

Learn More