V_ARS_RELEASE_CONTRACT

DDL: V_ARS_RELEASE_CONTRACT SQL: V_ARS_REL_CTRCT Type: view

API Release Contracts

V_ARS_RELEASE_CONTRACT is a CDS View that provides data about "API Release Contracts" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields. It has 2 associations to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l value from

Associations (2)

CardinalityTargetAliasCondition
[0..1] dd07t text text.domname = value.domname and text.as4local = value.as4local and text.valpos = value.valpos and text.as4vers = value.as4vers and text.domvalue_l = value.domvalue_l and text.ddlanguage = $session.system_language
[0..1] dd07t text_en text_en.domname = value.domname and text_en.as4local = value.as4local and text_en.valpos = value.valpos and text_en.as4vers = value.as4vers and text_en.domvalue_l = value.domvalue_l and text_en.ddlanguage = 'E'

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName V_ARS_REL_CTRCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label API Release Contracts view

Fields (2)

KeyFieldSource TableSource FieldDescription
rank dd07l valpos
description 
@AbapCatalog.sqlViewName: 'V_ARS_REL_CTRCT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'API Release Contracts'
define view V_ARS_RELEASE_CONTRACT
  as select from dd07l as value
  association [0..1] to dd07t as text    on  text.domname    = value.domname
                                         and text.as4local   = value.as4local
                                         and text.valpos     = value.valpos
                                         and text.as4vers    = value.as4vers
                                         and text.domvalue_l = value.domvalue_l
                                         and text.ddlanguage = $session.system_language
  association [0..1] to dd07t as text_en on  text_en.domname    = value.domname
                                         and text_en.as4local   = value.as4local
                                         and text_en.valpos     = value.valpos
                                         and text_en.as4vers    = value.as4vers
                                         and text_en.domvalue_l = value.domvalue_l
                                         and text_en.ddlanguage = 'E'
{
  key value.domvalue_l                                    as release_contract,
      value.valpos                                        as rank,
      coalesce(text.ddtext, coalesce(text_en.ddtext, '')) as description
}
where
      value.domname  = 'ARS_RELEASE_CONTRACT'
  and value.as4local = 'A'
  and value.as4vers  = '0000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"DD07T"
],
"ASSOCIATED":
[
"DD07T"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More