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/activities
Within order documents, addresses are stripped off empty fields.
Such a stripped address is available by using the following 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: - The sales office that is linked to the business
partner.
- The current logistic company if this company is also a
financial company and no sales office is linked to the business partner.
|
Example
bp.turnover.previous.year < 15000.00 and
bp.turnover.previous.year > 0.0
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.