SAP table TCY48 (Profile for the planning table)
SAP table TCY48 has 2 primary key fields being MANDT,PLTPROF_ID.
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
Profile for the planning table
CHAR
10
0
PLT_PROF
GRAPH_GRU
Profile group (sort graphics profiles)
CHAR
4
0
*
BCPRFGROUP
GRAPH_NAME
Name of graphics profile
CHAR
12
0
BCPRFNAME
GRAPH_INDX
Profile index for the graphics profile
CHAR
1
0
BCPRFINDEX
LAYPROF_ID
not used any more
CHAR
10
0
CUA_PROF
NODPROF_ID
Graphical object selection
CHAR
10
0
TCY46K
NODE_PROF
CUAPROF_ID
not used any more
CHAR
10
0
CUA_PROF
BOXPROF_ID
Line representation selection in table section
CHAR
10
0
TCY61K
BOX_PROF
SECPROF_ID
Time scale in the planning table
CHAR
10
0
TCY54D
SEC_PROF
SEC_SIZE_1
not used
DEC
10
2
SEC_SIZE
SEC_UNIT_1
Unit in time axis of bar chart
CHAR
3
0
BCTIMEUNIT
Possible values
1
Year
2
Quarter
3
Month
4
Week
5
Day
6
Hour
7
Minute
8
Second
A
application-specific
SEC_SIZE_2
not used
DEC
10
2
SEC_SIZE
SEC_UNIT_2
Unit in time axis of bar chart
CHAR
3
0
BCTIMEUNIT
Possible values
1
Year
2
Quarter
3
Month
4
Week
5
Day
6
Hour
7
Minute
8
Second
A
application-specific
SEC_SIZE_3
not used
DEC
10
2
SEC_SIZE
SEC_UNIT_3
Unit in time axis of bar chart
CHAR
3
0
BCTIMEUNIT
Possible values
1
Year
2
Quarter
3
Month
4
Week
5
Day
6
Hour
7
Minute
8
Second
A
application-specific
CHAPROF_ID
Chart sequence in the planning table
CHAR
10
0
TCY50K
CHART_PROF
LAYOUT
Grouping of layout keys
CHAR
10
0
TCY31_G
CY_LAYOUT
RIBPROF_ID
Time scale profile
CHAR
10
0
TCY58
RIB_PROF
PROTO
Indicator: Create Customizing log
CHAR
1
0
CUST_PROTO
DEF_REPRAE
Default for representation profile
CHAR
10
0
TCY62K
DEF_REPRAE
AXIS_PROF_ID
Axis representation selection
CHAR
10
0
TCY63K
CYAXISPROF
CURVE_PROF_ID
Curve representation selection
CHAR
10
0
TCY65K
CYCURVEPROF
TCY48 foreign key relationships
Table
Field
Check Table
Check Field
0 TCY48
AXIS_PROF_ID
TCY63K Axis representation selection - header
MANDT
0 TCY48
AXIS_PROF_ID
TCY63K Axis representation selection - header
AXIS_PROF
1 TCY48
BOXPROF_ID
TCY61K Selection of line representation - header
MANDT
1 TCY48
BOXPROF_ID
TCY61K Selection of line representation - header
BOX_PROF
0 TCY48
CHAPROF_ID
TCY50K Chart sequence: Header
MANDT
0 TCY48
CHAPROF_ID
TCY50K Chart sequence: Header
CHART_PRF
1 TCY48
CURVE_PROF_ID
TCY65K Curve representation selection - header
MANDT
1 TCY48
CURVE_PROF_ID
TCY65K Curve representation selection - header
KURVE_PROF
0 TCY48
DEF_REPRAE
TCY62K Representation profile - header
MANDT
0 TCY48
DEF_REPRAE
TCY62K Representation profile - header
REPR_PROF
1 TCY48
LAYOUT
TCY31_G Definition of layouts
MANDT
1 TCY48
LAYOUT
TCY31_G Definition of layouts
LAYOUT
0 TCY48
NODPROF_ID
TCY46K Graphic object type selection: Header
MANDT
0 TCY48
NODPROF_ID
TCY46K Graphic object type selection: Header
NODE_PROF
1 TCY48
RIBPROF_ID
TCY58 Time scale profile in planning table
MANDT
1 TCY48
RIBPROF_ID
TCY58 Time scale profile in planning table
RIBPROF_ID
0 TCY48
SECPROF_ID
TCY54D Measure - planning table
MANDT
0 TCY48
SECPROF_ID
TCY54D Measure - planning table
SEC_PROFID