I_DisputeCaseEmailTemplate

DDL: I_DISPUTECASEEMAILTEMPLATE Type: view COMPOSITE
50 Fields 1 Data Sources 1 Associations

Dispute Case Email Template

I_DisputeCaseEmailTemplate is a Composite CDS View that provides data about "Dispute Case Email Template" in SAP S/4HANA. It reads from 1 data source (R_DisputeCase) and exposes 50 fields with key field DisputeCaseUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_DisputeCase R_DisputeCase from

Parameters (1)

NameTypeDefault
P_language lang

Associations (1)

CardinalityTargetAliasCondition
[1] E_DisputeCase _Extension $projection.DisputeCaseUUID = _Extension.DisputeCaseUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IDCMAILTMPL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Dispute Case Email Template view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey DisputeCaseUUID view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY DisputeCaseUUID DisputeCaseUUID UUID
CaseID CaseID Case ID
CaseExternalReference CaseExternalReference External Reference
DisputeCaseCoordinator DisputeCaseCoordinator Coordinator
DsputCaseCoordinatorFullName _DisputeCaseCoordinatorCard FullName Name
DisputeCaseRootCause DisputeCaseRootCause Root Cause Code
CaseRootCauseDescription
CaseProcessingDeadlineDate CaseProcessingDeadlineDate Process. Deadline
OriginalAmount OriginalAmount Original Disputed Amount
DisputedAmount DisputedAmount Disputed Amount
PaidAmount PaidAmount Paid Amount
CreditedAmount CreditedAmount Credited
WriteOffAmount WriteOffAmount Cleared Manually
ManuallyClearedAmount ManuallyClearedAmount Automatically Written Off
DisputeCaseCurrency DisputeCaseCurrency Currency
ContactPersonName ContactPersonName Full Name
ContactPersonEmailAddress ContactPersonEmailAddress Email
ContactPersonPhoneNumber ContactPersonPhoneNumber Telephone No.
ContactPersonFaxNumber ContactPersonFaxNumber Fax Number
ContactPersonFaxCountry ContactPersonFaxCountry C/R of Fax No.
ContactPerson Contact Person Key
Customer Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
DisputeCaseExternalApplication DisputeCaseExternalApplication External Appl.
DisputeCaseExtApplName
CaseType CaseType Upper/Lowercase
CaseTypeName
CaseReason CaseReason Reason
CaseReasonName
CaseEscalationReason CaseEscalationReason Escalation Reason
CaseEscalationReasonName
CaseCategory CaseCategory Category
CaseCategoryName
CasePriority CasePriority Priority
CasePriorityName
CaseStatus CaseStatus Status
CaseStatusName
CaseCreatedBy CaseCreatedBy Created By
CreatedByUserName _CreatedByContactCard FullName Name
CaseLastChangedBy CaseLastChangedBy Changed By
LastChangedByUserName _ChangedByContactCard FullName Name
CaseClosedBy CaseClosedBy Closed By
DisputeCaseClosedByUserName _ClosedByContactCard FullName Name
CaseProcessor CaseProcessor Processor
DisputeCaseProcessorFullName _ProcessorContactCard FullName Name
CaseResponsible CaseResponsible Person Responsible
DisputeCaseResponsibleFullName _ResponsibleContactCard FullName Name
UserDefinedText

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 I_DisputeCaseEmailTemplate.
-- 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.
-- Parameters: P_language : lang

CREATE VIEW I_DisputeCaseEmailTemplate AS
SELECT
  DisputeCaseUUID,
  CaseID,
  CaseExternalReference,
  DisputeCaseCoordinator,
  _DisputeCaseCoordinatorCard.FullName AS DsputCaseCoordinatorFullName,
  DisputeCaseRootCause,
  _RootCause._Text[1:Language=$parameters.P_language].CaseRootCauseDescription AS CaseRootCauseDescription,
  CaseProcessingDeadlineDate,
  OriginalAmount,
  DisputedAmount,
  PaidAmount,
  CreditedAmount,
  WriteOffAmount,
  ManuallyClearedAmount,
  DisputeCaseCurrency,
  ContactPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  cast( ContactPerson as parnr ) AS ContactPerson,
  Customer,
  _Customer.CustomerName AS CustomerName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  DisputeCaseExternalApplication,
  _DisputeCaseExternalAppl._Text[1:Language=$parameters.P_language].DisputeCaseExtApplName AS DisputeCaseExtApplName,
  CaseType,
  _CaseTypes._Text[1:Language=$parameters.P_language].CaseTypeName AS CaseTypeName,
  CaseReason,
  _Reasons._Text[1:Language=$parameters.P_language].CaseReasonName AS CaseReasonName,
  CaseEscalationReason,
  _Escalation._Text[1:Language=$parameters.P_language].CaseEscalationReasonName AS CaseEscalationReasonName,
  CaseCategory,
  _CaseCategory._Text[1:Language=$parameters.P_language].CaseCategoryName AS CaseCategoryName,
  CasePriority,
  _Priority._Text[1:Language=$parameters.P_language].CasePriorityName AS CasePriorityName,
  CaseStatus,
  _Individual._Text[1:Language=$parameters.P_language].CaseStatusName AS CaseStatusName,
  CaseCreatedBy,
  _CreatedByContactCard.FullName AS CreatedByUserName,
  CaseLastChangedBy,
  _ChangedByContactCard.FullName AS LastChangedByUserName,
  CaseClosedBy,
  _ClosedByContactCard.FullName AS DisputeCaseClosedByUserName,
  CaseProcessor,
  _ProcessorContactCard.FullName AS DisputeCaseProcessorFullName,
  CaseResponsible,
  _ResponsibleContactCard.FullName AS DisputeCaseResponsibleFullName,
  '' AS UserDefinedText
FROM R_DisputeCase
LEFT OUTER JOIN E_DisputeCase AS _Extension ON DisputeCaseUUID = _Extension.DisputeCaseUUID  -- association [1]
;

Learn More