P_CUSTMGMTACTIVITYTEXT
P_CUSTMGMTACTIVITYTEXT is a CDS View in S/4HANA. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_AppointmentActivityText | view | from | COMPOSITE | Appointment Activity Text |
| A_CustMgmtTaskText | view | from | COMPOSITE | Customer Management Task Text |
| A_PhoneCallActivityText | view | from | COMPOSITE | Phone Call Activity Text |
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.sqlViewName: 'PCUSTMGMTACTTEXT'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.privilegedAssociations: ['_Text']
define view P_CustMgmtActivityText
as select from I_CustMgmtActivityEnhcd
association [0..*] to I_TextObjectPlainLongText as _Text on _Text.TextObjectKey <= $projection.TextObjectKeyTimeStamp
and _Text.TextObjectKey >= I_CustMgmtActivityEnhcd.TextObjectKey
and _Text.TextObjectCategory = 'CRM_ORDERH'
and ( _Text.TextObjectType = 'A002' or _Text.TextObjectType = 'A003' or
_Text.TextObjectType = 'A004' or _Text.TextObjectType = 'A005' or
_Text.TextObjectType = 'A006' or _Text.TextObjectType = 'A001' )
and _Text.Language = $session.system_language
{
CustMgmtActivity,
TextObjectKey,
concat(TextObjectKey,' ZZZZZZZZZZZZZZZZZ') as TextObjectKeyTimeStamp,
_Text
}
/* define view P_CustMgmtActivityText
as select from I_CustMgmtActivityEnhcd
association [0..*] to P_CustMgmtTextUUID as _CustMgmtText on I_CustMgmtActivityEnhcd.CustMgmtActivityUUID = _CustMgmtText.TextObjectKeyUUID
and(
_CustMgmtText.TextObjectType = 'A002'
or _CustMgmtText.TextObjectType = 'A003'
or _CustMgmtText.TextObjectType = 'A004'
or _CustMgmtText.TextObjectType = 'A005'
)
{
key CustMgmtActivity,
CustMgmtActivityUUID,
_CustMgmtText.TextObjectKey,
_CustMgmtText.TextObjectType
}
*/