P_CUSTOMERMATERIALLONGTEXT

CDS View

Customer Material Text Active Entity

P_CUSTOMERMATERIALLONGTEXT is a CDS View in S/4HANA. Customer Material Text Active Entity. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CustomerMaterialLongTextTP view from TRANSACTIONAL Customer Material BO Draft Text Node

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Customer Customer,CustomerForEdit 1
KEY DistributionChannel DistributionChannel,DistributionChannelForEdit 1
KEY Language Language,LanguageForEdit 1
KEY LongTextID LongTextID,LongTextIDForEdit 1
KEY SalesOrganization SalesOrganization,SalesOrganizationForEdit 1
LanguageISOCode LanguageISOCode 1
LongText LongText 1 
@AbapCatalog.sqlViewName: 'PSDCUSTMATTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true
define view P_CustomerMaterialLongText as select from stxl 
left outer join  custmat_txt on custmat_txt.material = '????'
{
  
  key substring(stxl.tdname, 1, 4)           as SalesOrganization,
  key substring(stxl.tdname, 5, 2)           as DistributionChannel,
  key substring(stxl.tdname, 7, 10)          as Customer,
  key substring(stxl.tdname, 17, 40)         as Material,
  key cast( stxl.tdspras as spras )          as Language,
      stxl.tdid                              as LongTextID,
      custmat_txt.longtext                   as LongText,  //String casting is not supported. so with a dummy left outer join we bring an empty string to the longtext. this should always be empty

      cast('' as laiso)                      as LanguageISOCode
}

where 
  relid    = 'TX'
  and tdobject = 'KNMT'
  and srtf2    = 0

Learn More