SAP Table
TCY54D Measure - planning table
SAP table TCY54D has 2 primary key fields being MANDT,SEC_PROFID.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TCY54D columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeySEC_PROFID | Time scale in the planning table | CHAR | 10 | 0 | SEC_PROF | ||
| SEC_F_AV | Scale factor evaluation lead period/planning period | DEC | 10 | 2 | SEC_F_AV | ||
| SEC_U_PH | Time unit for planning period | CHAR | 3 | 0 | SEC_U_PH | ||
| SEC_W_PH | Length / time unit for planning period | DEC | 10 | 2 | SEC_W_PH | ||
| SEC_F_AN | Scale factor evaluation follow-up/planning horizon | DEC | 10 | 2 | SEC_F_AN | ||
| SEC_U_AV | Time unit - Evaluation lead period - for scale definition | CHAR | 3 | 0 | SEC_U_AV | ||
| SEC_W_AV | Length per unit of time for the evaluation | DEC | 10 | 2 | SEC_W_AV | ||
| SEC_U_AN | Time unit for evaluation follow-up | CHAR | 3 | 0 | SEC_U_AN | ||
| SEC_W_AN | Length per unit of time for the evaluation follow-up | DEC | 10 | 2 | SEC_W_AN | ||
| COLLAPS | Indicator: Hide non-work periods | CHAR | 1 | 0 | COLAPS_NWT |