SAP VTBKORES Correspondence Data Table
Overview
VTBKORES is a standard SAP S/4HANA table that stores Correspondence Data data. There are total 52 fields in the VTBKORES table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBKORES belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 appl. development for Treasury money,forex,forward gen (FTA).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBKORES to other SAP tables and standard CDS views available based on VTBKORES table in S/4HANA 2020.
Techincal Settings of VTBKORES
Below are technical details of the table VTBKORES
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBKORES Fields
The following table gives you an overview of the fields available in VTBKORES
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RFHA | Financial Transaction | TB_RFHA | VTBFHA | CHAR | 13 |
| RFHAZU | Transaction Activity | TB_RFHAZU | NUMC | 5 | |
| RORDER | Order key | RORDER | CHAR | 12 | |
| DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | |
| TCTRIM | Entry Time | TB_TCRTIM | TIMS | 6 | |
| RLFDNR | Sequential No. VRBKORES Data Record per Activity (Key Field) | TB_RLFDNR | NUMC | 2 | |
| SPLAN | Planned Record | TB_SPLAN | CHAR | 1 | |
| SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | * | NUMC | 2 |
| SFUNKTL | Latest function used in editing activity | TB_SFUNKTL | * | CHAR | 4 |
| CORTYP | Correspondence Type | TB_CORTYP | AT81 | CHAR | 3 |
| SPRINT | Correspondence Medium: Print | TB_SPRINT | CHAR | 1 | |
| SFAX | Correspondence Medium: Fax | TB_SFAX | CHAR | 1 | |
| SSWIFT | Correspondence Medium: SWIFT File | TB_SSWIFT | CHAR | 1 | |
| SIDOC | Correspondence Medium: IDoc | TB_SIDOC | CHAR | 1 | |
| SEMAIL | Correspondence Medium: Internet Mail | TB_SEMAIL | CHAR | 1 | |
| DCIDAT | Date Scheduled | TB_DCIDAT | DATS | 8 | |
| TCIDAT | Time Scheduled | TB_TCIDAT | TIMS | 6 | |
| JSENDEN | Send correspondence | TB_JSENDEN | CHAR | 1 | |
| DEXDAT | Execution Date | TB_DEXDAT | DATS | 8 | |
| TEXDAT | Execution Time | TB_TEXDAT | TIMS | 6 | |
| UEXNAM | User | TB_UEXNAM | CHAR | 12 | |
| TDSPOOLID | Spool request number | RSPOID | INT4 | 10 | |
| TDOBJ_NO | Object: Number from ID | SO_OBJ_NO | * | CHAR | 12 |
| SRECONFIRM | Counterconfirmation | TB_RECONF | NUMC | 1 | |
| DREDAT | Counterconfirmation Date | TB_DREDAT | DATS | 8 | |
| TREDAT | Counterconfirmation Time | TB_TREDAT | TIMS | 6 | |
| URENAM | Counterconfirmation Executed by (User Responsible) | TB_URENAM | CHAR | 12 | |
| FORMULAR | Form name | TDFORM | CHAR | 16 | |
| SWIFT_DAT | Format for SWIFT Files | TB_SWI_DAT | CHAR | 8 | |
| KONTRH | Business Partner Number | TB_KUNNR_NEW | * | CHAR | 10 |
| ROLETYP | Business Partner Role | TB_CORR_ROLETYP | * | CHAR | 6 |
| URCNAM | Recipient | TB_URCNAM | CHAR | 12 | |
| CORR_AD | Alternative Address for Correspondence | TB_CORR_A | * | CHAR | 10 |
| CRUSER | Entered By | TB_CRUSER | CHAR | 12 | |
| UPUSER | Last Changed By | TB_UPUSER | CHAR | 12 | |
| DUPDAT | Changed On | TB_DUPDAT | DATS | 8 | |
| TUPTIM | Time Changed | TB_TUPTIM | TIMS | 6 | |
| JAUTOMAT | Entry generated automatically when correspondence is created | TB_JAUTOM | CHAR | 1 | |
| CORAUT | Generate Correspondence Automatically | TB_CORAUT | CHAR | 1 | |
| SSTATUS | Status Relevance Indicator | TB_STCORR | CHAR | 1 | |
| SSTATCHG | Indicator: Status for Outgoing Confirmation Modified | TB_STCHNG | CHAR | 1 | |
| SREPEAT | Repeat Correspondence? | TB_REPEAT | CHAR | 1 | |
| LAUFD | SWIFT: Date of Confirmation Run | LAUFDT | DATS | 8 | |
| LAUFI | Additional Identification | LAUFI | CHAR | 6 | |
| DTKEY | Additional field for the TemSe key fields | TDTKEY_D | CHAR | 16 | |
| LFDNR | Sequence Number | TLFDNU | NUMC | 3 | |
| SWIFTREF | Field 20 (with day ID) in SWIFT format: Transaction ref.no. | MT3XX_20 | CHAR | 20 | |
| DOCNUM | Number of IDoc (Outgoing) | TB_EDI_DOCNUM_OUT | NUMC | 16 | |
| DOCNUM_IN | Number of IDoc (Incoming) | TB_EDI_DOCNUM_IN | NUMC | 16 | |
| SFORMCT | Form Category | TB_FRMCAT | NUMC | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTBKORES
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBKORES | BUKRS | 1: CN | T001 |
| VTBKORES | CORTYP | 1: CN | AT81 |
| VTBKORES | MANDT | 1: CN | T000 |
| VTBKORES | RFHA | 1: CN | VTBFHA |