C_SrvcContrIntOrderQuery

Column Name Description
ServiceContract Transaction ID
ServiceObjectType FK Business Trans. Cat.
Column Name Description
💲 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
SemanticTag Semantic Tag of a Hierarchy Node FINS_SEM_TAG
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
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • C_SRVCCONTRINTORDERQUERY.MANDT == TVTW.MANDT
  • C_SRVCCONTRINTORDERQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_SRVCCONTRINTORDERQUERY.MANDT == TSPA.MANDT
  • C_SRVCCONTRINTORDERQUERY.DIVISION == TSPA.SPART
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. C_SRVCCONTRINTORDERQUERY.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • C_SRVCCONTRINTORDERQUERY.MANDT == BUT000.CLIENT
  • C_SRVCCONTRINTORDERQUERY.SOLDTOPARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • C_SRVCCONTRINTORDERQUERY.MANDT == T005.MANDT
  • C_SRVCCONTRINTORDERQUERY.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region
  • Region (State, Province, County)
  • C_SRVCCONTRINTORDERQUERY.MANDT == T005S.MANDT
  • C_SRVCCONTRINTORDERQUERY.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • C_SRVCCONTRINTORDERQUERY.SOLDTOPARTYREGION == T005S.BLAND