Delete Null value records from 0BPARTNER

[Former Member]

Hi Experts,

For 0BPARTNER info object we have 40 attributes. My requirement to delete the 0BPARTNER records which have all the attributes are NULL. I tried to delete the NULL records from master data maintenance, but those records already loaded to upstream targets.

Can anyone please suggest me any other solution to delete the NULL records from 0BPARTNER master data.

Thanks in advance,

Sai Chand.S

[former_member188080]

hI,

once transaction data loaded it may not eb possible to delete those values from master data.

It will keep one entry atleast..

you need to delete transaction data and thgen master data.

You can SE14 to drop tables but your queries will never run unless and until you reload your transaction data.

Thanks and regards

Kiran

[Former Member]

hi

try this

/BI0/PBPARTNER is the transparent table name for the 0BPARTNER.

steps

1.Go to SE14 t-code

2.Enter Table Name /BI0/PBPARTNER

3.Click on the Radio Button - Delete Data

delete the data S , P-Tables in the database

[Former Member]

Hi,

Go to the request which loaded null data in this info object. Make it red and delete it.

Now go to infopackage, in the select queue choose fields is not equal to null and then reload data.

Thanks,

NIKHIL