C_MODULE_EXACT_TABLE Initialization
The C_MODULE_EXACT_TABLE
table is used for defining flexible partitioning strategies on certain tables.
Most data in this table can be left as-is, but you must update this table if you plan to load Planning or Budget information
into the W_RTL_PLAN1_PROD1_LC1_T1_FS
interface. The partition level must align with the data level of your
plan (day or week). To configure the plan partitions, you must update the table C_MODULE_EXACT_TABLE
where MODULE_CODE = PLAN1
. Modify the columns PARTITION_COLUMN_TYPE
and PARTITION_INTERVAL
to be one of the following values:
-
If your input data will be at Day level, set both columns to
DY
-
If your input data will be at Week level, set both columns to
WK
You must then enable the partitioning process in C_MODULE_ARTIFACT
by locating the row for MODULE_CODE=PLAN1
and setting ACTIVE_FLG=Y
and PARTITION_FLG=Y
. If your plan data will extend into the future,
you must also change PARTITION_FUTURE_PERIOD
to the number of future months that need partitions built (for
example, use a value of 6M
to partition 6 months into the future).