P_SpecPropertyAuspSearch

DDL: P_SPECPROPERTYAUSPSEARCH SQL: PSPECPRPAUSPSRCH Type: view BASIC Package: CBUI

Basic Search to get RECN, ACTN from OBJEK

P_SpecPropertyAuspSearch is a Basic CDS View that provides data about "Basic Search to get RECN, ACTN from OBJEK" in SAP S/4HANA. It reads from 1 data source (ausp) and exposes 21 fields with key fields recn, actn, atinn, atzhl, mafid. Part of development package CBUI.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
ausp ausp from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSPECPRPAUSPSRCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY recn
KEY actn
KEY atinn atinn
KEY atzhl atzhl
KEY mafid mafid
KEY klart klart
KEY adzhl adzhl
atwrt atwrt
atflv atflv
atawe atawe
atflb atflb
ataw1 ataw1
atcod atcod
attlv attlv
attlb attlb
atprz atprz
atinc atinc
ataut ataut
aennr aennr
datuv datuv
lkenz lkenz 
@AbapCatalog.sqlViewName: 'PSPECPRPAUSPSRCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Basic Search to get RECN, ACTN from OBJEK'

@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_SpecPropertyAuspSearch
as select from ausp
{
   key substring (objek,1,20)  as recn,
   key substring (objek,21,20) as actn,
   key atinn,
   key atzhl,
   key mafid,
   key klart,
   key adzhl,
   atwrt,
   atflv,
   atawe,
   atflb,
   ataw1,
   atcod,
   attlv,
   attlb,
   atprz,
   atinc,
   ataut,
   aennr,
   datuv,
   lkenz
}

Learn More