I_CAWriteOffDocumentVH

DDL: I_CAWRITEOFFDOCUMENTVH SQL: ICAWRITEOFFDOCVH Type: view COMPOSITE Package: ODATA_O2C_FICA_WRITEOFF_HIST

Ausbuchungsbeleg

I_CAWriteOffDocumentVH is a Composite CDS View that provides data about "Ausbuchungsbeleg" in SAP S/4HANA. It reads from 1 data source (I_CADocument) and exposes 15 fields with key field CAWriteOffDocumentNumber. It has 1 association to related views. Part of development package ODATA_O2C_FICA_WRITEOFF_HIST.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_CADocument I_CADocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _UserContactCard $projection.CreatedByUser = _UserContactCard.ContactCardID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICAWRITEOFFDOCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Ausbuchungsbeleg view
Search.searchable true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CAWriteOffDocumentNumber
CADocumentType CADocumentType
CADocumentTypeName
CAReconciliationKey CAReconciliationKey
CAPostingDate CAPostingDate
CADocumentOriginCode CADocumentOriginCode
CADocumentOriginCodeName
CreatedByUser CreatedByUser
CreatedByUserName _UserContactCard FullName
CreationDate CreationDate
CAReferenceDocument CAReferenceDocument
CAApplicationArea CAApplicationArea
CATaxCompanyCode CATaxCompanyCode
_CADocumentType _CADocumentType
_CADocumentOriginCode _CADocumentOriginCode 
@AbapCatalog.sqlViewName: 'ICAWRITEOFFDOCVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Ausbuchungsbeleg'
@Search.searchable: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_CAWriteOffDocumentVH
  as select from I_CADocument
  association [0..1] to I_UserContactCard   as _UserContactCard on $projection.CreatedByUser = _UserContactCard.ContactCardID
{
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.95, ranking: #HIGH }
  key cast (CADocumentNumber as abbel_gfn_kk preserving type)                                                                                          as CAWriteOffDocumentNumber,

      @ObjectModel: { text.element:  [ 'CADocumentTypeName' ] }
      CADocumentType,

      @Semantics.text
      _CADocumentType._Text[1:Language = $session.system_language].CADocumentTypeName,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.9,  ranking: #MEDIUM }
      CAReconciliationKey,

      CAPostingDate,

      @ObjectModel: { text.element:  [ 'CADocumentOriginCodeName' ] }
      CADocumentOriginCode,

      @Semantics.text
      cast (_CADocumentOriginCode._Text[1: Language=$session.system_language].CADocumentOriginCodeName as htext_gfn_kk) as CADocumentOriginCodeName,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM }
      @ObjectModel: { text.element:  [ 'CreatedByUserName' ] }
      CreatedByUser,

      @Semantics.text
      _UserContactCard.FullName                                                                                                                       as CreatedByUserName,

      CreationDate,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.94, ranking: #MEDIUM }

      CAReferenceDocument,

      @UI.hidden: true
      CAApplicationArea,

      @UI.hidden: true
      CATaxCompanyCode,


      _CADocumentType,
      _CADocumentOriginCode

}
where
     CADocumentOriginCode = '16'
  or CADocumentOriginCode = '17'

Learn More