SAP ABAP Table VTBKORES_TEXT (Correspondence: VTBKORES + Text and Editing Fields)

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	INTTAB	Structure
Structure	VTBKORES_TEXT	Table Relationship Diagram
Short Description	Correspondence: VTBKORES + Text and Editing Fields

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Correspondence Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
5	RFHAZU	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
6	RORDER	☐	RORDER	RORDER	CHAR	12	0	Order key
7	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
8	TCTRIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
9	RLFDNR	☐	TB_RLFDNR	T_LFDNR2	NUMC	2	0	Sequential No. VRBKORES Data Record per Activity (Key Field)
10	SPLAN	☐	TB_SPLAN	XFELD	CHAR	1	0	Planned record
11	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
12	SFUNKTL	☐	TB_SFUNKTL	T_FUNKTION	CHAR	4	0	Latest function used in editing activity	*
13	CORTYP	☐	TB_CORTYP	T_CORTYP	CHAR	3	0	Correspondence type	AT81
14	.INCLUDE	☐				0	0	Correspondence Media
15	SPRINT	☐	TB_SPRINT	XFELD	CHAR	1	0	Correspondence medium: print
16	SFAX	☐	TB_SFAX	XFELD	CHAR	1	0	Correspondence medium: fax
17	SSWIFT	☐	TB_SSWIFT	XFELD	CHAR	1	0	Correspondence medium: SWIFT file
18	SIDOC	☐	TB_SIDOC	XFELD	CHAR	1	0	Correspondence medium: IDoc
19	SEMAIL	☐	TB_SEMAIL	XFELD	CHAR	1	0	Correspondence Medium: Internet Mail
20	DCIDAT	☐	TB_DCIDAT	DATUM	DATS	8	0	Date scheduled
21	TCIDAT	☐	TB_TCIDAT	UZEIT	TIMS	6	0	Dispatch time
22	JSENDEN	☐	TB_JSENDEN	XFELD	CHAR	1	0	Send correspondence
23	DEXDAT	☐	TB_DEXDAT	DATUM	DATS	8	0	Execution date
24	TEXDAT	☐	TB_TEXDAT	UZEIT	TIMS	6	0	Execution time
25	UEXNAM	☐	TB_UEXNAM	USNAM	CHAR	12	0	User
26	TDSPOOLID	☐	RSPOID	RSPOID	INT4	10	0	Spool request number
27	TDOBJ_NO	☐	SO_OBJ_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
28	SRECONFIRM	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
29	DREDAT	☐	TB_DREDAT	DATUM	DATS	8	0	Counterconfirmation Date
30	TREDAT	☐	TB_TREDAT	UZEIT	TIMS	6	0	Counterconfirmation time
31	URENAM	☐	TB_URENAM	USNAM	CHAR	12	0	Counterconfirmation Executed by (User Responsible)
32	FORMULAR	☐	TDFORM	TDFORM	CHAR	16	0	Form name
33	SWIFT_DAT	☐	TB_SWI_DAT	TB_SWI_DAT	CHAR	8	0	Format for SWIFT files
34	KONTRH	☐	TB_KUNNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
35	ROLETYP	☐	TB_CORR_ROLETYP	BU_ROLE	CHAR	6	0	Business Partner Role	*
36	URCNAM	☐	TB_URCNAM	UNAME	CHAR	12	0	Recipient
37	CORR_AD	☐	TB_CORR_A	BU_ADRKIND	CHAR	10	0	Alternative Address for Correspondence	*
38	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
39	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
40	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
41	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
42	JAUTOMAT	☐	TB_JAUTOM	XFELD	CHAR	1	0	Entry generated automatically when correspondence is created
43	CORAUT	☐	TB_CORAUT	XFELD	CHAR	1	0	Generate correspondence automatically
44	SSTATUS	☐	TB_STCORR	XFELD	CHAR	1	0	Status relevance indicator
45	SSTATCHG	☐	TB_STCHNG	XFELD	CHAR	1	0	'Status for outgoing confirmation' indicator modified
46	SREPEAT	☐	TB_REPEAT	XFELD	CHAR	1	0	Repeat correspondence?
47	LAUFD	☐	LAUFDT	DATUM	DATS	8	0	SWIFT: Date of Confirmation Run
48	LAUFI	☐	LAUFI	LAUFI	CHAR	6	0	Additional Identification
49	DTKEY	☐	TDTKEY_D	TEXT16	CHAR	16	0	Additional field for the TemSe key fields
50	LFDNR	☐	TLFDNU	NUMC3	NUMC	3	0	Sequence Number
51	SWIFTREF	☐	MT3XX_20	CHAR20	CHAR	20	0	Field 20 (with day ID) in SWIFT format: Transaction ref.no.
52	DOCNUM	☐	TB_EDI_DOCNUM_OUT	EDI_DOCNUM	NUMC	16	0	Number of IDoc (Outgoing)
53	DOCNUM_IN	☐	TB_EDI_DOCNUM_IN	EDI_DOCNUM	NUMC	16	0	Number of IDoc (Incoming)
54	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
55	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
56	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
57	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
58	XSGSART	☐	TB_XSGSART	T_XTEXT30	CHAR	30	0	Product description
59	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	*
60	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
61	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
62	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
63	XFATEXT	☐	TB_FATEXT	T_XTEXT30	CHAR	30	0	Name of Transaction Type
64	XVTYP	☐	TB_XTTEXT	TEXT30	CHAR	30	0	Name of activity category
65	XKONTRH	☐	TB_XKONTRH	TEXT80	CHAR	80	0	Name and address of business partner
66	XRECONFIRM	☐	TB_XRECONFIRM	TEXT60	CHAR	60	0	Counterconfirmation
67	SLIGHTS	☐	TB_STATE_ICON	ICON	CHAR	4	0	Processing Status for Correspondence Data Records	*
68	SLIGHTS_SORT	☐	TB_STATE_SORTFIELD	NUMC4	NUMC	4	0	Sort field for processing status (icon)
69	XSLIGHTS	☐	TB_STATE_TEXT	DDTEXT	CHAR	60	0	Description of next processing step
70	XCORR_MEDIUM	☐	TB_XCORR_MEDIUM	DDTEXT	CHAR	60	0	Correspondence medium
71	IDOC_STATUS	☐	EDI_STATUS	EDI_STATUS	CHAR	2	0	Status of IDoc	*
72	IDOC_STATUS_ICON	☐	EDI_STGR	CHAR5	CHAR	5	0	Status Grouping
73	IDOC_STATUS_DESCRP	☐	EDI_TEXT60	TEXT60	CHAR	60	0	Short description of object
74	ICON_CHECKED	☐	TB_ICON_CHECKED	CHAR4	CHAR	4	0	Processing indicator
75	MARKFIELD	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in