R_InsurPlcyPremiumPayerTP_3

DDL: R_INSURPLCYPREMIUMPAYERTP_3 Type: view_entity TRANSACTIONAL
36 Fields 2 Data Sources 2 Associations

Premium Payer - TP

R_InsurPlcyPremiumPayerTP_3 is a Transactional CDS View that provides data about "Premium Payer - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyPremPayerVersion, I_InsurPlcyHghstVersPerAppl) and exposes 36 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyContrPremPayerID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyPremPayerVersion _PremiumPayer from
I_InsurPlcyHghstVersPerAppl HighestVersion inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[1..1] E_InsurancePolicyPremiumPayer _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.InsurPlcyContrPremPayerID = _Extension.InsurPlcyContrPremPayerID

Annotations (12)

NameValueLevelField
EndUserText.label Premium Payer - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name InsurancePolicyPremiumPayer view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix PRP view
AbapCatalog.extensibility.allowNewDatasources false view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyPremPayerVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyPremPayerVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyPremPayerVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyContrPremPayerID I_InsurPlcyPremPayerVersion InsurPlcyContrPremPayerID PremiumPayer ID
InsurPlcyOrderNumber I_InsurPlcyPremPayerVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyPremPayerVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyPremPayerVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyPremPayerVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyPremPayerVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyPremPayerVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyPremPayerIsCanceled I_InsurPlcyPremPayerVersion InsurPlcyPremPayerIsCanceled Rev. Flag
AddressID I_InsurPlcyPremPayerVersion AddressID Ship-to address
InsurPlcyPremiumPayerID I_InsurPlcyPremPayerVersion InsurPlcyPremiumPayerID BusPartner
BankIdentification I_InsurPlcyPremPayerVersion BankIdentification Bank Details
PaymentCardID I_InsurPlcyPremPayerVersion PaymentCardID Card ID
CAPaymentMethod I_InsurPlcyPremPayerVersion CAPaymentMethod Payment Method
InsurPlcyPremiumPayerTemplate I_InsurPlcyPremPayerVersion InsurPlcyPremiumPayerTemplate Template ID
SEPAMandate I_InsurPlcyPremPayerVersion SEPAMandate SEPA Mandate
InsurPlcyBusinessObject I_InsurPlcyPremPayerVersion InsurPlcyBusinessObject
InsurPlcyCollectionType I_InsurPlcyPremPayerVersion InsurPlcyCollectionType Collection Type
LastChangeDateTime I_InsurPlcyPremPayerVersion LastChangeDateTime Timestamp
InsurPlcyPremPayerShareAmount I_InsurPlcyPremPayerVersion InsurPlcyPremPayerShareAmount Share Amount
InsurPlcyPremPayerSharePercent I_InsurPlcyPremPayerVersion InsurPlcyPremPayerSharePercent Share (%)
InsurPlcyPremPyrRmngAmtIsAssgd I_InsurPlcyPremPayerVersion InsurPlcyPremPyrRmngAmtIsAssgd All. Rem. Amnt
InsurPlcyPremPayerCollAcctID I_InsurPlcyPremPayerVersion InsurPlcyPremPayerCollAcctID Coll. Acct
InsurPlcyPremPyrPaytPrtn I_InsurPlcyPremPayerVersion InsurPlcyPremPyrPaytPrtn Payt Partner
InsurPlcyPremPyrInsurObject I_InsurPlcyPremPayerVersion InsurPlcyPremPyrInsurObject Ins. Obj.
InsurPlcyPremPyrSettlmtPlcy I_InsurPlcyPremPayerVersion InsurPlcyPremPyrSettlmtPlcy Settl. Policy
InsurPlcyPremPyrSettlmtContr I_InsurPlcyPremPayerVersion InsurPlcyPremPyrSettlmtContr Settl. Contract
InsurPlcyPremPyrCheckNmbr I_InsurPlcyPremPayerVersion InsurPlcyPremPyrCheckNmbr Check Number
InsurPlcyPremPyrBrkrInsurObj I_InsurPlcyPremPayerVersion InsurPlcyPremPyrBrkrInsurObj BrokerInsObject
InsurPlcyPremPyrBrkrBPNmbr I_InsurPlcyPremPayerVersion InsurPlcyPremPyrBrkrBPNmbr Broker BP No.
InsurPlcyPremPyrIsBrkrChanged I_InsurPlcyPremPayerVersion InsurPlcyPremPyrIsBrkrChanged
InsurPlcyPremiumCurrency I_InsurPlcyPremPayerVersion InsurPlcyPremiumCurrency Currency
_Currency I_InsurPlcyPremPayerVersion _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_InsurPlcyPremiumPayerTP_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_InsurPlcyPremiumPayerTP_3 AS
SELECT
  _PremiumPayer.InsurPlcyUUID AS InsurPlcyUUID,
  _PremiumPayer.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  _PremiumPayer.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  _PremiumPayer.InsurPlcyContrPremPayerID AS InsurPlcyContrPremPayerID,
  _PremiumPayer.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  _PremiumPayer.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  _PremiumPayer.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  _PremiumPayer.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  _PremiumPayer.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  _PremiumPayer.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  _PremiumPayer.InsurPlcyPremPayerIsCanceled AS InsurPlcyPremPayerIsCanceled,
  _PremiumPayer.AddressID AS AddressID,
  _PremiumPayer.InsurPlcyPremiumPayerID AS InsurPlcyPremiumPayerID,
  _PremiumPayer.BankIdentification AS BankIdentification,
  _PremiumPayer.PaymentCardID AS PaymentCardID,
  _PremiumPayer.CAPaymentMethod AS CAPaymentMethod,
  _PremiumPayer.InsurPlcyPremiumPayerTemplate AS InsurPlcyPremiumPayerTemplate,
  _PremiumPayer.SEPAMandate AS SEPAMandate,
  _PremiumPayer.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  _PremiumPayer.InsurPlcyCollectionType AS InsurPlcyCollectionType,
  _PremiumPayer.LastChangeDateTime AS LastChangeDateTime,
  _PremiumPayer.InsurPlcyPremPayerShareAmount AS InsurPlcyPremPayerShareAmount,
  _PremiumPayer.InsurPlcyPremPayerSharePercent AS InsurPlcyPremPayerSharePercent,
  _PremiumPayer.InsurPlcyPremPyrRmngAmtIsAssgd AS InsurPlcyPremPyrRmngAmtIsAssgd,
  _PremiumPayer.InsurPlcyPremPayerCollAcctID AS InsurPlcyPremPayerCollAcctID,
  _PremiumPayer.InsurPlcyPremPyrPaytPrtn AS InsurPlcyPremPyrPaytPrtn,
  _PremiumPayer.InsurPlcyPremPyrInsurObject AS InsurPlcyPremPyrInsurObject,
  _PremiumPayer.InsurPlcyPremPyrSettlmtPlcy AS InsurPlcyPremPyrSettlmtPlcy,
  _PremiumPayer.InsurPlcyPremPyrSettlmtContr AS InsurPlcyPremPyrSettlmtContr,
  _PremiumPayer.InsurPlcyPremPyrCheckNmbr AS InsurPlcyPremPyrCheckNmbr,
  _PremiumPayer.InsurPlcyPremPyrBrkrInsurObj AS InsurPlcyPremPyrBrkrInsurObj,
  _PremiumPayer.InsurPlcyPremPyrBrkrBPNmbr AS InsurPlcyPremPyrBrkrBPNmbr,
  _PremiumPayer.InsurPlcyPremPyrIsBrkrChanged AS InsurPlcyPremPyrIsBrkrChanged,
  _PremiumPayer.InsurPlcyPremiumCurrency AS InsurPlcyPremiumCurrency,
  _PremiumPayer._Currency AS _Currency
FROM I_InsurPlcyPremPayerVersion AS _PremiumPayer
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_InsurancePolicyPremiumPayer AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyContrPremPayerID = _Extension.InsurPlcyContrPremPayerID  -- association [1..1]
;

Learn More