SAP ABAP Table VVKK_PAT (Partner Data for Test DI/RFC)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CD (Application Component) Collections/Disbursements
⤷ ISCDFUN (Package) FS-CD: Collections/Disbursements Functionality
⤷ FS-CD (Application Component) Collections/Disbursements
⤷ ISCDFUN (Package) FS-CD: Collections/Disbursements Functionality
Basic Data
Table Category | INTTAB | Structure |
Structure | VVKK_PAT | Table Relationship Diagram |
Short Description | Partner Data for Test DI/RFC |
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 | M1 | CHAR01 | CHAR1 | CHAR | 1 | 0 | Character Field Length 1 | ||
2 | M2 | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
3 | FALLNR | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
4 | AKTYP | BU_AKTYP | BU_AKTYP | CHAR | 2 | 0 | Activity Category | * | |
5 | RLTP1 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
6 | RLTP2 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
7 | RLTP3 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
8 | RLTP4 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
9 | RLTP5 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
10 | RLTP6 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
11 | RLTP7 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
12 | RLTP8 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
13 | RLTP9 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
14 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
15 | VALDT | BU_VALDT_DI | CHAR8 | CHAR | 8 | 0 | Validity Date of Changes (Direct Input) | ||
16 | TYPE | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
17 | BPKIND | BU_BPKIND | BU_KIND | CHAR | 4 | 0 | Business Partner Type | TB004 | |
18 | BU_GROUP | BU_GROUP | BU_GROUP | CHAR | 4 | 0 | Business Partner Grouping | TB001 | |
19 | BPEXT | BU_BPEXT | CHAR20 | CHAR | 20 | 0 | Business Partner Number in External System | ||
20 | BU_SORT1 | BU_SORT1 | BU_SORT1 | CHAR | 20 | 0 | Search term 1 for business partner | ||
21 | BU_SORT2 | BU_SORT2 | BU_SORT1 | CHAR | 20 | 0 | Search term 2 for business partner | ||
22 | SOURCE | BU_SOURCE | BU_SOURCE | CHAR | 4 | 0 | Data Origin Types | TB005 | |
23 | TITLE | AD_TITLE | AD_TITLE | CHAR | 4 | 0 | Form-of-Address Key | TSAD3 | |
24 | XDELE | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
25 | XBLCK | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
26 | AUGRP | BU_AUGRP | BU_AUGRP | CHAR | 4 | 0 | Authorization Group | * | |
27 | NAME_ORG1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
28 | NAME_ORG2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
29 | NAME_ORG3 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
30 | NAME_ORG4 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
31 | LEGAL_ENTY | BU_LEGENTY | BU_LEGENTY | CHAR | 2 | 0 | BP: Legal form of organization | TB019 | |
32 | FOUND_DAT | BU_FOUND_DAT_DI | CHAR8 | CHAR | 8 | 0 | Date organization founded (direct input) | ||
33 | LIQUID_DAT | BU_LIQUID_DAT_DI | CHAR8 | CHAR | 8 | 0 | Date of liquidation of organization (direct input) | ||
34 | LOCATION_1 | BU_BBBNR_DI | CHAR7 | CHAR | 7 | 0 | International location number (part 1, direct input) | ||
35 | LOCATION_2 | BU_BBSNR_DI | CHAR5 | CHAR | 5 | 0 | International location number (part 2, direct input) | ||
36 | LOCATION_3 | BU_BUBKZ_DI | CHAR1 | CHAR | 1 | 0 | Check digit for international location number (direct input) | ||
37 | IND_SECTOR | BU_INDSECT | BU_INDSECT | CHAR | 10 | 0 | Industry sector | TB023 | |
38 | NAME_LAST | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
39 | NAME_FIRST | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
40 | NAME_LST2 | BU_NAMEPL2 | BU_NAME | CHAR | 40 | 0 | Other Last Name of a Person | ||
41 | NAME_LAST2 | BU_BIRTHNM | BU_NAME | CHAR | 40 | 0 | Name at birth of business partner | ||
42 | NAMEMIDDLE | BU_NAMEMID | BU_NAME | CHAR | 40 | 0 | Middle name or second forename of a person | ||
43 | TITLE_ACA1 | AD_TITLE1 | AD_TITLE1 | CHAR | 4 | 0 | Academic Title: Key | TSAD2 | |
44 | TITLE_ACA2 | AD_TITLE2 | AD_TITLE1 | CHAR | 4 | 0 | Second academic title (key) | TSAD2 | |
45 | TITLE_ROYL | AD_TITLES | AD_TITLES | CHAR | 4 | 0 | Name supplement, e.g. noble title (key) | TSAD5 | |
46 | PREFIX1 | AD_PREFIX | AD_PREFIX | CHAR | 4 | 0 | Name Prefix (Key) | TSAD4 | |
47 | PREFIX2 | AD_PREFIX2 | AD_PREFIX | CHAR | 4 | 0 | 2nd name prefix (key) | TSAD4 | |
48 | NAME1_TEXT | BU_NAME1TX | TEXT80 | CHAR | 80 | 0 | Full Name | ||
49 | NICKNAME | BU_NICKNAM | BU_NAME | CHAR | 40 | 0 | Nickname of Business Partner (Person) | ||
50 | INITIALS | AD_INITS | CHAR10 | CHAR | 10 | 0 | "Middle Initial" or personal initials | ||
51 | NAMEFORMAT | AD_FORMAT | AD_NAMFORM | CHAR | 2 | 0 | Name format | T005N | |
52 | NAMCOUNTRY | AD_NAMCTRY | LAND1 | CHAR | 3 | 0 | Country for name format rule | T005 | |
53 | XSEXM | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
54 | XSEXF | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
55 | BIRTHPL | BU_BIRTHPL | TEXT40 | CHAR | 40 | 0 | Birthplace of business partner | ||
56 | MARST | BU_MARST | BU_MARST | CHAR | 1 | 0 | Marital Status of Business Partner | TB027 | |
57 | EMPLO | BU_EMPLO | BU_EMPLO | CHAR | 35 | 0 | Name of Employer of a Natural Person | ||
58 | JOBGR | BU_JOBGR | BU_JOBGR | CHAR | 4 | 0 | Occupation/group | TB028 | |
59 | NATIO | BU_NATIO | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
60 | CNTAX | BU_CNTAX | LAND1 | CHAR | 3 | 0 | Obsolete Field | T005 | |
61 | CNDSC | BU_CNDSC | LAND1 | CHAR | 3 | 0 | Ctry of Origin: Non-Res. Companies | T005 | |
62 | PERSNUMBER | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
63 | XSEXU | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
64 | XUBNAME | XUBNAME | XUBNAME | CHAR | 12 | 0 | User Name in User Master Record | USR02 | |
65 | BIRTHDT | BU_BIRTHDT_DI | CHAR8 | CHAR | 8 | 0 | Date of birth of business partner (direct input) | ||
66 | DEATHDT | BU_DEATHDT_DI | CHAR8 | CHAR | 8 | 0 | Date of death of business partner (direct input) | ||
67 | PERNO | BU_PERNO_DI | CHAR8 | CHAR | 8 | 0 | Personnel number of business partner (direct input) | ||
68 | PARTGRPTYP | BU_GRPTYP | BU_GRPTYP | CHAR | 4 | 0 | Group type | TB025 | |
69 | NAME_GRP1 | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
70 | NAME_GRP2 | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
71 | LGTYP | BU_LGTYP | BU_LGTYP | CHAR | 4 | 0 | Legitimation Type | * | |
72 | LGNUM | BU_LGNUM | BU_LGNUM | CHAR | 16 | 0 | Identification number of legitimation document | ||
73 | INFCT | BU_INFCT | BU_INFCT | CHAR | 30 | 0 | Responsible local court | ||
74 | COMRG | BU_COMRG | CHAR30 | CHAR | 30 | 0 | Entry in commercial register | ||
75 | CLBRG | BU_CLBRG | CHAR30 | CHAR | 30 | 0 | BP: Entry in register of associations | ||
76 | COPRG | BU_COPRG | CHAR30 | CHAR | 30 | 0 | Entry in Register of Cooperatives | ||
77 | BONIMA | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
78 | ADINT_ADDR | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
79 | ADEXT_ADDR | BU_ADEXT | BU_ADEXT | CHAR | 20 | 0 | Address number in external system | ||
80 | CHIND_ADDR | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
81 | XDFADR | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
82 | NAME_CO | AD_NAME_CO | TEXT40 | CHAR | 40 | 0 | c/o name | ||
83 | CITY1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
84 | CITY2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
85 | CITY_CODE | AD_CITYNUM | CITY_CODE | CHAR | 12 | 0 | City code for city/street file | * | |
86 | CITYP_CODE | AD_CITYPNM | CITYP_CODE | CHAR | 8 | 0 | District code for City and Street file | * | |
87 | CHCKSTATUS | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
88 | REGIOGROUP | REGIOGROUP | REGIOGROUP | CHAR | 8 | 0 | Regional structure grouping | * | |
89 | POST_CODE1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
90 | POST_CODE2 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
91 | POST_CODE3 | AD_PSTCD3 | CHAR10 | CHAR | 10 | 0 | Company postal code (for large customers) | ||
92 | PCODE1_EXT | AD_PST1XT | CHAR10 | CHAR | 10 | 0 | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | ||
93 | PCODE2_EXT | AD_PST2XT | CHAR10 | CHAR | 10 | 0 | (Not Supported) PO Box Postal Code Extension | ||
94 | PCODE3_EXT | AD_PST3XT | CHAR10 | CHAR | 10 | 0 | (Not Supported) Major Customer Postal Code Extension | ||
95 | PO_BOX | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
96 | PO_BOX_NUM | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
97 | PO_BOX_LOC | AD_POBXLOC | TEXT40 | CHAR | 40 | 0 | PO Box city | ||
98 | CITY_CODE2 | AD_CIT2NUM | CITY_CODE | CHAR | 12 | 0 | City PO box code (City file) | * | |
99 | PO_BOX_REG | AD_POBXREG | REGIO | CHAR | 3 | 0 | Region for PO Box (Country, State, Province, ...) | * | |
100 | PO_BOX_CTY | AD_POBXCTY | LAND1 | CHAR | 3 | 0 | PO box country | * | |
101 | POSTALAREA | AD_PSTLAR | TEXT15 | CHAR | 15 | 0 | (Not Supported) Post Delivery District | ||
102 | TRANSPZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | * | |
103 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
104 | STREETCODE | AD_STRNUM | STRT_CODE | CHAR | 12 | 0 | Street Number for City/Street File | * | |
105 | STREETABBR | AD_STRABBR | STRTYPEAB | CHAR | 2 | 0 | (Not Supported) Abbreviation of Street Name | * | |
106 | HOUSE_NUM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
107 | HOUSE_NUM2 | AD_HSNM2 | TEXT10 | CHAR | 10 | 0 | House number supplement | ||
108 | HOUSE_NUM3 | AD_HSNM3 | TEXT10 | CHAR | 10 | 0 | (Not supported) House Number Range | ||
109 | STR_SUPPL1 | AD_STRSPP1 | TEXT40 | CHAR | 40 | 0 | Street 2 | ||
110 | STR_SUPPL2 | AD_STRSPP2 | TEXT40 | CHAR | 40 | 0 | Street 3 | ||
111 | STR_SUPPL3 | AD_STRSPP3 | TEXT40 | CHAR | 40 | 0 | Street 4 | ||
112 | LOCATION | AD_LCTN | TEXT40 | CHAR | 40 | 0 | Street 5 | ||
113 | BUILDING | AD_BLDNG | TEXT20 | CHAR | 20 | 0 | Building (Number or Code) | ||
114 | FLOOR | AD_FLOOR | TEXT10 | CHAR | 10 | 0 | Floor in building | ||
115 | ROOMNUMBER | AD_ROOMNUM | TEXT10 | CHAR | 10 | 0 | Room or Appartment Number | ||
116 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
117 | LANGU | CHAR | 1 | 0 | |||||
118 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
119 | SORT1 | AD_SORT1 | CHAR20 | CHAR | 20 | 0 | Search Term 1 | ||
120 | SORT2 | AD_SORT2 | CHAR20 | CHAR | 20 | 0 | Search Term 2 | ||
121 | SORT_PHN | AD_SRTPHN | CHAR20 | CHAR | 20 | 0 | (Not Supported) Phonetic Search Sort Field | ||
122 | ADDRORIGIN | AD_ORIGINA | AD_ORIGIN | CHAR | 4 | 0 | (Not Supported) Address Data Source (Key) | * | |
123 | EXTENSION1 | AD_EXTENS1 | TEXT40 | CHAR | 40 | 0 | Extension (only for data conversion) (e.g. data line) | ||
124 | EXTENSION2 | AD_EXTENS2 | TEXT40 | CHAR | 40 | 0 | Extension (only for data conversion) (e.g. telebox) | ||
125 | TIME_ZONE | AD_TZONE | TZNZONE | CHAR | 6 | 0 | Address time zone | * | |
126 | TAXJURCODE | AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
127 | ADDRESS_ID | AD_ADDR_ID | AD_ADDR_ID | CHAR | 10 | 0 | (Not supported) Physical address ID | ||
128 | REMARK | AD_REMARK1 | TEXT50 | CHAR | 50 | 0 | Address notes | ||
129 | LANGU_CREA | CHAR | 1 | 0 | |||||
130 | CHIND_TEL | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
131 | TEL_CONSNR | BU_CONSNUM | CHAR3 | CHAR | 3 | 0 | Seq. number (direct input) | ||
132 | TEL_CNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
133 | TEL_NUMBER | AD_TLNMBR | CHAR30 | CHAR | 30 | 0 | Telephone no.: dialling code+number | ||
134 | TEL_EXTENS | AD_TLXTNS | CHAR10 | CHAR | 10 | 0 | Telephone no.: Extension | ||
135 | TEL_DEFLT | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
136 | TEL_REMARK | AD_REMARK2 | TEXT50 | CHAR | 50 | 0 | Communication link notes | ||
137 | CHIND_FAX | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
138 | FAX_CONSNR | BU_CONSNUM | CHAR3 | CHAR | 3 | 0 | Seq. number (direct input) | ||
139 | FAX_CNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
140 | FAX_NUMBER | AD_FXNMBR | CHAR30 | CHAR | 30 | 0 | Fax number: dialling code+number | ||
141 | FAX_EXTENS | AD_FXXTNS | CHAR10 | CHAR | 10 | 0 | Fax no.: Extension | ||
142 | FAX_DEFLT | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
143 | FAX_REMARK | AD_REMARK2 | TEXT50 | CHAR | 50 | 0 | Communication link notes | ||
144 | ADINT_ADVW | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
145 | ADEXT_ADVW | BU_ADEXT | BU_ADEXT | CHAR | 20 | 0 | Address number in external system | ||
146 | CHIND_ADVW | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
147 | ADR_KIND | BU_ADRKIND | BU_ADRKIND | CHAR | 10 | 0 | Address Type | * | |
148 | XDFADU | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
149 | BKVID | BU_BKVID | CHAR4 | CHAR | 4 | 0 | Bank details ID | ||
150 | CHIND_BANK | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
151 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
152 | BANKL | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
153 | BANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
154 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
155 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
156 | KOINH | BU_KOINH | BU_KOINH | CHAR | 60 | 0 | Account Holder Name | ||
157 | BKEXT | BU_BKEXT | CHAR20 | CHAR | 20 | 0 | Bank details ID in external system | ||
158 | TAXTYPE | BPTAXTYPE | BPTAXTYPE | CHAR | 4 | 0 | Tax Number Category | ||
159 | CHIND_TAX | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
160 | TAXNUM | BPTAXNUM | BPTAXNUM | CHAR | 20 | 0 | Business Partner Tax Number | ||
161 | CCARD_ID | BU_CCID | CHAR6 | CHAR | 6 | 0 | Payment Card ID | ||
162 | CHIND_CCARD | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
163 | CCINS | CC_INSTITUTE | CC_INSTITUTE | CHAR | 4 | 0 | Payment card type | * | |
164 | CCNUM | CCNUM | CCNUM | CHAR | 25 | 0 | Payment cards: Card number | * | |
165 | CCDEF | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
166 | CCNAME | CCNAME | TEXT40 | CHAR | 40 | 0 | Payment Cards: Name of Cardholder | ||
167 | ISSBANK | CC_ISSBANK | TEXT40 | CHAR | 40 | 0 | Payment cards: Issuing bank | ||
168 | CCTYP | CC_CCTYP | CCTYPE | CHAR | 2 | 0 | Payment cards: Card category | * | |
169 | CCLOCK | CC_LOCK | CC_LOCK | CHAR | 2 | 0 | Payment Cards: Reason for Payment Card Lock | * | |
170 | DATAB | CC_DATAB_DI | CHAR8 | CHAR | 8 | 0 | Payment cards: Valid from (direct input) | ||
171 | DATBI | CC_DATBI_DI | CHAR8 | CHAR | 8 | 0 | Payment Cards: Valid To (Direct Input) | ||
172 | AUSGDAT | CC_AUSGDAT_DI | CHAR8 | CHAR | 8 | 0 | Payment cards: Issue date (direct input) | ||
173 | CUSTFELD | CHAR50 | TEXT50 | CHAR | 50 | 0 | Comment | ||
174 | ROLE1 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
175 | ROLE2 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
176 | ROLE3 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
177 | ROLE4 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
178 | ROLE5 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
179 | ROLE6 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
180 | ROLE7 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
181 | ROLE8 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
182 | ROLE9 | BU_RLTYP | BU_RLTYP | CHAR | 6 | 0 | BDT: Object part | * | |
183 | VALID_FROM_1 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
184 | VALID_TO_1 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
185 | CHIND_1 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
186 | VALID_FROM_2 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
187 | VALID_TO_2 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
188 | CHIND_2 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
189 | VALID_FROM_3 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
190 | VALID_TO_3 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
191 | CHIND_3 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
192 | VALID_FROM_4 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
193 | VALID_TO_4 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
194 | CHIND_4 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
195 | VALID_FROM_5 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
196 | VALID_TO_5 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
197 | CHIND_5 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
198 | VALID_FROM_6 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
199 | VALID_TO_6 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
200 | CHIND_6 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
201 | VALID_FROM_7 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
202 | VALID_TO_7 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
203 | CHIND_7 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
204 | VALID_FROM_8 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
205 | VALID_TO_8 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
206 | CHIND_8 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
207 | VALID_FROM_9 | BU_ROLE_VALID_FROM_DI | CHAR | 8 | 0 | Valid From Date of a BP Role (YYYYMMDD) | |||
208 | VALID_TO_9 | BU_ROLE_VALID_TO_DI | CHAR | 8 | 0 | Valid To Date of a BP Role (YYYYMMDD) | |||
209 | CHIND_9 | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
210 | ADDR_DATE_FROM | BU_VALID_DATE_FROM_DI | CHAR8 | CHAR | 8 | 0 | Validity Start (DI) | ||
211 | ADDR_DATE_TO | BU_VALID_DATE_TO_DI | CHAR8 | CHAR | 8 | 0 | Validity End (DI) | ||
212 | ADDR_MOVE_DATE | BU_MOVE_DATE_DI | CHAR8 | CHAR | 8 | 0 | Date of Move (DI) | ||
213 | MOVE_ADDR | BU_MOVE_ADDR | AD_ADDRNUM | CHAR | 10 | 0 | Number of Move Target Address for Address Moves | * | |
214 | ADVW_DATE_TO | BU_VALID_DATE_TO_DI | CHAR8 | CHAR | 8 | 0 | Validity End (DI) | ||
215 | ADVW_DATE_FROM | BU_VALID_DATE_FROM_DI | CHAR8 | CHAR | 8 | 0 | Validity Start (DI) | ||
216 | MOVE_BKVID | BU_MOVE_BKVID | CHAR4 | CHAR | 4 | 0 | ID of Target Details for Change of Bank Details (BP) | ||
217 | BK_DATE_FROM | BU_VALID_DATE_FROM_DI | CHAR8 | CHAR | 8 | 0 | Validity Start (DI) | ||
218 | BK_DATE_TO | BU_VALID_DATE_TO_DI | CHAR8 | CHAR | 8 | 0 | Validity End (DI) | ||
219 | BK_MOVE_DATE | BU_MOVE_DATE_DI | CHAR8 | CHAR | 8 | 0 | Date of Move (DI) | ||
220 | VALID_DATE_CDATA | BU_VALID_DATE_FROM_DI | CHAR8 | CHAR | 8 | 0 | Validity Start (DI) | ||
221 | VALID_FROM_CDATA | BU_VALID_DATE_TO_DI | CHAR8 | CHAR | 8 | 0 | Validity End (DI) | ||
222 | VALID_TO_CDATA | BU_VALID_DATE_TO_DI | CHAR8 | CHAR | 8 | 0 | Validity End (DI) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VVKK_PAT | BPKIND | TB004 | BPKIND | REF | 1 | CN |
2 | VVKK_PAT | BU_GROUP | TB001 | BU_GROUP | REF | 1 | CN |
3 | VVKK_PAT | CNDSC | T005 | LAND1 | REF | 1 | CN |
4 | VVKK_PAT | CNTAX | T005 | LAND1 | REF | 1 | CN |
5 | VVKK_PAT | IND_SECTOR | TB023 | IND_SECTOR | REF | 1 | CN |
6 | VVKK_PAT | JOBGR | TB028 | JOBGR | REF | 1 | CN |
7 | VVKK_PAT | LEGAL_ENTY | TB019 | LEGAL_ENTY | KEY | 1 | CN |
8 | VVKK_PAT | MARST | TB027 | MARST | 1 | CN | |
9 | VVKK_PAT | NAMCOUNTRY | T005 | LAND1 | REF | C | CN |
10 | VVKK_PAT | NAMEFORMAT | T005N | NAMEFORMAT | REF | C | CN |
11 | VVKK_PAT | NATIO | T005 | LAND1 | 1 | CN | |
12 | VVKK_PAT | PARTGRPTYP | TB025 | PARTGRPTYP | KEY | 1 | CN |
13 | VVKK_PAT | PREFIX1 | TSAD4 | PREFIX_KEY | KEY | 1 | CN |
14 | VVKK_PAT | PREFIX2 | TSAD4 | PREFIX_KEY | KEY | 1 | CN |
15 | VVKK_PAT | SOURCE | TB005 | SOURCE | REF | 1 | CN |
16 | VVKK_PAT | TITLE | TSAD3 | TITLE | REF | 1 | CN |
17 | VVKK_PAT | TITLE_ACA1 | TSAD2 | TITLE_KEY | KEY | 1 | CN |
18 | VVKK_PAT | TITLE_ACA2 | TSAD2 | TITLE_KEY | KEY | 1 | CN |
19 | VVKK_PAT | TITLE_ROYL | TSAD5 | TITLE_KEY | KEY | 1 | CN |
20 | VVKK_PAT | XUBNAME | USR02 | BNAME | KEY | 1 | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |