I_REContractStat

DDL: I_RECONTRACTSTAT SQL: IRECONTRACTSTAT Type: view BASIC

Contract with active status

I_REContractStat is a Basic CDS View that provides data about "Contract with active status" in SAP S/4HANA. It reads from 1 data source (P_ConcatenatedCnActiveSts) and exposes 5 fields with key field StatusObject. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_ConcatenatedCnActiveSts P_ConcatenatedCnActiveSts from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_StatusObject _StatusObject $projection.StatusObject = _StatusObject.StatusObject
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IRECONTRACTSTAT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Contract with active status view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey StatusObject view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
StatusProfile StatusProfile
REContractStatus
_StatusObject _StatusObject
_StatusProfile _StatusProfile 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IRECONTRACTSTAT'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Contract with active status'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.preserveKey:true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: [ '_StatusObject'  ]
//@ClientDependent: true

@ObjectModel.representativeKey: 'StatusObject'
define view I_REContractStat
  as select from P_ConcatenatedCnActiveSts( P_Language : $session.system_language, P_Clnt: $session.client )

  association [0..1] to I_StatusObject  as _StatusObject  on $projection.StatusObject = _StatusObject.StatusObject

  association [0..1] to I_StatusProfile as _StatusProfile on $projection.StatusProfile = _StatusProfile.StatusProfile

{
      @ObjectModel.foreignKey.association:'_StatusObject'
  key StatusObject,
      @ObjectModel.foreignKey.association:'_StatusProfile'

      StatusProfile,

      ConcatenatedActiveUserStsName,
      ConcatenatedActiveSystStsName,
      concat_with_space(ConcatenatedActiveSystStsName, coalesce(ConcatenatedActiveUserStsName, ' ' ), 1 ) as REContractStatus,
//      cast(concat_with_space(ConcatenatedActiveSystStsName, coalesce(ConcatenatedActiveUserStsName, ' ' ), 1 ) as recnvdmcnstatus) as REContractStatus,


      _StatusObject,
      _StatusProfile
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[],
"ASSOCIATED":
[
"I_STATUSOBJECT",
"I_STATUSPROFILE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More