Using Projectcodes in OITM and transfer the projectcode to the Documentslines

[former_member681242]

Hi Everyone,

is there a standard way within SAPB1 to set an Projektcode (fincal project not the projectmanagment) within an item and transfer the projectcode to new Documentlines automatically when a new Document is created ?
Or do I have to use UDV ?

Thank you for your help!
Kind regards

Tobias

[Johan_H · Accepted solution]

Hi Tobias,

It can be done with a Formatted Search, but only if the document is entered into B1 manually.

Adapt and save this query:

SELECT i.[FieldWithTheProjectCode]
FROM OITM i
WHERE i.ItemCode = $[$38.1.0]

and then create a Formatted Search in the relevant field in the document line. Choose option 'Search in Existing User-Defined Values according to Saved Query', and select the query you just saved. Set 'Auto Refresh' and 'When exiting altered column', and column 'Item No.'. Finally choose option 'Display Saved User-Defined Values'.

If your documents are entered automatically, you will need to adapt the code of the program that imports the documents.

Regards,

Johan

[former_member681242 · Accepted solution]

thanks for the support

[LoHa]

Hi Tobias,

you could use FMS (formatted search) for this case, I think

regards Lothar

[former_member681242]

thanks for the support