Outbound Delivery Document Flow (One-Step procedure) Goods Receipt

[Former Member]

I am trying to extract the Goods Receipt status of Outbound Deliveries which are posted using One-Step procedure. I can do this one delivery at a time using VL03N.

Some sites (plants) are configured with One-Step procedure and others are configured as Two-Step procedure.

Document flow of an Outbound Delivery is extracted from table VBFA.

For the two-step delivery process (Movement type 641) the Goods Receipt is recorded in table VBFA (Subs.doc.categ. / VBTYP_N = 'i'). Therefore, I can easily extract the goods receipts for these deliveries.

However, for the one-step procedure (Movement type 647) the Goods Receipt does not appear to be recorded in table VBFA. Does anyone know which table the Goods Receipt is stored for one-step procedure?

Using transaction VL03N we can view the document flow. It appears that for One-Step procedure the Goods Receipt is held at item level. By highlighting a delivery line in VL03N and viewing the document flow we can see the goods receipt for One-Step deliveries (therefore, the data must be held somewhere).

I understand that by using One-step procedure the goods receipt is posted automatically, so we can assume that there should never be outstanding Goods Receipts for One-Step sites. However, I have been tasked with the job of reconciling all deliveries for the past 12 months. I need to prove that a goods receipt has been posted for every single delivery.

Any advice is much appreciated.

[Former Member]

I am trying to extract the Goods Receipt status of Outbound Deliveries which are posted using One-Step procedure. I can do this one delivery at a time using VL03N.

Some sites (plants) are configured with One-Step procedure and others are configured as Two-Step procedure.

Document flow of an Outbound Delivery is extracted from table VBFA.

For the two-step delivery process (Movement type 641) the Goods Receipt is recorded in table VBFA (Subs.doc.categ. / VBTYP_N = 'i'). Therefore, I can easily extract the goods receipts for these deliveries.

However, for the one-step procedure (Movement type 647) the Goods Receipt does not appear to be recorded in table VBFA. Does anyone know which table the Goods Receipt is stored for one-step procedure?

Using transaction VL03N we can view the document flow. It appears that for One-Step procedure the Goods Receipt is held at item level. By highlighting a delivery line in VL03N and viewing the document flow we can see the goods receipt for One-Step deliveries (therefore, the data must be held somewhere).

I understand that by using One-step procedure the goods receipt is posted automatically, so we can assume that there should never be outstanding Goods Receipts for One-Step sites. However, I have been tasked with the job of reconciling all deliveries for the past 12 months. I need to prove that a goods receipt has been posted for every single delivery.

Any advice is much appreciated.

[Former Member]

just try with: LIKP, LIPS, MKPF, MSEG etc

thanq

[Former Member]

As soon as you do Goods Receipt for any delivery and any movement type, it automatically hits the MKPF and MSEG tables.

MKPF(Mat. Doc Header).

MSEG (Mat. Doc Line Item).

Here MKPF is the material document header table, in this there is a field XBLNR has the delivery number.

In table MSEG you have the material document number which u can relate from MKPF and you have

BWART (Movement type) field also and other related data to Goods Receipt.

[Former Member]

Thankyou for the advice. I will proceed with your recommendation.

However, the query is inefficient since the link between LIKP and MKPF does not use the primary key (Article Doc. / MBLNR). We have almost 7 million records in MKPF table.

Is there any intermediate tables I can include between LIKP and MKPF so that only primary keys are used for the joins?

[Former Member]

IF u are capturing data related to Outbound delivery, then you can give the Transaction code VL01N and VL02N in your selection criteria. Also you must be giving date on the selection screen, so that also can be given in filter criteria during selecting,There is also BLART field that is the document type which can also be used in where clause. Just see what all data you can filter in your query , there are so various fields in MKPF you will come to know.