I_CmmdtySubAcctMappingVH

DDL: I_CMMDTYSUBACCTMAPPINGVH SQL: ICMMDTYSUBMAPVH Type: view BASIC

Value Help for Active/Inactive SubAcc

I_CmmdtySubAcctMappingVH is a Basic CDS View that provides data about "Value Help for Active/Inactive SubAcc" in SAP S/4HANA. It reads from 1 data source (I_CommoditySubAccount) and exposes 3 fields with key fields CommoditySubAccount, CommoditySubAccountName, CmmdtySubAccountStatus.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_CommoditySubAccount CommoditySubAccount from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYSUBMAPVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value Help for Active/Inactive SubAcc view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CommoditySubAccount I_CommoditySubAccount CommoditySubAccount
KEY CommoditySubAccountName I_CommoditySubAccount CommoditySubAccountName
KEY CmmdtySubAccountStatus I_CommoditySubAccount CmmdtySubAccountStatus 
@AbapCatalog.sqlViewName: 'ICMMDTYSUBMAPVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Value Help for Active/Inactive SubAcc'
@VDM.viewType                           : #BASIC
@ClientHandling.algorithm               : #SESSION_VARIABLE
@ObjectModel.usageType                  : { serviceQuality: #B, sizeCategory: #S, dataClass: #MASTER }


define view I_CmmdtySubAcctMappingVH
  as select from I_CommoditySubAccount as CommoditySubAccount
{
  key   CommoditySubAccount.CommoditySubAccount                       as  CommoditySubAccount,
  key   CommoditySubAccount.CommoditySubAccountName                   as  CommoditySubAccountName,
  key   CommoditySubAccount.CmmdtySubAccountStatus                    as  CmmdtySubAccountStatus

}
where
     CommoditySubAccount.CmmdtySubAccountStatus = '01'
  or CommoditySubAccount.CmmdtySubAccountStatus = '02'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMODITYSUBACCOUNT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More