Link between VBEP and MSEG

[Former Member]

Hi everybody

My team are trying to create a report that need the data from VBEP and MSEG but we cant link two tables with each other. Anyone have the solution for this case?

[former_member320332]

I am not sure but you can check with below join condition

MSEG-KDAUF = VBEP-VBELN

[anjan_paul]

This message was moderated.

[Former Member]

>

> Hi,
> MSEG-Matnr --> VBAP-Matnr --> VBEP-vbeln

Anjan PAul, you are aware that the MATNR in MSEG can populate numerous VBAP records? So i fail to understand how that relationship can ever lead to the right VBEP of an MSEG record.

[former_member201319]

Can you please elaborate a bit more on what exactly is the requirement here?

[Former Member]

Well, I need to calculate the delivered qty for each schedule line of an item in SO. For that purpose, I need the Qty of unit entry (MSEG-LFIMG). Schedule line's datas in VBEP so I need to link MSEG with VBEP.

[Former Member]

Hi

There isn't a direct link between VBEP and MSEG, MSEG is filled as soon as incoming moviment is posted from delivery

That mean you need to know the link between the delivery and sales order, so LIPS and VBEP: but probabbly if you need to know the delivered qty, you need to get the data from LIPS only

Max

[former_member201319]

As per my previous experience, there are 2 possibilities here...

1. Delivered Qty is determined based on Delivery Document

2. Delivered Qty is the Qty for which Post Goods Issue has happened.

If your requirement is as per possibility no. 1, then, you need not go to MSEG...You can get it from LIPS. Please keep in mind that for one Sales Order item, there can be multiple deliveries. So you may be required to total the qty from LIPS and then you can allocate it against the schedule lines starting from the earliest line having the confirmed qty,

If your requirement is as per possibility no. 2, then, you need to get the Post Goods Issue documents by referring to VBFA table (subsequent doc category "R") for the particular sales order item and then go to MSEG based on this document no. Here also, you can have multiple GI documents possible so again, you may have to total the GI Qty and then follow the same logic as mentioned above to allocate it against the schedule lines.

Hope this helps.

[Former Member]

Thanks for all replies from you guys, my ABAPer found the solution. He used a Function Module name RV_SCHEDULE_CHECK_DELIVERIES for calculate the Delivered Qty so I didnt need to link two table anymore.

[P561888]

Hi,

Easy way to see the common share fields.

GO to SQVI tcode and create one sample and data source is Table join and enter the table that you want to see the relationship

Regards,

Bharani

Edited by: SeethaRamaiah Bharani on Jan 3, 2011 4:09 PM