I_CABillPrntPrvdrContrItm

Provider Contract Item | view: ICABIPRPRVT_I | Extraction: Not supported | Component: Convergent Invoicing
Tables used: DFKK_VT_H, DFKK_VT_I
Column Name Description
CAProviderContract FK Identification of a Provider Contract
CAProviderContractItemNumber Contract: Item Number
CAProduct Product 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
CAProviderContractName Name of Contract TEXT35
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
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
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
CABillgPrintProdLongDesc null
CABillgPrintProdShortDesc null
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TGSB.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.BUSINESSAREA == TGSB.GSBER
Alternative Payee
  • Alternative Payee
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CAALTERNATIVEPAYEE == BUT000.PARTNER
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == BUT000.CLIENT
Alternative Payer
  • Alternative Payer
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CAALTERNATIVEPAYER == BUT000.PARTNER
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == BUT000.CLIENT
Billing Cycle
  • Billing Cycle
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CABILLGCYCLE == TFK2607.CYCLE
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TFK2607.MANDT
Invoice Recipient
  • Invoice Recipient
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CACONSUMPTIONBILLGINVOICERCPNT == BUT000.PARTNER
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == BUT000.CLIENT
Sold-To Party
  • Sold-To Party
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CACONSUMPTIONBILLGSOLDTOPARTY == BUT000.PARTNER
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == BUT000.CLIENT
Selection Characteristic for Scheduling
  • Client
  • Selection Characteristic for Scheduling
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TFK2606.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.CAINVCGSCHEDULE == TFK2606.INV_SCHEDULE
Partner Settlement Rule
  • Client
  • Partner Settlement Rule
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TFKPS_RULE.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.CAPARTNERSETTLEMENTRULE == TFKPS_RULE.PTSRL
Contract Key
  • Client
  • Identification of a Provider Contract
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == DFKK_VT_H.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.CAPROVIDERCONTRACT == DFKK_VT_H.VTKEY
Unit of Measure
  • Client
  • Unit of Measure
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == T006.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.CAPROVIDERCONTRACTQUANTITYUNIT == T006.MSEHI
Change Reason
  • Client
  • Change Reason
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TFK_RA_CHRSN.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.CAPRVDRCONTRITMCHGREASON == TFK_RA_CHRSN.CHANGE_REASON
Rating Area
  • Client
  • Rating Area
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TFK_RA_DEF.CLIENT
  • I_CABILLPRNTPRVDRCONTRITM.CARATINGAREA == TFK_RA_DEF.RATING_AREA
Destination Country/Region (for Tax Reports)
  • Destination Country/Region (for Tax Reports)
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CARECEIVINGCOUNTRY == T005.LAND1
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == T005.MANDT
Service Types
  • Service Type
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CAREVNACCTGRECRRGSERVICETYPE == TFK_RA_SERVTYP.SERVICE_TYPE
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TFK_RA_SERVTYP.MANDT
Foreign Key for Service Recipient on BUT000
  • Recipient of Service
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CASERVICERECIPIENT == BUT000.PARTNER
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == BUT000.CLIENT
Accounting Indicator
  • Accounting Indicator
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.CNSMPNBILLGBILLABLECONTROL == TBMOT.BEMOT
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TBMOT.MANDT
Terms of Payment
  • ?
  • Terms of payment key
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • I_CABILLPRNTPRVDRCONTRITM.CONSUMPTIONBILLINGPAYMENTTERMS == T052.ZTERM
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == T052.MANDT
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • I_CABILLPRNTPRVDRCONTRITM.SALESORGANIZATION == TVKOV.VKORG
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TVKOV.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Order Number
  • Client
  • Order Number
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == AUFK.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.INTERNALORDER == AUFK.AUFNR
Payment Condition
  • Client
  • Payment Condition
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TE052.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.PAYMENTCONDITION == TE052.ZAHLKOND
Reference Type for Revenue Accounting
  • Reference Type for Revenue Accounting
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.REVENUEACCOUNTINGREFTYPE == TFK_RA_REFTYPE.REFERENCE_TYPE
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TFK_RA_REFTYPE.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.SALESORGANIZATION == TVKO.VKORG
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.SEGMENT == FAGL_SEGM.SEGMENT
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == FAGL_SEGM.MANDT
Product Sold
  • Client
  • Product Sold
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == MARA.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.SOLDPRODUCT == MARA.MATNR
Time Unit for Recurrence Period
  • Client
  • Time Unit for Recurrence Period
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TIMECUUT.CLIENT
  • I_CABILLPRNTPRVDRCONTRITM.SSPRICERECURRENCEPERDTIMEUNIT == TIMECUUT.NAME_UNIT
Currency Key
  • Client
  • Currency Key
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TCURC.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.STANDALONESELLINGPRICECURRENCY == TCURC.WAERS
Tax Reporting Country/Region
  • Client
  • Tax Reporting Country/Region
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == T005.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.TAXCOUNTRY == T005.LAND1
Time Unit for Recurrence Period
  • Time Unit for Recurrence Period
  • Client
  • I_CABILLPRNTPRVDRCONTRITM.TRANSACPRICERCRRCPERDTIMEUNIT == TIMECUUT.NAME_UNIT
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TIMECUUT.CLIENT
Currency Key
  • Client
  • Currency Key
  • I_CABILLPRNTPRVDRCONTRITM.MANDT == TCURC.MANDT
  • I_CABILLPRNTPRVDRCONTRITM.TRANSACTIONPRICECURRENCY == TCURC.WAERS