08-01-2006 2:22 PM
Hi All,
<b>I have a issue in finding out Partner function[PARVW], Message partner[PARNR], Message transmission medium[NACHA], Teletex number[TELTX], User name[USNAM], Message processed manually[MANUE], Country Key[TLAND] and some other fields all are related to NAST table.</b>
Actually we have one script which is already working when we run from from <b>VA02/03</b> for single order.
When we execute from <b>VA02/03</b> all <b>NAST</b> table entries are filled up and by using those entries we are fetching remaining entries and displaying them in Output.
Now we are developing another program where we will have a selection screen with <b>Sales order, Output Type & Order Type</b> and execute the program and then we will get list of sales orders in <b>ALV list output</b> with check boxes before every record.
Now if we select one (or) multiple records from there and click on Print Prevview button i am calling above <b>SAP Script Print Program</b> but now in that P.Program we will not have any <b>NAST</b> table entries other than Sales Order and Output Type those can be moved to [<b>NAST-OBJKY, NAST-KSCHL</b>].
But here what about other fields in <b>NAST</b> table like <b>PARVW, PARNR, NACHA, TELTX, USNAM, MANUE, TLAND</b> etc.
How can we get them as we are exclusively using those other <b>NAST</b> table entries in above <b>SCRIPT/Print Program</b>.
Can anybody solve this issue!
Thanks in advance.
Thanks & Regards,
Prasad.
08-01-2006 4:11 PM
Please try using Function Modules
T685B_SINGLE_READ or SD_COND_T685_SELECT
08-01-2006 4:32 PM
Hi,
Thanks for that reply.
But First F.M is retrieving some fields like NACHA, PARVW but still i need to lot of other fields that are in NAST.
Second F.M tables like T685 serial also does not contain all required fields which are related to NAST table.
Can anybody give me any other solution!
All these NAST table fields will defenetely be in some of VBAK, VBAP, VBPA, VBKD etc.
Can anybody solve this issue!
Thanks in advance.
Thanks & Regards,
Prasad.
08-01-2006 5:57 PM
Hi,
Anybody give the solution for the above issue!
<b>I need to retrieve PARNR, VSTAT, MANUE, TCODE, VSDAT, VSURA, SORT1 - I know the VBELN and KSCHL values.</b>
For Other fields mentioned above i am able to find through diffrent tables and SD_PARTNER_READ F.M.
Can anybody tell me how to retrieve above remaining fields.
Any help in this regard will be appreciated.
Thanks in advance.
Thanks & Regards,
Prasad.
08-01-2006 6:54 PM
Check this FM
WFMC_MESSAGES_SELECT
example
tables : nase.
constants: appl like nase-kappl value 'V2'.
select-options:
rg_nacha for nase-nacha default '1',
rg_kschl for nase-kschl.
ranges: rg_objky for nast-objky.
data:
msgs_1 like msg0 occurs 100 with header line.
*-Fill Object Key
*-Execute fm
call function 'WFMC_MESSAGES_SELECT'
exporting
pi_application = appl
pi_processing = '1'
tables
ri_medium = rg_nacha
ri_type = rg_kschl
ri_object = rg_objky
tx_messages = msgs_1.
08-01-2006 7:26 PM
Hi Naresh,
Thanks for that reply.
That Function module will again fetch the values from <b>NAST</b> table only na.
But most of the records we will be processing might not be in NAST.
I think this F.M will inturn will take values from NAST only.
we need to pick up above mentioned NAST entries from any of VBAK/VBAP/VBKD/VBPA/VBFA etc tables.
Because when i have processed my Order Number from NAST it will not show any values.
Thanks for your time and effort.
Thanks,
Prasad.