MM functional Help

[Former Member]

experts,

I need a help in MM functional area.

I have a requirement to display in report for differnt movement types like transfers, issues and receipts.

The movement types for tranfers 411 412 , but I observed in MB51 that 411 text(+ sloc to sloc) and 411 text (- consignment to own) again considering +ve an -ve based on text from T156T (movement text table. but for some materials it is not set.

My doubt is How can I categrorize these values +ves and -ves. Which field(s) is I need to look.

Is there any field(s) to capture the movements within the plant and outside the plant?

Please help me........

Thanks

[Former Member]

Hi Alekhya

For any movement type, we have to consider the Debit/Credit Indicator i.e field SHKZG. 'H' is considered positive movement and 'S' negative movement.

Kind Regards

Eswar

[Former Member]

but the thing is there is negative movement withing in the same movement.

If only consider the SHKZG is not enough.

for example, 411 is again 2 types(refer MB51)

based on text and probably SOBKZ indicator it is categorizing into 2. (+ve, -Ve).

Please help me

Thanks

[Former Member]

Hi Alekhya

SHKZG is the right thing to consider.

Considering an example with 411 transaction in MB51. Take that material document, go to table MSEG with the same material document.

Execute for entries giving the material document number.

If you observe for each item, you will find two entries. One with XAUTO = SPACE and another with XAUTO = 'X'.

XUATO = 'X' is the one generated by SAP.

More to observe, if you see SHKZG will be different for both entries.

Generally in extraction in our programs, we will consider the entries which are not automated i.e XAUTO = SPACE.

Next thing to observe is, w.r.t 411 it is transfer posting between storage location.

Hence you will see fields LGORT and UMLGO populated.

It means stock is moved from storage location in LGORT to storage location in UMLGO.

For storage location in LGORT it is negative movement, whereas for storage location in UMLGO it is negative movement when the Debit/Credit Indicator(SHKZG) is 'H'.

Hope this info gives you some more idea.

Kind Regards

Eswar