SAP table J_1HWTCTNCO4 (Withholding tax certificate numbering concept 4)

SAP table J_1HWTCTNCO4 has 5 primary key fields being MANDT,BUKRS,KOART,BUPLA,QSREC.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
QSREC Type of Recipient CHAR 2 0 T059C WT_QSREC
CTNOGRP Numbering Group for Withholding Tax Certificate Numbers CHAR 6 0 WITH_CTNGR CTNOGRP
TOYEAR Checkbox CHAR 1 0 XFELD
No
X Yes

J_1HWTCTNCO4 foreign key relationships

Table Field Check Table Check Field
0 J_1HWTCTNCO4 BUKRS T001 Company Codes BUKRS
1 J_1HWTCTNCO4 BUPLA J_1BBRANCH Business Place BUKRS
1 J_1HWTCTNCO4 BUPLA J_1BBRANCH Business Place BRANCH
1 J_1HWTCTNCO4 BUPLA J_1BBRANCH Business Place BUPLA_TYPE
0 J_1HWTCTNCO4 CTNOGRP WITH_CTNGR Numbering group for withholding tax certificate numbers MANDT
1 J_1HWTCTNCO4 MANDT T000 Clients MANDT
0 J_1HWTCTNCO4 QSREC T059C Types of Recipient: Vendors per Withholding Tax Type MANDT
0 J_1HWTCTNCO4 QSREC T059C Types of Recipient: Vendors per Withholding Tax Type LAND1
0 J_1HWTCTNCO4 QSREC T059C Types of Recipient: Vendors per Withholding Tax Type WITHT