I_GteeMBillingElement

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_GteeMBillingElement.
-- 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: IGMBILLGELMNT

CREATE VIEW I_GteeMBillingElement AS
SELECT
  BillingElement.gteembillingelementuuid AS GteeMBillingElementUUID,
  BillingElement.grantid AS GrantID,
  BillingElement.sponsoredprogram AS SponsoredProgram,
  BillingElement.documentcurrency AS DocumentCurrency,
  BillingElement.gteembillgelmntcreatedbyuser AS GteeMBillgElmntCreatedByUser,
  BillingElement.gteembillgelmntcreatedatdtetme AS GteeMBillgElmntCreatedAtDteTme,
  BillingElement.gteembillgelmntlastchgdbyuser AS GteeMBillgElmntLastChgdByUser,
  BillingElement.gteembillgelmntlastchgdtetme AS GteeMBillgElmntLastChgDteTme
FROM gmbillgelmnt AS BillingElement
LEFT OUTER JOIN I_GteeMBillingElementEntry AS _GteeMBillingElementEntry ON GteeMBillingElementUUID = _GteeMBillingElementEntry.GteeMBillingElementUUID  -- association [0..*]
LEFT OUTER JOIN I_GteeMBillingRequestItem AS _GteeMBillingRequestItem ON GteeMBillingElementUUID = _GteeMBillingRequestItem.GteeMBillingElementUUID  -- association [0..*]
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]
;