Business Partner Address Label selection

Martin Cerasuolo

Dear Phillip,

A customer of mine wants to select a address from the business partner to print an address label. Can you tell me how to make such a solution?

best regards,


Martin Cerasuolo

Philipp Knecht

Hi Martin


Make a query like:

SELECT T0.* FROM OCPR T0 WHERE T0.CntctCode = '[%CntctCode]'

Define the Parameters:

CardCode on the 134 Formtype
CntctCode without itemid

Then make an new layoutdefinition and add those parameters in the püaram tab.
Then enter the following statement in the design Value of the CntctCode Param:

[SELECT CntctCode,Name FROM OCPR WHERE CardCode = '[%CardCode]']

hth

Martin Cerasuolo

Dear Phillip,

It is not based on contacts. The customer has multiple address types and want to select from a grid the wanted addressline to be printed in a label.

Please help?

Best regards,

Martin Cerasuolo

Philipp Knecht

Hi Martin

Let me know if choosing the corresponding Adress from a combobox in the Paramform can also be a solution (instead of Grid)

If no please let me know which grid it is exactly.

hth

Martin Cerasuolo

Dear Phillip,

Sorry, but the customer uses the same addressname(address) for ship to and bill to. Here for i think it is not possible to use your work around.

Please advise.

Best Regards.

Martin Cerasuolo

Philipp Knecht

Hi Martin

In this case your query should look +- like:

SELECT T0.* FROM CRD1 T0 WHERE T0.AdresType + '_' + REPLACE(T0.Address,'''','') = '[%AdressId]'

And the one ine the Param Tab DesignValue for Param AdressId:

[SELECT T0.AdresType  + '_' +  REPLACE(T0.Address,'''',''), T0.Address  FROM CRD1 T0 WHERE T0.CardCode = '[%CardCode]' ORDER BY AdresType + Address]

And don't forget the param: AdressId without itemid and CardCode with id and FormType relation.


hth