SAP ABAP Table CRMT_PARTNER_WRK (Partner Processing Work Area for Runtime)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-BF-PD (Application Component) Partner Processing
⤷
CRM_PARTNER (Package) CRM Partner Processing
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | CRMT_PARTNER_WRK |
|
| Short Description | Partner Processing Work Area for Runtime |
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 | |
0 | 0 | Partner Processing Work Area for Runtime | |||||
| 2 | |
0 | 0 | Partners | |||||
| 3 | |
0 | 0 | Internal Identification Key for a Partner (in Function) | |||||
| 4 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
| 5 | |
CRMT_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | GUID for an Individual Partner | ||
| 6 | |
0 | 0 | Internally Controlled Data for a Partner | |||||
| 7 | |
0 | 0 | GUID Integration of the Partner Set | |||||
| 8 | |
CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
| 9 | |
0 | 0 | Internally Controlled Data for a Partner | |||||
| 10 | |
CRMT_PARTNER_COMPRESSED | CRM_BOOLEAN | CHAR | 1 | 0 | Partner has Dependent, Compressed Records | ||
| 11 | |
CRMT_PARTNER_ATTRIBUTES | CRM_BOOLEAN | CHAR | 1 | 0 | Partner has Dependent Attributes | ||
| 12 | |
CRMT_PARTNER_KIND_OF_ENTRY | CRM_PARTNER_KIND_OF_ENTRY | CHAR | 1 | 0 | Source of a partner in a transaction | ||
| 13 | |
COMT_PARTNER_CUST_ATTRIBUTES | FLAG | CHAR | 1 | 0 | Flag: Customizable Attributes Available for Partner | ||
| 14 | |
COMT_PARTNER_CUST_RELATION | FLAG | CHAR | 1 | 0 | Partner Relationship Available | ||
| 15 | |
0 | 0 | Externally Influenced Partner Data | |||||
| 16 | |
0 | 0 | Identification Data for a Partner | |||||
| 17 | |
CRMT_PARTNER_FCT | COM_PARTNER_FCT | CHAR | 8 | 0 | Partner Function | ||
| 18 | |
CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
| 19 | |
CRMT_PARTNER_DISPLAY_TYPE | COMT_PARTNER_NO_TYPE | CHAR | 2 | 0 | Object Type, for Which Partner Number is to be Shown | ||
| 20 | |
CRMT_PARTNER_NO_TYPE | COMT_PARTNER_NO_TYPE | CHAR | 2 | 0 | Partner Number Type (e.g. GUID, Pers. No., ...), Internal | ||
| 21 | |
CRMT_PARTNER_MAIN | CRM_BOOLEAN | CHAR | 1 | 0 | Main Partner (For Ambiguous Partner Functions) | ||
| 22 | |
BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
| 23 | |
0 | 0 | Address Data of a Partner | |||||
| 24 | |
AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
| 25 | |
AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | * | |
| 26 | |
AD_ADRTYPE | AD_ADRTYPE | CHAR | 1 | 0 | Address type (1=Organization, 2=Person, 3=Contact person) | ||
| 27 | |
CRMT_ADDR_ORIGIN_MD | CRM_ADDR_ORIGIN_MD | CHAR | 1 | 0 | Origin of a Partner Address | ||
| 28 | |
CRMT_PARTNER_STD_BP_ADDRESS | XFELD | CHAR | 1 | 0 | Standard Business Partner Address (Depending on Addr.Type) | ||
| 29 | |
BU_OPERATION | BU_OPERATION | CHAR | 6 | 0 | Transaction for BP Address Determination | * | |
| 30 | |
0 | 0 | Common Attributes for all Partner Functions | |||||
| 31 | |
CRMT_PARTNER_CALENDAR | CRM_BOOLEAN | CHAR | 1 | 0 | Maintain Calendar for the Partner? | ||
| 32 | |
CRMT_PARTNER_DISABLED | CRM_BOOLEAN | CHAR | 1 | 0 | No INBOX Selection for the Partner | ||
| 33 | |
XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
| 34 | |
COMT_PARTNER_SRC_SYS | LOGSYS | CHAR | 10 | 0 | Logical System from Which Partner Originates | * | |
| 35 | |
0 | 0 | CRM Fields | |||||
| 36 | |
0 | 0 | EEW Include | |||||
| 37 | |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
| 38 | |
CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
| 39 | |
COMT_PARTNER_ATTR | STRU | 0 | 0 | ||||
| 40 | |
COMT_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | GUID for an Individual Partner | ||
| 41 | |
COMT_ATTR_TERRITORY | STRU | 0 | 0 | ||||
| 42 | |
GUID_16 | SYSUUID | RAW | 16 | 0 | GUID in 'RAW' format | ||
| 43 | |
CRMT_TERRITORY_PATH_ID | CRM_TERRITORY_PATH_ID | CHAR | 30 | 0 | Territory Hierarchy ID | ||
| 44 | |
COMT_ATTR_SCORING | STRU | 0 | 0 | ||||
| 45 | |
CRMT_SCORE | CRM_SCORE | CHAR | 10 | 0 | Result Value of an Internal Creditworthiness Check | ||
| 46 | |
DATUV | DATUM | DATS | 8 | 0 | Valid-From Date | ||
| 47 | |
DATBI | DATUM | DATS | 8 | 0 | Valid To Date | ||
| 48 | |
COMT_PARTNER_PFT | COM_PARTNER_PFT | CHAR | 4 | 0 | Partner Function Category | * | |
| 49 | |
COMT_PARTNER_SUBTYPE | CHAR4 | CHAR | 4 | 0 | Partner Function Sub-Type | ||
| 50 | |
COMT_PARTNER_NUMBER | COM_PARTNER_NUMBER | CHAR | 20 | 0 | Partner Number for Use Outside Partner Processing | ||
| 51 | |
0 | 0 | Dynamic Fields for Runtime of CRM Partner Processing | |||||
| 52 | |
0 | 0 | BAPI reference structure for addresses (contact person) | |||||
| 53 | |
AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | ADRP | |
| 54 | |
AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ADRC | |
| 55 | |
AD_TITLETX | TEXT30 | CHAR | 30 | 0 | Title text | ||
| 56 | |
AD_NAMEFIR | TEXT40 | CHAR | 40 | 0 | First name | ||
| 57 | |
AD_NAMELAS | TEXT40 | CHAR | 40 | 0 | Last name | ||
| 58 | |
AD_NAME2_P | TEXT40 | CHAR | 40 | 0 | Name of person at birth | ||
| 59 | |
AD_NAMEMID | TEXT40 | CHAR | 40 | 0 | Middle name or second forename of a person | ||
| 60 | |
AD_NAMLAS2 | TEXT40 | CHAR | 40 | 0 | Second surname of a person | ||
| 61 | |
AD_NAMTEXT | TEXT80 | CHAR | 80 | 0 | Full Name of Person | ||
| 62 | |
AD_NAMCONV | AD_NAMCONV | CHAR | 1 | 0 | Status of Field 'Full Name' NAME_TEXT | ||
| 63 | |
AD_TITLE1T | TEXT20 | CHAR | 20 | 0 | Academic Title: Written Form | ||
| 64 | |
AD_TITLE2T | TEXT20 | CHAR | 20 | 0 | 2nd academic title: written form | ||
| 65 | |
AD_PREFIXT | TEXT20 | CHAR | 20 | 0 | Name prefix | ||
| 66 | |
AD_PREFX2T | TEXT20 | CHAR | 20 | 0 | 2nd name prefix | ||
| 67 | |
AD_TITLEST | TEXT20 | CHAR | 20 | 0 | Name supplement, e.g. noble title (written form) | ||
| 68 | |
AD_NICKNAM | TEXT40 | CHAR | 40 | 0 | Nickname or name used | ||
| 69 | |
AD_INITS | CHAR10 | CHAR | 10 | 0 | "Middle Initial" or personal initials | ||
| 70 | |
AD_FORMAT | AD_NAMFORM | CHAR | 2 | 0 | Name format | T005N | |
| 71 | |
AD_NAMCTRY | LAND1 | CHAR | 3 | 0 | Country for name format rule | T005 | |
| 72 | |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
| 73 | |
LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
| 74 | |
AD_SORT1 | CHAR20 | CHAR | 20 | 0 | Search Term 1 | ||
| 75 | |
AD_SORT2 | CHAR20 | CHAR | 20 | 0 | Search Term 2 | ||
| 76 | |
AD_DPRTMNT | TEXT40 | CHAR | 40 | 0 | Department | ||
| 77 | |
AD_FNCTN | TEXT40 | CHAR | 40 | 0 | Function | ||
| 78 | |
AD_BLDNG_P | TEXT10 | CHAR | 10 | 0 | Building (number or code) | ||
| 79 | |
AD_FLOOR | TEXT10 | CHAR | 10 | 0 | Floor in building | ||
| 80 | |
AD_ROOMNUM | TEXT10 | CHAR | 10 | 0 | Room or Appartment Number | ||
| 81 | |
AD_ID_CODE | TEXT10 | CHAR | 10 | 0 | Short name for correspondence | ||
| 82 | |
AD_IH_MAIL | TEXT10 | CHAR | 10 | 0 | Int. mail postal code | ||
| 83 | |
AD_COMM | AD_COMM | CHAR | 3 | 0 | Communication Method (Key) (Business Address Services) | TSAC | |
| 84 | |
AD_TITLETX | TEXT30 | CHAR | 30 | 0 | Title text | ||
| 85 | |
AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
| 86 | |
AD_NAME2 | TEXT40 | CHAR | 40 | 0 | Name 2 | ||
| 87 | |
AD_NAME3 | TEXT40 | CHAR | 40 | 0 | Name 3 | ||
| 88 | |
AD_NAME4 | TEXT40 | CHAR | 40 | 0 | Name 4 | ||
| 89 | |
AD_NAME_CO | TEXT40 | CHAR | 40 | 0 | c/o name | ||
| 90 | |
AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
| 91 | |
AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
| 92 | |
AD_CITYNUM | CITY_CODE | CHAR | 12 | 0 | City code for city/street file | ADRCITY | |
| 93 | |
AD_CITYPNM | CITYP_CODE | CHAR | 8 | 0 | District code for City and Street file | ADRCITYPRT | |
| 94 | |
AD_CHECKST | AD_CHECKST | CHAR | 1 | 0 | City file test status | ||
| 95 | |
AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
| 96 | |
AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
| 97 | |
AD_PSTCD3 | CHAR10 | CHAR | 10 | 0 | Company postal code (for large customers) | ||
| 98 | |
AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
| 99 | |
AD_POBXLOC | TEXT40 | CHAR | 40 | 0 | PO Box city | ||
| 100 | |
AD_CIT2NUM | CITY_CODE | CHAR | 12 | 0 | City PO box code (City file) | ADRCITY | |
| 101 | |
AD_PSTLAR | TEXT15 | CHAR | 15 | 0 | (Not Supported) Post Delivery District | ||
| 102 | |
LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | TZONE | |
| 103 | |
AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
| 104 | |
AD_STRNUM | STRT_CODE | CHAR | 12 | 0 | Street Number for City/Street File | ADRSTREET | |
| 105 | |
AD_STRABBR | STRTYPEAB | CHAR | 2 | 0 | (Not Supported) Abbreviation of Street Name | ADRSTRTYPE | |
| 106 | |
AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
| 107 | |
AD_HSNM2 | TEXT10 | CHAR | 10 | 0 | House number supplement | ||
| 108 | |
AD_STRSPP1 | TEXT40 | CHAR | 40 | 0 | Street 2 | ||
| 109 | |
AD_STRSPP2 | TEXT40 | CHAR | 40 | 0 | Street 3 | ||
| 110 | |
AD_STRSPP3 | TEXT40 | CHAR | 40 | 0 | Street 4 | ||
| 111 | |
AD_LCTN | TEXT40 | CHAR | 40 | 0 | Street 5 | ||
| 112 | |
AD_BLD_OLD | TEXT10 | CHAR | 10 | 0 | old: building (no. or abbreviation) | ||
| 113 | |
AD_FLOOR | TEXT10 | CHAR | 10 | 0 | Floor in building | ||
| 114 | |
AD_ROOMNUM | TEXT10 | CHAR | 10 | 0 | Room or Appartment Number | ||
| 115 | |
LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
| 116 | |
INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
| 117 | |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
| 118 | |
LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
| 119 | |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
| 120 | |
AD_SORT1 | CHAR20 | CHAR | 20 | 0 | Search Term 1 | ||
| 121 | |
AD_SORT2 | CHAR20 | CHAR | 20 | 0 | Search Term 2 | ||
| 122 | |
AD_TZONE | TZNZONE | CHAR | 6 | 0 | Address time zone | TTZZ | |
| 123 | |
AD_TXJCD | AD_TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | ||
| 124 | |
AD_REMARK1 | TEXT50 | CHAR | 50 | 0 | Address notes | ||
| 125 | |
AD_TLNMBR1 | CHAR30 | CHAR | 30 | 0 | First telephone no.: dialling code+number | ||
| 126 | |
AD_TLXTNS1 | CHAR10 | CHAR | 10 | 0 | First Telephone No.: Extension | ||
| 127 | |
AD_FXNMBR1 | CHAR30 | CHAR | 30 | 0 | First fax no.: dialling code+number | ||
| 128 | |
AD_FXXTNS1 | CHAR10 | CHAR | 10 | 0 | First fax no.: extension | ||
| 129 | |
AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
| 130 | |
AD_BLDNG | TEXT20 | CHAR | 20 | 0 | Building (Number or Code) | ||
| 131 | |
REGIOGROUP | REGIOGROUP | CHAR | 8 | 0 | Regional structure grouping | * | |
| 132 | |
AD_CITY3 | TEXT40 | CHAR | 40 | 0 | City (different from postal city) | ||
| 133 | |
AD_CITYHNM | CITY_CODE | CHAR | 12 | 0 | Different city for city/street file | * | |
| 134 | |
AD_PST1XT | CHAR10 | CHAR | 10 | 0 | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | ||
| 135 | |
AD_PST2XT | CHAR10 | CHAR | 10 | 0 | (Not Supported) PO Box Postal Code Extension | ||
| 136 | |
AD_PST3XT | CHAR10 | CHAR | 10 | 0 | (Not Supported) Major Customer Postal Code Extension | ||
| 137 | |
AD_POBXNUM | XFELD | CHAR | 1 | 0 | Flag: PO Box without number | ||
| 138 | |
AD_POBXREG | REGIO | CHAR | 3 | 0 | Region for PO Box (Country, State, Province, ...) | * | |
| 139 | |
AD_POBXCTY | LAND1 | CHAR | 3 | 0 | PO box country | * | |
| 140 | |
INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
| 141 | |
AD_NO_USES | AD_NO_USE | CHAR | 4 | 0 | Street Address Undeliverable Flag | * | |
| 142 | |
AD_NO_USEP | AD_NO_USE | CHAR | 4 | 0 | PO Box Address Undeliverable Flag | * | |
| 143 | |
AD_HSNM3 | TEXT10 | CHAR | 10 | 0 | (Not supported) House Number Range | ||
| 144 | |
AD_LANGUCR | SPRAS | LANG | 1 | 0 | Address record creation original language | * | |
| 145 | |
LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
| 146 | |
AD_PO_BOX_LBY | TEXT40 | CHAR | 40 | 0 | PO Box Lobby | ||
| 147 | |
AD_DELIVERY_SERVICE_TYPE | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | 0 | Type of Delivery Service | * | |
| 148 | |
AD_DELIVERY_SERVICE_NUMBER | CHAR10 | CHAR | 10 | 0 | Number of Delivery Service | ||
| 149 | |
AD_CNTYNUM | CNTY_CODE | CHAR | 8 | 0 | County code for county | * | |
| 150 | |
AD_COUNTY | TEXT40 | CHAR | 40 | 0 | County | ||
| 151 | |
AD_TWSHPNUM | TWSHP_CODE | CHAR | 8 | 0 | Township code for Township | * | |
| 152 | |
AD_TOWNSHIP | TEXT40 | CHAR | 40 | 0 | Township | ||
| 153 | |
0 | 0 | No usage flags for partner addresses | |||||
| 154 | |
AD_FLNOUSE | XFELD | CHAR | 1 | 0 | Flag: This Communication Number is Not Used | ||
| 155 | |
AD_FLNOUSE | XFELD | CHAR | 1 | 0 | Flag: This Communication Number is Not Used | ||
| 156 | |
AD_FLNOUSE | XFELD | CHAR | 1 | 0 | Flag: This Communication Number is Not Used | ||
| 157 | |
AD_FLNOUSE | XFELD | CHAR | 1 | 0 | Flag: This Communication Number is Not Used | ||
| 158 | |
AD_FLNOUSE | XFELD | CHAR | 1 | 0 | Flag: This Communication Number is Not Used | ||
| 159 | |
CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
| 160 | |
AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
| 161 | |
AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
| 162 | |
AD_COMCTRY | LAND1 | CHAR | 3 | 0 | Country for telephone/fax number | * | |
| 163 | |
AD_MBNMBR1 | CHAR30 | CHAR | 30 | 0 | First Mobile Telephone No.: Dialing Code + Number | ||
| 164 | |
COMT_PARTNER_CUST_ATTRIBUTES_T | TTYP | 0 | 0 | ||||
| 165 | |
COMT_PARTNER_CUST_RELATIONS_T | TTYP | 0 | 0 | ||||
| 166 | |
COMT_PARTNER_COMP_PRD_T | TTYP | 0 | 0 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | CRMT_PARTNER_WRK | ADDR_NO | |
|
|||
| 2 | CRMT_PARTNER_WRK | CITY_NO | |
|
|||
| 3 | CRMT_PARTNER_WRK | COMM_TYPE | |
|
|||
| 4 | CRMT_PARTNER_WRK | COUNTRY | |
|
|||
| 5 | CRMT_PARTNER_WRK | DISTRCT_NO | |
|
|||
| 6 | CRMT_PARTNER_WRK | LANGU | |
|
|||
| 7 | CRMT_PARTNER_WRK | LANGU_P | |
|
|||
| 8 | CRMT_PARTNER_WRK | NAMCOUNTRY | |
|
|||
| 9 | CRMT_PARTNER_WRK | NAMEFORMAT | |
|
|||
| 10 | CRMT_PARTNER_WRK | PBOXCIT_NO | |
|
|||
| 11 | CRMT_PARTNER_WRK | PERS_NO | |
|
|||
| 12 | CRMT_PARTNER_WRK | REGION | |
|
|||
| 13 | CRMT_PARTNER_WRK | STREET_NO | |
|
|||
| 14 | CRMT_PARTNER_WRK | STR_ABBR | |
|
|||
| 15 | CRMT_PARTNER_WRK | TIME_ZONE | |
|
|||
| 16 | CRMT_PARTNER_WRK | TRANSPZONE | |
|
History
| Last changed by/on | SAP | 20141013 |
| SAP Release Created in |