SAP Table TVVD
Contract Data Profile
TVVD (Contract Data Profile) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TVVD to other SAP tables.
TVVD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| VPROF | Profile with default values for contract data | VPROF | CHAR | 4 | 0 | |||
| VLAUFK | Validity period category of contract | VLAUK_VEDA | TVLZ | CHAR | 2 | 0 | ||
| VKUESCH | Assignment cancellation procedure/cancellation rule | VKUES_VEDA | TVKS | CHAR | 4 | 0 | ||
| VAKTSCH | Action at end of contract | VASCH_VEDA | TVAS | CHAR | 4 | 0 | ||
| VBEGREG | Rule for calculating contract start date | VBREG_VEDA | TVRG | CHAR | 2 | 0 | ||
| VENDREG | Rule for contract end date | RGVTE | TVRG | CHAR | 2 | 0 | ||
| VASDR | Date rule for action | VASDR | TVRG | CHAR | 2 | 0 | ||
| ISMSTARTDATEREG | IS-M: Rule for Start of Billing Period | ISMSTARTDATEREG | TVRG | CHAR | 2 | 0 | ||
TVVD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TVVD | ISMSTARTDATEREG | TVVD | MANDT | TVRG | Rule table for indirect date determination for contracts | MANDT |
| TVVD | ISMSTARTDATEREG | TVVD | ISMSTARTDATEREG | TVRG | Rule table for indirect date determination for contracts | REGEL |
| TVVD | MANDT | TVVD | MANDT | T000 | Clients | MANDT |
| TVVD | VAKTSCH | TVVD | VAKTSCH | TVAS | Action Procedure for End of Contract | AKTVT |
| TVVD | VAKTSCH | TVVD | MANDT | TVAS | Action Procedure for End of Contract | MANDT |
| TVVD | VASDR | TVVD | MANDT | TVRG | Rule table for indirect date determination for contracts | MANDT |
| TVVD | VASDR | TVVD | VASDR | TVRG | Rule table for indirect date determination for contracts | REGEL |
| TVVD | VBEGREG | TVVD | VBEGREG | TVRG | Rule table for indirect date determination for contracts | REGEL |
| TVVD | VBEGREG | TVVD | MANDT | TVRG | Rule table for indirect date determination for contracts | MANDT |
| TVVD | VENDREG | TVVD | MANDT | TVRG | Rule table for indirect date determination for contracts | MANDT |
| TVVD | VENDREG | TVVD | VENDREG | TVRG | Rule table for indirect date determination for contracts | REGEL |
| TVVD | VKUESCH | TVVD | MANDT | TVKS | Cancellation procedures for contracts | MANDT |
| TVVD | VKUESCH | TVVD | VKUESCH | TVKS | Cancellation procedures for contracts | VKUESCH |
| TVVD | VLAUFK | TVVD | MANDT | TVLZ | Validity Period Category | MANDT |
| TVVD | VLAUFK | TVVD | VLAUFK | TVLZ | Validity Period Category | VLAUFK |
