R_CndnContrActiveStatus

DDL: R_CNDNCONTRACTIVESTATUS Type: view BASIC

Active Status of Condition Contract

R_CndnContrActiveStatus is a Basic CDS View that provides data about "Active Status of Condition Contract" in SAP S/4HANA. It reads from 2 data sources (I_ConditionContract, P_CndnContrActiveStatus) and exposes 6 fields with key fields ConditionContract, StatusCode. It has 2 associations to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_ConditionContract Contract inner
P_CndnContrActiveStatus ContractStatus from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ConditionContract _ConditionContract $projection.ConditionContract = _ConditionContract.ConditionContract
[0..1] I_StatusCode _StatusCode $projection.StatusCode = _StatusCode.StatusCode and $projection.StatusProfile = _StatusCode.StatusProfile

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWCBCCACTSTAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
Analytics.internalName #LOCAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey StatusCode view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Active Status of Condition Contract view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract I_ConditionContract ConditionContract
KEY StatusCode P_CndnContrActiveStatus StatusCode
IsUserStatus P_CndnContrActiveStatus IsUserStatus
StatusProfile P_CndnContrActiveStatus StatusProfile
_ConditionContract _ConditionContract
_StatusCode _StatusCode 
@AbapCatalog: { sqlViewName: 'RWCBCCACTSTAT',
                compiler.compareFilter: true,
                preserveKey: true
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ClientHandling: {
  type: #INHERITED,
  algorithm: #SESSION_VARIABLE
}
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@Analytics: {
    internalName: #LOCAL
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   },
   representativeKey: 'StatusCode'
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Active Status of Condition Contract'
define view R_CndnContrActiveStatus
  as select from P_CndnContrActiveStatus as ContractStatus
    inner join   I_ConditionContract     as Contract on ContractStatus.StatusObjectUUID = Contract.CndnContrUUID

  association [1..1] to I_ConditionContract as _ConditionContract on  $projection.ConditionContract = _ConditionContract.ConditionContract
  association [0..1] to I_StatusCode        as _StatusCode        on  $projection.StatusCode    = _StatusCode.StatusCode
                                                                  and $projection.StatusProfile = _StatusCode.StatusProfile

{
   @ObjectModel.foreignKey.association: '_ConditionContract'                                                                                                   
      @Consumption: {
        valueHelpDefinition: [{ entity: { name: 'I_ConditionContractStdVH', element: 'ConditionContract' } }]
      }
  key Contract.ConditionContract   as ConditionContract,
  @ObjectModel.foreignKey.association: '_StatusCode'
  key ContractStatus.StatusCode    as StatusCode,
      ContractStatus.IsUserStatus  as IsUserStatus,
      ContractStatus.StatusProfile as StatusProfile,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _ConditionContract,
      _StatusCode
}

Learn More