Inventory Management Process (Transaction) Keys

[Former Member]

I have a list of Process Keys which I can view using transaction MCB0. For the 03 Application where can I see what movement types are allocated to the specified process keys? Thanks

[edwin_harpino · Accepted solution]

hi Niten,

checked oss note 492828-Determining the transaction key for 2LIS_03_BF + 2LIS_03_UM ?

(for purchasing-02 684465-BWVORG for purchasing data sources)

Symptom

This consulting note describes how to determine the transaction key (the BWVORG field in the plug-in, 0PROCESSKEY InfoObject in the BW)) for the extraction of material movements and revaluations (2LIS_03_BF and 2LIS_03_UM extractors) in the R/3 plug-in system.

Other terms

MC03BF0, MC03UM0

Reason and Prerequisites

The following transaction keys are available in the standard system (see transaction MCB0) for the MM application component and Application 03 (Inventory Controlling).

Extractor 2LIS_03_BF

Transaction Description Receipt/Issue

000 Misc.

001 Goods receipt/vendor Receipt

004 Matl transfer posting/inbound Receipt

005 Stock adjustment inventory + Receipt

006 Stock adjustment other + Receipt

010 Receipt from stock transfer Receipt

issues Issue

101 Returns/vendor Issue

104 Matl transfer posting/outbound Issue

105 Stock adjustment inventory - Issue

106 Stock adjustment inventory - Issue

110 Issue from stock transfer Issue

Extractor 2LIS_03_UM

Transaction Description

revaluation +

051 Revaluation/price change +

052 Revaluation/invoice verification + + +

revaluation -

151 Revaluation/price change -

152 Revaluation/invoice verification - - -

Solution

Extractor 2LIS_03_BF

1. Determine whether the transferred row of the 2LIS_03_BF extractor corresponds to a receipt or an issue.

Receipt:

The debit/credit indicator of the movement type = DEBIT (T156-SHKZG = S) and the movement type is not defined as a reversal movement type (T156-XSTBW = BLANK).

The debit/credit indicator of the movement type = CREDIT (T156-SHKZG = H) and the movement type is defined as a reversal movement type (T156-XSTBW = X).

In this case, the transferred row is also determined as a receipt. However, the ROCANCEL = X (BW: 0STORNO) indicator is set. For this reason, the fields of the 2LIS_03_BF extractor, where the STORNO = X (ROOSFIELD table, STORNO field) reversal indicator is set, are transferred with a minus sign. This means that key figures in the BW are also updated with a minus sign (subtracted) if they are based on the fields described above.

For more information, see note 352344.

Issue:

The debit/credit indicator of the movement type = CREDIT (T156-SHKZG = H) and the movement type is not defined as a reversal movement type (T156-XSTBW = BLANK).

The debit/credit indicator of the movement type = DEBIT (T156-SHKZG = S.) and movement type is defined as a reversal movement type (T156-XSTBW = X).

In this case, the transferred row is also determined as an issue. However, the ROCANCEL = X (BW: 0STORNO) indicator is set. For this reason, the fields of the 2LIS_03_BF extractor, where the STORNO = X (ROOSFIELD table, STORNO field) reversal indicator is set, are transferred with a minus sign. This means that key figures in the BW are also updated with a minus sign (subtracted) if they are based on the fields described above.

For more information, see note 352344.

Exceptions:

Movement type 122 is defined as an issue even though it was defined as a reversal movement type in the T156 table. Movement type 123 is accordingly defined as an issue (with a minus sign).

If the movement type of the posting is flagged as a stock transfer movement type (table TMCA field UMLKZ = X), the system creates an additional line item as an offsetting entry (MSEG-XAUTO = X). This receives the same movement type, however the opposite debit/credit indicator. In this case, the debits/credit indicator does not correspond to the entry in the T156 table because it is determined during the creation of the material document.

The following are possible transaction keys for a receipt: 000, 001, 004, 005, 006, 010

000, 001, 004, 005, 006 and 010 100, 101, 104, 105, 106, 110 100, 101, 104, 105, 106, 110

2. Transaction key 004 or 104

Transaction key 004 or 104 is determined if the posting movement type is flagged as a stock transfer movement type (TMCA table, UMLKZ = X field) and an article transfer posting or material transfer posting exists (MSEG-UMMAT < > MSEG-MATNR).

3. Transaction key 010 or 110

Transaction key 010 or 110 is determined if the posting movement type is flagged as a stock transfer movement type (TMCA table, UMLKZ = X field) and a stock transfer exists between different plants (MSEG-UMWRK < > MSEG-WERKS).

4. Transaction key 005 or 105

If the posting movement type corresponds to a physical inventory (TMCA table, INVKZ = X field).

5. Transaction key 006 or 106

If the posting movement type corresponds to a stock adjustment (TMCA table, KORR = X field).

6. Transaction key 001 or 101

If the movement type with reference to a vendor (MSEG-LIFNR <> BLANK) and does not correspond to a stock transfer movement type, a physical inventory or a stock adjustment.

7. Transaction key 000 or 100

All remaining goods movements.

Extractor 2LIS_03_UM

8. Transaction key 51

Revaluation through a material price change (for example, with transaction MR21) and the debit/credit indicator = DEBIT.

9. Transaction key 151

Revaluation through a material price change (for example, with transaction MR21) and the debit/credit indicator = CREDIT.

10. Transaction key 52

Revaluation through invoice verification and the debit/credit indicator = DEBIT.

11. Transaction key 152

Revaluation through invoice verification and the debit/credit indicator = CREDIT.

12. Transaction key 50

Revaluations not caused by a material price change or invoice and the debit/credit indicator = DEBIT.

13. Transaction key 150

Revaluations not caused by a material price change or invoice and the debit/credit indicator = CREDIT.

Example:

Goods receipt (ten pieces of material 4711) with movement type 561. Then, goods issue (two pieces of material 4711) with movement type 562.

Key figure 'Overall stock adjustment (positive)/BasME' = 0 (see InfoCube 0CP_IC_C1).

Movement type 561 is processed as a receipt since it is defined as a regular 'debit' movement type (T156-SHKZG = S. and T156-XSTBW = BLANK).

The movement type corresponds to a stock adjustment (TMCA table, KORR = X field).

=> transaction key = 006

Movement type 562 is also processed as a receipt since it is defined as a reversed 'credit' movement type (T156-SHKZG = H and T156-XSTBW = X).

=> transaction key = 006

The ROCANCEL = X field is also set.

Key figure => 'Overall stock adjustment (positive)/BasME' = 8.

[Former Member · Accepted solution]

Thanks for that. I have gone through the note and am still not clear what movement types are specifically allocated to what process key.

Are we able to formally say that for example these movement types (below) can be categorically mapped to specific process keys and if so how are customer specific movement types handled

101 GR goods receipt

102 GR for PO reversal

103 GR into blocked stck

104 GR to blocked rev.

105 GR from blocked stck

106 GR from blocked rev.

121 GR subseq. adjustm.

122 RE return to vendor

123 RE rtrn vendor rev.

124 GR rtrn blocked stck

125 GR rtn blkd stck rev

131 Goods receipt

132 Goods receipt

141 GR G subseq. adjustm

142 GR G subseq. adjustm

161 GR returns

162 GR rtrns reversal

201 GI for cost center

202 RE for cost center

221 GI for project

222 RE for project

231 GI for sales order

232 RE for sales order

241 GI for asset

242 RE for asset

251 GI for sales

252 RE for sales

261 GI for order

262 RE for order

281 GI for network

282 RE for network

291 GI all acc. assigmts

292 RE all acct assigmts