I_CAPromiseToPayStatusText

DDL: I_CAPROMISETOPAYSTATUSTEXT SQL: ICAPRMS2PSTST Type: view BASIC

Text für Status des Zahlungsversprechens

I_CAPromiseToPayStatusText is a Basic CDS View that provides data about "Text für Status des Zahlungsversprechens" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields CAPromiseToPayStatus, Language. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CAPromiseToPayStatus _CAPromiseToPayStatus $projection.CAPromiseToPayStatus = _CAPromiseToPayStatus.CAPromiseToPayStatus
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CAPromiseToPayStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ICAPRMS2PSTST view
EndUserText.label Text für Status des Zahlungsversprechens view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CAPromiseToPayStatus
KEY Language ddlanguage
CAPromiseToPayStatusName dd07t ddtext
_CAPromiseToPayStatus _CAPromiseToPayStatus
_Language _Language 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'CAPromiseToPayStatus'
@ObjectModel.usageType.dataClass: #CUSTOMIZING 
@ObjectModel.usageType.serviceQuality: #C 
@ObjectModel.usageType.sizeCategory: #L 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ICAPRMS2PSTST'
@EndUserText.label: 'Text für Status des Zahlungsversprechens'
@VDM.viewType: #BASIC

define view I_CAPromiseToPayStatusText as select from dd07t 

association [0..1] to I_CAPromiseToPayStatus as _CAPromiseToPayStatus on
  $projection.CAPromiseToPayStatus = _CAPromiseToPayStatus.CAPromiseToPayStatus
    
association [0..1] to I_Language as _Language on
    $projection.Language = _Language.Language 

{
    @ObjectModel.foreignKey.association: '_CAPromiseToPayStatus'
    key cast ( substring( domvalue_l, 1, 1 ) as ppsta_kk ) as CAPromiseToPayStatus,
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key ddlanguage as Language,
        
    @Semantics.text: true    
    dd07t.ddtext as  CAPromiseToPayStatusName,
    _CAPromiseToPayStatus,
    _Language
  
}where dd07t.domname = 'PPSTA_KK' and dd07t.as4local = 'A'

Learn More