SAP ABAP Table KUPAV (Cust.Master View: Partners (Data from TKNVP w/Address))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
⤷
VZ (Package) Application development R/3 RV central functions

⤷

⤷

Basic Data
Table Category | INTTAB | Structure |
Structure | KUPAV |
![]() |
Short Description | Cust.Master View: Partners (Data from TKNVP w/Address) |
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 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ![]() |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
3 | ![]() |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
4 | ![]() |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
5 | ![]() |
SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
6 | ![]() |
PARVW | PARVW | CHAR | 2 | 0 | Partner Role | TPAR | |
7 | ![]() |
PARZA | PARZA | NUMC | 3 | 0 | Partner counter | ||
8 | ![]() |
KUNN2 | KUNNR | CHAR | 10 | 0 | Customer number of business partner | KNA1 | |
9 | ![]() |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
10 | ![]() |
PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
11 | ![]() |
PARNR | PARNR | NUMC | 10 | 0 | Number of contact person | ||
12 | ![]() |
ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
13 | ![]() |
KNREF | KNREF | CHAR | 30 | 0 | Customer description of partner (plant, storage location) | ||
14 | ![]() |
ANRED_VP | ANRED | CHAR | 15 | 0 | Form of address | ||
15 | ![]() |
NAME1_VP | NAME | CHAR | 35 | 0 | Name 1 of a partner | ||
16 | ![]() |
NAME2_VP | NAME | CHAR | 35 | 0 | Name 2 of a partner | ||
17 | ![]() |
NAME3_VP | NAME | CHAR | 35 | 0 | Name 3 of a partner | ||
18 | ![]() |
NAME4_VP | NAME | CHAR | 35 | 0 | Name 4 of a partner | ||
19 | ![]() |
STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
20 | ![]() |
LAND1_VP | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
21 | ![]() |
LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | TZONE | |
22 | ![]() |
PSTLZ_VP | PSTLZ | CHAR | 10 | 0 | Postal code | ||
23 | ![]() |
PSTL2_VP | PSTLZ | CHAR | 10 | 0 | Postal code of the P.O. box | ||
24 | ![]() |
PFORT_GP | TEXT35 | CHAR | 35 | 0 | PO Box city | ||
25 | ![]() |
ORT01_VP | ORT01 | CHAR | 35 | 0 | City | ||
26 | ![]() |
ORT02_GP | TEXT35 | CHAR | 35 | 0 | District | ||
27 | ![]() |
REGIO_VP | REGIO | CHAR | 3 | 0 | Regional code | T005S | |
28 | ![]() |
PFACH_VP | PFACH | CHAR | 10 | 0 | PO box | ||
29 | ![]() |
ABTEI | ABTEI | CHAR | 12 | 0 | Department | ||
30 | ![]() |
SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
31 | ![]() |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
32 | ![]() |
TELF1_VP | TELF1 | CHAR | 16 | 0 | Telephone Number | ||
33 | ![]() |
TELF2 | TEXT16 | CHAR | 16 | 0 | Second telephone number | ||
34 | ![]() |
TELBX_VP | TELBX | CHAR | 15 | 0 | Telebox number | ||
35 | ![]() |
TELFX_VP | TELFX | CHAR | 31 | 0 | Fax number | ||
36 | ![]() |
TELTX_VP | TELTX | CHAR | 30 | 0 | Teltex number | ||
37 | ![]() |
TELX1_VP | TELX1 | CHAR | 30 | 0 | Telex number | ||
38 | ![]() |
DATLT_VP | DATLT | CHAR | 14 | 0 | Number of data communication line | ||
39 | ![]() |
XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
40 | ![]() |
KTOKD | KTOKD | CHAR | 4 | 0 | Customer Account Group | T077D | |
41 | ![]() |
NAME_LIST | NAME | CHAR | 35 | 0 | Name for list displays | ||
42 | ![]() |
SPERB_X | XFELD | CHAR | 1 | 0 | Central posting block | ||
43 | ![]() |
AUFSD_X | KAUFS | CHAR | 2 | 0 | Central order block for customer | TVAST | |
44 | ![]() |
LIFSD_X | LIFSP | CHAR | 2 | 0 | Central delivery block for the customer | TVLS | |
45 | ![]() |
FAKSD_X | FAKSP | CHAR | 2 | 0 | Central billing block for customer | TVFS | |
46 | ![]() |
LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
47 | ![]() |
AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
48 | ![]() |
AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
49 | ![]() |
STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
50 | ![]() |
STCD2 | STCD2 | CHAR | 11 | 0 | Tax Number 2 | ||
51 | ![]() |
STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
52 | ![]() |
STCD4 | CHAR18 | CHAR | 18 | 0 | Tax Number 4 | ||
53 | ![]() |
STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
54 | ![]() |
J_1ATOID | J_1ATOID | CHAR | 2 | 0 | Tax Number Type | * | |
55 | ![]() |
REPRES | REPRES | CHAR | 10 | 0 | Name of Representative | ||
56 | ![]() |
GESTYP | GESTYP | CHAR | 30 | 0 | Type of Business | * | |
57 | ![]() |
INDTYP | INDTYP | CHAR | 30 | 0 | Type of Industry | * |
Foreign Keys
![]() |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
---|---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
1 | KUPAV | AUFSD | ![]() |
![]() |
REF | C | CN |
2 | KUPAV | FAKSD | ![]() |
![]() |
REF | C | CN |
3 | KUPAV | KTOKD | ![]() |
![]() |
|||
4 | KUPAV | KUNN2 | ![]() |
![]() |
|||
5 | KUPAV | KUNNR | ![]() |
![]() |
|||
6 | KUPAV | LAND1 | ![]() |
![]() |
|||
7 | KUPAV | LIFNR | ![]() |
![]() |
|||
8 | KUPAV | LIFSD | ![]() |
![]() |
REF | C | CN |
9 | KUPAV | LZONE | ![]() |
![]() |
|||
10 | KUPAV | MANDT | ![]() |
![]() |
|||
11 | KUPAV | PARVW | ![]() |
![]() |
|||
12 | KUPAV | REGIO | ![]() |
![]() |
|||
13 | KUPAV | SPART | ![]() |
![]() |
|||
14 | KUPAV | SPRAS | ![]() |
![]() |
|||
15 | KUPAV | VKORG | ![]() |
![]() |
|||
16 | KUPAV | VTWEG | ![]() |
![]() |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |