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

CDBD_ADRC Table in SAP | Addresses (central address admin) Table & Fields List

CDBD_ADRC is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of CDBD_ADRC in SAP.

  • Table description : Addresses (central address admin)
  • Module : CRM-BTX
  • Parent Module : CRM
  • Package : CDB_ORDER
  • Software Component : BBPCRM
CDBD_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 CDBD_ADRC Table Fields structure

FieldNoteData ElementDomain
CLIENTClientMANDTMANDT
ADRC_GUIDGuid for ADRC ( address table )CDBT_ADRC_GUIDSYSUUID
ADR_GUIDGuid for ADR(Address table)CDBT_ADR_GUIDSYSUUID
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
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
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
.INCLUDECommunication Fields for Mobile Sales/Service    
TR_USERTransaction UserSMO_TR_USRSMO_TR_USR
TR_IDTransaction IdentifierSMO_TR_IDSMO_TR_ID
TR_STATUSStatus of TransactionSMO_TR_STSSMO_TR_STS
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPTZNTSTMPS
DELETEDMobile Sales DeletedSMO_DELETDSMO_DELETD
TR_ROOTIDIdentifier of BDoc Root objectSMO_RTGUIDSMO_GUID

CDBD_ADRC related tables

TableNote
CDBD_ADR7Remote Mail Addresses(central address admin.)
CDBD_ADRCAddresses (central address admin)
SMOADRCAddresses (central address admin.)
NADRIS-H: Addresses (Central Address Management)
CDBD_ADR10Printers (central address admin.)
CDBD_ADR11SSF (central address admin.)
CDBD_ADR12FTP and URL (central address admin.)
CDBD_ADR13Pager (central address admin.)
CDBD_ADR2Telephone numbers (central address admin.)
CDBD_ADR3Fax numbers (central address admin.)
CDBD_ADR8X400 (central address admin.)
CDBD_ADR9RFC Destinations (central address admin.)
SMOADR2Telephone numbers (central address admin.)
SMOADR3Fax numbers (central address admin.)
SMOADR4Teletex numbers (central address admin.)
Fast update demon admin status TablesReport in concur that list all admin accounts? TablesVendor with multiple addresses TablesCustomer addresses tables in sap TablesDelivery addresses tables in sap TablesCustomer master email addresses TablesVendor master multiple addresses TablesVendor master data email addresses Tables

Latest Table Searches

Sap handling unit packaging material table in SAP
How to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP

Popular Table Searches

Hdfc bank ltd company code for zinghr table in SAP
Link between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP
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