| 1 | MANDT | Client | MANDT | T000 | MANDT | CLNT | 000003 | 000000 | |
| 2 | ADRNR | IS-M: Address Number | JADRNR | JGTSADR | JADRNR | CHAR | 000010 | 000000 | |
| 3 | UVADR_ST | IS-M: Coding Status of Address | UVADR_AD | | UVADR_AD | CHAR | 000001 | 000000 | |
Possible Values | 0 | coded in full | | 1 | coded in part | | 2 | not coded | | 3 | does not exist | | 4 | technical change to postal data |
|
|
| 4 | UVADR_PF | IS-M: Coding Status of Address | UVADR_AD | | UVADR_AD | CHAR | 000001 | 000000 | |
Possible Values | 0 | coded in full | | 1 | coded in part | | 2 | not coded | | 3 | does not exist | | 4 | technical change to postal data |
|
|
| 5 | UVADR_GK | IS-M: Coding Status of Address | UVADR_AD | | UVADR_AD | CHAR | 000001 | 000000 | |
Possible Values | 0 | coded in full | | 1 | coded in part | | 2 | not coded | | 3 | does not exist | | 4 | technical change to postal data |
|
|
| 6 | HERK | IS-M: Use of Address | HERK | | HERK | CHAR | 000001 | 000000 | |
Possible Values | 1 | Business Partner | | 2 | IS-M/SD Order | | 3 | Loading/Unloading Pt | | 4 | Voucher Shipping | | 5 | Divert Address | | 6 | Shipping Order | | 7 | Household | | A | Media Order | | B | Media Contact Person | | C | Media Order (One-Time) |
|
|
| 7 | XADRLOE | IS-M: Deletion Flag for Address | XLOES | | XFELD | CHAR | 000001 | 000000 | |
|
|
| 8 | ERFUSER | Created By | ERFUSER | | USNAM | CHAR | 000012 | 000000 | |
| 9 | ERFDATE | Created On | ERFDATE | | DATUM | DATS | 000008 | 000000 | |
| 10 | ERFTIME | Time Created | ERFTIME | | UZEIT | TIMS | 000006 | 000000 | |
| 11 | AENUSER | Last Changed By | AENUSER | | USNAM | CHAR | 000012 | 000000 | |
| 12 | AENDATE | Date of Last Change | AENDATE | | DATUM | DATS | 000008 | 000000 | |
| 13 | AENTIME | Time of Last Change | AENTIME | | UZEIT | TIMS | 000006 | 000000 | |
| 14 | ANRED | Form of Address Key | JANRED | TJG43 | JANRED | CHAR | 000002 | 000000 | |
| 15 | NAME1 | IS-M: Business Partner Name | NAME1_ISP | | NAME | CHAR | 000035 | 000000 | |
| 16 | NAME2 | IS-M: First Name of Business Partner | NAME2_ISP | | NAME | CHAR | 000035 | 000000 | |
| 17 | NAME3 | IS-M: Further Name Field for Business Partner | NAME3_ISP | | NAME | CHAR | 000035 | 000000 | |
| 18 | NAME4 | IS-M: Further Name Field for Business Partner | NAME4_ISP | | NAME | CHAR | 000035 | 000000 | |
| 19 | TITEL | IS-M: Title | TITEL_ISP | T535N | TITEL | CHAR | 000015 | 000000 | |
| 20 | NAMZU | IS-M: Name Affix | NAMZU_ISP | T535N | TITEL | CHAR | 000015 | 000000 | |
| 21 | VORSW | IS-M: Name Prefix | VORSW_ISP | T535N | TITEL | CHAR | 000015 | 000000 | |
| 22 | PSTLZ | IS-M: Postal Code | PLZ_ISP | | PSTLZ | CHAR | 000010 | 000000 | |
| 23 | PSTLZ_ADDON | IS-M: Extension to 5-Character ZIP Code | PSTLZ_ADDON | | CHAR4 | CHAR | 000004 | 000000 | |
| 24 | ORT01 | IS-M: City | ORT01_ISP | | TEXT35 | CHAR | 000035 | 000000 | |
| 25 | ORT02 | IS-M: City District | ORT02_ISP | | TEXT35 | CHAR | 000035 | 000000 | |
| 26 | PSTL2 | IS-M: Postal Code for PO Box | PLZPF | | PSTLZ | CHAR | 000010 | 000000 | |
| 27 | PSTL2_ADDON | IS-M: Extension to 5-Character ZIP Code (PO Box) | PSTL2_ADDON | | CHAR4 | CHAR | 000004 | 000000 | |
| 28 | PSTL3 | IS-M: Company Postal Code | PSTL3 | | PSTLZ | CHAR | 000010 | 000000 | |
| 29 | PSTL3_ADDON | IS-M: Extension to 5-Character ZIP Code (Company) | PSTL3_ADDON | | CHAR4 | CHAR | 000004 | 000000 | |
| 30 | PFACH | IS-M: Post Office Box | PFACH_ISP | | PFACH_ISP | CHAR | 000010 | 000000 | |
| 31 | ORTPF | IS-M: City for PO Box | ORTPF | | TEXT35 | CHAR | 000035 | 000000 | |
| 32 | STRAS | Street Name | STRAS_ISP | | TEXT35 | CHAR | 000035 | 000000 | |
| 33 | HAUSN | IS-M: House Number | HSNMR1 | | HAUSNUMMER | CHAR | 000010 | 000000 | |
| 34 | HSNMR2 | IS-M: House Number Affix | HSNMR2 | | CHAR8 | CHAR | 000008 | 000000 | |
| 35 | ADRZUS2 | Classification Using a Further Address Affix | ADRZUS2 | | ADRZUS | CHAR | 000006 | 000000 | |
| 36 | STOCK | Floor | STOCK | | STOCK | CHAR | 000006 | 000000 | |
| 37 | LAND1 | Country Key | LAND1 | T005 | LAND1 | CHAR | 000003 | 000000 | |
| 38 | PREDIRECTIONAL | Directional for Street Name | DIRECTIONAL | TJS41 | DIRECTIONAL | CHAR | 000010 | 000000 | |
| 39 | POSTDIRECTIONAL | Directional for Street Name | DIRECTIONAL | TJS41 | DIRECTIONAL | CHAR | 000010 | 000000 | |
| 40 | ADDRSECABBREV | IS-M: Secondary Address Text | ADDRSECABBREV | TJS43 | ADDRSECABBREV | CHAR | 000004 | 000000 | |
| 41 | ADDRSECNUMBER | IS-M: Secondary Address Number | ADDRSECNUMBER | | ADDRSECNUMBER | CHAR | 000008 | 000000 | |
| 42 | STREET2 | IS-M: Second street line | STREET2_ISM | | TEXT35 | CHAR | 000035 | 000000 | |
| 43 | ALIASNAME | IS-M: Alias Text (Street Name + Suffix) | ALIASNAME | | TEXT50 | CHAR | 000050 | 000000 | |
| 44 | ALIASPREDIRECTN | Directional for Street Name | DIRECTIONAL | TJS41 | DIRECTIONAL | CHAR | 000010 | 000000 | |
| 45 | ALIASPOSTDIRECTN | Directional for Street Name | DIRECTIONAL | TJS41 | DIRECTIONAL | CHAR | 000010 | 000000 | |
| 46 | ALIASDELADDRLOW | IS-M: Primary House Number (Lower Limit) | ADDRPRIMLOW | | HAUSNUMMER | CHAR | 000010 | 000000 | |
| 47 | ALIASDELADDRHIGH | IS-M: Primary House Number (Upper Limit) | ADDRPRIMHIGH | | HAUSNUMMER | CHAR | 000010 | 000000 | |
| 48 | ALIASDELODDEVEN | IS-M: Indicator - Even/Odd/All | ODDEVENCODE | | ODDEVENCODE | CHAR | 000001 | 000000 | |
|
|
| 49 | SUCHFELDALIAS | Search field for accessing postal structures w/o matchcode | SUCHFELD | | CHAR40 | CHAR | 000040 | 000000 | |
| 50 | POSTEINORT | IS-M: City Number (Unique) | JALORT | JSTORTPRO | ALORT | CHAR | 000008 | 000000 | |
| 51 | ERSTADR | IS-M: Address Proposal for Alternatives | ERSTADR | | ERSTADR | CHAR | 000001 | 000000 | |
Possible Values | 1 | Address with City/Street | | 2 | PO Box Address | | 3 | Major Customer Postal Code |
|
|
| 52 | POSTEINSTR | IS-M: Street Number | STRASSENNR | JSTSTRPRO | STRASSENNR | CHAR | 000010 | 000000 | |
| 53 | PEINORTPF | IS-M: Postal Unit of City for PO Box | ALORT2 | JSTORTPRO | ALORT | CHAR | 000008 | 000000 | |
| 54 | LOCCO | City Coordinates | LOCCO | | LOCCO | CHAR | 000010 | 000000 | |
| 55 | NIELS | Nielsen ID | NIELS | TNLS | NIELS | CHAR | 000002 | 000000 | |
| 56 | COUNC | County Code | COUNC | T005E | COUNC | CHAR | 000003 | 000000 | |
| 57 | CITYC | City Code | CITYC | T005G | CITYC | CHAR | 000004 | 000000 | |
| 58 | RPMKR | Regional market | RPMKR | | RPMKR | CHAR | 000005 | 000000 | |
| 59 | SORTL | Sort field | SORTL | | CHAR10 | CHAR | 000010 | 000000 | |
| 60 | SORT2 | IS-M: Sort Field 2 (for Internal Use) | SORTL2 | | CHAR20 | CHAR | 000020 | 000000 | |
| 61 | SORT3 | IS-M: Sort field 3 (internal) | SORTL3 | | TEXT30 | CHAR | 000030 | 000000 | |
| 62 | BU_SORT1 | Search term 1 for business partner | BU_SORT1 | | BU_SORT1 | CHAR | 000020 | 000000 | |
| 63 | SPRAS | Language Key | SPRAS | T002 | SPRAS | LANG | 000001 | 000000 | |
| 64 | REGIO | Region (State | REGIO | T005S | REGIO | CHAR | 000003 | 000000 | |
| 65 | TELFP | IS-M: Home Phone Number | TELFP | | TEXT16 | CHAR | 000016 | 000000 | |
| 66 | TELFD | IS-M: Telephone Number at Work | TELFD | | TEXT16 | CHAR | 000016 | 000000 | |
| 67 | TELW1 | IS-M: Additional Telephone Number | TELWT | | TEXT16 | CHAR | 000016 | 000000 | |
| 68 | TELW2 | IS-M: Additional Telephone Number | TELWT | | TEXT16 | CHAR | 000016 | 000000 | |
| 69 | TELW3 | IS-M: Additional Telephone Number | TELWT | | TEXT16 | CHAR | 000016 | 000000 | |
| 70 | TELW4 | IS-M: Mobile Phone Number | TELWF | | TEXT20 | CHAR | 000020 | 000000 | |
| 71 | TELW5 | IS-M: Mobile Phone Number | TELWF | | TEXT20 | CHAR | 000020 | 000000 | |
| 72 | TELFX | Fax Number | TELFX | | TEXT31 | CHAR | 000031 | 000000 | |
| 73 | TELF1 | IS-M: Additional Fax Number | TELFT | | TEXT16 | CHAR | 000016 | 000000 | |
| 74 | TELF2 | IS-M: Additional Fax Number | TELFT | | TEXT16 | CHAR | 000016 | 000000 | |
| 75 | TELF3 | IS-M: Additional Fax Number | TELFT | | TEXT16 | CHAR | 000016 | 000000 | |
| 76 | TELTX | Teletex number | TELTX | | TEXT30 | CHAR | 000030 | 000000 | |
| 77 | TELX1 | Telex number | TELX1 | | TEXT30 | CHAR | 000030 | 000000 | |
| 78 | TELBX | Telebox number | TELBX | | TEXT15 | CHAR | 000015 | 000000 | |
| 79 | DATLT | Data communication line no. | DATLT | | TEXT14 | CHAR | 000014 | 000000 | |
| 80 | STDKO | Default communications service | STDKO_D | | CHAR1 | CHAR | 000001 | 000000 | |
| 81 | GPHERK | IS-M: Business Partner Origin | GPHERK | TJG41 | GPHERK | CHAR | 000002 | 000000 | |
| 82 | GP_REF | IS-M: Business Partner Key | GPNR | JGTGPNR | GPNR | CHAR | 000010 | 000000 | |
| 83 | VBELN_REF | IS-M/SD: Publishing Sales Order | AVNR | JKAK | AVNR | CHAR | 000010 | 000000 | |
| 84 | POSNR_REF | Sales Order Item | APNR | JKAP | APNR | NUMC | 000006 | 000000 | |
| 85 | JPARVW_REF | IS-M: Business Partner Role | JPARVW | TJG39 | JPARVW | CHAR | 000002 | 000000 | |
| 86 | BEABLS_REF | IS-M: Unloading Point | BEABLST | JRTBEABST | BEABLST | CHAR | 000010 | 000000 | |
| 87 | TELFP_COD | IS-M: Home Phone Number | TELFP | | TEXT16 | CHAR | 000016 | 000000 | |
| 88 | TELFD_COD | IS-M: Telephone Number at Work | TELFD | | TEXT16 | CHAR | 000016 | 000000 | |
| 89 | NAME1_MACO | IS-M: Business Partner Name (Upper Case for Matchcode) | NAME1_ISPM | | NAME_MACO | CHAR | 000035 | 000000 | |
| 90 | NAME2_MACO | IS-M: Bus.Partner's First Name (Upper Case for Matchcode) | NAME2_ISPM | | NAME_MACO | CHAR | 000035 | 000000 | |
| 91 | STRAS_MACO | IS-M: Street Name | STRAS_ISPM | | STRAS_MACO | CHAR | 000035 | 000000 | |
| 92 | ORT01_MACO | IS-M/SD: City Name (Upper Case for Matchcode) | ORT01_ISPM | | ORT01_MACO | CHAR | 000035 | 000000 | |
| 93 | ISPTELVWP | IS-M: Area Code (Home) | ISPTELVWP | | ISPTELVW | CHAR | 000010 | 000000 | |
| 94 | ISPTELP | IS-M: Telephone Number | ISPTELP | | ISPTEL | CHAR | 000020 | 000000 | |
| 95 | ISPTELVWD | IS-M: Area Code - Work | ISPTELVWD | | ISPTELVW | CHAR | 000010 | 000000 | |
| 96 | ISPTELD | IS-M: Telephone Number | ISPTELD | | ISPTEL | CHAR | 000020 | 000000 | |
| 97 | ISPHANDY | IS-M: Mobile Phone Number | ISPHANDY | | CHAR30 | CHAR | 000030 | 000000 | |
| 98 | ISPEMAIL | IS-M: E-Mail Address | ISPEMAIL | | CHAR50LOW | CHAR | 000050 | 000000 | |
| 99 | ISPADRBSND | IS-M/SD: Note for Home Delivery to Ship-to Party | ISPADRBSND | | TEXT50 | CHAR | 000050 | 000000 | |
| 100 | TECHNUMZUG | IS-M: Technical Relocation Due to Postal Data Change | TECHNUMZUG | | XFELD | CHAR | 000001 | 000000 | |
|
|
| 101 | XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | | XFELD | CHAR | 000001 | 000000 | |
|
|
| 102 | ALIASLFDNR | IS-M: Sequence Number for Alias Table (Key) | ALIASLFDNR | JSTALIAS | NUMC10 | NUMC | 000010 | 000000 | |
| 103 | XNOCARPERMESS | IS-M: No Change of Carrier When Address Changes | XNOCARPERMESS | | XFELD | CHAR | 000001 | 000000 | |
|
|
| 104 | TXJCD | Tax Jurisdiction | TXJCD | TTXJ | TXJCD | CHAR | 000015 | 000000 | |
| 105 | ANI_TELNRP | Telephone number for determining caller | AD_TELNRCL | | CHAR30 | CHAR | 000030 | 000000 | |
| 106 | ANI_TELNRD | Telephone number for determining caller | AD_TELNRCL | | CHAR30 | CHAR | 000030 | 000000 | |
| 107 | ANI_ISPHANDY | Telephone number for determining caller | AD_TELNRCL | | CHAR30 | CHAR | 000030 | 000000 | |
| 108 | HH_REF | IS-M: Business Partner Number of Household | GPNR_HH | BUT000 | BU_PARTNER | CHAR | 000010 | 000000 | |
| 109 | HH_EXCLUDE | IS-M: Indicator: Exclude Household Assignment | HH_EXCLUDE | | XFELD | CHAR | 000001 | 000000 | |
|
|
| 110 | PRIVACY_STATUS | IS-M: Status of Address As Regards Data Protection | ADDRESS_PRIVACY_STATUS | | ADDRESS_PRIVACY_STATUS | CHAR | 000001 | 000000 | |
Possible Values | No Response from Customer | | Y | Consent from Customer | | N | Refusal from Customer |
|
|
| 111 | ADDRNUMBER | Address number | AD_ADDRNUM | ADRC | AD_ADDRNUM | CHAR | 000010 | 000000 | |
| 112 | PERSNUMBER | Person number | AD_PERSNUM | ADRP | AD_PERSNUM | CHAR | 000010 | 000000 | |