on 09-19-2014 6:31 PM
Hi all,
Could somebody tell me what is Table name for movement type related to Consignemnt special stock K? I know T156 but their no special stock K
Thanks
SL
Hi,
You may check the table T156X
Regards,
AKPT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Prasoon,
I want to check how many movement types with special stock indicator K currently using by my company for example 101K. 102k, 412K, 411K like that, I want to develop a report by using this movement types for K, for which my company is currently using...could you please help me in this
Thanks
SL
if you want to know which combinations are used then you should check table MSEG with all movements instead of the customizing.
And you do not even need to develop a report, just let SAP do a table analysis and then filter the result
Use transaction TAANA. directly click execute.
SAP will ask you for the table, enter MSEG .
click the button to select a variant
click Ad-Hoc Variant button
Move the fields you want count from the right to the left
in your case
movement type and special stock indicator
click okay
the Ad-hoc variant is flagged, just click continue
select online or background depending on the volume of records you have in MSEG and click continue
later find your table in the tree on the left, click the variant and see the results on the right
This list has any combination of movement type and special stock indicator that was ever used along with the number of records.
So just filter on K and you have what you want
Sastry,
If you're talking about movement types actually used, as opposed to configured, you can use SE16 to query table MSEG. This is the material document table - and it may be very, very large. If it's not too large, query all the documents, displaying movement type (MSEG-BWART) and the special stock indicator (MSEG-SOBKZ). You can download it into Excel, use the 'Remove Duplicates' button in the Data tab, and you'll be left with a list of the movement types you've actually used.
You may find over a million entries in the table, though, so watch out for your execution time.
- Jeff
If you are going for your own custom development, then you should take all movement types which is related to special stock K.
Till today your organization has used only movement type 101K. 102k, 412K, 411K. But how can you be sure your organization will be not going to use other movement types which is related to special stock K, like as 201K, 551K etc etc?
You can find all movement type from T156X table with regards to special stock K.
Hi,
If you dont have transaction data in the system, you have to check with your client and understand their business process. If you have transaction data in the system, you can find which all movement types are used with special stock K till now, from MSEG table, as already suggested by experts.
Regards,
AKPT
Hi Sastry,
please try the following fields in MARD
KLABS Unrestricted-Use Consignment Stock
KINSM Consignment Stock in Quality Inspection
KEINM Restricted-Use Consignment Stock
KSPEM Blocked Consignment Stock.
You can also refer to the link Movement types-in-sap-mm
Regards,
Sagnik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.