I_InsurPlcyBsClauseBasic

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 I_InsurPlcyBsClauseBasic.
-- 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 I_InsurPlcyBsClauseBasic AS
SELECT
  cast( Clause.policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  Clause.policyproduct_id AS InsurPlcyInsurContr,
  cast( Clause.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyJrnlNmbr,
  Clause.journalendno_id AS InsurPlcyJrnlEndNmbr,
  Clause.covpac_id AS InsurPlcyCoveragePackageID,
  Clause.coverage_id AS InsurPlcyCoverageID,
  Clause.covcp_id AS InsurPlcyCoverageOptionID,
  Clause.subject_id AS InsurPlcyInsuredObjectID,
  Clause.uwdcn_id AS InsurPlcyUndrwrtgDcsnRiskID,
  Clause.covcpco_id AS InsurPlcySubCvrgID,
  Clause.clause_id AS InsurPlcyClauseID,
  Clause.ppdpac_id AS InsurPlcyProductPackageID,
  Clause.cancel_fg AS InsurPlcyClauseIsCanceled,
  Clause.clause_td AS InsurPlcyIndivClauseAgrmtText,
  cast( Clause.longtext_id as /pm0/vdm_clause_longtext_uuid preserving type ) AS InsurPlcyClauseDetailTextUUID,
  _LongText.LongText AS LongText,
  _LongText.TextObjectCategory AS TextObjectCategory,
  _LongText.TextObjectKey AS TextObjectKey,
  _LongText.Language AS Language,
  Clause.clause_cd AS InsurPlcyClauseType,
  cast( Clause.begin_dt as /pm0/vdm_clause_start_date preserving type ) AS InsurPlcyClauseStartDate,
  cast( Clause.end_dt as /pm0/vdm_clause_end_date preserving type ) AS InsurPlcyClauseEndDate,
  Clause.pm_id AS InsurPlcyClauseTemplate,
  Clause.clausenr_cd AS InsurPlcyClauseClauseNumber,
  Clause.applnr_cd AS InsurancePolicyApplication,
  Clause.bo_cd AS InsurPlcyBusinessObject,
  Clause.change_ts AS LastChangeDateTime
FROM /pm0/abdaclause AS Clause
;