A_SitnTmplDataCntxtDefText

DDL: A_SITNTMPLDATACNTXTDEFTEXT SQL: ASITNTDCTXSCHT Type: view BASIC

Schema for Data Context Definition - Text

A_SitnTmplDataCntxtDefText is a Basic CDS View that provides data about "Schema for Data Context Definition - Text" in SAP S/4HANA. It reads from 2 data sources (I_Language, sit_t_dctx_sch_t) and exposes 5 fields with key fields SitnDefTemplateID, SitnDataCntxtFormatVersion, SitnDataCntxtSchemaVersion, Language. It is exposed through 1 OData service (API_BUS_SITN_MSTRDATA_SRV).

2 data source(s) Exposed by 1 service(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_Language _Language inner
sit_t_dctx_sch_t _SchemaText from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ASITNTDCTXSCHT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Schema for Data Context Definition - Text view
ObjectModel.query.implementedBy ABAP:CL_SIT_DCTX_ENTITY_SCHEMA_T view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #TEXT view

OData Services (1)

ServiceBindingVersionContractRelease
API_BUS_SITN_MSTRDATA_SRV API_BUS_SITN_MSTRDATA_SRV V2 C2 C1

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SitnDefTemplateID sit_t_dctx_sch_t sitndeftemplateid
KEY SitnDataCntxtFormatVersion sit_t_dctx_sch_t sitndatacntxtformatversion
KEY SitnDataCntxtSchemaVersion sit_t_dctx_sch_t sitndatacntxtschemaversion
KEY Language sit_t_dctx_sch_t language
SitnDataCntxtText sitndatacntxttext 
@AbapCatalog.sqlViewName: 'ASITNTDCTXSCHT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Schema for Data Context Definition - Text'
@ObjectModel:{
    query: {
        implementedBy: 'ABAP:CL_SIT_DCTX_ENTITY_SCHEMA_T'
    },
    usageType:{
                serviceQuality: #C,
                sizeCategory: #M,
                dataClass: #MIXED
               },
    dataCategory: #TEXT
}



define view A_SitnTmplDataCntxtDefText
  as select from sit_t_dctx_sch_t as _SchemaText
    inner join   I_Language       as _Language on  _SchemaText.language      =  _Language.Language
                                               and _Language.LanguageISOCode <> '1Q'
                                               and _Language.LanguageISOCode <> '2Q'
{
  key _SchemaText.sitndeftemplateid          as SitnDefTemplateID,
  key _SchemaText.sitndatacntxtformatversion as SitnDataCntxtFormatVersion,
  key _SchemaText.sitndatacntxtschemaversion as SitnDataCntxtSchemaVersion,
      @Semantics.language: true
  key _SchemaText.language                   as Language,

      @Semantics.text:true
      sitndatacntxttext                      as SitnDataCntxtText

}

Learn More