1. Home
  2. Resources
  3. SAP Tables
  4. VTBKORES_TEXT - Correspondence: VTBKORES + Text and Editing Fields

SAP Table VTBKORES_TEXT

Correspondence: VTBKORES + Text and Editing Fields

VTBKORES_TEXT (Correspondence: VTBKORES + Text and Editing Fields) 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 VTBKORES_TEXT to other SAP tables.

VTBKORES_TEXT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RFHA Financial Transaction TB_RFHA VTBFHA CHAR 13 0
RFHAZU Transaction activity TB_RFHAZU NUMC 5 0
RORDER Order key RORDER CHAR 12 0
DCRDAT Entered On TB_DCRDAT DATS 8 0
TCTRIM Entry Time TB_TCRTIM TIMS 6 0
RLFDNR Sequential No. VRBKORES Data Record per Activity (Key Field) TB_RLFDNR NUMC 2 0
SPLAN Planned record TB_SPLAN CHAR 1 0
X Yes
NULL No
SFGZUSTT Transaction Activity Category TB_SFGZUTY NUMC 2 0
SFUNKTL Latest function used in editing activity TB_SFUNKTL CHAR 4 0
CORTYP Correspondence type TB_CORTYP AT81 CHAR 3 0
SPRINT Correspondence medium: print TB_SPRINT CHAR 1 0
X Yes
NULL No
SFAX Correspondence medium: fax TB_SFAX CHAR 1 0
X Yes
NULL No
SSWIFT Correspondence medium: SWIFT file TB_SSWIFT CHAR 1 0
X Yes
NULL No
SIDOC Correspondence medium: IDoc TB_SIDOC CHAR 1 0
X Yes
NULL No
SEMAIL Correspondence Medium: Internet Mail TB_SEMAIL CHAR 1 0
X Yes
NULL No
DCIDAT Date scheduled TB_DCIDAT DATS 8 0
TCIDAT Dispatch time TB_TCIDAT TIMS 6 0
JSENDEN Send correspondence TB_JSENDEN CHAR 1 0
X Yes
NULL No
DEXDAT Execution date TB_DEXDAT DATS 8 0
TEXDAT Execution time TB_TEXDAT TIMS 6 0
UEXNAM User TB_UEXNAM CHAR 12 0
TDSPOOLID Spool request number RSPOID INT4 10 0
TDOBJ_NO Object: Number from ID SO_OBJ_NO CHAR 12 0
SRECONFIRM Counterconfirmation TB_RECONF NUMC 1 0
0 Not Required
1 Required
2 Reminder Sent
3 Matched
4 Incorrect
5 Cannot Be Assigned
DREDAT Counterconfirmation Date TB_DREDAT DATS 8 0
TREDAT Counterconfirmation time TB_TREDAT TIMS 6 0
URENAM Counterconfirmation Executed by (User Responsible) TB_URENAM CHAR 12 0
FORMULAR Form Name TDFORM CHAR 16 0
SWIFT_DAT Format for SWIFT files TB_SWI_DAT CHAR 8 0
MT300 MT300 SWIFT format
MT320 MT320 SWIFT format
KONTRH Business Partner Number TB_KUNNR_NEW CHAR 10 0
ROLETYP Business Partner Role TB_CORR_ROLETYP CHAR 6 0
URCNAM Recipient TB_URCNAM CHAR 12 0
CORR_AD Alternative Address for Correspondence TB_CORR_A CHAR 10 0
CRUSER Entered by TB_CRUSER CHAR 12 0
UPUSER Last Changed by TB_UPUSER CHAR 12 0
DUPDAT Changed on TB_DUPDAT DATS 8 0
TUPTIM Time changed TB_TUPTIM TIMS 6 0
JAUTOMAT Entry generated automatically when correspondence is created TB_JAUTOM CHAR 1 0
X Yes
NULL No
CORAUT Generate correspondence automatically TB_CORAUT CHAR 1 0
X Yes
NULL No
SSTATUS Status relevance indicator TB_STCORR CHAR 1 0
X Yes
NULL No
SSTATCHG 'Status for outgoing confirmation' indicator modified TB_STCHNG CHAR 1 0
X Yes
NULL No
SREPEAT Repeat correspondence? TB_REPEAT CHAR 1 0
X Yes
NULL No
LAUFD SWIFT: Date of Confirmation Run LAUFDT DATS 8 0
LAUFI Additional Identification LAUFI CHAR 6 0
DTKEY Additional field for the TemSe key fields TDTKEY_D CHAR 16 0
LFDNR Sequence Number TLFDNU NUMC 3 0
SWIFTREF Field 20 (with day ID) in SWIFT format: Transaction ref.no. MT3XX_20 CHAR 20 0
DOCNUM Number of IDoc (Outgoing) TB_EDI_DOCNUM_OUT NUMC 16 0
DOCNUM_IN Number of IDoc (Incoming) TB_EDI_DOCNUM_IN NUMC 16 0
SFORMCT Form Category TB_FRMCAT NUMC 1 0
0 SAPscript-Based
1 PDF-Based
SANLF Product Category SANLF NUMC 3 0
SGSART Product Type VVSART CHAR 3 0
RANL Security ID Number VVRANLW CHAR 13 0
RLDEPO Securities Account VRLDEPO CHAR 10 0
XSGSART Product description TB_XSGSART CHAR 30 0
SFGTYP Transaction Category TB_SFGTYP NUMC 3 0
SFHAART Financial Transaction Type TB_SFHAART CHAR 3 0
DVTRAB Contract Conclusion Date TB_DVTRAB DATS 8 0
TVTRAB Time of contract conclusion TB_TVTRAB TIMS 6 0
XFATEXT Name of Transaction Type TB_FATEXT CHAR 30 0
XVTYP Name of activity category TB_XTTEXT CHAR 30 0
XKONTRH Name and address of business partner TB_XKONTRH CHAR 80 0
XRECONFIRM Counterconfirmation TB_XRECONFIRM CHAR 60 0
SLIGHTS Processing Status for Correspondence Data Records TB_STATE_ICON CHAR 4 0
SLIGHTS_SORT Sort field for processing status (icon) TB_STATE_SORTFIELD NUMC 4 0
XSLIGHTS Description of next processing step TB_STATE_TEXT CHAR 60 0
XCORR_MEDIUM Correspondence medium TB_XCORR_MEDIUM CHAR 60 0
IDOC_STATUS Status of IDoc EDI_STATUS CHAR 2 0
IDOC_STATUS_ICON Status Grouping EDI_STGR CHAR 5 0
IDOC_STATUS_DESCRP Short description of object EDI_TEXT60 CHAR 60 0
ICON_CHECKED Processing indicator TB_ICON_CHECKED CHAR 4 0
MARKFIELD Checkbox XFELD CHAR 1 0
X Yes
NULL No
XFORMCT UI: Form Category Text TB_XFORMCT CHAR 60 0

VTBKORES_TEXT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTBKORES_TEXT BUKRS VTBKORES_TEXT BUKRS T001 Company Codes BUKRS
VTBKORES_TEXT BUKRS VTBKORES_TEXT MANDT T001 Company Codes MANDT
VTBKORES_TEXT CORTYP VTBKORES_TEXT MANDT AT81 Correspondence type MANDT
VTBKORES_TEXT CORTYP VTBKORES_TEXT CORTYP AT81 Correspondence type CORTYP
VTBKORES_TEXT MANDT VTBKORES_TEXT MANDT T000 Clients MANDT
VTBKORES_TEXT RFHA VTBKORES_TEXT MANDT VTBFHA Transaction MANDT
VTBKORES_TEXT RFHA VTBKORES_TEXT BUKRS VTBFHA Transaction BUKRS
VTBKORES_TEXT RFHA VTBKORES_TEXT RFHA VTBFHA Transaction RFHA