ISM_PDF_ADDRESS SAP (Address Data) Structure details
Description: Address Data
Related tables to ISM_PDF_ADDRESS
Access table ISM_PDF_ADDRESS
Structure field list including key, data, relationships and ABAP select examples
ISM_PDF_ADDRESS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Address Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ISM_PDF_ADDRESS TYPE ISM_PDF_ADDRESS.
The ISM_PDF_ADDRESS table consists of various fields, each holding specific information or linking keys about Address Data data available in SAP. These include ADRS (), ANRED (Title), NAME1 (Name 1 of an address), NAME2 (Name 2 of an address).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP ISM_PDF_ADDRESS structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ADDRESS_SENDER | 0 | ||||||||
ADRS | 0 | ||||||||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 of an address | NAME1_ADRS | CHAR | 40 | TEXT40 | ||||
NAME2 | Name 2 of an address | NAME2_ADRS | CHAR | 40 | TEXT40 | ||||
NAME3 | Name 3 of an address | NAME3_ADRS | CHAR | 40 | TEXT40 | ||||
NAME4 | Name 4 of an address | NAME4_ADRS | CHAR | 40 | TEXT40 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO box | PFACH_BAS | CHAR | 10 | PFACH | ||||
PSTL2 | PO Box postal code | PSTL2_BAS | CHAR | 10 | PSTLZ | ||||
PFORT | PO Box city | PFORT_ADRS | CHAR | 40 | TEXT40 | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
PSTLZ | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
INLND | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
ANZZL | Number of lines in address | ANZEI | DEC | 2 | ANZEI | ||||
PRIOR | Address lines priority | PRITY_ADRS | CHAR | 9 | CHAR9 | ||||
WAREN | Delivery address ID | WAREN | CHAR | 1 | WAREN | ||||
LINE0 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE1 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE2 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE3 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE4 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE5 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE6 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE7 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE8 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE9 | Address line | LINES | CHAR | 80 | LINES | ||||
LINEK | Address line | LINES | CHAR | 80 | LINES | ||||
LINED | Address line | LINES | CHAR | 80 | LINES | ||||
LINED0 | Address line | LINES | CHAR | 80 | LINES | ||||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
COMMDATA | 0 | ||||||||
EMAIL_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
FAX_COUNTRY | Country for telephone/fax number | AD_COMCTRY | CHAR | 3 | LAND1 | LND | |||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
TELNR | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30 | CHAR30 | ||||
ADDRESS_RECEIVER | 0 | ||||||||
JGTSADR | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
ADRNR | IS-M: Address Number | JADRNR | CHAR | 10 | ALPHA | JADRNR | |||
UVADR_ST | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
UVADR_PF | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
UVADR_GK | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
HERK | IS-M: Use of Address | HERK | CHAR | 1 | HERK | ||||
XADRLOE | IS-M: Deletion Flag for Address | XLOES | CHAR | 1 | XFELD | ||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
ANRED | Form of Address Key | JANRED | CHAR | 2 | ALPHA | JANRED | JGA | ||
NAME1 | IS-M: Business Partner Name | NAME1_ISP | CHAR | 35 | NAME | ||||
NAME2 | IS-M: First Name of Business Partner | NAME2_ISP | CHAR | 35 | NAME | ||||
NAME3 | IS-M: Further Name Field for Business Partner | NAME3_ISP | CHAR | 35 | NAME | ||||
NAME4 | IS-M: Further Name Field for Business Partner | NAME4_ISP | CHAR | 35 | NAME | ||||
TITEL | IS-M: Title | TITEL_ISP | CHAR | 15 | TITEL | ||||
NAMZU | IS-M: Name Affix | NAMZU_ISP | CHAR | 15 | TITEL | ||||
VORSW | IS-M: Name Prefix | VORSW_ISP | CHAR | 15 | TITEL | ||||
PSTLZ | IS-M: Postal Code | PLZ_ISP | CHAR | 10 | PSTLZ | ||||
PSTLZ_ADDON | IS-M: Extension to 5-Character ZIP Code | PSTLZ_ADDON | CHAR | 4 | CHAR4 | ||||
ORT01 | IS-M: City | ORT01_ISP | CHAR | 35 | TEXT35 | ||||
ORT02 | IS-M: City District | ORT02_ISP | CHAR | 35 | TEXT35 | ||||
PSTL2 | IS-M: Postal Code for PO Box | PLZPF | CHAR | 10 | PSTLZ | ||||
PSTL2_ADDON | IS-M: Extension to 5-Character ZIP Code (PO Box) | PSTL2_ADDON | CHAR | 4 | CHAR4 | ||||
PSTL3 | IS-M: Company Postal Code | PSTL3 | CHAR | 10 | PSTLZ | ||||
PSTL3_ADDON | IS-M: Extension to 5-Character ZIP Code (Company) | PSTL3_ADDON | CHAR | 4 | CHAR4 | ||||
PFACH | IS-M: Post Office Box | PFACH_ISP | CHAR | 10 | ALPHA | PFACH_ISP | |||
ORTPF | IS-M: City for PO Box | ORTPF | CHAR | 35 | TEXT35 | ||||
STRAS | Street Name | STRAS_ISP | CHAR | 35 | TEXT35 | ||||
HAUSN | IS-M: House Number | HSNMR1 | CHAR | 10 | HAUSNUMMER | ||||
HSNMR2 | IS-M: House Number Affix | HSNMR2 | CHAR | 8 | CHAR8 | ||||
ADRZUS2 | Classification Using a Further Address Affix | ADRZUS2 | CHAR | 6 | ADRZUS | ||||
STOCK | Floor | STOCK | CHAR | 6 | STOCK | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
PREDIRECTIONAL | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
POSTDIRECTIONAL | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ADDRSECABBREV | IS-M: Secondary Address Text | ADDRSECABBREV | CHAR | 4 | ADDRSECABBREV | ||||
ADDRSECNUMBER | IS-M: Secondary Address Number | ADDRSECNUMBER | CHAR | 8 | ALPHA | ADDRSECNUMBER | |||
STREET2 | IS-M: Second street line | STREET2_ISM | CHAR | 35 | TEXT35 | ||||
ALIASNAME | IS-M: Alias Text (Street Name + Suffix) | ALIASNAME | CHAR | 50 | TEXT50 | ||||
ALIASPREDIRECTN | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ALIASPOSTDIRECTN | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ALIASDELADDRLOW | IS-M: Primary House Number (Lower Limit) | ADDRPRIMLOW | CHAR | 10 | HAUSNUMMER | ||||
ALIASDELADDRHIGH | IS-M: Primary House Number (Upper Limit) | ADDRPRIMHIGH | CHAR | 10 | HAUSNUMMER | ||||
ALIASDELODDEVEN | IS-M: Indicator - Even/Odd/All | ODDEVENCODE | CHAR | 1 | ODDEVENCODE | ||||
SUCHFELDALIAS | Search field for accessing postal structures w/o matchcode | SUCHFELD | CHAR | 40 | CHAR40 | ||||
POSTEINORT | IS-M: City Number (Unique) | JALORT | CHAR | 8 | ALPHA | ALORT | JSO | ||
ERSTADR | IS-M: Address Proposal for Alternatives | ERSTADR | CHAR | 1 | ERSTADR | ||||
POSTEINSTR | IS-M: Street Number | STRASSENNR | CHAR | 10 | ALPHA | STRASSENNR | JSS | ||
PEINORTPF | IS-M: Postal Unit of City for PO Box | ALORT2 | CHAR | 8 | ALPHA | ALORT | |||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
NIELS | Nielsen ID | NIELS | CHAR | 2 | NIELS | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
RPMKR | Regional Market | RPMKR | CHAR | 5 | RPMKR | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
SORT2 | IS-M: Sort Field 2 (for Internal Use) | SORTL2 | CHAR | 20 | CHAR20 | ||||
SORT3 | IS-M: Sort field 3 (internal) | SORTL3 | CHAR | 30 | TEXT30 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
TELFP | IS-M: Home Phone Number | TELFP | CHAR | 16 | TEXT16 | ||||
TELFD | IS-M: Telephone Number at Work | TELFD | CHAR | 16 | TEXT16 | ||||
TELW1 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW2 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW3 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW4 | IS-M: Mobile Phone Number | TELWF | CHAR | 20 | TEXT20 | ||||
TELW5 | IS-M: Mobile Phone Number | TELWF | CHAR | 20 | TEXT20 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELF1 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELF2 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELF3 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
STDKO | Default communications service | STDKO_D | CHAR | 1 | CHAR1 | ||||
GPHERK | IS-M: Business Partner Origin | GPHERK | CHAR | 2 | ALPHA | GPHERK | |||
GP_REF | IS-M: Business Partner Key | GPNR | CHAR | 10 | ALPHA | GPNR | JGP | MJG0 | |
VBELN_REF | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | ALPHA | AVNR | JK1 | MJK1 | |
POSNR_REF | Sales Order Item | APNR | NUMC | 6 | APNR | ||||
JPARVW_REF | IS-M: Business Partner Role | JPARVW | CHAR | 2 | PARVW | JPARVW | JGR | ||
BEABLS_REF | IS-M: Unloading Point | BEABLST | CHAR | 10 | ALPHA | BEABLST | BAS | MJV2 | |
TELFP_COD | IS-M: Home Phone Number | TELFP | CHAR | 16 | TEXT16 | ||||
TELFD_COD | IS-M: Telephone Number at Work | TELFD | CHAR | 16 | TEXT16 | ||||
NAME1_MACO | IS-M: Business Partner Name (Upper Case for Matchcode) | NAME1_ISPM | CHAR | 35 | JYTNF | NAME_MACO | |||
NAME2_MACO | IS-M: Bus.Partner's First Name (Upper Case for Matchcode) | NAME2_ISPM | CHAR | 35 | JYTNF | NAME_MACO | |||
STRAS_MACO | IS-M: Street Name | STRAS_ISPM | CHAR | 35 | JYTNF | STRAS_MACO | |||
ORT01_MACO | IS-M/SD: City Name (Upper Case for Matchcode) | ORT01_ISPM | CHAR | 35 | JYTNF | ORT01_MACO | |||
ISPTELVWP | IS-M: Area Code (Home) | ISPTELVWP | CHAR | 10 | TELN2 | ISPTELVW | |||
ISPTELP | IS-M: Telephone Number | ISPTELP | CHAR | 20 | TELN1 | ISPTEL | |||
ISPTELVWD | IS-M: Area Code - Work | ISPTELVWD | CHAR | 10 | TELN2 | ISPTELVW | |||
ISPTELD | IS-M: Telephone Number | ISPTELD | CHAR | 20 | TELN1 | ISPTEL | |||
ISPHANDY | IS-M: Mobile Phone Number | ISPHANDY | CHAR | 30 | CHAR30 | ||||
ISPEMAIL | IS-M: E-Mail Address | ISPEMAIL | CHAR | 50 | CHAR50LOW | ||||
ISPADRBSND | IS-M/SD: Note for Home Delivery to Ship-to Party | ISPADRBSND | CHAR | 50 | TEXT50 | ||||
TECHNUMZUG | IS-M: Technical Relocation Due to Postal Data Change | TECHNUMZUG | CHAR | 1 | XFELD | ||||
XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | CHAR | 1 | XFELD | ||||
ALIASLFDNR | IS-M: Sequence Number for Alias Table (Key) | ALIASLFDNR | NUMC | 10 | NUMC10 | ||||
XNOCARPERMESS | IS-M: No Change of Carrier When Address Changes | XNOCARPERMESS | CHAR | 1 | XFELD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TXJCD | TXJ | |||
ANI_TELNRP | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
ANI_TELNRD | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
ANI_ISPHANDY | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
HH_REF | IS-M: Business Partner Number of Household | GPNR_HH | CHAR | 10 | ALPHA | BU_PARTNER | |||
HH_EXCLUDE | IS-M: Indicator: Exclude Household Assignment | HH_EXCLUDE | CHAR | 1 | XFELD | ||||
PRIVACY_STATUS | IS-M: Status of Address As Regards Data Protection | ADDRESS_PRIVACY_STATUS | CHAR | 1 | ADDRESS_PRIVACY_STATUS | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
COMMDATA | 0 | ||||||||
EMAIL_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
FAX_COUNTRY | Country for telephone/fax number | AD_COMCTRY | CHAR | 3 | LAND1 | LND | |||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
ADDRESS_LINES | 0 | ||||||||
USED_LINES | IS-M: Number of Lines That Can Be Printed | JANZZL | DEC | 2 | DEC2 | ||||
LINE0 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE1 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE2 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE3 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE4 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE5 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE6 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE7 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE8 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE9 | Address line | LINES | CHAR | 80 | LINES | ||||
LINEK | Address line | LINES | CHAR | 80 | LINES | ||||
LINED | Address line | LINES | CHAR | 80 | LINES | ||||
LINED0 | Address line | LINES | CHAR | 80 | LINES | ||||
NAME_LONG | Text Field | TEXT50 | CHAR | 50 | TEXT50 | ||||
BPARTNER | 0 | ||||||||
BUT000 | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
.INCLU--AP | 0 | ||||||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
.INCLU--AP | 0 | ||||||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
.INCLU--AP | 0 | ||||||||
JGVDB_GP | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
GPNR | IS-M: Business Partner Key | GPNR | CHAR | 10 | ALPHA | GPNR | JGP | MJG0 | |
XGPLOE | IS-M: Deletion Flag for General Business Partner | JXLV_GP | CHAR | 1 | XFELD | ||||
XGPLOEKZ | IS-M: Deletion Indicator (Role-Specific) | XLOESCHKZ | CHAR | 1 | XFELD | ||||
XGPSPE | IS-M/SD: Lock Indicator for General Business Partner | XGPSPE | CHAR | 1 | XFELD | ||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
JKTOKD | IS-M: Business Partner Account Group | JKTOKD | CHAR | 4 | ALPHA | JKTOKD | JGK | ||
MAILN | IS-M: Mail Address | JMAILN | CHAR | 12 | SO_OBJ_NAM | ||||
BERUFSL | IS-M: Occupation | BERUFSL | CHAR | 8 | ALPHA | BERUFSL | |||
JBRSCH | Industry key | BRSCH | CHAR | 4 | BRSCH | ||||
JGEBDAT | IS-M: Date of Birth of a Business Partner | JGEBDAT | DATS | 8 | DATUM | ||||
GESCH | IS-M: Gender Key | JGESCHL | CHAR | 1 | JGESCHL | ||||
JFAMST | IS-M: Business Partner's Marital Status | JFAMST | CHAR | 1 | JFAMST | ||||
GPHERK | IS-M: Business Partner Origin | GPHERK | CHAR | 2 | ALPHA | GPHERK | |||
XNATUR | IS-M: Natural Person Indicator | XNATUR | CHAR | 1 | XFELD | ||||
XVERMSACH | IS-M: BP Authorized to Receive Gifts | XVERMSACH | CHAR | 1 | XFELD | ||||
XOHNE | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
XDEBI | IS-M: Indicator: Customer Exists | JXDEBI | CHAR | 1 | XFELD | ||||
KUNNR | IS-M: Customer Number in Previous System | JKUNNR | CHAR | 10 | ALPHA | KUNNR | |||
FKUNNR | IS-M: Customer Number in Non-SAP System | JFKUNNR | CHAR | 10 | ALPHA | KUNNR | |||
XKREDI | IS-M: Indicator: Vendor Exists | XKREDI | CHAR | 1 | XFELD | ||||
LIFNR | IS-M: Vendor Number in Previous System | JLIFNR | CHAR | 10 | ALPHA | LIFNR | |||
FLIFNR | IS-M: Vendor Number in Non-SAP System | JFLIFNR | CHAR | 10 | ALPHA | LIFNR | |||
XMITARB | IS-M: Employee Indicator | XMITARB | CHAR | 1 | XFELD | ||||
PERNR | IS-M: Personnel Number | JPERNR2 | CHAR | 20 | JPERNR | ||||
XNOWERB | IS-M: No Advertising | XNOWERB | CHAR | 1 | XFELD | ||||
RECHZENTNR | IS-M: WBZ, Computer Center Number | JWBZRZNR | CHAR | 2 | JKWBZ | JWBZRZNR | |||
WBZKUNNR | IS-M: WBZ, VDZ Number of WBZ Company | JWBZKUNNR | CHAR | 6 | JKWBZ | JWBZKUNNR | |||
ADDR_CONV | Time-Dependent Business Partner Addresses Converted | ISM_ADDR_CONV | CHAR | 1 | ISM_ADDR_CONV | ||||
ADDRESS_OLD | 0 | ||||||||
JGTSADR | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
ADRNR | IS-M: Address Number | JADRNR | CHAR | 10 | ALPHA | JADRNR | |||
UVADR_ST | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
UVADR_PF | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
UVADR_GK | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
HERK | IS-M: Use of Address | HERK | CHAR | 1 | HERK | ||||
XADRLOE | IS-M: Deletion Flag for Address | XLOES | CHAR | 1 | XFELD | ||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
ANRED | Form of Address Key | JANRED | CHAR | 2 | ALPHA | JANRED | JGA | ||
NAME1 | IS-M: Business Partner Name | NAME1_ISP | CHAR | 35 | NAME | ||||
NAME2 | IS-M: First Name of Business Partner | NAME2_ISP | CHAR | 35 | NAME | ||||
NAME3 | IS-M: Further Name Field for Business Partner | NAME3_ISP | CHAR | 35 | NAME | ||||
NAME4 | IS-M: Further Name Field for Business Partner | NAME4_ISP | CHAR | 35 | NAME | ||||
TITEL | IS-M: Title | TITEL_ISP | CHAR | 15 | TITEL | ||||
NAMZU | IS-M: Name Affix | NAMZU_ISP | CHAR | 15 | TITEL | ||||
VORSW | IS-M: Name Prefix | VORSW_ISP | CHAR | 15 | TITEL | ||||
PSTLZ | IS-M: Postal Code | PLZ_ISP | CHAR | 10 | PSTLZ | ||||
PSTLZ_ADDON | IS-M: Extension to 5-Character ZIP Code | PSTLZ_ADDON | CHAR | 4 | CHAR4 | ||||
ORT01 | IS-M: City | ORT01_ISP | CHAR | 35 | TEXT35 | ||||
ORT02 | IS-M: City District | ORT02_ISP | CHAR | 35 | TEXT35 | ||||
PSTL2 | IS-M: Postal Code for PO Box | PLZPF | CHAR | 10 | PSTLZ | ||||
PSTL2_ADDON | IS-M: Extension to 5-Character ZIP Code (PO Box) | PSTL2_ADDON | CHAR | 4 | CHAR4 | ||||
PSTL3 | IS-M: Company Postal Code | PSTL3 | CHAR | 10 | PSTLZ | ||||
PSTL3_ADDON | IS-M: Extension to 5-Character ZIP Code (Company) | PSTL3_ADDON | CHAR | 4 | CHAR4 | ||||
PFACH | IS-M: Post Office Box | PFACH_ISP | CHAR | 10 | ALPHA | PFACH_ISP | |||
ORTPF | IS-M: City for PO Box | ORTPF | CHAR | 35 | TEXT35 | ||||
STRAS | Street Name | STRAS_ISP | CHAR | 35 | TEXT35 | ||||
HAUSN | IS-M: House Number | HSNMR1 | CHAR | 10 | HAUSNUMMER | ||||
HSNMR2 | IS-M: House Number Affix | HSNMR2 | CHAR | 8 | CHAR8 | ||||
ADRZUS2 | Classification Using a Further Address Affix | ADRZUS2 | CHAR | 6 | ADRZUS | ||||
STOCK | Floor | STOCK | CHAR | 6 | STOCK | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
PREDIRECTIONAL | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
POSTDIRECTIONAL | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ADDRSECABBREV | IS-M: Secondary Address Text | ADDRSECABBREV | CHAR | 4 | ADDRSECABBREV | ||||
ADDRSECNUMBER | IS-M: Secondary Address Number | ADDRSECNUMBER | CHAR | 8 | ALPHA | ADDRSECNUMBER | |||
STREET2 | IS-M: Second street line | STREET2_ISM | CHAR | 35 | TEXT35 | ||||
ALIASNAME | IS-M: Alias Text (Street Name + Suffix) | ALIASNAME | CHAR | 50 | TEXT50 | ||||
ALIASPREDIRECTN | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ALIASPOSTDIRECTN | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ALIASDELADDRLOW | IS-M: Primary House Number (Lower Limit) | ADDRPRIMLOW | CHAR | 10 | HAUSNUMMER | ||||
ALIASDELADDRHIGH | IS-M: Primary House Number (Upper Limit) | ADDRPRIMHIGH | CHAR | 10 | HAUSNUMMER | ||||
ALIASDELODDEVEN | IS-M: Indicator - Even/Odd/All | ODDEVENCODE | CHAR | 1 | ODDEVENCODE | ||||
SUCHFELDALIAS | Search field for accessing postal structures w/o matchcode | SUCHFELD | CHAR | 40 | CHAR40 | ||||
POSTEINORT | IS-M: City Number (Unique) | JALORT | CHAR | 8 | ALPHA | ALORT | JSO | ||
ERSTADR | IS-M: Address Proposal for Alternatives | ERSTADR | CHAR | 1 | ERSTADR | ||||
POSTEINSTR | IS-M: Street Number | STRASSENNR | CHAR | 10 | ALPHA | STRASSENNR | JSS | ||
PEINORTPF | IS-M: Postal Unit of City for PO Box | ALORT2 | CHAR | 8 | ALPHA | ALORT | |||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
NIELS | Nielsen ID | NIELS | CHAR | 2 | NIELS | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
RPMKR | Regional Market | RPMKR | CHAR | 5 | RPMKR | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
SORT2 | IS-M: Sort Field 2 (for Internal Use) | SORTL2 | CHAR | 20 | CHAR20 | ||||
SORT3 | IS-M: Sort field 3 (internal) | SORTL3 | CHAR | 30 | TEXT30 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
TELFP | IS-M: Home Phone Number | TELFP | CHAR | 16 | TEXT16 | ||||
TELFD | IS-M: Telephone Number at Work | TELFD | CHAR | 16 | TEXT16 | ||||
TELW1 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW2 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW3 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW4 | IS-M: Mobile Phone Number | TELWF | CHAR | 20 | TEXT20 | ||||
TELW5 | IS-M: Mobile Phone Number | TELWF | CHAR | 20 | TEXT20 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELF1 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELF2 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELF3 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
STDKO | Default communications service | STDKO_D | CHAR | 1 | CHAR1 | ||||
GPHERK | IS-M: Business Partner Origin | GPHERK | CHAR | 2 | ALPHA | GPHERK | |||
GP_REF | IS-M: Business Partner Key | GPNR | CHAR | 10 | ALPHA | GPNR | JGP | MJG0 | |
VBELN_REF | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | ALPHA | AVNR | JK1 | MJK1 | |
POSNR_REF | Sales Order Item | APNR | NUMC | 6 | APNR | ||||
JPARVW_REF | IS-M: Business Partner Role | JPARVW | CHAR | 2 | PARVW | JPARVW | JGR | ||
BEABLS_REF | IS-M: Unloading Point | BEABLST | CHAR | 10 | ALPHA | BEABLST | BAS | MJV2 | |
TELFP_COD | IS-M: Home Phone Number | TELFP | CHAR | 16 | TEXT16 | ||||
TELFD_COD | IS-M: Telephone Number at Work | TELFD | CHAR | 16 | TEXT16 | ||||
NAME1_MACO | IS-M: Business Partner Name (Upper Case for Matchcode) | NAME1_ISPM | CHAR | 35 | JYTNF | NAME_MACO | |||
NAME2_MACO | IS-M: Bus.Partner's First Name (Upper Case for Matchcode) | NAME2_ISPM | CHAR | 35 | JYTNF | NAME_MACO | |||
STRAS_MACO | IS-M: Street Name | STRAS_ISPM | CHAR | 35 | JYTNF | STRAS_MACO | |||
ORT01_MACO | IS-M/SD: City Name (Upper Case for Matchcode) | ORT01_ISPM | CHAR | 35 | JYTNF | ORT01_MACO | |||
ISPTELVWP | IS-M: Area Code (Home) | ISPTELVWP | CHAR | 10 | TELN2 | ISPTELVW | |||
ISPTELP | IS-M: Telephone Number | ISPTELP | CHAR | 20 | TELN1 | ISPTEL | |||
ISPTELVWD | IS-M: Area Code - Work | ISPTELVWD | CHAR | 10 | TELN2 | ISPTELVW | |||
ISPTELD | IS-M: Telephone Number | ISPTELD | CHAR | 20 | TELN1 | ISPTEL | |||
ISPHANDY | IS-M: Mobile Phone Number | ISPHANDY | CHAR | 30 | CHAR30 | ||||
ISPEMAIL | IS-M: E-Mail Address | ISPEMAIL | CHAR | 50 | CHAR50LOW | ||||
ISPADRBSND | IS-M/SD: Note for Home Delivery to Ship-to Party | ISPADRBSND | CHAR | 50 | TEXT50 | ||||
TECHNUMZUG | IS-M: Technical Relocation Due to Postal Data Change | TECHNUMZUG | CHAR | 1 | XFELD | ||||
XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | CHAR | 1 | XFELD | ||||
ALIASLFDNR | IS-M: Sequence Number for Alias Table (Key) | ALIASLFDNR | NUMC | 10 | NUMC10 | ||||
XNOCARPERMESS | IS-M: No Change of Carrier When Address Changes | XNOCARPERMESS | CHAR | 1 | XFELD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TXJCD | TXJ | |||
ANI_TELNRP | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
ANI_TELNRD | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
ANI_ISPHANDY | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
HH_REF | IS-M: Business Partner Number of Household | GPNR_HH | CHAR | 10 | ALPHA | BU_PARTNER | |||
HH_EXCLUDE | IS-M: Indicator: Exclude Household Assignment | HH_EXCLUDE | CHAR | 1 | XFELD | ||||
PRIVACY_STATUS | IS-M: Status of Address As Regards Data Protection | ADDRESS_PRIVACY_STATUS | CHAR | 1 | ADDRESS_PRIVACY_STATUS | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
COMMDATA | 0 | ||||||||
EMAIL_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
FAX_COUNTRY | Country for telephone/fax number | AD_COMCTRY | CHAR | 3 | LAND1 | LND | |||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
ADDRESS_LINES | 0 | ||||||||
USED_LINES | IS-M: Number of Lines That Can Be Printed | JANZZL | DEC | 2 | DEC2 | ||||
LINE0 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE1 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE2 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE3 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE4 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE5 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE6 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE7 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE8 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE9 | Address line | LINES | CHAR | 80 | LINES | ||||
LINEK | Address line | LINES | CHAR | 80 | LINES | ||||
LINED | Address line | LINES | CHAR | 80 | LINES | ||||
LINED0 | Address line | LINES | CHAR | 80 | LINES | ||||
NAME_LONG | Text Field | TEXT50 | CHAR | 50 | TEXT50 | ||||
ADDRESS_NEW | 0 | ||||||||
JGTSADR | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
ADRNR | IS-M: Address Number | JADRNR | CHAR | 10 | ALPHA | JADRNR | |||
UVADR_ST | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
UVADR_PF | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
UVADR_GK | IS-M: Coding Status of Address | UVADR_AD | CHAR | 1 | UVADR_AD | ||||
HERK | IS-M: Use of Address | HERK | CHAR | 1 | HERK | ||||
XADRLOE | IS-M: Deletion Flag for Address | XLOES | CHAR | 1 | XFELD | ||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
ANRED | Form of Address Key | JANRED | CHAR | 2 | ALPHA | JANRED | JGA | ||
NAME1 | IS-M: Business Partner Name | NAME1_ISP | CHAR | 35 | NAME | ||||
NAME2 | IS-M: First Name of Business Partner | NAME2_ISP | CHAR | 35 | NAME | ||||
NAME3 | IS-M: Further Name Field for Business Partner | NAME3_ISP | CHAR | 35 | NAME | ||||
NAME4 | IS-M: Further Name Field for Business Partner | NAME4_ISP | CHAR | 35 | NAME | ||||
TITEL | IS-M: Title | TITEL_ISP | CHAR | 15 | TITEL | ||||
NAMZU | IS-M: Name Affix | NAMZU_ISP | CHAR | 15 | TITEL | ||||
VORSW | IS-M: Name Prefix | VORSW_ISP | CHAR | 15 | TITEL | ||||
PSTLZ | IS-M: Postal Code | PLZ_ISP | CHAR | 10 | PSTLZ | ||||
PSTLZ_ADDON | IS-M: Extension to 5-Character ZIP Code | PSTLZ_ADDON | CHAR | 4 | CHAR4 | ||||
ORT01 | IS-M: City | ORT01_ISP | CHAR | 35 | TEXT35 | ||||
ORT02 | IS-M: City District | ORT02_ISP | CHAR | 35 | TEXT35 | ||||
PSTL2 | IS-M: Postal Code for PO Box | PLZPF | CHAR | 10 | PSTLZ | ||||
PSTL2_ADDON | IS-M: Extension to 5-Character ZIP Code (PO Box) | PSTL2_ADDON | CHAR | 4 | CHAR4 | ||||
PSTL3 | IS-M: Company Postal Code | PSTL3 | CHAR | 10 | PSTLZ | ||||
PSTL3_ADDON | IS-M: Extension to 5-Character ZIP Code (Company) | PSTL3_ADDON | CHAR | 4 | CHAR4 | ||||
PFACH | IS-M: Post Office Box | PFACH_ISP | CHAR | 10 | ALPHA | PFACH_ISP | |||
ORTPF | IS-M: City for PO Box | ORTPF | CHAR | 35 | TEXT35 | ||||
STRAS | Street Name | STRAS_ISP | CHAR | 35 | TEXT35 | ||||
HAUSN | IS-M: House Number | HSNMR1 | CHAR | 10 | HAUSNUMMER | ||||
HSNMR2 | IS-M: House Number Affix | HSNMR2 | CHAR | 8 | CHAR8 | ||||
ADRZUS2 | Classification Using a Further Address Affix | ADRZUS2 | CHAR | 6 | ADRZUS | ||||
STOCK | Floor | STOCK | CHAR | 6 | STOCK | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
PREDIRECTIONAL | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
POSTDIRECTIONAL | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ADDRSECABBREV | IS-M: Secondary Address Text | ADDRSECABBREV | CHAR | 4 | ADDRSECABBREV | ||||
ADDRSECNUMBER | IS-M: Secondary Address Number | ADDRSECNUMBER | CHAR | 8 | ALPHA | ADDRSECNUMBER | |||
STREET2 | IS-M: Second street line | STREET2_ISM | CHAR | 35 | TEXT35 | ||||
ALIASNAME | IS-M: Alias Text (Street Name + Suffix) | ALIASNAME | CHAR | 50 | TEXT50 | ||||
ALIASPREDIRECTN | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ALIASPOSTDIRECTN | Directional for Street Name | DIRECTIONAL | CHAR | 10 | DIRECTIONAL | ||||
ALIASDELADDRLOW | IS-M: Primary House Number (Lower Limit) | ADDRPRIMLOW | CHAR | 10 | HAUSNUMMER | ||||
ALIASDELADDRHIGH | IS-M: Primary House Number (Upper Limit) | ADDRPRIMHIGH | CHAR | 10 | HAUSNUMMER | ||||
ALIASDELODDEVEN | IS-M: Indicator - Even/Odd/All | ODDEVENCODE | CHAR | 1 | ODDEVENCODE | ||||
SUCHFELDALIAS | Search field for accessing postal structures w/o matchcode | SUCHFELD | CHAR | 40 | CHAR40 | ||||
POSTEINORT | IS-M: City Number (Unique) | JALORT | CHAR | 8 | ALPHA | ALORT | JSO | ||
ERSTADR | IS-M: Address Proposal for Alternatives | ERSTADR | CHAR | 1 | ERSTADR | ||||
POSTEINSTR | IS-M: Street Number | STRASSENNR | CHAR | 10 | ALPHA | STRASSENNR | JSS | ||
PEINORTPF | IS-M: Postal Unit of City for PO Box | ALORT2 | CHAR | 8 | ALPHA | ALORT | |||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
NIELS | Nielsen ID | NIELS | CHAR | 2 | NIELS | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
RPMKR | Regional Market | RPMKR | CHAR | 5 | RPMKR | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
SORT2 | IS-M: Sort Field 2 (for Internal Use) | SORTL2 | CHAR | 20 | CHAR20 | ||||
SORT3 | IS-M: Sort field 3 (internal) | SORTL3 | CHAR | 30 | TEXT30 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
TELFP | IS-M: Home Phone Number | TELFP | CHAR | 16 | TEXT16 | ||||
TELFD | IS-M: Telephone Number at Work | TELFD | CHAR | 16 | TEXT16 | ||||
TELW1 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW2 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW3 | IS-M: Additional Telephone Number | TELWT | CHAR | 16 | TEXT16 | ||||
TELW4 | IS-M: Mobile Phone Number | TELWF | CHAR | 20 | TEXT20 | ||||
TELW5 | IS-M: Mobile Phone Number | TELWF | CHAR | 20 | TEXT20 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELF1 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELF2 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELF3 | IS-M: Additional Fax Number | TELFT | CHAR | 16 | TEXT16 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
STDKO | Default communications service | STDKO_D | CHAR | 1 | CHAR1 | ||||
GPHERK | IS-M: Business Partner Origin | GPHERK | CHAR | 2 | ALPHA | GPHERK | |||
GP_REF | IS-M: Business Partner Key | GPNR | CHAR | 10 | ALPHA | GPNR | JGP | MJG0 | |
VBELN_REF | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | ALPHA | AVNR | JK1 | MJK1 | |
POSNR_REF | Sales Order Item | APNR | NUMC | 6 | APNR | ||||
JPARVW_REF | IS-M: Business Partner Role | JPARVW | CHAR | 2 | PARVW | JPARVW | JGR | ||
BEABLS_REF | IS-M: Unloading Point | BEABLST | CHAR | 10 | ALPHA | BEABLST | BAS | MJV2 | |
TELFP_COD | IS-M: Home Phone Number | TELFP | CHAR | 16 | TEXT16 | ||||
TELFD_COD | IS-M: Telephone Number at Work | TELFD | CHAR | 16 | TEXT16 | ||||
NAME1_MACO | IS-M: Business Partner Name (Upper Case for Matchcode) | NAME1_ISPM | CHAR | 35 | JYTNF | NAME_MACO | |||
NAME2_MACO | IS-M: Bus.Partner's First Name (Upper Case for Matchcode) | NAME2_ISPM | CHAR | 35 | JYTNF | NAME_MACO | |||
STRAS_MACO | IS-M: Street Name | STRAS_ISPM | CHAR | 35 | JYTNF | STRAS_MACO | |||
ORT01_MACO | IS-M/SD: City Name (Upper Case for Matchcode) | ORT01_ISPM | CHAR | 35 | JYTNF | ORT01_MACO | |||
ISPTELVWP | IS-M: Area Code (Home) | ISPTELVWP | CHAR | 10 | TELN2 | ISPTELVW | |||
ISPTELP | IS-M: Telephone Number | ISPTELP | CHAR | 20 | TELN1 | ISPTEL | |||
ISPTELVWD | IS-M: Area Code - Work | ISPTELVWD | CHAR | 10 | TELN2 | ISPTELVW | |||
ISPTELD | IS-M: Telephone Number | ISPTELD | CHAR | 20 | TELN1 | ISPTEL | |||
ISPHANDY | IS-M: Mobile Phone Number | ISPHANDY | CHAR | 30 | CHAR30 | ||||
ISPEMAIL | IS-M: E-Mail Address | ISPEMAIL | CHAR | 50 | CHAR50LOW | ||||
ISPADRBSND | IS-M/SD: Note for Home Delivery to Ship-to Party | ISPADRBSND | CHAR | 50 | TEXT50 | ||||
TECHNUMZUG | IS-M: Technical Relocation Due to Postal Data Change | TECHNUMZUG | CHAR | 1 | XFELD | ||||
XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | CHAR | 1 | XFELD | ||||
ALIASLFDNR | IS-M: Sequence Number for Alias Table (Key) | ALIASLFDNR | NUMC | 10 | NUMC10 | ||||
XNOCARPERMESS | IS-M: No Change of Carrier When Address Changes | XNOCARPERMESS | CHAR | 1 | XFELD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TXJCD | TXJ | |||
ANI_TELNRP | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
ANI_TELNRD | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
ANI_ISPHANDY | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | CHAR30 | ||||
HH_REF | IS-M: Business Partner Number of Household | GPNR_HH | CHAR | 10 | ALPHA | BU_PARTNER | |||
HH_EXCLUDE | IS-M: Indicator: Exclude Household Assignment | HH_EXCLUDE | CHAR | 1 | XFELD | ||||
PRIVACY_STATUS | IS-M: Status of Address As Regards Data Protection | ADDRESS_PRIVACY_STATUS | CHAR | 1 | ADDRESS_PRIVACY_STATUS | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
COMMDATA | 0 | ||||||||
EMAIL_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
FAX_COUNTRY | Country for telephone/fax number | AD_COMCTRY | CHAR | 3 | LAND1 | LND | |||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
ADDRESS_LINES | 0 | ||||||||
USED_LINES | IS-M: Number of Lines That Can Be Printed | JANZZL | DEC | 2 | DEC2 | ||||
LINE0 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE1 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE2 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE3 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE4 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE5 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE6 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE7 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE8 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE9 | Address line | LINES | CHAR | 80 | LINES | ||||
LINEK | Address line | LINES | CHAR | 80 | LINES | ||||
LINED | Address line | LINES | CHAR | 80 | LINES | ||||
LINED0 | Address line | LINES | CHAR | 80 | LINES | ||||
NAME_LONG | Text Field | TEXT50 | CHAR | 50 | TEXT50 | ||||
VALID_FROM | Valid-From Date | GUELTIGVON | DATS | 8 | DATUM | JSA |
Key field | Non-key field |
How do I retrieve data from SAP structure ISM_PDF_ADDRESS using ABAP code?
As ISM_PDF_ADDRESS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ISM_PDF_ADDRESS as there is no data to select.How to access SAP table ISM_PDF_ADDRESS
Within an ECC or HANA version of SAP you can also view further information about ISM_PDF_ADDRESS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects