SAP Table
TVVD Contract Data Profile
SAP table TVVD (Contract Data Profile) contains configuration settings for contract profiles in SAP Sales and Distribution (SD). It defines the parameters and rules for managing contract-related data, such as contract validity, billing relevance, and other control options. This table is used to customize how contracts are processed within the system.
SAP table TVVD has 2 primary key fields being MANDT,VPROF.
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
TVVD columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyVPROF | Profile with default values for contract data | CHAR | 4 | 0 | VPROF | ||
| VLAUFK | Validity Period Category of Contract | CHAR | 2 | 0 | TVLZ | VLAUK_VEDA | |
| VKUESCH | Assignment Cancellation Procedure/Cancellation Rule | CHAR | 4 | 0 | TVKS | VKUES_VEDA | |
| VAKTSCH | Action at end of contract | CHAR | 4 | 0 | TVAS | VASCH_VEDA | |
| VBEGREG | Rule for calculating contract start date | CHAR | 2 | 0 | TVRG | VBREG_VEDA | |
| VENDREG | Rule for contract end date | CHAR | 2 | 0 | TVRG | RGVTE | |
| VASDR | Date rule for action | CHAR | 2 | 0 | TVRG | VASDR |
/ Relationships
TVVD foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TVVD | VAKTSCH | TVAS | Action Procedure for End of Contract | MANDT |
| TVVD | VAKTSCH | TVAS | Action Procedure for End of Contract | AKTVT |
| TVVD | VASDR | TVRG | Rule table for indirect date determination for contracts | MANDT |
| TVVD | VASDR | TVRG | Rule table for indirect date determination for contracts | REGEL |
| TVVD | VBEGREG | TVRG | Rule table for indirect date determination for contracts | MANDT |
| TVVD | VBEGREG | TVRG | Rule table for indirect date determination for contracts | REGEL |
| TVVD | VENDREG | TVRG | Rule table for indirect date determination for contracts | MANDT |
| TVVD | VENDREG | TVRG | Rule table for indirect date determination for contracts | REGEL |
| TVVD | VKUESCH | TVKS | Cancellation procedures for contracts | MANDT |
| TVVD | VKUESCH | TVKS | Cancellation procedures for contracts | VKUESCH |
| TVVD | VLAUFK | TVLZ | Validity Period Category | VLAUFK |