R_CndnContrType

DDL: R_CNDNCONTRTYPE Type: view BASIC

Condition Contract Type

R_CndnContrType is a Basic CDS View that provides data about "Condition Contract Type" in SAP S/4HANA. It reads from 1 data source (twcbcontrtype) and exposes 28 fields with key field CndnContrType. It has 13 associations to related views.

Data Sources (1)

SourceAliasJoin Type
twcbcontrtype twcbcontrtype from

Associations (13)

CardinalityTargetAliasCondition
[0..*] R_CndnContrTypeText _Text $projection.CndnContrType = _Text.CndnContrType
[0..1] I_CndnContrTypeBlockUsage _CndnContrTypeBlockUsage $projection.CndnContrTypeBlockUsage = _CndnContrTypeBlockUsage.CndnContrTypeBlockUsage
[0..1] I_CndnContrPartnerCat _CndnContrPartnerCat $projection.CndnContrPartnerCat = _CndnContrPartnerCat.CndnContrPartnerCat
[0..1] I_CndnContrChangeability _CndnContrChangeability $projection.CndnContrChangeability = _CndnContrChangeability.CndnContrChangeability
[0..1] R_BusVolFldCombnSet _BusVolFldCombnSet $projection.BusVolFldCombnSet = _BusVolFldCombnSet.BusVolFldCombnSet
[0..1] I_CndnContrClassfctnType _CndnContrClassfctnType $projection.CndnContrClassfctnType = _CndnContrClassfctnType.CndnContrClassfctnType
[0..1] I_CndnContrItemCategory _CndnContrItemCategory $projection.CndnContrItemCategory = _CndnContrItemCategory.CndnContrItemCategory
[0..1] I_CndnContrEligibleCat _CndnContrEligibleCat $projection.CndnContrEligibleCat = _CndnContrEligibleCat.CndnContrEligibleCat
[0..1] I_CndnContrSettlmtType _CndnContrSettlmtType $projection.CndnContrSettlmtType = _CndnContrSettlmtType.CndnContrSettlmtType
[0..1] I_CndnContrPrtlSettlmtCat _CndnContrPrtlSettlmtCat $projection.CndnContrPrtlSettlmtCat = _CndnContrPrtlSettlmtCat.CndnContrPrtlSettlmtCat
[0..1] I_CndnContrAccrRvslCat _CndnContrAccrRvslCat $projection.CndnContrAccrRvslCat = _CndnContrAccrRvslCat.CndnContrAccrRvslCat
[0..1] I_CndnContrElmntBehaviorGrp _ApplElmntBehaviorGrp $projection.ApplElmntBehaviorGrp = _ApplElmntBehaviorGrp.ApplElmntBehaviorGrp
[0..1] I_CnConMnlSettlmtAllwncCat _CnConMnlSettlmtAllwncCat $projection.CnConMnlSettlmtAllwncCat = _CnConMnlSettlmtAllwncCat.CnConMnlSettlmtAllwncCat

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWLFCOCOTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Condition Contract Type view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey CndnContrType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CndnContrType contract_type
SAPObjectType bo_type
CndnContrTypeBlockUsage type_block
CndnContrPartnerCat owner_type
CndnContrEligibleCat eligible_type
CndnContrClassfctnType category
CndnContrHasNoConditions no_condition
CndnContrSettlmtType
CndnContrChangeability ui_change
BusVolFldCombnSet busvolbase_type
CndnContrPrtlSettlmtCat settl_part_type
CndnContrItemCategory contract_items
CndnContrAccrRvslCat accr_rev_type
ApplElmntBehaviorGrp visibility_group
CnConMnlSettlmtAllwncCat
_Text _Text
_CndnContrTypeBlockUsage _CndnContrTypeBlockUsage
_CndnContrPartnerCat _CndnContrPartnerCat
_CndnContrClassfctnType _CndnContrClassfctnType
_CndnContrChangeability _CndnContrChangeability
_BusVolFldCombnSet _BusVolFldCombnSet
_CndnContrItemCategory _CndnContrItemCategory
_CndnContrEligibleCat _CndnContrEligibleCat
_CndnContrSettlmtType _CndnContrSettlmtType
_CndnContrPrtlSettlmtCat _CndnContrPrtlSettlmtCat
_CndnContrAccrRvslCat _CndnContrAccrRvslCat
_ApplElmntBehaviorGrp _ApplElmntBehaviorGrp
_CnConMnlSettlmtAllwncCat _CnConMnlSettlmtAllwncCat
@AbapCatalog: {
    sqlViewName: 'RWLFCOCOTYPE',
    compiler.compareFilter: true,
    preserveKey: true
    }
@EndUserText.label: 'Condition Contract Type'
@AccessControl: {
    authorizationCheck: #MANDATORY,
    privilegedAssociations: ['_Text'],
    personalData.blocking: #('TRANSACTIONAL_DATA')
    }
@ObjectModel: {
    representativeKey: 'CndnContrType',
    usageType: {
      dataClass:      #CUSTOMIZING,
      serviceQuality: #B,
      sizeCategory:   #S
      }
    }
@ClientHandling: {
    type: #INHERITED,
    algorithm: #SESSION_VARIABLE
    }
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #SAP_INTERNAL_API
    }
//@Analytics: {

//    dataCategory: #DIMENSION,

//    dataExtraction.enabled: false,

//    internalName: #LOCAL

//}

@Metadata: {
    ignorePropagatedAnnotations: true,
    allowExtensions: false
    }

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view R_CndnContrType
  as select from twcbcontrtype

  association [0..*] to R_CndnContrTypeText         as _Text                     on $projection.CndnContrType = _Text.CndnContrType
  association [0..1] to I_CndnContrTypeBlockUsage   as _CndnContrTypeBlockUsage  on $projection.CndnContrTypeBlockUsage = _CndnContrTypeBlockUsage.CndnContrTypeBlockUsage
  association [0..1] to I_CndnContrPartnerCat       as _CndnContrPartnerCat      on $projection.CndnContrPartnerCat = _CndnContrPartnerCat.CndnContrPartnerCat
  association [0..1] to I_CndnContrChangeability    as _CndnContrChangeability   on $projection.CndnContrChangeability = _CndnContrChangeability.CndnContrChangeability
  association [0..1] to R_BusVolFldCombnSet         as _BusVolFldCombnSet        on $projection.BusVolFldCombnSet = _BusVolFldCombnSet.BusVolFldCombnSet
  association [0..1] to I_CndnContrClassfctnType    as _CndnContrClassfctnType   on $projection.CndnContrClassfctnType = _CndnContrClassfctnType.CndnContrClassfctnType
  association [0..1] to I_CndnContrItemCategory     as _CndnContrItemCategory    on $projection.CndnContrItemCategory = _CndnContrItemCategory.CndnContrItemCategory
  association [0..1] to I_CndnContrEligibleCat      as _CndnContrEligibleCat     on $projection.CndnContrEligibleCat = _CndnContrEligibleCat.CndnContrEligibleCat
  association [0..1] to I_CndnContrSettlmtType      as _CndnContrSettlmtType     on $projection.CndnContrSettlmtType = _CndnContrSettlmtType.CndnContrSettlmtType
  association [0..1] to I_CndnContrPrtlSettlmtCat   as _CndnContrPrtlSettlmtCat  on $projection.CndnContrPrtlSettlmtCat = _CndnContrPrtlSettlmtCat.CndnContrPrtlSettlmtCat
  association [0..1] to I_CndnContrAccrRvslCat      as _CndnContrAccrRvslCat     on $projection.CndnContrAccrRvslCat = _CndnContrAccrRvslCat.CndnContrAccrRvslCat
  association [0..1] to I_CndnContrElmntBehaviorGrp as _ApplElmntBehaviorGrp     on $projection.ApplElmntBehaviorGrp = _ApplElmntBehaviorGrp.ApplElmntBehaviorGrp
  association [0..1] to I_CnConMnlSettlmtAllwncCat  as _CnConMnlSettlmtAllwncCat on $projection.CnConMnlSettlmtAllwncCat = _CnConMnlSettlmtAllwncCat.CnConMnlSettlmtAllwncCat

{
      @ObjectModel.text.association: '_Text'
  key contract_type                                                       as CndnContrType,
      bo_type                                                             as SAPObjectType,

      @ObjectModel.foreignKey.association: '_CndnContrTypeBlockUsage'
      type_block                                                          as CndnContrTypeBlockUsage,
      @ObjectModel.foreignKey.association: '_CndnContrPartnerCat'
      owner_type                                                          as CndnContrPartnerCat,
      @ObjectModel.foreignKey.association: '_CndnContrEligibleCat'
      eligible_type                                                       as CndnContrEligibleCat,
      @ObjectModel.foreignKey.association: '_CndnContrClassfctnType'
      category                                                            as CndnContrClassfctnType,
      @Semantics.booleanIndicator: true
      no_condition                                                        as CndnContrHasNoConditions,
      @ObjectModel.foreignKey.association: '_CndnContrSettlmtType'
      cast( rebate_type as wb2_rebate_type_fio preserving type )          as CndnContrSettlmtType,
      @ObjectModel.foreignKey.association: '_CndnContrChangeability'
      ui_change                                                           as CndnContrChangeability,
      @ObjectModel.foreignKey.association: '_BusVolFldCombnSet'
      busvolbase_type                                                     as BusVolFldCombnSet,
      @ObjectModel.foreignKey.association: '_CndnContrPrtlSettlmtCat'
      settl_part_type                                                     as CndnContrPrtlSettlmtCat,
      @ObjectModel.foreignKey.association: '_CndnContrItemCategory'
      contract_items                                                      as CndnContrItemCategory,
      @ObjectModel.foreignKey.association: '_CndnContrAccrRvslCat'
      accr_rev_type                                                       as CndnContrAccrRvslCat,
      @ObjectModel.foreignKey.association: '_ApplElmntBehaviorGrp'
      visibility_group                                                    as ApplElmntBehaviorGrp,
      cast( man_settl_docs as wb2_mnl_settlmt_allowance preserving type ) as CnConMnlSettlmtAllwncCat,


      /* Associations */
      _Text,
      _CndnContrTypeBlockUsage,
      _CndnContrPartnerCat,
      _CndnContrClassfctnType,
      _CndnContrChangeability,
      _BusVolFldCombnSet,
      _CndnContrItemCategory,
      _CndnContrEligibleCat,
      _CndnContrSettlmtType,
      _CndnContrPrtlSettlmtCat,
      _CndnContrAccrRvslCat,
      _ApplElmntBehaviorGrp,
      _CnConMnlSettlmtAllwncCat

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TWCBCONTRTYPE"
],
"ASSOCIATED":
[
"I_CNCONMNLSETTLMTALLWNCCAT",
"I_CNDNCONTRACCRRVSLCAT",
"I_CNDNCONTRCHANGEABILITY",
"I_CNDNCONTRCLASSFCTNTYPE",
"I_CNDNCONTRELIGIBLECAT",
"I_CNDNCONTRELMNTBEHAVIORGRP",
"I_CNDNCONTRITEMCATEGORY",
"I_CNDNCONTRPARTNERCAT",
"I_CNDNCONTRPRTLSETTLMTCAT",
"I_CNDNCONTRSETTLMTTYPE",
"I_CNDNCONTRTYPEBLOCKUSAGE",
"R_BUSVOLFLDCOMBNSET",
"R_CNDNCONTRTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/