I_GteeMBillingPlanHeaderBasic

DDL: I_GTEEMBILLINGPLANHEADERBASIC SQL: IGMBPHDRBSC Type: view BASIC Package: PSM_S4C_GM_BILLING
27 Fields 1 Data Sources 7 Associations

GteeM Billing Plan Header Basic

I_GteeMBillingPlanHeaderBasic is a Basic CDS View that provides data about "GteeM Billing Plan Header Basic" in SAP S/4HANA. It reads from 1 data source (gmbillgplhdr) and exposes 27 fields with key field GteeMBillingPlanHeaderUUID. It has 7 associations to related views. Part of development package PSM_S4C_GM_BILLING.

Data Sources (1)

SourceAliasJoin Type
gmbillgplhdr BillingPlanHeader from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_Grant _Grant $projection.GrantID = _Grant.GrantID
[0..1] I_SponsoredProgramCore _SponsoredProgramCore $projection.SponsoredProgram = _SponsoredProgramCore.SponsoredProgram
[0..1] I_Currency _DocumentCurrency $projection.DocumentCurrency = _DocumentCurrency.Currency
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..1] I_GteeMBillingPlanStatus _GteeMBillingPlanStatus $projection.GteeMBillingPlanStatus = _GteeMBillingPlanStatus.GteeMBillingPlanStatus
[0..1] I_GteeMBillingPlanPeriodicity _GteeMBillingPlanPeriodicity $projection.GteeMBillgPlnHeaderPeriodicity = _GteeMBillingPlanPeriodicity.GteeMBillgPlnHeaderPeriodicity
[0..1] I_GteeMBillgPlnFirstOrLastDay _GteeMBillgPlnFirstOrLastDay $projection.GteeMBillgPlnFirstOrLastDay = _GteeMBillgPlnFirstOrLastDay.GteeMBillgPlnFirstOrLastDay

Annotations (12)

NameValueLevelField
EndUserText.label GteeM Billing Plan Header Basic view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IGMBPHDRBSC view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey GteeMBillingPlanHeaderUUID view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillingPlanHeaderUUID gmbillgplhdr gteembillingplanheaderuuid GMBPHD UUID
GrantID gmbillgplhdr grantid Sender Grant
SponsoredProgram gmbillgplhdr sponsoredprogram Sponsored Program
WBSElementInternalID gmbillgplhdr wbselementinternalid WBS Internal ID
FinancialManagementArea
Fund gmbillgplhdr fund Sender Fund
GteeMBillgPlnTotAmtInDocCrcy gmbillgplhdr gteembillgplntotamtindoccrcy Total Billing Amount
GteeMBillgPlnInstlmntInDocCrcy gmbillgplhdr gteembillgplninstlmntindoccrcy Installment Amount
DocumentCurrency gmbillgplhdr documentcurrency Document Currency
GteeMBillgPlnHeaderPeriodicity gmbillgplhdr gteembillgplnheaderperiodicity Periodicity
GteeMBillgPlnFirstOrLastDay gmbillgplhdr gteembillgplnfirstorlastday Billing Due Date
GteeMBillingPlanStatus gmbillgplhdr gteembillingplanheaderstatus Grants Billing Plan Status
CompanyCode _Grant CompanyCode Receiver Company Code
GteeMBillingPlanValidFromDate gmbillgplhdr gteembillingplanvalidfromdate Valid From Date
GteeMBillingPlanValidToDate gmbillgplhdr gteembillingplanvalidtodate Valid To Date
GteeMBillingPlanCreatedByUser gmbillgplhdr gteembillgplanhdrcreatedby Created By
GteeMBillingPlanCrtedAtDteTme gmbillgplhdr gteembillgplanhdrcrtedatdtetme Created On
GteeMBillingPlanLastChgdByUser gmbillgplhdr gteembillgplanhdrlastchangedby Changed By
GteeMBillingPlanLastChgDteTme gmbillgplhdr gteembillgplanhdrchgdatdtetime Changed On
_Grant _Grant
_SponsoredProgramCore _SponsoredProgramCore
_DocumentCurrency _DocumentCurrency
_CompanyCode _Grant _CompanyCode
_WBSElementBasicData _WBSElementBasicData
_GteeMBillingPlanStatus _GteeMBillingPlanStatus
_GteeMBillingPlanPeriodicity _GteeMBillingPlanPeriodicity
_GteeMBillgPlnFirstOrLastDay _GteeMBillgPlnFirstOrLastDay

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_GteeMBillingPlanHeaderBasic.
-- 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: IGMBPHDRBSC

CREATE VIEW I_GteeMBillingPlanHeaderBasic AS
SELECT
  BillingPlanHeader.gteembillingplanheaderuuid AS GteeMBillingPlanHeaderUUID,
  BillingPlanHeader.grantid AS GrantID,
  BillingPlanHeader.sponsoredprogram AS SponsoredProgram,
  BillingPlanHeader.wbselementinternalid AS WBSElementInternalID,
  _Grant._CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  BillingPlanHeader.fund AS Fund,
  BillingPlanHeader.gteembillgplntotamtindoccrcy AS GteeMBillgPlnTotAmtInDocCrcy,
  BillingPlanHeader.gteembillgplninstlmntindoccrcy AS GteeMBillgPlnInstlmntInDocCrcy,
  BillingPlanHeader.documentcurrency AS DocumentCurrency,
  BillingPlanHeader.gteembillgplnheaderperiodicity AS GteeMBillgPlnHeaderPeriodicity,
  BillingPlanHeader.gteembillgplnfirstorlastday AS GteeMBillgPlnFirstOrLastDay,
  BillingPlanHeader.gteembillingplanheaderstatus AS GteeMBillingPlanStatus,
  _Grant.CompanyCode AS CompanyCode,
  BillingPlanHeader.gteembillingplanvalidfromdate AS GteeMBillingPlanValidFromDate,
  BillingPlanHeader.gteembillingplanvalidtodate AS GteeMBillingPlanValidToDate,
  BillingPlanHeader.gteembillgplanhdrcreatedby AS GteeMBillingPlanCreatedByUser,
  BillingPlanHeader.gteembillgplanhdrcrtedatdtetme AS GteeMBillingPlanCrtedAtDteTme,
  BillingPlanHeader.gteembillgplanhdrlastchangedby AS GteeMBillingPlanLastChgdByUser,
  BillingPlanHeader.gteembillgplanhdrchgdatdtetime AS GteeMBillingPlanLastChgDteTme,
  _Grant._CompanyCode AS _CompanyCode
FROM gmbillgplhdr AS BillingPlanHeader
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_SponsoredProgramCore AS _SponsoredProgramCore ON SponsoredProgram = _SponsoredProgramCore.SponsoredProgram  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_GteeMBillingPlanStatus AS _GteeMBillingPlanStatus ON GteeMBillingPlanStatus = _GteeMBillingPlanStatus.GteeMBillingPlanStatus  -- association [0..1]
LEFT OUTER JOIN I_GteeMBillingPlanPeriodicity AS _GteeMBillingPlanPeriodicity ON GteeMBillgPlnHeaderPeriodicity = _GteeMBillingPlanPeriodicity.GteeMBillgPlnHeaderPeriodicity  -- association [0..1]
LEFT OUTER JOIN I_GteeMBillgPlnFirstOrLastDay AS _GteeMBillgPlnFirstOrLastDay ON GteeMBillgPlnFirstOrLastDay = _GteeMBillgPlnFirstOrLastDay.GteeMBillgPlnFirstOrLastDay  -- association [0..1]
;

Learn More