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

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

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

  • Table description : Addresses (central address admin.)
  • Module : CRM-MSA
  • Parent Module : CRM
  • Package : SMO3
  • Software Component : BBPCRM
SMOADRC 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 SMOADRC Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
SFAADRCSFA Key of AddressSMO_SFAADCSMO_GUID
SFAKNA1SFA Key of Business PartnerSMO_SFAKN1SMO_GUID
SFAKVBEZ6SFA Key of IL. Business Partner - Business PartnerSMO_SFAZ06SMO_GUID
KUNNRCustomer numberSMO3KUNNRSMO3KUNNR
SOURCE_CSource of an objectSMO_SOURCESMO_SOURCE
ADDRNUMBERAddress numberAD_ADDRNUMAD_ADDRNUM
PERSNUMBERPerson numberAD_PERSNUMAD_PERSNUM
NATIONVersion ID for International AddressesAD_NATIONAD_NATION
DATE_FROMValid-from date - in current Release only 00010101 possibleAD_DATE_FRDATUM
DATE_TOValid-to date in current Release only 99991231 possibleAD_DATE_TODATUM
ADR_KINDKind of AddressSMO_ADRKNDSMO_TXT10
ADRCDFLTAddress is Default Address of Business PartnerSMO_ADRCDTSMO_ADRCDT
PERSADDRFlag: Address is private Address (local object)SMO_PERADRSMO_LOGICL
NMAILAdvertising material indicatorSMO3NMAILXFELD
NAME1Name 1AD_NAME1TEXT40
NAME2Name 2AD_NAME2TEXT40
NAME3Name 3AD_NAME3TEXT40
NAME4Name 4AD_NAME4TEXT40
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
POST_CODE1City postal codeAD_PSTCD1CHAR10
POST_CODE2PO Box postal codeAD_PSTCD2CHAR10
POST_CODE3Company postal code (for large customers)AD_PSTCD3CHAR10
PO_BOXPO BoxAD_POBXCHAR10
PO_BOX_NUMFlag: PO Box without numberAD_POBXNUMXFELD
PO_BOX_LOCPO Box cityAD_POBXLOCTEXT40
PO_BOX_CTYPO box countryAD_POBXCTYLAND1
POSTALAREA(Not Supported) Post Delivery DistrictAD_PSTLARTEXT15
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_BLDNG_PTEXT10
FLOORFloor in buildingAD_FLOORTEXT10
ROOMNUMBERRoom or Appartment NumberAD_ROOMNUMTEXT10
DEPARTMENTDepartmentAD_DPRTMNTTEXT40
FUNCTIONFunctionAD_FNCTNTEXT40
COUNTRYCountry KeyLAND1LAND1
REGIONRegion (State, Province, County)REGIOREGIO
COUNCCounty codeSMO3COUNCSMO3COUNC
TRANSPZONETransportation zone to or from which the goods are deliveredLZONEZONE
LANGULanguageSMO_LANGUSMO_LANGU
ADDR_GROUPAddress Group (Key) (Business Address Services)AD_GROUPAD_GROUP
SORT1Search Term 1AD_SORT1CHAR20
SORT2Search Term 2AD_SORT2CHAR20
DEFLT_COMMCommunication Method (Key) (Business Address Services)AD_COMMAD_COMM
ADDRORIGIN(Not Supported) Address Data Source (Key)AD_ORIGINAAD_ORIGIN
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
STCD1Tax number 1SMO3STCD1SMO3STCD1
STCD2Tax number 2SMO3STCD2SMO3STCD2
STCEGVAT registration numberSMO3STCEGSMO3STCEG
STKZAIndicator: Business partner subject to equalization tax ?SMO3STKZASMO3STKZA
STKZUIndicator: Business partner subject to tax on sales/purch. ?SMO3STKZUXFELD
STKZNIndicator: Business partner a sole proprietor ?SMO3STKZNSMO3STKZN
SO_KEYSAP-Office keyAD_SO_KEYAD_SO_KEY
TEL_NUMBERTelephone no.: dialling code+numberAD_TLNMBRCHAR30
TEL_EXTENSTelephone no.: ExtensionAD_TLXTNSCHAR10
TELNR_LONGComplete number: dialling code+number+extensionAD_TELNRLGCHAR30
FAX_NUMBERFax number: dialling code+numberAD_FXNMBRCHAR30
FAX_EXTENSFax no.: ExtensionAD_FXXTNSCHAR10
FAXNR_LONGComplete number: dialling code+number+extensionAD_FXNRLNGCHAR30
TTX_NUMBERTeletex numberAD_TTXNMBRTEXT30
TLX_NUMBERTelex numberAD_TLXNMBRTEXT30
SMTP_ADDRE-Mail AddressAD_SMTPADRAD_SMTPADR
ADRCH1Free Choice Field on Customer's DemandSMO_CHOI2SMO_TXT2
ADRCH2Free Choice Field on Customer's DemandSMO_CHOI2SMO_TXT2
ADRCH3Free Choice Field on Customer's DemandSMO_CHOI2SMO_TXT2
FLAG1FlagSMO_FLAG1SMO_TEXT1
KVMICBRICKBrick CodesSMOBRCKCODSMO_BRCKCD
KVBRICKBrick CodesSMOBRCKCODSMO_BRCKCD
KVNANBRICKBrick CodesSMOBRCKCODSMO_BRCKCD
KVTOURTourSMO_KVTOURSMO_TXT2
NON_GUIDNot Guided RecordSMO_NGUIDSMO_NGUID
.INCLUDERecord Modification Fields for Mobile Sales/Service    
ERFASSDate of Creation.SMO_CREATESMO_DATE
GEAENDDate last ModifiedSMO_MODIFYSMO_DATE
BEARBRecord Edited by User NameSMO_BEARBSMO_BEARB
.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
SFAVBPAGlobal Unique IdentifierSMO_GUIDSMO_GUID
SFAVBAKSFA Key of Sales DocumentSMO_SFAVBKSMO_GUID
SFAVBAPSFA Key of the Sales Document ItemSMO_SFAVBPSMO_GUID
VBELNSales documentSMO3VBELN2SMO3VBELN
POSNRSales document itemSMO3POSNR2SMO3POSNR
POSEXItem number of the underlying customer purchase orderSMO3POSEXSMO3POSEX
STCDTTax Number Category of FI: For Using FI Tax ChecksSMO3BPTAXTSMO3J_1ATO
PARTNERZGP-Partner NumberSMO_PARTNRSMO_PARTNR

SMOADRC 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.)
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