issue in deleting null and initial value from Ztable

[naveen_yadavs]

HI Guys,

I have these fields in Z table and ABCDE are my key fields, and in B field

there is a INITIAL and a NULL value.

I want wo remove that record from Z-table where ABCDEF are same and G = 'N'.

but i dont able to delete records bcz in my B column there is initial and a null value.

A             B                             C                                 D                   E             F             G

2506   initial         000000000100103003      23.05.2016             Z310        5.000        N

2506   null            000000000100103003      23.05.2016            Z310        5.000        S

2503   null            000000000100103003      23.05.2016            Z310        5.000        N

2503   initial         000000000100103003       23.05.2016           Z310        5.000         S

Thanks in advace

[former_member183164]

Hi,

Use this

DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.

for specific,

DELETE ADJACENT DUPLICATES FROM itab COMPARING B

[naveen_yadavs]

i dont want to delete from internal table but from z-global table, and adjacent duplicate entries are not work for this bcz key field have a null and a initial value.

[former_member1299692]

Hi Naveen,

Is B field is one your primary or key field?