I_InsurPlcyPrtlDisbmtVersion

DDL: I_INSURPLCYPRTLDISBMTVERSION Type: view_entity COMPOSITE
46 Fields 4 Data Sources

Partial Disbursement

I_InsurPlcyPrtlDisbmtVersion is a Composite CDS View that provides data about "Partial Disbursement" in SAP S/4HANA. It reads from 4 data sources (I_InsurPlcyPrtlDisbmtBsc, I_InsurPlcyPrtlDisbmtBsc, P_InPlPrtlDisbmtLoadJrnlAppl, P_InPlPrtlDisbmtLoadJrnlAppl) and exposes 46 fields with key fields InsurPlcyUUID, InsurPlcyOrderNumber, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID.

Data Sources (4)

SourceAliasJoin Type
I_InsurPlcyPrtlDisbmtBsc PrtlDisbmtBsc from
I_InsurPlcyPrtlDisbmtBsc PrtlDisbmtBsc union
P_InPlPrtlDisbmtLoadJrnlAppl PrtlDisbmtLdJrnlAppl inner
P_InPlPrtlDisbmtLoadJrnlAppl PrtlDisbmtLdJrnlAppl inner

Annotations (7)

NameValueLevelField
EndUserText.label Partial Disbursement view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID
KEY InsurPlcyOrderNumber P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyOrderNumber Sequence Number
KEY InsurPlcyInsurContr P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyBenefitID P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyBenefitID Benefit
KEY InsurPlcyPrtlDisbmtPrtlPaytId P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyPrtlDisbmtPrtlPaytId Partial Payt ID
InsurPlcyApplUUID
InsurPlcyBusProcType P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyPrtlDisbmtBsc InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyPrtlDisbmtBsc InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyPrtlDisbmtBsc InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyPrtlDisbmtIsCancelled I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtIsCancelled Rev. Flag
InsurPlcyPrtlDisbursementDate I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbursementDate Disb. Date
InsurPlcyPrtlDisbmtAbsltAmt I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtAbsltAmt Partial Disb.
InPlPrtlDisbmtRltvPrtlPaytAmt I_InsurPlcyPrtlDisbmtBsc InPlPrtlDisbmtRltvPrtlPaytAmt Rel. P.Payt Amt
InsurPlcyPrtlDisbmtTemplate I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtTemplate PartPayt PM_ID
InsurPlcyPrtlDisbmtPaymentRate I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtPaymentRate Partial Payt %
InsurPlcyPrtlDisbmtCurrency I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtCurrency Currency
InsurPlcyBusinessObject I_InsurPlcyPrtlDisbmtBsc InsurPlcyBusinessObject Process.Status
LastChangeDateTime I_InsurPlcyPrtlDisbmtBsc LastChangeDateTime Timestamp
KEY InsurPlcyOrderNumber P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyOrderNumber Sequence Number
KEY InsurPlcyInsurContr P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyBenefitID P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyBenefitID Benefit
KEY InsurPlcyPrtlDisbmtPrtlPaytId P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyPrtlDisbmtPrtlPaytId Partial Payt ID
InsurPlcyApplUUID
InsurPlcyBusProcType P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator P_InPlPrtlDisbmtLoadJrnlAppl InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyPrtlDisbmtBsc InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyPrtlDisbmtBsc InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyPrtlDisbmtBsc InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyPrtlDisbmtIsCancelled I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtIsCancelled Rev. Flag
InsurPlcyPrtlDisbursementDate I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbursementDate Disb. Date
InsurPlcyPrtlDisbmtAbsltAmt I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtAbsltAmt Partial Disb.
InPlPrtlDisbmtRltvPrtlPaytAmt I_InsurPlcyPrtlDisbmtBsc InPlPrtlDisbmtRltvPrtlPaytAmt Rel. P.Payt Amt
InsurPlcyPrtlDisbmtTemplate I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtTemplate PartPayt PM_ID
InsurPlcyPrtlDisbmtPaymentRate I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtPaymentRate Partial Payt %
InsurPlcyPrtlDisbmtCurrency I_InsurPlcyPrtlDisbmtBsc InsurPlcyPrtlDisbmtCurrency Currency
InsurPlcyBusinessObject I_InsurPlcyPrtlDisbmtBsc InsurPlcyBusinessObject Process.Status
LastChangeDateTime I_InsurPlcyPrtlDisbmtBsc LastChangeDateTime Timestamp
_Currency I_InsurPlcyPrtlDisbmtBsc _Currency

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_InsurPlcyPrtlDisbmtVersion.
-- 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_InsurPlcyPrtlDisbmtVersion AS
SELECT
  cast( PrtlDisbmtLdJrnlAppl.InsurPlcyUUID as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  PrtlDisbmtLdJrnlAppl.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  PrtlDisbmtLdJrnlAppl.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  PrtlDisbmtLdJrnlAppl.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  PrtlDisbmtLdJrnlAppl.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  PrtlDisbmtLdJrnlAppl.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  PrtlDisbmtLdJrnlAppl.InsurPlcyBenefitID AS InsurPlcyBenefitID,
  PrtlDisbmtLdJrnlAppl.InsurPlcyPrtlDisbmtPrtlPaytId AS InsurPlcyPrtlDisbmtPrtlPaytId,
  cast( PrtlDisbmtLdJrnlAppl.InsurPlcyApplUUID as /pm0/vdm_application_uuid preserving type ) AS InsurPlcyApplUUID,
  PrtlDisbmtLdJrnlAppl.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  PrtlDisbmtLdJrnlAppl.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  PrtlDisbmtBsc.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  PrtlDisbmtBsc.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  PrtlDisbmtBsc.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  PrtlDisbmtBsc.InsurPlcyPrtlDisbmtIsCancelled AS InsurPlcyPrtlDisbmtIsCancelled,
  PrtlDisbmtBsc.InsurPlcyPrtlDisbursementDate AS InsurPlcyPrtlDisbursementDate,
  PrtlDisbmtBsc.InsurPlcyPrtlDisbmtAbsltAmt AS InsurPlcyPrtlDisbmtAbsltAmt,
  PrtlDisbmtBsc.InPlPrtlDisbmtRltvPrtlPaytAmt AS InPlPrtlDisbmtRltvPrtlPaytAmt,
  PrtlDisbmtBsc.InsurPlcyPrtlDisbmtTemplate AS InsurPlcyPrtlDisbmtTemplate,
  PrtlDisbmtBsc.InsurPlcyPrtlDisbmtPaymentRate AS InsurPlcyPrtlDisbmtPaymentRate,
  PrtlDisbmtBsc.InsurPlcyPrtlDisbmtCurrency AS InsurPlcyPrtlDisbmtCurrency,
  PrtlDisbmtBsc.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  PrtlDisbmtBsc.LastChangeDateTime AS LastChangeDateTime,
  PrtlDisbmtBsc._Currency AS _Currency
FROM I_InsurPlcyPrtlDisbmtBsc AS PrtlDisbmtBsc
INNER JOIN P_InPlPrtlDisbmtLoadJrnlAppl AS PrtlDisbmtLdJrnlAppl ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_InsurPlcyPrtlDisbmtBsc
;

Learn More