R_InsurPlcyAgentTP_2

DDL: R_INSURPLCYAGENTTP_2 Type: view_entity TRANSACTIONAL
19 Fields 2 Data Sources 2 Associations

Agent - TP

R_InsurPlcyAgentTP_2 is a Transactional CDS View that provides data about "Agent - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurancePolicyAgentVersion, I_InsurPlcyHghstVersPerAppl) and exposes 19 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurancePolicyAgentIdentifier. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurancePolicyAgentVersion Agent from
I_InsurPlcyHghstVersPerAppl HighestVersion inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[1..1] E_InsurancePolicyAgent _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurancePolicyAgentIdentifier = _Extension.InsurancePolicyAgentIdentifier

Annotations (12)

NameValueLevelField
EndUserText.label Agent - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name InsurancePolicyAgent view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix AGT view
AbapCatalog.extensibility.allowNewDatasources false view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurancePolicyAgentVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurancePolicyAgentVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurancePolicyAgentVersion InsurPlcyInsurContr Contract Key
KEY InsurancePolicyAgentIdentifier I_InsurancePolicyAgentVersion InsurancePolicyAgentIdentifier Representative
InsurPlcyOrderNumber I_InsurancePolicyAgentVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurancePolicyAgentVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurancePolicyAgentVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurancePolicyAgentVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurancePolicyAgentVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurancePolicyAgentVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyAgentIsCanceled I_InsurancePolicyAgentVersion InsurPlcyAgentIsCanceled Rev. Flag
InsurPlcyRprstvType I_InsurancePolicyAgentVersion InsurPlcyRprstvType Representative Type
InsurPlcyScopeAgent I_InsurancePolicyAgentVersion InsurPlcyScopeAgent Authority Scope
InsurancePolicyAgentPartner I_InsurancePolicyAgentVersion InsurancePolicyAgentPartner BusPartner
InsurPlcyAgentAddrNmbr I_InsurancePolicyAgentVersion InsurPlcyAgentAddrNmbr Address
InsurPlcyAgentTemplate I_InsurancePolicyAgentVersion InsurPlcyAgentTemplate Template ID
InsurPlcyBusinessObject I_InsurancePolicyAgentVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurancePolicyAgentVersion LastChangeDateTime Timestamp
_Policy _Policy

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_InsurPlcyAgentTP_2.
-- 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_InsurPlcyAgentTP_2 AS
SELECT
  Agent.InsurPlcyUUID AS InsurPlcyUUID,
  Agent.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  Agent.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Agent.InsurancePolicyAgentIdentifier AS InsurancePolicyAgentIdentifier,
  Agent.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  Agent.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  Agent.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  Agent.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Agent.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Agent.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Agent.InsurPlcyAgentIsCanceled AS InsurPlcyAgentIsCanceled,
  Agent.InsurPlcyRprstvType AS InsurPlcyRprstvType,
  Agent.InsurPlcyScopeAgent AS InsurPlcyScopeAgent,
  Agent.InsurancePolicyAgentPartner AS InsurancePolicyAgentPartner,
  Agent.InsurPlcyAgentAddrNmbr AS InsurPlcyAgentAddrNmbr,
  Agent.InsurPlcyAgentTemplate AS InsurPlcyAgentTemplate,
  Agent.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  Agent.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurancePolicyAgentVersion AS Agent
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN E_InsurancePolicyAgent AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurancePolicyAgentIdentifier = _Extension.InsurancePolicyAgentIdentifier  -- association [1..1]
;

Learn More