P_SU22_NEW_AUTHVALTRC

DDL: P_SU2X_NEW_AUTHVALTRC SQL: PSU22_NEW_VALTRC Type: view Package: SU2X
17 Fields 2 Data Sources

Neue Einträge zur Anwendung in USOB_AUTHVALTRC

P_SU22_NEW_AUTHVALTRC is a CDS View that provides data about "Neue Einträge zur Anwendung in USOB_AUTHVALTRC" in SAP S/4HANA. It reads from 2 data sources (usob_authvaltrc, usobx) and exposes 17 fields with key fields name, type. Part of development package SU2X.

Data Sources (2)

SourceAliasJoin Type
usob_authvaltrc trc from
usobx x left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSU22_NEW_VALTRC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Neue Einträge zur Anwendung in USOB_AUTHVALTRC view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY name usob_authvaltrc name Zone name
KEY type usob_authvaltrc type Worklist Type
object usob_authvaltrc object TRFM Object
field1 usob_authvaltrc field1 Value
field2 usob_authvaltrc field2 Value
field3 usob_authvaltrc field3 Value
field4 usob_authvaltrc field4 Value
field5 usob_authvaltrc field5 Value
field6 usob_authvaltrc field6 Value
field7 usob_authvaltrc field7 Value
field8 usob_authvaltrc field8 Value
field9 usob_authvaltrc field9 Value
field0 usob_authvaltrc field0 Value
moddate usob_authvaltrc moddate Modification date
modtime usob_authvaltrc modtime Time
moddate_x usobx moddate Modification date
modtime_x usobx modtime Time

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_SU22_NEW_AUTHVALTRC.
-- 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: PSU22_NEW_VALTRC

CREATE VIEW P_SU22_NEW_AUTHVALTRC AS
SELECT
  trc.name AS name,
  trc.type AS type,
  trc.object AS object,
  trc.field1 AS field1,
  trc.field2 AS field2,
  trc.field3 AS field3,
  trc.field4 AS field4,
  trc.field5 AS field5,
  trc.field6 AS field6,
  trc.field7 AS field7,
  trc.field8 AS field8,
  trc.field9 AS field9,
  trc.field0 AS field0,
  trc.moddate AS moddate,
  trc.modtime AS modtime,
  x.moddate AS moddate_x,
  x.modtime AS modtime_x
FROM usob_authvaltrc AS trc
LEFT OUTER JOIN usobx AS x ON /* join condition not captured in parsed metadata */
;

Learn More