C_SubscriptionContractItemSitn

SOM Subcription Contract End Situation | view: ISITSBSCRCONTRI2 | TRAN | Extraction: Not supported | Component: S4CRM: Subscription Order Management
Tables used: CRMS4D_SERV_I
Column Name Description
ServiceObjectType FK Business Trans. Cat.
SubscriptionContract Transaction ID
SubscriptionContractItem Shortened Item Number in Document
Column Name Description
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (ServiceDocItemQuantityUnit):
ServiceDocumentItemQuantity CRM: Order Quantity
Column Name Description
SubscrpnContrItemEndDate null
Column Name Description
Column Name Description Domain name
Product Product Number MATNR
SubscriptionContractExternalID IS-T Contract Number IST_EXT_REF
ResponsibleEmployeeUserID User ID XUBNAME
NrOfSbscrContrItemExprdDays null
SubscriptionContractItemUUID GUID of a CRM Order Object SYSUUID
SubscrpnContrItmCharUUID 32 Character CRM Object GUID (Converted)
SubscrpnContrItmEndDateTime Contract End Date DEC15
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Distribution Channel
  • Client
  • Distribution Channel
  • C_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == TVTW.MANDT
  • C_SUBSCRIPTIONCONTRACTITEMSITN.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == TSPA.MANDT
  • C_SUBSCRIPTIONCONTRACTITEMSITN.DIVISION == TSPA.SPART
Employee Responsible
  • Client
  • Employee Responsible
  • C_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == BUT000.CLIENT
  • C_SUBSCRIPTIONCONTRACTITEMSITN.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • C_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == T006.MANDT
  • C_SUBSCRIPTIONCONTRACTITEMSITN.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
Business Transaction Type
  • Business Transaction Type
  • Client
  • C_SUBSCRIPTIONCONTRACTITEMSITN.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • C_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == CRMC_PROC_TYPE.CLIENT
Business Trans. Cat. C_SUBSCRIPTIONCONTRACTITEMSITN.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Client
  • Sold-To Party
  • C_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == BUT000.CLIENT
  • C_SUBSCRIPTIONCONTRACTITEMSITN.SOLDTOPARTY == BUT000.PARTNER