CRM – predefined variables in the Text Editor
If you use the Text Editor to define the layout of a letter or to create a selection expression, you can use predefined variables.
General predefined variables for business partners, opportunities, contacts, and activities
Within order documents, addresses are stripped off the empty fields.
| cor.nama | First field of Postal Address |
| cor.namb | Second field of Postal Address |
| cor.namc | Third field of Postal Address |
| cor.namd | Fourth field of Postal Address |
| cor.name | Fifth field of Postal Address |
| cor.namf | Sixth field of Postal Address |
| cor.ccty.dsca | Description of Postal Address Country |
| del.nama | First field of Delivery Address |
| del.namb | Second field of Delivery Address |
| del.namc | Third field of Delivery Address |
| del.namd | Fourth field of Delivery Address |
| del.name | Fifth field of Delivery Address |
| del.namf | Sixth field of Delivery Address |
| del.ccty.dsca | Description of Delivery Address Country |
| pad.nama | First field of Private Address |
| pad.namb | Second field of Private Address |
| pad.namc | Third field of Private Address |
| pad.namd | Fourth field of Private Address |
| pad.name | Fifth field of Private Address |
| pad.namf | Sixth field of Private Address |
| pad.ccty.dsca | Description of Private Address Country |
Predefined variables for business partners
| pldd_mcs034.dsca | Description of Price List |
| pcpr_com010.nama | Name of Parent Customer for Prices/Discounts |
| pctx_com010.nama | Name of Parent Customer for Texts |
| pctf_com010.nama | Name of Parent Customer for Finance |
| ccus_com010.nama | Name of Parent Customer for Statistics Update |
| iscn_com000.nama | Name 1 of Affiliated Company |
| iscn_com000.namb | Name 2 of Affiliated Company |
| iscn_com000.namc | Address 1 of Affiliated Company |
| iscn_com000.namd | Address 2 of Affiliated Company |
| iscn_com000.name | City 1 of Affiliated Company |
| iscn_com000.namf | City 2 of Affiliated Company |
| iscn_com000.pstc | ZIP Code of Affiliated Company |
Predefined variables for opportunities
| mprj_com001.nama | Name of Assigned To |
| mprj_com012.nama | Name A of Postal Address |
| mprj_com012.namb | Name B of Postal Address |
| mprj_com012.namc | Address A of Postal Address |
| mprj_com012.namd | Address B of Postal Address |
| mprj_com012.name | City A of Postal Address |
| mprj_com012.namf | City B of Postal Address |
| mprj_com012.pstc | ZIP Code of Postal Address |
Predefined variables for contacts
| cper_mcs122.dsca | Description of Attention |
| cper_mcs046.dsca | Description of Language |
| cper_mcs019.dsca | Description of Title |
| wadr_com012.nama | Name A of Work Address |
| wadr_com012.namb | Name B of Work Address |
| wadr_com012.namc | Address A of Work Address |
| wadr_com012.namd | Address B of Work Address |
| wadr_com012.name | City A of Work Address |
| wadr_com012.namf | City B of Work Address |
| wadr_com012.pstc | ZIP Code of Work Address |
| padr_com012.nama | Name A of Private Address |
| padr_com012.namb | Name B of Private Address |
| padr_com012.namc | Address A of Private Address |
| padr_com012.namd | Address B of Private Address |
| padr_com012.name | City A of Private Address |
| padr_com012.namf | City B of Private Address |
| padr_com012.pstc | ZIP Code of Private Address |
Predefined variables for activities
| acti_smi002.dsca | Description of Source |
| acti_smi003.dsca | Description of Phase |
| acti_smi004.dsca | Description of Jobtitle |
| acti_smi006.dsca | Description of Attention |
| empl_com001.nama | Name of Employee |
| crep_com001.nama | Name of Sales Representative |
Predefined variable for selection expressions
| bp.turnover.previous.year |
The
turnover from the Invoice-to Business Partner Balances (tccom4513s000) session. This value represents last year's turnover for all departments that belong to the financial company of:
|
Based on the selection expression, business partners that match the turnover criteria can be retrieved in the Mail Merge by Standard Letter (tdsmi2410m000) and Flexible Printing (tdsmi2410m100) sessions. You can, for example, send a letter to all business partners with a turnover value below 15000 and above 0.
The following limitations apply to the turnover:
- The turnover value of only one financial company is calculated. Turnover of multiple financial companies are not totalized.
- For a business partner, only one record can be retrieved from the Invoice-to Business Partner Balances (tccom4513s000) session.
Example
bp.turnover.previous.year < 15000.00 and bp.turnover.previous.year > 0.0.