I_CommissionBusinessPartnerVH

DDL: I_COMMISSIONBUSINESSPARTNERVH Type: view_entity BASIC
22 Fields 2 Data Sources

Commission Business Partner

I_CommissionBusinessPartnerVH is a Basic CDS View that provides data about "Commission Business Partner" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner, I_BusinessPartner_to_BP_Role) and exposes 22 fields with key field BusinessPartner.

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner _businesspartner from
I_BusinessPartner_to_BP_Role _BusinessPartnerRole inner

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Commission Business Partner view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BusinessPartner view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Consumption.ranked true view
OData.entityType.name I_CommsnBusinessPartnerVH view
Analytics.technicalName ICOMMSNBPVH view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerRole I_BusinessPartner_to_BP_Role BusinessPartnerRole BP Role
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory Business Partner Category
AuthorizationGroup I_BusinessPartner AuthorizationGroup AuthorizGroup
BusinessPartnerUUID I_BusinessPartner BusinessPartnerUUID UUID
PersonNumber I_BusinessPartner PersonNumber Person Number
BusinessPartnerName I_BusinessPartner BusinessPartnerName Business Partner Name
BusinessPartnerFullName I_BusinessPartner BusinessPartnerFullName Business Partner Full Name
FirstName I_BusinessPartner FirstName First Name Business Partner (Person)
LastName I_BusinessPartner LastName Last Name Business Partner (Person)
PersonFullName I_BusinessPartner PersonFullName Full Name
BirthDate I_BusinessPartner BirthDate Date of Birth
_BPCreditWorthiness I_BusinessPartner _BPCreditWorthiness
_BPEmployment I_BusinessPartner _BPEmployment
_BPFinancialServicesExt I_BusinessPartner _BPFinancialServicesExt
_BPFinancialServicesExtn I_BusinessPartner _BPFinancialServicesExtn
_BPRating I_BusinessPartner _BPRating
_BuPaIdentification I_BusinessPartner _BuPaIdentification
_BusinessPartnerIndustry I_BusinessPartner _BusinessPartnerIndustry
_BusinessPartnerRole I_BusinessPartner _BusinessPartnerRole
_CurrentDefaultAddress I_BusinessPartner _CurrentDefaultAddress
_DefaultAddress I_BusinessPartner _DefaultAddress

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_CommissionBusinessPartnerVH.
-- 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_CommissionBusinessPartnerVH AS
SELECT
  _businesspartner.BusinessPartner AS BusinessPartner,
  _BusinessPartnerRole.BusinessPartnerRole AS BusinessPartnerRole,
  _businesspartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  _businesspartner.AuthorizationGroup AS AuthorizationGroup,
  _businesspartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _businesspartner.PersonNumber AS PersonNumber,
  _businesspartner.BusinessPartnerName AS BusinessPartnerName,
  _businesspartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _businesspartner.FirstName AS FirstName,
  _businesspartner.LastName AS LastName,
  _businesspartner.PersonFullName AS PersonFullName,
  _businesspartner.BirthDate AS BirthDate,
  _businesspartner._BPCreditWorthiness AS _BPCreditWorthiness,
  _businesspartner._BPEmployment AS _BPEmployment,
  _businesspartner._BPFinancialServicesExt AS _BPFinancialServicesExt,
  _businesspartner._BPFinancialServicesExtn AS _BPFinancialServicesExtn,
  _businesspartner._BPRating AS _BPRating,
  _businesspartner._BuPaIdentification AS _BuPaIdentification,
  _businesspartner._BusinessPartnerIndustry AS _BusinessPartnerIndustry,
  _businesspartner._BusinessPartnerRole AS _BusinessPartnerRole,
  _businesspartner._CurrentDefaultAddress AS _CurrentDefaultAddress,
  _businesspartner._DefaultAddress AS _DefaultAddress
FROM I_BusinessPartner AS _businesspartner
INNER JOIN I_BusinessPartner_to_BP_Role AS _BusinessPartnerRole ON /* join condition not captured in parsed metadata */
;

Learn More