C_GteeMBillingRequestItemTP

DDL: C_GTEEMBILLINGREQUESTITEMTP Type: view_entity CONSUMPTION Package: ODATA_PSM_S4C_GM_POSTINGS
27 Fields 1 Data Sources 2 OData Services

Grantee Mgmt Billing Req Item Projection

C_GteeMBillingRequestItemTP is a Consumption CDS View that provides data about "Grantee Mgmt Billing Req Item Projection" in SAP S/4HANA. It reads from 1 data source (R_GteeMBillingRequestItemTP) and exposes 27 fields with key field GteeMBillingRequestItemUUID. It is exposed through 2 OData services (ASQL_F5524, UI_GTEEMBILLINGREQUEST_SD). Part of development package ODATA_PSM_S4C_GM_POSTINGS.

Data Sources (1)

SourceAliasJoin Type
R_GteeMBillingRequestItemTP R_GteeMBillingRequestItemTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Grantee Mgmt Billing Req Item Projection view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.representativeKey GteeMBillingRequestItemUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5524 ASQL_F5524 C2 NOT_RELEASED
UI_GTEEMBILLINGREQUEST_SD UI_GTEEMBILLINGREQUEST_SB V2 C1 NOT_RELEASED

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillingRequestItemUUID BillingRequestItem GteeMBillingRequestItemUUID Item UUID
GteeMBillingRequestUUID BillingRequestItem GteeMBillingRequestUUID GM Billg Req UUID
GteeMBillgElmntEntrItmUUID BillingRequestItem GteeMBillgElmntEntrItmUUID GMBE Entry UUID
GteeMBillingElementUUID BillingRequestItem GteeMBillingElementUUID GMBE UUID
JournalEntrySemanticKey BillingRequestItem JournalEntrySemanticKey Journal Entry/Item/Fiscal Year
GrantID
GrantName
SponsoredProgram
SponsoredProgramName
virtualAccountingDocumentTypefis_blart
virtualFundbp_geber
virtualSponsoredClassgm_sponsored_class
virtualWBSElementExternalIDps_posid_edit
virtualWBSDescriptionps_s4_post1
GteeMBillgReqItmIncldInBillg BillingRequestItem GteeMBillgReqItmIncldInBillg Included in Billing
GteeMBillgReqItmMnlBillgSel BillingRequestItem GteeMBillgReqItmMnlBillgSel Manual Billing Selection
GteeMBillingRequestItemStatus BillingRequestItem GteeMBillingRequestItemStatus
GranteeMgmtBillingRule _GteeMBillingRequest GranteeMgmtBillingRule
PostingDate
DocumentCurrency BillingRequestItem DocumentCurrency Document Currency
OpenRevenueAmtInDocCrcy BillingRequestItem OpenRevenueAmtInDocCrcy Open Revenue
ToBeBilledAmtInDocCrcy BillingRequestItem ToBeBilledAmtInDocCrcy Amount To Be Billed
ToBePostponedAmtInDocCrcy BillingRequestItem ToBePostponedAmtInDocCrcy Amount to Be Postponed
ToBeWrittenOffAmtInDocCrcy BillingRequestItem ToBeWrittenOffAmtInDocCrcy Amount to Be Written Off
GteeMBillgReqItmLastChgdBy BillingRequestItem GteeMBillgReqItmLastChgdBy GM Billing Request Item: Changed By
GteeMBillgReqItmLastChgdDteTme BillingRequestItem GteeMBillgReqItmLastChgdDteTme GM Billing Request Item: Changed On
_GteeMBillingElementEntry BillingRequestItem _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 C_GteeMBillingRequestItemTP.
-- 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 C_GteeMBillingRequestItemTP AS
SELECT
  BillingRequestItem.GteeMBillingRequestItemUUID AS GteeMBillingRequestItemUUID,
  BillingRequestItem.GteeMBillingRequestUUID AS GteeMBillingRequestUUID,
  BillingRequestItem.GteeMBillgElmntEntrItmUUID AS GteeMBillgElmntEntrItmUUID,
  BillingRequestItem.GteeMBillingElementUUID AS GteeMBillingElementUUID,
  BillingRequestItem.JournalEntrySemanticKey AS JournalEntrySemanticKey,
  BillingRequestItem._GteeMBillingElement.GrantID AS GrantID,
  BillingRequestItem._GteeMBillingElement._Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  BillingRequestItem._GteeMBillingElement.SponsoredProgram AS SponsoredProgram,
  BillingRequestItem._GteeMBillingElement._SponsoredProgramCore._Text[1:Language = $session.system_language].SponsoredProgramName AS SponsoredProgramName,
  virtual AccountingDocumentType : fis_blart AS virtualAccountingDocumentTypefis_blart,
  virtual Fund : bp_geber AS virtualFundbp_geber,
  virtual SponsoredClass : gm_sponsored_class AS virtualSponsoredClassgm_sponsored_class,
  virtual WBSElementExternalID : ps_posid_edit AS virtualWBSElementExternalIDps_posid_edit,
  virtual WBSDescription : ps_s4_post1 AS virtualWBSDescriptionps_s4_post1,
  BillingRequestItem.GteeMBillgReqItmIncldInBillg AS GteeMBillgReqItmIncldInBillg,
  BillingRequestItem.GteeMBillgReqItmMnlBillgSel AS GteeMBillgReqItmMnlBillgSel,
  BillingRequestItem.GteeMBillingRequestItemStatus AS GteeMBillingRequestItemStatus,
  _GteeMBillingRequest.GranteeMgmtBillingRule AS GranteeMgmtBillingRule,
  BillingRequestItem._GteeMBillingElementEntry.PostingDate AS PostingDate,
  BillingRequestItem.DocumentCurrency AS DocumentCurrency,
  BillingRequestItem.OpenRevenueAmtInDocCrcy AS OpenRevenueAmtInDocCrcy,
  BillingRequestItem.ToBeBilledAmtInDocCrcy AS ToBeBilledAmtInDocCrcy,
  BillingRequestItem.ToBePostponedAmtInDocCrcy AS ToBePostponedAmtInDocCrcy,
  BillingRequestItem.ToBeWrittenOffAmtInDocCrcy AS ToBeWrittenOffAmtInDocCrcy,
  BillingRequestItem.GteeMBillgReqItmLastChgdBy AS GteeMBillgReqItmLastChgdBy,
  BillingRequestItem.GteeMBillgReqItmLastChgdDteTme AS GteeMBillgReqItmLastChgdDteTme,
  BillingRequestItem._GteeMBillingElementEntry AS _GteeMBillingElementEntry
FROM R_GteeMBillingRequestItemTP
;

Learn More