SAP table BCONT (Business Partner Contact)

SAP table BCONT has 2 primary key fields being MANDT,BPCONTACT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BPCONTACT Business Partner Contact CHAR 12 0 CT_CONTACT
PCATEGORY Business Partner Category of SAP System CHAR 1 0 CT_PCATEG
New Business Partner
X Business Partner from SD
PARTNER Business Partner Number CHAR 10 0 BUT000 BU_PARTNER
ALTPARTNER Contact Person CHAR 10 0 BUT000 CT_ALTPART
RLTYP BDT: Object part CHAR 6 0 BU_RLTYP
CTYPE Contact Type CHAR 3 0 BCONTT CT_CTYPE
CCLASS Contact Class CHAR 4 0 BCONTC CT_CCLASS
ACTIVITY Contact Action CHAR 4 0 BCONTA CT_ACTIVIT
F_COMING Contact Direction (Incoming or Outgoing) CHAR 1 0 BCONTCD CT_COMING
ORIGIN Technical Origin of Business Partner Contact CHAR 1 0 CT_ORIGIN
1 Online Processing
2 Background Processing
CTDATE Date DATS 8 0 DATUM
CTTIME Time TIMS 6 0 TIME_
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion Indicator CHAR 1 0 LOEVM
WFID Workflow ID NUMC 12 0 SWWWIHEAD CT_WFID
ADDINFO Additional Documents Are Available CHAR 2 0 BCONTAI CT_ADDINFO
PRIORITY Contact Priority CHAR 2 0 BCONTP CT_PRIORITY
CUSTINFO Customer Information CHAR 2 0 BCONTCI CT_CUSTINFO
SPARTE Division CHAR 2 0 TSPA SPARTE
BUKRS Company Code CHAR 4 0 T001 BUKRS

BCONT foreign key relationships

Table Field Check Table Check Field
0 BCONT ACTIVITY BCONTA Contact Activities CCLASS
1 BCONT ADDINFO BCONTAI Additional Contact Information MANDT
1 BCONT ADDINFO BCONTAI Additional Contact Information ADDINFO
0 BCONT ALTPARTNER BUT000 BP: General data I PARTNER
1 BCONT BUKRS T001 Company Codes BUKRS
0 BCONT CTYPE BCONTT Contact Type MANDT
0 BCONT CTYPE BCONTT Contact Type CTYPE
1 BCONT CUSTINFO BCONTCI Customer Information MANDT
1 BCONT CUSTINFO BCONTCI Customer Information CUSTINFO
0 BCONT F_COMING BCONTCD Direction MANDT
1 BCONT MANDT T000 Clients MANDT
0 BCONT PARTNER BUT000 BP: General data I PARTNER
1 BCONT PRIORITY BCONTP Contact Priority MANDT
1 BCONT PRIORITY BCONTP Contact Priority PRIORITY
0 BCONT SPARTE TSPA Organizational Unit: Sales Divisions MANDT
0 BCONT SPARTE TSPA Organizational Unit: Sales Divisions SPART
1 BCONT WFID SWWWIHEAD Workflow Runtime: Header Table for All Work Item Types WI_ID