A_ChgRecdBusinessPartner

DDL: A_CHGRECDBUSINESSPARTNER Type: view_entity COMPOSITE

Change Record Business Partner

A_ChgRecdBusinessPartner is a Composite CDS View that provides data about "Change Record Business Partner" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner_to_BP_Role, I_BusinessPartner) and exposes 5 fields with key field Partner.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner_to_BP_Role BusinessPartnerToBPRole inner
I_BusinessPartner I_BusinessPartner from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Change Record Business Partner view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Feature BF:API_FULLSCOPE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Partner I_BusinessPartner BusinessPartner
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory
AuthorizationGroup I_BusinessPartner AuthorizationGroup
BusinessPartnerIsBlocked I_BusinessPartner BusinessPartnerIsBlocked
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Change Record Business Partner'
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Feature: 'BF:API_FULLSCOPE'
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MASTER,
                         sizeCategory: #L}
define view entity A_ChgRecdBusinessPartner
  as select from I_BusinessPartner
    inner join   I_BusinessPartner_to_BP_Role as BusinessPartnerToBPRole on  I_BusinessPartner.BusinessPartner           = BusinessPartnerToBPRole.BusinessPartner
                                                                         and BusinessPartnerToBPRole.BusinessPartnerRole = 'BUP003'
{
  key I_BusinessPartner.BusinessPartner as Partner,

      I_BusinessPartner.BusinessPartnerCategory,

      I_BusinessPartner.AuthorizationGroup,

      I_BusinessPartner.BusinessPartnerIsBlocked,

      I_BusinessPartner.IsBusinessPurposeCompleted
}
where
      I_BusinessPartner.BusinessPartnerCategory =  '1'
  and BusinessPartnerToBPRole.ValidFrom         <= tstmp_current_utctimestamp()
  and BusinessPartnerToBPRole.ValidTo           >  tstmp_current_utctimestamp()

Learn More