I_InsurPlcyMnlCostPostgBasic

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_InsurPlcyMnlCostPostgBasic.
-- 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_InsurPlcyMnlCostPostgBasic AS
SELECT
  cast( ManualCostPosting.policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  ManualCostPosting.policyproduct_id AS InsurPlcyInsurContr,
  ManualCostPosting.journalendno_id AS InsurPlcyPremJournalEndNumber,
  cast( ManualCostPosting.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyPremiumJournalNumber,
  ManualCostPosting.covpac_id AS InsurPlcyCoveragePackageID,
  ManualCostPosting.coverage_id AS InsurPlcyCoverageID,
  ManualCostPosting.macost_id AS InsurPlcyManualCostPostingID,
  ManualCostPosting.ppdpac_id AS InsurPlcyProductPackageID,
  ManualCostPosting.cancel_fg AS InsurPlcyMnlCostIsCancelled,
  ManualCostPosting.postingtarget_id AS InsurPlcyMnlCostPostgTargetID,
  ManualCostPosting.partner_id AS InsurPlcyMnlCostPostgPartnerID,
  cast( ManualCostPosting.adressnumber_id as /pm0/vdm_address_id preserving type ) AS InsurPlcyMnlCostPostgAddrNmbr,
  ManualCostPosting.accountfrom_dt AS InsurPlcyMnlCostSettlmtFrmDte,
  ManualCostPosting.accountto_dt AS InsurPlcyMnlCostSettlmtToDte,
  ManualCostPosting.postingcode_id AS InsurPlcyMnlCostPostgCodeID,
  ManualCostPosting.postintx_tt AS InsurPlcyMnlCostPostgText,
  ManualCostPosting.debpostcode_id AS InsurPlcyMnlCostPostgDebitID,
  ManualCostPosting.debpostintx_tt AS InsurPlcyMnlCostPostgDebitText,
  ManualCostPosting.recipient_id AS InsurPlcyMnlCostPostgRcpntID,
  ManualCostPosting.incpaymethod_cd AS InsurPlcyMnlCostPostgPaytMeth,
  ManualCostPosting.macccosts_am AS InsurPlcyMnlCostPostgCostAmt,
  ManualCostPosting.currency_id AS InsurPlcyMnlCostPostgCrcy,
  ManualCostPosting.payer_cd AS InsurPlcyMnlCostPostgPayer,
  ManualCostPosting.debit_am AS InsurPlcyMnlCostPostgDebitAmt,
  ManualCostPosting.settledam_fg AS InsurPlcyMnlCostPostgIsSettled,
  ManualCostPosting.bankacc_id AS InsurPlcyMnlCostPostgBankDetID,
  ManualCostPosting.rate_dt AS InsurPlcyMnlCostExchRateDte,
  cast( ManualCostPosting.rate_vl as /pm0/vdm_translation_vl preserving type ) AS InsurPlcyMnlCostPostgExchRate,
  ManualCostPosting.bo_cd AS InsurPlcyBusinessObject,
  ManualCostPosting.change_ts AS LastChangeDateTime
FROM /pm0/abdamacost AS ManualCostPosting
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyMnlCostPostgCrcy = _Currency.Currency  -- association [1..1]
;