SAP Table T5KB1

Definition of Business Number, Canada

T5KB1 (Definition of Business Number, Canada) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T5KB1 to other SAP tables.

T5KB1 table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MANDT

Client

MANDT

T000

CLNT

BNTYPE

Business Number type

PCA_BNTYPE

CHAR

Possible values

RC	Business Number, Canada Revenue Agency
QC	Taxation Identifier, Minist�re du Revenu du Qu�bec
WS	Business Number, Nova Scotia Workers' Comp. Board

REGNR

Registration Number of Bus. No./QC Tax ID

PCA_REGN2

T5KB0

NUMC

ACTYPE

Business Number account type

PCA_ACTYP

CHAR

Possible values

RP	Payroll Account - Canada Revenue Agency
RS	Payroll Account - Minist�re du Revenu du Qu�bec
NW	Remittance Account - Nova Scotia Workers' Comp. Board

ACNBF

Account number

PCA_ACNBF

NUMC

ADRNR

Addresses: Address Number

CADNR

SADR

CHAR

KONST

Payroll constant

ABRKN

T511K

CHAR

T5KB1 foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
T5KB1	ADRNR	T5KB1	MANDT	SADR	Address Management: Company Data	MANDT
T5KB1	ADRNR	T5KB1	ADRNR	SADR	Address Management: Company Data	ADRNR
T5KB1	ADRNR	*		SADR	Address Management: Company Data	NATIO
T5KB1	KONST	T5KB1	MANDT	T511K	Payroll Parameters	MANDT
T5KB1	KONST	'07'		T511K	Payroll Parameters	MOLGA
T5KB1	KONST	T5KB1	KONST	T511K	Payroll Parameters	KONST
T5KB1	KONST	*		T511K	Payroll Parameters	ENDDA
T5KB1	MANDT	T5KB1	MANDT	T000	Clients	MANDT
T5KB1	REGNR	T5KB1	REGNR	T5KB0	Definition of Registration Number, Canada	REGNR
T5KB1	REGNR	T5KB1	MANDT	T5KB0	Definition of Registration Number, Canada	MANDT
T5KB1	REGNR	T5KB1	BNTYPE	T5KB0	Definition of Registration Number, Canada	BNTYPE