P_PostingProcedureTypeVHT

DDL: P_POSTINGPROCEDURETYPEVHT SQL: PPSTNGPROCTYPET Type: view BASIC

P_PostingProcedureTypeVHT is a Basic CDS View 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.

1 data source(s) 9 fields

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 (10)

NameValueLevelField
AbapCatalog.sqlViewName PPSTNGPROCTYPET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog.sqlViewName: 'PPSTNGPROCTYPET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.resultSet.sizeCategory: #XS

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@Search.searchable: true

define view 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';

Learn More