How to find billing doc.s for Sales org and material

[Former Member]

Can any of you please help me in finding all the billing documents filtered with sales organisation and material used.

In VBRK, Sales org. filter is maintained, but i couldn't find the material filter.

[ravi_kumar100]

Hi,

Better check in WB2_V_VBRK_VBRP2 -Generated Table for View VBRK and VBRP

It is a combination view of VBRK  and VBRP table. You will get the Sales Org/ Material Combination.

Regards,

SRK

[jpfriends079]

Hi Anudeep,

Table VBRK is header table. A material being Item data, obviously, you will not find in header table(VBRK).

Check Table VBRP. There you have

  - Material - MATNR

  - SOrg of order-VKORG_AUFT

  - DistChanOrder-VTWEG_AUFT

If you want Billing Doc's Sales Org or Distribution Channel, then join table VBRK and VBRP.

Thanks, JP

Moderator's Remark: This post is unmarked as a question.