I_CMMDTYSUBACCTSTATUSTEXT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/