SAP table T7CN36 (Tax grouping for company)
SAP table T7CN36 has 3 primary key fields being MANDT,TAXGP,ENDDA.
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
Client
CLNT
3
0
T000
MANDT
Tax grouping for company
CHAR
4
0
PCN_TAXGP
End Date
DATS
8
0
ENDDA
BEGDA
Start Date
DATS
8
0
BEGDA
TXARE
Tax area
CHAR
2
0
T7CN32
PCN_TXARE
ENTXI
Enterprise tax ID
CHAR
20
0
PCN_ENTXI
TXADR
Tax authority institution address
CHAR
10
0
PCN_TXADR
PERUL
Calculation rule for service year
CHAR
4
0
T525P
PCN_PERUL
EXPAM
Severance Payment Exempted Amount
CURR
13
2
PCN_EXPSP
EXPCY
Currency Key
CUKY
5
0
TCURC
WAERS
SMONT
Month
NUMC
2
0
MONTH
Possible values
01
January
02
February
03
March
04
April
05
May
06
June
07
July
08
August
09
September
10
October
11
November
12
December
SYEAR
Cumulation Interval Year
NUMC
4
0
PBAS_CUMYR
ENTDA
Enterprise Founded Date
DATS
8
0
PCN_ENTDA
T7CN36 foreign key relationships
Table
Field
Check Table
Check Field
0 T7CN36
EXPCY
TCURC Currency Codes
MANDT
0 T7CN36
EXPCY
TCURC Currency Codes
WAERS
1 T7CN36
PERUL
T525P Calculation Process for Employment Period Calculation
MANDT
1 T7CN36
PERUL
T525P Calculation Process for Employment Period Calculation
MOLGA
1 T7CN36
PERUL
T525P Calculation Process for Employment Period Calculation
PROCE
1 T7CN36
PERUL
T525P Calculation Process for Employment Period Calculation
ENDDA
0 T7CN36
TXARE
T7CN32 Tax Area
MANDT
0 T7CN36
TXARE
T7CN32 Tax Area
TXARE