SAP Table RJH_OP_PARTNER_NEW

IS-M: Object Provider Attributes For New Business Partner

RJH_OP_PARTNER_NEW (IS-M: Object Provider Attributes For New Business Partner) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RJH_OP_PARTNER_NEW to other SAP tables.

RJH_OP_PARTNER_NEW table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
PARTNER Business Partner Number BU_PARTNER BUT000 CHAR 10 0
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
XVERMSACH IS-M: BP Authorized to Receive Gifts XVERMSACH CHAR 1 0
X Yes
NULL No
XMITARB IS-M: Employee Indicator XMITARB CHAR 1 0
X Yes
NULL No
PERNR IS-M: Personnel Number JPERNR2 CHAR 20 0
XNOWERB IS-M: No Advertising XNOWERB CHAR 1 0
X Yes
NULL No
XVERB IS-M: Association Indicator XVERB CHAR 1 0
X Yes
NULL No
XINTERN IS-M: Internal Business Partner Indicator XINTERN CHAR 1 0
X Yes
NULL No
XSOZIAL IS-M: Social Facility Indicator XSOZIAL CHAR 1 0
X Yes
NULL No
XVERLEIG IS-M: Indicator: Owned By Publisher XVERLEIG CHAR 1 0
X Yes
NULL No
VERLVKORG IS-M: Publisher's Sales Organization VERLVKORG TVKO CHAR 4 0
XINSER IS-M: Selection Indicator for Advertiser XINSERENT CHAR 1 0
NULL Evaluation of advertiser will not be performed
X Evaluation of advertiser is being performed
XAGEN IS-M: Agency Indicator XAGENTUR CHAR 1 0
X Yes
NULL No
AGEN_ART IS-M: Creative Boutique Indicator XAGEN_KREA CHAR 1 0
X Yes
NULL No
AGEN_STR IS-M: Distribution Agency Indicator XAGEN_STR CHAR 1 0
X Yes
NULL No
AGEN_PLAN IS-M: Planning Agency Indicator XAGEN_PLAN CHAR 1 0
X Yes
NULL No
AGEN_GRU IS-M: Agency Type AGEN_GRUP TJGJ4 CHAR 1 0
GP_DUB IS-M: Credit Query Indicator JDUBIOS TJGJ0 CHAR 1 0
BON IS-M: Creditworthiness Indicator JBONITAET TJGJ2 CHAR 2 0
WBZKUNNR IS-M: WBZ, VDZ Number of WBZ Company JWBZKUNNR CHAR 6 0
RECHZENTNR IS-M: WBZ, Computer Center Number JWBZRZNR TJKW0 CHAR 2 0
XWBZFIRMA IS-M: Business Partner Is WBZ Company XWBZFIRMA CHAR 1 0
X Yes
NULL No
WBZZLSCH Payment Method for Billing Documents to WBZ Company WBZZLSCH TJK42 CHAR 1 0
REFBELEG IS-M/SD: Reference Document in Legacy System REMELD_ISP CHAR 20 0
J_SOC_SECU Social Insurance Number J_SOC_SECU CHAR 20 0
SEARCHTERM1 Search term 1 for business partner BU_SORT1 CHAR 20 0
SEARCHTERM2 Search term 2 for business partner BU_SORT2 CHAR 20 0
PARTNERTYPE Business Partner Type BU_BPKIND TB004 CHAR 4 0
AUTHORIZATIONGROUP Authorization Group BU_AUGRP CHAR 4 0
PARTNERLANGUAGE Business partner: Language BU_LANGU T002 LANG 1 0
PARTNERLANGUAGEISO 2-Character SAP Language Code LAISO CHAR 2 0
DATAORIGINTYPE Data Origin Types BU_SOURCE TB005 CHAR 4 0
CENTRALARCHIVINGFLAG Central Archiving Flag BU_XDELE CHAR 1 0
X Yes
NULL No
CENTRALBLOCK Central Block for Business Partner BU_XBLCK CHAR 1 0
X Yes
NULL No
TITLE_KEY Form-of-Address Key AD_TITLE TSAD3 CHAR 4 0
CONTACTALLOWANCE Business Partner: Contact Permission BU_CONTACT CHAR 1 0
1 Allowed
2 Disallowed
3 Check Permission
PARTNEREXTERNAL Business Partner Number in External System BU_BPEXT CHAR 20 0
TITLELETTER Salutation BU_TITLE_LET CHAR 50 0
NOTRELEASED Indicator: Not Released BU_XNOT_RELEASED CHAR 1 0
X Yes
NULL No
COMM_TYPE Communication Method (Key) (Business Address Services) AD_COMM CHAR 3 0
PRINT_MODE Business Partner Print Format BU_PRINT_MODE CHAR 1 0
1 Braille
2 Large Print
FIRSTNAME First name of business partner (person) BU_NAMEP_F CHAR 40 0
LASTNAME Last name of business partner (person) BU_NAMEP_L CHAR 40 0
BIRTHNAME Name at birth of business partner BU_BIRTHNM CHAR 40 0
MIDDLENAME Middle name or second forename of a person BU_NAMEMID CHAR 40 0
SECONDNAME Other Last Name of a Person BU_NAMEPL2 CHAR 40 0
TITLE_ACA1 Academic Title: Key AD_TITLE1 TSAD2 CHAR 4 0
TITLE_ACA2 Second academic title (key) AD_TITLE2 TSAD2 CHAR 4 0
TITLE_SPPL Name supplement, e.g. noble title (key) AD_TITLES TSAD5 CHAR 4 0
PREFIX1 Name Prefix (Key) AD_PREFIX TSAD4 CHAR 4 0
PREFIX2 2nd name prefix (key) AD_PREFIX2 TSAD4 CHAR 4 0
NICKNAME Nickname of Business Partner (Person) BU_NICKNAM CHAR 40 0
INITIALS "Middle Initial" or personal initials AD_INITS CHAR 10 0
NAMEFORMAT Name format AD_FORMAT T005N CHAR 2 0
NAMCOUNTRY Country for name format rule AD_NAMCTRY T005 CHAR 3 0
NAMCOUNTRYISO Country ISO code INTCA CHAR 2 0
SEX Sex of business partner (person) BU_SEXID CHAR 1 0
NULL Unknown
1 Female
2 Male
BIRTHPLACE Birthplace of business partner BU_BIRTHPL CHAR 40 0
BIRTHDATE Date of Birth of Business Partner BU_BIRTHDT DATS 8 0
DEATHDATE Date of death of business partner BU_DEATHDT DATS 8 0
MARITALSTATUS Marital Status of Business Partner BU_MARST TB027 CHAR 1 0
CORRESPONDLANGUAGE Business Partner: Correspondence Language BU_LANGU_CORR T002 LANG 1 0
CORRESPONDLANGUAGEISO 2-Character SAP Language Code LAISO CHAR 2 0
FULLNAME Full Name BU_NAME1TX CHAR 80 0
EMPLOYER Name of Employer of a Natural Person BU_EMPLO CHAR 35 0
OCCUPATION Occupation/group BU_JOBGR CHAR 4 0
NATIONALITY Nationality BU_NATIO CHAR 3 0
NATIONALITYISO Country ISO code INTCA CHAR 2 0
COUNTRYORIGIN Ctry of Origin: Non-Res. Companies BU_CNDSC CHAR 3 0
NAME1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
NAME2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
NAME3 Name 3 of organization BU_NAMEOR3 CHAR 40 0
NAME4 Name 4 of organization BU_NAMEOR4 CHAR 40 0
LEGALFORM BP: Legal form of organization BU_LEGENTY TB019 CHAR 2 0
INDUSTRYSECTOR Industry sector BU_INDSECT TB023 CHAR 10 0
FOUNDATIONDATE Date organization founded BU_FOUND_DAT DATS 8 0
LIQUIDATIONDATE Liquidation date of organization BU_LIQUID_DAT DATS 8 0
LOC_NO_1 International location number (part 1) BBBNR NUMC 7 0
LOC_NO_2 International location number (Part 2) BBSNR NUMC 5 0
CHK_DIGIT Check digit for the international location number BUBKZ NUMC 1 0
LEGALORG Legal Entity of Organization BU_LEGAL_ORG CHAR 2 0
NAMEGROUP1 Name 1 (group) BU_NAMEGR1 CHAR 40 0
NAMEGROUP2 Name 2 (group) BU_NAMEGR2 CHAR 40 0
GROUPTYPE Group type BU_GRPTYP TB025 CHAR 4 0
CREATIONDATE Date on which the object was created BU_CRDAT DATS 8 0
CREATIONTIME Time at which the object was created BU_CRTIM TIMS 6 0
CREATIONUSER User who created the object BU_CRUSR CHAR 12 0
LASTCHANGEDATE Date when object was last changed BU_CHDAT DATS 8 0
LASTCHANGETIME Time at which object was last changed BU_CHTIM TIMS 6 0
LASTCHANGEUSER Last user to change object BU_CHUSR CHAR 12 0
PERS_NO Person number AD_PERSNUM CHAR 10 0
STANDARDADDRESS Indicator: Address is standard address BU_XDFADR CHAR 1 0
X Yes
NULL No
C_O_NAME c/o name AD_NAME_CO CHAR 40 0
CITY City AD_CITY1 CHAR 40 0
DISTRICT District AD_CITY2 CHAR 40 0
REGIOGROUP Regional structure grouping REGIOGROUP ADRREGGRP CHAR 8 0
POSTL_COD1 City postal code AD_PSTCD1 CHAR 10 0
POSTL_COD2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POSTL_COD3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
PCODE2_EXT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
PO_BOX PO Box AD_POBX CHAR 10 0
PO_W_O_NO Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
PO_BOX_CIT PO Box city AD_POBXLOC CHAR 40 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG T005S CHAR 3 0
POBOX_CTRY PO box country AD_POBXCTY T005 CHAR 3 0
PO_CTRYISO Country ISO code INTCA CHAR 2 0
STREET Street AD_STREET CHAR 60 0
STR_ABBR (Not Supported) Abbreviation of Street Name AD_STRABBR ADRSTRTYPE CHAR 2 0
HOUSE_NO House Number AD_HSNM1 CHAR 10 0
HOUSE_NO2 House number supplement AD_HSNM2 CHAR 10 0
HOUSE_NO3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
STR_SUPPL1 Street 2 AD_STRSPP1 CHAR 40 0
STR_SUPPL2 Street 3 AD_STRSPP2 CHAR 40 0
STR_SUPPL3 Street 4 AD_STRSPP3 CHAR 40 0
LOCATION Street 5 AD_LCTN CHAR 40 0
BUILDING Building (Number or Code) AD_BLDNG CHAR 20 0
FLOOR Floor in building AD_FLOOR CHAR 10 0
ROOM_NO Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
COUNTRYISO Country ISO code INTCA CHAR 2 0
REGION Region (State, Province, County) REGIO T005S CHAR 3 0
TIME_ZONE Address time zone AD_TZONE TTZZ CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
LANGU Language Key SPRAS LANG 1 0
LANGUISO 2-Character SAP Language Code LAISO CHAR 2 0
EXTADDRESSNUMBER Address number in external system BU_ADEXT CHAR 20 0
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USEP CHAR 4 0
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES CHAR 4 0
TELEPHONE Telephone no.: dialling code+number AD_TLNMBR CHAR 30 0
EXTENSION Telephone no.: Extension AD_TLXTNS CHAR 10 0
TEL_NO Complete number: dialling code+number+extension AD_TELNRLG CHAR 30 0
FAX Fax number: dialling code+number AD_FXNMBR CHAR 30 0
FAX_EXTENSION Fax no.: Extension AD_FXXTNS CHAR 10 0
FAX_NO Complete number: dialling code+number+extension AD_FXNRLNG CHAR 30 0
E_MAIL E-Mail Address AD_SMTPADR CHAR 241 0

RJH_OP_PARTNER_NEW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RJH_OP_PARTNER_NEW AGEN_GRU RJH_OP_PARTNER_NEW CLIENT TJGJ4 IS-M/SD: Indicator for Agency Type MANDT
RJH_OP_PARTNER_NEW AGEN_GRU RJH_OP_PARTNER_NEW AGEN_GRU TJGJ4 IS-M/SD: Indicator for Agency Type AGEN_GRU
RJH_OP_PARTNER_NEW BON RJH_OP_PARTNER_NEW CLIENT TJGJ2 IS-M/SD: Credit Query Indicator MANDT
RJH_OP_PARTNER_NEW BON RJH_OP_PARTNER_NEW BON TJGJ2 IS-M/SD: Credit Query Indicator BONITAET
RJH_OP_PARTNER_NEW CLIENT RJH_OP_PARTNER_NEW CLIENT T000 Clients MANDT
RJH_OP_PARTNER_NEW CORRESPONDLANGUAGE RJH_OP_PARTNER_NEW CORRESPONDLANGUAGE T002 Language Keys (Component BC-I18) SPRAS
RJH_OP_PARTNER_NEW COUNTRY SYST MANDT T005 Countries MANDT
RJH_OP_PARTNER_NEW COUNTRY RJH_OP_PARTNER_NEW COUNTRY T005 Countries LAND1
RJH_OP_PARTNER_NEW DATAORIGINTYPE RJH_OP_PARTNER_NEW DATAORIGINTYPE TB005 BP data sources SOURCE
RJH_OP_PARTNER_NEW DATAORIGINTYPE SYST MANDT TB005 BP data sources CLIENT
RJH_OP_PARTNER_NEW GP_DUB RJH_OP_PARTNER_NEW GP_DUB TJGJ0 IS-M/SD: Credit Query Indicator DUBIOS
RJH_OP_PARTNER_NEW GP_DUB RJH_OP_PARTNER_NEW CLIENT TJGJ0 IS-M/SD: Credit Query Indicator MANDT
RJH_OP_PARTNER_NEW GROUPTYPE SYST MANDT TB025 BP group types CLIENT
RJH_OP_PARTNER_NEW GROUPTYPE RJH_OP_PARTNER_NEW GROUPTYPE TB025 BP group types PARTGRPTYP
RJH_OP_PARTNER_NEW INDUSTRYSECTOR SYST MANDT TB023 BP industries (Obsolete ==> TB038A) CLIENT
RJH_OP_PARTNER_NEW INDUSTRYSECTOR RJH_OP_PARTNER_NEW INDUSTRYSECTOR TB023 BP industries (Obsolete ==> TB038A) IND_SECTOR
RJH_OP_PARTNER_NEW LEGALFORM SYST MANDT TB019 BP legal forms CLIENT
RJH_OP_PARTNER_NEW LEGALFORM RJH_OP_PARTNER_NEW LEGALFORM TB019 BP legal forms LEGAL_ENTY
RJH_OP_PARTNER_NEW MARITALSTATUS SYST MANDT TB027 BP marital status CLIENT
RJH_OP_PARTNER_NEW MARITALSTATUS RJH_OP_PARTNER_NEW MARITALSTATUS TB027 BP marital status MARST
RJH_OP_PARTNER_NEW NAMCOUNTRY SYST MANDT T005 Countries MANDT
RJH_OP_PARTNER_NEW NAMCOUNTRY RJH_OP_PARTNER_NEW NAMCOUNTRY T005 Countries LAND1
RJH_OP_PARTNER_NEW NAMEFORMAT RJH_OP_PARTNER_NEW NAMCOUNTRY T005N Name formats LAND1
RJH_OP_PARTNER_NEW NAMEFORMAT RJH_OP_PARTNER_NEW NAMEFORMAT T005N Name formats NAMEFORMAT
RJH_OP_PARTNER_NEW NAMEFORMAT SYST MANDT T005N Name formats MANDT
RJH_OP_PARTNER_NEW PARTNER RJH_OP_PARTNER_NEW PARTNER BUT000 BP: General data I PARTNER
RJH_OP_PARTNER_NEW PARTNER RJH_OP_PARTNER_NEW CLIENT BUT000 BP: General data I CLIENT
RJH_OP_PARTNER_NEW PARTNERLANGUAGE RJH_OP_PARTNER_NEW PARTNERLANGUAGE T002 Language Keys (Component BC-I18) SPRAS
RJH_OP_PARTNER_NEW PARTNERTYPE SYST MNADT TB004 BP types CLIENT
RJH_OP_PARTNER_NEW PARTNERTYPE RJH_OP_PARTNER_NEW PARTNERTYPE TB004 BP types BPKIND
RJH_OP_PARTNER_NEW POBOX_CTRY SYST MANDT T005 Countries MANDT
RJH_OP_PARTNER_NEW POBOX_CTRY RJH_OP_PARTNER_NEW POBOX_CTRY T005 Countries LAND1
RJH_OP_PARTNER_NEW PO_BOX_REG SYST MANDT T005S Taxes: Region (Province) Key MANDT
RJH_OP_PARTNER_NEW PO_BOX_REG RJH_OP_PARTNER_NEW POBOX_CTRY T005S Taxes: Region (Province) Key LAND1
RJH_OP_PARTNER_NEW PO_BOX_REG RJH_OP_PARTNER_NEW PO_BOX_REG T005S Taxes: Region (Province) Key BLAND
RJH_OP_PARTNER_NEW PREFIX1 SYST MANDT TSAD4 Name Prefixes (Business Address Services) CLIENT
RJH_OP_PARTNER_NEW PREFIX1 RJH_OP_PARTNER_NEW PREFIX1 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
RJH_OP_PARTNER_NEW PREFIX2 SYST MANDT TSAD4 Name Prefixes (Business Address Services) CLIENT
RJH_OP_PARTNER_NEW PREFIX2 RJH_OP_PARTNER_NEW PREFIX2 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
RJH_OP_PARTNER_NEW RECHZENTNR RJH_OP_PARTNER_NEW CLIENT TJKW0 IS-M/SD: WBZ, Computer Center MANDT
RJH_OP_PARTNER_NEW RECHZENTNR RJH_OP_PARTNER_NEW RECHZENTNR TJKW0 IS-M/SD: WBZ, Computer Center RECHZENTNR
RJH_OP_PARTNER_NEW REGIOGROUP RJH_OP_PARTNER_NEW REGIOGROUP ADRREGGRP Regional structure grouping REGIOGROUP
RJH_OP_PARTNER_NEW REGIOGROUP SYST MANDT ADRREGGRP Regional structure grouping CLIENT
RJH_OP_PARTNER_NEW REGION SYST MANDT T005S Taxes: Region (Province) Key MANDT
RJH_OP_PARTNER_NEW REGION RJH_OP_PARTNER_NEW POBOX_CTRY T005S Taxes: Region (Province) Key LAND1
RJH_OP_PARTNER_NEW REGION RJH_OP_PARTNER_NEW REGION T005S Taxes: Region (Province) Key BLAND
RJH_OP_PARTNER_NEW STR_ABBR SYST MANDT ADRSTRTYPE Street type CLIENT
RJH_OP_PARTNER_NEW STR_ABBR RJH_OP_PARTNER_NEW POBOX_CTRY ADRSTRTYPE Street type COUNTRY
RJH_OP_PARTNER_NEW STR_ABBR RJH_OP_PARTNER_NEW STR_ABBR ADRSTRTYPE Street type STRTYPEAB
RJH_OP_PARTNER_NEW TIME_ZONE SYST MANDT TTZZ Time zones CLIENT
RJH_OP_PARTNER_NEW TIME_ZONE RJH_OP_PARTNER_NEW TIME_ZONE TTZZ Time zones TZONE
RJH_OP_PARTNER_NEW TITLE_ACA1 RJH_OP_PARTNER_NEW TITLE_ACA1 TSAD2 Academic Title (Business Address Services) TITLE_KEY
RJH_OP_PARTNER_NEW TITLE_ACA1 SYST MANDT TSAD2 Academic Title (Business Address Services) CLIENT
RJH_OP_PARTNER_NEW TITLE_ACA2 SYST MANDT TSAD2 Academic Title (Business Address Services) CLIENT
RJH_OP_PARTNER_NEW TITLE_ACA2 RJH_OP_PARTNER_NEW TITLE_ACA2 TSAD2 Academic Title (Business Address Services) TITLE_KEY
RJH_OP_PARTNER_NEW TITLE_KEY SYST MANDT TSAD3 Forms of Address (Key) (Business Address Services) CLIENT
RJH_OP_PARTNER_NEW TITLE_KEY RJH_OP_PARTNER_NEW TITLE_KEY TSAD3 Forms of Address (Key) (Business Address Services) TITLE
RJH_OP_PARTNER_NEW TITLE_SPPL SYST MANDT TSAD5 Name Suffixes/Title (Key) (Business Address Services) CLIENT
RJH_OP_PARTNER_NEW TITLE_SPPL RJH_OP_PARTNER_NEW TITLE_SPPL TSAD5 Name Suffixes/Title (Key) (Business Address Services) TITLE_KEY
RJH_OP_PARTNER_NEW VERLVKORG RJH_OP_PARTNER_NEW CLIENT TVKO Organizational Unit: Sales Organizations MANDT
RJH_OP_PARTNER_NEW VERLVKORG RJH_OP_PARTNER_NEW VERLVKORG TVKO Organizational Unit: Sales Organizations VKORG
RJH_OP_PARTNER_NEW WBZZLSCH T001 LAND1 TJK42 IS-M/SD: Allowed Payment Methods for Incoming Payments LAND1
RJH_OP_PARTNER_NEW WBZZLSCH RJH_OP_PARTNER_NEW WBZZLSCH TJK42 IS-M/SD: Allowed Payment Methods for Incoming Payments ZLSCH
RJH_OP_PARTNER_NEW WBZZLSCH RJH_OP_PARTNER_NEW CLIENT TJK42 IS-M/SD: Allowed Payment Methods for Incoming Payments MANDT