I_InboundDocumentStatusText

DDL: I_INBOUNDDOCUMENTSTATUSTEXT Type: view_entity Package: S_APS_IIP_MODEL_API

Inbound Document External Text

I_InboundDocumentStatusText is a CDS View that provides data about "Inbound Document External Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 6 fields with key fields Language, InboundDocumentStatus. It has 2 associations to related views. Part of development package S_APS_IIP_MODEL_API.

Data Sources (1)

SourceAliasJoin Type
dd07t DomainValueText from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InboundDocumentStatusVH _DomainValue $projection.InboundDocumentStatus = _DomainValue.InboundDocumentStatus
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Inbound Document External Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Language
KEY InboundDocumentStatus
DomainValue dd07t domvalue_l
InboundDocumentStatusText dd07t ddtext
_Language _Language
_DomainValue _DomainValue
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inbound Document External Text'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_InboundDocumentStatusText 
as select from dd07t as DomainValueText
  association [1..1] to I_InboundDocumentStatusVH as _DomainValue
    on $projection.InboundDocumentStatus = _DomainValue.InboundDocumentStatus
  association [0..1] to I_Language as _Language 
  on $projection.Language = _Language.Language //_Language.Language

 
{
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast( DomainValueText.ddlanguage as spras preserving type ) as Language, 
      @ObjectModel.text.element: [ 'InboundDocumentStatusText' ]
  key cast( substring( domvalue_l, 1, 2 ) as iip_document_status )                   as InboundDocumentStatus,
       DomainValueText.domvalue_l as DomainValue, //keep this field name

      @Semantics:   { text: true }
      //cast( DomainValueText.ddtext as iip_document_status_ext preserving type ) as ExternalStatus,

      DomainValueText.ddtext as InboundDocumentStatusText,
      @Semantics:   { text: true }
      _Language,
      _DomainValue
}
where
      DomainValueText.domname  = 'IIP_DOCUMENT_STATUS'
  and DomainValueText.as4local = 'A'