Sales office in Customer line items

[Former Member]

Presently using FBL5N for details of customer line items. Now the user wants the customer details Sales office wise.

Tried to change the selection views of logical database DDF used in this program but couldn't as it doesn't include table KNVV. SPRO config also doesn't have this table.

Is there any other standard report to achieve this except customized report development.

Kindly resolve.

thanks

annie

[rmazzali · Accepted solution]

I think this is not possible with a standard system. The sales office is a tipical SD information not sent to FI during posting.

You have 2 chanches:

1) make a user exit that saves the sales office in ZUONR field during invoice posting

2) search for some OSS notes that explain how to extend the field catalogue in FBL5N.

I think the second option is the best.

Roberto

[Manoj_Mahajan78]

anya,

Try these two reports-

Sales office Analysis- Invoiced Sales - MC-E

Sales office Analysis- Returns - MC-A

REWARD IF U FINDS THIS AS USEFUL...

Regds

MM

[Lakshmipathi]

Hi Anya

You can get the required data through SQVI by table joining KNVV (field VKBUR) and VBRP.

Let me know if this is not clear and require more details on that.

By the way dont forget to reward points if this is useful to you.

Regards

G. Lakshmipathi