I_ProviderContractItem

Provider Contract Item | view: IPRVDRCONTRI | Extraction: Not supported | Component: Contract Accounts Receivable and Payable
Tables used: DFKK_VT_I
Column Name Description
ProviderContract FK Identification of a Provider Contract
ProviderContractItem Contract: Item Number
Column Name Description
💲 Currency Key (TransactionPriceCurrency):
TransactionPrice Transaction Price for Each Recurrence Period
TotalTransactionPrice Total Transaction Price
💲 Currency Key (StandAloneSellingPriceCurrency):
StandAloneSellingPrice Standalone Selling Price for Each Recurrence Period
TotalStandAloneSellingPrice Total Standalone Selling Price
Column Name Description
📏 Unit of Measure (CAProviderContractQuantityUnit):
CAProviderContractQuantity Quantity
Column Name Description
CreationDate Date on which the record was created
CreationTime Creation Time
LastChangeDate Last Changed On
LastChangeTime Last Changed At
CABillgCyclePeriodStartDate Contract: Date of Original Start of Period
CustomerPurchaseOrderDate Customer Reference Date
Column Name Description
CAProviderContractStatus Status of Provider Contract Show values
CASubscriptionChargeType Charge Type Show values
CALastDayOfBillingPeriod Day of Period End Show values
CAIsRevenueAccountingRelevant Relevant for Revenue Accounting Show values
CARevnAcctgTransfRecordOrigin Type of Origin for Transfer Record Show values
CAOriginOfPaymentMasterData Determination of Payment Data Show values
CAOriginOfDunningMasterData Dunning Control Show values
CAServiceDisconncnIsProhibited Disconnection of Service Not Permitted Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
CAProviderContractItemUUID External GUID of Provider Contract Items SYSUUID
CAPrvdrContrParentItemUUID External GUID of Higher-Level Provider Contract Items SYSUUID
CAPrvdrContrItmValidFromDteTme Valid From (Time Stamp) TZNTSTMPS
CAPrvdrContrItmValidToDateTime Valid To (Time Stamp) TZNTSTMPS
CAPrvdrContrItemCanclnDateTime Time of Reversal (Time Stamp) TZNTSTMPS
CAProviderContractItemText Text for Provider Contract Item TEXT50
ContractAccount Contract Account Number VKONT_KK
CAPrepaidAccount Prepaid Account PPACC_KK
CATechnicalResourceGroup Group of IDs VTTRG_KK
CAAddressIDOfServiceRecipient Address Number for Recipient of the Service AD_ADDRNUM
CAProduct Product Number PRDNR_KK
ProductConfiguration Configuration Instance CU_INSTANCE_KK
CASalesPackageProduct Product ID of the Sales Package PRDNR_KK
CAMasterAgreement Identification of Master Agreement MAKEY_KK
CAMasterAgreementProduct Custom Product or Product Range MAPRD_KK
CASharingContract Reference to Sharing Contract VTKEY_KK
TaxJurisdiction Jurisdiction for Tax Calculation - Tax Jurisdiction Code TXJCD
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
BusinessSolutionOrderItem Solution Order Item CRMS4_NUMBER_INT
CompanyCode Company Code BUKRS
ProfitCenter Profit Center PRCTR
Division Division SPART
CAPrvdrContrSalesAreaAttrib1 Contract: Sales Area Attribute 1 VKBER_KK
CAPrvdrContrSalesAreaAttrib2 Contract: Sales Area Attribute 2 VKBER_KK
CAStandardDivision Contract: Standard Division SPART
CABillgPlnNumber Billing Plan Number BILLPLANNO_KK
ConsumptionBillingSEPAMandate Unique Reference to Mandate for each Payee ID035
CAConsumptionBillgPaymentCard Payment Card ID for Payments CHAR6
CARevenueAcctgMigrationPackage Migration Package ID
RevenueAccountingReference Reference ID for Revenue Accounting CHAR30
CARevenueAcctgDocumentItem Revenue Accounting Item ID
TransacPriceRcrrcPerdDuration Length of Recurrence Period TIMEDURA
SSPriceRecurrencePerdDuration Length of Recurrence Period TIMEDURA
CAStartOfDurationDateTime Contract Term Start (Time Stamp) TZNTSTMPS
CAEndOfDurationDateTime End of Contract Duration (Time Stamp) TZNTSTMPS
CAPaymentMethodForIncgPayment Incoming Payment Method CHAR1
CAAddressIDOfAlternativePayer Address Number for Alternative Payer AD_ADDRNUM
CABankIDForIncomingPayments Bank Details ID for Incoming Payments CHAR4
SEPAMandate Unique Reference to Mandate for each Payee ID035
CAPaymentCardIDForIncomingPayt Payment Card ID for Incoming Payments CHAR6
CAPaymentMethodForOutgPayment Outgoing Payment Methods CHAR5
CAAddressIDOfAlternativePayee Address Number for Alternative Payee AD_ADDRNUM
CABankIDForOutgoingPayments Bank Details ID for Outgoing Payments CHAR4
CAPaymentCardIDForOutgoingPayt Payment Card ID for Outgoing Payments CHAR6
CADunningProcedure Dunning Procedure MAHNV_KK
PurchaseOrderByCustomer Customer Reference BSTKD
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • I_PROVIDERCONTRACTITEM.BUSINESSAREA == TGSB.GSBER
  • I_PROVIDERCONTRACTITEM.MANDT == TGSB.MANDT
Alternative Payee
  • Alternative Payee
  • Client
  • I_PROVIDERCONTRACTITEM.CAALTERNATIVEPAYEE == BUT000.PARTNER
  • I_PROVIDERCONTRACTITEM.MANDT == BUT000.CLIENT
Alternative Payer
  • Alternative Payer
  • Client
  • I_PROVIDERCONTRACTITEM.CAALTERNATIVEPAYER == BUT000.PARTNER
  • I_PROVIDERCONTRACTITEM.MANDT == BUT000.CLIENT
Billing Cycle
  • Billing Cycle
  • Client
  • I_PROVIDERCONTRACTITEM.CABILLGCYCLE == TFK2607.CYCLE
  • I_PROVIDERCONTRACTITEM.MANDT == TFK2607.MANDT
Invoice Recipient
  • Invoice Recipient
  • Client
  • I_PROVIDERCONTRACTITEM.CACONSUMPTIONBILLGINVOICERCPNT == BUT000.PARTNER
  • I_PROVIDERCONTRACTITEM.MANDT == BUT000.CLIENT
Sold-To Party
  • Client
  • Sold-To Party
  • I_PROVIDERCONTRACTITEM.MANDT == BUT000.CLIENT
  • I_PROVIDERCONTRACTITEM.CACONSUMPTIONBILLGSOLDTOPARTY == BUT000.PARTNER
Selection Characteristic for Scheduling
  • Selection Characteristic for Scheduling
  • Client
  • I_PROVIDERCONTRACTITEM.CAINVCGSCHEDULE == TFK2606.INV_SCHEDULE
  • I_PROVIDERCONTRACTITEM.MANDT == TFK2606.MANDT
Partner Settlement Rule
  • Partner Settlement Rule
  • Client
  • I_PROVIDERCONTRACTITEM.CAPARTNERSETTLEMENTRULE == TFKPS_RULE.PTSRL
  • I_PROVIDERCONTRACTITEM.MANDT == TFKPS_RULE.MANDT
Unit of Measure
  • Client
  • Unit of Measure
  • I_PROVIDERCONTRACTITEM.MANDT == T006.MANDT
  • I_PROVIDERCONTRACTITEM.CAPROVIDERCONTRACTQUANTITYUNIT == T006.MSEHI
Change Reason
  • Change Reason
  • Client
  • I_PROVIDERCONTRACTITEM.CAPRVDRCONTRITMCHGREASON == TFK_RA_CHRSN.CHANGE_REASON
  • I_PROVIDERCONTRACTITEM.MANDT == TFK_RA_CHRSN.MANDT
Rating Area
  • Rating Area
  • Client
  • I_PROVIDERCONTRACTITEM.CARATINGAREA == TFK_RA_DEF.RATING_AREA
  • I_PROVIDERCONTRACTITEM.MANDT == TFK_RA_DEF.CLIENT
Destination Country/Region (for Tax Reports)
  • Destination Country/Region (for Tax Reports)
  • Client
  • I_PROVIDERCONTRACTITEM.CARECEIVINGCOUNTRY == T005.LAND1
  • I_PROVIDERCONTRACTITEM.MANDT == T005.MANDT
Reference Type for Revenue Accounting
  • Client
  • Reference Type for Revenue Accounting
  • Reference Type for Revenue Accounting
  • I_PROVIDERCONTRACTITEM.MANDT == TFK_RA_REFTYPE.MANDT
  • I_PROVIDERCONTRACTITEM.CAREVENUEACCOUNTINGREFTYPE == TFK_RA_REFTYPE.REFERENCE_TYPE
  • I_PROVIDERCONTRACTITEM.REVENUEACCOUNTINGREFTYPE == TFK_RA_REFTYPE.REFERENCE_TYPE
Service Types
  • Service Type
  • Client
Foreign Key for Service Recipient on BUT000
  • Recipient of Service
  • Client
  • I_PROVIDERCONTRACTITEM.CASERVICERECIPIENT == BUT000.PARTNER
  • I_PROVIDERCONTRACTITEM.MANDT == BUT000.CLIENT
Accounting Indicator
  • Accounting Indicator
  • Client
  • I_PROVIDERCONTRACTITEM.CNSMPNBILLGBILLABLECONTROL == TBMOT.BEMOT
  • I_PROVIDERCONTRACTITEM.MANDT == TBMOT.MANDT
Terms of Payment
  • Terms of payment key
  • ?
  • Client
  • I_PROVIDERCONTRACTITEM.CONSUMPTIONBILLINGPAYMENTTERMS == T052.ZTERM
  • I_PROVIDERCONTRACTITEM.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • I_PROVIDERCONTRACTITEM.MANDT == T052.MANDT
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • I_PROVIDERCONTRACTITEM.SALESORGANIZATION == TVKOV.VKORG
  • I_PROVIDERCONTRACTITEM.MANDT == TVKOV.MANDT
  • I_PROVIDERCONTRACTITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Recognition key
  • Client
  • Recognition key
  • Recognition key
  • I_PROVIDERCONTRACTITEM.MANDT == TKKAA.MANDT
  • I_PROVIDERCONTRACTITEM.REVENUERECOGNITIONKEY == TKKAA.ABGSL
  • I_PROVIDERCONTRACTITEM.EBRRRESULTANALYSISINTERNALID == TKKAA.ABGSL
Order Number
  • Order Number
  • Client
  • I_PROVIDERCONTRACTITEM.INTERNALORDER == AUFK.AUFNR
  • I_PROVIDERCONTRACTITEM.MANDT == AUFK.MANDT
Payment Condition
  • Payment Condition
  • Client
  • I_PROVIDERCONTRACTITEM.PAYMENTCONDITION == TE052.ZAHLKOND
  • I_PROVIDERCONTRACTITEM.MANDT == TE052.MANDT
Contract Key
  • Client
  • Identification of a Provider Contract
  • I_PROVIDERCONTRACTITEM.MANDT == DFKK_VT_H.MANDT
  • I_PROVIDERCONTRACTITEM.PROVIDERCONTRACT == DFKK_VT_H.VTKEY
Reference Type for Revenue Accounting
  • Client
  • Reference Type for Revenue Accounting
  • Reference Type for Revenue Accounting
  • I_PROVIDERCONTRACTITEM.MANDT == TFK_RA_REFTYPE.MANDT
  • I_PROVIDERCONTRACTITEM.CAREVENUEACCOUNTINGREFTYPE == TFK_RA_REFTYPE.REFERENCE_TYPE
  • I_PROVIDERCONTRACTITEM.REVENUEACCOUNTINGREFTYPE == TFK_RA_REFTYPE.REFERENCE_TYPE
Recognition key
  • Client
  • Recognition key
  • Recognition key
  • I_PROVIDERCONTRACTITEM.MANDT == TKKAA.MANDT
  • I_PROVIDERCONTRACTITEM.REVENUERECOGNITIONKEY == TKKAA.ABGSL
  • I_PROVIDERCONTRACTITEM.EBRRRESULTANALYSISINTERNALID == TKKAA.ABGSL
Sales Organization
  • Sales Organization
  • Client
  • I_PROVIDERCONTRACTITEM.SALESORGANIZATION == TVKO.VKORG
  • I_PROVIDERCONTRACTITEM.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_PROVIDERCONTRACTITEM.SEGMENT == FAGL_SEGM.SEGMENT
  • I_PROVIDERCONTRACTITEM.MANDT == FAGL_SEGM.MANDT
Product Sold
  • Product Sold
  • Client
  • I_PROVIDERCONTRACTITEM.SOLDPRODUCT == MARA.MATNR
  • I_PROVIDERCONTRACTITEM.MANDT == MARA.MANDT
Time Unit for Recurrence Period
  • Time Unit for Recurrence Period
  • Client
  • I_PROVIDERCONTRACTITEM.SSPRICERECURRENCEPERDTIMEUNIT == TIMECUUT.NAME_UNIT
  • I_PROVIDERCONTRACTITEM.MANDT == TIMECUUT.CLIENT
Currency Key
  • Currency Key
  • Client
  • I_PROVIDERCONTRACTITEM.STANDALONESELLINGPRICECURRENCY == TCURC.WAERS
  • I_PROVIDERCONTRACTITEM.MANDT == TCURC.MANDT
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • I_PROVIDERCONTRACTITEM.TAXCOUNTRY == T005.LAND1
  • I_PROVIDERCONTRACTITEM.MANDT == T005.MANDT
Time Unit for Recurrence Period
  • Time Unit for Recurrence Period
  • Client
  • I_PROVIDERCONTRACTITEM.TRANSACPRICERCRRCPERDTIMEUNIT == TIMECUUT.NAME_UNIT
  • I_PROVIDERCONTRACTITEM.MANDT == TIMECUUT.CLIENT
Currency Key
  • Client
  • Currency Key
  • I_PROVIDERCONTRACTITEM.MANDT == TCURC.MANDT
  • I_PROVIDERCONTRACTITEM.TRANSACTIONPRICECURRENCY == TCURC.WAERS