R_InsurPlcyContractTP

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_InsurPlcyContractTP.
-- 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_InsurPlcyContractTP AS
SELECT
  InsurPlcyUUID,
  InsurPlcyInsurContr,
  _Policy.InsrrIDByInsrr AS InsrrIDByInsrr,
  _Policy.InsurPlcyAuthznSlsProductGroup AS InsurPlcyAuthznSlsProductGroup,
  InsurPlcyJrnlNmbr,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyProductPackageID,
  InsurPlcyContractIsCanceled,
  InsurancePolicyContract,
  InsurPlcyContrOldContractID,
  InsurPlcyContrNmbrOfCoverage,
  InsurPlcyLineOfBusiness,
  InsurPlcyContractStartDate,
  InsurancePolicyStartTime,
  InsurancePolicyStartTimeZone,
  InsurancePolicyContractEndDate,
  InsurancePolicyEndTime,
  InsurancePolicyEndTimeZone,
  InsurPlcyContrCommentID,
  LongText,
  TextObjectCategory,
  TextObjectKey,
  Language,
  InsurPlcyContractCompanyID,
  InsurPlcyContractPolicyStatus,
  InsurPlcyContractCategory,
  InsurPlcyContrLifeCycleStatus,
  InsurPlcyContrCanclnRsn,
  InsurPlcyContrCanclnDte,
  InsurPlcyContractReversalTime,
  InsurPlcyContrReversalTimeZone,
  InsurPlcyContractAcctVariant,
  InsurancePolicyContractStatus,
  InsurPlcyContrSuspensionType,
  InsurPlcySuspensionBeginDate,
  InsurPlcySuspensionBeginTime,
  InsurPlcySuspnBeginTmeZn,
  InsurPlcySuspensionEndDate,
  InsurPlcySuspensionEndTime,
  InsurPlcySuspensionEndTimeZone,
  InsurPlcyContrMatlStartDate,
  InsurPlcyContrExtensionVariant,
  InsPlcyContrIsCoPensnSchmPmtd,
  InsurPlcyContrIsAdjustment,
  InsurPlcyContrTariffVariant,
  InsurPlcyContrIsManualRating,
  InsurPlcyContrGenerationDate,
  InsurPlcyContrProRtTmpVariant,
  InsurPlcyProductTemplate,
  InsurPlcyContrExprtnAgeValue,
  InsurPlcyContractRejectionDate,
  InsurPlcyContrRejectionReason,
  InsPlcyContrSrceDocStsDateTime,
  InsurPlcyContrInsurObjectID,
  InsPlcyContrHasPndgCommsnCase,
  InsurPlcyContrCommsnPostgCode,
  InsurPlcyContractIsLifetime,
  InsurPlcyPrvsnlContractNumber,
  InsurPlcyCountry,
  InsurPlcyContrTxblPersnInfo,
  InsurPlcyContractIsGeneration,
  InsurPlcyContractRegion,
  InsurPlcyContrScpOfPremTxn,
  InsurPlcyContrIsAlreadyIncld,
  InsPlcyContrDiffntMttyDayMnth,
  InsurPlcyContrFirstProcessorID,
  InsurPlcyContrSecondProcsrID,
  InsurPlcyContrRefusalRsnText,
  InsurPlcyContrIsCheckPending,
  InsurPlcyContrIsAutomProdChg,
  InsurPlcyContrTransferType,
  InsurPlcyContrConversionType,
  InsurPlcyContrAutomProdChgDate,
  InsurPlcyContrGnrtnDetnDate,
  InsurPlcyContractIsDuplicate,
  InsurPlcyContractShiftType,
  InsurPlcyContrFnlRnwlDcsn,
  InsurPlcyContrRnwlRefusalRsn,
  InsurPlcyContrRenewalDate,
  InsurPlcyContrRnwlDecision,
  InsurPlcyContrRnwlPrepLastDate,
  InsurPlcyContractCurrency,
  InsurPlcyContrAbsltMnlPMLAmt,
  InsurPlcyContrRltvMnlPMLRate,
  InsurPlcyContrIsMnlPostprocg,
  InsurPlcyContrMnlFldLblAmtText,
  InsurPlcyContrEnhancedLife,
  InsurPlcyContrLoanLimitRate,
  InsPlcyContrAutomPremLoanOptn,
  InsurPlcyContrMaxLoanAmount,
  InsurPlcyContractLocalCurrency,
  InsurPlcyContractRiskCurrency,
  InsurPlcyContrInvoiceCurrency,
  InsurPlcyContrRiskExchRate,
  InsurPlcyContrRiskExchRateDte,
  InsurPlcyContrInvcCrcyExchRate,
  InsurPlcyContrInvcExchRateDte,
  InsurPlcyContrExchRateDetn,
  InsurPlcyContrRskApplExchRate,
  InsPlcyContrRskApplExchRateDte,
  InsurPlcyContrInvcApplExchRate,
  InsurPlcyInvcApplExchRateDate,
  InsurPlcyContrQuotationVariant,
  InsurPlcyBusinessObject,
  LastChangeDateTime
FROM I_InsurancePolicyContract
LEFT OUTER JOIN R_InsurancePolicyTP_2 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID  -- association [1..1]
LEFT OUTER JOIN E_InsuranceContract AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyContrCoverageTP_2 AS _Coverage ON InsurPlcyUUID = _Coverage.InsurPlcyUUID AND InsurPlcyInsurContr = _Coverage.InsurPlcyInsurContr  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrCvrgPackageTP AS _CoveragePackage ON InsurPlcyUUID = _CoveragePackage.InsurPlcyUUID AND InsurPlcyInsurContr = _CoveragePackage.InsurPlcyInsurContr  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyAccountingTP_2 AS _TransferSettle ON InsurancePolicyContract = _TransferSettle.InsurPlcyAcctgExtContrNmbr  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrReltdContrTP AS _RelatedContract ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrBeneficiaryTP AS _Beneficiary ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyCBCPayerTP AS _CBCPayer ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContractChargeTP AS _Charge ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContractCreditorTP AS _Creditor ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContractDcblTP_2 AS _Deductible ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrAdjustmentTP AS _Adjustment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContractLimitTP_2 AS _Limit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyPremiumPayerTP_2 AS _PremiumPayer ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrSuDscTP AS _SurchargeDiscount ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrValDateTP AS _ValueDate ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContractPremiumTP AS _Premium ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrClauseTP_2 AS _Clause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContractBenefitTP AS _Benefit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyProcDpCndTP AS _ProcessDependentCondition ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrInsObTP_2 AS _InsuredObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrExtRefTP AS _ExternalReference ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyLifeContractTP AS _LifeContract ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_InsurPlcyGeneralContractTP AS _GeneralContract ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_InsurPlcyContrAssmtBasisTP AS _AssessmentBasis ON /* condition not available in parsed metadata */  -- association [0..*]
;