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. It is exposed through 1 OData service (UI_FREIGHTORDER_ACCR). It is used in 1 Fiori application: Monitor Freight Documents for Accrual.

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_FREIGHTORDER_ACCR UI_FREIGHTORDER_ACCR V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4329 Monitor Freight Documents for Accrual Transactional

Monitor Freight Documents for Accrual

Business Role: Transportation Manager (Transportation Management)

With this app, you can monitor your freight documents to post accruals. You can confirm a freight document to post the freight cost to Financial Accounting for accruals. You can monitor your freight documents in case there are errors during the posting process. To post the freight costs to Financial Accounting, you must confirm that the charges for a freight document are a correct reflection of the planned costs to be paid to the carrier. When you confirm a freight document for posting, the system posts the freight costs to Financial Accounting. You can also identify freight documents for which you have successfully posted the freight costs.

Key Features: Confirm freight costs for posting to Financial Accounting for accruals View freight documents that are successfully posted to Financial Accounting Cancel postings for freight documents that are successfully posted to Financial Accounting Monitor freight documents that have errors when you post them to Financial Accounting Display the errors that the system encountered when it posted your freight documents Post or cancel posting for freight documents for which the system encountered errors during posting

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'