Skip to Content
avatar image
Former Member

Extract of product master

Hi,

I am trying to get an extract of the values set for the parameters in the location product master particularly the parameters in the tabs SNP2, PPDS, demand and lot size. Where can I get all these details in one place?

For example I want to extract values set for "SNP Stk Trn.Horizon" (in SNP2 tab of the product master) for all products at a location. Supply profile is not used and the values are manually entered in the SNP Stk Trn.Horizon when the product is CIFed from R/3 the first time.

I tried table /sapapo/v_mat3 but it does not give me the SNP Stk Trn.Horizon. It says what supply profile is...but we don't fill in that field and manually enter the SNP Stk Trn.Horizon in location product master.

I would appreciate if some body can refer me some tables or some BAPIs that I can use to extract the values of parameters in the tabs SNP2, PPDS, demand and lot size of location product master.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 23, 2008 at 06:09 PM

    We have created an Infoset in Tcode SARP to pull the parameters of product master. You can get some of the parameters like Profiles., Procurement type, Plnd Delv Time etc from table: /SAPAPO/MATLOC but you need to have Product and Location Ids. These you can get from /SAPAPO/MATKEY, /SAPAPO/LOCMAP tables respectively.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sai,

      Thanks for the reply but the details from the tables /SAPAPO/MATLOC, /SAPAPO/MATKEY and /SAPAPO/LOCMAP are all integrated in standard view /sapapo/v_mat3.

      My problem is none of the above tables give you the details of the parameters like SNP stock transfer horizon.

      Any other suggestions please?

  • avatar image
    Former Member
    Dec 23, 2008 at 08:58 PM

    Used the table V_MAT3 and got the supply profile key and used it in SNP02 to get the values I need.

    Add comment
    10|10000 characters needed characters exceeded