C_CollsEmailCorrespncTypeTP

DDL: C_COLLSEMAILCORRESPNCTYPETP Type: view_entity CONSUMPTION
7 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Collections Email Correspondence Type

C_CollsEmailCorrespncTypeTP is a Consumption CDS View that provides data about "Collections Email Correspondence Type" in SAP S/4HANA. It reads from 1 data source (R_CollsEmailCorrespncTypeTP) and exposes 7 fields with key fields EmailUUID, EmailCorrespondenceUUID. It has 1 association to related views. 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_CollsEmailCorrespncTypeTP R_CollsEmailCorrespncTypeTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_CollsEmlFinCorrespncPreview _Preview $projection.EmailUUID = _Preview.EmailUUID and $projection.CorrespondenceType = _Preview.CorrespondenceType

Annotations (7)

NameValueLevelField
Metadata.allowExtensions true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Collections Email Correspondence Type view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL 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 (7)

KeyFieldSource TableSource FieldDescription
KEY EmailUUID EmailUUID UUID
KEY EmailCorrespondenceUUID EmailCorrespondenceUUID UUID
CorrespondenceType CorrespondenceType Corresp. Identifier
CollectionsEmailObjectType _CollectionsEmail CollectionsEmailObjectType
CollectionsEmailObject _CollectionsEmail CollectionsEmailObject
CorrespondenceTypeDesclocalized
_Preview _Preview

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_CollsEmailCorrespncTypeTP.
-- 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_CollsEmailCorrespncTypeTP AS
SELECT
  EmailUUID,
  EmailCorrespondenceUUID,
  CorrespondenceType,
  _CollectionsEmail.CollectionsEmailObjectType AS CollectionsEmailObjectType,
  _CollectionsEmail.CollectionsEmailObject AS CollectionsEmailObject,
  _CorrespncTypeText.CorrespondenceTypeDesc : localized AS CorrespondenceTypeDesclocalized
FROM R_CollsEmailCorrespncTypeTP
LEFT OUTER JOIN C_CollsEmlFinCorrespncPreview AS _Preview ON EmailUUID = _Preview.EmailUUID AND CorrespondenceType = _Preview.CorrespondenceType  -- association [0..*]
;

Learn More