I_BusPartRelationshipTP_2

DDL: I_BUSPARTRELATIONSHIPTP_2 SQL: IBUPARELTP2 Type: view TRANSACTIONAL
47 Fields 2 Data Sources 2 Associations

BO View fot BUPA Relationship

I_BusPartRelationshipTP_2 is a Transactional CDS View that provides data about "BO View fot BUPA Relationship" in SAP S/4HANA. It reads from 2 data sources (I_BPRelationship_2, I_BPRelationship_2) and exposes 47 fields with key fields RelationshipNumber, BusinessPartner1, BusinessPartner2, ValidityEndDate, BusinessPartner1. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BPRelationship_2 I_BPRelationship_2 from
I_BPRelationship_2 I_BPRelationship_2 union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner1 = _BusinessPartner.BusinessPartner
[0..1] I_BPRelshpCompanyInterestTP_2 _BPRelshpCompanyInterest $projection.RelationshipNumber = _BPRelshpCompanyInterest.RelationshipNumber and $projection.BusinessPartner1 = _BPRelshpCompanyInterest.BusinessPartner1 and $projection.BusinessPartner2 = _BPRelshpCompanyInterest.BusinessPartner2 and $projection.ValidityEndDate = _BPRelshpCompanyInterest.ValidityEndDate

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBUPARELTP2 view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO View fot BUPA Relationship view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.writeDraftPersistence bupa_rel_d view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY RelationshipNumber RelationshipNumber BP Rel. Number
KEY BusinessPartner1 BusinessPartner1 Partner
KEY BusinessPartner2 BusinessPartner2 Partner
KEY ValidityEndDate ValidityEndDate ValidTo
RelationshipCategory RelationshipCategory Relationsh.Cat.
ValidityStartDate ValidityStartDate Validity Start Date
RelationshipNumberForEdit RelationshipNumber BP Rel. Number
BusinessPartner1ForEdit BusinessPartner1 Partner
BusinessPartner2ForEdit BusinessPartner2 Partner
ValidityEndDateForEdit ValidityEndDate ValidTo
IsStandardRelationship IsStandardRelationship Standard
BPRelationshipType BPRelationshipType RelationshpType
BusPartRelshpIsRoleDefinition BusPartRelshpIsRoleDefinition Role definition
BPRelshpCatIsInFwdDirection
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
_BusinessPartner _BusinessPartner
_BPRelshpCompanyInterest _BPRelshpCompanyInterest
_BusinessPartner1 _BusinessPartner1
ValidityEndDatekeyRelationshipNumber
KEY BusinessPartner1 BusinessPartner2 Partner
KEY BusinessPartner2 BusinessPartner1 Partner
KEY ValidityEndDate ValidityEndDate ValidTo
RelationshipCategory RelationshipCategory Relationsh.Cat.
ValidityStartDate ValidityStartDate Validity Start Date
RelationshipNumberForEdit RelationshipNumber BP Rel. Number
BusinessPartner1ForEdit BusinessPartner2 Partner
BusinessPartner2ForEdit BusinessPartner1 Partner
ValidityEndDateForEdit ValidityEndDate ValidTo
IsStandardRelationship IsStandardRelationship Standard
BPRelationshipType BPRelationshipType RelationshpType
BusPartRelshpIsRoleDefinition BusPartRelshpIsRoleDefinition Role definition
BPRelshpCatIsInFwdDirection
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
_BusinessPartner _BusinessPartner
_BPRelshpCompanyInterest _BPRelshpCompanyInterest
_BusinessPartner1 _BusinessPartner2
_BusinessPartner2 _BusinessPartner1

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_BusPartRelationshipTP_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.
-- SQL view name: IBUPARELTP2

CREATE VIEW I_BusPartRelationshipTP_2 AS
SELECT
  RelationshipNumber,
  BusinessPartner1,
  BusinessPartner2,
  ValidityEndDate,
  RelationshipCategory,
  ValidityStartDate,
  RelationshipNumber AS RelationshipNumberForEdit,
  BusinessPartner1 AS BusinessPartner1ForEdit,
  BusinessPartner2 AS BusinessPartner2ForEdit,
  ValidityEndDate AS ValidityEndDateForEdit,
  IsStandardRelationship,
  BPRelationshipType,
  BusPartRelshpIsRoleDefinition,
  'X' AS BPRelshpCatIsInFwdDirection,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime
FROM I_BPRelationship_2
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner1 = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPRelshpCompanyInterestTP_2 AS _BPRelshpCompanyInterest ON RelationshipNumber = _BPRelshpCompanyInterest.RelationshipNumber AND BusinessPartner1 = _BPRelshpCompanyInterest.BusinessPartner1 AND BusinessPartner2 = _BPRelshpCompanyInterest.BusinessPartner2 AND ValidityEndDate = _BPRelshpCompanyInterest.ValidityEndDate  -- association [0..1]
-- UNION ALL with additional select branch(es): I_BPRelationship_2
;

Learn More