I_CADISPUTECASE

CDS View

Dispute Case Attribute

I_CADISPUTECASE is a CDS View in S/4HANA. Dispute Case Attribute. It contains 54 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 54 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CADisputeCaseContact view from COMPOSITE Dispute Case Contact
I_CADisputeCaseFllwUpPosting view inner COMPOSITE Disputed Follow Up Posting Document
I_CADisputeCaseTP view from TRANSACTIONAL Draft View for Dispute Cases
R_CADisputeCaseTP view_entity from TRANSACTIONAL Dispute case

Fields (54)

KeyField CDS FieldsUsed in Views
KEY CaseUUID CaseUUID 2
BusinessPartner BusinessPartner 1
BusinessPartnerFullName BusinessPartnerFullName 1
CAApplicationArea CAApplicationArea 1
CAContract CAContract 1
CADisputeCase CADisputeCase 1
CADisputeType CADisputeType 1
CADisputeTypeText CADisputeTypeText 1
CARemainingDisputedAmount CARemainingDisputedAmount 1
CaseAuthorizationLevel CaseAuthorizationLevel 1
CaseCategory CaseCategory 1
CaseClosedBy CaseClosedBy 1
CaseClosedTime CaseClosedTime 1
CaseCreatedBy CaseCreatedBy 1
CaseCreationDate CaseCreationDate 1
CaseExternalReference CaseExternalReference 1
CaseID CaseID 1
CaseLastChangedBy CaseLastChangedBy 1
CaseLastChangedOn CaseLastChangedOn 1
CasePlannedCloseDate CasePlannedCloseDate 1
CasePriority CasePriority 1
CaseProcessingDeadlineDate CaseProcessingDeadlineDate 1
CaseProcessor CaseProcessor 1
CaseReason CaseReason,IncorrectDocCaseReason,MissingDocCaseReason 1
CaseResponsible CaseResponsible 1
CaseStatus CaseStatus 1
CaseStatusProfile CaseStatusProfile 1
CaseSystemStatus CaseSystemStatus 1
CaseTitle CaseTitle 1
CaseType CaseType 1
CaseUserStatusName CaseUserStatusName 1
CompanyCode CompanyCode 1
CompanyCodeName CompanyCodeName 1
ContactPersonEmailAddress ContactPersonEmailAddress 2
ContactPersonFaxCountry ContactPersonFaxCountry 2
ContactPersonFaxNumber ContactPersonFaxNumber 2
ContactPersonFullName ContactPersonFullName 2
ContactPersonPhoneNumber ContactPersonPhoneNumber 2
ContractAccount ContractAccount 1
ContractAccountName ContractAccountName 1
CountryName CountryName 1
CreditedAmount CreditedAmount 1
DisputeCaseCoordinator DisputeCaseCoordinator 1
DisputeCaseCorrectionAmount DisputeCaseCorrectionAmount 1
DisputeCaseCurrency DisputeCaseCurrency 1
DisputeCaseReplacedAmount DisputeCaseReplacedAmount 1
DisputeCaseReversedAmount DisputeCaseReversedAmount 1
DisputeCaseRootCause DisputeCaseRootCause 1
DisputeCaseTransactionDate DisputeCaseTransactionDate 1
DisputedAmount DisputedAmount 1
LogicalSystem LogicalSystem 1
PaidAmount PaidAmount 1
TotalReceivablesAmount TotalReceivablesAmount 1
WriteOffAmount WriteOffAmount 1 
@AbapCatalog.sqlViewName: 'ICADISPUTECASE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Dispute Case Attribute'

define view I_CADisputeCase as select from P_CADisputeCaseAttribute 
  association [0..1] to I_User                as _CaseProcessor             on $projection.CaseProcessor = _CaseProcessor.UserID
  association [0..1] to I_User                as _CaseResponsible           on $projection.CaseResponsible = _CaseResponsible.UserID
  association [0..1] to I_User                as _DisputeCaseCoordinator    on $projection.DisputeCaseCoordinator = _DisputeCaseCoordinator.UserID
  association [0..1] to I_User                as _CaseCreatedBy             on $projection.CaseCreatedBy = _CaseCreatedBy.UserID
  association [0..1] to I_User                as _CaseLastChangedBy         on $projection.CaseLastChangedBy = _CaseLastChangedBy.UserID
  association [0..1] to I_User                as _CaseClosedBy              on $projection.CaseClosedBy = _CaseClosedBy.UserID
  association [1..1] to I_RootCause           as _RootCause                 on  $projection.CaseType = _RootCause.CaseType
                                                                            and $projection.DisputeCaseRootCause = _RootCause.DisputeCaseRootCause  
  association [0..*] to I_CaseIndivStatusText as _CaseIndividualStatusText  on $projection.CaseStatusProfile = _CaseIndividualStatusText.CaseStatusProfile
                                                                            and $projection.CaseStatus = _CaseIndividualStatusText.CaseStatus 
  association [0..*] to I_CADisputeCaseOriginText as _CaseOriginText  on $projection.CADisputeCaseOrigin = _CaseOriginText.CADisputeCaseOrigin                                                                              
    {
      key CaseUUID,
      BusinessPartner,
      ContractAccount,
      cast ( ltrim( CAContract,'0') as fica_vtref preserving type )  as CAContract,
      CAApplicationArea, 
      cast( CASubApplication as subap_kk ) as CASubApplication,
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      DisputedAmount,
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      TotalReceivablesAmount,
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      DisputeCaseCorrectionAmount,
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      DisputeCaseReversedAmount,
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      CreditedAmount, 
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      WriteOffAmount,
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      DisputeCaseReplacedAmount,
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      PaidAmount,
      @Semantics.amount.currencyCode: 'DisputeCaseCurrency'
      CARemainingDisputedAmount, 
      @Semantics.currencyCode: true
      DisputeCaseCurrency,
      LogicalSystem,
//      CADisputeType,

      CompanyCode,
      DisputeCaseCoordinator,
      _DisputeCaseCoordinator.UserDescription as DsputCaseCoordinatorFullName,
      DisputeCaseRootCause,
      _RootCause._Text[1:Language = $session.system_language].CaseRootCauseDescription,
      DisputeCaseRootCause as MissingDocCaseRootCause,
      DisputeCaseRootCause as IncorrectDocCaseRootCause,      
      CaseProcessingDeadlineDate,  
      ContactPersonFullName,
      ContactPersonEmailAddress,
      ContactPersonPhoneNumber,
      ContactPersonFaxNumber,
      ContactPersonFaxCountry, 
      DisputeCaseBPCorrespondenceKey,
      DisputeCaseInformationText,
      DisputeCaseTransactionDate,
      cast( CADisputeType as fica_dispute_type_gfn ) as CADisputeType,
      CADisputeCase,
      CaseType,
      CaseID,
      CaseExternalReference,
      CaseCreatedBy,
      _CaseCreatedBy.UserDescription as CaseCreatedByUserName,
      CaseCreationDate,
      CaseLastChangedBy,
      _CaseLastChangedBy.UserDescription as CaseLastChangedByUserName,
      @Semantics: { systemDateTime: { lastChangedAt: true } }
      cast( CaseLastChangedOn as coll_pr_changed_at preserving type )              as CaseLastChangedOn,
//      CaseLastChangedOn,

      CaseStatusProfile,
      CaseClosedBy,
      _CaseClosedBy.UserDescription as CaseClosedByUserName,
      CaseClosedTime,
      CasePlannedCloseDate,
      CaseProcessor,
      _CaseProcessor.UserDescription as CaseProcessorName,
      CaseResponsible,
      _CaseResponsible.UserDescription as CaseResponsibleName,
      CaseTitle,
      CaseAuthorizationLevel,
      CaseStatus,
      CaseStatus as MissingDocumentCaseStatus,
      CaseStatus as IncorrectDocumentCaseStatus,
      cast(_CaseIndividualStatusText[1:Language = $session.system_language].CaseStatusName as scmgstat_descr_gfn) as CaseStatusName,
      CaseSystemStatus,
      CaseUserStatusName,
      CasePriority,
      DisputeCasePriorityName, // Display

      CaseCategory,
      DisputeCaseCategoryName,
      CaseCategory as MissingDocCaseCategory,
      CaseCategory as IncorrectDocCaseCategory,      
      CaseReason,
      CaseReasonName,
      CaseReason as MissingDocCaseReason,  
      CaseReason as IncorrectDocCaseReason,      
      CACaseEscltnRsnForMissingDoc,
      CACaseEscltnRsnForIncorrectDoc,    
      CaseEscalationReason,
      DsputCaseEscalationRsnName,
      CADisputeTypeText, 
      BusinessPartnerFullName,
      StreetName,
      HouseNumber,  
      CountryName,
      PostalCode, 
      CityName,
      ContractAccountName,
      CompanyCodeName,
      CACaseConversionStatus,
      CaseIsDisplayOnly,
      CaseIsClosed, 
      CADisputeCaseProcessingIsActv,
      DisputeCaseOrigin,
      CADisputeCaseOrigin,
      _CaseOriginText[1:Language = $session.system_language].CADisputeCaseOriginText,
      //_User.UserDescription,

      _CaseTypes.CaseAttributeProfile,
      _CaseProcessor.UserDescription,
      _Priority,
      _Escalation,
      _Reasons,
      _Category,
//      _CADisputeCaseType,

      _BusinessPartner,
      _ContractAccount,
      _CompCode,
      _Currency,
      _CaseSystemStatus,
      _StatProfile,
      _CaseTypes,
      //_User,

      _CaseProcessor,
      _CaseResponsible,
      _DisputeCaseCoordinator,
      _CaseCreatedBy,
      _CaseLastChangedBy,
      _CaseClosedBy,
      _RootCause,
      _CaseIndividualStatusText,
      _CaseOriginText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADISPUTECASEORIGINTEXT",
"I_CASEINDIVSTATUSTEXT",
"I_CASETYPES",
"I_ROOTCAUSE",
"I_ROOTCAUSETEXT",
"I_USER",
"P_CADISPUTECASEATTRIBUTE"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CADISPUTECASEORIGINTEXT",
"I_CASECATEGORY",
"I_CASEESCALATIONREASON",
"I_CASEINDIVSTATUSTEXT",
"I_CASEPRIORITY",
"I_CASEREASONS",
"I_CASESTATUSPROFILE",
"I_CASESYSTEMSTATUS",
"I_CASETYPES",
"I_COMPANYCODE",
"I_CONTRACTACCOUNTPARTNER",
"I_CURRENCY",
"I_ROOTCAUSE",
"I_USER"
],
"BASE":
[
"P_CADISPUTECASEATTRIBUTE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More