I_Recontractstatll

DDL: I_RECONTRACTSTATLL SQL: IReContrStatLL Type: view COMPOSITE

Contract with active status logon language

I_Recontractstatll is a Composite CDS View that provides data about "Contract with active status logon language" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectActiveStatus) and exposes 10 fields with key fields StatusObject, StatusCode. It has 3 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectActiveStatus I_StatusObjectActiveStatus from

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_StatusObject _StatusObject $projection.StatusObject = _StatusObject.StatusObject
[0..1] I_StatusCode _StatusCod $projection.StatusCode = _StatusCod.StatusCode and $projection.StatusProfile = _StatusCod.StatusProfile
[0..1] I_StatusProfile _StatusProfile $projection.StatusProfile = _StatusProfile.StatusProfile

Annotations (10)

NameValueLevelField
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey StatusCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName IRECONTRSTATLL view
EndUserText.label Contract with active status logon language view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
KEY StatusCode StatusCode
StatusProfile StatusProfile
IsUserStatus IsUserStatus
StatusProfileName
StatusName
StatusShortName
_StatusObject _StatusObject
_StatusProfile _StatusProfile
_StatusCod _StatusCod 
//@AbapCatalog.sqlViewName: 'IReContrStatLL'

//@AbapCatalog.compiler.compareFilter: true

//@AccessControl.authorizationCheck: #NOT_REQUIRED

//@VDM.viewType: #COMPOSITE

//@ClientDependent: true

//@EndUserText.label: 'Contract with active status logon language'

//@ObjectModel.representativeKey: 'StatusCode'

@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'IRECONTRSTATLL'
@EndUserText.label: 'Contract with active status logon language'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
define view I_Recontractstatll
  with parameters
    @Consumption.hidden : true
    @Environment.systemField : #SYSTEM_LANGUAGE
    P_Language : sylangu

  as select from I_StatusObjectActiveStatus

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

  association [0..1] to I_StatusCode    as _StatusCod     on  // Need to be chaned once we have Status view ready

                                                              $projection.StatusCode    = _StatusCod.StatusCode
                                                          and $projection.StatusProfile = _StatusCod.StatusProfile

  association [0..1] to I_StatusProfile as _StatusProfile on  $projection.StatusProfile = _StatusProfile.StatusProfile
{
      @ObjectModel.foreignKey.association: '_StatusObject'
  key StatusObject,
      //@ObjectModel.foreignKey.association: '_StatusCode'

  key StatusCode,
      //@ObjectModel.foreignKey.association: '_StatusProfile'

      StatusProfile,
      IsUserStatus,
      //StatusIsActive,


      _StatusProfile._StatusProfileText[1: Language = $parameters.P_Language].StatusProfileName,
      _StatusCod._StatusCodeText[1: Language = $parameters.P_Language].StatusName,
      _StatusCod._StatusCodeText[1: Language = $parameters.P_Language].StatusShortName,
      _StatusObject,
      _StatusProfile,
      _StatusCod

} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSCODE",
"I_STATUSCODETEXT",
"I_STATUSOBJECTACTIVESTATUS",
"I_STATUSPROFILE",
"I_STATUSPROFILETEXT"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSOBJECT",
"I_STATUSPROFILE"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More