N_AccountingPostingStatus

DDL: N_ACCOUNTINGPOSTINGSTATUS SQL: NACCTPOSTGSTS Type: view

AccountingPostingStatus Auxiliary View

N_AccountingPostingStatus is a CDS View that provides data about "AccountingPostingStatus Auxiliary View" in SAP S/4HANA. It reads from 1 data source (tvbst) and exposes 4 fields with key fields AccountingPostingStatus, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tvbst tvbst from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName NACCTPOSTGSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label AccountingPostingStatus Auxiliary View view
VDM.auxiliaryEntity.for.entity I_AccountingPostingStatus view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY AccountingPostingStatus statu
KEY Language spras
AccountingPostingStatusDesc bezei
_Language _Language
@AbapCatalog.sqlViewName: 'NACCTPOSTGSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'AccountingPostingStatus Auxiliary View'
@VDM.auxiliaryEntity.usage.type: [#ENTERPRISE_SEARCH] 
@VDM.auxiliaryEntity.for.entity: 'I_AccountingPostingStatus' 

@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #S
   }
}

define view N_AccountingPostingStatus as select from tvbst
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
key statu as AccountingPostingStatus,
@Semantics.language: true 
@ObjectModel.foreignKey.association: '_Language' 
key spras as Language,
@Semantics.text: true bezei as AccountingPostingStatusDesc,
//Associations 

_Language
}
where (tvbst.tbnam = 'VBRK') and (tvbst.fdnam = 'BUCHK');
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVBST"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/