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'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 | T000 | MANDT | |
| VPROF | 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 |
TVVD foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TVVD | VAKTSCH | TVAS | Action Procedure for End of Contract | MANDT |
| 0 TVVD | VAKTSCH | TVAS | Action Procedure for End of Contract | AKTVT |
| 1 TVVD | VASDR | TVRG | Rule table for indirect date determination for contracts | MANDT |
| 1 TVVD | VASDR | TVRG | Rule table for indirect date determination for contracts | REGEL |
| 0 TVVD | VBEGREG | TVRG | Rule table for indirect date determination for contracts | MANDT |
| 0 TVVD | VBEGREG | TVRG | Rule table for indirect date determination for contracts | REGEL |
| 1 TVVD | VENDREG | TVRG | Rule table for indirect date determination for contracts | MANDT |
| 1 TVVD | VENDREG | TVRG | Rule table for indirect date determination for contracts | REGEL |
| 0 TVVD | VKUESCH | TVKS | Cancellation procedures for contracts | MANDT |
| 0 TVVD | VKUESCH | TVKS | Cancellation procedures for contracts | VKUESCH |
| 1 TVVD | VLAUFK | TVLZ | Validity Period Category | VLAUFK |