SAP table T001C (Valid Posting Periods for Global Companies)
SAP table T001C has 5 primary key fields being MANDT,RRCTY,RCOMP,MKOAR,BKONT.
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
RRCTY
Record Type
CHAR
1
0
RRCTY
Possible values
0
Actual
1
Plan
2
Actual assessment/distribution
3
Planned assessment/distribution
5
Year-End Closing Posting
RCOMP
Company
CHAR
6
0
T880
RCOMP_D
MKOAR
Account Type or Masking
CHAR
1
0
MKOAR
Possible values
+
Valid for all account types
A
Assets
C
CO-PA: Profitability Analysis
D
Customers
G
Special Purpose Ledger
K
Vendors
M
Materials
S
G/L accounts
V
Contract accounts
BKONT
To Account
CHAR
10
0
BKONT_001B
VKONT
From Account
CHAR
10
0
VKONT_001B
FRYE1
Fiscal Year for First Period Allowed (in Interval 1)
NUMC
4
0
FRYER
FRPE1
First Posting Period Allowed (in Interval 1)
NUMC
3
0
FRPER
TOYE1
Fiscal Year for Last Period Allowed (in Interval 1)
NUMC
4
0
TOYER
TOPE1
Last Posting Period Allowed (in Interval 1)
NUMC
3
0
TOPER
FRYE2
Fiscal Year for First Period Allowed (in Interval 2)
NUMC
4
0
FRYE2
FRPE2
First Posting Period Allowed (in Interval 2)
NUMC
3
0
FRPE2
TOYE2
Fiscal Year for Last Period Allowed (in Interval 2)
NUMC
4
0
TOYE2
TOPE2
Last Posting Period Allowed (in Interval 2)
NUMC
3
0
TOPE2
T001C foreign key relationships
Table
Field
Check Table
Check Field
0 T001C
MANDT
T000
Clients
MANDT
1 T001C
RCOMP
T880
Global Company Data (for KONS Ledger)
MANDT
1 T001C
RCOMP
T880
Global Company Data (for KONS Ledger)
RCOMP