SAP Table

DFKK_VT_I CT: Items of Provider Contract

SAP table DFKK_VT_I has 3 primary key fields being MANDT,VTKEY,VTPOS.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

DFKK_VT_I columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 MANDT
KeyVTKEY Identification of a Provider Contract CHAR 20 0 DFKK_VT_H VTKEY_KK
KeyVTPOS Contract: Item Number NUMC 6 0 VTPOS_KK
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERTIM Time at which the object was created TIMS 6 0 ERTIM_KK
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AETIM Last Changed At TIMS 6 0 AETIM2_KK
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
VTPID External GUID of Provider Contract Items RAW 16 0 VTPID_KK
VALFR Valid From (Time Stamp) DEC 15 0 VALID_FROM_KK
VALFR_LOCL Local Time in Short Form (YYYYMMDDhhmmss) DEC 15 0 TLOCL_KK
VALTO Valid To (Time Stamp) DEC 15 0 VALID_TO_KK
VALTO_LOCL Local Time in Short Form (YYYYMMDDhhmmss) DEC 15 0 TLOCL_KK
CANCL Time of Reversal (Time Stamp) DEC 15 0 CANCELLATION_TSTMP_KK
PAPID External GUID of Higher-Level Provider Contract Items RAW 16 0 PAPID_KK
VTITT Text for Provider Contract Item CHAR 50 0 VTITT_KK
VKONT Contract Account Number CHAR 12 0 * VKONT_KK
PPACC Prepaid Account CHAR 12 0 PPACC_KK
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 SPART
VBER1 Contract: Sales Area Attribute 1 CHAR 4 0 VBER1_KK
VBER2 Contract: Sales Area Attribute 2 CHAR 4 0 VBER2_KK
BUKRS Company Code CHAR 4 0 * BUKRS
PRCTR Profit Center CHAR 10 0 PRCTR
SEGMT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM SEGMT_KK
STDSP Contract: Standard Division CHAR 2 0 * STDSP_KK
GSBER Business Area CHAR 4 0 TGSB GSBER
PRDNR Product Number CHAR 40 0 * PRDNR_KK
CYCLE Billing Cycle CHAR 4 0 TFK2607 CYCLE_KK
CYCLE_DAY Day of Period End CHAR 2 0 CYCLE_DAY_KK
CYCLE_DATE Contract: Date of Original Start of Period DATS 8 0 CYCLE_DATE_KK
VALTO_PRE Valid To (Time Stamp) DEC 15 0 VALID_TO_KK
INV_SCHEDULE Selection Characteristic for Scheduling CHAR 4 0 TFK2606 INV_SCHEDULE_KK
VTTRG Group of IDs NUMC 6 0 * VTTRG_KK
MAKEY Identification of Master Agreement CHAR 10 0 * MAKEY_KK
MAPRD Custom Product or Product Range CHAR 40 0 MAPRD_KK
SRVRP Recipient of Service CHAR 10 0 BUT000 SRVRP_KK
PTSRL Partner Settlement Rule CHAR 4 0 TFKPS_RULE PTSRL_KK
VTKRF Reference to Sharing Contract CHAR 20 0 * VTKRF_KK
AUFNR Order Number CHAR 12 0 AUFK AUFNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
CB_SOLDTO Sold-To Party CHAR 10 0 BUT000 GPSTO_KK
CB_BILLTO Invoice Recipient CHAR 10 0 BUT000 GPBTO_KK
CB_DZTERM Terms of payment key CHAR 4 0 T052 DZTERM
CB_BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
CB_MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
CB_CCARD_ID Payment Card ID for Payments CHAR 6 0 CCID_KK
RATING_AREA Rating Area CHAR 4 0 TFK_RA_DEF RATING_AREA_KK
RAREL Relevant for Revenue Accounting CHAR 1 0 RAREL_KK
RA_REFTYPE Reference Type for Revenue Accounting CHAR 3 0 TFK_RA_REFTYPE RAI_REFTYPE_KK
RA_REFID Reference ID for Revenue Accounting CHAR 30 0 RAI_REFID_KK
PRDNR_SP Product ID of the Sales Package CHAR 40 0 * PRDNR_SP_KK
TRPRC Transaction Price for Each Recurrence Period CURR 13 2 TRPRC_KK
TRPRC_CURR Currency Key CUKY 5 0 TCURC WAERS
TRPRC_FREQ_UNIT Time Unit for Recurrence Period CHAR 12 0 TIMECUUT PRICE_FREQ_UNIT_KK
TRPRC_FREQ_DURATION Length of Recurrence Period DEC 13 0 PRICE_FREQ_DURATION_KK
SSPRC Standalone Selling Price for Each Recurrence Period CURR 13 2 SSPRC_KK
SSPRC_CURR Currency Key CUKY 5 0 TCURC WAERS
SSPRC_FREQ_UNIT Time Unit for Recurrence Period CHAR 12 0 TIMECUUT PRICE_FREQ_UNIT_KK
SSPRC_FREQ_DURATION Length of Recurrence Period DEC 13 0 PRICE_FREQ_DURATION_KK
VALTO_CTRTERM End of Contract Duration (Time Stamp) DEC 15 0 VALID_TO_CTRTERM_KK
VALTO_CTRTERM_LOCL Local Time in Short Form (YYYYMMDDhhmmss) DEC 15 0 TLOCL_KK
CHRSN Change Reason CHAR 2 0 TFK_RA_CHRSN RAI_CHANGE_REASON_KK
RA_SRCDOC_ID Revenue Accounting Item ID CHAR 20 0 RAI_SRCDOC_ID_KK
RA_MIG_PACKAGE Migration Package ID CHAR 4 0 RAI_MIG_PACKAGE_KK
TRPRC_TOTAL Total Transaction Price CURR 13 2 TRPRC_TOTAL_KK
SSPRC_TOTAL Total Standalone Selling Price CURR 13 2 SSPRC_TOTAL_KK
ADRSR Address Number for Recipient of the Service CHAR 10 0 * ADRSR_KK
TXJCD Jurisdiction for Tax Calculation - Tax Jurisdiction Code CHAR 15 0 * TXJCD_NOCD_KK
LANDL Destination Country/Region (for Tax Reports) CHAR 3 0 T005 LANDL_NOCD_KK
STATUS Status of Provider Contract CHAR 1 0 STATUS_VT_KK
CUOBJ Configuration Instance NUMC 18 0 CU_INSTANCE_KK
BILLPLANNO Billing Plan Number NUMC 12 0 * BILLPLANNO_KK
MAHNV Dunning Procedure CHAR 2 0 MAHNV_KK
XDISCOEXEMPT Disconnection of Service Not Permitted CHAR 1 0 XDISCOEXEMPT_KK
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 T005 FOT_TAX_COUNTRY
ZAHLKOND Payment Condition CHAR 4 0 TE052 KONDZAHL
EZAWE Incoming Payment Method CHAR 1 0 EZAWE_KK
ABWRE Alternative Payer CHAR 10 0 BUT000 ABWRE_KK
ADRRE Address Number for Alternative Payer CHAR 10 0 * ADRRE_KK
EBVTY Bank Details ID for Incoming Payments CHAR 4 0 EBVTY_KK
MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
CCARD_ID Payment Card ID for Incoming Payments CHAR 6 0 CCID_IN_KK
AZAWE Outgoing Payment Methods CHAR 5 0 AZAWE_KK
ABWRA Alternative Payee CHAR 10 0 BUT000 ABWRA_KK
ADRRA Address Number for Alternative Payee CHAR 10 0 * ADRRA_KK
ABVTY Bank Details ID for Outgoing Payments CHAR 4 0 ABVTY_KK
CCARD_OUT Payment Card ID for Outgoing Payments CHAR 6 0 CCID_OUT_KK
PAY_PAR_ACTIVE Determination of Payment Data CHAR 1 0 PAY_PAR_ORIG_KK
DUNN_PAR_ACTIVE Dunning Control CHAR 1 0 DUNN_PAR_ORIG_KK
QUANTITY Quantity QUAN 18 6 VT_QUANTITY_KK
QUANTITY_UNIT Unit of Measure UNIT 3 0 T006 VT_QUANTITY_UNIT_KK
VALFROM_CTRTERM Contract Term Start (Time Stamp) DEC 15 0 VALID_FROM_CTRTERM_KK
VALFROM_CTRTERM_LOCL Local Time in Short Form (YYYYMMDDhhmmss) DEC 15 0 TLOCL_KK
RECURR_SERVICE_TYPE Service Type CHAR 6 0 TFK_RA_SERVTYP RAI_SERVICE_TYPE_RECURR_KK
REV_REC_KEY Recognition key CHAR 6 0 TKKAA ABGR_SCHL_CUST_TBRR
SOLUTION_ORDER_ID Solution Order CHAR 10 0 CRMS4_SOLO_OBJECT_ID
SOLUTION_ORDER_ITEM_ID Solution Order Item NUMC 6 0 CRMS4_SOLO_NUMBER_INT
MATNR_COPA Product Sold CHAR 40 0 MARA FINS_MATNR_PA
CHARGE_TYPE Charge Type CHAR 2 0 CHARGE_TYPE_KK
BSTKD Customer Reference CHAR 35 0 BSTKD_KK
BSTDK Customer Reference Date DATS 8 0 BSTDK_KK
RA_OI_ORIG Type of Origin for Transfer Record CHAR 1 0 RA_OI_ORIG_KK
DUMMY_PRVCTRITM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
/ Relationships

DFKK_VT_I foreign keys.

Table Field Check Table Description Check Field
DFKK_VT_I ABWRA BUT000 BP: General data I PARTNER
DFKK_VT_I ABWRE BUT000 BP: General data I PARTNER
DFKK_VT_I AUFNR AUFK Order master data AUFNR
DFKK_VT_I CB_BEMOT TBMOT Accounting indicators MANDT
DFKK_VT_I CB_BEMOT TBMOT Accounting indicators BEMOT
DFKK_VT_I CB_BILLTO BUT000 BP: General data I PARTNER
DFKK_VT_I CB_DZTERM T052 Terms of Payment MANDT
DFKK_VT_I CB_DZTERM T052 Terms of Payment ZTERM
DFKK_VT_I CB_DZTERM T052 Terms of Payment ZTAGG
DFKK_VT_I CB_SOLDTO BUT000 BP: General data I PARTNER
DFKK_VT_I CHRSN TFK_RA_CHRSN Change Reasons for Provider Contract Items MANDT
DFKK_VT_I CHRSN TFK_RA_CHRSN Change Reasons for Provider Contract Items CHANGE_REASON
DFKK_VT_I CYCLE TFK2607 Billing Cycles CYCLE
DFKK_VT_I GSBER TGSB Business Areas MANDT
DFKK_VT_I GSBER TGSB Business Areas GSBER
DFKK_VT_I INV_SCHEDULE TFK2606 Scheduling MANDT
DFKK_VT_I INV_SCHEDULE TFK2606 Scheduling INV_SCHEDULE
DFKK_VT_I LANDL T005 Countries MANDT
DFKK_VT_I LANDL T005 Countries LAND1
DFKK_VT_I MATNR_COPA MARA General Material Data MANDT
DFKK_VT_I MATNR_COPA MARA General Material Data MATNR
DFKK_VT_I PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
DFKK_VT_I PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
DFKK_VT_I PTSRL TFKPS_RULE Partner Settlement Rule MANDT
DFKK_VT_I PTSRL TFKPS_RULE Partner Settlement Rule PTSRL
DFKK_VT_I QUANTITY_UNIT T006 Units of Measurement MANDT
DFKK_VT_I RA_REFTYPE TFK_RA_REFTYPE Reference Types for Revenue Accounting Items MANDT
DFKK_VT_I RA_REFTYPE TFK_RA_REFTYPE Reference Types for Revenue Accounting Items REFERENCE_TYPE
DFKK_VT_I RECURR_SERVICE_TYPE TFK_RA_SERVTYP Service Types for Revenue Accounting Items MANDT
DFKK_VT_I RECURR_SERVICE_TYPE TFK_RA_SERVTYP Service Types for Revenue Accounting Items SERVICE_TYPE
DFKK_VT_I REV_REC_KEY TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
DFKK_VT_I REV_REC_KEY TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
DFKK_VT_I SEGMT FAGL_SEGM Master Data for Segments SEGMENT
DFKK_VT_I SRVRP BUT000 BP: General data I PARTNER
DFKK_VT_I SSPRC_CURR TCURC Currency Codes MANDT
DFKK_VT_I SSPRC_CURR TCURC Currency Codes WAERS
DFKK_VT_I SSPRC_FREQ_UNIT TIMECUUT Symbolic Names for Time Durations CLIENT
DFKK_VT_I SSPRC_FREQ_UNIT TIMECUUT Symbolic Names for Time Durations NAME_UNIT
DFKK_VT_I TAX_COUNTRY T005 Countries MANDT
DFKK_VT_I TAX_COUNTRY T005 Countries LAND1
DFKK_VT_I TRPRC_CURR TCURC Currency Codes MANDT
DFKK_VT_I TRPRC_CURR TCURC Currency Codes WAERS
DFKK_VT_I TRPRC_FREQ_UNIT TIMECUUT Symbolic Names for Time Durations CLIENT
DFKK_VT_I TRPRC_FREQ_UNIT TIMECUUT Symbolic Names for Time Durations NAME_UNIT
DFKK_VT_I VKORG TVKO Organizational Unit: Sales Organizations MANDT
DFKK_VT_I VKORG TVKO Organizational Unit: Sales Organizations VKORG
DFKK_VT_I VTKEY DFKK_VT_H CT: Header Data of Provider Contract MANDT
DFKK_VT_I VTKEY DFKK_VT_H CT: Header Data of Provider Contract VTKEY
DFKK_VT_I VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
DFKK_VT_I VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
DFKK_VT_I VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
DFKK_VT_I ZAHLKOND TE052 Terms of Payment MANDT
DFKK_VT_I ZAHLKOND TE052 Terms of Payment ZAHLKOND
Back to SAP tables