1. Home
  2. Resources
  3. SAP Tables
  4. T5KB1 - Definition of Business Number, Canada

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.

Source: T5KB1 (Definition of Business Number, Canada)

T5KB1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BNTYPE Business Number type PCA_BNTYPE CHAR 2 0
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 10 0
ACTYPE Business Number account type PCA_ACTYP CHAR 2 0
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 4 0
ADRNR Addresses: Address Number CADNR SADR CHAR 10 0
KONST Payroll constant ABRKN T511K CHAR 5 0

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 MANDT T5KB0 Definition of Registration Number, Canada MANDT
T5KB1 REGNR T5KB1 BNTYPE T5KB0 Definition of Registration Number, Canada BNTYPE
T5KB1 REGNR T5KB1 REGNR T5KB0 Definition of Registration Number, Canada REGNR