I_InsurApplPremPayer

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_InsurApplPremPayer.
-- 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_InsurApplPremPayer AS
SELECT
  PremPayer.InsurPlcyUUID AS InsurPlcyUUID,
  PremPayer.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  PremPayer.InsurPlcyContrPremPayerID AS InsurPlcyContrPremPayerID,
  cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  PremPayer.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  PremPayer.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  PremPayer.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  PremPayer.AddressID AS AddressID,
  PremPayer.InsurPlcyPremiumPayerID AS InsurPlcyPremiumPayerID,
  PremPayer.BankIdentification AS BankIdentification,
  PremPayer.PaymentCardID AS PaymentCardID,
  PremPayer.CAPaymentMethod AS CAPaymentMethod,
  PremPayer.InsurPlcyPremiumPayerTemplate AS InsurPlcyPremiumPayerTemplate,
  PremPayer.SEPAMandate AS SEPAMandate,
  PremPayer.LastChangeDateTime AS LastChangeDateTime,
  _InsurApplContract.InsurPlcyCountry AS InsurPlcyCountry,
  PremPayer.InsurPlcyCollectionType AS InsurPlcyCollectionType,
  PremPayer.InsurPlcyPremPayerShareAmount AS InsurPlcyPremPayerShareAmount,
  PremPayer.InsurPlcyPremPayerSharePercent AS InsurPlcyPremPayerSharePercent,
  PremPayer.InsurPlcyPremPyrRmngAmtIsAssgd AS InsurPlcyPremPyrRmngAmtIsAssgd,
  PremPayer.InsurPlcyPremiumCurrency AS InsurPlcyPremiumCurrency
FROM P_InsurPolicyJournalKeys AS PlcyJrnl
INNER JOIN I_InsurPlcyPremPayerBasic AS PremPayer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyPremiumCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyPremiumPayerTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON InsurPlcyPremiumPayerID = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentMethodText AS _CAPaymentMethodText ON CAPaymentMethod = _CAPaymentMethodText.CAPaymentMethod AND InsurPlcyCountry = _CAPaymentMethodText.Country  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyCollectionType AS _InsurPlcyCollectionType ON InsurPlcyCollectionType = _InsurPlcyCollectionType.InsurPlcyCollectionType  -- association [1..1]
;