P_CUSTOMERTEXT

CDS View

P_CUSTOMERTEXT is a CDS View in S/4HANA. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CustomerText view from COMPOSITE Customer Text
I_BusinessPartnerCustomerTxtTP view from TRANSACTIONAL TP view for Customer long text

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 1
KEY Language Language 1 
@AbapCatalog.sqlViewName: 'PCUSTTEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
//@AccessControl.authorizationCheck: #CHECK

//@EndUserText.label: 'Customer Long Text view'

@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm:#SESSION_VARIABLE


define view P_CustomerText as select from R_TextObjectEmptyText
 
association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner   on  $projection.TextObjectKey = _CustomerToBusinessPartner.Customer
{
key TextObjectCategory,
key TextObjectType      as LongTextID,
key TextObjectKey,
key Language,
key _CustomerToBusinessPartner.Customer as Customer,
PlainLongText           as LongText,
_CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
_CustomerToBusinessPartner._Customer
}
where TextObjectCategory = 'KNA1'



/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMERTOBUSINESSPARTNER",
"R_TEXTOBJECTEMPTYTEXT"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"BASE":
[
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More