Quote Table Content in generated document in Sap CPQ

[Robin_32]

Hello Everyone,

I am working with quote table. I know how to add entire quote table in document template(<<QUOTE_TABLE(name of the quote table)>>). The bracket will load the the entire quote table.

But in my case I want a particular row(example the second row) to get added in document template. Is there any conditions that I can associate with the particular column and if that matches,that particular row of quote table should get added in the document template.

Please help me with this issue.

Thank you.

[patrick_latour3 · Accepted solution]

Hi Robin,

Yes you can. You first need to understand your data and figure out what is the condition and then implement it as shown in this help page: Conditions | SAP Help Portal

Thanks,

Patrick

[Robin_32 · Accepted solution]

Hello Patrick,

thank you for the response. I tried to use conditions but I was getting the right out. So can you please guide on this issue. I'll just elaborate my problem and I'll paste the condition tag also. Please guide me.

1)Quote Table Name is "TEST"

I want the row which is having value of "ab" in "SITE" COLUMN of QUOTE TABLE.

If the column "SITE" is having value "ab" in third row and fifth row. That particular should be displayed and the rest should not be there in document template. I am trying to achieve this with the conditions as you suggested.

2)I just saw one more condition tag that may help so I just an example with regarding my issue. I have posted the picture along with message which is having tag called "DR" in conditions.

So I request you to provide the tag for the first issue with quote table called "TEST". If you provide me the condition tag for this. I can replicate the same with my cpq. I tried find this everywhere but I was unable to find it. I even read the sap setup and administration pdf.

Thanks in advance.20231207-204057.jpg

[patrick_latour3 · Accepted solution]

Hi Robin,

In your quote table loop, add a condition similar to this that will help the system determine which row to display:

<<QUOTE_TABLE_ROW>>

[CONDITION,<<QUOTE_TABLE_COLUMN(SITE)>>=ab]
Any static text or tables or tags
[CONDITION_END]

<<QUOTE_TABLE_ROW_END>>