R_InsurPlcyCBCPayerTP_2

DDL: R_INSURPLCYCBCPAYERTP_2 Type: view_entity TRANSACTIONAL
29 Fields 2 Data Sources 2 Associations

Cash Before Cover Payer - TP

R_InsurPlcyCBCPayerTP_2 is a Transactional CDS View that provides data about "Cash Before Cover Payer - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyCBCPayerVersion, I_InsurPlcyHghstVersPerAppl) and exposes 29 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCBCAmtPyrID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyCBCPayerVersion _CBCPayer from
I_InsurPlcyHghstVersPerAppl HighestVersion inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_InsurancePolicyCBCPayer _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyCBCAmtPyrID = _Extension.InsurPlcyCBCAmtPyrID
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID

Annotations (12)

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

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyCBCPayerVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyCBCPayerVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyCBCPayerVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCBCAmtPyrID I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmtPyrID CBC Payer ID
InsurPlcyOrderNumber I_InsurPlcyCBCPayerVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyCBCPayerVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyCBCPayerVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyCBCPayerVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyCBCPayerVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyCBCPayerVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyCBCAmountPyrIsCancld I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmountPyrIsCancld Rev. Flag
InsurPlcyCBCAmountPyrAddrNmbr I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmountPyrAddrNmbr Address
InsurPlcyCBCAmountSharePercent I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmountSharePercent Share (%)
InsurPlcyCBCAmountPyrPartner I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmountPyrPartner BusPartner
InsurPlcyCBCPyrIsAllocRmngAmt I_InsurPlcyCBCPayerVersion InsurPlcyCBCPyrIsAllocRmngAmt All. Rem. Amnt
InsurPlcyCBCAmtPyrBkAcctDet I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmtPyrBkAcctDet Bank Details
InsurPlcyCBCAmtPyrPaytCardNmbr I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmtPyrPaytCardNmbr Pymnt Card No.
InsurPlcyIncomingPaymentMethod I_InsurPlcyCBCPayerVersion InsurPlcyIncomingPaymentMethod IncPaytMth
InsurPlcyCBCAmountPyrCurrency I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmountPyrCurrency Currency
InsurPlcyCBCAmtPyrChkNmbr I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmtPyrChkNmbr Check Number
InsurPlcyCBCAmountPyrTemplate I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmountPyrTemplate Template ID
InsurPlcySEPAMandateID I_InsurPlcyCBCPayerVersion InsurPlcySEPAMandateID SEPA Mandate
InsurPlcyCollectionType I_InsurPlcyCBCPayerVersion InsurPlcyCollectionType Collection Type
InsurPlcyBrkrInsurObj I_InsurPlcyCBCPayerVersion InsurPlcyBrkrInsurObj BrokerInsObject
InsurPlcyCBCAmtPyrBrkrBP I_InsurPlcyCBCPayerVersion InsurPlcyCBCAmtPyrBrkrBP Broker BP No.
InsurPlcyBusinessObject I_InsurPlcyCBCPayerVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyCBCPayerVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyCBCPayerVersion _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_InsurPlcyCBCPayerTP_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_InsurPlcyCBCPayerTP_2 AS
SELECT
  _CBCPayer.InsurPlcyUUID AS InsurPlcyUUID,
  _CBCPayer.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  _CBCPayer.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  _CBCPayer.InsurPlcyCBCAmtPyrID AS InsurPlcyCBCAmtPyrID,
  _CBCPayer.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  _CBCPayer.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  _CBCPayer.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  _CBCPayer.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  _CBCPayer.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  _CBCPayer.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  _CBCPayer.InsurPlcyCBCAmountPyrIsCancld AS InsurPlcyCBCAmountPyrIsCancld,
  _CBCPayer.InsurPlcyCBCAmountPyrAddrNmbr AS InsurPlcyCBCAmountPyrAddrNmbr,
  _CBCPayer.InsurPlcyCBCAmountSharePercent AS InsurPlcyCBCAmountSharePercent,
  _CBCPayer.InsurPlcyCBCAmountPyrPartner AS InsurPlcyCBCAmountPyrPartner,
  _CBCPayer.InsurPlcyCBCPyrIsAllocRmngAmt AS InsurPlcyCBCPyrIsAllocRmngAmt,
  _CBCPayer.InsurPlcyCBCAmtPyrBkAcctDet AS InsurPlcyCBCAmtPyrBkAcctDet,
  _CBCPayer.InsurPlcyCBCAmtPyrPaytCardNmbr AS InsurPlcyCBCAmtPyrPaytCardNmbr,
  _CBCPayer.InsurPlcyIncomingPaymentMethod AS InsurPlcyIncomingPaymentMethod,
  _CBCPayer.InsurPlcyCBCAmountPyrCurrency AS InsurPlcyCBCAmountPyrCurrency,
  _CBCPayer.InsurPlcyCBCAmtPyrChkNmbr AS InsurPlcyCBCAmtPyrChkNmbr,
  _CBCPayer.InsurPlcyCBCAmountPyrTemplate AS InsurPlcyCBCAmountPyrTemplate,
  _CBCPayer.InsurPlcySEPAMandateID AS InsurPlcySEPAMandateID,
  _CBCPayer.InsurPlcyCollectionType AS InsurPlcyCollectionType,
  _CBCPayer.InsurPlcyBrkrInsurObj AS InsurPlcyBrkrInsurObj,
  _CBCPayer.InsurPlcyCBCAmtPyrBrkrBP AS InsurPlcyCBCAmtPyrBrkrBP,
  _CBCPayer.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  _CBCPayer.LastChangeDateTime AS LastChangeDateTime,
  _CBCPayer._Currency AS _Currency
FROM I_InsurPlcyCBCPayerVersion AS _CBCPayer
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_InsurancePolicyCBCPayer AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyCBCAmtPyrID = _Extension.InsurPlcyCBCAmtPyrID  -- association [1..1]
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
;

Learn More