SAP table BUS_BP_REL_INFO_BW (SAP BP: Extraction SAP BW Relationships, Partner Info)

Field Description Data Type Length Decimals Checktable Data Element
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
PARTNER_GUID Business Partner GUID RAW 16 0 BU_PARTNER_GUID
VALID_FROM Validity Start BUT000 BP Data DEC 15 0 BU_BP_VALID_FROM
VALID_TO Validity End BUT000 BP Data DEC 15 0 BU_BP_VALID_TO
TYPE Business Partner Category CHAR 1 0 BU_TYPE
1 Person
2 Organization
3 Group
PERSNUMBER Person Number CHAR 10 0 AD_PERSNUM
NAME_ORG1 Name 1 of organization CHAR 40 0 BU_NAMEOR1
NAME_ORG2 Name 2 of organization CHAR 40 0 BU_NAMEOR2
NAME_ORG3 Name 3 of organization CHAR 40 0 BU_NAMEOR3
NAME_ORG4 Name 4 of organization CHAR 40 0 BU_NAMEOR4
NAME_LAST Last name of business partner (person) CHAR 40 0 BU_NAMEP_L
NAME_FIRST First name of business partner (person) CHAR 40 0 BU_NAMEP_F
TITLE_ACA1 Academic Title: Key CHAR 4 0 AD_TITLE1
TITLE_ACA2 Second academic title (key) CHAR 4 0 * AD_TITLE2
TITLE_ROYL Name supplement, e.g. noble title (key) CHAR 4 0 * AD_TITLES
PREFIX1 Name Prefix (Key) CHAR 4 0 * AD_PREFIX
NAME_GRP1 Name 1 (group) CHAR 40 0 BU_NAMEGR1
NAME_GRP2 Name 2 (group) CHAR 40 0 BU_NAMEGR2