C_CADisputeCaseChangeHist

DDL: C_CADISPUTECASECHANGEHIST Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Dispute Case Change History

C_CADisputeCaseChangeHist is a Consumption CDS View that provides data about "Dispute Case Change History" in SAP S/4HANA. It reads from 1 data source (I_CADisputeCaseProtocol) and exposes 18 fields with key fields DisputeCaseUUID, TableChangeLogKey. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADisputeCaseProtocol I_CADisputeCaseProtocol from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_CAInvcgUserContact _LastChangedByContact $projection.TableChangeLogUser = _LastChangedByContact.ContactCardID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCADISPCASEHIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Dispute Case Change History view
ObjectModel.representativeKey DisputeCaseUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.query.implementedBy ABAP:CL_O2C_FICA_DISPUTE_CHG_HIST view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DisputeCaseUUID DisputeCaseUUID UUID
KEY TableChangeLogKey TableChangeLogKey
TableChangeLogUser TableChangeLogUser
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUserName LastChangedByUserName User Name
TableChangeLogFieldOldValue TableChangeLogFieldOldValue
ChangeDocNewFieldValueText ChangeDocNewFieldValueText
TableChangeLogFieldNewValue TableChangeLogFieldNewValue
ChangeDocOldFieldValueText ChangeDocOldFieldValueText
ParameterValue ParameterValue Value
ParameterName ParameterName Rule Parameter
ObjectName ObjectName Object name
Department _LastChangedByContact Department Department
PhoneNumber _LastChangedByContact PhoneNumber Telephone no.
EmailAddress _LastChangedByContact EmailAddress E-Mail Address
FullName _LastChangedByContact FullName Name
FunctionalTitleName _LastChangedByContact FunctionalTitleName
_LastChangedByContact _LastChangedByContact

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_CADisputeCaseChangeHist.
-- 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_CADisputeCaseChangeHist AS
SELECT
  DisputeCaseUUID,
  TableChangeLogKey,
  TableChangeLogUser,
  LastChangeDateTime,
  LastChangedByUserName,
  TableChangeLogFieldOldValue,
  ChangeDocNewFieldValueText,
  TableChangeLogFieldNewValue,
  ChangeDocOldFieldValueText,
  ParameterValue,
  ParameterName,
  ObjectName,
  _LastChangedByContact.Department AS Department,
  _LastChangedByContact.PhoneNumber AS PhoneNumber,
  _LastChangedByContact.EmailAddress AS EmailAddress,
  _LastChangedByContact.FullName AS FullName,
  _LastChangedByContact.FunctionalTitleName AS FunctionalTitleName
FROM I_CADisputeCaseProtocol
LEFT OUTER JOIN C_CAInvcgUserContact AS _LastChangedByContact ON TableChangeLogUser = _LastChangedByContact.ContactCardID  -- association [0..1]
;

Learn More