From which table I can get email template content in Hybris Marketing(1709 SP1)?

[spvamsi]

For our analysis, we need to collect the Email body content in Hybris Marketing from backend(GUI) tables. What is the Hybris Marketing table that I can refer to collect the Email body(content). From CUAND_ME_BLCK_CT table, I am able to get subject but not total content.

We are working on SAP Hybris Marketing On-Premise (1709 SP1)

misj14

kunalkumar.bansal

Can someone help me on this table information?

[former_member226 · Accepted solution]

Hi,

Take the ID or Name of you email Content and get the DB_KEY from CUAND_ME_ME_ROOT.

Then Go to CUAND_ME_BLCK_CT and put ROOT_KEY as DB_KEY from CUAND_ME_ME_ROOT. here field HTML will give you whole content of template.

Note: PARENT_KEY of CUAND_ME_BLCK_CT is DB_KEY of CUAND_ME_BLOCK.

table.jpg

Thanks

Saurabh

[spvamsi · Accepted solution]

Hi Saurabh,

Thanks for your detailed response. I have already tried this way but in tables I can see first line of the template content. I have to extract the table data to excel to see the complete content

[former_member226 · Accepted solution]

yes that SAP standard GUI Property:)

[KunalBansal]

Dear Phani,

You can check all the tables with CUAND_ME* for your query:

CUAND_ME_BLCK_CT 
CUAND_ME_BLKTP_T 
CUAND_ME_BLKTYPE
CUAND_ME_BLOCK 
CUAND_ME_COND_HD
CUAND_ME_COND_IT 
CUAND_ME_REUSE

Hope that helps.

Regards,

Kunal Bansal

SAP Marketing Cloud - Consultant

[spvamsi]

Hi Kunal,

Thanks for your quick response.

I have already tried the tables mentioned but I did not find any entry related to email content in those tables.

Regards,

Vamsi