P_ExposureBucket_HR_Version

DDL: P_EXPOSUREBUCKET_HR_VERSION SQL: PEXPBUCKETHRV Type: view BASIC
4 Fields 1 Data Sources

P_ExposureBucket_HR_Version is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_ExposureBucket_HR) and exposes 4 fields with key fields CompanyCode, FinancialTransaction, ExposureBucket.

Data Sources (1)

SourceAliasJoin Type
P_ExposureBucket_HR P_ExposureBucket_HR from

Parameters (2)

NameTypeDefault
P_ValidityStartDate abap.dats
P_ValidityStartTime abap.tims

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PEXPBUCKETHRV view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_ExposureBucket_HR CompanyCode Receiver Company Code
KEY FinancialTransaction P_ExposureBucket_HR FinancialTransaction Transaction
KEY ExposureBucket P_ExposureBucket_HR ExposureBucket Hedged Item ID
MaxVersion

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_ExposureBucket_HR_Version.
-- 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: PEXPBUCKETHRV
-- Parameters: P_ValidityStartDate : abap.dats, P_ValidityStartTime : abap.tims

CREATE VIEW P_ExposureBucket_HR_Version AS
SELECT
  P_ExposureBucket_HR.CompanyCode AS CompanyCode,
  P_ExposureBucket_HR.FinancialTransaction AS FinancialTransaction,
  P_ExposureBucket_HR.ExposureBucket AS ExposureBucket,
  max ( P_ExposureBucket_HR.Version ) AS MaxVersion
FROM P_ExposureBucket_HR
;

Learn More