R_InsurPlcyCvrgInsObClauseTP

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_InsurPlcyCvrgInsObClauseTP.
-- 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_InsurPlcyCvrgInsObClauseTP AS
SELECT
  Clause.InsurPlcyUUID AS InsurPlcyUUID,
  Clause.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Clause.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Clause.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Clause.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  Clause.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  Clause.InsurPlcyUndrwrtgDcsnRiskID AS InsurPlcyUndrwrtgDcsnRiskID,
  Clause.InsurPlcySubCvrgID AS InsurPlcySubCvrgID,
  Clause.InsurPlcyClauseID AS InsurPlcyClauseID,
  Clause.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Clause.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Clause.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Clause.InsurPlcyClauseIsCanceled AS InsurPlcyClauseIsCanceled,
  Clause.InsurPlcyIndivClauseAgrmtText AS InsurPlcyIndivClauseAgrmtText,
  Clause.InsurPlcyClauseDetailTextUUID AS InsurPlcyClauseDetailTextUUID,
  LongText,
  TextObjectCategory,
  TextObjectKey,
  Language,
  Clause.InsurPlcyClauseType AS InsurPlcyClauseType,
  Clause.InsurPlcyClauseStartDate AS InsurPlcyClauseStartDate,
  Clause.InsurPlcyClauseEndDate AS InsurPlcyClauseEndDate,
  Clause.InsurPlcyClauseTemplate AS InsurPlcyClauseTemplate,
  Clause.InsurPlcyClauseClauseNumber AS InsurPlcyClauseClauseNumber,
  Clause.InsurancePolicyApplication AS InsurancePolicyApplication,
  Clause.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  Clause.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyBsClauseBasic AS Clause
LEFT OUTER JOIN E_InsurancePolicyClause AS _Extension ON InsurPlcySubCvrgID = _Extension.InsurPlcySubCvrgID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND InsurPlcyClauseID = _Extension.InsurPlcyClauseID AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyUndrwrtgDcsnRiskID = _Extension.InsurPlcyUndrwrtgDcsnRiskID  -- association [1..1]
;