I_SrvcContrIntOrderCube

Internal Order of Srvc Contract - Cube | view: PSRVINTORDCUB | TRAN | Extraction: Not supported | Component: S4CRM: Analytics
Tables used: SCAL_TT_DATE, CRMS4D_SERV_H, IAOM_EXT_OBJ_INF, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, TKA01, CRMS4C_ORGMAN, FINSC_LEDGER, PROJ, T000, HRRP_FSV_DIR, AUFK, IAOM_ASSIGNMENTS, IAOM_CRMSRV_EXAT, 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
💲 Company Code Currency (CompanyCodeCurrency):
RecognizedMarginAmtInCCCrcy Recognized Margin
RevenueAmountInCompanyCodeCrcy Revenue Amount in Company Code Currency
CostAmountInCompanyCodeCrcy Cost Amount in Company Code Currency
💲 Currency Key (DisplayCurrency):
AnnualSrvcContrValueInDC null
TotalSrvcContrValueInDC null
RevenueAmountInDisplayCrcy null
CostAmountInDisplayCurrency null
SrvcContrProfitabilityInDC null
YTDSrvcContrPrftMarginAmtInDC null
YTDSrvcContrRevnAmtInDC null
YTDSrvcContrCostInDC null
Column Name Description
Column Name Description
CreationDate Creation Date
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
ServiceDocumentIsOpen Status "Open" Show values
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarWeek Calendar Week NUM2
OrderID Order ID AUFNR
ServiceContractDescription Transaction Description CRM_PROCESS_DESCRIPTION
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
NumberOfDays null
FiscalYearVariant Fiscal Year Variant PERIV
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
SoldToPartyFullName null
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
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
IsActive null
Master Data Relations Join Conditions
Customer Contact Person
  • Client
  • Customer Contact Person
  • I_SRVCCONTRINTORDERCUBE.MANDT == BUT000.CLIENT
  • I_SRVCCONTRINTORDERCUBE.CONTACTPERSONBUSINESSPARTNERID == BUT000.PARTNER
Distribution Channel
  • Client
  • Distribution Channel
  • I_SRVCCONTRINTORDERCUBE.MANDT == TVTW.MANDT
  • I_SRVCCONTRINTORDERCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_SRVCCONTRINTORDERCUBE.MANDT == TSPA.MANDT
  • I_SRVCCONTRINTORDERCUBE.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • I_SRVCCONTRINTORDERCUBE.MANDT == BUT000.CLIENT
  • I_SRVCCONTRINTORDERCUBE.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • I_SRVCCONTRINTORDERCUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • I_SRVCCONTRINTORDERCUBE.MANDT == BUT000.CLIENT
  • I_SRVCCONTRINTORDERCUBE.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • I_SRVCCONTRINTORDERCUBE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Business Transaction Type
  • Client
  • Business Transaction Type
Cancelling Party
  • Client
  • Cancelling Party
  • I_SRVCCONTRINTORDERCUBE.MANDT == CRMC_PARTY.CLIENT
  • I_SRVCCONTRINTORDERCUBE.SERVICEDOCUMENTITEMCANCLNPARTY == CRMC_PARTY.CANC_PARTY
CRM Service : Reason for Cancellation
  • Client
  • CRM Service : Reason for Cancellation
Business Trans. Cat. I_SRVCCONTRINTORDERCUBE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Ship-To Party
  • Ship-To Party
  • Client
  • I_SRVCCONTRINTORDERCUBE.SHIPTOPARTY == BUT000.PARTNER
  • I_SRVCCONTRINTORDERCUBE.MANDT == BUT000.CLIENT
Sold-To Party
  • Client
  • Sold-To Party
  • I_SRVCCONTRINTORDERCUBE.MANDT == BUT000.CLIENT
  • I_SRVCCONTRINTORDERCUBE.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Country/Region
  • Client
  • I_SRVCCONTRINTORDERCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
  • I_SRVCCONTRINTORDERCUBE.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region
  • Client
  • Region (State, Province, County)
  • I_SRVCCONTRINTORDERCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_SRVCCONTRINTORDERCUBE.MANDT == T005S.MANDT
  • I_SRVCCONTRINTORDERCUBE.SOLDTOPARTYREGION == T005S.BLAND