I_CMMDTYSUBACCTSTATUSTEXT

CDS View

Commodity Subaccount Status Text

I_CMMDTYSUBACCTSTATUSTEXT is a CDS View in S/4HANA. Commodity Subaccount Status Text. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CommoditySubAccountTP view left_outer CONSUMPTION Commodity Subaccount
@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'