SRFD_SCHEMAELEMENTENRICHED

CDS View

Schema Elements Metadata

SRFD_SCHEMAELEMENTENRICHED is a CDS View in S/4HANA. Schema Elements Metadata. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SRFD_DocumentDataEnriched view inner Generated Document Data

Fields (3)

KeyField CDS FieldsUsed in Views
StatryRptSchemaParentElementId StatryRptSchemaParentElementId 1
StatryRptSchemaRefElementId StatryRptSchemaRefElementId 1
StatryRptSchemaSingleValLeafEl StatryRptSchemaSingleValLeafEl 1 
@AbapCatalog.sqlViewName: 'SRFV_SCHELEMENRC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Schema Elements Metadata'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L

define view SRFD_SchemaElementEnriched
  as select distinct from SRFD_SchemaElement as A
    left outer join       SRFD_SchemaElement as B on  A.StatryRptSchema          = B.StatryRptSchema
                                                  and A.StatryRptSchemaVersion   = B.StatryRptSchemaVersion
                                                  and A.StatryRptSchemaElementId = B.StatryRptSchemaParentElementId

{

  key A.StatryRptSchema,
  key A.StatryRptSchemaVersion,
  key A.StatryRptSchemaElementId,

      A.StatryRptSchemaParentElementId,
      A.StatryRptSchemaRefElementId,

      case
        when B.StatryRptSchemaParentElementId is null then
          case
            when A.StatryRptSchemaElementMaxOccur > 1 or  A.StatryRptSchemaElementMaxOccur = -1  then ' '
            else  'X'
          end
        else ' '
      end as StatryRptSchemaSingleValLeafEl

}

Learn More