BP030

BP: Business partner - address | #masterdata | Component: Business Partner
Column Name Description
MANDT FK Client
PARTNR FK Business Partner Number
ADR_REF_K FK Address ID
ADR_DAT Valid-From Date of Business Partner Address Relationship
Column Name Description
Column Name Description
Column Name Description
ADR_DAT Valid-From Date of Business Partner Address Relationship
ADR_D_E Valid-To Date of Business Partner Address Relationship
Column Name Description
Column Name Description Domain name
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID
ADR_LOC Building CHAR20
FLOOR Floor CHAR10
ROOM_NR Room Number CHAR10
NAME3 Name 3 TEXT40
NAME4 Name 4 TEXT40
NAME_CO c/o Name TEXT40
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
TELF1 First telephone number TEXT16
TELF2 Second telephone number TEXT16
TELFX1 Fax Number TEXT31
TELFX2 Fax Number TEXT31
TELBX Telebox number TEXT15
TELX1 Telex number TEXT30
DATLT Data communication line no. TEXT14
TELTX Teletex number TEXT30
ADSMTP E-Mail Address AD_SMTPADR
TELNR_CALL1 Telephone number for determining caller CHAR30
TELNR_CALL2 Telephone number for determining caller CHAR30
Master Data Relations Join Conditions
Address Number
  • Address Number
  • ?
  • ?
  • BP030.MANDT == ADRC.CLIENT
  • BP030.ADDRNUMBER == ADRC.ADDRNUMBER
  • BP030.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • BP030.[column in domain "AD_NATION"] == ADRC.NATION
Address
  • BP030.MANDT == SANS1.MANDT
  • BP030.ADRNR == SANS1.ADRNR
Address ID
  • Address ID
  • Client
  • BP030.ADR_REF_K == TP14.ADR_REF
  • BP030.MANDT == TP14.MANDT
Foreign Key: Client BP030.MANDT == T000.MANDT
Foreign Key: Business Partner
  • BP030.MANDT == BP000.MANDT
  • BP030.PARTNR == BP000.PARTNR