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
⤷ 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 |