I_BPDocumentStatusName

DDL: I_BPDOCUMENTSTATUSNAME SQL: IBPSDDOCSTATNAME Type: view BASIC

Billing Plan Document Status Text

I_BPDocumentStatusName is a Basic CDS View that provides data about "Billing Plan Document 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
AbapCatalog.sqlViewName IBPSDDOCSTATNAME view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey SDDocumentStatus view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Billing Plan Document Status Text view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SDDocumentStatus domvalue_l
KEY Language
DocumentStatusName ddtext
_BPDocumentStatus _BPDocumentStatus
_Language _Language 
@AbapCatalog.sqlViewName: 'IBPSDDOCSTATNAME'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.representativeKey: 'SDDocumentStatus'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Billing Plan Document Status Text'
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED

define view I_BPDocumentStatusName 
as select from  
dd07t
association[0..1] to I_BPDocumentStatus as _BPDocumentStatus                                // _SDDocuStatus

                   on $projection.SDDocumentStatus = _BPDocumentStatus.SDDocumentStatus
association[0..1] to I_Language as _Language on $projection.Language = _Language.Language{
 
      @ObjectModel.foreignKey.association: '_Bpdocumentstatus'
      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,
      
      _BPDocumentStatus,
      _Language
}
where domname = 'FKSAF' and as4local = 'A';       
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_BPDOCUMENTSTATUS",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More