R_GteeMBillgElmntEntrFlwTP

DDL: R_GTEEMBILLGELMNTENTRFLWTP Type: view_entity TRANSACTIONAL Package: PSM_S4C_GM_BILLING
27 Fields 1 Data Sources 1 Associations

Grantee Mgmt Transacl BillgElmnt EntrFlw

R_GteeMBillgElmntEntrFlwTP is a Transactional CDS View that provides data about "Grantee Mgmt Transacl BillgElmnt EntrFlw" in SAP S/4HANA. It reads from 1 data source (I_GteeMBillingElementEntryFlw) and exposes 27 fields with key field GteeMBillgElmntEntrItmFlowUUID. It has 1 association to related views. Part of development package PSM_S4C_GM_BILLING.

Data Sources (1)

SourceAliasJoin Type
I_GteeMBillingElementEntryFlw BillingElementEntryFlow from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_GteeMBillingElementTP _GteeMBillingElement $projection.GteeMBillingElementUUID = _GteeMBillingElement.GteeMBillingElementUUID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Grantee Mgmt Transacl BillgElmnt EntrFlw view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey GteeMBillgElmntEntrItmFlowUUID view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillgElmntEntrItmFlowUUID I_GteeMBillingElementEntryFlw GteeMBillgElmntEntrItmFlowUUID Billg Elmt Flow UUID
GteeMBillgElmntEntrItmUUID I_GteeMBillingElementEntryFlw GteeMBillgElmntEntrItmUUID GMBE Entry UUID
GteeMBillingElementUUID I_GteeMBillingElementEntryFlw GteeMBillingElementUUID GMBE UUID
BillingDocument I_GteeMBillingElementEntryFlw BillingDocument SD Document
BillingDocumentItem I_GteeMBillingElementEntryFlw BillingDocumentItem Item
BillingDocumentType I_GteeMBillingElementEntryFlw BillingDocumentType Billing Type
SDDocumentCategory I_GteeMBillingElementEntryFlw SDDocumentCategory Document Cat.
PrecedingDocument I_GteeMBillingElementEntryFlw PrecedingDocument SD Document
PrecedingDocumentItem I_GteeMBillingElementEntryFlw PrecedingDocumentItem Item
PrecedingDocumentType I_GteeMBillingElementEntryFlw PrecedingDocumentType Document cat.
BillingDate I_GteeMBillingElementEntryFlw BillingDate Billing Date
DocumentBillingStatus I_GteeMBillingElementEntryFlw DocumentBillingStatus PBEE BDR Status
DocumentCurrency I_GteeMBillingElementEntryFlw DocumentCurrency Document Currency
GlobalCurrency I_GteeMBillingElementEntryFlw GlobalCurrency GM Billing Element: Global Currency
GrantCurrency I_GteeMBillingElementEntryFlw GrantCurrency Grant Currency
BillgInProcAmtInDocCrcy I_GteeMBillingElementEntryFlw BillgInProcAmtInDocCrcy Billing in Process Amount
BilledRevenueAmtInDocCrcy I_GteeMBillingElementEntryFlw BilledRevenueAmtInDocCrcy Billed Revenue
BillgInProcAmtInGlobCurrency I_GteeMBillingElementEntryFlw BillgInProcAmtInGlobCurrency Billg in Process Amt in Global Currency
BilledRevenueAmtInGlobCrcy I_GteeMBillingElementEntryFlw BilledRevenueAmtInGlobCrcy
BillgInProcAmtInGrantCrcy I_GteeMBillingElementEntryFlw BillgInProcAmtInGrantCrcy
BilledRevenueAmtInGrantCrcy I_GteeMBillingElementEntryFlw BilledRevenueAmtInGrantCrcy
GteeMBillgElmntFlwCrtedByUser I_GteeMBillingElementEntryFlw GteeMBillgElmntFlwCrtedByUser Element Flow Crtd By
GteeMBillgElmntFlwCrteDteTme I_GteeMBillingElementEntryFlw GteeMBillgElmntFlwCrteDteTme Element Flow Crtd On
GteeMBillgElmntFlwChgdByUser I_GteeMBillingElementEntryFlw GteeMBillgElmntFlwChgdByUser Element Flow Chgd By
GteeMBillgElmntFlwChgdAtDteTme I_GteeMBillingElementEntryFlw GteeMBillgElmntFlwChgdAtDteTme Element Flow Chgd On
_GteeMBillingElement _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 R_GteeMBillgElmntEntrFlwTP.
-- 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.

CREATE VIEW R_GteeMBillgElmntEntrFlwTP AS
SELECT
  BillingElementEntryFlow.GteeMBillgElmntEntrItmFlowUUID AS GteeMBillgElmntEntrItmFlowUUID,
  BillingElementEntryFlow.GteeMBillgElmntEntrItmUUID AS GteeMBillgElmntEntrItmUUID,
  BillingElementEntryFlow.GteeMBillingElementUUID AS GteeMBillingElementUUID,
  BillingElementEntryFlow.BillingDocument AS BillingDocument,
  BillingElementEntryFlow.BillingDocumentItem AS BillingDocumentItem,
  BillingElementEntryFlow.BillingDocumentType AS BillingDocumentType,
  BillingElementEntryFlow.SDDocumentCategory AS SDDocumentCategory,
  BillingElementEntryFlow.PrecedingDocument AS PrecedingDocument,
  BillingElementEntryFlow.PrecedingDocumentItem AS PrecedingDocumentItem,
  BillingElementEntryFlow.PrecedingDocumentType AS PrecedingDocumentType,
  BillingElementEntryFlow.BillingDate AS BillingDate,
  BillingElementEntryFlow.DocumentBillingStatus AS DocumentBillingStatus,
  BillingElementEntryFlow.DocumentCurrency AS DocumentCurrency,
  BillingElementEntryFlow.GlobalCurrency AS GlobalCurrency,
  BillingElementEntryFlow.GrantCurrency AS GrantCurrency,
  BillingElementEntryFlow.BillgInProcAmtInDocCrcy AS BillgInProcAmtInDocCrcy,
  BillingElementEntryFlow.BilledRevenueAmtInDocCrcy AS BilledRevenueAmtInDocCrcy,
  BillingElementEntryFlow.BillgInProcAmtInGlobCurrency AS BillgInProcAmtInGlobCurrency,
  BillingElementEntryFlow.BilledRevenueAmtInGlobCrcy AS BilledRevenueAmtInGlobCrcy,
  BillingElementEntryFlow.BillgInProcAmtInGrantCrcy AS BillgInProcAmtInGrantCrcy,
  BillingElementEntryFlow.BilledRevenueAmtInGrantCrcy AS BilledRevenueAmtInGrantCrcy,
  BillingElementEntryFlow.GteeMBillgElmntFlwCrtedByUser AS GteeMBillgElmntFlwCrtedByUser,
  BillingElementEntryFlow.GteeMBillgElmntFlwCrteDteTme AS GteeMBillgElmntFlwCrteDteTme,
  BillingElementEntryFlow.GteeMBillgElmntFlwChgdByUser AS GteeMBillgElmntFlwChgdByUser,
  BillingElementEntryFlow.GteeMBillgElmntFlwChgdAtDteTme AS GteeMBillgElmntFlwChgdAtDteTme
FROM I_GteeMBillingElementEntryFlw AS BillingElementEntryFlow
LEFT OUTER JOIN R_GteeMBillingElementTP AS _GteeMBillingElement ON GteeMBillingElementUUID = _GteeMBillingElement.GteeMBillingElementUUID  -- association [1..1]
;

Learn More