Hi
I have 2 coumns in DSO - 0FC_OPBEL and 0FC_AUGBL and loading data from DSO to Cube.
I want to delete the records from source package where FC_OPBEL = FC_AUGBL
Opbel Augbl
100 200
200 200
I want to just load the firs record in Cube. How would I delete it from source package.
I have written below statement but is throwing an error that FC_AUGBL is unknown.
DELETE source_package where fc_opbel = FC_AUGBL.
Let me know how can I delete the records where opbel eq Augbl.