SAP-tabelreferentie

ADRC

Addresses (Business Address Services)

Bekijk een andere tabel

Vul een tabelcode of zoekwoord in om verder te zoeken.

Bekijk de structuur, velden en relaties van SAP-tabel ADRC.

SAP-tabel ADRC heeft 4 primaire sleutelvelden: CLIENT,ADDRNUMBER,DATE_FROM,NATION.

/ Velden

ADRC velden.

102 velden

Veld

Omschrijving

Datatype

Lengte

Decimalen

Checktabel

Data-element

Sleutel CLIENT

Client

CLNT

T000

MANDT

Sleutel ADDRNUMBER

Address Number

CHAR

AD_ADDRNUM

Sleutel DATE_FROM

Valid-from date - in current Release only 00010101 possible

DATS

AD_DATE_FR

Sleutel NATION

Version ID for International Addresses

CHAR

TSADV

AD_NATION

DATE_TO

Valid-to date in current Release only 99991231 possible

DATS

AD_DATE_TO

TITLE

Form-of-Address Key

CHAR

TSAD3

AD_TITLE

NAME1

Name 1

CHAR

AD_NAME1

NAME2

Name 2

CHAR

AD_NAME2

NAME3

Name 3

CHAR

AD_NAME3

NAME4

Name 4

CHAR

AD_NAME4

NAME_TEXT

Converted name field (with form of address)

CHAR

AD_NAMETXT

NAME_CO

c/o name

CHAR

AD_NAME_CO

CITY1

City

CHAR

AD_CITY1

CITY2

District

CHAR

AD_CITY2

CITY_CODE

City code for city/street file

CHAR

ADRCITY

AD_CITYNUM

CITYP_CODE

District code for City and Street file

CHAR

ADRCITYPRT

AD_CITYPNM

HOME_CITY

City (different from postal city)

CHAR

AD_CITY3

CITYH_CODE

Different city for city/street file

CHAR

ADRCITY

AD_CITYHNM

CHCKSTATUS

City file test status

CHAR

AD_CHECKST

REGIOGROUP

Regional structure grouping

CHAR

ADRREGGRP

REGIOGROUP

POST_CODE1

City postal code

CHAR

AD_PSTCD1

POST_CODE2

PO Box Postal Code

CHAR

AD_PSTCD2

POST_CODE3

Company Postal Code (for Large Customers)

CHAR

AD_PSTCD3

PCODE1_EXT

(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code

CHAR

AD_PST1XT

PCODE2_EXT

(Not Supported) PO Box Postal Code Extension

CHAR

AD_PST2XT

PCODE3_EXT

(Not Supported) Major Customer Postal Code Extension

CHAR

AD_PST3XT

PO_BOX

PO Box

CHAR

AD_POBX

DONT_USE_P

PO Box Address Undeliverable Flag

CHAR

TSAD12

AD_NO_USEP

PO_BOX_NUM

Flag: PO Box Without Number

CHAR

AD_POBXNUM

PO_BOX_LOC

PO Box city

CHAR

AD_POBXLOC

CITY_CODE2

City PO box code (City file)

CHAR

ADRCITY

AD_CIT2NUM

PO_BOX_REG

Region for PO Box (Country/Region, State, Province, ...)

CHAR

T005S

AD_POBXREG

PO_BOX_CTY

PO Box of Country/Region

CHAR

T005

AD_POBXCTY

POSTALAREA

(Not Supported) Post Delivery District

CHAR

AD_PSTLAR

TRANSPZONE

Transportation zone to or from which the goods are delivered

CHAR

TZONE

LZONE

STREET

Street

CHAR

AD_STREET

DONT_USE_S

Street Address Undeliverable Flag

CHAR

TSAD12

AD_NO_USES

STREETCODE

Street Number for City/Street File

CHAR

ADRSTREET

AD_STRNUM

STREETABBR

(Not Supported) Abbreviation of Street Name

CHAR

ADRSTRTYPE

AD_STRABBR

HOUSE_NUM1

House Number

CHAR

AD_HSNM1

HOUSE_NUM2

House number supplement

CHAR

AD_HSNM2

HOUSE_NUM3

(Not supported) House Number Range

CHAR

AD_HSNM3

STR_SUPPL1

Street 2

CHAR

AD_STRSPP1

STR_SUPPL2

Street 3

CHAR

AD_STRSPP2

STR_SUPPL3

Street 4

CHAR

AD_STRSPP3

LOCATION

Street 5

CHAR

AD_LCTN

BUILDING

Building (Number or Code)

CHAR

AD_BLDNG

FLOOR

Floor in building

CHAR

AD_FLOOR

ROOMNUMBER

Room or Apartment Number

CHAR

AD_ROOMNUM

COUNTRY

Country/Region Key

CHAR

T005

LAND1

LANGU

Language Key

LANG

T002

SPRAS

REGION

Region (State, Province, County)

CHAR

T005S

REGIO

ADDR_GROUP

Address Group (Key) (Business Address Services)

CHAR

TSAD7

AD_GROUP

FLAGGROUPS

Flag: There are more address group assignments

CHAR

AD_FLGGP

PERS_ADDR

Flag: This is a personal address

CHAR

AD_PRSADDR

SORT1

Search Term 1

CHAR

AD_SORT1

SORT2

Search Term 2

CHAR

AD_SORT2

SORT_PHN

(Not Supported) Phonetic Search Sort Field

CHAR

AD_SRTPHN

DEFLT_COMM

Communication Method (Key) (Business Address Services)

CHAR

TSAC

AD_COMM

TEL_NUMBER

First telephone no.: dialling code+number

CHAR

AD_TLNMBR1

TEL_EXTENS

First Telephone No.: Extension

CHAR

AD_TLXTNS1

FAX_NUMBER

First Fax No.: Area Code + Number

CHAR

AD_FXNMBR1

FAX_EXTENS

First fax no.: extension

CHAR

AD_FXXTNS1

FLAGCOMM2

Flag: Telephone number(s) defined

CHAR

AD_FLGCM02

FLAGCOMM3

Flag: Fax number(s) defined

CHAR

AD_FLGCM03

FLAGCOMM4

Flag: Teletex number(s) defined

CHAR

AD_FLGCM04

FLAGCOMM5

Flag: Telex number(s) defined

CHAR

AD_FLGCM05

FLAGCOMM6

Flag: E-mail address(es) defined

CHAR

AD_FLGCM06

FLAGCOMM7

Flag: RML (remote mail) addresse(s) defined

CHAR

AD_FLGCM07

FLAGCOMM8

Flag: X.400 addresse(s) defined

CHAR

AD_FLGCM08

FLAGCOMM9

Flag: RFC destination(s) defined

CHAR

AD_FLGCM09

FLAGCOMM10

Flag: Printer defined

CHAR

AD_FLGCM10

FLAGCOMM11

Flag: SSF defined

CHAR

AD_FLGCM11

FLAGCOMM12

Flag: URI/FTP address defined

CHAR

AD_FLGCM12

FLAGCOMM13

Flag: Pager address defined

CHAR

AD_FLGCM13

ADDRORIGIN

(Not Supported) Address Data Source (Key)

CHAR

TSAD6

AD_ORIGINA

MC_NAME1

Name (Field NAME1) in Uppercase for Search Help

CHAR

AD_MC_NAME

MC_CITY1

City name in Uppercase for Search Help

CHAR

AD_MC_CITY

MC_STREET

Street Name in Uppercase for Search Help

CHAR

AD_MC_STRT

EXTENSION1

Extension (only for data conversion) (e.g. data line)

CHAR

AD_EXTENS1

EXTENSION2

Extension (only for data conversion) (e.g. telebox)

CHAR

AD_EXTENS2

TIME_ZONE

Address time zone

CHAR

TTZZ

AD_TZONE

TAXJURCODE

Tax Jurisdiction

CHAR

AD_TXJCD

ADDRESS_ID

(Not supported) Physical address ID

CHAR

AD_ADDR_ID

LANGU_CREA

Address record creation original language

LANG

AD_LANGUCR

ADRC_UUID

UUID Used in the Address

RAW

AD_UUID

UUID_BELATED

Indicator: UUID created later

CHAR

AD_UUID_BELATED

ID_CATEGORY

Category of an Address ID

CHAR

AD_ID_CATEGORY

ADRC_ERR_STATUS

Error Status of Address

CHAR

AD_ERR_STATUS

PO_BOX_LOBBY

PO Box Lobby

CHAR

AD_PO_BOX_LBY

DELI_SERV_TYPE

Type of Delivery Service

CHAR

ADDRC_DELI_SERV

AD_DELIVERY_SERVICE_TYPE

DELI_SERV_NUMBER

Number of Delivery Service

CHAR

AD_DELIVERY_SERVICE_NUMBER

COUNTY_CODE

County code for county

CHAR

AD_CNTYNUM

COUNTY

County

CHAR

AD_COUNTY

TOWNSHIP_CODE

Township code for Township

CHAR

AD_TWSHPNUM

TOWNSHIP

Township

CHAR

AD_TOWNSHIP

MC_COUNTY

County name in upper case for search help

CHAR

AD_MC_COUNTY

MC_TOWNSHIP

Township name in upper case for search help

CHAR

AD_MC_TWSHP

XPCPT

Business Purpose Completed Flag

CHAR

AD_XPCPT

_DATAAGING

Data Filter Value for Data Aging

DATS

DATA_TEMPERATURE

DUNS

Dun & Bradstreet number (DUNS)

CHAR

/SAPHT/RN_DUNS

DUNSP4

DUNS+4 number (the last four digit)

CHAR

/SAPHT/RN_DUNSP4

/ Relaties

ADRC relaties.

37 relaties

Tabel	Veld	Checktabel	Omschrijving	Checkveld
ADRC	ADDRORIGIN	TSAD6	Source Address or Personal Data (Business Address Services)	CLIENT
ADRC	ADDRORIGIN	TSAD6	Source Address or Personal Data (Business Address Services)	ORIGIN
ADRC	ADDR_GROUP	TSAD7	Address Groups (Business Address Services)	ADDR_GROUP
ADRC	CITYH_CODE	ADRCITY	Postal cities	COUNTRY
ADRC	CITYH_CODE	ADRCITY	Postal cities	CITY_CODE
ADRC	CITYP_CODE	ADRCITYPRT	Postal districts	CLIENT
ADRC	CITYP_CODE	ADRCITYPRT	Postal districts	COUNTRY
ADRC	CITYP_CODE	ADRCITYPRT	Postal districts	CITY_CODE
ADRC	CITY_CODE	ADRCITY	Postal cities	COUNTRY
ADRC	CITY_CODE	ADRCITY	Postal cities	CITY_CODE
ADRC	CITY_CODE2	ADRCITY	Postal cities	COUNTRY
ADRC	CITY_CODE2	ADRCITY	Postal cities	CITY_CODE
ADRC	CLIENT	T000	Clients	MANDT
ADRC	COUNTRY	T005	Countries	MANDT
ADRC	COUNTRY	T005	Countries	LAND1
ADRC	DEFLT_COMM	TSAC	Communication Methods (Business Address Services)	COMM_TYPE
ADRC	DELI_SERV_TYPE	ADDRC_DELI_SERV	Address Service Types	CLIENT
ADRC	DELI_SERV_TYPE	ADDRC_DELI_SERV	Address Service Types	DELI_SERV_TYPE
ADRC	DONT_USE_P	TSAD12	Reasons for Non-Delivery (Business Address Services)	CLIENT
ADRC	DONT_USE_P	TSAD12	Reasons for Non-Delivery (Business Address Services)	UNDELIVER
ADRC	DONT_USE_S	TSAD12	Reasons for Non-Delivery (Business Address Services)	CLIENT
ADRC	DONT_USE_S	TSAD12	Reasons for Non-Delivery (Business Address Services)	UNDELIVER
ADRC	PO_BOX_CTY	T005	Countries	MANDT
ADRC	PO_BOX_CTY	T005	Countries	LAND1
ADRC	PO_BOX_REG	T005S	Taxes: Region (Province) Key	LAND1
ADRC	REGIOGROUP	ADRREGGRP	Regional structure grouping	CLIENT
ADRC	REGION	T005S	Taxes: Region (Province) Key	LAND1
ADRC	STREETABBR	ADRSTRTYPE	Street type	CLIENT
ADRC	STREETABBR	ADRSTRTYPE	Street type	COUNTRY
ADRC	STREETCODE	ADRSTREET	Streets	CLIENT
ADRC	STREETCODE	ADRSTREET	Streets	COUNTRY
ADRC	STREETCODE	ADRSTREET	Streets	STRT_CODE
ADRC	TIME_ZONE	TTZZ	Time zones	TZONE
ADRC	TITLE	TSAD3	Forms of Address (Key) (Business Address Services)	TITLE
ADRC	TRANSPZONE	TZONE	Customers: Regional zones	MANDT
ADRC	TRANSPZONE	TZONE	Customers: Regional zones	LAND1
ADRC	TRANSPZONE	TZONE	Customers: Regional zones	ZONE1

Terug naar SAP-tabellen