0REPARTNR_ADR_ATTR

RE BW: Real Estate Partner Addresses | #ATTR | Extraction method: V | No Delta | Component: Real Estate Management Master Data

Tables used: SANS1, VZGPO, BP030 → show details

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (1)
Other (8)
🔗 Relations (5)

Column Name	Description
SNUMOBJ	Key for number range object	Show values
SOBJEKT	Internal key for object for business partner table
ROLETYP FK	Business Partner Role Category
DTRANS	Flow data key: System date
PARTNR FK	Business Partner Number
ADR_REF_K FK	Address ID
ADR_DAT	Valid-From Date of Business Partner Address Relationship
ADRNR	Address number

Column Name	Description

Column Name	Description

Column Name	Description
DTRANS	Flow data key: System date
ADR_DAT	Valid-From Date of Business Partner Address Relationship

Column Name	Description
SNUMOBJ	Key for number range object	Show values

Column Name	Description	Domain name
PSTLZ	Postal Code	PSTLZ
ORT01	City	TEXT35
ORT02	District	TEXT35
PSTBZ	Post delivery district	PSTBZ
STRAS	Street and House Number	TEXT35
STRA1	Street and House Number	TEXT35
ORT01_MC	IS-IS: City 1 in upper case characters for matchcode search	CHAR16
STRAS_MC	IS-IS: Street in upper case characters for matchcode search	CHAR16

Master Data Relations	Join Conditions
Address ID Client Address ID	`0REPARTNR_ADR_ATTR.MANDT == TP14.MANDT` `0REPARTNR_ADR_ATTR.ADR_REF_K == TP14.ADR_REF`
Country key Client Country/Region Key	`0REPARTNR_ADR_ATTR.MANDT == T005.MANDT` `0REPARTNR_ADR_ATTR.LAND1 == T005.LAND1`
Partner number Business Partner Number Client	`0REPARTNR_ADR_ATTR.PARTNR == BP000.PARTNR` `0REPARTNR_ADR_ATTR.MANDT == BP000.MANDT`
Regional key Region (State, Province, County) Country/Region Key Client	`0REPARTNR_ADR_ATTR.REGIO == T005S.BLAND` `0REPARTNR_ADR_ATTR.LAND1 == T005S.LAND1` `0REPARTNR_ADR_ATTR.MANDT == T005S.MANDT`
Role category of partner Client Business Partner Role Category	`0REPARTNR_ADR_ATTR.MANDT == TPZ3.MANDT` `0REPARTNR_ADR_ATTR.ROLETYP == TPZ3.ROLETYP`