P_AccountingDocumentType

DDL: P_ACCOUNTINGDOCUMENTTYPE SQL: PFIACCDOCTYPE Type: view BASIC

P_AccountingDocumentType is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (t003) and exposes 6 fields with key field AccountingDocumentType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
t003 t003 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] t003t _Text $projection.AccountingDocumentType = _Text.blart and _Text.spras = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PFIACCDOCTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocumentType
AccountingDocumentTypeName
AccountingDocumentNumberRange numkr
AuthorizationGroup brgru
ExchangeRateType kurst
AllowedFinancialAccountTypes koars
@AbapCatalog.sqlViewName: 'PFIACCDOCTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private:true
@Search.searchable: true
@ObjectModel.usageType: {
      serviceQuality: #C,
      sizeCategory: #S,
      dataClass: #MASTER
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
//@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_AccountingDocumentType as select from t003

association [0..1] to t003t as _Text on $projection.AccountingDocumentType = _Text.blart and _Text.spras = $session.system_language

//association [0..*] to I_AccountingDocumentTypeText as _Text on $projection.AccountingDocumentType = _Text.AccountingDocumentType

//                                                                       and _Text.Language = $session.system_language

{
 
  //@ObjectModel.text.association: '_Text'

  @ObjectModel.text.element: 'AccountingDocumentTypeName'
  @Search: { defaultSearchElement: true, ranking: #HIGH }
  key cast ( blart as farp_blart preserving type ) as AccountingDocumentType,
  //@Semantics.text: true

  @Semantics.text
  @Search: { defaultSearchElement: true, ranking: #LOW }
  cast ( _Text.ltext as farp_ltext_003t preserving type ) as AccountingDocumentTypeName,
  //_Text.AccountingDocumentTypeName as AccountingDocumentTypeName,

  numkr as AccountingDocumentNumberRange,
  brgru as AuthorizationGroup,
  kurst as ExchangeRateType,
  koars as AllowedFinancialAccountTypes
  //_Text

};