Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to get the commission

Former Member
0 Kudos

hi frndz,

can u help me out to solve my problem.

i have an issue that how to get the relation from the table and the field names

table fieldname

KONP KBETR

RVI3A DATAB

DATB1

KOMG MATNR

VBFA MATNR

for VBFA we need to takr thre document flow,sales order, billing document

as sales order is tracked from material

As i got the material and quantity but i am unable to get the commission for the material. and can u plz tell me how to calculate the commision for quarterly, halfyearly and annually.

Thanku in advance.

Regards,

Farhee.

1 REPLY 1

Former Member
0 Kudos

Well, one thing you can do is goto sqvi->write a query for table join and then try to join all the tables mentioned. There you will get all the fields of the tables and foriegn key relationship also as per how they aer related to each other.

Regards,

Raman