T5KB2

Canadian tax reporting units | #other | Component: Canada

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

Column Name	Description
MANDT FK	Client
BNTYPE	Business Number type	Show values
REGNR FK	Registration Number of Bus. No./QC Tax ID
ACTYPE	Business Number account type	Show values
ACNBF FK	Account number
ENDDA	End Date

Column Name	Description

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
BNTYPE	Business Number type	Show values
ACTYPE	Business Number account type	Show values

Column Name	Description	Domain name
TRUNT	Tax Reporting Unit	CHAR5

Master Data Relations \| to Other Relations ↓	Join Conditions
Client	`T5KB2.MANDT == T000.MANDT`

Other Relations	Join Conditions
Account number Business Number account type Registration Number of Bus. No./QC Tax ID Client Account number Business Number type	`T5KB2.ACTYPE == T5KB1.ACTYPE` `T5KB2.REGNR == T5KB1.REGNR` `T5KB2.MANDT == T5KB1.MANDT` `T5KB2.ACNBF == T5KB1.ACNBF` `T5KB2.BNTYPE == T5KB1.BNTYPE`
Registration Number of Bus. No./QC Tax ID Registration Number of Bus. No./QC Tax ID Business Number type	`T5KB2.MANDT == T5KB0.MANDT` `T5KB2.REGNR == T5KB0.REGNR` `T5KB2.BNTYPE == T5KB0.BNTYPE`