I_GteeMBillgElmntItmCube

DDL: I_GTEEMBILLGELMNTITMCUBE SQL: IGMBLGELMITMCUBE Type: view BASIC

Grantee Mgmt Billing Element Item - Cube

I_GteeMBillgElmntItmCube (Basic)

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

Cross Applications

I_GteeMBillgElmntItmCube is a Basic CDS View (Cube) that provides data about "Grantee Mgmt Billing Element Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_GteeMBillingElementEntry) and exposes 14 fields with key fields GteeMBillgElmntEntrItmUUID, GteeMBillgElmntEntrItmFlowUUID. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPSM-GM-GTE-GM
CapabilitiesData Provider for Analytical Queries
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_GteeMBillingElementEntry BillingElementEntry from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Grant _Grant $projection.GrantID = _Grant.GrantID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IGMBLGELMITMCUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Grantee Mgmt Billing Element Item - Cube view
VDM.viewType #BASIC view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillgElmntEntrItmUUID GteeMBillgElmntEntrItmUUID Grantee Mgmt: Billing Element Entry UUID
KEY GteeMBillgElmntEntrItmFlowUUID GM Billing Element: Flow UUID
GrantID I_GteeMBillingElementEntry GrantID Sender Grant
SponsoredProgram I_GteeMBillingElementEntry SponsoredProgram Sponsored Program
DocumentCurrency I_GteeMBillingElementEntry DocumentCurrency Document Currency
OriginalRevenueAmtInDocCrcy I_GteeMBillingElementEntry OriginalRevenueAmtInDocCrcy Original Amount in Document Currency
ToBePostponedAmtInDocCrcy I_GteeMBillingElementEntry ToBePostponedAmtInDocCrcy Amount to Be Postponed in Document Currency
ToBeWrittenOffAmtInDocCrcy I_GteeMBillingElementEntry ToBeWrittenOffAmtInDocCrcy Amount to Be Written Off in Document Currency
BillgInProcAmtInDocCrcy Billing in Process Amount in Document Currency
BilledRevenueAmtInDocCrcy Billed Revenue Amount in Document Currency
GranteeMgmtSponsor _Grant GranteeMgmtSponsor Grant Sponsor
_SponsoredProgramCore I_GteeMBillingElementEntry _SponsoredProgramCore
_Sponsor _Grant _Sponsor
_Grant _Grant

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_GteeMBillgElmntItmCube.
-- 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: IGMBLGELMITMCUBE

CREATE VIEW I_GteeMBillgElmntItmCube AS
SELECT
  GteeMBillgElmntEntrItmUUID,
  BillingElementEntry._GteeMBillingElementEntryFlw.GteeMBillgElmntEntrItmFlowUUID AS GteeMBillgElmntEntrItmFlowUUID,
  BillingElementEntry.GrantID AS GrantID,
  BillingElementEntry.SponsoredProgram AS SponsoredProgram,
  BillingElementEntry.DocumentCurrency AS DocumentCurrency,
  BillingElementEntry.OriginalRevenueAmtInDocCrcy AS OriginalRevenueAmtInDocCrcy,
  BillingElementEntry.ToBePostponedAmtInDocCrcy AS ToBePostponedAmtInDocCrcy,
  BillingElementEntry.ToBeWrittenOffAmtInDocCrcy AS ToBeWrittenOffAmtInDocCrcy,
  BillingElementEntry._GteeMBillingElementEntryFlw.BillgInProcAmtInDocCrcy AS BillgInProcAmtInDocCrcy,
  BillingElementEntry._GteeMBillingElementEntryFlw.BilledRevenueAmtInDocCrcy AS BilledRevenueAmtInDocCrcy,
  _Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  BillingElementEntry._SponsoredProgramCore AS _SponsoredProgramCore,
  _Grant._Sponsor AS _Sponsor
FROM I_GteeMBillingElementEntry AS BillingElementEntry
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [1..1]
;