I_ServiceDocRevenueCube

DDL: I_SERVICEDOCREVENUECUBE Type: view COMPOSITE Package: CRMS4_ANALYTICS_COMMON
61 Fields 1 Associations

Service Transaction Revenue - Cube

I_ServiceDocRevenueCube is a Composite CDS View (Cube) that provides data about "Service Transaction Revenue - Cube" in SAP S/4HANA. It has 1 association to related views. Part of development package CRMS4_ANALYTICS_COMMON.

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ServiceDocumentEnhcd _DocumentEnhcd $projection.ServiceDocument = _DocumentEnhcd.ServiceDocument and( _DocumentEnhcd.ServiceObjectType = 'BUS2000116' or _DocumentEnhcd.ServiceObjectType = 'BUS2000112' )

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVCDOCREVCUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Service Transaction Revenue - Cube view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
KEY ServiceContract ServiceContract Transaction ID
KEY Ledger Ledger Ledger
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY GLAccountHierarchy GLAccountHierarchy
KEY SemanticTag SemanticTag Semantic Tag
KEY ValidityStartDate ValidityStartDate Validity Start Date
KEY ValidityEndDate ValidityEndDate ValidTo
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceObjectType ServiceObjectType Object Type
ServiceDocumentDescription ServiceDocumentDescription
DisplayCurrency DisplayCurrency Display Currency
RevenueAmountInDisplayCrcy RevenueAmountInDisplayCrcy
CreationDate CreationDate Time Stamp
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarYear CalendarYear Year
Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
ResponsibleEmployee ResponsibleEmployee Employee Resp.
_ServiceDocument _ServiceDocument
_ServiceDocumentItem _ServiceDocumentItem
_CompanyCode _CompanyCode
_Ledger _Ledger
_SourceLedger _SourceLedger
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_Hierarchy _Hierarchy
_SemanticTag _SemanticTag
_ServiceObjType _ServiceObjType
_DocumentEnhcd _DocumentEnhcd
_ServiceDocumentType _ServiceDocumentType
_CalendarQuarter _CalendarQuarter
_CalendarYear _CalendarYear
_SoldProduct _SoldProduct
_SoldProductGroup _SoldProductGroup
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_RespEmployee _RespEmployee

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_ServiceDocRevenueCube.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_ServiceDocRevenueCube AS
SELECT
  ServiceDocument,
  ServiceDocumentItem,
  ServiceContract,
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  ServiceDocumentType,
  ServiceObjectType,
  ServiceDocumentDescription,
  DisplayCurrency,
  RevenueAmountInDisplayCrcy,
  CreationDate,
  CalendarQuarter,
  CalendarYear,
  Product,
  ProductGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  ResponsibleEmployee
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _DocumentEnhcd ON ServiceDocument = _DocumentEnhcd.ServiceDocument AND( _DocumentEnhcd.ServiceObjectType = 'BUS2000116' OR _DocumentEnhcd.ServiceObjectType = 'BUS2000112' )  -- association [0..1]
;

Learn More