I_SalesProviderContractItem

SB Provider Contract Items | view: ISLSPRVDRCONTRI | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKK_VT_HDFKK_VT_I
Column Name Description
SalesProviderContract FK Identification of a Provider Contract
SalesProviderContractItem Contract: Item Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Creation Time
LastChangeDate Last Changed On
LastChangeTime Last Changed At
CustomerPurchaseOrderDate Customer Reference Date
Column Name Description
CAProviderContractStatus Status of Provider Contract Show values
CASubscriptionChargeType Charge Type Show values
Column Name Description Domain name
CAProviderContractItemUUID External GUID of Provider Contract Items SYSUUID
CAPrvdrContrParentItemUUID External GUID of Higher-Level Provider Contract Items SYSUUID
CAProviderContractItemText Text for Provider Contract Item TEXT50
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
CAPrvdrContrItmValidFromDteTme Valid From (Time Stamp) TZNTSTMPS
CAPrvdrContrItmValidToDateTime Valid To (Time Stamp) TZNTSTMPS
CAPrvdrContrItemCanclnDateTime Time of Reversal (Time Stamp) TZNTSTMPS
CAStartOfDurationDateTime Contract Term Start (Time Stamp) TZNTSTMPS
CAEndOfDurationDateTime End of Contract Duration (Time Stamp) TZNTSTMPS
CAProduct Product Number PRDNR_KK
ProductConfiguration Configuration Instance CU_INSTANCE_KK
PurchaseOrderByCustomer Customer Reference BSTKD
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
BusinessSolutionOrderItem Solution Order Item CRMS4_NUMBER_INT
Division Division SPART
CAPrvdrContrSalesAreaAttrib1 Contract: Sales Area Attribute 1 VKBER_KK
CAPrvdrContrSalesAreaAttrib2 Contract: Sales Area Attribute 2 VKBER_KK
CompanyCode Company Code BUKRS
ProfitCenter Profit Center PRCTR
CAStandardDivision Contract: Standard Division SPART
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • I_SALESPROVIDERCONTRACTITEM.BUSINESSAREA == TGSB.GSBER
  • I_SALESPROVIDERCONTRACTITEM.MANDT == TGSB.MANDT
Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • I_SALESPROVIDERCONTRACTITEM.MANDT == TVKOV.MANDT
  • I_SALESPROVIDERCONTRACTITEM.SALESORGANIZATION == TVKOV.VKORG
  • I_SALESPROVIDERCONTRACTITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Recognition key
  • Client
  • Recognition key
  • Recognition key
  • I_SALESPROVIDERCONTRACTITEM.MANDT == TKKAA.MANDT
  • I_SALESPROVIDERCONTRACTITEM.REVENUERECOGNITIONKEY == TKKAA.ABGSL
  • I_SALESPROVIDERCONTRACTITEM.EBRRRESULTANALYSISINTERNALID == TKKAA.ABGSL
Order Number
  • Order Number
  • Client
  • I_SALESPROVIDERCONTRACTITEM.INTERNALORDER == AUFK.AUFNR
  • I_SALESPROVIDERCONTRACTITEM.MANDT == AUFK.MANDT
Recognition key
  • Client
  • Recognition key
  • Recognition key
  • I_SALESPROVIDERCONTRACTITEM.MANDT == TKKAA.MANDT
  • I_SALESPROVIDERCONTRACTITEM.REVENUERECOGNITIONKEY == TKKAA.ABGSL
  • I_SALESPROVIDERCONTRACTITEM.EBRRRESULTANALYSISINTERNALID == TKKAA.ABGSL
Sales Organization
  • Client
  • Sales Organization
  • I_SALESPROVIDERCONTRACTITEM.MANDT == TVKO.MANDT
  • I_SALESPROVIDERCONTRACTITEM.SALESORGANIZATION == TVKO.VKORG
Contract Key
  • Client
  • Identification of a Provider Contract
  • I_SALESPROVIDERCONTRACTITEM.MANDT == DFKK_VT_H.MANDT
  • I_SALESPROVIDERCONTRACTITEM.SALESPROVIDERCONTRACT == DFKK_VT_H.VTKEY
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_SALESPROVIDERCONTRACTITEM.MANDT == FAGL_SEGM.MANDT
  • I_SALESPROVIDERCONTRACTITEM.SEGMENT == FAGL_SEGM.SEGMENT
Product Sold
  • Client
  • Product Sold
  • I_SALESPROVIDERCONTRACTITEM.MANDT == MARA.MANDT
  • I_SALESPROVIDERCONTRACTITEM.SOLDPRODUCT == MARA.MATNR