SAP ABAP Table VTBKORES (Correspondence Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTA (Package) R/3 appl. development for Treasury money,forex,forward gen

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTBKORES	Table Relationship Diagram
Short Description	Correspondence Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RFHA	☑	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
4	RFHAZU	☑	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
5	RORDER	☑	RORDER	RORDER	CHAR	12	0	Order key
6	DCRDAT	☑	TB_DCRDAT	DATUM	DATS	8	0	Entered On
7	TCTRIM	☑	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
8	RLFDNR	☑	TB_RLFDNR	T_LFDNR2	NUMC	2	0	Sequential No. VRBKORES Data Record per Activity (Key Field)
9	SPLAN	☐	TB_SPLAN	XFELD	CHAR	1	0	Planned record
10	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
11	SFUNKTL	☐	TB_SFUNKTL	T_FUNKTION	CHAR	4	0	Latest function used in editing activity	*
12	CORTYP	☐	TB_CORTYP	T_CORTYP	CHAR	3	0	Correspondence type	AT81
13	.INCLUDE	☐				0	0	Correspondence Media
14	SPRINT	☐	TB_SPRINT	XFELD	CHAR	1	0	Correspondence medium: print
15	SFAX	☐	TB_SFAX	XFELD	CHAR	1	0	Correspondence medium: fax
16	SSWIFT	☐	TB_SSWIFT	XFELD	CHAR	1	0	Correspondence medium: SWIFT file
17	SIDOC	☐	TB_SIDOC	XFELD	CHAR	1	0	Correspondence medium: IDoc
18	SEMAIL	☐	TB_SEMAIL	XFELD	CHAR	1	0	Correspondence Medium: Internet Mail
19	DCIDAT	☐	TB_DCIDAT	DATUM	DATS	8	0	Date scheduled
20	TCIDAT	☐	TB_TCIDAT	UZEIT	TIMS	6	0	Dispatch time
21	JSENDEN	☐	TB_JSENDEN	XFELD	CHAR	1	0	Send correspondence
22	DEXDAT	☐	TB_DEXDAT	DATUM	DATS	8	0	Execution date
23	TEXDAT	☐	TB_TEXDAT	UZEIT	TIMS	6	0	Execution time
24	UEXNAM	☐	TB_UEXNAM	USNAM	CHAR	12	0	User
25	TDSPOOLID	☐	RSPOID	RSPOID	INT4	10	0	Spool request number
26	TDOBJ_NO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
27	SRECONFIRM	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
28	DREDAT	☐	TB_DREDAT	DATUM	DATS	8	0	Counterconfirmation Date
29	TREDAT	☐	TB_TREDAT	UZEIT	TIMS	6	0	Counterconfirmation time
30	URENAM	☐	TB_URENAM	USNAM	CHAR	12	0	Counterconfirmation Executed by (User Responsible)
31	FORMULAR	☐	TDFORM	TDFORM	CHAR	16	0	Form name
32	SWIFT_DAT	☐	TB_SWI_DAT	TB_SWI_DAT	CHAR	8	0	Format for SWIFT files
33	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
34	ROLETYP	☐	TB_CORR_ROLETYP	BU_ROLE	CHAR	6	0	Business Partner Role	*
35	URCNAM	☐	TB_URCNAM	UNAME	CHAR	12	0	Recipient
36	CORR_AD	☐	TB_CORR_A	BU_ADRKIND	CHAR	10	0	Alternative Address for Correspondence	*
37	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
38	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
39	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
40	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
41	JAUTOMAT	☐	TB_JAUTOM	XFELD	CHAR	1	0	Entry generated automatically when correspondence is created
42	CORAUT	☐	TB_CORAUT	XFELD	CHAR	1	0	Generate correspondence automatically
43	SSTATUS	☐	TB_STCORR	XFELD	CHAR	1	0	Status relevance indicator
44	SSTATCHG	☐	TB_STCHNG	XFELD	CHAR	1	0	'Status for outgoing confirmation' indicator modified
45	SREPEAT	☐	TB_REPEAT	XFELD	CHAR	1	0	Repeat correspondence?
46	LAUFD	☐	LAUFDT	DATUM	DATS	8	0	SWIFT: Date of Confirmation Run
47	LAUFI	☐	LAUFI	LAUFI	CHAR	6	0	Additional Identification
48	DTKEY	☐	TDTKEY_D	TEXT16	CHAR	16	0	Additional field for the TemSe key fields
49	LFDNR	☐	TLFDNU	NUMC3	NUMC	3	0	Sequence Number
50	SWIFTREF	☐	MT3XX_20	CHAR20	CHAR	20	0	Field 20 (with day ID) in SWIFT format: Transaction ref.no.
51	DOCNUM	☐	TB_EDI_DOCNUM_OUT	EDI_DOCNUM	NUMC	16	0	Number of IDoc (Outgoing)
52	DOCNUM_IN	☐	TB_EDI_DOCNUM_IN	EDI_DOCNUM	NUMC	16	0	Number of IDoc (Incoming)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTBKORES	BUKRS	T001	BUKRS	KEY	1	CN
2	VTBKORES	CORTYP	AT81	CORTYP	REF	1	CN
3	VTBKORES	MANDT	T000	MANDT	KEY	1	CN
4	VTBKORES	RFHA	VTBFHA	RFHA	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in