BUT_ADRP_PRC - Process Records Of OTC 147, Table ADRP

Process Records Of OTC 147, Table ADRP information is stored in SAP table BUT_ADRP_PRC.
It is part of development package MDC_BP_MODEL in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: Business Partner Data Model".

Fields for table BUT_ADRP_PRC

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6
.INCLUDEPROCESS_KEYXMDC_PROCESS_KEY0
.INCLUDESTEP_KEYXMDC_STEP_KEY0
PROCESS_IDMaster Data Change Process IdentifierXMDC_PROCESS_IDNUMC24
PROCESS_STEP_NOMaster Data Change Process Step NumberXMDC_PROCESS_STEP_NONUMC8
.INCLUDESOURCE_KEYXMDC_SOURCE_KEY0
SOURCE_SYSTEMSource SystemXMDC_BUSINESS_SYSTEMCHAR120
SOURCE_IDMaster Data Consolidation: ID of a Source ObjectsXMDC_SOURCE_IDCHAR120
.INCLUDETABLE_KEYXMDC_ADRP_KEY0
DATE_FROMValid-from date - in current Release only 00010101 possibleXAD_DATE_FRDATS16
NATIONVersion ID for International AddressesXAD_NATIONCHAR2
.INCLUDETABLE_ATTRIBUTESMDC_ADRP_ATTRIBUTES0
PERSNUMBERPerson NumberAD_PERSNUMCHAR20
DATE_TOValid-to date in current Release only 99991231 possibleAD_DATE_TODATS16
TITLEForm-of-Address KeyAD_TITLECHAR8
NAME_FIRSTFirst nameAD_NAMEFIRCHAR80
NAME_LASTLast nameAD_NAMELASCHAR80
NAME2Name of person at birthAD_NAME2_PCHAR80
NAMEMIDDLEMiddle name or second forename of a personAD_NAMEMIDCHAR80
NAME_LAST2Other Last Name of a PersonAD_NAMLAS2CHAR80
NAME_TEXTFull Name of PersonAD_NAMTEXTCHAR160
CONVERTEDStatus of Field 'Full Name' NAME_TEXTAD_NAMCONVCHAR2
TITLE_ACA1Academic Title: KeyAD_TITLE1CHAR8
TITLE_ACA2Second academic title (key)AD_TITLE2CHAR8
PREFIX1Name Prefix (Key)AD_PREFIXCHAR8
PREFIX22nd name prefix (key)AD_PREFIX2CHAR8
TITLE_SPPLName supplement, e.g. noble title (key)AD_TITLESCHAR8
NICKNAMENickname or name usedAD_NICKNAMCHAR80
INITIALS"Middle Initial" or personal initialsAD_INITSCHAR20
NAMEFORMATName formatAD_FORMATCHAR4
NAMCOUNTRYCountry/Region for Name Format RuleAD_NAMCTRYCHAR6
PROFESSIONProfessionAD_PROFESSCHAR80
SEXGender keyAD_SEXCHAR2*
LANGULanguage KeySPRASLANG2
PERS_GROUPPerson Group (Key) (Business Address Services)AD_GROUP_PCHAR8
FLAGGROUPSFlag: There are other person group assignmentsAD_FLGGP_PCHAR2
SORT1Search Term 1AD_SORT1CHAR40
SORT2Search Term 2AD_SORT2CHAR40
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR40
ADDR_COMP(not used)AD_ADDRCOMCHAR20*
ADDR_PERS(not used)AD_ADDRPERCHAR20*
FLPERSTELFlag: person has personal telephone numbersAD_FLPTELCHAR2
FLPERSCOMMFlag: Person has personal comm. numbers (apart from Tel.)AD_FLPCOMMCHAR2
PERSORIGINPersonal data source (key)AD_ORIGINPCHAR8
MC_NAMEFIRFirst Name in Uppercase for Search HelpAD_MC_NMFICHAR50
MC_NAMELASLast Name in Uppercase for Search HelpAD_MC_NMLACHAR50
MC_NAME2Field NAME2 in Uppercase for MatchcodeAD_MC_NAM2CHAR50
LANGU_CREAAddress record creation original languageAD_LANGUCRLANG2*
ADRP_UUIDUUID Used in the AddressAD_UUIDRAW16
UUID_BELATEDIndicator: UUID created laterAD_UUID_BELATEDCHAR2
ID_CATEGORYCategory of an Address IDAD_ID_CATEGORYCHAR2
ADRP_ERR_STATUSError Status of AddressAD_ERR_STATUSCHAR2
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
SOURCE_RECENCYMaster Data Consolidation: RecencyMDC_RECENCYDEC8
SOURCE_MODIFIEDIndicator: Source Record modifiedMDC_SOURCE_MODIFIEDCHAR2
SOURCE_MODIFICATION_BLIPModification Indicator refering to a field's positionMDC_MODIFICATION_BLIPRAW64
SOURCE_INDEXIndex of recordMDC_SOURCE_INDEXINT44
Privacy Policy