I_GteeMBillingElementAddl

DDL: I_GTEEMBILLINGELEMENTADDL SQL: IGMGBEADD Type: view COMPOSITE Package: PSM_S4C_GM_BILLING

Grantee Mgmt Billing Element Additional

I_GteeMBillingElementAddl is a Composite CDS View that provides data about "Grantee Mgmt Billing Element Additional" in SAP S/4HANA. It reads from 1 data source (P_GteeMBillingElementAddl) and exposes 9 fields with key field GteeMBillingElementUUID. Part of development package PSM_S4C_GM_BILLING.

Data Sources (1)

SourceAliasJoin Type
P_GteeMBillingElementAddl Main from

Annotations (13)

NameValueLevelField
EndUserText.label Grantee Mgmt Billing Element Additional view
AbapCatalog.sqlViewName IGMGBEADD view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillingElementUUID P_GteeMBillingElementAddl GteeMBillingElementUUID GMBE UUID
GteeMBillingRequestUUID P_GteeMBillingElementAddl GteeMBillingRequestUUID GM Billg Req UUID
DocumentCurrency P_GteeMBillingElementAddl DocumentCurrency Document Currency
NotBilledAmtInDocCrcy P_GteeMBillingElementAddl NotBilledAmtInDocCrcy
BillgInProcAmtInDocCrcy P_GteeMBillingElementAddl BillgInProcAmtInDocCrcy Billing in Process Amount
ToBePostponedAmtInDocCrcy P_GteeMBillingElementAddl ToBePostponedAmtInDocCrcy Amount to Be Postponed
ToBeWrittenOffAmtInDocCrcy P_GteeMBillingElementAddl ToBeWrittenOffAmtInDocCrcy Amount to Be Written Off
BilledRevenueAmtInDocCrcy P_GteeMBillingElementAddl BilledRevenueAmtInDocCrcy Billed Revenue
ToBeBilledAmtInDocCrcy P_GteeMBillingElementAddl ToBeBilledAmtInDocCrcy Amount To Be Billed

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_GteeMBillingElementAddl.
-- 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: IGMGBEADD

CREATE VIEW I_GteeMBillingElementAddl AS
SELECT
  Main.GteeMBillingElementUUID AS GteeMBillingElementUUID,
  Main.GteeMBillingRequestUUID AS GteeMBillingRequestUUID,
  Main.DocumentCurrency AS DocumentCurrency,
  Main.NotBilledAmtInDocCrcy AS NotBilledAmtInDocCrcy,
  Main.BillgInProcAmtInDocCrcy AS BillgInProcAmtInDocCrcy,
  Main.ToBePostponedAmtInDocCrcy AS ToBePostponedAmtInDocCrcy,
  Main.ToBeWrittenOffAmtInDocCrcy AS ToBeWrittenOffAmtInDocCrcy,
  Main.BilledRevenueAmtInDocCrcy AS BilledRevenueAmtInDocCrcy,
  Main.ToBeBilledAmtInDocCrcy AS ToBeBilledAmtInDocCrcy
FROM P_GteeMBillingElementAddl AS Main
;