P_BUSINESSPARTNERLONGTEXT

CDS View

CDS view for Long Texts (Notes) in Business Partner App

P_BUSINESSPARTNERLONGTEXT is a CDS View in S/4HANA. CDS view for Long Texts (Notes) in Business Partner App. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BusinessPartnerLongTextTP view from TRANSACTIONAL TP view for Business Partner long text
@AbapCatalog.sqlViewName: 'PBPTEXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

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

define view P_BusinessPartnerLongText as select from R_TextObjectEmptyText 

association [1..1] to I_BusinessPartner as _BusinessPartner   on  $projection.TextObjectKey = _BusinessPartner.BusinessPartner
{
    key TextObjectCategory,
    key TextObjectType      as LongTextID,
    key TextObjectKey,
    key Language,
    key _BusinessPartner.BusinessPartner as BusinessPartner,
    
    PlainLongText           as LongText,
    _BusinessPartner
}
where TextObjectCategory = 'BUT000'