SAP ABAP Table RECP_OI_DOC_CA_ALL (General Document Data)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-CP (Application Component) Correspondence
⤷ RE_CP_OI (Package) RE: Office Integration (Correspondence with OfficeIntegr.)
⤷ RE-FX-CP (Application Component) Correspondence
⤷ RE_CP_OI (Package) RE: Office Integration (Correspondence with OfficeIntegr.)
Basic Data
Table Category | INTTAB | Structure |
Structure | RECP_OI_DOC_CA_ALL | Table Relationship Diagram |
Short Description | General Document Data |
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 | General Output Parameters | |||||
2 | TEMPLATE | RECPOITEMPLATE | TEXT64 | CHAR | 64 | 0 | Template for Printing with Office Application | ||
3 | LANGU | RECPOILANGU | SPRAS | LANG | 1 | 0 | Language for Document Creation | * | |
4 | SELDATE | RECPOISELDATE | RECADATE | DATS | 8 | 0 | Key Date for Data Selection | ||
5 | PRNDATE | RECPOIPRNDATE | RECADATE | DATS | 8 | 0 | Print Date | ||
6 | .INCLUDE | 0 | 0 | General Data for the Business Object | |||||
7 | IDENTKEY | RECAIDENTKEY | CHAR45 | CHAR | 45 | 0 | ID Part Key, for example "1000/123" | ||
8 | IDENT | RECAIDENT | CHAR50 | CHAR | 50 | 0 | Complete Object Identification, for Example BE 1000/123 | ||
9 | XIDENT | RECAXIDENT | TEXT80 | CHAR | 80 | 0 | Object ID, for Example, Business Entity 1000/123 | ||
10 | XOBJTYPE | RECAXOBJTYPE | CHAR3 | CHAR | 3 | 0 | Partial Object Type ID, for example "BE" | ||
11 | XLOBJTYPE | RECAXLOBJTYPE | TEXT20 | CHAR | 20 | 0 | Object Type Name (20) | ||
12 | BUSTYPE | SWO_OBJTYP | OJ_NAME | CHAR | 10 | 0 | Object Type | * | |
13 | BUSKEY | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
14 | .INCLUDE | 0 | 0 | Sender (Company Code Data) | |||||
15 | .INCLU-_SE | 0 | 0 | Company Code Data | |||||
16 | BUKRS_SE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
17 | BUTXT_SE | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
18 | ORT01_SE | ORT01 | TEXT25 | CHAR | 25 | 0 | City | ||
19 | LAND1_SE | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
20 | WAERS_SE | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
21 | SPRAS_SE | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
22 | KTOPL_SE | KTOPL | KTOPL | CHAR | 4 | 0 | Chart of Accounts | * | |
23 | WAABW_SE | WAABW_001 | NUM02 | NUMC | 2 | 0 | Maximum exchange rate deviation in percent | ||
24 | PERIV_SE | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
25 | KOKFI_SE | KOKFI | KOKFI | CHAR | 1 | 0 | Allocation Indicator | ||
26 | RCOMP_SE | RCOMP_D | RCOMP | CHAR | 6 | 0 | Company | * | |
27 | ADRNR_SE | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
28 | STCEG_SE | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
29 | FIKRS_SE | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
30 | TXJCD_SE | TXJCD_NSTX | TXJCD | CHAR | 15 | 0 | Jurisdiction for tax calculation - tax jurisdiction code | * | |
31 | .INCLUDE | 0 | 0 | Recipient | |||||
32 | .INCLU-_RC | 0 | 0 | Business Partner: General Data | |||||
33 | PARTNER_RC | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
34 | PARTN_CAT_RC | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
35 | SEARCHTERM1_RC | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
36 | SEARCHTERM2_RC | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
37 | FIRSTNAME_RC | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
38 | LASTNAME_RC | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
39 | NAME1_RC | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
40 | NAME2_RC | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
41 | NAME3_RC | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
42 | NAME4_RC | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
43 | NAMEGROUP1_RC | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
44 | NAMEGROUP2_RC | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
45 | XNAME_RC | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
46 | XPARTNER_RC | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
47 | XSALUTATION_RC | REBPXSALUTATION | CHAR80 | CHAR | 80 | 0 | Salutation for Business Partner | ||
48 | XADDRESS_RC | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
49 | LINE0_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
50 | LINE1_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
51 | LINE2_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
52 | LINE3_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
53 | LINE4_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
54 | LINE5_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
55 | LINE6_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
56 | LINE7_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
57 | LINE8_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
58 | LINE9_RC | LINES | LINES | CHAR | 80 | 0 | Address line | ||
59 | ADDRCATE_RC | AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
60 | ADDRNUMBER_RC | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
61 | PERSNUMBER_RC | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
62 | SMTP_ADDR_RC | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
63 | TEL_COUNTRY_RC | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
64 | TEL_NUMBER_RC | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
65 | TEL_EXTENS_RC | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
66 | TEL_NUMBER_LONG_RC | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
67 | FAX_COUNTRY_RC | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
68 | FAX_NUMBER_RC | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
69 | FAX_EXTENS_RC | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
70 | FAX_NUMBER_LONG_RC | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
71 | INTRENO_RC | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
72 | ROLE_RC | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | * | |
73 | XROLE_RC | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
74 | SUBROLE_RC | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
75 | XSUBROLE_RC | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
76 | ROLECATE_RC | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
77 | APPL_RC | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | * | |
78 | VALIDFROM_RC | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
79 | VALIDTO_RC | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
80 | ADDRTYPE_RC | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * | |
81 | .INCLUDE | 0 | 0 | Clerk | |||||
82 | .INCLU-_CL | 0 | 0 | Business Partner: General Data | |||||
83 | PARTNER_CL | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
84 | PARTN_CAT_CL | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
85 | SEARCHTERM1_CL | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
86 | SEARCHTERM2_CL | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
87 | FIRSTNAME_CL | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
88 | LASTNAME_CL | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
89 | NAME1_CL | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
90 | NAME2_CL | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
91 | NAME3_CL | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
92 | NAME4_CL | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
93 | NAMEGROUP1_CL | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
94 | NAMEGROUP2_CL | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
95 | XNAME_CL | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
96 | XPARTNER_CL | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
97 | XSALUTATION_CL | REBPXSALUTATION | CHAR80 | CHAR | 80 | 0 | Salutation for Business Partner | ||
98 | XADDRESS_CL | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
99 | LINE0_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
100 | LINE1_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
101 | LINE2_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
102 | LINE3_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
103 | LINE4_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
104 | LINE5_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
105 | LINE6_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
106 | LINE7_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
107 | LINE8_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
108 | LINE9_CL | LINES | LINES | CHAR | 80 | 0 | Address line | ||
109 | ADDRCATE_CL | AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
110 | ADDRNUMBER_CL | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
111 | PERSNUMBER_CL | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
112 | SMTP_ADDR_CL | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
113 | TEL_COUNTRY_CL | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
114 | TEL_NUMBER_CL | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
115 | TEL_EXTENS_CL | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
116 | TEL_NUMBER_LONG_CL | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
117 | FAX_COUNTRY_CL | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
118 | FAX_NUMBER_CL | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
119 | FAX_EXTENS_CL | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
120 | FAX_NUMBER_LONG_CL | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
121 | INTRENO_CL | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
122 | ROLE_CL | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | * | |
123 | XROLE_CL | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
124 | SUBROLE_CL | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
125 | XSUBROLE_CL | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
126 | ROLECATE_CL | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
127 | APPL_CL | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | * | |
128 | VALIDFROM_CL | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
129 | VALIDTO_CL | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
130 | ADDRTYPE_CL | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * | |
131 | .INCLUDE | 0 | 0 | Further Partner 1 | |||||
132 | .INCLU-_P1 | 0 | 0 | Business Partner: General Data | |||||
133 | PARTNER_P1 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
134 | PARTN_CAT_P1 | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
135 | SEARCHTERM1_P1 | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
136 | SEARCHTERM2_P1 | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
137 | FIRSTNAME_P1 | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
138 | LASTNAME_P1 | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
139 | NAME1_P1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
140 | NAME2_P1 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
141 | NAME3_P1 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
142 | NAME4_P1 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
143 | NAMEGROUP1_P1 | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
144 | NAMEGROUP2_P1 | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
145 | XNAME_P1 | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
146 | XPARTNER_P1 | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
147 | XSALUTATION_P1 | REBPXSALUTATION | CHAR80 | CHAR | 80 | 0 | Salutation for Business Partner | ||
148 | XADDRESS_P1 | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
149 | LINE0_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
150 | LINE1_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
151 | LINE2_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
152 | LINE3_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
153 | LINE4_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
154 | LINE5_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
155 | LINE6_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
156 | LINE7_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
157 | LINE8_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
158 | LINE9_P1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
159 | ADDRCATE_P1 | AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
160 | ADDRNUMBER_P1 | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
161 | PERSNUMBER_P1 | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
162 | SMTP_ADDR_P1 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
163 | TEL_COUNTRY_P1 | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
164 | TEL_NUMBER_P1 | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
165 | TEL_EXTENS_P1 | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
166 | TEL_NUMBER_LONG_P1 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
167 | FAX_COUNTRY_P1 | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
168 | FAX_NUMBER_P1 | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
169 | FAX_EXTENS_P1 | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
170 | FAX_NUMBER_LONG_P1 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
171 | INTRENO_P1 | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
172 | ROLE_P1 | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | * | |
173 | XROLE_P1 | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
174 | SUBROLE_P1 | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
175 | XSUBROLE_P1 | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
176 | ROLECATE_P1 | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
177 | APPL_P1 | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | * | |
178 | VALIDFROM_P1 | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
179 | VALIDTO_P1 | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
180 | ADDRTYPE_P1 | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * | |
181 | .INCLUDE | 0 | 0 | Further Partner 2 | |||||
182 | .INCLU-_P2 | 0 | 0 | Business Partner: General Data | |||||
183 | PARTNER_P2 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
184 | PARTN_CAT_P2 | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
185 | SEARCHTERM1_P2 | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
186 | SEARCHTERM2_P2 | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
187 | FIRSTNAME_P2 | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
188 | LASTNAME_P2 | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
189 | NAME1_P2 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
190 | NAME2_P2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
191 | NAME3_P2 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
192 | NAME4_P2 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
193 | NAMEGROUP1_P2 | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
194 | NAMEGROUP2_P2 | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
195 | XNAME_P2 | REBPXNAME | BU_TEXT50 | CHAR | 50 | 0 | Short Name of Business Partner | ||
196 | XPARTNER_P2 | REBPXPARTNER | TEXT80 | CHAR | 80 | 0 | Name/Address of Business Partner | ||
197 | XSALUTATION_P2 | REBPXSALUTATION | CHAR80 | CHAR | 80 | 0 | Salutation for Business Partner | ||
198 | XADDRESS_P2 | REBPXADDRESS | REBPXADDRESS | CHAR | 80 | 0 | Compact Display of Address | ||
199 | LINE0_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
200 | LINE1_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
201 | LINE2_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
202 | LINE3_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
203 | LINE4_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
204 | LINE5_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
205 | LINE6_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
206 | LINE7_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
207 | LINE8_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
208 | LINE9_P2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
209 | ADDRCATE_P2 | AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
210 | ADDRNUMBER_P2 | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
211 | PERSNUMBER_P2 | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
212 | SMTP_ADDR_P2 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
213 | TEL_COUNTRY_P2 | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
214 | TEL_NUMBER_P2 | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
215 | TEL_EXTENS_P2 | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
216 | TEL_NUMBER_LONG_P2 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
217 | FAX_COUNTRY_P2 | AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
218 | FAX_NUMBER_P2 | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
219 | FAX_EXTENS_P2 | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
220 | FAX_NUMBER_LONG_P2 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
221 | INTRENO_P2 | RECAINTRENO | RECAINTRENO | CHAR | 13 | 0 | Internal Key of Real Estate Object | ||
222 | ROLE_P2 | REBPROLE | BU_ROLE | CHAR | 6 | 0 | Business Partner: Role | * | |
223 | XROLE_P2 | REBPXROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Business Partner Role | ||
224 | SUBROLE_P2 | REBPSUBROLE | REBPSUBROLE | CHAR | 4 | 0 | Business Partner: Role Type | TIVBPSUBROLE | |
225 | XSUBROLE_P2 | REBPXSUBROLE | RECAXMDESCRIPTION | CHAR | 30 | 0 | Name of Role Type | ||
226 | ROLECATE_P2 | REBPROLECATE | REBPROLECATE | CHAR | 1 | 0 | Category of Role Category | ||
227 | APPL_P2 | REBPAPPL | BP_APPL | CHAR | 4 | 0 | Business Partner: Application Category | * | |
228 | VALIDFROM_P2 | REBPVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date of Start of Relationship | ||
229 | VALIDTO_P2 | REBPVALIDTO | RECADATEEND | DATS | 8 | 0 | Date of End of Relationship | ||
230 | ADDRTYPE_P2 | REBPADDRTYPE | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RECP_OI_DOC_CA_ALL | SUBROLE_CL | TIVBPSUBROLE | SUBROLE | REF | C | CN |
2 | RECP_OI_DOC_CA_ALL | SUBROLE_P1 | TIVBPSUBROLE | SUBROLE | REF | C | CN |
3 | RECP_OI_DOC_CA_ALL | SUBROLE_P2 | TIVBPSUBROLE | SUBROLE | REF | C | CN |
4 | RECP_OI_DOC_CA_ALL | SUBROLE_RC | TIVBPSUBROLE | SUBROLE | REF | C | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 110 |