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

CDBD_ADRP Table in SAP | Persons (central address administration.) Table & Fields List

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

  • Table description : Persons (central address administration.)
  • Module : CRM-BTX
  • Parent Module : CRM
  • Package : CDB_ORDER
  • Software Component : BBPCRM
CDBD_ADRP 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_ADRP Table Fields structure

FieldNoteData ElementDomain
CLIENTClientMANDTMANDT
ADRP_GUIDGuid for ADRP ( address table )CDBT_ADRP_GUIDSYSUUID
ADR_GUIDGuid for ADR(Address table)CDBT_ADR_GUIDSYSUUID
PERSNUMBERPerson numberAD_PERSNUMAD_PERSNUM
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
NAME_FIRSTFirst nameAD_NAMEFIRTEXT40
NAME_LASTLast nameAD_NAMELASTEXT40
NAME2Name of person at birthAD_NAME2_PTEXT40
NAMEMIDDLEMiddle name or second forename of a personAD_NAMEMIDTEXT40
NAME_LAST2Second surname of a personAD_NAMLAS2TEXT40
NAME_TEXTFull Name of PersonAD_NAMTEXTTEXT80
CONVERTEDStatus of Field 'Full Name' NAME_TEXTAD_NAMCONVAD_NAMCONV
TITLE_ACA1Academic Title: KeyAD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key)AD_TITLE2AD_TITLE1
PREFIX1Name Prefix (Key)AD_PREFIXAD_PREFIX
PREFIX22nd name prefix (key)AD_PREFIX2AD_PREFIX
TITLE_SPPLName supplement, e.g. noble title (key)AD_TITLESAD_TITLES
NICKNAMENickname or name usedAD_NICKNAMTEXT40
INITIALS"Middle Initial" or personal initialsAD_INITSCHAR10
NAMEFORMATName formatAD_FORMATAD_NAMFORM
NAMCOUNTRYCountry for name format ruleAD_NAMCTRYLAND1
PROFESSIONProfessionAD_PROFESSTEXT40
SEXGender keyAD_SEXAD_SEX
LANGULanguage KeySPRASSPRAS
PERS_GROUPPerson Group (Key) (Business Address Services)AD_GROUP_PAD_GROUP_P
FLAGGROUPSFlag: There are other person group assignmentsAD_FLGGP_PXFELD
SORT1Search Term 1AD_SORT1CHAR20
SORT2Search Term 2AD_SORT2CHAR20
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR20
ADDR_COMP(not used)AD_ADDRCOMAD_ADDRNUM
ADDR_PERS(not used)AD_ADDRPERAD_ADDRNUM
FLPERSTELFlag: person has personal telephone numbersAD_FLPTELXFELD
FLPERSCOMMFlag: Person has personal comm. numbers (apart from Tel.)AD_FLPCOMMXFELD
PERSORIGINPersonal data source (key)AD_ORIGINPAD_ORIGIN
MC_NAMEFIRFirst name in upper case for search helpAD_MC_NMFICHAR25
MC_NAMELASLast name in upper-case for search helpAD_MC_NMLACHAR25
MC_NAME2NAME2 field in upper case for matchcodeAD_MC_NAM2CHAR25
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_ADRP related tables

TableNote
CDBD_ADRPPersons (central address administration.)
SMOTSAD8TName of group of persons (central address administration)
CDBD_ADCPPerson/Address assignment (central address administration)
CDBD_ADRVAddress where used list (central address administration)
CDBD_ADRTCommunication data text (central address administration)
CDBD_ADRVPPerson where-used list (central address administration)
SMOADR5Telex numbers (central address administration)
SMOTSAD3TTitles (text) (central address administration)
SAINCentral Address File: Address where-used list
TSADCAddress administration: Communications types administration
ADRPPersons (Business Address Services)
ADRPSShadow Table: Persons (Business Address Services)
TSAD8Groups of Persons (Business Address Services)
TSAD8TName of Group of Persons (Business Address Services)
SRT_CC_MIF_CDATASRT Central Configuration: Central Matching Interfaces Data
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