R_ACMBusPartValues

DDL: R_ACMBUSPARTVALUES SQL: RACMBUSPARTVALS Type: view BASIC

CDS view for Counterparty Type Values for BP

R_ACMBusPartValues is a Basic CDS View that provides data about "CDS view for Counterparty Type Values for BP" in SAP S/4HANA. It reads from 2 data sources (but000, /accgo/t_bp_type) and exposes 6 fields with key field BusinessPartnerNumber.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
but000 BusinessPartnerDetails inner
/accgo/t_bp_type BusinessPartnerValues from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName RACMBUSPARTVALS view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label CDS view for Counterparty Type Values for BP view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerNumber bu_partner
BusinessPartnerClassification cp_classification
ACMBusinessPartnerType
ACMOnboardRelevant /accgo/t_bp_type onboarded_relevant
IsBlocked but000 xblck
BPIsCentrallyArchived but000 xdele 
@AbapCatalog.sqlViewName: 'RACMBUSPARTVALS'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'CDS view for Counterparty Type Values for BP'
define view R_ACMBusPartValues
  as select from /accgo/t_bp_type as BusinessPartnerValues
    inner join   but000           as BusinessPartnerDetails on BusinessPartnerValues.bu_partner = BusinessPartnerDetails.partner
{
  key bu_partner                               as BusinessPartnerNumber,
      cp_classification                        as BusinessPartnerClassification,
      cast( cp_type as abap.char(60) )         as ACMBusinessPartnerType,
      BusinessPartnerValues.onboarded_relevant as ACMOnboardRelevant,
      BusinessPartnerDetails.xblck             as IsBlocked,
      BusinessPartnerDetails.xdele             as BPIsCentrallyArchived
       
}

Learn More