Updates to VEKP,VEPO

[Former Member]

Guys,

What would be the effects of a direct update to VEKP,VEPO(handling unit header and item), LIKP,LIPS tables.

As of now our client has only SD module. No WM or transportation planning.

Billing is next to Delivery(R/3) and Accounting is in Legacy.

What would be the impacts if in future WM or TP is implemneted.

Thanks

[former_member188685 · Accepted solution]

Don't Do any Direct Updates on Transactional data bases tables LIKP/LIPS.

why do you need that direct updation?

Regards

vijay

[Former Member · Accepted solution]

becuase there is no other way after PGi I could change outbound delivery without cancelling/reversing it which the business is not willing to do as that would need cancellation of Invoice also.

[Former Member · Accepted solution]

As Tanveer mentioned you can insert the data with Abap statements. But lot of checks will be missing.

Never change standarad DB tables with open sql statements in ABAP. That will give more problems to. Always you should go with transactions. Discuss with functional and

obtain the process how to go via transactions.

Hope this helps.

Thanks,

vamshi tallada

[Former Member]

You can bet that by updating these directly that you will violate the database's referential integrity.

Once that integrity has been lost, everyone can just "go home."

[Former Member]

this is not a standalone report that updates tables for fun.

a complex custom transaction that has a lot of checks.

but the only thing is it is 'custom' transcation.

thanks

[Former Member]

and since i haven't worked in WM and TPVS modules I was curious to know the connectivity/flow.

thanks

[Former Member]

KP,

After making direct updates to these core tables in SAP... make some direct updates to your resume, too.

That can be career-ending stuff.

DO NOT break SAP's business model by doing direct updates. The company at which you are working has paid a great deal of money for that business model... work within it's framework.

[Former Member]

Thanks for your input.

Regarding updating my Resume let me worry about that.

Thanks

[Former Member]

Hi KP,

The logic is simple..

In case if there is any number series attached with these master tables, you would disrupt it..

You wont be able to catch the wrong entry.

"Insert statement" i belive is a very deadly statement..

Try this..

data itab like mara.

itab-matnr = ' '.

insert into table mara value itab.

Surprisingly, u would have a new material with no MATNR or blank MATNR...

Same applies to these tables too.

Also domain checks are overriden by Insert statement..

Hence, its always advisable to use a BAPI to update these master tables..

Regards,

Tanveer.

<b>Please mark helpful answers</b>

What do u think ppl..Let me know