I_InsurPlcyPremPayerBasic

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_InsurPlcyPremPayerBasic.
-- 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_InsurPlcyPremPayerBasic AS
SELECT
  cast( PremPayer.policy_id as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  PremPayer.policyproduct_id AS InsurPlcyInsurContr,
  PremPayer.prmpayr_id AS InsurPlcyContrPremPayerID,
  cast( PremPayer.journalno_id as /pm0/vdm_journal_number_id preserving type ) AS InsurPlcyJrnlNmbr,
  PremPayer.journalendno_id AS InsurPlcyJrnlEndNmbr,
  PremPayer.ppdpac_id AS InsurPlcyProductPackageID,
  PremPayer.cancel_fg AS InsurPlcyPremPayerIsCanceled,
  cast( PremPayer.addressnumber_id as /pm0/vdm_address_id preserving type ) AS AddressID,
  PremPayer.partner_id AS InsurPlcyPremiumPayerID,
  cast( PremPayer.bankacc_id as bu_bkvid preserving type ) AS BankIdentification,
  cast( PremPayer.paymentcard_id as bu_ccid preserving type ) AS PaymentCardID,
  cast( PremPayer.incpaymethod_cd as pymet_kk preserving type ) AS CAPaymentMethod,
  PremPayer.pm_id AS InsurPlcyPremiumPayerTemplate,
  cast( PremPayer.sepa_mandate_id as sepa_mndid preserving type ) AS SEPAMandate,
  PremPayer.bo_cd AS InsurPlcyBusinessObject,
  PremPayer.colltype_cd AS InsurPlcyCollectionType,
  PremPayer.change_ts AS LastChangeDateTime,
  PremPayer.share_am AS InsurPlcyPremPayerShareAmount,
  PremPayer.share_vl AS InsurPlcyPremPayerSharePercent,
  PremPayer.allocremaind_fg AS InsurPlcyPremPyrRmngAmtIsAssgd,
  PremPayer.paymacc_cd AS InsurPlcyPremPayerCollAcctID,
  PremPayer.paympart_cd AS InsurPlcyPremPyrPaytPrtn,
  PremPayer.insobj_cd AS InsurPlcyPremPyrInsurObject,
  PremPayer.paympolicy_id AS InsurPlcyPremPyrSettlmtPlcy,
  PremPayer.paympolpr_id AS InsurPlcyPremPyrSettlmtContr,
  PremPayer.checkno_id AS InsurPlcyPremPyrCheckNmbr,
  PremPayer.brokerinsobj_id AS InsurPlcyPremPyrBrkrInsurObj,
  PremPayer.brokerbp_id AS InsurPlcyPremPyrBrkrBPNmbr,
  PremPayer.currency_id AS InsurPlcyPremiumCurrency
FROM /pm0/abdaprmpayr AS PremPayer
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyPremiumCurrency = _Currency.Currency  -- association [1..1]
;