SAP PIQ_ADDRESS table - Application: Address (Central Address Mgmt) details in SAP


SAP PIQ_ADDRESS table summary

Object Name: PIQ_ADDRESS
Dictionary Type: Structure
Description: Application: Address (Central Address Mgmt)


Field list for PIQ_ADDRESS table on an S/4 SAP system

Details
PIQ_ADDRESS-C_O_NAME table field - c/o name

Description: c/o name
Field Name: C_O_NAME
Data Element: AD_NAME_CO
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field C_O_NAME

PIQ_ADDRESS-CITY table field - City

Description: City
Field Name: CITY
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY

PIQ_ADDRESS-DISTRICT table field - District

Description: District
Field Name: DISTRICT
Data Element: AD_CITY2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CITY_PART
SHLP Field: CITY_PART
ConvExit:

See all SAP tables containing field DISTRICT

PIQ_ADDRESS-REGIOGROUP table field - Regional structure grouping

Description: Regional structure grouping
Field Name: REGIOGROUP
Data Element: REGIOGROUP
Data Type: CHAR
length (Dec): 8(0)
Check table: ADRREGGRP
Conversion Routine:
Domain Name: REGIOGROUP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGIOGROUP

PIQ_ADDRESS-POSTAL_CD table field - Postal Code

Description: Postal Code
Field Name: POSTAL_CD
Data Element: PD_PSTLZ
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: PSTLZ
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTAL_CD

PIQ_ADDRESS-POSTL_COD1 table field - City postal code

Description: City postal code
Field Name: POSTL_COD1
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTL_COD1

PIQ_ADDRESS-POSTL_COD2 table field - PO Box Postal Code

Description: PO Box Postal Code
Field Name: POSTL_COD2
Data Element: AD_PSTCD2
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTL_COD2

PIQ_ADDRESS-POSTL_COD3 table field - Company Postal Code (for Large Customers)

Description: Company Postal Code (for Large Customers)
Field Name: POSTL_COD3
Data Element: AD_PSTCD3
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTL_COD3

PIQ_ADDRESS-PCODE1_EXT table field - (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code

Description: (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
Field Name: PCODE1_EXT
Data Element: AD_PST1XT
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCODE1_EXT

PIQ_ADDRESS-PCODE2_EXT table field - (Not Supported) PO Box Postal Code Extension

Description: (Not Supported) PO Box Postal Code Extension
Field Name: PCODE2_EXT
Data Element: AD_PST2XT
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCODE2_EXT

PIQ_ADDRESS-PCODE3_EXT table field - (Not Supported) Major Customer Postal Code Extension

Description: (Not Supported) Major Customer Postal Code Extension
Field Name: PCODE3_EXT
Data Element: AD_PST3XT
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCODE3_EXT

PIQ_ADDRESS-PO_BOX table field - PO Box

Description: PO Box
Field Name: PO_BOX
Data Element: AD_POBX
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX

PIQ_ADDRESS-PO_W_O_NO table field - Flag: PO Box Without Number

Description: Flag: PO Box Without Number
Field Name: PO_W_O_NO
Data Element: AD_POBXNUM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_W_O_NO

PIQ_ADDRESS-PO_BOX_CIT table field - PO Box city

Description: PO Box city
Field Name: PO_BOX_CIT
Data Element: AD_POBXLOC
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CITY_NAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field PO_BOX_CIT

PIQ_ADDRESS-PO_BOX_REG table field - Region for PO Box (Country/Region, State, Province, ...)

Description: Region for PO Box (Country/Region, State, Province, ...)
Field Name: PO_BOX_REG
Data Element: AD_POBXREG
Data Type: CHAR
length (Dec): 3(0)
Check table: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_REG

PIQ_ADDRESS-POBOX_CTRY table field - PO Box of Country/Region

Description: PO Box of Country/Region
Field Name: POBOX_CTRY
Data Element: AD_POBXCTY
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POBOX_CTRY

PIQ_ADDRESS-STREET table field - Street

Description: Street
Field Name: STREET
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET

PIQ_ADDRESS-STR_ABBR table field - (Not Supported) Abbreviation of Street Name

Description: (Not Supported) Abbreviation of Street Name
Field Name: STR_ABBR
Data Element: AD_STRABBR
Data Type: CHAR
length (Dec): 2(0)
Check table: ADRSTRTYPE
Conversion Routine:
Domain Name: STRTYPEAB
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STR_ABBR

PIQ_ADDRESS-HOUSE_NO table field - House Number

Description: House Number
Field Name: HOUSE_NO
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NO

PIQ_ADDRESS-HOUSE_NO2 table field - House number supplement

Description: House number supplement
Field Name: HOUSE_NO2
Data Element: AD_HSNM2
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NO2

PIQ_ADDRESS-HOUSE_NO3 table field - (Not supported) House Number Range

Description: (Not supported) House Number Range
Field Name: HOUSE_NO3
Data Element: AD_HSNM3
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NO3

PIQ_ADDRESS-STR_SUPPL1 table field - Street 2

Description: Street 2
Field Name: STR_SUPPL1
Data Element: AD_STRSPP1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STR_SUPPL1

PIQ_ADDRESS-STR_SUPPL2 table field - Street 3

Description: Street 3
Field Name: STR_SUPPL2
Data Element: AD_STRSPP2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STR_SUPPL2

PIQ_ADDRESS-STR_SUPPL3 table field - Street 4

Description: Street 4
Field Name: STR_SUPPL3
Data Element: AD_STRSPP3
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STR_SUPPL3

PIQ_ADDRESS-LOCATION table field - Street 5

Description: Street 5
Field Name: LOCATION
Data Element: AD_LCTN
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCATION

PIQ_ADDRESS-BUILDING table field - Building (Number or Code)

Description: Building (Number or Code)
Field Name: BUILDING
Data Element: AD_BLDNG
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUILDING

PIQ_ADDRESS-FLOOR table field - Floor in building

Description: Floor in building
Field Name: FLOOR
Data Element: AD_FLOOR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLOOR

PIQ_ADDRESS-ROOM_NO table field - Room or Apartment Number

Description: Room or Apartment Number
Field Name: ROOM_NO
Data Element: AD_ROOMNUM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOM_NO

PIQ_ADDRESS-COUNTRY table field - Country/Region Key

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

PIQ_ADDRESS-REGION table field - Region (State, Province, County)

Description: Region (State, Province, County)
Field Name: REGION
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

PIQ_ADDRESS-TIME_ZONE table field - Address time zone

Description: Address time zone
Field Name: TIME_ZONE
Data Element: AD_TZONE
Data Type: CHAR
length (Dec): 6(0)
Check table: TTZZ
Conversion Routine:
Domain Name: TZNZONE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME_ZONE

PIQ_ADDRESS-TAXJURCODE table field - Tax Jurisdiction

Description: Tax Jurisdiction
Field Name: TAXJURCODE
Data Element: AD_TXJCD
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: AD_TXJCD
MemoryID: TXJ
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAXJURCODE

PIQ_ADDRESS-HOME_CITY table field - City (different from postal city)

Description: City (different from postal city)
Field Name: HOME_CITY
Data Element: AD_CITY3
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOME_CITY

PIQ_ADDRESS-COUNTRY_TL table field - Country/Region for Telephone/Fax Number

Description: Country/Region for Telephone/Fax Number
Field Name: COUNTRY_TL
Data Element: AD_COMCTRY
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY_TL

PIQ_ADDRESS-STD_NO_TL table field - Standard Sender Address in this Communication Type

Description: Standard Sender Address in this Communication Type
Field Name: STD_NO_TL
Data Element: AD_FLGDFNR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STD_NO_TL

PIQ_ADDRESS-TELEPHONE_TL table field - Telephone no.: dialling code+number

Description: Telephone no.: dialling code+number
Field Name: TELEPHONE_TL
Data Element: AD_TLNMBR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELEPHONE_TL

PIQ_ADDRESS-TEL_NO table field - Telephone Number

Description: Telephone Number
Field Name: TEL_NO
Data Element: TELENR
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEL_NO

PIQ_ADDRESS-EXTENSION_TL table field - Telephone no.: Extension

Description: Telephone no.: Extension
Field Name: EXTENSION_TL
Data Element: AD_TLXTNS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENSION_TL

PIQ_ADDRESS-HOME_FLAG_TL table field - Recipient address in this communication type (mail sys.grp)

Description: Recipient address in this communication type (mail sys.grp)
Field Name: HOME_FLAG_TL
Data Element: AD_FLGHOME
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOME_FLAG_TL

PIQ_ADDRESS-CONSNUMBER_TL table field - Sequence Number

Description: Sequence Number
Field Name: CONSNUMBER_TL
Data Element: AD_CONSNUM
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: NUMC3
MemoryID:
AppClass: QSS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONSNUMBER_TL

PIQ_ADDRESS-STD_NO_SP table field - Standard Sender Address in this Communication Type

Description: Standard Sender Address in this Communication Type
Field Name: STD_NO_SP
Data Element: AD_FLGDFNR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STD_NO_SP

PIQ_ADDRESS-E_MAIL_SP table field - E-Mail Address

Description: E-Mail Address
Field Name: E_MAIL_SP
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field E_MAIL_SP

PIQ_ADDRESS-ENCODE_SP table field - Required Data Encoding (E-Mail)

Description: Required Data Encoding (E-Mail)
Field Name: ENCODE_SP
Data Element: AD_ENCODE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AD_ENCODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENCODE_SP

PIQ_ADDRESS-TNEF_SP table field - Flag: Receiver can receive TNEF encoding by SMTP

Description: Flag: Receiver can receive TNEF encoding by SMTP
Field Name: TNEF_SP
Data Element: AD_TNEF6
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TNEF_SP

PIQ_ADDRESS-HOME_FLAG_SP table field - Recipient address in this communication type (mail sys.grp)

Description: Recipient address in this communication type (mail sys.grp)
Field Name: HOME_FLAG_SP
Data Element: AD_FLGHOME
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOME_FLAG_SP

PIQ_ADDRESS-CONSNUMBER_SP table field - Sequence Number

Description: Sequence Number
Field Name: CONSNUMBER_SP
Data Element: AD_CONSNUM
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: NUMC3
MemoryID:
AppClass: QSS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONSNUMBER_SP

PIQ_ADDRESS-FAX_NO table field - Fax Number

Description: Fax Number
Field Name: FAX_NO
Data Element: FAXNR
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAX_NO

PIQ_ADDRESS-LANGU table field - Language Key

Description: Language Key
Field Name: LANGU
Data Element: SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table:
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID: SPR
AppClass: STXD
SHLP: H_T002
SHLP Field: SPRAS
ConvExit: ISOLA

See all SAP tables containing field LANGU

PIQ_ADDRESS-VALIDFROMDATE table field - Validity Date (Valid From)

Description: Validity Date (Valid From)
Field Name: VALIDFROMDATE
Data Element: BU_DATFROM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALIDFROMDATE

PIQ_ADDRESS-VALIDTODATE table field - Validity Date (Valid To)

Description: Validity Date (Valid To)
Field Name: VALIDTODATE
Data Element: BU_DATTO
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALIDTODATE

PIQ_ADDRESS-ADDRESS_ID table field - Address Identification Number (ISR)

Description: Address Identification Number (ISR)
Field Name: ADDRESS_ID
Data Element: PIQADDRESSID
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUMC2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS_ID

PIQ_ADDRESS-ADDRESSTYPE table field - Address Type

Description: Address Type
Field Name: ADDRESSTYPE
Data Element: BU_ADRKIND
Data Type: CHAR
length (Dec): 10(0)
Check table: TB009
Conversion Routine:
Domain Name: BU_ADRKIND
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESSTYPE

PIQ_ADDRESS-STANDARDADDRESSUSAGE table field - Indicator: Standard Address Usage

Description: Indicator: Standard Address Usage
Field Name: STANDARDADDRESSUSAGE
Data Element: BU_XDFADU
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STANDARDADDRESSUSAGE

PIQ_ADDRESS-ADDRESSID table field - Address Identification Number (ISR)

Description: Address Identification Number (ISR)
Field Name: ADDRESSID
Data Element: PIQADDRESSID
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUMC2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESSID


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table