SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

ADRC Table in SAP | Addresses (Business Address Services) Table & Fields List

ADRC is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of ADRC in SAP.

  • Table description : Addresses (Business Address Services)
  • Module : BC-SRV-ADR
  • Parent Module : BC
  • Package : SZAD
  • Software Component : SAP_BASIS
ADRC table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP ADRC Table Fields structure

FieldNoteData ElementDomain
CLIENTClientMANDTMANDT
ADDRNUMBERAddress numberAD_ADDRNUMAD_ADDRNUM
DATE_FROMValid-from date - in current Release only 00010101 possibleAD_DATE_FRDATUM
NATIONVersion ID for International AddressesAD_NATIONAD_NATION
DATE_TOValid-to date in current Release only 99991231 possibleAD_DATE_TODATUM
TITLEForm-of-Address KeyAD_TITLEAD_TITLE
NAME1Name 1AD_NAME1TEXT40
NAME2Name 2AD_NAME2TEXT40
NAME3Name 3AD_NAME3TEXT40
NAME4Name 4AD_NAME4TEXT40
NAME_TEXTConverted name field (with form of address)AD_NAMETXTTEXT50
NAME_COc/o nameAD_NAME_COTEXT40
CITY1CityAD_CITY1TEXT40
CITY2DistrictAD_CITY2TEXT40
CITY_CODECity code for city/street fileAD_CITYNUMCITY_CODE
CITYP_CODEDistrict code for City and Street fileAD_CITYPNMCITYP_CODE
HOME_CITYCity (different from postal city)AD_CITY3TEXT40
CITYH_CODEDifferent city for city/street fileAD_CITYHNMCITY_CODE
CHCKSTATUSCity file test statusAD_CHECKSTAD_CHECKST
REGIOGROUPRegional structure groupingREGIOGROUPREGIOGROUP
POST_CODE1City postal codeAD_PSTCD1CHAR10
POST_CODE2PO Box postal codeAD_PSTCD2CHAR10
POST_CODE3Company postal code (for large customers)AD_PSTCD3CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 CodeAD_PST1XTCHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code ExtensionAD_PST2XTCHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code ExtensionAD_PST3XTCHAR10
PO_BOXPO BoxAD_POBXCHAR10
DONT_USE_PPO Box Address Undeliverable FlagAD_NO_USEPAD_NO_USE
PO_BOX_NUMFlag: PO Box without numberAD_POBXNUMXFELD
PO_BOX_LOCPO Box cityAD_POBXLOCTEXT40
CITY_CODE2City PO box code (City file)AD_CIT2NUMCITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...)AD_POBXREGREGIO
PO_BOX_CTYPO box countryAD_POBXCTYLAND1
POSTALAREA(Not Supported) Post Delivery DistrictAD_PSTLARTEXT15
TRANSPZONETransportation zone to or from which the goods are deliveredLZONEZONE
STREETStreetAD_STREETTEXT60
DONT_USE_SStreet Address Undeliverable FlagAD_NO_USESAD_NO_USE
STREETCODEStreet Number for City/Street FileAD_STRNUMSTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street NameAD_STRABBRSTRTYPEAB
HOUSE_NUM1House NumberAD_HSNM1TEXT10
HOUSE_NUM2House number supplementAD_HSNM2TEXT10
HOUSE_NUM3(Not supported) House Number RangeAD_HSNM3TEXT10
STR_SUPPL1Street 2AD_STRSPP1TEXT40
STR_SUPPL2Street 3AD_STRSPP2TEXT40
STR_SUPPL3Street 4AD_STRSPP3TEXT40
LOCATIONStreet 5AD_LCTNTEXT40
BUILDINGBuilding (Number or Code)AD_BLDNGTEXT20
FLOORFloor in buildingAD_FLOORTEXT10
ROOMNUMBERRoom or Appartment NumberAD_ROOMNUMTEXT10
COUNTRYCountry KeyLAND1LAND1
LANGULanguage KeySPRASSPRAS
REGIONRegion (State, Province, County)REGIOREGIO
ADDR_GROUPAddress Group (Key) (Business Address Services)AD_GROUPAD_GROUP
FLAGGROUPSFlag: There are more address group assignmentsAD_FLGGPXFELD
PERS_ADDRFlag: This is a personal addressAD_PRSADDRXFELD
SORT1Search Term 1AD_SORT1CHAR20
SORT2Search Term 2AD_SORT2CHAR20
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR20
DEFLT_COMMCommunication Method (Key) (Business Address Services)AD_COMMAD_COMM
TEL_NUMBERFirst telephone no.: dialling code+numberAD_TLNMBR1CHAR30
TEL_EXTENSFirst Telephone No.: ExtensionAD_TLXTNS1CHAR10
FAX_NUMBERFirst fax no.: dialling code+numberAD_FXNMBR1CHAR30
FAX_EXTENSFirst fax no.: extensionAD_FXXTNS1CHAR10
FLAGCOMM2Flag: Telephone number(s) maintainedAD_FLGCM02XFELD
FLAGCOMM3Flag: Fax number(s) maintainedAD_FLGCM03XFELD
FLAGCOMM4Flag: Teletex number(s) maintainedAD_FLGCM04XFELD
FLAGCOMM5Flag: Telex number(s) maintainedAD_FLGCM05XFELD
FLAGCOMM6Indicator: E-Mail Address(es) MaintainedAD_FLGCM06XFELD
FLAGCOMM7Flag: RML (remote mail) addresse(s) maintainedAD_FLGCM07XFELD
FLAGCOMM8Flag: X.400 addresse(s) maintainedAD_FLGCM08XFELD
FLAGCOMM9Flag: RFC destination(s) maintainedAD_FLGCM09XFELD
FLAGCOMM10Flag: Printer maintainedAD_FLGCM10XFELD
FLAGCOMM11Flag: SSF maintainedAD_FLGCM11XFELD
FLAGCOMM12Flag: URI/FTP address maintainedAD_FLGCM12XFELD
FLAGCOMM13Flag: Pager address maintainedAD_FLGCM13XFELD
ADDRORIGIN(Not Supported) Address Data Source (Key)AD_ORIGINAAD_ORIGIN
MC_NAME1Name (field NAME1) in upper case for matchcodeAD_MC_NAMECHAR25
MC_CITY1City name in upper case for search helpAD_MC_CITYCHAR25
MC_STREETStreet name in upper case for search helpAD_MC_STRTCHAR25
EXTENSION1Extension (only for data conversion) (e.g. data line)AD_EXTENS1TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox)AD_EXTENS2TEXT40
TIME_ZONEAddress time zoneAD_TZONETZNZONE
TAXJURCODETax JurisdictionAD_TXJCDAD_TXJCD
ADDRESS_ID(Not supported) Physical address IDAD_ADDR_IDAD_ADDR_ID
LANGU_CREAAddress record creation original languageAD_LANGUCRSPRAS
ADRC_UUIDUUID Used in the AddressAD_UUIDSYSUUID
UUID_BELATEDIndicator: UUID was generated laterAD_UUID_BELATEDAD_UUID_BELATED
ID_CATEGORYCategory of an Address IDAD_ID_CATEGORYAD_ID_CATEGORY
ADRC_ERR_STATUSError Status of AddressAD_ERR_STATUSAD_ERR_STATUS
PO_BOX_LOBBYPO Box LobbyAD_PO_BOX_LBYTEXT40
DELI_SERV_TYPEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPEAD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR10
COUNTY_CODECounty code for countyAD_CNTYNUMCNTY_CODE
COUNTYCountyAD_COUNTYTEXT40
TOWNSHIP_CODETownship code for TownshipAD_TWSHPNUMTWSHP_CODE
TOWNSHIPTownshipAD_TOWNSHIPTEXT40
MC_COUNTYCounty name in upper case for search helpAD_MC_COUNTYCHAR25
MC_TOWNSHIPTownship name in upper case for search helpAD_MC_TWSHPCHAR25
XPCPTBusiness Purpose Completed FlagAD_XPCPTAD_XPCPT

ADRC related tables

TableNote
ADR6E-Mail Addresses (Business Address Services)
ADR7SShadow Table: RML Addresses (Business Address Services)
ADR7S2Shadow Table 2: RML Addresses (Business Address Services)
ADRCAddresses (Business Address Services)
ADRCSShadow Table: Addresses (Business Address Services)
ADRCS2Shadow Table 2: Addresses (Business Address Services)
T7ARM5My Simplification: Business activity addresses/addresses
ADCPPerson/Address Assignment (Business Address Services)
ADRCTAddress Texts (Business Address Services)
ADRCTS2Shadow Table 2: Address Texts (Business Address Services)
ADRVAddress Where-Used List (Business Address Services)
TSAD3Forms of Address (Key) (Business Address Services)
TSAD6Source Address or Personal Data (Business Address Services)
TSAD7Address Groups (Business Address Services)
TSAD7TDescription of Address Groups (Business Address Services)
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com