I_CmmdtySubAcctStatusText

DDL: I_CMMDTYSUBACCTSTATUSTEXT SQL: ICMMDTYSASTSTXT Type: view BASIC

Commodity Subaccount Status Text

I_CmmdtySubAcctStatusText is a Basic CDS View that provides data about "Commodity Subaccount Status Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 3 fields with key fields CmmdtySubAccountStatus, Language.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYSASTSTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CmmdtySubAccountStatus view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Commodity Subaccount Status Text view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CmmdtySubAccountStatus
KEY Language ddlanguage
CmmdtySubAccountStatusText ddtext 
@AbapCatalog.sqlViewName: 'ICMMDTYSASTSTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'CmmdtySubAccountStatus'
@ObjectModel.usageType:{ serviceQuality: #B, sizeCategory : #S, dataClass: #META}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Commodity Subaccount Status Text'
@Metadata.ignorePropagatedAnnotations:true

define view I_CmmdtySubAcctStatusText
  as select from dd07t
{
  key  substring(domvalue_l, 1, 2) as CmmdtySubAccountStatus,
       @Semantics.language: true
  key  ddlanguage                  as Language,
       @Semantics.text: true
       ddtext                      as CmmdtySubAccountStatusText
}
where
      domname        = 'CMMFSA_SUBACCOUNTSTATUS'
  and dd07t.as4local = 'A'

Learn More