I_InsurPlcyModCalcTxBsc

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_InsurPlcyModCalcTxBsc.
-- 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_InsurPlcyModCalcTxBsc AS
SELECT
  cast( ModCalcTx.policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  ModCalcTx.policyproduct_id AS InsurPlcyInsurContr,
  ModCalcTx.journalendno_id AS InsurPlcyJrnlEndNmbr,
  cast( ModCalcTx.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyJrnlNmbr,
  ModCalcTx.covpac_id AS InsurPlcyCoveragePackageID,
  ModCalcTx.coverage_id AS InsurPlcyCoverageID,
  ModCalcTx.projec_id AS InsurPlcyModCalcID,
  ModCalcTx.projtax_id AS InsurPlcyModCalcTaxID,
  ModCalcTx.ppdpac_id AS InsurPlcyProductPackageID,
  ModCalcTx.cancel_fg AS InsurPlcyModCalcTxIsCancld,
  ModCalcTx.losstype_cd AS InsurPlcyClaimIncidentType,
  ModCalcTx.taxtype_cd AS InsurancePolicyTaxType,
  ModCalcTx.taxbase_cd AS InsurPlcyTaxAssessmentBase,
  cast( ModCalcTx.taxbegin_dt as /pm0/vdm_supdc_start_date preserving type ) AS InsurancePolicyTaxStartDate,
  cast( ModCalcTx.taxend_dt as /pm0/vdm_supdc_end_date preserving type ) AS InsurancePolicyTaxEndDate,
  ModCalcTx.taxbase_am AS InsPlcyTaxAssessmentBaseAmount,
  ModCalcTx.valoftaxbase_am AS InsurPlcyTaxValueOfBasisAmount,
  ModCalcTx.taxrate_vl AS InsurancePolicyTaxRate,
  ModCalcTx.tax_am AS InsurancePolicyTaxAmount,
  ModCalcTx.currency_id AS InsurPlcyModCalcTaxCurrency,
  ModCalcTx.taxusage_id AS InsurancePolicyTaxUsageType,
  ModCalcTx.taxcode_id AS InsurancePolicyTaxCode,
  ModCalcTx.bp_id AS InsurancePolicyTaxPartnerID,
  ModCalcTx.country_cd AS InsurancePolicyTaxCountry,
  ModCalcTx.region_cd AS InsurancePolicyTaxRegion,
  ModCalcTx.bo_cd AS InsurPlcyBusinessObject,
  ModCalcTx.change_ts AS InsurPlcyTaxChangeDateTime
FROM /pm0/aldaprojtax AS ModCalcTx
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyModCalcTaxCurrency = _Currency.Currency  -- association [1..1]
;