I_IPUTSScpDurationUsrVH

DDL: I_IPUTSSCPDURATIONUSRVH Type: view_entity BASIC Package: IPUTS_MAIN
3 Fields 1 Data Sources 1 Associations

IPUTS Scope Duration User

I_IPUTSScpDurationUsrVH is a Basic CDS View that provides data about "IPUTS Scope Duration User" in SAP S/4HANA. It reads from 1 data source (I_User) and exposes 3 fields with key field IPUTSAuthUser. It has 1 association to related views. Part of development package IPUTS_MAIN.

Data Sources (1)

SourceAliasJoin Type
I_User I_User from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_AddressPersonName _AddressPersonName $projection.AddressPersonID = _AddressPersonName.AddressPersonID and _AddressPersonName.AddressRepresentationCode = ''

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IPUTS Scope Duration User view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey IPUTSAuthUser view
VDM.viewType #BASIC view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY IPUTSAuthUser UserID User Name
IPUTSAuthUserName UserDescription Full Name
AddressPersonID AddressPersonID Person 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 I_IPUTSScpDurationUsrVH.
-- 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.

CREATE VIEW I_IPUTSScpDurationUsrVH AS
SELECT
  UserID AS IPUTSAuthUser,
  UserDescription AS IPUTSAuthUserName,
  AddressPersonID
FROM I_User
LEFT OUTER JOIN I_AddressPersonName AS _AddressPersonName ON AddressPersonID = _AddressPersonName.AddressPersonID AND _AddressPersonName.AddressRepresentationCode = ''  -- association [0..1]
;

Learn More