C_CADisputeCaseChangeHist

DDL: C_CADISPUTECASECHANGEHIST Type: view CONSUMPTION

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.

1 data source(s) 18 fields

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
KEY TableChangeLogKey TableChangeLogKey
TableChangeLogUser TableChangeLogUser
LastChangeDateTime LastChangeDateTime
LastChangedByUserName LastChangedByUserName
TableChangeLogFieldOldValue TableChangeLogFieldOldValue
ChangeDocNewFieldValueText ChangeDocNewFieldValueText
TableChangeLogFieldNewValue TableChangeLogFieldNewValue
ChangeDocOldFieldValueText ChangeDocOldFieldValueText
ParameterValue ParameterValue
ParameterName ParameterName
ObjectName ObjectName
Department _LastChangedByContact Department
PhoneNumber _LastChangedByContact PhoneNumber
EmailAddress _LastChangedByContact EmailAddress
FullName _LastChangedByContact FullName
FunctionalTitleName _LastChangedByContact FunctionalTitleName
_LastChangedByContact _LastChangedByContact 
@AbapCatalog: { sqlViewName: 'CCADISPCASEHIST',
                compiler: { compareFilter: true },
                preserveKey: true }
@EndUserText.label: 'Dispute Case Change History'
@ObjectModel: { representativeKey: 'DisputeCaseUUID',
                usageType:         { dataClass: #TRANSACTIONAL,
                                     sizeCategory: #L,
                                     serviceQuality: #C },
                query: { implementedBy: 'ABAP:CL_O2C_FICA_DISPUTE_CHG_HIST' }
              }            
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #REQUIRED,
                  privilegedAssociations: ['_LastChangedByContact'] 
                }
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@Metadata: { allowExtensions: true }

define root view C_CADisputeCaseChangeHist
  as select from I_CADisputeCaseProtocol
  association [0..1] to C_CAInvcgUserContact as _LastChangedByContact on $projection.TableChangeLogUser = _LastChangedByContact.ContactCardID
  
{
      @UI: { hidden: true }
      key DisputeCaseUUID,
      @UI: { hidden: true }
      key TableChangeLogKey,        
                    
//      @UI: { lineItem: [ { position: 80,

//                           type:     #AS_CONTACT,

//                           label: 'Changed By'

//                         } ],

//             textArrangement: #TEXT_ONLY }

//      @Consumption: { semanticObject: 'BusinessUser' }

//      @ObjectModel: { foreignKey: { association: '_LastChangedByContact' },

//                      text: { element: [ 'LastChangedByUserName' ] } }

//      @Semantics: { contact: { type: #PERSON },

//                    user: { id: true } }    

      @UI.hidden: true
      TableChangeLogUser,
      
      @UI: { lineItem: [ { position: 90, importance: #HIGH, label: 'Changed At' } ] }
      LastChangeDateTime,
      
            
      @UI: { hidden: true }
      LastChangedByUserName,
      
      @UI: { lineItem: [ { position: 20, importance: #HIGH } ],
             textArrangement: #TEXT_LAST  }
      @ObjectModel: { text: { element: [ 'ChangeDocOldFieldValueText' ] } }
      TableChangeLogFieldOldValue,
      
      @UI: { hidden: true }
      ChangeDocNewFieldValueText,

      @UI: { lineItem: [ { position: 30, importance: #HIGH } ],
             textArrangement: #TEXT_LAST  }
      @ObjectModel: { text: { element: [ 'ChangeDocNewFieldValueText' ] } }
      TableChangeLogFieldNewValue,
      
      @UI: { hidden: true }
      ChangeDocOldFieldValueText,

//      @UI: { lineItem: [ { position: 40 } ],

//             textArrangement: #TEXT_ONLY  }

//      @ObjectModel: { text: { element: [ 'ParameterName' ] } }

      @UI: { hidden: true }
      ParameterValue,
      
      @UI: { lineItem: [ { position: 40, label: 'Activity', importance: #HIGH } ] }
      ParameterName,

      @UI: { lineItem: [ { position: 10, label: 'Field Name', importance: #HIGH } ] }
      ObjectName,
      
      @Semantics: { organization: { name: true } }
      @UI: { hidden: true }
      _LastChangedByContact.Department,
      
      @Semantics.telephone.type:  [ #WORK ]
      @UI: { hidden: true }
      _LastChangedByContact.PhoneNumber,

      @Semantics: { eMail: { type: [ #WORK ],
                            address: true } }
      @UI: { hidden: true }
      _LastChangedByContact.EmailAddress,
      
      @Semantics: { name: { fullName: true } }
      @UI: { hidden: true }
      _LastChangedByContact.FullName,
      
      @Semantics: { organization: { role: true } }
      @UI: { hidden: true }
      _LastChangedByContact.FunctionalTitleName,     
      
       //Associations

      @UI:{ lineItem: [ {position: 80, importance: #HIGH, type: #AS_CONTACT, value: '.', label: 'Changed By' } ] }
      @Consumption.filter.hidden: true
      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false
      _LastChangedByContact
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CAINVCGUSERCONTACT",
"I_CADISPUTECASEPROTOCOL"
],
"ASSOCIATED":
[
"C_CAINVCGUSERCONTACT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More