Tcode MB5L

[Former Member]

Hi all,

Please can someone analyse the value in the field of TCODE MB5L,i.e where is the value in Materials Crcy (field),Stock Account Crcy(field)and Variance Crcy(field) derive from.

[tomas_talpa · Accepted solution]

Hello, Etukmma,

the value of "Materials" specifies the stock amount in MM, i.e. from table MBEW "Material Valuation";

tha value of "Stock Accounts" specifies the stock amount in FI, i.e. the ballance from stock acounts assigned to materials.valuation classes ( via tx OBYX -> transaction BSX "Inventory posting");

tha value of "Variance" is simply the difference between MM and FI;

Generaly speaking, there shouldn't be any variance, as long as nobody posted anything directly to stock account in FI (which should be prevented by setting these accounts as "Automatic posting only"), or you didn't "break" the system in interesting way. So once there is any difference, it's time to think and search for the reason for the difference.

Kind Regards

TomT

[Former Member]

Materials Crcy (field)/ Total Value - Check in Material Master, Accounting 1 View, Total Value

Stock Account Crcy(field) - Navigate to Accounting >> financial Accounting>>General Ledger>>Information Sys>> GL report>> Account balances>>General>> G/L account balances>>G/L account balances

give Chart of Account, G/L account No. displayed in MB5L and company code, Execute

value under 'Total debit bal' is a Stock Account ....

(This value is posted to the assigned balance sheet account in financial accounting.)

The difference between Total Value and Stock Account value is variance.

[Former Member]

Adding further .. idealy there should not be any differences in MB5L ..(variance)..

If its there , please review OSS Note : SAP Note 968812 - MM/FI Difference for material stocks and take corrective actions..

Regards

Sarada