C_TranspServiceProviderVH

DDL: C_TRANSPSERVICEPROVIDERVH Type: view CONSUMPTION

Carrier or Service Provider

C_TranspServiceProviderVH is a Consumption CDS View that provides data about "Carrier or Service Provider" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner, I_BusinessPartner_to_BP_Role) and exposes 9 fields with key field BusinessPartner.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner BusinessPartner from
I_BusinessPartner_to_BP_Role BusinessPartnerRole inner

Annotations (13)

NameValueLevelField
EndUserText.label Carrier or Service Provider view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CTRNSPSRVPRVDRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BusinessPartner view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner
BusinessPartnerName
PostalCode
CityName
Country Country/Region
SearchTerm1 SearchTerm1
SearchTerm2 SearchTerm2
AuthorizationGroup I_BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted 
@EndUserText:   {label:  'Carrier or Service Provider'}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog:   {sqlViewName:        'CTRNSPSRVPRVDRVH',
                 compiler.compareFilter: true,
                 preserveKey:true        }
@ObjectModel: {dataCategory: #VALUE_HELP,
               representativeKey: 'BusinessPartner',
               usageType:  { serviceQuality: #C,
                              sizeCategory: #XL,
                              dataClass: #MASTER}
              }
@VDM:           {viewType:          #CONSUMPTION}
@AccessControl: {authorizationCheck: #CHECK,
                 personalData.blocking: #REQUIRED}

define view C_TranspServiceProviderVH
  as select from I_BusinessPartner            as BusinessPartner
    inner join   I_BusinessPartner_to_BP_Role as BusinessPartnerRole on BusinessPartnerRole.BusinessPartner = BusinessPartner.BusinessPartner
{
      @EndUserText: { quickInfo: 'Carrier/Service Provider ID',
                      label: 'Carrier/Service Provider ID' }
  key BusinessPartner.BusinessPartner,

      @EndUserText: { quickInfo: 'Carrier/Service Provider Name',
                      label: 'Carrier/Service Provider Name' }
      cast(BusinessPartner.BusinessPartnerName as /scmtms/vdm_carrier_name preserving type ) as BusinessPartnerName,

      _CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode,
      _CurrentDefaultAddress._AddressDefaultRepresentation.CityName,
      @EndUserText.label: 'Country/Region'
      _CurrentDefaultAddress._AddressDefaultRepresentation.Country,

      @EndUserText.quickInfo: 'Search Term 1 for Carrier/Service Provider'
      SearchTerm1,

      @EndUserText.quickInfo: 'Search Term 2 for Carrier/Service Provider'
      SearchTerm2,

      @UI.hidden: true
      BusinessPartner.AuthorizationGroup,
      @UI.hidden: true
      BusinessPartner.IsBusinessPurposeCompleted
}
where
  BusinessPartnerRole._BusinessPartnerRole.RoleCategory = 'CRM010'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERROLE",
"I_BUSINESSPARTNER_TO_BP_ROLE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More