SAP Table
DFKK_VT_H CT: Header Data of Provider Contract
SAP table DFKK_VT_H has 2 primary key fields being MANDT,VTKEY.
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
DFKK_VT_H columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||
| KeyVTKEY | Identification of a Provider Contract | CHAR | 20 | 0 | VTKEY_KK | ||||||||
| GPART | Business Partner Number | CHAR | 10 | 0 | BUT000 | GPART_KK | |||||||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||||||||
| ERTIM | Time at which the object was created | TIMS | 6 | 0 | ERTIM_KK | ||||||||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||||||||
| LOEVM | Flag Provider Contract for Deletion | CHAR | 1 | 0 | VTLOEVM_KK | ||||||||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||
| AETIM | Last Changed At | TIMS | 6 | 0 | AETIM2_KK | ||||||||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||||
| VTBEZ | Name of Contract | CHAR | 35 | 0 | VTBEZ_VT_KK | ||||||||
| VTALT | Technical Key of Provider Contract in External System | CHAR | 20 | 0 | VTALT_KK | ||||||||
| VTBEG | Contract Start | DEC | 15 | 0 | VTBEG_KK | ||||||||
| VTBEG_LOCL | Local Time in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TLOCL_KK | ||||||||
| VTEND | Contract End Date | DEC | 15 | 0 | VTEND_KK | ||||||||
| VTEND_LOCL | Local Time in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TLOCL_KK | ||||||||
| BEGRU | Authorization Group | CHAR | 4 | 0 | BEGRU | ||||||||
| BUKRS | Company Code for Authorization Check | CHAR | 4 | 0 | BUKRS_AUTH_KK | ||||||||
| TZONE | Time Zone of Provider Contract | CHAR | 6 | 0 | TTZZ | TIZON_KK | |||||||
| VTCAT | Contract Category | CHAR | 1 | 0 | VTCAT_KK | ||||||||
|
|||||||||||||
| MIGST | Migration Status | CHAR | 1 | 0 | MIGST_KK | ||||||||
|
|||||||||||||
| VTCHR | Contract Specification | CHAR | 1 | 0 | VTCHR_KK | ||||||||
|
|||||||||||||
| STATU | Status of Provider Contract | CHAR | 1 | 0 | STATUS_VT_KK | ||||||||
|
|||||||||||||
| ASUAC | Alternative Subscriber Account in SAP CC | CHAR | 30 | 0 | ASUAC_KK | ||||||||
| SENDER | Provider Contract Sender | CHAR | 3 | 0 | TFK_VT_SENDER | SENDER_KK | |||||||
| VTVRS | Subscription Version | NUMC | 6 | 0 | VTVRS_KK | ||||||||
/ Relationships
DFKK_VT_H foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| DFKK_VT_H | GPART | BUT000 | BP: General data I | PARTNER |
| DFKK_VT_H | SENDER | TFK_VT_SENDER | Provider Contract Sender | SENDER |
| DFKK_VT_H | TZONE | TTZZ | Time zones | TZONE |