I_GteeMBillingElementEntryFlw

DDL: I_GTEEMBILLINGELEMENTENTRYFLW SQL: IGMBLGELMETRFLW Type: view BASIC
21 Fields 1 Data Sources 1 Associations

Grantee Mgmt Billing Element Entry Flow

I_GteeMBillingElementEntryFlw is a Basic CDS View that provides data about "Grantee Mgmt Billing Element Entry Flow" in SAP S/4HANA. It reads from 1 data source (gmblgemtentrflw) and exposes 21 fields with key field GteeMBillgElmntEntrItmFlowUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
gmblgemtentrflw BillingElementEntryFlow from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_GteeMBillingElementEntry _GteeMBillingElementEntry $projection.GteeMBillgElmntEntrItmUUID = _GteeMBillingElementEntry.GteeMBillgElmntEntrItmUUID

Annotations (13)

NameValueLevelField
EndUserText.label Grantee Mgmt Billing Element Entry Flow view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IGMBLGELMETRFLW view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey GteeMBillgElmntEntrItmFlowUUID view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillgElmntEntrItmFlowUUID gmblgemtentrflw gteembillgelmntentritmflowuuid Billg Elmt Flow UUID
GteeMBillgElmntEntrItmUUID gmblgemtentrflw gteembillgelmntentritmuuid GMBE Entry UUID
GteeMBillingElementUUID _GteeMBillingElementEntry GteeMBillingElementUUID GMBE UUID
BillingDocument
BillingDocumentItem
BillingDocumentType gmblgemtentrflw billingdocumenttype Billing Type
SDDocumentCategory gmblgemtentrflw sddocumentcategory Document Cat.
PrecedingDocument
PrecedingDocumentItem gmblgemtentrflw precedingdocumentitem Item
PrecedingDocumentType gmblgemtentrflw precedingdocumenttype Document cat.
BillingDate gmblgemtentrflw billingdate Billing Date
DocumentBillingStatus gmblgemtentrflw documentbillingstatus PBEE BDR Status
DocumentCurrency _GteeMBillingElementEntry DocumentCurrency Document Currency
BillgInProcAmtInDocCrcy gmblgemtentrflw billginprocamtindoccrcy Billing in Process Amount
BilledRevenueAmtInDocCrcy gmblgemtentrflw billedrevenueamtindoccrcy Billed Revenue
GteeMBillgElmntFlwCrtedByUser gmblgemtentrflw gteembillgelmntflwcrtedbyuser Element Flow Crtd By
GteeMBillgElmntFlwCrteDteTme gmblgemtentrflw gteembillgelmntflwcrtedtetme Element Flow Crtd On
GteeMBillgElmntFlwChgdByUser gmblgemtentrflw gteembillgelmntflwchgdbyuser Element Flow Chgd By
GteeMBillgElmntFlwChgdAtDteTme gmblgemtentrflw gteembillgelmntflwchgdatdtetme Element Flow Chgd On
_GteeMBillingElement _GteeMBillingElementEntry _GteeMBillingElement
_GteeMBillingElementEntry _GteeMBillingElementEntry

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_GteeMBillingElementEntryFlw.
-- 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: IGMBLGELMETRFLW

CREATE VIEW I_GteeMBillingElementEntryFlw AS
SELECT
  BillingElementEntryFlow.gteembillgelmntentritmflowuuid AS GteeMBillgElmntEntrItmFlowUUID,
  BillingElementEntryFlow.gteembillgelmntentritmuuid AS GteeMBillgElmntEntrItmUUID,
  _GteeMBillingElementEntry.GteeMBillingElementUUID AS GteeMBillingElementUUID,
  cast( BillingElementEntryFlow.billingdocument as vbeln_vf preserving type ) AS BillingDocument,
  cast( BillingElementEntryFlow.billingdocumentitem as posnr_vf preserving type ) AS BillingDocumentItem,
  BillingElementEntryFlow.billingdocumenttype AS BillingDocumentType,
  BillingElementEntryFlow.sddocumentcategory AS SDDocumentCategory,
  cast( BillingElementEntryFlow.precedingdocument as preced_doc ) AS PrecedingDocument,
  BillingElementEntryFlow.precedingdocumentitem AS PrecedingDocumentItem,
  BillingElementEntryFlow.precedingdocumenttype AS PrecedingDocumentType,
  BillingElementEntryFlow.billingdate AS BillingDate,
  BillingElementEntryFlow.documentbillingstatus AS DocumentBillingStatus,
  _GteeMBillingElementEntry.DocumentCurrency AS DocumentCurrency,
  BillingElementEntryFlow.billginprocamtindoccrcy AS BillgInProcAmtInDocCrcy,
  BillingElementEntryFlow.billedrevenueamtindoccrcy AS BilledRevenueAmtInDocCrcy,
  BillingElementEntryFlow.gteembillgelmntflwcrtedbyuser AS GteeMBillgElmntFlwCrtedByUser,
  BillingElementEntryFlow.gteembillgelmntflwcrtedtetme AS GteeMBillgElmntFlwCrteDteTme,
  BillingElementEntryFlow.gteembillgelmntflwchgdbyuser AS GteeMBillgElmntFlwChgdByUser,
  BillingElementEntryFlow.gteembillgelmntflwchgdatdtetme AS GteeMBillgElmntFlwChgdAtDteTme,
  _GteeMBillingElementEntry._GteeMBillingElement AS _GteeMBillingElement
FROM gmblgemtentrflw AS BillingElementEntryFlow
LEFT OUTER JOIN I_GteeMBillingElementEntry AS _GteeMBillingElementEntry ON GteeMBillgElmntEntrItmUUID = _GteeMBillingElementEntry.GteeMBillgElmntEntrItmUUID  -- association [1..1]
;

Learn More