I_BpCpmStatusName

DDL: I_BPCPMSTATUSNAME SQL: IBPCPMSTATNAME Type: view BASIC

CPM Billing Plan Status Text

I_BpCpmStatusName is a Basic CDS View that provides data about "CPM Billing Plan Status Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields SDDocumentStatus, Language.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IBPCPMSTATNAME view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey SDDocumentStatus view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CPM Billing Plan Status Text view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SDDocumentStatus domvalue_l
KEY Language
DocumentStatusName ddtext
_BpCpmStatus _BpCpmStatus
_Language _Language 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IBPCPMSTATNAME'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.representativeKey: 'SDDocumentStatus'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CPM Billing Plan Status Text'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
define view I_BpCpmStatusName 
as select from dd07t
association[0..1] to I_BpCpmStatus as _BpCpmStatus                              // _SDDocuStatus

                   on $projection.SDDocumentStatus = _BpCpmStatus.SDDocumentStatus
association[0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
 
      @ObjectModel.foreignKey.association: '_BpCpmStatus'
      key domvalue_l as SDDocumentStatus,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
      key cast( ddlanguage as spras) as Language,
      @Semantics.text: true
      ddtext              as DocumentStatusName,
      
      _BpCpmStatus,
      _Language
}
where domname = '/CPD/CPM_BILLINGPLAN_STATUS' and as4local = 'A';       
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_BPCPMSTATUS",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More