11-03-2017 9:16 AM
As we all know, WRFCHVALGRP is where we group Merchandising Categories and the possible characteristic values in SAP IS-Retail. I am currently looking for the relevant tables where I could find the assignments done in this transaction. I am aware of the option of extracting in a spreadsheet by each Characteristic and its content but it will take a lot of time with so much volume of data.
I am looking for a more holistic data which logically a table could provide. I'd really appreciate any helpful input.
Thank you in advance.
Regards,
Sunil.
11-03-2017 11:17 AM
Hi Sunil,
These tables are touched when you open/save entries in WRFCHVALGRP:
WRFT_CUSTFLD
WRF_HIER_OBJ
WRF_HIER_NODES_T
WRF_HIER_NODES
WRF_HIER_NODEBOX
WRF_HIER_ID_T
WRF_HIER_ID
WRF_CHARVALT
WRF_CHARVAL_HEAD
WRF_CHARVAL
WRF_C_ACT_CC2012
WRF_APPL_SET_T
WRF_APPL_SET
WRF_HIER_OBJ
But if you are interested in such technical stuffs in the future, you can start a trace (SAT or ST12) for the specific transaction, and you will see, which tables are used.
Best regards,
Andras
11-03-2017 11:17 AM
Hi Sunil,
These tables are touched when you open/save entries in WRFCHVALGRP:
WRFT_CUSTFLD
WRF_HIER_OBJ
WRF_HIER_NODES_T
WRF_HIER_NODES
WRF_HIER_NODEBOX
WRF_HIER_ID_T
WRF_HIER_ID
WRF_CHARVALT
WRF_CHARVAL_HEAD
WRF_CHARVAL
WRF_C_ACT_CC2012
WRF_APPL_SET_T
WRF_APPL_SET
WRF_HIER_OBJ
But if you are interested in such technical stuffs in the future, you can start a trace (SAT or ST12) for the specific transaction, and you will see, which tables are used.
Best regards,
Andras
12-08-2017 7:46 AM
Hi Andras,
My apologies for the late acknowledgement. Thank you very much.
Best Regards,
Sunil.