tables/relationship path

open in builder

TSPA

SPART

KNVP

KUNNR

KNA1

KUNNR → PARTNER

BUT000

PARTNER

BUT021

business partner: relationships

sd11f · 5k · 2r

Unchanged in S/4

Core S/4HANA table. Replaces legacy KNVK (customer contact persons) and analogous vendor contact structures. Time-dependency is mandatory — stale records without DATE_TO=99991231 are a common data quality issue.

fields (11)

field	type	length	key	description
`DATE_FROM`	dats	8	pk	valid from
`MANDT`	clnt	3	pk	client
`PARTNER`	char	10	pk	business partner number
`PARTNER2`	char	10	pk	business partner number 2
`RESSION`	char	6	pk	relationship category
`ADDRNUMBER`	char	10		address number
`ADR_KIND`	char	10		address type
`CLIENT`	clnt	3		client
`DATE_TO`	dats	8		valid to
`XDFADU`	char	1		indicator: standard address usage
`XDFREL`	char	1		standard relationship

relationships (2)

master lookup

reference to master data

references

BUT020

ADDRNUMBERADDRNUMBER

N:1

BUT000

PARTNERPARTNER

N:1