R_CompanySubstanceTextTP

DDL: R_COMPANYSUBSTANCETEXTTP Type: view_entity TRANSACTIONAL

Company Substance Name - TP

R_CompanySubstanceTextTP is a Transactional CDS View that provides data about "Company Substance Name - TP" in SAP S/4HANA. It reads from 1 data source (I_SubstanceText) and exposes 5 fields with key fields CompanySubstanceUUID, Language.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_SubstanceText I_SubstanceText from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Company Substance Name - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #TEXT view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanySubstanceUUID SubstanceUUID
KEY Language Language
CompanySubstanceName SubstanceName
_Language _Language
_CompanySubstance _CompanySubstance 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Company Substance Name - TP'

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED // Selected because parent is MIXED but I_SubstanceText is #MASTER

}

@ObjectModel.dataCategory: #TEXT

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL }
define view entity R_CompanySubstanceTextTP
  as select from I_SubstanceText
  association to parent R_CompanySubstanceTP as _CompanySubstance on $projection.CompanySubstanceUUID = _CompanySubstance.CompanySubstanceUUID
{

      // UUID of company substance

  key SubstanceUUID as CompanySubstanceUUID,

      // Language for company substance name

  key Language      as Language,

      // Company substance name

      SubstanceName as CompanySubstanceName,

      /*** Associations ***/
      _Language,
      
      // To parent

      _CompanySubstance
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUBSTANCETEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"R_COMPANYSUBSTANCETP"
],
"BASE":
[
"I_SUBSTANCETEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More