C_BusinessPartnerCustCoText

DDL: C_BUSINESSPARTNERCUSTCOTEXT SQL: CBPCUSTCCTEXT Type: view CONSUMPTION

C view for Customer company code texts

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

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerCustCoTextTP I_BusinessPartnerCustCoTextTP from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartnerCustCo _BusinessPartnerCustomerCo $projection.BusinessPartner = _BusinessPartnerCustomerCo.BusinessPartner and $projection.CompanyCode = _BusinessPartnerCustomerCo.CompanyCode
[0..*] I_TextObjectTypeText _TextIDDescription $projection.LongTextID = _TextIDDescription.TextObjectType and _TextIDDescription.TextObjectCategory = 'KNB1'

Annotations (18)

NameValueLevelField
EndUserText.label C view for Customer company code texts view
AbapCatalog.sqlViewName CBPCUSTCCTEXT 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
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY CompanyCode CompanyCode
KEY Customer Customer
KEY Language Language
KEY LongTextID LongTextID
LongText LongText
BusinessPartnerForEdit BusinessPartnerForEdit
CompanyCodeForEdit CompanyCodeForEdit
LongTextIDForEdit LongTextIDForEdit
LanguageForEdit LanguageForEdit
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomerCo _BusinessPartnerCustomerCo
_TextIDDescription _TextIDDescription 
@EndUserText.label: 'C view for Customer company code texts'

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

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

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
    semanticKey: ['BusinessPartner','CompanyCode', 'Language', 'LongTextID'],
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true
}
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

/*@UI.headerInfo:{
  typeName: 'Company Code',
  typeNamePlural: 'Company Codes',
  title:  { label: 'Company Code Description', value: '_CompanyCodeValueHelp.CompanyCodeName' }
  }*/

@VDM.viewType: #CONSUMPTION

define view C_BusinessPartnerCustCoText
    as select from I_BusinessPartnerCustCoTextTP  
 
 association [1..1] to C_BusinessPartner           as _BusinessPartner           on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
 
 association [1..1] to C_BusinessPartnerCustomer   as _BusinessPartnerCustomer   on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
 
 association [1..1] to C_BusinessPartnerCustCo     as _BusinessPartnerCustomerCo on  $projection.BusinessPartner = _BusinessPartnerCustomerCo.BusinessPartner
                                                                                  and $projection.CompanyCode     = _BusinessPartnerCustomerCo.CompanyCode
 //association [1..1] to C_CustomerTextObjectType    as _CompanyTextValueHelp       on $projection.LongTextID    =   _CompanyTextValueHelp.TextObjectType

                                                                           //             and _CompanyTextValueHelp.TextObjectCategory = 'KNB1'

 //association [1..1] to C_TextObjectValueHelp        as _TextValueHelp       on $projection.LongTextID =  _TextValueHelp.TextObjectType

  //                                                                               and _TextValueHelp.P_TextObjectCategory = 'KNB1'

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

 //  association [0..*] to C_BPLanguageTextValueHelp  as _LanguageText             on  $projection.Language = _LanguageText.LanguageCode                                                                                                                                                                    

                                                                                  
                                                                                 
{

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

 //@ObjectModel.text.association: '_LanguageText'

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

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

// @ObjectModel.virtualElement

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

 LongText,
 //@ObjectModel.readOnly: true

 //_TextIDDescription.TextObjectTypeName,

 
 BusinessPartnerForEdit,
 CompanyCodeForEdit,
 LongTextIDForEdit,
 LanguageForEdit,

@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
_BusinessPartnerCustomer,

@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
_BusinessPartner,

@ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
_BusinessPartnerCustomerCo,

//_CompanyTextValueHelp,

//_TextValueHelp,

_TextIDDescription
//_LanguageValueHelp

//_LanguageText

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

Learn More