I_DsputCaseCompanyCodeDfltVal

DDL: I_DSPUTCASECOMPANYCODEDFLTVAL Type: view BASIC

Company Code Default Values

I_DsputCaseCompanyCodeDfltVal is a Basic CDS View that provides data about "Company Code Default Values" in SAP S/4HANA. It reads from 1 data source (tfdm_defcc) and exposes 12 fields with key fields CompanyCode, OriginType. It has 5 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
tfdm_defcc tfdm_defcc from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_CaseType _CaseType $projection.CaseType = _CaseType.CaseType
[0..1] I_CaseCategory _CaseCategory $projection.CaseCategory = _CaseCategory.CaseCategory and $projection.CaseType = _CaseCategory.CaseType
[0..1] I_CaseReason _CaseReason $projection.CaseReason = _CaseReason.CaseReason and $projection.CaseType = _CaseReason.CaseType
[0..1] I_CasePriority _CasePriority $projection.CasePriority = _CasePriority.CasePriority

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IDCCMOCDDF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Company Code Default Values view
VDM.viewType #BASIC 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 CompanyCode view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs
KEY OriginType
CaseType case_type
CaseCategory category
CaseStatus stat_orderno
CaseReason reason_code
CasePriority priority
_CompanyCode _CompanyCode
_CaseType _CaseType
_CaseCategory _CaseCategory
_CaseReason _CaseReason
_CasePriority _CasePriority 
@AbapCatalog: { sqlViewName: 'IDCCMOCDDF',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK }
@EndUserText: { label: 'Company Code Default Values' }
@VDM: { viewType:  #BASIC,
        lifecycle: { contract: { type: #PUBLIC_LOCAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #C,
                             sizeCategory: #S,
                             dataClass: #MIXED },
                semanticKey: [ 'CompanyCode' ],
                representativeKey: 'CompanyCode' }

define view I_DsputCaseCompanyCodeDfltVal
  as select from tfdm_defcc

  // VDM Associations

  // Company Code

  association [0..1] to I_CompanyCode          as _CompanyCode          on  $projection.CompanyCode = _CompanyCode.CompanyCode

  // Case Type

  association [0..1] to I_CaseType             as _CaseType             on  $projection.CaseType = _CaseType.CaseType

  // Case Category

  association [0..1] to I_CaseCategory         as _CaseCategory         on  $projection.CaseCategory = _CaseCategory.CaseCategory
                                                                        and $projection.CaseType     = _CaseCategory.CaseType 

  // Case Reason

  association [0..1] to I_CaseReason           as _CaseReason           on  $projection.CaseReason = _CaseReason.CaseReason
                                                                        and $projection.CaseType   = _CaseReason.CaseType

  // Case Priority

  association [0..1] to I_CasePriority         as _CasePriority         on  $projection.CasePriority = _CasePriority.CasePriority

{

      // VDM Fields

  key bukrs                    as CompanyCode,
  key cast( subject as char3 ) as OriginType,
      case_type                as CaseType,
      category                 as CaseCategory,
      stat_orderno             as CaseStatus,
      reason_code              as CaseReason,
      priority                 as CasePriority,

      // Exposed Associations

      _CompanyCode,
      _CaseType,
      _CaseCategory, 
      _CaseReason,
      _CasePriority

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TFDM_DEFCC"
],
"ASSOCIATED":
[
"I_CASECATEGORY",
"I_CASEPRIORITY",
"I_CASEREASON",
"I_CASETYPE",
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More