SAP table reference

DFKK_VT_I

CT: Items of Provider Contract

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table DFKK_VT_I.

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

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

DFKK_VT_I fields.

106 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 MANDT
Key VTKEY Identification of a Provider ContractCHAR200 DFKK_VT_H VTKEY_KK
Key VTPOS Contract: Item NumberNUMC60 VTPOS_KK
ERDAT Date on which the record was createdDATS80 ERDAT
ERTIM Time at which the object was createdTIMS60 ERTIM_KK
ERNAM Name of Person Responsible for Creating the ObjectCHAR120 ERNAM
AEDAT Last Changed OnDATS80 AEDAT
AETIM Last Changed AtTIMS60 AETIM2_KK
AENAM Name of Person Who Changed ObjectCHAR120 AENAM
VTPID External GUID of Provider Contract ItemsRAW160 VTPID_KK
VALFR Valid From (Time Stamp)DEC150 VALID_FROM_KK
VALFR_LOCL Local Time in Short Form (YYYYMMDDhhmmss)DEC150 TLOCL_KK
VALTO Valid To (Time Stamp)DEC150 VALID_TO_KK
VALTO_LOCL Local Time in Short Form (YYYYMMDDhhmmss)DEC150 TLOCL_KK
CANCL Time of Reversal (Time Stamp)DEC150 CANCELLATION_TSTMP_KK
PAPID External GUID of Higher-Level Provider Contract ItemsRAW160 PAPID_KK
VTITT Text for Provider Contract ItemCHAR500 VTITT_KK
VKONT Contract Account NumberCHAR120 * VKONT_KK
PPACC Prepaid AccountCHAR120 PPACC_KK
VKORG Sales OrganizationCHAR40 TVKO VKORG
VTWEG Distribution ChannelCHAR20 TVKOV VTWEG
SPART DivisionCHAR20 SPART
VBER1 Contract: Sales Area Attribute 1CHAR40 VBER1_KK
VBER2 Contract: Sales Area Attribute 2CHAR40 VBER2_KK
BUKRS Company CodeCHAR40 * BUKRS
PRCTR Profit CenterCHAR100 PRCTR
SEGMT Segment for Segmental ReportingCHAR100 FAGL_SEGM SEGMT_KK
STDSP Contract: Standard DivisionCHAR20 * STDSP_KK
GSBER Business AreaCHAR40 TGSB GSBER
PRDNR Product NumberCHAR400 * PRDNR_KK
CYCLE Billing CycleCHAR40 TFK2607 CYCLE_KK
CYCLE_DAY Day of Period EndCHAR20 CYCLE_DAY_KK
CYCLE_DATE Contract: Date of Original Start of PeriodDATS80 CYCLE_DATE_KK
VALTO_PRE Valid To (Time Stamp)DEC150 VALID_TO_KK
INV_SCHEDULE Selection Characteristic for SchedulingCHAR40 TFK2606 INV_SCHEDULE_KK
VTTRG Group of IDsNUMC60 * VTTRG_KK
MAKEY Identification of Master AgreementCHAR100 * MAKEY_KK
MAPRD Custom Product or Product RangeCHAR400 MAPRD_KK
SRVRP Recipient of ServiceCHAR100 BUT000 SRVRP_KK
PTSRL Partner Settlement RuleCHAR40 TFKPS_RULE PTSRL_KK
VTKRF Reference to Sharing ContractCHAR200 * VTKRF_KK
AUFNR Order NumberCHAR120 AUFK AUFNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element)NUMC80 PRPS PS_PSP_PNR
CB_SOLDTO Sold-To PartyCHAR100 BUT000 GPSTO_KK
CB_BILLTO Invoice RecipientCHAR100 BUT000 GPBTO_KK
CB_DZTERM Terms of payment keyCHAR40 T052 DZTERM
CB_BEMOT Accounting IndicatorCHAR20 TBMOT BEMOT
CB_MNDID Unique Reference to Mandate for each PayeeCHAR350 SEPA_MNDID
CB_CCARD_ID Payment Card ID for PaymentsCHAR60 CCID_KK
RATING_AREA Rating AreaCHAR40 TFK_RA_DEF RATING_AREA_KK
RAREL Relevant for Revenue AccountingCHAR10 RAREL_KK
RA_REFTYPE Reference Type for Revenue AccountingCHAR30 TFK_RA_REFTYPE RAI_REFTYPE_KK
RA_REFID Reference ID for Revenue AccountingCHAR300 RAI_REFID_KK
PRDNR_SP Product ID of the Sales PackageCHAR400 * PRDNR_SP_KK
TRPRC Transaction Price for Each Recurrence PeriodCURR132 TRPRC_KK
TRPRC_CURR Currency KeyCUKY50 TCURC WAERS
TRPRC_FREQ_UNIT Time Unit for Recurrence PeriodCHAR120 TIMECUUT PRICE_FREQ_UNIT_KK
TRPRC_FREQ_DURATION Length of Recurrence PeriodDEC130 PRICE_FREQ_DURATION_KK
SSPRC Standalone Selling Price for Each Recurrence PeriodCURR132 SSPRC_KK
SSPRC_CURR Currency KeyCUKY50 TCURC WAERS
SSPRC_FREQ_UNIT Time Unit for Recurrence PeriodCHAR120 TIMECUUT PRICE_FREQ_UNIT_KK
SSPRC_FREQ_DURATION Length of Recurrence PeriodDEC130 PRICE_FREQ_DURATION_KK
VALTO_CTRTERM End of Contract Duration (Time Stamp)DEC150 VALID_TO_CTRTERM_KK
VALTO_CTRTERM_LOCL Local Time in Short Form (YYYYMMDDhhmmss)DEC150 TLOCL_KK
CHRSN Change ReasonCHAR20 TFK_RA_CHRSN RAI_CHANGE_REASON_KK
RA_SRCDOC_ID Revenue Accounting Item IDCHAR200 RAI_SRCDOC_ID_KK
RA_MIG_PACKAGE Migration Package IDCHAR40 RAI_MIG_PACKAGE_KK
TRPRC_TOTAL Total Transaction PriceCURR132 TRPRC_TOTAL_KK
SSPRC_TOTAL Total Standalone Selling PriceCURR132 SSPRC_TOTAL_KK
ADRSR Address Number for Recipient of the ServiceCHAR100 * ADRSR_KK
TXJCD Jurisdiction for Tax Calculation - Tax Jurisdiction CodeCHAR150 * TXJCD_NOCD_KK
LANDL Destination Country/Region (for Tax Reports)CHAR30 T005 LANDL_NOCD_KK
STATUS Status of Provider ContractCHAR10 STATUS_VT_KK
CUOBJ Configuration InstanceNUMC180 CU_INSTANCE_KK
BILLPLANNO Billing Plan NumberNUMC120 * BILLPLANNO_KK
MAHNV Dunning ProcedureCHAR20 MAHNV_KK
XDISCOEXEMPT Disconnection of Service Not PermittedCHAR10 XDISCOEXEMPT_KK
TAX_COUNTRY Tax Reporting Country/RegionCHAR30 T005 FOT_TAX_COUNTRY
ZAHLKOND Payment ConditionCHAR40 TE052 KONDZAHL
EZAWE Incoming Payment MethodCHAR10 EZAWE_KK
ABWRE Alternative PayerCHAR100 BUT000 ABWRE_KK
ADRRE Address Number for Alternative PayerCHAR100 * ADRRE_KK
EBVTY Bank Details ID for Incoming PaymentsCHAR40 EBVTY_KK
MNDID Unique Reference to Mandate for each PayeeCHAR350 SEPA_MNDID
CCARD_ID Payment Card ID for Incoming PaymentsCHAR60 CCID_IN_KK
AZAWE Outgoing Payment MethodsCHAR50 AZAWE_KK
ABWRA Alternative PayeeCHAR100 BUT000 ABWRA_KK
ADRRA Address Number for Alternative PayeeCHAR100 * ADRRA_KK
ABVTY Bank Details ID for Outgoing PaymentsCHAR40 ABVTY_KK
CCARD_OUT Payment Card ID for Outgoing PaymentsCHAR60 CCID_OUT_KK
PAY_PAR_ACTIVE Determination of Payment DataCHAR10 PAY_PAR_ORIG_KK
DUNN_PAR_ACTIVE Dunning ControlCHAR10 DUNN_PAR_ORIG_KK
QUANTITY QuantityQUAN186 VT_QUANTITY_KK
QUANTITY_UNIT Unit of MeasureUNIT30 T006 VT_QUANTITY_UNIT_KK
VALFROM_CTRTERM Contract Term Start (Time Stamp)DEC150 VALID_FROM_CTRTERM_KK
VALFROM_CTRTERM_LOCL Local Time in Short Form (YYYYMMDDhhmmss)DEC150 TLOCL_KK
RECURR_SERVICE_TYPE Service TypeCHAR60 TFK_RA_SERVTYP RAI_SERVICE_TYPE_RECURR_KK
REV_REC_KEY Recognition keyCHAR60 TKKAA ABGR_SCHL_CUST_TBRR
SOLUTION_ORDER_ID Solution OrderCHAR100 CRMS4_SOLO_OBJECT_ID
SOLUTION_ORDER_ITEM_ID Solution Order ItemNUMC60 CRMS4_SOLO_NUMBER_INT
MATNR_COPA Product SoldCHAR400 MARA FINS_MATNR_PA
CHARGE_TYPE Charge TypeCHAR20 CHARGE_TYPE_KK
BSTKD Customer ReferenceCHAR350 BSTKD_KK
BSTDK Customer Reference DateDATS80 BSTDK_KK
RA_OI_ORIG Type of Origin for Transfer RecordCHAR10 RA_OI_ORIG_KK
DUMMY_PRVCTRITM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension IncludesCHAR10 CFD_DUMMY
/ Relationships

DFKK_VT_I relationships.

53 relationships
TableFieldCheck tableDescriptionCheck field
DFKK_VT_IABWRABUT000BP: General data IPARTNER
DFKK_VT_IABWREBUT000BP: General data IPARTNER
DFKK_VT_IAUFNRAUFKOrder master dataAUFNR
DFKK_VT_ICB_BEMOTTBMOTAccounting indicatorsMANDT
DFKK_VT_ICB_BEMOTTBMOTAccounting indicatorsBEMOT
DFKK_VT_ICB_BILLTOBUT000BP: General data IPARTNER
DFKK_VT_ICB_DZTERMT052Terms of PaymentMANDT
DFKK_VT_ICB_DZTERMT052Terms of PaymentZTERM
DFKK_VT_ICB_DZTERMT052Terms of PaymentZTAGG
DFKK_VT_ICB_SOLDTOBUT000BP: General data IPARTNER
DFKK_VT_ICHRSNTFK_RA_CHRSNChange Reasons for Provider Contract ItemsMANDT
DFKK_VT_ICHRSNTFK_RA_CHRSNChange Reasons for Provider Contract ItemsCHANGE_REASON
DFKK_VT_ICYCLETFK2607Billing CyclesCYCLE
DFKK_VT_IGSBERTGSBBusiness AreasMANDT
DFKK_VT_IGSBERTGSBBusiness AreasGSBER
DFKK_VT_IINV_SCHEDULETFK2606SchedulingMANDT
DFKK_VT_IINV_SCHEDULETFK2606SchedulingINV_SCHEDULE
DFKK_VT_ILANDLT005CountriesMANDT
DFKK_VT_ILANDLT005CountriesLAND1
DFKK_VT_IMATNR_COPAMARAGeneral Material DataMANDT
DFKK_VT_IMATNR_COPAMARAGeneral Material DataMATNR
DFKK_VT_IPS_PSP_PNRPRPSWBS (Work Breakdown Structure) Element Master DataMANDT
DFKK_VT_IPS_PSP_PNRPRPSWBS (Work Breakdown Structure) Element Master DataPSPNR
DFKK_VT_IPTSRLTFKPS_RULEPartner Settlement RuleMANDT
DFKK_VT_IPTSRLTFKPS_RULEPartner Settlement RulePTSRL
DFKK_VT_IQUANTITY_UNITT006Units of MeasurementMANDT
DFKK_VT_IRA_REFTYPETFK_RA_REFTYPEReference Types for Revenue Accounting ItemsMANDT
DFKK_VT_IRA_REFTYPETFK_RA_REFTYPEReference Types for Revenue Accounting ItemsREFERENCE_TYPE
DFKK_VT_IRECURR_SERVICE_TYPETFK_RA_SERVTYPService Types for Revenue Accounting ItemsMANDT
DFKK_VT_IRECURR_SERVICE_TYPETFK_RA_SERVTYPService Types for Revenue Accounting ItemsSERVICE_TYPE
DFKK_VT_IREV_REC_KEYTKKAACheck Table for Results Analysis Key of RA for OrdersMANDT
DFKK_VT_IREV_REC_KEYTKKAACheck Table for Results Analysis Key of RA for OrdersABGSL
DFKK_VT_ISEGMTFAGL_SEGMMaster Data for SegmentsSEGMENT
DFKK_VT_ISRVRPBUT000BP: General data IPARTNER
DFKK_VT_ISSPRC_CURRTCURCCurrency CodesMANDT
DFKK_VT_ISSPRC_CURRTCURCCurrency CodesWAERS
DFKK_VT_ISSPRC_FREQ_UNITTIMECUUTSymbolic Names for Time DurationsCLIENT
DFKK_VT_ISSPRC_FREQ_UNITTIMECUUTSymbolic Names for Time DurationsNAME_UNIT
DFKK_VT_ITAX_COUNTRYT005CountriesMANDT
DFKK_VT_ITAX_COUNTRYT005CountriesLAND1
DFKK_VT_ITRPRC_CURRTCURCCurrency CodesMANDT
DFKK_VT_ITRPRC_CURRTCURCCurrency CodesWAERS
DFKK_VT_ITRPRC_FREQ_UNITTIMECUUTSymbolic Names for Time DurationsCLIENT
DFKK_VT_ITRPRC_FREQ_UNITTIMECUUTSymbolic Names for Time DurationsNAME_UNIT
DFKK_VT_IVKORGTVKOOrganizational Unit: Sales OrganizationsMANDT
DFKK_VT_IVKORGTVKOOrganizational Unit: Sales OrganizationsVKORG
DFKK_VT_IVTKEYDFKK_VT_HCT: Header Data of Provider ContractMANDT
DFKK_VT_IVTKEYDFKK_VT_HCT: Header Data of Provider ContractVTKEY
DFKK_VT_IVTWEGTVKOVOrg. Unit: Distribution Channels per Sales OrganizationMANDT
DFKK_VT_IVTWEGTVKOVOrg. Unit: Distribution Channels per Sales OrganizationVKORG
DFKK_VT_IVTWEGTVKOVOrg. Unit: Distribution Channels per Sales OrganizationVTWEG
DFKK_VT_IZAHLKONDTE052Terms of PaymentMANDT
DFKK_VT_IZAHLKONDTE052Terms of PaymentZAHLKOND