SAP ABAP Table BAPICUSCPG (BAPI Structure Customer - Contact Person General Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM (Package) Customer Relationship Management (Interfaces SFA Server)
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM (Package) Customer Relationship Management (Interfaces SFA Server)
Basic Data
Table Category | INTTAB | Structure |
Structure | BAPICUSCPG | Table Relationship Diagram |
Short Description | BAPI Structure Customer - Contact Person General 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 | CONTACT | PARNR | PARNR | NUMC | 10 | 0 | Number of contact person | ||
2 | CUSTOMER | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
3 | BUSIADR | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
4 | PRIVADDR | ADRNR | ADRNR | CHAR | 10 | 0 | Address | * | |
5 | DEPARTMCOD | ABTNR_PA | ABTNR | CHAR | 4 | 0 | Contact person department | ||
6 | HGHLEVELPE | UEPAR | PARNR | NUMC | 10 | 0 | Higher-level contact person | ||
7 | FUNCT_CODE | PAFKT | PAFKT | CHAR | 2 | 0 | Contact person function | * | |
8 | AUTHORITY | PARVO | PARVO | CHAR | 1 | 0 | Partner's power of attorney | * | |
9 | VIP | PAVIP | PAVIP | CHAR | 1 | 0 | VIP Partner | * | |
10 | GENDER | PARGE | GESCH | CHAR | 1 | 0 | Partner's gender | ||
11 | DATE_BIRTH | GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
12 | REPRESENT | VTRNR | VTRNR | NUMC | 10 | 0 | Representative number | ||
13 | CALL_FREQ | BRYTH | BRYTH | CHAR | 4 | 0 | Call frequency | * | |
14 | BUY_HABITS | AKVER | AKVER | CHAR | 2 | 0 | Buying habits | * | |
15 | ADVERT_MAT | NMAIL | XFELD | CHAR | 1 | 0 | Advertising material indicator | ||
16 | NOTES | PARAU | TEXT40 | CHAR | 40 | 0 | Notes about contact person | ||
17 | ATTRIBUTE1 | PAAT1 | PARHO | CHAR | 2 | 0 | Contact Partner: Attribute 1 | * | |
18 | ATTRIBUTE2 | PAAT2 | PAAT2 | CHAR | 2 | 0 | Contact person: Attribute 2 | * | |
19 | ATTRIBUTE3 | PAAT3 | PAAT3 | CHAR | 2 | 0 | Contact person: Attribute 3 | * | |
20 | ATTRIBUTE4 | PAAT4 | PAAT4 | CHAR | 2 | 0 | Contact person: Attribute 4 | * | |
21 | ATTRIBUTE5 | PAAT5 | PAAT5 | CHAR | 2 | 0 | Contact person: Attribute 5 | * | |
22 | VISITMOMFR | BEMOAB1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Monday morning from ... | ||
23 | VISITMOMTO | BEMOBI1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Monday morning until ... | ||
24 | VISITMOAFR | BEMOAB2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Monday afternoon from ... | ||
25 | VISITMOATO | BEMOBI2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Monday afternoon until ... | ||
26 | VISITTUMFR | BEDIAB1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Tuesday morning from... | ||
27 | VISITTUMTO | BEDIBI1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Tuesday morning until ... | ||
28 | VISITTUAFR | BEDIAB2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Tuesday afternoon from.. | ||
29 | VISITTUATO | BEDIBI2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Tuesday afternoon until ... | ||
30 | VISITWEMFR | BEMIAB1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Wednesday morning from... | ||
31 | VISITWEMTO | BEMIBI1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Wednesday morning until ... | ||
32 | VISITWEAFR | BEMIAB2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Wednesday afternoon from .. | ||
33 | VISITWEATO | BEMIBI2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Wednesday afternoon until.. | ||
34 | VISITTHMFR | BEDOAB1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Thursday morning from .... | ||
35 | VISITTHMTO | BEDOBI1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Thursday morning until .... | ||
36 | VISITTHAFR | BEDOAB2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Thursday afternoon from... | ||
37 | VISITTHATO | BEDOBI2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Thursday afternoon until .. | ||
38 | VISITFRMFR | BEFRAB1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Friday morning from ... | ||
39 | VISITFRMTO | BEFRBI1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Friday morning until ... | ||
40 | VISITFRAFR | BEFRAB2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Friday afternoon from ... | ||
41 | VISITFRATO | BEFRBI2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Friday afternoon until ... | ||
42 | VISITSAMFR | BESAAB1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Saturday morning from ... | ||
43 | VISITSAMTO | BESABI1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Saturday morning until ... | ||
44 | VISITSAAFR | BESAAB2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Saturday afternoon from ... | ||
45 | VISITSAATO | BESABI2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Saturday afternoon until .. | ||
46 | VISITSUMFR | BESOAB1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Sunday morning from ... | ||
47 | VISITSUMTO | BESOBI1 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Sunday morning until ... | ||
48 | VISITSUAFR | BESOAB2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Sunday afternoon from ... | ||
49 | VISITSUATO | BESOBI2 | UHRZT | TIMS | 6 | 0 | Contact person's visiting hours: Sunday afternoon until ... | ||
50 | ATTRIBUTE6 | PAAT6 | PAAT6 | CHAR | 3 | 0 | Contact person: Attribute 6 | * | |
51 | ATTRIBUTE7 | PAAT7 | PAAT7 | CHAR | 3 | 0 | Contact person: Attribute 7 | * | |
52 | ATTRIBUTE8 | PAAT8 | PAAT8 | CHAR | 3 | 0 | Contact person: Attribute 8 | * | |
53 | ATTRIBUTE9 | PAAT9 | PAAT9 | CHAR | 3 | 0 | Contact person: Attribute 9 | * | |
54 | ATTRIB_10 | PAAT0 | PAAT0 | CHAR | 3 | 0 | Contact person: Attribute 10 | * | |
55 | MARITAL_ST | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | * | |
56 | CREAT_DATE | ERDAT_RF | DATUM | DATS | 8 | 0 | Date on which the Record Was Created | ||
57 | ENTERED_BY | ERNAM_RF | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
58 | VENDOR_NO | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
59 | DEL_FLAG_G | LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
60 | FORM_OF_AD | ANRED_AP | TEXT30 | CHAR | 30 | 0 | Form of address for contact person (Mr, Mrs...etc) | ||
61 | FIRSTNAME | AD_NAMEFIR | TEXT40 | CHAR | 40 | 0 | First name | ||
62 | LASTNAME | AD_NAMELAS | TEXT40 | CHAR | 40 | 0 | Last name | ||
63 | BIRTH_NAME | AD_NAME2_P | TEXT40 | CHAR | 40 | 0 | Name of person at birth | ||
64 | MIDDLENAME | CRM_DUMMY1 | TEXT40 | CHAR | 40 | 0 | Dummy Field: Middle Name or Second Forename of Person | ||
65 | SECONDNAME | CRM_DUMMY2 | TEXT40 | CHAR | 40 | 0 | Dummy field: Second family name of person | ||
66 | FULLNAME | AD_NAMTEXT | TEXT80 | CHAR | 80 | 0 | Full Name of Person | ||
67 | FULLNAME_X | AD_NAMCONV | AD_NAMCONV | CHAR | 1 | 0 | Status of Field 'Full Name' NAME_TEXT | ||
68 | TITLE_ACA1 | AD_TITLE1T | TEXT20 | CHAR | 20 | 0 | Academic Title: Written Form | ||
69 | TITLE_ACA2 | AD_TITLE1T | TEXT20 | CHAR | 20 | 0 | Academic Title: Written Form | ||
70 | PREFIX1 | AD_PREFIXT | TEXT20 | CHAR | 20 | 0 | Name prefix | ||
71 | PREFIX2 | AD_PREFIXT | TEXT20 | CHAR | 20 | 0 | Name prefix | ||
72 | TITLE_SPPL | AD_TITLEST | TEXT20 | CHAR | 20 | 0 | Name supplement, e.g. noble title (written form) | ||
73 | TITLE_FCTN | TITEL_AP | TEXT35 | CHAR | 35 | 0 | Title of contact person (description of function) | ||
74 | NICKNAME | AD_NICKNAM | TEXT40 | CHAR | 40 | 0 | Nickname or name used | ||
75 | INITIALS | AD_INITS | CHAR10 | CHAR | 10 | 0 | "Middle Initial" or personal initials | ||
76 | NAMEFORMAT | AD_FORMAT | AD_NAMFORM | CHAR | 2 | 0 | Name format | T005N | |
77 | NAMCOUNTRY | AD_NAMCTRY | LAND1 | CHAR | 3 | 0 | Country for name format rule | T005 | |
78 | NAMCNTYISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
79 | LANGU_P | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
80 | LANGUP_ISO | LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
81 | SORT1_P | AD_SORT1 | CHAR20 | CHAR | 20 | 0 | Search Term 1 | ||
82 | SORT2_P | AD_SORT2 | CHAR20 | CHAR | 20 | 0 | Search Term 2 | ||
83 | DEPARTMENT | AD_DPRTMNT | TEXT40 | CHAR | 40 | 0 | Department | ||
84 | FUNCTION | AD_FNCTN | TEXT40 | CHAR | 40 | 0 | Function | ||
85 | BUILDING_P | AD_BLDNG_P | TEXT10 | CHAR | 10 | 0 | Building (number or code) | ||
86 | FLOOR_P | AD_FLOOR | TEXT10 | CHAR | 10 | 0 | Floor in building | ||
87 | ROOM_NO_P | AD_ROOMNUM | TEXT10 | CHAR | 10 | 0 | Room or Appartment Number | ||
88 | INITS_SIG | AD_ID_CODE | TEXT10 | CHAR | 10 | 0 | Short name for correspondence | ||
89 | INHOUSE_ML | AD_IH_MAIL | TEXT10 | CHAR | 10 | 0 | Int. mail postal code | ||
90 | COMM_TYPE | AD_COMM | AD_COMM | CHAR | 3 | 0 | Communication Method (Key) (Business Address Services) | TSAC |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BAPICUSCPG | COMM_TYPE | TSAC | COMM_TYPE | |||
2 | BAPICUSCPG | LANGU_P | T002 | SPRAS | |||
3 | BAPICUSCPG | NAMCOUNTRY | T005 | LAND1 | |||
4 | BAPICUSCPG | NAMEFORMAT | T005N | NAMEFORMAT |
History
Last changed by/on | SAP | 20140117 |
SAP Release Created in |