topic Re: Billing Document and Material Document Relation in Application Development and Automation Discussions

Billing Document and Material Document Relation

PAL14 — Sat, 29 Oct 2011 09:01:16 GMT

Dear all,

i need to know about the relation between Billing document and Material document.

Please let me know if there is any Function Module or Some View available to get these details.

my only requirement is to get only Material document From Billing Document.

Thanks In Advance.

Pradeep.

Re: Billing Document and Material Document Relation

Former Member — Sat, 29 Oct 2011 10:26:39 GMT

It depends on which kind of billing document you mean, but there's not a direct link, it needs to get the delivery document and so the material document generated for outcoming or incoming goods

Max

Re: Billing Document and Material Document Relation

PAL14 — Sat, 29 Oct 2011 10:47:47 GMT

Dear Max,

Thanks For the reply. I need the Material documents for out ward movement.

Can you please mention the Table and fields with relation.

Thanks & Regards,

Pradeep Alex Luke.

Re: Billing Document and Material Document Relation

Former Member — Sat, 29 Oct 2011 10:57:57 GMT

Can you say me which module are speaking about?

Max

Re: Billing Document and Material Document Relation

PAL14 — Sat, 29 Oct 2011 11:11:23 GMT

Hi Max,

Its related to FI module. but i think we need to consider both SD and FI.

Pradeep

Re: Billing Document and Material Document Relation

Former Member — Sat, 29 Oct 2011 11:31:16 GMT

So the material document should be linked to the delivery

The document flow:

Delivery->Outgoing moviment->Delivery->Bill->FI invoinces

If you start from FI:

- Get the bill number from header data: BKPF-AWKEY

- get the delivery number from bill item VBRP-VGBEL

- get the document flow for the delivery: VBFA: here you can find out the material document

Max