I_SubscriptionContractItemSitn

SOM Subcription Contract End Situation | view: ISITSBSCRCONTRIT | 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
SubscrpnContrActivationStatus Activation Status of Subscription Order/Contract Show values
SubscrpnContrTimeSliceStatus Status of Contract Time Slice Show values
ServiceDocumentItemIsRejected Cancellation Status Show values
SubscrpnOrdProdSelType Product Selection Type Show values
SubscrpnContrAutoRnwlIsActv Auto-Renewal Indicator Show values
BusSolutionQtnItemIsPhased Phase Indicator Show values
Column Name Description Domain name
Product Product Number MATNR
SubscriptionContractExternalID IS-T Contract Number IST_EXT_REF
SubscrpnContrItmEndDateTime Contract End Date DEC15
SubscrpnContrItmStartDateTime Contract Start date DEC15
SbscrContrTimeSliceStrtDteTme Start of Contract Time Slice DEC15
SbscrContrTimeSliceEndDteTme End of Contract Time Slice DEC15
ResponsibleSalesOrganization Organizational Unit (Sales) HROBJEC_14
ResponsibleEmployeeUserID User ID XUBNAME
NrOfSbscrContrItemExprdDays null
SubscriptionContractItemUUID GUID of a CRM Order Object SYSUUID
SubscrpnContrItmCharUUID 32 Character CRM Object GUID (Converted)
ServiceContrItemEndDateTime 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
  • Distribution Channel
  • Client
  • I_SUBSCRIPTIONCONTRACTITEMSITN.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • I_SUBSCRIPTIONCONTRACTITEMSITN.DIVISION == TSPA.SPART
  • I_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == TSPA.MANDT
Employee Responsible
  • Employee Responsible
  • Client
  • I_SUBSCRIPTIONCONTRACTITEMSITN.RESPEMPLOYEEBUSINESSPARTNERID == BUT000.PARTNER
  • I_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == BUT000.CLIENT
Unit of Measure in Which the Product Is Sold
  • Unit of Measure in Which the Product Is Sold
  • Client
  • I_SUBSCRIPTIONCONTRACTITEMSITN.SERVICEDOCITEMQUANTITYUNIT == T006.MSEHI
  • I_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == T006.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
  • I_SUBSCRIPTIONCONTRACTITEMSITN.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • I_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == CRMC_PROC_TYPE.CLIENT
Business Trans. Cat. I_SUBSCRIPTIONCONTRACTITEMSITN.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Sold-To Party
  • Sold-To Party
  • Client
  • I_SUBSCRIPTIONCONTRACTITEMSITN.SOLDTOPARTY == BUT000.PARTNER
  • I_SUBSCRIPTIONCONTRACTITEMSITN.MANDT == BUT000.CLIENT