P_SCRL_PUBLISH_STATE

DDL: P_SCRL_PUBLISH_STATE Type: view

CRL: Publish state view

P_SCRL_PUBLISH_STATE is a CDS View that provides data about "CRL: Publish state view" in SAP S/4HANA. It reads from 1 data source (dd07v) and exposes 1 field with key field Code.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
dd07v dd07v from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_SCRL_PS_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CRL: Publish state view view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY Code domvalue_l 
@AbapCatalog: {
  sqlViewName: 'P_SCRL_PS_V',
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CRL: Publish state view'
define view P_SCRL_PUBLISH_STATE
  as select from dd07v
{
  key domvalue_l as Code,

      case domvalue_l
        when 'PC' then 'P'
        when 'PQ' then 'PS'
        when 'DQ' then 'DS'
        else domvalue_l
      end        as TextCode
}
where
  domname = 'SCRL_PUBLISH_STATE'
group by
  domvalue_l
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07V"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More