I_BPRelshpCompanyInterestTP

DDL: I_BPRELSHPCOMPANYINTERESTTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_REL_BO
13 Fields 1 Data Sources

RAP BO view for BP shareholder data

I_BPRelshpCompanyInterestTP is a Transactional CDS View that provides data about "RAP BO view for BP shareholder data" in SAP S/4HANA. It reads from 1 data source (P_BPRelshpCompanyIntUnion) and exposes 13 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory. Part of development package MDC_BUPA_REL_BO.

Data Sources (1)

SourceAliasJoin Type
P_BPRelshpCompanyIntUnion P_BPRelshpCompanyIntUnion from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label RAP BO view for BP shareholder data view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartnerCompany Busn. Partner
KEY BusinessPartner2 BusinessPartnerPerson Busn. Partner
KEY ValidityEndDate ValidTo
KEY RelationshipCategory RelationshipCategory Relationsh.Cat.
RelationshipNumber RelationshipNumber BP Rel. Number
BPCoCapitalInterestPercentage BPCoCapitalInterestPercentage
BPCompanyCapitalInterestAmount BPCompanyCapitalInterestAmount
Currency Currency Valuation Crcy
IsShareholderControlledCompany
BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
_BusinessPartner1 _BusinessPartnerCompany
_BusinessPartner2 _BusinessPartnerPerson
_BusPartRelationship _BusPartRelationship

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_BPRelshpCompanyInterestTP.
-- 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_BPRelshpCompanyInterestTP AS
SELECT
  BusinessPartnerCompany AS BusinessPartner1,
  BusinessPartnerPerson AS BusinessPartner2,
  cast( ValidityEndDate as abap.char( 17 )) AS ValidityEndDate,
  RelationshipCategory,
  RelationshipNumber,
  BPCoCapitalInterestPercentage,
  BPCompanyCapitalInterestAmount,
  Currency,
  cast(IsShareholderControlledCompany as abap_boolean preserving type) AS IsShareholderControlledCompany,
  BPRelshpCatIsInFwdDirection
FROM P_BPRelshpCompanyIntUnion
;

Learn More