T100_M

DDL: T100_M Type: view_entity

Text Verticalization: Replacement View for T100

T100_M is a CDS View that provides data about "Text Verticalization: Replacement View for T100" in SAP S/4HANA. It reads from 2 data sources (t100_i, t100) and exposes 4 fields with key fields sprsl, arbgb, msgnr.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
t100_i delta left_outer
t100 orig from

Annotations (3)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed true view
EndUserText.label Text Verticalization: Replacement View for T100 view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY sprsl t100 sprsl
KEY arbgb t100 arbgb
KEY msgnr t100 msgnr
text 
 @AbapCatalog.entityBuffer.definitionAllowed: true
 @EndUserText.label: 'Text Verticalization: Replacement View for T100'
@AccessControl.authorizationCheck: #NOT_ALLOWED
define view entity T100_M
  as select from    t100   as orig
    left outer join t100_i as delta on  orig.sprsl = delta.sprsl
                                    and orig.arbgb = delta.arbgb
                                    and orig.msgnr = delta.msgnr
{
  key orig.sprsl                      as sprsl,
  key orig.arbgb                      as arbgb,
  key orig.msgnr                      as msgnr,
      coalesce(delta.text, orig.text) as text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T100",
"T100_I"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More