P_PostingProcedureTypeVHT

DDL: P_POSTINGPROCEDURETYPEVHT Type: view_entity BASIC Package: ODATA_AR_POSTING_RULES

Text for posting procedure type

P_PostingProcedureTypeVHT is a Basic CDS View that provides data about "Text for posting procedure type" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 9 fields with key fields ReprocRuleDomName, ReprocgRulePostgProcedureType, Language, Pos2, Pos3. It has 2 associations to related views. Part of development package ODATA_AR_POSTING_RULES.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[0..*] P_PostingProcedureType _ProcedureType $projection.ReprocgRulePostgProcedureType = _ProcedureType.ReprocgRulePostgProcedureType
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #BASIC view
VDM.private true view
Search.searchable true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ReprocRuleDomName domname
KEY ReprocgRulePostgProcedureType domvalue_l
KEY Language ddlanguage
KEY Pos2 as4local
KEY Pos3 valpos
KEY Pos4 as4vers
PostgProcedureTypeName ddtext
_Language _Language
_ProcedureType _ProcedureType
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.resultSet.sizeCategory: #XS

@VDM.viewType: #BASIC 
@VDM.private: true

@Search.searchable: true

define view entity P_PostingProcedureTypeVHT as select from dd07t 

  association [0..*] to P_PostingProcedureType as _ProcedureType on $projection.ReprocgRulePostgProcedureType = _ProcedureType.ReprocgRulePostgProcedureType
 
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
  {
    
    key domname as ReprocRuleDomName,
    
    key domvalue_l  as ReprocgRulePostgProcedureType, 
    
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key ddlanguage as Language,
    
    key as4local   as Pos2,
    key valpos     as Pos3,
    key as4vers    as Pos4,
         
    @Semantics.text: true
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8
    @Search.ranking: #HIGH
    ddtext as PostgProcedureTypeName,
    _Language,
    _ProcedureType
  }  
where
  dd07t.domname = 'FAR_PSTRL_POSTINGPROCEDURETYPE' and dd07t.as4local = 'A' and dd07t.domvalue_l between '000' and '999';