I_DISPUTECASECOMPANYCODEVH

CDS View

Dispute Case Company Code

I_DISPUTECASECOMPANYCODEVH is a CDS View in S/4HANA. Dispute Case Company Code. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_DisputeCaseCompanyCodeVH view_entity from CONSUMPTION Dispute Case Company Code 
@AbapCatalog: { sqlViewName: 'IDCCCMP',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData:       { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'Dispute Case Company Code' }
@VDM: { viewType:  #BASIC,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType:         { serviceQuality: #B,
                                     sizeCategory: #S,
                                     dataClass: #MIXED },
                dataCategory:      #VALUE_HELP,
                resultSet: { sizeCategory: #XS } }
@Search: { searchable: true }
@Consumption: { ranked: true,
                dbHints: [ 'USE_HEX_PLAN' ] }

define view I_DisputeCaseCompanyCodeVH
  as select from knb1
    inner join   t001       on knb1.bukrs = t001.bukrs
    inner join   tfdm_defcc on knb1.bukrs = tfdm_defcc.bukrs

  // VDM Associations

  // Customer

  association [0..1] to I_Customer    as _Customer   on $projection.Customer = _Customer.Customer

  // Customer Value Help

  association [0..1] to I_Customer_VH as _CustomerVH on $projection.Customer = _CustomerVH.Customer

{

      // VDM Fields

      @Search: { defaultSearchElement: true,
                 fuzzinessThreshold:   0.8,
                 ranking:              #LOW }
      @Consumption: { valueHelpDefinition: [ { entity: { name: 'I_Customer_VH',
                                                         element: 'Customer' },
                                               association: '_CustomerVH' } ] }
  key knb1.kunnr as Customer,

      @ObjectModel: { text: { element: [ 'CompanyCodeName' ] } }
      @Search: { defaultSearchElement: true,
                 fuzzinessThreshold:   0.8,
                 ranking:              #HIGH }
  key knb1.bukrs as CompanyCode,

      @Semantics: { text: true }
      @Search: { defaultSearchElement: true,
                 fuzzinessThreshold:   0.8,
                 ranking:              #LOW }
      t001.butxt as CompanyCodeName,

      // Exposed Associations

      _Customer,
      _CustomerVH

}

where
      tfdm_defcc.case_type is not initial
  and tfdm_defcc.subject   = '000'

Learn More