R_InsurPlcyAcctBalShtValTP

DDL: R_INSURPLCYACCTBALSHTVALTP Type: view_entity TRANSACTIONAL
33 Fields 2 Data Sources 2 Associations

Account Balance Sheet Values - TP

R_InsurPlcyAcctBalShtValTP is a Transactional CDS View that provides data about "Account Balance Sheet Values - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyAcctBalShtValsVers, I_InsurPlcyHghstVersPerAppl) and exposes 33 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyAcctBalShtValsVers AcctBalShtValue 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_InsurPlcyAcctBalSheetValue _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyAcctBalShtValuesID = _Extension.InsurPlcyAcctBalShtValuesID

Annotations (11)

NameValueLevelField
EndUserText.label Account Balance Sheet Values - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name InsurPlcyAcctBalSheetValue view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix ABV view
Metadata.ignorePropagatedAnnotations true view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyAcctBalShtValsVers InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyAcctBalShtValsVers InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyAcctBalShtValsVers InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyAcctBalShtValsVers InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyAcctBalShtValsVers InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID I_InsurPlcyAcctBalShtValsVers InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyAcctBalShtValuesID I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtValuesID Acct ID BS Val.
InsurPlcyOrderNumber I_InsurPlcyAcctBalShtValsVers InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyAcctBalShtValsVers InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyAcctBalShtValsVers InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyAcctBalShtValsVers InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyAcctBalShtValsVers InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyAcctBalShtValsVers InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyAcctBalShtIsCancelled I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtIsCancelled Rev. Flag
InsurPlcyAcctBalShtProductID I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtProductID AcctBalValsPMID
InsurPlcyAcctBalShtNetRsrvAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtNetRsrvAmt Net Reserve
InsurPlcyAcctBalRskCptlOneAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalRskCptlOneAmt Risked Capital 1
InsurPlcyAcctBalRskCptlTwoAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalRskCptlTwoAmt Risked Cap. 2
InsurPlcyAcctBalAdminRsrvAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalAdminRsrvAmt AdminCostsRes
InsurPlcyAcctBalShtCtrlUsrAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtCtrlUsrAmt Zillmer Reserve
InsurPlcyAcctBalShtModuleType I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtModuleType Module Type
InsurPlcyAcctBalShtStstclAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtStstclAmt Stat. Prem.
InsurPlcyAcctBalStstclSumAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalStstclSumAmt Stat. Sum Ins.
InsurPlcyAcctBalFnlRsrvAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalFnlRsrvAmt FinSurpRes
InsurPlcyAcctBalBoundRsrvAmt I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalBoundRsrvAmt Bound FS Res.
InsurPlcyAcctBalShtValdDte I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtValdDte Valid
InsurPlcyAcctBalShtReceiptDte I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtReceiptDte Receipt Date
InsurPlcyAcctBalShtCurrency I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtCurrency Currency
InsurPlcyAcctBalShtStstclNmbr I_InsurPlcyAcctBalShtValsVers InsurPlcyAcctBalShtStstclNmbr Statistical No.
InsurPlcyBusinessObject I_InsurPlcyAcctBalShtValsVers InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyAcctBalShtValsVers LastChangeDateTime Timestamp
_Currency I_InsurPlcyAcctBalShtValsVers _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_InsurPlcyAcctBalShtValTP.
-- 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_InsurPlcyAcctBalShtValTP AS
SELECT
  AcctBalShtValue.InsurPlcyUUID AS InsurPlcyUUID,
  AcctBalShtValue.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  AcctBalShtValue.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  AcctBalShtValue.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  AcctBalShtValue.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  AcctBalShtValue.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  AcctBalShtValue.InsurPlcyAcctBalShtValuesID AS InsurPlcyAcctBalShtValuesID,
  AcctBalShtValue.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  AcctBalShtValue.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  AcctBalShtValue.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  AcctBalShtValue.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  AcctBalShtValue.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  AcctBalShtValue.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  AcctBalShtValue.InsurPlcyAcctBalShtIsCancelled AS InsurPlcyAcctBalShtIsCancelled,
  AcctBalShtValue.InsurPlcyAcctBalShtProductID AS InsurPlcyAcctBalShtProductID,
  AcctBalShtValue.InsurPlcyAcctBalShtNetRsrvAmt AS InsurPlcyAcctBalShtNetRsrvAmt,
  AcctBalShtValue.InsurPlcyAcctBalRskCptlOneAmt AS InsurPlcyAcctBalRskCptlOneAmt,
  AcctBalShtValue.InsurPlcyAcctBalRskCptlTwoAmt AS InsurPlcyAcctBalRskCptlTwoAmt,
  AcctBalShtValue.InsurPlcyAcctBalAdminRsrvAmt AS InsurPlcyAcctBalAdminRsrvAmt,
  AcctBalShtValue.InsurPlcyAcctBalShtCtrlUsrAmt AS InsurPlcyAcctBalShtCtrlUsrAmt,
  AcctBalShtValue.InsurPlcyAcctBalShtModuleType AS InsurPlcyAcctBalShtModuleType,
  AcctBalShtValue.InsurPlcyAcctBalShtStstclAmt AS InsurPlcyAcctBalShtStstclAmt,
  AcctBalShtValue.InsurPlcyAcctBalStstclSumAmt AS InsurPlcyAcctBalStstclSumAmt,
  AcctBalShtValue.InsurPlcyAcctBalFnlRsrvAmt AS InsurPlcyAcctBalFnlRsrvAmt,
  AcctBalShtValue.InsurPlcyAcctBalBoundRsrvAmt AS InsurPlcyAcctBalBoundRsrvAmt,
  AcctBalShtValue.InsurPlcyAcctBalShtValdDte AS InsurPlcyAcctBalShtValdDte,
  AcctBalShtValue.InsurPlcyAcctBalShtReceiptDte AS InsurPlcyAcctBalShtReceiptDte,
  AcctBalShtValue.InsurPlcyAcctBalShtCurrency AS InsurPlcyAcctBalShtCurrency,
  AcctBalShtValue.InsurPlcyAcctBalShtStstclNmbr AS InsurPlcyAcctBalShtStstclNmbr,
  AcctBalShtValue.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  AcctBalShtValue.LastChangeDateTime AS LastChangeDateTime,
  AcctBalShtValue._Currency AS _Currency
FROM I_InsurPlcyAcctBalShtValsVers AS AcctBalShtValue
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_InsurPlcyAcctBalSheetValue AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyAcctBalShtValuesID = _Extension.InsurPlcyAcctBalShtValuesID  -- association [1..1]
;

Learn More