R_InsurPlcyFundAllocationTP

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 R_InsurPlcyFundAllocationTP.
-- 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 R_InsurPlcyFundAllocationTP AS
SELECT
  FundAllocation.InsurPlcyUUID AS InsurPlcyUUID,
  FundAllocation.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  FundAllocation.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  FundAllocation.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  FundAllocation.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  FundAllocation.InsurPlcyFundAllocationID AS InsurPlcyFundAllocationID,
  FundAllocation.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  FundAllocation.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  FundAllocation.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  FundAllocation.InsurPlcyFundAllocIsCancelled AS InsurPlcyFundAllocIsCancelled,
  FundAllocation.InsurPlcyFundAllocFundID AS InsurPlcyFundAllocFundID,
  FundAllocation.InsurPlcyFundAllocEffctvDte AS InsurPlcyFundAllocEffctvDte,
  FundAllocation.InsurPlcyFundAllocCurDistrPct AS InsurPlcyFundAllocCurDistrPct,
  FundAllocation.InsurPlcyFundAllocMinShrPct AS InsurPlcyFundAllocMinShrPct,
  FundAllocation.InsurPlcyFundAllocMaxShrPct AS InsurPlcyFundAllocMaxShrPct,
  FundAllocation.InsurPlcyFundAllocValueAmt AS InsurPlcyFundAllocValueAmt,
  FundAllocation.InsurPlcyFundAllocNmbrOfShares AS InsurPlcyFundAllocNmbrOfShares,
  FundAllocation.InsurPlcyFundAllocPriceDte AS InsurPlcyFundAllocPriceDte,
  FundAllocation.InsurPlcyFundAllocLoclCrcyAmt AS InsurPlcyFundAllocLoclCrcyAmt,
  FundAllocation.InsurPlcyFundAllocSlsProdID AS InsurPlcyFundAllocSlsProdID,
  FundAllocation.InsurPlcyFundAllocIntNumber AS InsurPlcyFundAllocIntNumber,
  FundAllocation.InsurPlcyFundAllocCurrency AS InsurPlcyFundAllocCurrency,
  FundAllocation.InsurPlcyFundAllocOrdAmt AS InsurPlcyFundAllocOrdAmt,
  FundAllocation.InsurPlcyFundAllocOrdShrVal AS InsurPlcyFundAllocOrdShrVal,
  FundAllocation.InsurPlcyFundAllocDistCalcRule AS InsurPlcyFundAllocDistCalcRule,
  FundAllocation.InsurPlcyFundAllocChrgSched AS InsurPlcyFundAllocChrgSched,
  FundAllocation.InsurPlcyFundAllocChrgType AS InsurPlcyFundAllocChrgType,
  FundAllocation.InsurPlcyFundAllocMgmtChrgPct AS InsurPlcyFundAllocMgmtChrgPct,
  FundAllocation.InsurPlcyFundAllocIssuancePct AS InsurPlcyFundAllocIssuancePct,
  FundAllocation.InsurPlcyFundAllocCollType AS InsurPlcyFundAllocCollType,
  FundAllocation.InsurPlcyFundAllocMinIntrstPct AS InsurPlcyFundAllocMinIntrstPct,
  FundAllocation.InsurPlcyFundIntrstCalcPct AS InsurPlcyFundIntrstCalcPct,
  FundAllocation.InsurPlcyFundAllocPriceType AS InsurPlcyFundAllocPriceType,
  FundAllocation.InsurPlcyFundAllocPartnerID AS InsurPlcyFundAllocPartnerID,
  FundAllocation.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  FundAllocation.LastChangeDateTime AS LastChangeDateTime,
  FundAllocation._Currency AS _Currency
FROM I_InsurPlcyFundAllocationBasic AS FundAllocation
LEFT OUTER JOIN E_InsurPolicyFundAllocation AS _Extension ON InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyFundAllocationID = _Extension.InsurPlcyFundAllocationID  -- association [1..1]
;