P_SpecPropertyAuspSearch

DDL: P_SPECPROPERTYAUSPSEARCH SQL: PSPECPRPAUSPSRCH Type: view BASIC
21 Fields 1 Data Sources

P_SpecPropertyAuspSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (ausp) and exposes 21 fields with key fields recn, actn, atinn, atzhl, mafid.

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 Internal char.
KEY atzhl atzhl Int counter
KEY mafid mafid Record type
KEY klart klart Class Type
KEY adzhl adzhl Int. counter
atwrt atwrt Char. Value
atflv atflv Value from
atawe atawe Internal UoM
atflb atflb Value to
ataw1 ataw1 Internal UoM
atcod atcod Interval limits
attlv attlv Tolerance from
attlb attlb Tolerance to
atprz atprz Percentage
atinc atinc Increment
ataut ataut Justification
aennr aennr Change Number
datuv datuv Valid-from date
lkenz lkenz Deletion Ind.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SpecPropertyAuspSearch.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PSPECPRPAUSPSRCH

CREATE VIEW P_SpecPropertyAuspSearch AS
SELECT
  substring (objek,1,20) AS recn,
  substring (objek,21,20) AS actn,
  atinn,
  atzhl,
  mafid,
  klart,
  adzhl,
  atwrt,
  atflv,
  atawe,
  atflb,
  ataw1,
  atcod,
  attlv,
  attlb,
  atprz,
  atinc,
  ataut,
  aennr,
  datuv,
  lkenz
FROM ausp
;

Learn More