I_SrvcContrFinancialCube_2

DDL: I_SRVCCONTRFINANCIALCUBE_2 Type: view COMPOSITE
159 Fields 4 Data Sources 1 Associations

Service Contract Financial - Cube

I_SrvcContrFinancialCube_2 is a Composite CDS View (Cube) that provides data about "Service Contract Financial - Cube" in SAP S/4HANA. It reads from 4 data sources (I_SrvcContrGLAcctLineItmCube_2, I_SrvcContrIntOrderCube, P_SrvcContrSysChkFunc, P_SrvcContrSysChkFunc) and exposes 159 fields with key fields ServiceContract, ServiceContractItem, SemanticTag, AccountingDocument, LedgerGLLineItem. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
I_SrvcContrGLAcctLineItmCube_2 I_SrvcContrGLAcctLineItmCube_2 from
I_SrvcContrIntOrderCube I_SrvcContrIntOrderCube union_all
P_SrvcContrSysChkFunc SystemType inner
P_SrvcContrSysChkFunc SystemType inner

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ServiceContractType _ServiceContractTypeVH $projection.ServiceContractType = _ServiceContractTypeVH.ServiceContractType

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVCCONTRFINC2 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 #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.allowExtensions true view
Aggregation.allowPrecisionLoss true view
EndUserText.label Service Contract Financial - Cube view

Fields (159)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceContract Transaction ID
KEY ServiceContractItem ServiceContractItem Item Number in Doc.
KEY SemanticTag SemanticTag Semantic Tag
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
ServiceObjectType ServiceObjectType Object Type
CalendarYear CalendarYear Year
CalendarWeek CalendarWeek Calendar Week
ServiceContractType ServiceContractType
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarMonth CalendarMonth Calendar Month
ServiceContractDescription ServiceContractDescription
RefBusinessSolutionOrder RefBusinessSolutionOrder
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
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
SoldToParty SoldToParty Sold-to Party
SoldToPartyFullName SoldToPartyFullName
BusinessPartnerFullName SoldToPartyFullName
ShipToParty ShipToParty Ship-To Party (obsolete)
ResponsibleEmployee ResponsibleEmployee Employee Resp.
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId Contact Person Key
CreationDate CreationDate Time Stamp
PostingDate PostingDate Posting Date for GR
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DisplayCurrency DisplayCurrency Display Currency
TransactionCurrency TransactionCurrency Transaction Currency
_TransactionCurrency _TransactionCurrency
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
TotalSrvcContrValueInDC TotalSrvcContrValueInDC
AnnualSrvcContrValueInDC AnnualSrvcContrValueInDC
RevenueAmountInDisplayCrcy RevenueAmountInDisplayCrcy
CostAmountInDisplayCurrency CostAmountInDisplayCurrency
SrvcContrProfitabilityInDC SrvcContrProfitabilityInDC
YTDSrvcContrPrftMarginAmtInDC YTDSrvcContrPrftMarginAmtInDC
YTDSrvcContrRevnAmtInDC YTDSrvcContrRevnAmtInDC
YTDSrvcContrCostInDC YTDSrvcContrCostInDC
NumberOfDays NumberOfDays Number of Days
ServiceDocumentIsOpen ServiceDocumentIsOpen
ServiceDocumentItemCanclnParty ServiceDocumentItemCanclnParty
ServiceDocumentItmCanclnReason ServiceDocumentItmCanclnReason
_CalendarMonth _CalendarMonth
_CalendarQuarter _CalendarQuarter
_SoldToPartyRegion _SoldToPartyRegion
_SoldToParty _SoldToParty
_RespEmployee _RespEmployee
_RespEmployeeID _RespEmployeeID
_ContactPerson _ContactPerson
_CompanyCodeCurrency _CompanyCodeCurrency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceObjectType _ServiceObjectType
_ServiceContractTypeVH _ServiceContractTypeVH
_JournalEntry _JournalEntry
_SemanticTag _SemanticTag
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_SoldToPartyCountry _SoldToPartyCountry
_SolutionOrderVH _SolutionOrderVH
ServiceContractTypekeyServiceContract
KEY ServiceContractItem ServiceContractItem Item Number in Doc.
KEY SemanticTag SemanticTag Semantic Tag
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
ServiceObjectType ServiceObjectType Object Type
CalendarYear CalendarYear Year
CalendarWeek CalendarWeek Calendar Week
ServiceContractType ServiceContractType
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarMonth CalendarMonth Calendar Month
ServiceContractDescription ServiceContractDescription
RefBusinessSolutionOrder RefBusinessSolutionOrder
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
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
SoldToParty SoldToParty Sold-to Party
SoldToPartyFullName SoldToPartyFullName
BusinessPartnerFullName SoldToPartyFullName
ShipToParty ShipToParty Ship-To Party (obsolete)
ResponsibleEmployee ResponsibleEmployee Employee Resp.
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId Contact Person Key
CreationDate CreationDate Time Stamp
PostingDate PostingDate Posting Date for GR
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DisplayCurrency DisplayCurrency Display Currency
TransactionCurrency TransactionCurrency Transaction Currency
_TransactionCurrency _TransactionCurrency
ServiceDocumentItemNetAmount TotalSrvcContrValueInDC
TotalSrvcContrValueInDC TotalSrvcContrValueInDC
AnnualSrvcContrValueInDC AnnualSrvcContrValueInDC
RevenueAmountInDisplayCrcy RevenueAmountInDisplayCrcy
CostAmountInDisplayCurrency CostAmountInDisplayCurrency
SrvcContrProfitabilityInDC SrvcContrProfitabilityInDC
YTDSrvcContrPrftMarginAmtInDC YTDSrvcContrPrftMarginAmtInDC
YTDSrvcContrRevnAmtInDC YTDSrvcContrRevnAmtInDC
YTDSrvcContrCostInDC YTDSrvcContrCostInDC
NumberOfDays NumberOfDays Number of Days
ServiceDocumentIsOpen ServiceDocumentIsOpen
ServiceDocumentItemCanclnParty ServiceDocumentItemCanclnParty
ServiceDocumentItmCanclnReason ServiceDocumentItmCanclnReason
_CalendarMonth _CalendarMonth
_CalendarQuarter _CalendarQuarter
_SoldToPartyRegion _SoldToPartyRegion
_SoldToParty _SoldToParty
_RespEmployee _RespEmployee
_RespEmployeeID _RespEmployeeID
_ContactPerson _ContactPerson
_CompanyCodeCurrency _CompanyCodeCurrency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceObjectType _ServiceObjectType
_ServiceContractTypeVH _ServiceContractTypeVH
_JournalEntry _JournalEntry
_SemanticTag _SemanticTag
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_SoldToPartyCountry _SoldToPartyCountry
_SolutionOrderVH _SolutionOrderVH
_ShipToParty _ShipToParty

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_SrvcContrFinancialCube_2.
-- 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_SrvcContrFinancialCube_2 AS
SELECT
  ServiceContract,
  ServiceContractItem,
  SemanticTag,
  AccountingDocument,
  LedgerGLLineItem,
  CompanyCode,
  FiscalYear,
  ServiceObjectType,
  CalendarYear,
  CalendarWeek,
  ServiceContractType,
  CalendarQuarter,
  CalendarMonth,
  ServiceContractDescription,
  RefBusinessSolutionOrder,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  SoldToPartyFullName,
  SoldToPartyFullName AS BusinessPartnerFullName,
  ShipToParty,
  ResponsibleEmployee,
  RespEmployeeBusinessPartnerId,
  ContactPersonBusinessPartnerId,
  CreationDate,
  PostingDate,
  CompanyCodeCurrency,
  DisplayCurrency,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  TotalSrvcContrValueInDC,
  AnnualSrvcContrValueInDC,
  RevenueAmountInDisplayCrcy,
  CostAmountInDisplayCurrency,
  SrvcContrProfitabilityInDC,
  YTDSrvcContrPrftMarginAmtInDC,
  YTDSrvcContrRevnAmtInDC,
  YTDSrvcContrCostInDC,
  NumberOfDays,
  ServiceDocumentIsOpen,
  ServiceDocumentItemCanclnParty,
  ServiceDocumentItmCanclnReason
FROM I_SrvcContrGLAcctLineItmCube_2
INNER JOIN P_SrvcContrSysChkFunc AS SystemType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ServiceContractType AS _ServiceContractTypeVH ON ServiceContractType = _ServiceContractTypeVH.ServiceContractType  -- association [0..1]
-- UNION ALL with additional select branch(es): I_SrvcContrIntOrderCube
;

Learn More