I_PaymentProcessingStatus

DDL: I_PAYMENTPROCESSINGSTATUS SQL: IPAYMENTSTATUS Type: view BASIC

Payment Processing Status

I_PaymentProcessingStatus is a Basic CDS View that provides data about "Payment Processing Status" in SAP S/4HANA. It reads from 2 data sources (dd07t, dd07l) and exposes 4 fields with key fields Language, DomainValueLow.

Data Sources (2)

SourceAliasJoin Type
dd07t _dd07t left_outer
dd07l dd07l from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPAYMENTSTATUS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Payment Processing Status view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropogatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language dd07t ddlanguage
KEY DomainValueLow dd07l domvalue_l
PaymentProcessingStatus dd07t ddtext
_Language _Language
@AbapCatalog.sqlViewName: 'IPAYMENTSTATUS'
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Payment Processing Status'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropogatedAnnotations: true

define view I_PaymentProcessingStatus as select from dd07l as dd07l
left outer join dd07t as _dd07t on dd07l.as4local = _dd07t.as4local
                 and dd07l.as4vers = _dd07t.as4vers
                 and dd07l.domname = _dd07t.domname
                 and dd07l.valpos = _dd07t.valpos
association[0..1] to I_Language as _Language on $projection.Language = _Language.Language                 
{   
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key _dd07t.ddlanguage as Language,
    key dd07l.domvalue_l as DomainValueLow,
    @Semantics.text   
    _dd07t.ddtext as PaymentProcessingStatus,
    
    /*associations*/
    _Language
} where dd07l.domname = 'FCLM_PYMSTATUS_TXT_GEN' and dd07l.as4local = 'A'