DFKK_VT_I

CT: Items of Provider Contract | #masterdata | Component: Contract Accounts Receivable and Payable
Column Name Description
MANDT Client
VTKEY FK Identification of a Provider Contract
VTPOS Contract: Item Number
Column Name Description
💲 Currency Key (TRPRC_CURR):
TRPRC Transaction Price for Each Recurrence Period
TRPRC_TOTAL Total Transaction Price
💲 Currency Key (SSPRC_CURR):
SSPRC Standalone Selling Price for Each Recurrence Period
SSPRC_TOTAL Total Standalone Selling Price
Column Name Description
📏 Unit of Measure (QUANTITY_UNIT):
QUANTITY Quantity
Column Name Description
ERDAT Date on which the record was created
ERTIM Time at which the object was created
AEDAT Last Changed On
AETIM Last Changed At
CYCLE_DATE Contract: Date of Original Start of Period
BSTDK Customer Reference Date
Column Name Description
CYCLE_DAY Day of Period End Show values
RAREL Relevant for Revenue Accounting Show values
STATUS Status of Provider Contract Show values
XDISCOEXEMPT Disconnection of Service Not Permitted Show values
PAY_PAR_ACTIVE Determination of Payment Data Show values
DUNN_PAR_ACTIVE Dunning Control Show values
CHARGE_TYPE Charge Type Show values
RA_OI_ORIG Type of Origin for Transfer Record Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
VTPID External GUID of Provider Contract Items SYSUUID
VALFR Valid From (Time Stamp) TZNTSTMPS
VALFR_LOCL Local Time in Short Form (YYYYMMDDhhmmss) TLOCL_KK
VALTO Valid To (Time Stamp) TZNTSTMPS
VALTO_LOCL Local Time in Short Form (YYYYMMDDhhmmss) TLOCL_KK
CANCL Time of Reversal (Time Stamp) TZNTSTMPS
PAPID External GUID of Higher-Level Provider Contract Items SYSUUID
VTITT Text for Provider Contract Item TEXT50
VKONT Contract Account Number VKONT_KK
PPACC Prepaid Account PPACC_KK
SPART Division SPART
VBER1 Contract: Sales Area Attribute 1 VKBER_KK
VBER2 Contract: Sales Area Attribute 2 VKBER_KK
BUKRS Company Code BUKRS
PRCTR Profit Center PRCTR
STDSP Contract: Standard Division SPART
PRDNR Product Number PRDNR_KK
VALTO_PRE Valid To (Time Stamp) TZNTSTMPS
VTTRG Group of IDs VTTRG_KK
MAKEY Identification of Master Agreement MAKEY_KK
MAPRD Custom Product or Product Range MAPRD_KK
VTKRF Reference to Sharing Contract VTKEY_KK
CB_MNDID Unique Reference to Mandate for each Payee ID035
CB_CCARD_ID Payment Card ID for Payments CHAR6
RA_REFID Reference ID for Revenue Accounting CHAR30
PRDNR_SP Product ID of the Sales Package PRDNR_KK
TRPRC_FREQ_DURATION Length of Recurrence Period TIMEDURA
SSPRC_FREQ_DURATION Length of Recurrence Period TIMEDURA
VALTO_CTRTERM End of Contract Duration (Time Stamp) TZNTSTMPS
VALTO_CTRTERM_LOCL Local Time in Short Form (YYYYMMDDhhmmss) TLOCL_KK
RA_SRCDOC_ID Revenue Accounting Item ID
RA_MIG_PACKAGE Migration Package ID
ADRSR Address Number for Recipient of the Service AD_ADDRNUM
TXJCD Jurisdiction for Tax Calculation - Tax Jurisdiction Code TXJCD
CUOBJ Configuration Instance CU_INSTANCE_KK
BILLPLANNO Billing Plan Number BILLPLANNO_KK
MAHNV Dunning Procedure MAHNV_KK
EZAWE Incoming Payment Method CHAR1
ADRRE Address Number for Alternative Payer AD_ADDRNUM
EBVTY Bank Details ID for Incoming Payments CHAR4
MNDID Unique Reference to Mandate for each Payee ID035
CCARD_ID Payment Card ID for Incoming Payments CHAR6
AZAWE Outgoing Payment Methods CHAR5
ADRRA Address Number for Alternative Payee AD_ADDRNUM
ABVTY Bank Details ID for Outgoing Payments CHAR4
CCARD_OUT Payment Card ID for Outgoing Payments CHAR6
VALFROM_CTRTERM Contract Term Start (Time Stamp) TZNTSTMPS
VALFROM_CTRTERM_LOCL Local Time in Short Form (YYYYMMDDhhmmss) TLOCL_KK
SOLUTION_ORDER_ID Solution Order CRM_OBJECT_ID
SOLUTION_ORDER_ITEM_ID Solution Order Item CRMS4_NUMBER_INT
BSTKD Customer Reference BSTKD
DUMMY_PRVCTRITM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Alternative Payee
  • Alternative Payee
  • Client
  • DFKK_VT_I.ABWRA == BUT000.PARTNER
  • DFKK_VT_I.MANDT == BUT000.CLIENT
Alternative Payer
  • Alternative Payer
  • Client
  • DFKK_VT_I.ABWRE == BUT000.PARTNER
  • DFKK_VT_I.MANDT == BUT000.CLIENT
Order Number
  • Order Number
  • Client
  • DFKK_VT_I.AUFNR == AUFK.AUFNR
  • DFKK_VT_I.MANDT == AUFK.MANDT
Accounting Indicator
  • DFKK_VT_I.MANDT == TBMOT.MANDT
  • DFKK_VT_I.CB_BEMOT == TBMOT.BEMOT
Invoice Recipient
  • Invoice Recipient
  • Client
  • DFKK_VT_I.CB_BILLTO == BUT000.PARTNER
  • DFKK_VT_I.MANDT == BUT000.CLIENT
Terms of Payment
  • Terms of payment key
  • ?
  • Client
  • DFKK_VT_I.CB_DZTERM == T052.ZTERM
  • DFKK_VT_I.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • DFKK_VT_I.MANDT == T052.MANDT
Sold-To Party
  • Sold-To Party
  • Client
  • DFKK_VT_I.CB_SOLDTO == BUT000.PARTNER
  • DFKK_VT_I.MANDT == BUT000.CLIENT
Change Reason
Billing Cycle
Business Area
  • DFKK_VT_I.MANDT == TGSB.MANDT
  • DFKK_VT_I.GSBER == TGSB.GSBER
Selection Characteristic for Scheduling
  • Selection Characteristic for Scheduling
  • Client
  • DFKK_VT_I.INV_SCHEDULE == TFK2606.INV_SCHEDULE
  • DFKK_VT_I.MANDT == TFK2606.MANDT
Destination Country/Region (for Tax Reports)
  • Destination Country/Region (for Tax Reports)
  • Client
  • DFKK_VT_I.LANDL == T005.LAND1
  • DFKK_VT_I.MANDT == T005.MANDT
Product Sold
  • Product Sold
  • Client
  • DFKK_VT_I.MATNR_COPA == MARA.MATNR
  • DFKK_VT_I.MANDT == MARA.MANDT
Partner Settlement Rule
Unit of Measure
  • DFKK_VT_I.MANDT == T006.MANDT
  • DFKK_VT_I.QUANTITY_UNIT == T006.MSEHI
Rating Area
Reference Type for Revenue Accounting
Service Types
Recognition key
  • DFKK_VT_I.MANDT == TKKAA.MANDT
  • DFKK_VT_I.REV_REC_KEY == TKKAA.ABGSL
Segment for Segmental Reporting
Foreign Key for Service Recipient on BUT000
  • Recipient of Service
  • Client
  • DFKK_VT_I.SRVRP == BUT000.PARTNER
  • DFKK_VT_I.MANDT == BUT000.CLIENT
Currency Key
  • DFKK_VT_I.MANDT == TCURC.MANDT
  • DFKK_VT_I.SSPRC_CURR == TCURC.WAERS
Time Unit for Recurrence Period
  • Time Unit for Recurrence Period
  • Client
  • DFKK_VT_I.SSPRC_FREQ_UNIT == TIMECUUT.NAME_UNIT
  • DFKK_VT_I.MANDT == TIMECUUT.CLIENT
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • DFKK_VT_I.TAX_COUNTRY == T005.LAND1
  • DFKK_VT_I.MANDT == T005.MANDT
Currency Key
  • DFKK_VT_I.MANDT == TCURC.MANDT
  • DFKK_VT_I.TRPRC_CURR == TCURC.WAERS
Time Unit for Recurrence Period
  • Time Unit for Recurrence Period
  • Client
  • DFKK_VT_I.TRPRC_FREQ_UNIT == TIMECUUT.NAME_UNIT
  • DFKK_VT_I.MANDT == TIMECUUT.CLIENT
Sales Organization
  • DFKK_VT_I.MANDT == TVKO.MANDT
  • DFKK_VT_I.VKORG == TVKO.VKORG
Contract Key
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • DFKK_VT_I.VKORG == TVKOV.VKORG
  • DFKK_VT_I.MANDT == TVKOV.MANDT
  • DFKK_VT_I.VTWEG == TVKOV.VTWEG
Payment Condition
  • Payment Condition
  • Client
  • DFKK_VT_I.ZAHLKOND == TE052.ZAHLKOND
  • DFKK_VT_I.MANDT == TE052.MANDT