C_BusinessPartnerCustomerTxt

DDL: C_BUSINESSPARTNERCUSTOMERTXT SQL: CBPCUSTTEXT Type: view CONSUMPTION

C view for Customer texts

C_BusinessPartnerCustomerTxt is a Consumption CDS View that provides data about "C view for Customer texts" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerCustomerTxtTP) and exposes 13 fields with key fields BusinessPartner, Language, LongTextID, Customer. It has 3 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerCustomerTxtTP I_BusinessPartnerCustomerTxtTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_TextObjectTypeText _TextIDDescription $projection.LongTextID = _TextIDDescription.TextObjectType and _TextIDDescription.TextObjectCategory = 'KNA1' and _TextIDDescription.Language = $session.system_language

Annotations (17)

NameValueLevelField
EndUserText.label C view for Customer texts view
AbapCatalog.sqlViewName CBPCUSTTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY Language Language
KEY LongTextID LongTextID
KEY Customer Customer
LongText LongText
BusinessPartnerForEdit BusinessPartnerForEdit
LongTextIDForEdit LongTextIDForEdit
LanguageForEdit LanguageForEdit
TextObjectCategory TextObjectCategory
CustomerAccountGroup CustomerAccountGroup
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_TextIDDescription _TextIDDescription 
@EndUserText.label: 'C view for Customer texts'

@AbapCatalog.sqlViewName: 'CBPCUSTTEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.allowExtensions: true

@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    transactionalProcessingDelegated:true,
    semanticKey: ['BusinessPartner','Language', 'LongTextID'],
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    usageType.serviceQuality: #A,
    usageType.sizeCategory : #L,
    usageType.dataClass: #MASTER
}

@Search.searchable: true

define view C_BusinessPartnerCustomerTxt as select from I_BusinessPartnerCustomerTxtTP 

association [1..1] to C_BusinessPartnerCustomer    as _BusinessPartnerCustomer    on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
  
association [1..1] to C_BusinessPartner            as _BusinessPartner            on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//association [0..*] to I_TextObjectType             as _CustomerTextValueHelp       on $projection.LongTextID    =   _CustomerTextValueHelp.TextObjectType 

  //                                                                              and _CustomerTextValueHelp.TextObjectCategory = 'KNA1'

association [0..1] to I_TextObjectTypeText         as _TextIDDescription       on  $projection.LongTextID     = _TextIDDescription.TextObjectType
                                                                                and _TextIDDescription.TextObjectCategory = 'KNA1' and _TextIDDescription.Language = $session.system_language
//association [0..*] to I_Language                as _LanguageValueHelp           on $projection.Language =   _LanguageValueHelp.Language                                                                                                                                                                    

  {

  key BusinessPartner,
//  @ObjectModel.foreignKey.association: '_LanguageValueHelp'

  key Language,
//  @ObjectModel.foreignKey.association: '_CustomerTextValueHelp'

  @ObjectModel.text.association: '_TextIDDescription'
  key LongTextID,
  key Customer,
  //@ObjectModel.readOnly: true

  //@ObjectModel.virtualElement

  //@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_S4H_STXL_READ'

  LongText,

  //LongText  as  LongTextEdit,

  
  BusinessPartnerForEdit,
  
  LongTextIDForEdit,
  
  LanguageForEdit,
  
  TextObjectCategory,
  
  CustomerAccountGroup,

 @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
 _BusinessPartnerCustomer,
 
 
 @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
 _BusinessPartner,
 
 //_CustomerTextValueHelp,

 _TextIDDescription
 //_LanguageValueHelp


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERCUSTOMERTXTTP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER",
"I_TEXTOBJECTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More