I_UtilsNmbrOfAllwdMRCtrlCodeT

DDL: I_UTILSNMBROFALLWDMRCTRLCODET SQL: IENOFAMTRRDNGCCT Type: view BASIC

Number Of Allowed Meter Reading Control Codes - Text

I_UtilsNmbrOfAllwdMRCtrlCodeT (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

UtilsNmbrOfAllwdMtrRdngCtrlTxt · Utilities

I_UtilsNmbrOfAllwdMRCtrlCodeT is a Basic CDS View that provides data about "Number Of Allowed Meter Reading Control Codes - Text" in SAP S/4HANA. It reads from 1 data source (te438t) and exposes 5 fields with key fields Language, NmbrOfAllwdMtrRdngsCntrlCode. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-MD
CapabilitiesLanguage-Dependent Text, Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageUtilities for SAP S/4HANA
Description <p>This CDS view retrieves data for IS-U contract history.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
te438t te438t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UtilsNmbrOfAllwdMRCtrlCode _UtilsNmbrOfAllwdMRCtrlCode $projection.NmbrOfAllwdMtrRdngsCntrlCode = _UtilsNmbrOfAllwdMRCtrlCode.NmbrOfAllwdMtrRdngsCntrlCode
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (15)

NameValueLevelField
EndUserText.label Number Of Allowed Meter Reading Control Codes - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey NmbrOfAllwdMtrRdngsCntrlCode view
AbapCatalog.sqlViewName IENOFAMTRRDNGCCT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name UtilsNmbrOfAllwdMtrRdngCtrlTxt view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language spras Off. Language
KEY NmbrOfAllwdMtrRdngsCntrlCode ablesartst Control of perm. number of cust. MRs and autom. estimations
NmbrOfAllwdMtrRdngsCntrlName text30 Text (30 Characters)
_UtilsNmbrOfAllwdMRCtrlCode _UtilsNmbrOfAllwdMRCtrlCode
_Language _Language

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_UtilsNmbrOfAllwdMRCtrlCodeT.
-- 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: IENOFAMTRRDNGCCT

CREATE VIEW I_UtilsNmbrOfAllwdMRCtrlCodeT AS
SELECT
  spras AS Language,
  ablesartst AS NmbrOfAllwdMtrRdngsCntrlCode,
  text30 AS NmbrOfAllwdMtrRdngsCntrlName
FROM te438t
LEFT OUTER JOIN I_UtilsNmbrOfAllwdMRCtrlCode AS _UtilsNmbrOfAllwdMRCtrlCode ON NmbrOfAllwdMtrRdngsCntrlCode = _UtilsNmbrOfAllwdMRCtrlCode.NmbrOfAllwdMtrRdngsCntrlCode  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;