R_GteeMBillingElementTP

DDL: R_GTEEMBILLINGELEMENTTP Type: view_entity TRANSACTIONAL Package: PSM_S4C_GM_BILLING
27 Fields 1 Data Sources 4 Associations

Grantee Mgmt Transacl Billing Element

R_GteeMBillingElementTP is a Transactional CDS View that provides data about "Grantee Mgmt Transacl Billing Element" in SAP S/4HANA. It reads from 1 data source (I_GteeMBillingElement) and exposes 27 fields with key field GteeMBillingElementUUID. It has 4 associations to related views. Part of development package PSM_S4C_GM_BILLING.

Data Sources (1)

SourceAliasJoin Type
I_GteeMBillingElement BillingElement from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_GteeMBillingElementAddl _GteeMBillingElementAddl $projection.GteeMBillingElementUUID = _GteeMBillingElementAddl.GteeMBillingElementUUID
[0..1] I_GteeMBillingRequest _GteeMBillingRequest $projection.GteeMBillingRequestUUID = _GteeMBillingRequest.GteeMBillingRequestUUID
[0..1] I_GteeMBillgElmntIsInProcess _GteeMBillgElmntIsInProcess $projection.GteeMBillgElmntIsInProcess = _GteeMBillgElmntIsInProcess.GteeMBillgElmntIsInProcess
[0..*] R_GteeMBillingElmntEntryTP _GteeMBillingElementEntry

Annotations (11)

NameValueLevelField
EndUserText.label Grantee Mgmt Transacl Billing Element view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey GteeMBillingElementUUID view
ObjectModel.sapObjectNodeType.name GrantsBillingElement view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillingElementUUID I_GteeMBillingElement GteeMBillingElementUUID GMBE UUID
GrantID I_GteeMBillingElement GrantID Sender Grant
SponsoredProgram I_GteeMBillingElement SponsoredProgram Sponsored Program
GteeMBillingRequestUUID _GteeMBillingElementAddl GteeMBillingRequestUUID GM Billg Req UUID
GranteeMgmtSponsor
CompanyCode
GranteeMgmtBillingRule
DocumentCurrency I_GteeMBillingElement DocumentCurrency Document Currency
NotBilledAmtInDocCrcy _GteeMBillingElementAddl NotBilledAmtInDocCrcy
BillgInProcAmtInDocCrcy _GteeMBillingElementAddl BillgInProcAmtInDocCrcy Billing in Process Amount
ToBePostponedAmtInDocCrcy _GteeMBillingElementAddl ToBePostponedAmtInDocCrcy Amount to Be Postponed
ToBeWrittenOffAmtInDocCrcy _GteeMBillingElementAddl ToBeWrittenOffAmtInDocCrcy Amount to Be Written Off
BilledRevenueAmtInDocCrcy _GteeMBillingElementAddl BilledRevenueAmtInDocCrcy Billed Revenue
ToBeBilledAmtInDocCrcy _GteeMBillingElementAddl ToBeBilledAmtInDocCrcy Amount To Be Billed
GteeMBillgElmntCreatedByUser I_GteeMBillingElement GteeMBillgElmntCreatedByUser GM Billing Element: Created By
GteeMBillgElmntCreatedAtDteTme I_GteeMBillingElement GteeMBillgElmntCreatedAtDteTme GM Billing Element: Created On
GteeMBillgElmntLastChgdByUser I_GteeMBillingElement GteeMBillgElmntLastChgdByUser GM: Billing Element: Changed By
GteeMBillgElmntLastChgDteTme I_GteeMBillingElement GteeMBillgElmntLastChgDteTme GM: Billing Element: Changed On
_Sponsor
_CompanyCode
_BillingRule
_Grant I_GteeMBillingElement _Grant
_SponsoredProgramCore I_GteeMBillingElement _SponsoredProgramCore
_DocumentCurrency I_GteeMBillingElement _DocumentCurrency
_GteeMBillgElmntIsInProcess _GteeMBillgElmntIsInProcess
_GteeMBillingRequest _GteeMBillingRequest
_GteeMBillingElementEntry _GteeMBillingElementEntry

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 R_GteeMBillingElementTP.
-- 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 R_GteeMBillingElementTP AS
SELECT
  BillingElement.GteeMBillingElementUUID AS GteeMBillingElementUUID,
  BillingElement.GrantID AS GrantID,
  BillingElement.SponsoredProgram AS SponsoredProgram,
  _GteeMBillingElementAddl.GteeMBillingRequestUUID AS GteeMBillingRequestUUID,
  BillingElement._Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  BillingElement._Grant.CompanyCode AS CompanyCode,
  BillingElement._Grant.GranteeMgmtBillingRule AS GranteeMgmtBillingRule,
  BillingElement.DocumentCurrency AS DocumentCurrency,
  _GteeMBillingElementAddl.NotBilledAmtInDocCrcy AS NotBilledAmtInDocCrcy,
  _GteeMBillingElementAddl.BillgInProcAmtInDocCrcy AS BillgInProcAmtInDocCrcy,
  _GteeMBillingElementAddl.ToBePostponedAmtInDocCrcy AS ToBePostponedAmtInDocCrcy,
  _GteeMBillingElementAddl.ToBeWrittenOffAmtInDocCrcy AS ToBeWrittenOffAmtInDocCrcy,
  _GteeMBillingElementAddl.BilledRevenueAmtInDocCrcy AS BilledRevenueAmtInDocCrcy,
  _GteeMBillingElementAddl.ToBeBilledAmtInDocCrcy AS ToBeBilledAmtInDocCrcy,
  BillingElement.GteeMBillgElmntCreatedByUser AS GteeMBillgElmntCreatedByUser,
  BillingElement.GteeMBillgElmntCreatedAtDteTme AS GteeMBillgElmntCreatedAtDteTme,
  BillingElement.GteeMBillgElmntLastChgdByUser AS GteeMBillgElmntLastChgdByUser,
  BillingElement.GteeMBillgElmntLastChgDteTme AS GteeMBillgElmntLastChgDteTme,
  BillingElement._Grant._Sponsor AS _Sponsor,
  BillingElement._Grant._CompanyCode AS _CompanyCode,
  BillingElement._Grant._BillingRule AS _BillingRule,
  BillingElement._Grant AS _Grant,
  BillingElement._SponsoredProgramCore AS _SponsoredProgramCore,
  BillingElement._DocumentCurrency AS _DocumentCurrency
FROM I_GteeMBillingElement AS BillingElement
LEFT OUTER JOIN I_GteeMBillingElementAddl AS _GteeMBillingElementAddl ON GteeMBillingElementUUID = _GteeMBillingElementAddl.GteeMBillingElementUUID  -- association [0..1]
LEFT OUTER JOIN I_GteeMBillingRequest AS _GteeMBillingRequest ON GteeMBillingRequestUUID = _GteeMBillingRequest.GteeMBillingRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_GteeMBillgElmntIsInProcess AS _GteeMBillgElmntIsInProcess ON GteeMBillgElmntIsInProcess = _GteeMBillgElmntIsInProcess.GteeMBillgElmntIsInProcess  -- association [0..1]
LEFT OUTER JOIN R_GteeMBillingElmntEntryTP AS _GteeMBillingElementEntry ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More