C_CollectionsEmailTP

DDL: C_COLLECTIONSEMAILTP Type: view_entity CONSUMPTION
34 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Collections Email - TP

C_CollectionsEmailTP is a Consumption CDS View that provides data about "Collections Email - TP" in SAP S/4HANA. It reads from 1 data source (R_CollectionsEmailTP) and exposes 34 fields with key field EmailUUID. It is exposed through 1 OData service (UI_COLLECTIONS_EMAIL). It is used in 1 Fiori application: Manage Collections Emails.

Data Sources (1)

SourceAliasJoin Type
R_CollectionsEmailTP R_CollectionsEmailTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Collections Email - TP view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey EmailUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
Search.searchable true view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_COLLECTIONS_EMAIL UI_COLLECTIONS_EMAIL V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F6120 Manage Collections Emails Transactional

Manage Collections Emails

Business Role: Others

Use this new app to send emails as part of the cash collection process in SAP Collections Management. To improve the communication with the customer, you have the option to include several types of attachments, for example, billing documents.

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY EmailUUID EmailUUID UUID
CollectionsEmailObjectType CollectionsEmailObjectType
CollectionsEmailObject CollectionsEmailObject
EmailTemplateID EmailTemplateID
Language Language Report Text Language
EmailSubjectText EmailSubjectText
EmailBodyText EmailBodyText
CollsRecipientEmailAddrString CollsRecipientEmailAddrString
CollsCCRcpntEmailAddrString CollsCCRcpntEmailAddrString
CollsBCCRcpntEmailAddrString CollsBCCRcpntEmailAddrString
CollsSenderEmailAddressString CollsSenderEmailAddressString
EmailCreationDateTime EmailCreationDateTime
EmailLastChangeDateTime EmailLastChangeDateTime
EmailSentDateTime EmailSentDateTime
EmailCreatedByUser EmailCreatedByUser
EmailCreatedByUserFullName _EmailCreatedByUser UserDescription Full Name
EmailLastChangedByUser EmailLastChangedByUser
EmailLastChangedByUserFullName _EmailChangedByUser UserDescription Full Name
EmailSentByUser EmailSentByUser
EmailSentByUserFullName _EmailSentByUser UserDescription Full Name
CollectionsEmailStatus CollectionsEmailStatus
ApplicationLog ApplicationLog Log Number
EmailAttachmentIsZIPFile EmailAttachmentIsZIPFile
virtualLogNumberbalognr
virtualCollsEmailStatusCriticalityint1
LanguageNamelocalized
EmailTemplateNamelocalized
SAPObjectTypeNamelocalized
CollectionsEmailStatusNamelocalized
_Language _Language
_RblsMgmtEmailTemplate _RblsMgmtEmailTemplate
_SAPObjectType _SAPObjectType
_DisputeCase _DisputeCase
_CustomerContact _CustomerContact

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CollectionsEmailTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_CollectionsEmailTP AS
SELECT
  EmailUUID,
  CollectionsEmailObjectType,
  CollectionsEmailObject,
  EmailTemplateID,
  Language,
  EmailSubjectText,
  EmailBodyText,
  CollsRecipientEmailAddrString,
  CollsCCRcpntEmailAddrString,
  CollsBCCRcpntEmailAddrString,
  CollsSenderEmailAddressString,
  EmailCreationDateTime,
  EmailLastChangeDateTime,
  EmailSentDateTime,
  EmailCreatedByUser,
  _EmailCreatedByUser.UserDescription AS EmailCreatedByUserFullName,
  EmailLastChangedByUser,
  _EmailChangedByUser.UserDescription AS EmailLastChangedByUserFullName,
  EmailSentByUser,
  _EmailSentByUser.UserDescription AS EmailSentByUserFullName,
  CollectionsEmailStatus,
  ApplicationLog,
  EmailAttachmentIsZIPFile,
  virtual LogNumber : balognr AS virtualLogNumberbalognr,
  virtual CollsEmailStatusCriticality : int1 AS virtualCollsEmailStatusCriticalityint1,
  _Language._Text.LanguageName : localized AS LanguageNamelocalized,
  _RblsMgmtEmailTemplate._Text.EmailTemplateName : localized AS EmailTemplateNamelocalized,
  _SAPObjectType._Text.SAPObjectTypeName : localized AS SAPObjectTypeNamelocalized,
  _EmailStatus._Text.CollectionsEmailStatusName : localized AS CollectionsEmailStatusNamelocalized
FROM R_CollectionsEmailTP
;

Learn More