P_GteeMBillingElementEntryOpen

DDL: P_GTEEMBILLINGELEMENTENTRYOPEN SQL: PGMGBEEOPEN Type: view COMPOSITE

P_GteeMBillingElementEntryOpen is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_GteeMBillingElementEntry) and exposes 21 fields with key field GteeMBillgElmntEntrItmUUID. It has 1 association to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_GteeMBillingElementEntry BillingElementEntry from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_GteeMBillingElementEntryFlw _BillingElementEntrFlwOne $projection.GteeMBillgElmntEntrItmUUID = _BillingElementEntrFlwOne.GteeMBillgElmntEntrItmUUID and _BillingElementEntrFlwOne.DocumentBillingStatus <> 'D'

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PGMGBEEOPEN view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY GteeMBillgElmntEntrItmUUID I_GteeMBillingElementEntry GteeMBillgElmntEntrItmUUID
GteeMBillingElementUUID I_GteeMBillingElementEntry GteeMBillingElementUUID
GrantID I_GteeMBillingElementEntry GrantID
SponsoredProgram I_GteeMBillingElementEntry SponsoredProgram
DocumentCurrency I_GteeMBillingElementEntry DocumentCurrency
OriginalRevenueAmtInDocCrcy I_GteeMBillingElementEntry OriginalRevenueAmtInDocCrcy
ToBeWrittenOffAmtInDocCrcy I_GteeMBillingElementEntry ToBeWrittenOffAmtInDocCrcy
ToBePostponedAmtInDocCrcy I_GteeMBillingElementEntry ToBePostponedAmtInDocCrcy
Ledger I_GteeMBillingElementEntry Ledger
CompanyCode I_GteeMBillingElementEntry CompanyCode
FiscalYear I_GteeMBillingElementEntry FiscalYear
AccountingDocument I_GteeMBillingElementEntry AccountingDocument
LedgerGLLineItem I_GteeMBillingElementEntry LedgerGLLineItem
GteeMBillgElmntEntrCrtedByUsr I_GteeMBillingElementEntry GteeMBillgElmntEntrCrtedByUsr
GteeMBillgElmntEntrCrteDteTme I_GteeMBillingElementEntry GteeMBillgElmntEntrCrteDteTme
GteeMBillgElmntEntrChgdByUsr I_GteeMBillingElementEntry GteeMBillgElmntEntrChgdByUsr
GteeMBillingElmntEntrChgDteTme I_GteeMBillingElementEntry GteeMBillingElmntEntrChgDteTme
_Grant I_GteeMBillingElementEntry _Grant
_SponsoredProgramCore I_GteeMBillingElementEntry _SponsoredProgramCore
_GteeMBillingElementEntryFlw I_GteeMBillingElementEntry _GteeMBillingElementEntryFlw
_GteeMBillingElement I_GteeMBillingElementEntry _GteeMBillingElement 
@AbapCatalog.sqlViewName: 'PGMGBEEOPEN'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel: {
     usageType: {
         dataClass: #MIXED,
         serviceQuality: #P,
         sizeCategory: #XL
     }
}

define view P_GteeMBillingElementEntryOpen
  as select from I_GteeMBillingElementEntry as BillingElementEntry
  association [0..1] to I_GteeMBillingElementEntryFlw as _BillingElementEntrFlwOne on $projection.GteeMBillgElmntEntrItmUUID = _BillingElementEntrFlwOne.GteeMBillgElmntEntrItmUUID
                                                                                   and _BillingElementEntrFlwOne.DocumentBillingStatus <> 'D'
{
  key BillingElementEntry.GteeMBillgElmntEntrItmUUID     as GteeMBillgElmntEntrItmUUID,
      BillingElementEntry.GteeMBillingElementUUID        as GteeMBillingElementUUID,

      //Main Billing Account Assignments

      @ObjectModel.foreignKey.association: '_Grant'
      BillingElementEntry.GrantID                         as GrantID,
      @ObjectModel.foreignKey.association: '_SponsoredProgramCore'
      BillingElementEntry.SponsoredProgram                as SponsoredProgram,

      //Currencies

      @Semantics.currencyCode: true
      BillingElementEntry.DocumentCurrency              as DocumentCurrency,

      //Amounts

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      BillingElementEntry.OriginalRevenueAmtInDocCrcy    as OriginalRevenueAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      BillingElementEntry.ToBeWrittenOffAmtInDocCrcy     as ToBeWrittenOffAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      BillingElementEntry.ToBePostponedAmtInDocCrcy      as ToBePostponedAmtInDocCrcy,

      //Journal Reference

      BillingElementEntry.Ledger                         as Ledger,
      BillingElementEntry.CompanyCode                    as CompanyCode,
      BillingElementEntry.FiscalYear                     as FiscalYear,
      BillingElementEntry.AccountingDocument             as AccountingDocument,
      BillingElementEntry.LedgerGLLineItem               as LedgerGLLineItem,

      //Admin fields

      @Semantics.user.createdBy: true
      BillingElementEntry.GteeMBillgElmntEntrCrtedByUsr  as GteeMBillgElmntEntrCrtedByUsr,
      @Semantics.systemTime.createdAt: true
      BillingElementEntry.GteeMBillgElmntEntrCrteDteTme  as GteeMBillgElmntEntrCrteDteTme,
      @Semantics.user.lastChangedBy: true
      BillingElementEntry.GteeMBillgElmntEntrChgdByUsr   as GteeMBillgElmntEntrChgdByUsr,
      @Semantics.systemTime.lastChangedAt: true
      BillingElementEntry.GteeMBillingElmntEntrChgDteTme as GteeMBillingElmntEntrChgDteTme,

      // Association

      BillingElementEntry._Grant,
      BillingElementEntry._SponsoredProgramCore,
      BillingElementEntry._GteeMBillingElementEntryFlw,
      BillingElementEntry._GteeMBillingElement
      
} where _BillingElementEntrFlwOne.GteeMBillgElmntEntrItmFlowUUID is null

Learn More