C_CADocumentHeaderValueHelp

DDL: C_CADOCUMENTHEADERVALUEHELP SQL: CCADOCHEADERVH Type: view CONSUMPTION

Belegnummer

C_CADocumentHeaderValueHelp is a Consumption CDS View that provides data about "Belegnummer" in SAP S/4HANA. It reads from 1 data source (I_CADocumentHeader) and exposes 15 fields with key field CADocumentNumber. It has 1 association to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_CADocumentHeader I_CADocumentHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByContact $projection.CreatedByUser = _CreatedByContact.UserID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCADOCHEADERVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Belegnummer view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CADocumentNumber view
Search.searchable true view
Consumption.ranked true view
VDM.viewType #CONSUMPTION view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
CADocumentType CADocumentType
CADocumentTypeName
CAReconciliationKey CAReconciliationKey
CAPostingDate CAPostingDate
CADocumentOriginCode CADocumentOriginCode
CADocumentOriginCodeName
CreatedByUser CreatedByUser
CreatedByUserName _CreatedByContact UserDescription Vollständiger Name
CreationDate CreationDate
CAReferenceDocument CAReferenceDocument
CAApplicationArea CAApplicationArea
CATaxCompanyCode CATaxCompanyCode
_DocType _DocType
_DocOriginCode _DocOriginCode 
@AbapCatalog.sqlViewName: 'CCADOCHEADERVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Belegnummer'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'CADocumentNumber'
@Search.searchable: true
@Consumption.ranked: true
@VDM.viewType: #CONSUMPTION
//@AccessControl.privilegedAssociations: [ '_CreatedByContact' ]

define view C_CADocumentHeaderValueHelp
  as select from I_CADocumentHeader
  association [0..1] to I_User as _CreatedByContact on $projection.CreatedByUser = _CreatedByContact.UserID
{
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      @UI.lineItem.importance: #HIGH
  key CADocumentNumber,

      @ObjectModel.text.element: [ 'CADocumentTypeName' ]
      @UI.lineItem.importance: #HIGH
      @UI.textArrangement: #TEXT_ONLY
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8,  ranking: #LOW }
      CADocumentType,

      @Semantics.text
      @UI.lineItem.importance: #MEDIUM
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8,  ranking: #LOW }
      _DocType._Text[1:Language = $session.system_language].CADocumentTypeName,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8,  ranking: #LOW }
      @UI.lineItem.importance: #HIGH
      CAReconciliationKey,

      @UI.lineItem.importance: #MEDIUM
      CAPostingDate,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8,  ranking: #LOW }
      @ObjectModel: { text.element:  [ 'CADocumentOriginCodeName' ] }
      @UI.lineItem.importance: #MEDIUM
      CADocumentOriginCode,

      @Semantics.text
      @UI.lineItem.importance: #MEDIUM
      @Search: { defaultSearchElement: true }
      cast (_DocOriginCode._Text[1: Language = $session.system_language].CADocumentOriginCodeName as htext_gfn_kk) as CADocumentOriginCodeName,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
      @ObjectModel: { text.element:  [ 'CreatedByUserName' ] }
      @UI.lineItem.importance: #HIGH
      CreatedByUser,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8 }
      @Semantics.text
      @UI.lineItem.importance: #MEDIUM
      @EndUserText.label: 'Vollständiger Name'
      _CreatedByContact.UserDescription                                                                            as CreatedByUserName,

      @UI.lineItem.importance: #MEDIUM
      CreationDate,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
      @UI.lineItem.importance: #HIGH
      CAReferenceDocument,

      @UI.hidden: true
      CAApplicationArea,
      @UI.hidden: true
      CATaxCompanyCode,


      _DocType,
      _DocOriginCode

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENTHEADER",
"I_CADOCUMENTORIGINCODE",
"I_CADOCUMENTORIGINCODETEXT",
"I_CADOCUMENTTYPE",
"I_CADOCUMENTTYPETEXT",
"I_USER"
],
"ASSOCIATED":
[
"I_CADOCUMENTORIGINCODE",
"I_CADOCUMENTTYPE",
"I_USER"
],
"BASE":
[
"I_CADOCUMENTHEADER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More