I_SrvcContrGLAcctLineItmCube_2

GL Account Item for Srvc Contract - Cube | view: ISRVCCONTRGLCUB | TRAN | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, CRMS4D_SERV_I, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, TKA01, CRMS4C_ORGMAN, FINSC_LEDGER, PROJ, T000, HRRP_FSV_DIR, USR21, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, USR05, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
ServiceContract Transaction ID
ServiceContractItem Shortened Item Number in Document
SemanticTag Semantic Tag of a Hierarchy Node
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
CompanyCode Company Code
FiscalYear Fiscal Year
Column Name Description
💲 Currency Key (DisplayCurrency):
ServiceDocumentItemNetAmount Net Value of Service Transaction Item
TotalSrvcContrValueInDC Total Net Value of Service Contract in Display Currency
AnnualSrvcContrValueInDC Annual Net Value of Service Contract in Display Currency
RevenueAmountInDisplayCrcy Revenue in Display Currency
CostAmountInDisplayCurrency Cost in Display Currency
SrvcContrProfitabilityInDC Profit Margin in Display Currency
YTDSrvcContrPrftMarginAmtInDC Year-to-Date Profit Margin in Display Currency
YTDSrvcContrRevnAmtInDC Year-to-Date Revenue in Display Currency
YTDSrvcContrCostInDC Year-to-Date Cost in Display Currency
Column Name Description
Column Name Description
CreationDate Creation Date
PostingDate Posting Date
Column Name Description
ServiceDocumentIsOpen Status "Open" Show values
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarWeek Calendar Week NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
ServiceContractDescription Transaction Description CRM_PROCESS_DESCRIPTION
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
RefBusinessSolutionOrderItem Item Number in Referenced Solution Order CRMS4_NUMBER_INT
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
SoldToPartyFullName Sold-To Party Name TEXT80
BusinessPartnerFullName Sold-To Party Name TEXT80
NumberOfDays null
Master Data Relations Join Conditions
Customer Contact Person
  • Client
  • Customer Contact Person
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == BUT000.CLIENT
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.CONTACTPERSONBUSINESSPARTNERID == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == TVTW.MANDT
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == TSPA.MANDT
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.DIVISION == TSPA.SPART
Employee Responsible
  • Employee Responsible
  • Employee Responsible
  • Client
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == BUT000.CLIENT
Employee Responsible
  • Employee Responsible
  • Employee Responsible
  • Client
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == BUT000.CLIENT
Business Transaction Type
  • Business Transaction Type
  • Client
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == CRMC_PROC_TYPE.CLIENT
Cancelling Party
  • Cancelling Party
  • Client
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.SERVICEDOCUMENTITEMCANCLNPARTY == CRMC_PARTY.CANC_PARTY
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == CRMC_PARTY.CLIENT
CRM Service : Reason for Cancellation
  • CRM Service : Reason for Cancellation
  • Client
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.SERVICEDOCUMENTITMCANCLNREASON == CRMC_CANCREASON.CANC_REASON
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == CRMC_CANCREASON.CLIENT
Business Trans. Cat. I_SRVCCONTRGLACCTLINEITMCUBE_2.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Ship-To Party
  • Client
  • Ship-To Party
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == BUT000.CLIENT
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.SHIPTOPARTY == BUT000.PARTNER
Sold-To Party
  • Sold-To Party
  • Client
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.SOLDTOPARTY == BUT000.PARTNER
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == BUT000.CLIENT
Country/Region
  • Country/Region
  • Client
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.SOLDTOPARTYCOUNTRY == T005.LAND1
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region
  • Client
  • Region (State, Province, County)
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.MANDT == T005S.MANDT
  • I_SRVCCONTRGLACCTLINEITMCUBE_2.SOLDTOPARTYREGION == T005S.BLAND