Solved: issue with sap query and enhancement

Former Member · ‎04-12-2016

Hi,

I have an sap query, infoset and all those stuff created , my question is , if the credit/debit indicator is X and there should be a field which should be marked as negative and if its not X and we should set another field as NEGATIVE.

Please suggest how can I achieve that?

Thanks,

rg

jogeswararao_kavala · ‎04-12-2016

Hello Ramya,

You should try to be very clear at the first time and everytime. There should not be any necessity for replying persons to first ask you for clarifications and then reply to you.

Now coming to you query

By Debit/Credit indicator, do you mean field SHKZG ?
If yes it has its own specific values H for Credit and S for Debit.
In this case you need to multiply your respective fields with Positive or Negative sign.
Even if your Debit/Credit indicator is different then also you need to do accordingly.

Now you are not clear about whether you are talking about additional fields which should be made negative or positive or you are talking about existing fields. If you are talking about additional fields, this thread would become an Infoset tutorial.

You should improve asking questions to receive proper help. Be clear in mind about what to ask and also be clear about what is the basis of asking.

thanh_dinh · ‎04-12-2016

hello,

I have a question. What does "marked as negative" mean? Displaying it with the sign( -10 ) or just calculating the sum?

Thanh.

jogeswararao_kavala · ‎04-12-2016

Hello Ramya,

You should try to be very clear at the first time and everytime. There should not be any necessity for replying persons to first ask you for clarifications and then reply to you.

Now coming to you query

By Debit/Credit indicator, do you mean field SHKZG ?
If yes it has its own specific values H for Credit and S for Debit.
In this case you need to multiply your respective fields with Positive or Negative sign.
Even if your Debit/Credit indicator is different then also you need to do accordingly.

Now you are not clear about whether you are talking about additional fields which should be made negative or positive or you are talking about existing fields. If you are talking about additional fields, this thread would become an Infoset tutorial.

You should improve asking questions to receive proper help. Be clear in mind about what to ask and also be clear about what is the basis of asking.

Former Member · ‎04-13-2016

Hi,

thank you very much for the sugegestion.

I am talking about VBRP table SHKZG field when this field is X I want to make one of the fields of the internal table to dispaly as negative for suppose if the value of the field is 10 it should be -10.

However I had solved myself by using code section in the query and during record processing event.

thanks,

RG

jogeswararao_kavala · ‎04-13-2016

Hello Ramya,

Glad you've solved yourself. It is a simple requirement.
Because you work on Infoset Queries these two posts might be of your use.
- 10 Useful Tips on Infoset Queries
- Infoset Queries: Collection of important posts

Good luck

KJogeswaraRao