Sales & Distribution

[Former Member]

Hi All

Can anyone tell how can I link company code & profit center with customer no & distribution channel. Are all these information available on a single table. If this is not possible tell me whether i can link atleast company code with customer no & distribution channel.

Also please tell me from where i can get sales figures excluding taxes. Table BSID & BSID has these but my client is not updating taxes in these tables. so please suggest me some other way.

Useful answers will definitely be rewarded.

Regards

Sathar

[Former Member]

Dear Sathir,

How can I link company code & profit center with customer no & distribution channel

Company code, customer Number & Distribution Channel are available in VBRK table. Profit Center is in VBRP table. The joining of VBRK & VBRP is through Billing Document i.e VBELN field.

Also please tell me from where i can get sales figures excluding taxes.

A net value field is there both in VBRK & VBRP.

Regards

SWAPNIL