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're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
VTKEY Identification of a Provider Contract CHAR 20 0 DFKK_VT_H VTKEY_KK
VTPOS 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
Defaulted Using Billing Cycle
01 1st Day of Month
02 2nd Day of Month
03 3rd Day of Month
04 4th Day of Month
05 5th Day of Month
06 6th Day of Month
07 7th Day of Month
08 8th Day of Month
09 9th Day of Month
10 10th Day of Month
11 11th Day of Month
12 12th Day of Month
13 13th Day of Month
14 14th Day of Month
15 15th Day of Month
16 16th Day of Month
17 17th Day of Month
18 18th Day of Month
19 19th Day of Month
20 20th Day of Month
21 21st Day of Month
22 22nd Day of Month
23 23rd Day of Month
24 24th Day of Month
25 25th Day of Month
26 26th Day of Month
27 27th Day of Month
28 28th Day of Month
29 29th Day of Month
30 30th Day of Month
31 31st Day of Month
W1 Monday
W2 Tuesday
W3 Wednesday
W4 Thursday
W5 Friday
W6 Saturday
W7 Sunday
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
Not Relevant for Revenue Accounting
X Relevant for Revenue Accounting
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
Active
I Inactive
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
Use Payment Data from Contract Account
X Use Payment Data from Provider Contract
DUNN_PAR_ACTIVE Dunning Control CHAR 1 0 DUNN_PAR_ORIG_KK
Use Dunning Control from Contract Account
X Use Dunning Control from Provider Contract
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
01 One-Time
02 Recurring
03 Usage-Based
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
Provider Contract Creates Order Item
1 Billing Plan Creates Order Item
DUMMY_PRVCTRITM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY

DFKK_VT_I foreign key relationships

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