1. Home
  2. Resources
  3. SAP Tables
  4. RJGBUSISM007_SAP_STAT_STR - IS-M: Business Partner all SAP BP Attributes STAT

SAP Table RJGBUSISM007_SAP_STAT_STR

IS-M: Business Partner all SAP BP Attributes STAT

RJGBUSISM007_SAP_STAT_STR (IS-M: Business Partner all SAP BP Attributes STAT) 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 RJGBUSISM007_SAP_STAT_STR to other SAP tables.

RJGBUSISM007_SAP_STAT_STR table fields

Field Data element Checktable Datatype Length Decimals
BUT000 BUT000 STRU 0 0
CLIENT Client MANDT CLNT 3 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
TYPE Business partner category BU_TYPE CHAR 1 0
1 Person
2 Organization
3 Group
BPKIND Business Partner Type BU_BPKIND CHAR 4 0
BU_GROUP Business Partner Grouping BU_GROUP CHAR 4 0
BPEXT Business Partner Number in External System BU_BPEXT CHAR 20 0
BU_SORT1 Search term 1 for business partner BU_SORT1 CHAR 20 0
BU_SORT2 Search term 2 for business partner BU_SORT2 CHAR 20 0
SOURCE Data Origin Types BU_SOURCE CHAR 4 0
TITLE Form-of-Address Key AD_TITLE CHAR 4 0
XDELE Central Archiving Flag BU_XDELE CHAR 1 0
X Yes
NULL No
XBLCK Central Block for Business Partner BU_XBLCK CHAR 1 0
X Yes
NULL No
AUGRP Authorization Group BU_AUGRP CHAR 4 0
TITLE_LET Salutation BU_TITLE_LET CHAR 50 0
BU_LOGSYS Logical system LOGSYS CHAR 10 0
CONTACT Business Partner: Contact Permission BU_CONTACT CHAR 1 0
1 Allowed
2 Disallowed
3 Check Permission
NOT_RELEASED Indicator: Not Released BU_XNOT_RELEASED CHAR 1 0
X Yes
NULL No
NOT_LG_COMPETENT Indicator: Not Legally Competent BU_NOT_LEG_COMPETENT CHAR 1 0
X TRUE
NULL FALSE
PRINT_MODE Business Partner Print Format BU_PRINT_MODE CHAR 1 0
1 Braille
2 Large Print
BP_EEW_DUMMY Dummy function in length 1 DUMMY CHAR 1 0
NAPR Business Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSON CHAR 1 0
NULL Business Person is a Legal Person or Organization
X Business Partner is a Natural Person
BBP_IPISP Tax Split BBP_J_1BINDEQU CHAR 1 0
X Yes
NULL No
RATE Cost Rate/Revenue Rate for Project Costing DPR_TV_RATE CHAR 15 0
NAME_ORG1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
NAME_ORG2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
NAME_ORG3 Name 3 of organization BU_NAMEOR3 CHAR 40 0
NAME_ORG4 Name 4 of organization BU_NAMEOR4 CHAR 40 0
LEGAL_ENTY BP: Legal form of organization BU_LEGENTY CHAR 2 0
IND_SECTOR Industry sector BU_INDSECT CHAR 10 0
LEGAL_ORG Legal Entity of Organization BU_LEGAL_ORG CHAR 2 0
FOUND_DAT Date organization founded BU_FOUND_DAT DATS 8 0
LIQUID_DAT Liquidation date of organization BU_LIQUID_DAT DATS 8 0
LOCATION_1 International location number (part 1) BBBNR NUMC 7 0
LOCATION_2 International location number (Part 2) BBSNR NUMC 5 0
LOCATION_3 Check digit for the international location number BUBKZ NUMC 1 0
NAME_LAST Last name of business partner (person) BU_NAMEP_L CHAR 40 0
NAME_FIRST First name of business partner (person) BU_NAMEP_F CHAR 40 0
NAME_LST2 Other Last Name of a Person BU_NAMEPL2 CHAR 40 0
NAME_LAST2 Name at birth of business partner BU_BIRTHNM CHAR 40 0
NAMEMIDDLE Middle name or second forename of a person BU_NAMEMID CHAR 40 0
TITLE_ACA1 Academic Title: Key AD_TITLE1 CHAR 4 0
TITLE_ACA2 Second academic title (key) AD_TITLE2 CHAR 4 0
TITLE_ROYL Name supplement, e.g. noble title (key) AD_TITLES CHAR 4 0
PREFIX1 Name Prefix (Key) AD_PREFIX CHAR 4 0
PREFIX2 2nd name prefix (key) AD_PREFIX2 CHAR 4 0
NAME1_TEXT Full Name BU_NAME1TX CHAR 80 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 CHAR 2 0
NAMCOUNTRY Country for name format rule AD_NAMCTRY CHAR 3 0
LANGU_CORR Business Partner: Correspondence Language BU_LANGU_CORR LANG 1 0
XSEXM Selection: Business partner is male BU_XSEXM CHAR 1 0
X Yes
NULL No
XSEXF Selection: Business partner is female BU_XSEXF CHAR 1 0
X Yes
NULL No
BIRTHPL Birthplace of business partner BU_BIRTHPL CHAR 40 0
MARST Marital Status of Business Partner BU_MARST CHAR 1 0
EMPLO Name of Employer of a Natural Person BU_EMPLO CHAR 35 0
JOBGR Occupation/group BU_JOBGR CHAR 4 0
NATIO Nationality BU_NATIO CHAR 3 0
CNTAX Obsolete Field BU_CNTAX CHAR 3 0
CNDSC Ctry of Origin: Non-Res. Companies BU_CNDSC CHAR 3 0
PERSNUMBER Person number AD_PERSNUM CHAR 10 0
XSEXU Selection: Sex of business partner is not known BU_XSEXU CHAR 1 0
X Yes
NULL No
XUBNAME Obsolete Field BU_XUBNAME CHAR 12 0
BU_LANGU Business partner: Language BU_LANGU LANG 1 0
BIRTHDT Date of Birth of Business Partner BU_BIRTHDT DATS 8 0
DEATHDT Date of death of business partner BU_DEATHDT DATS 8 0
PERNO Personnel Number BU_PERNO NUMC 8 0
CHILDREN Obsolete Field BU_CHILDREN NUMC 2 0
MEM_HOUSE Obsolete Field BU_MEM_HOUSE DEC 2 0
PARTGRPTYP Group type BU_GRPTYP CHAR 4 0
NAME_GRP1 Name 1 (group) BU_NAMEGR1 CHAR 40 0
NAME_GRP2 Name 2 (group) BU_NAMEGR2 CHAR 40 0
MC_NAME1 Search Help Field 1 (Name 1/Last Name) BU_MCNAME1 CHAR 35 0
MC_NAME2 Search Help Field 2 (Name 2/First Name) BU_MCNAME2 CHAR 35 0
CRUSR User who created the object BU_CRUSR CHAR 12 0
CRDAT Date on which the object was created BU_CRDAT DATS 8 0
CRTIM Time at which the object was created BU_CRTIM TIMS 6 0
CHUSR Last user to change object BU_CHUSR CHAR 12 0
CHDAT Date when object was last changed BU_CHDAT DATS 8 0
CHTIM Time at which object was last changed BU_CHTIM TIMS 6 0
PARTNER_GUID Business Partner GUID BU_PARTNER_GUID RAW 16 0
ADDRCOMM Address Number BU_ADDRCOMM CHAR 10 0
TD_SWITCH Planned Change Documents for Partner Were Converted BU_TD_SWITCH CHAR 1 0
IS_ORG_CENTRE Indicator: Business Partner Is Also an Organizational Center BU_IS_ORG_CENTRE CHAR 1 0
NULL BP Is Not an Organizational Center
1 BP Is Also an Organizational Center - BP Existed First
2 BP Is Also an Organizational Center - Org.Cent.Existed First
DB_KEY UUID in X form (binary) SYSUUID_X RAW 16 0
VALID_FROM Validity Start BUT000 BP Data BU_BP_VALID_FROM DEC 15 0
VALID_TO Validity End BUT000 BP Data BU_BP_VALID_TO DEC 15 0
XPCPT Business Purpose Completed Flag BU_XPCPT CHAR 1 0
X True
NULL False
NATPERS Business Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSON CHAR 1 0
NULL Business Person is a Legal Person or Organization
X Business Partner is a Natural Person
PAR_REL Business Partner Released BP_PAR_REL CHAR 1 0
NULL Released
X Not released
BP_SORT Sort Field for Phonetic Search; Obsolete BP_SORT_PH CHAR 20 0
KBANKS Bank country key BANKS CHAR 3 0
KBANKL Bank Keys BANKK CHAR 15 0
BUT100 RJGBUT100_TAB TTYP 0 0
BUT0BK BUT0BK_TAB TTYP 0 0
BUT0CC RJGBUT0CC_TAB TTYP 0 0
ADDRESSES RJGBUSISM007_ADDR_STAT_TAB TTYP 0 0