R_GteeMBillingPlanTP

DDL: R_GTEEMBILLINGPLANTP Type: view_entity TRANSACTIONAL Package: PSM_S4C_GM_BILLING
38 Fields 1 Data Sources 1 Associations

Grantee Mgmt Transactional Billing Plan

R_GteeMBillingPlanTP is a Transactional CDS View that provides data about "Grantee Mgmt Transactional Billing Plan" in SAP S/4HANA. It reads from 1 data source (I_GteeMBillingPlanHeader) and exposes 38 fields with key field GteeMBillingPlanHeaderUUID. It has 1 association to related views. Part of development package PSM_S4C_GM_BILLING.

Data Sources (1)

SourceAliasJoin Type
I_GteeMBillingPlanHeader BillingPlanHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_GteeMBillingPlanItemTP _GteeMBillingPlanItem

Annotations (11)

NameValueLevelField
EndUserText.label Grantee Mgmt Transactional Billing Plan view
AccessControl.authorizationCheck #MANDATORY 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 GteeMBillingPlanHeaderUUID view
ObjectModel.sapObjectNodeType.name GrantsBillingPlan view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillingPlanHeaderUUID I_GteeMBillingPlanHeader GteeMBillingPlanHeaderUUID GMBPHD UUID
GrantID I_GteeMBillingPlanHeader GrantID Sender Grant
SponsoredProgram I_GteeMBillingPlanHeader SponsoredProgram Sponsored Program
GranteeMgmtSponsor
FinancialManagementArea I_GteeMBillingPlanHeader FinancialManagementArea FM Area
Fund I_GteeMBillingPlanHeader Fund Sender Fund
WBSElementInternalID I_GteeMBillingPlanHeader WBSElementInternalID WBS Internal ID
WBSElementExternalID
DocumentCurrency I_GteeMBillingPlanHeader DocumentCurrency Document Currency
GteeMBillgPlnTotAmtInDocCrcy I_GteeMBillingPlanHeader GteeMBillgPlnTotAmtInDocCrcy Total Billing Amount
GteeMBillgPlnInstlmntInDocCrcy I_GteeMBillingPlanHeader GteeMBillgPlnInstlmntInDocCrcy Installment Amount
GteeMBillgPlnItemTotInDocCrcy _GteeMBillingPlanHdrAddl GteeMBillgPlnItemTotInDocCrcy
GteeMBillgPlnBilledInDocCrcy _GteeMBillingPlanHdrAddl GteeMBillgPlnBilledInDocCrcy
BillgInProcAmtInDocCrcy _GteeMBillingPlanHdrAddl BillgInProcAmtInDocCrcy Billing in Process Amount
BilledRevenueAmtInDocCrcy _GteeMBillingPlanHdrAddl BilledRevenueAmtInDocCrcy Billed Revenue
GteeMBillgPlnHeaderPeriodicity I_GteeMBillingPlanHeader GteeMBillgPlnHeaderPeriodicity Periodicity
GteeMBillgPlnFirstOrLastDay I_GteeMBillingPlanHeader GteeMBillgPlnFirstOrLastDay Billing Due Date
GteeMBillingPlanStatus I_GteeMBillingPlanHeader GteeMBillingPlanStatus
CompanyCode I_GteeMBillingPlanHeader CompanyCode Receiver Company Code
GteeMBillingPlanValidFromDate I_GteeMBillingPlanHeader GteeMBillingPlanValidFromDate Valid From Date
GteeMBillingPlanValidToDate I_GteeMBillingPlanHeader GteeMBillingPlanValidToDate Valid To Date
GteeMBillingPlanCreatedByUser I_GteeMBillingPlanHeader GteeMBillingPlanCreatedByUser
GteeMBillingPlanCrtedAtDteTme I_GteeMBillingPlanHeader GteeMBillingPlanCrtedAtDteTme
GteeMBillingPlanLastChgdByUser I_GteeMBillingPlanHeader GteeMBillingPlanLastChgdByUser
GteeMBillingPlanLastChgDteTme I_GteeMBillingPlanHeader GteeMBillingPlanLastChgDteTme
_DocumentCurrency I_GteeMBillingPlanHeader _DocumentCurrency
_CompanyCode I_GteeMBillingPlanHeader _CompanyCode
_Fund I_GteeMBillingPlanHeader _Fund
_FinMgmtArea I_GteeMBillingPlanHeader _FinMgmtArea
_Grant I_GteeMBillingPlanHeader _Grant
_SponsoredProgramCore I_GteeMBillingPlanHeader _SponsoredProgramCore
_Sponsor
_WBSElementBasicData I_GteeMBillingPlanHeader _WBSElementBasicData
_WBSElementExternalID _WBSElementExternalID
_GteeMBillingPlanStatus I_GteeMBillingPlanHeader _GteeMBillingPlanStatus
_GteeMBillingPlanPeriodicity I_GteeMBillingPlanHeader _GteeMBillingPlanPeriodicity
_GteeMBillgPlnFirstOrLastDay I_GteeMBillingPlanHeader _GteeMBillgPlnFirstOrLastDay
_GteeMBillingPlanItem _GteeMBillingPlanItem

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_GteeMBillingPlanTP.
-- 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_GteeMBillingPlanTP AS
SELECT
  BillingPlanHeader.GteeMBillingPlanHeaderUUID AS GteeMBillingPlanHeaderUUID,
  BillingPlanHeader.GrantID AS GrantID,
  BillingPlanHeader.SponsoredProgram AS SponsoredProgram,
  BillingPlanHeader._Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  BillingPlanHeader.FinancialManagementArea AS FinancialManagementArea,
  BillingPlanHeader.Fund AS Fund,
  BillingPlanHeader.WBSElementInternalID AS WBSElementInternalID,
  BillingPlanHeader._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  BillingPlanHeader.DocumentCurrency AS DocumentCurrency,
  BillingPlanHeader.GteeMBillgPlnTotAmtInDocCrcy AS GteeMBillgPlnTotAmtInDocCrcy,
  BillingPlanHeader.GteeMBillgPlnInstlmntInDocCrcy AS GteeMBillgPlnInstlmntInDocCrcy,
  _GteeMBillingPlanHdrAddl.GteeMBillgPlnItemTotInDocCrcy AS GteeMBillgPlnItemTotInDocCrcy,
  _GteeMBillingPlanHdrAddl.GteeMBillgPlnBilledInDocCrcy AS GteeMBillgPlnBilledInDocCrcy,
  _GteeMBillingPlanHdrAddl.BillgInProcAmtInDocCrcy AS BillgInProcAmtInDocCrcy,
  _GteeMBillingPlanHdrAddl.BilledRevenueAmtInDocCrcy AS BilledRevenueAmtInDocCrcy,
  BillingPlanHeader.GteeMBillgPlnHeaderPeriodicity AS GteeMBillgPlnHeaderPeriodicity,
  BillingPlanHeader.GteeMBillgPlnFirstOrLastDay AS GteeMBillgPlnFirstOrLastDay,
  BillingPlanHeader.GteeMBillingPlanStatus AS GteeMBillingPlanStatus,
  BillingPlanHeader.CompanyCode AS CompanyCode,
  BillingPlanHeader.GteeMBillingPlanValidFromDate AS GteeMBillingPlanValidFromDate,
  BillingPlanHeader.GteeMBillingPlanValidToDate AS GteeMBillingPlanValidToDate,
  BillingPlanHeader.GteeMBillingPlanCreatedByUser AS GteeMBillingPlanCreatedByUser,
  BillingPlanHeader.GteeMBillingPlanCrtedAtDteTme AS GteeMBillingPlanCrtedAtDteTme,
  BillingPlanHeader.GteeMBillingPlanLastChgdByUser AS GteeMBillingPlanLastChgdByUser,
  BillingPlanHeader.GteeMBillingPlanLastChgDteTme AS GteeMBillingPlanLastChgDteTme,
  BillingPlanHeader._DocumentCurrency AS _DocumentCurrency,
  BillingPlanHeader._CompanyCode AS _CompanyCode,
  BillingPlanHeader._Fund AS _Fund,
  BillingPlanHeader._FinMgmtArea AS _FinMgmtArea,
  BillingPlanHeader._Grant AS _Grant,
  BillingPlanHeader._SponsoredProgramCore AS _SponsoredProgramCore,
  BillingPlanHeader._Grant._Sponsor AS _Sponsor,
  BillingPlanHeader._WBSElementBasicData AS _WBSElementBasicData,
  BillingPlanHeader._GteeMBillingPlanStatus AS _GteeMBillingPlanStatus,
  BillingPlanHeader._GteeMBillingPlanPeriodicity AS _GteeMBillingPlanPeriodicity,
  BillingPlanHeader._GteeMBillgPlnFirstOrLastDay AS _GteeMBillgPlnFirstOrLastDay
FROM I_GteeMBillingPlanHeader AS BillingPlanHeader
LEFT OUTER JOIN R_GteeMBillingPlanItemTP AS _GteeMBillingPlanItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More