P_SCRL_PARAMETER_TRANSPORTED

DDL: P_SCRL_PARAMETER_TRANSPORTED SQL: P_SCRL_PARA_T_V Type: view Package: S_CRL_MODEL
4 Fields 2 Data Sources

CRL: Parameter transported view

P_SCRL_PARAMETER_TRANSPORTED is a CDS View that provides data about "CRL: Parameter transported view" in SAP S/4HANA. It reads from 2 data sources (scrl_parameter, scrl_parameter) and exposes 4 fields with key fields LibraryID, MethodID, ParameterID. Part of development package S_CRL_MODEL.

Data Sources (2)

SourceAliasJoin Type
scrl_parameter CurrentVersionParameter from
scrl_parameter TransportedParameter left_outer

Annotations (5)

NameValueLevelField
EndUserText.label CRL: Parameter transported view view
AbapCatalog.sqlViewName P_SCRL_PARA_T_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_INDEPENDENT view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY LibraryID scrl_parameter library_id Library ID
KEY MethodID scrl_parameter method_id Validation Method
KEY ParameterID scrl_parameter parameter_id Parameter ID
TranportedVersionNumber scrl_parameter version_number Version Number

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_SCRL_PARAMETER_TRANSPORTED.
-- 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: P_SCRL_PARA_T_V

CREATE VIEW P_SCRL_PARAMETER_TRANSPORTED AS
SELECT
  CurrentVersionParameter.library_id AS LibraryID,
  CurrentVersionParameter.method_id AS MethodID,
  CurrentVersionParameter.parameter_id AS ParameterID,
  TransportedParameter.version_number AS TranportedVersionNumber
FROM scrl_parameter AS CurrentVersionParameter
LEFT OUTER JOIN scrl_parameter AS TransportedParameter ON /* join condition not captured in parsed metadata */
;

Learn More