I_InsurPlcyExternalDateBasic

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_InsurPlcyExternalDateBasic.
-- 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_InsurPlcyExternalDateBasic AS
SELECT
  cast( policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  policyproduct_id AS InsurPlcyInsurContr,
  func_id AS InsurPolicyTimeModelFunction,
  date_dt AS InsurPlcyPlndProcgEffctvDate,
  version_id AS InsurPlcyPlndProcgVersionValue,
  cast( application_id as /pm0/vdm_application_uuid preserving type ) AS InsurPlcyApplUUID,
  date_cd AS InsurPlcyPlannedProcessingType,
  storedtemp_fg AS InsurPlcyExtDteIsTmpStored,
  bo_cd AS InsurPlcyBusinessObject,
  knowldg_dt AS InsurPlcyExtDteReceiptDate,
  execute_dt AS InsurPlcyExtDteExecutionDate,
  execute_fg AS InsurPlcyExtDteProcgIsCmpltd,
  cast( journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyJrnlNmbr,
  delete_fg AS InsurPlcyExternalDateIsDeleted,
  delete_dt AS InsurPlcyExtDteDeletionDate,
  modname_tt AS InsurPlcyExtDteChangedBy,
  applnr_tt AS InsurancePolicyContract,
  order_vl AS InsurPlcyExtDteTmeModFuncSqnc,
  predappl_id AS InsurPlcyExtDteApplicationID,
  release_dt AS InsurPlcyExtDteReleaseDate,
  phase_vl AS InsurPlcyExtDtePerfPhaseType,
  infoextdt_id AS InsurPlcyExtDteRefConfID,
  sender_id AS InsurPlcyExtDteCreatedBy,
  adddtinfo_id AS InsurPlcyExtDteAddlInfoID
FROM /pm0/abdutrdptdt AS ExternalDate
;