Skip to Content
author's profile photo Former Member
Former Member

Regarding finding out Partner function based on Sales Order/Output Type

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.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 03:11 PM

    Please try using Function Modules

    T685B_SINGLE_READ or SD_COND_T685_SELECT

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 05: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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.