P_Sitn2Transport

DDL: P_SITN2TRANSPORT SQL: PSITN2TR Type: view BASIC
10 Fields 2 Data Sources

P_Sitn2Transport is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (e070c, e070) and exposes 10 fields with key fields trkorr, as4user, strkorr.

Data Sources (2)

SourceAliasJoin Type
e070c _Client inner
e070 _Transport from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSITN2TR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY trkorr e070 trkorr Virtual Transport
KEY as4user e070 as4user Person Respons.
KEY strkorr e070 strkorr Parent Request
as4text _Text as4text Short Description
trfunction e070 trfunction Type
trstatus e070 trstatus Status
tarsystem e070 tarsystem Transport Target
korrdev e070 korrdev Category
as4date e070 as4date Date
as4time e070 as4time 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_Sitn2Transport.
-- 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: PSITN2TR

CREATE VIEW P_Sitn2Transport AS
SELECT
  _Transport.trkorr AS trkorr,
  _Transport.as4user AS as4user,
  _Transport.strkorr AS strkorr,
  _Text.as4text AS as4text,
  _Transport.trfunction AS trfunction,
  _Transport.trstatus AS trstatus,
  _Transport.tarsystem AS tarsystem,
  _Transport.korrdev AS korrdev,
  _Transport.as4date AS as4date,
  _Transport.as4time AS as4time
FROM e070 AS _Transport
INNER JOIN e070c AS _Client ON /* join condition not captured in parsed metadata */
;

Learn More