on 01-18-2012 6:43 PM
Hi All,
I tried making a SQVI query in system.
I wanted a field "product descrption" which is present in the table "/sapapo/matkey". But that is not visible in the column list of the table which we get after pressing F3.
Can anyone tell me from where to get the field of product or material description ?? ..
Can i get some help.
Is there any way to make a selection field primary key. I mean to say mandatory field?
Regards,
Ankit
Hi Ankit,
You can use table /SAPAPO/MATTXT field MAKTX in your SQVI query.
About mandatory field in a SQVI query.
Go to your report display and click on save now check the check box Required field for the field which you want as mandatory field and save this variant.
Regards,
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for quick update nikhil. It helped.
Is ther any way i can make it available to my other teammates ..Since it is ID specific only way i know is to create manually in everyone's ID.
Is there any other way .. ?? Like linking it to a Tcode or copy it to others id as it is .. Just to save lot of manual wrk by going in evryones id or ask them to make by themselves..
Regards,
Ankit
Hi All,
One more favour, Is there any way i can get the details/list of the tables which are present and relevant to SNC system.
Like /sapapo/matkey or mattxt ..
/sapapo/v_matloc ..
PO failed because either "plant specific purch organisation data not exist: or "PIR does not exist". There were lot of PO failures, is there any way i can come to know the error of all PO failed at a go .
Right now i am checking the error for indiviual PO by going inside xml or chceking status.
Please do help on this. Any suggestion or comment is welcome.
Regards,
Ankit
Edited by: ankit_012 on Jan 20, 2012 12:36 AM
Hi Ankit,
You need to activate the alert type 7035 PO validation alert.
Path:SPRO --> Supply Network Collaboration --> Exceptions --> Alert Type Activation --> Activate Alert Types
Enter alert type=7035
Whenever PO fails system will generate 7035 alert.
If you want this alerts as email then you can follow steps in below mentioned link to get 7035 alerts as email so no need to check for each failed XML of PO one by one.
Regards,
Nikhil
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.