I_UtilitiesPortion

DDL: I_UTILITIESPORTION SQL: IEPORTION Type: view BASIC

Portion

I_UtilitiesPortion is a Basic CDS View (Dimension) that provides data about "Portion" in SAP S/4HANA. It reads from 1 data source (te420) and exposes 5 fields with key field UtilitiesPortion. It has 1 association to related views.

SAP Help Documentation

CategoryMiscellaneous
Data CategoryDimension
StatusC1
Purpose
This CDS view retrieves the portion schedule master data.

Prerequisites
Authorizations The following authorization objects are required to use this CDS view: E_PORTION (Authorization to display IS-U schedule master data for portions)

Structure
Important fields in this view include the following: Field Name Description UtilitiesPortion Portion UtilsDefaultBdgtBillgCycle Allowed Budget Billing Cycles

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
te420 te420 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UtilsPortnDfltBdgtBillgCyc _UtilitiesBdgtBillgCyc $projection.UtilsDefaultBdgtBillgCycle = _UtilitiesBdgtBillgCyc.UtilsDefaultBdgtBillgCycle

Annotations (14)

NameValueLevelField
EndUserText.label Portion view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IEPORTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey UtilitiesPortion view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesPortion te420 termschl Portion
UtilitiesPortionName
AuthorizationGroup te420 begru AuthorizGroup
UtilsDefaultBdgtBillgCycle
_UtilitiesBdgtBillgCyc _UtilitiesBdgtBillgCyc

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_UtilitiesPortion.
-- 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: IEPORTION

CREATE VIEW I_UtilitiesPortion AS
SELECT
  te420.termschl AS UtilitiesPortion,
  cast(te420.termtext as e_portion_name_vdm preserving type) AS UtilitiesPortionName,
  te420.begru AS AuthorizationGroup,
  cast(te420.abszyk as e_abszykter_vdm preserving type) AS UtilsDefaultBdgtBillgCycle
FROM te420
LEFT OUTER JOIN I_UtilsPortnDfltBdgtBillgCyc AS _UtilitiesBdgtBillgCyc ON UtilsDefaultBdgtBillgCycle = _UtilitiesBdgtBillgCyc.UtilsDefaultBdgtBillgCycle  -- association [0..1]
;