I_GteeMBillingPlanHeader

DDL: I_GTEEMBILLINGPLANHEADER SQL: IGMBPHDR Type: view BASIC Package: PSM_S4C_GM_BILLING
29 Fields 1 Data Sources 2 Associations

Grantee Management Billing Plan Header

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

Data Sources (1)

SourceAliasJoin Type
I_GteeMBillingPlanHeaderBasic BillingPlanHeader from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FinancialManagementArea _FinMgmtArea $projection.FinancialManagementArea = _FinMgmtArea.FinancialManagementArea
[0..1] I_Fund _Fund $projection.FinancialManagementArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IGMBPHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Grantee Management Billing Plan Header view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey GteeMBillingPlanHeaderUUID view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillingPlanHeaderUUID I_GteeMBillingPlanHeaderBasic GteeMBillingPlanHeaderUUID GMBPHD UUID
GrantID I_GteeMBillingPlanHeaderBasic GrantID Sender Grant
SponsoredProgram I_GteeMBillingPlanHeaderBasic SponsoredProgram Sponsored Program
WBSElementInternalID I_GteeMBillingPlanHeaderBasic WBSElementInternalID WBS Internal ID
FinancialManagementArea I_GteeMBillingPlanHeaderBasic FinancialManagementArea FM Area
Fund I_GteeMBillingPlanHeaderBasic Fund Sender Fund
GteeMBillgPlnTotAmtInDocCrcy I_GteeMBillingPlanHeaderBasic GteeMBillgPlnTotAmtInDocCrcy Total Billing Amount
GteeMBillgPlnInstlmntInDocCrcy I_GteeMBillingPlanHeaderBasic GteeMBillgPlnInstlmntInDocCrcy Installment Amount
DocumentCurrency I_GteeMBillingPlanHeaderBasic DocumentCurrency Document Currency
GteeMBillgPlnHeaderPeriodicity I_GteeMBillingPlanHeaderBasic GteeMBillgPlnHeaderPeriodicity Periodicity
GteeMBillgPlnFirstOrLastDay I_GteeMBillingPlanHeaderBasic GteeMBillgPlnFirstOrLastDay Billing Due Date
GteeMBillingPlanStatus I_GteeMBillingPlanHeaderBasic GteeMBillingPlanStatus Grants Billing Plan Status
CompanyCode I_GteeMBillingPlanHeaderBasic CompanyCode Receiver Company Code
GteeMBillingPlanValidFromDate I_GteeMBillingPlanHeaderBasic GteeMBillingPlanValidFromDate Valid From Date
GteeMBillingPlanValidToDate I_GteeMBillingPlanHeaderBasic GteeMBillingPlanValidToDate Valid To Date
GteeMBillingPlanCreatedByUser I_GteeMBillingPlanHeaderBasic GteeMBillingPlanCreatedByUser Created By
GteeMBillingPlanCrtedAtDteTme I_GteeMBillingPlanHeaderBasic GteeMBillingPlanCrtedAtDteTme Created On
GteeMBillingPlanLastChgdByUser I_GteeMBillingPlanHeaderBasic GteeMBillingPlanLastChgdByUser Changed By
GteeMBillingPlanLastChgDteTme I_GteeMBillingPlanHeaderBasic GteeMBillingPlanLastChgDteTme Changed On
_Grant _Grant
_SponsoredProgramCore _SponsoredProgramCore
_DocumentCurrency _DocumentCurrency
_CompanyCode _CompanyCode
_WBSElementBasicData _WBSElementBasicData
_FinMgmtArea _FinMgmtArea
_Fund _Fund
_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_GteeMBillingPlanHeader.
-- 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: IGMBPHDR

CREATE VIEW I_GteeMBillingPlanHeader AS
SELECT
  BillingPlanHeader.GteeMBillingPlanHeaderUUID AS GteeMBillingPlanHeaderUUID,
  BillingPlanHeader.GrantID AS GrantID,
  BillingPlanHeader.SponsoredProgram AS SponsoredProgram,
  BillingPlanHeader.WBSElementInternalID AS WBSElementInternalID,
  BillingPlanHeader.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.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
FROM I_GteeMBillingPlanHeaderBasic AS BillingPlanHeader
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
;

Learn More