Purchse Info Record to default Net Price from Storage Location, not Plant

[Former Member]

Hi Expert

We are using Stock Transport Order (STO) at Storage Location (SLOCs) level and there are 10 SLOCs assigned to 1 plant.

For the same material and same vendor, vendor is charging the material Net Price differently based on the location of the SLOCS but it is captured as Net Price but not Freight Charge. We need to have the Net Price from PIR auto defaulted in the STO based on SLOC. Is there a way to do it?

Thanks!

[jagdeepsingh83 · Accepted solution]

Hi

I think you can achieve this using the standard SAP functionality of conditions records. Please following the following steps

1. Spro-->Materials Management-->Purchasing-->Define Price Determination Process-->Extend Field Catalog for Conditions Tables

Click on New Entry and select field name LGORT-Storage location and Save your request. System will create workbench request, make your you have package available from your developer.

2. Spro-->Materials Management-->Purchasing-->Define Price Determination Process-->Maintain Condition Table

Create a new table that starts with 9**.. e.g. 991. Then find plant, material, vendor and storage locations in field catalogs. Select them by double clicking on them, Note:- You have press page down button to find all fields

3. Spro-->Materials Management-->Purchasing-->Define Price Determination Process-->Define Access Sequence

Make you select the access sequence that assigned to your gross price condition, it may be PB00 or P000 or may configured one that have access sequence assigned 0002.

4. Select access sequence 0002 then click on Accesses folder --Click on new entry and add No ( whichever is available it can 2, 4. or priority you want to keep) and Table you created in Step 2. Also check exclusive indicator

5. Now select on the entry you just added and double click on folder name "Fields". All fields must added that you selected in step 2 while generating the table

6. Now maintain the condition records for given material / vendor/ plant and storage location combination MEK1

Create a new PO to test configuration and condition records.

Thanks,

Jagdeep

[Prasoon · Accepted solution]

Hi Jagdeep,

   The field LGORT does not exist in table KOMG, KOMK, or KOMP in standard. Then you can not add the field by using "extend field cataloge" node. You may check the scenario. The only option would be append structure.

Regards,

AKPT

[jagdeepsingh83 · Accepted solution]

Hi AKPT,

I tried adding a LGORT field in extend field catalog in test and I am able to do so in my test system. But I think you are right here, adding a New field in structure is the only option. Then rest of steps will remain the same.

Thanks,

Jagdeep

[shantanukumar_sinha]

Hi Daimos

Were you able to find your solution?

Can you please share it here as to how you achieved it?

As I have the exact requirement and I would like to see how to move forward for it.

Shan

[JL23]

You are from SAP, I would expect a solution from you instead of reopening an old question to ask if they have succeeded. The discussion was pretty far, the only thing left is the execution, a test in an own system. Why don't you do it?

[Prasoon]

Hi,

   I agree with Alan - but the storage location field doesnt exists in the standard condition structures KOMG / KOMP. So you can not directly add the storage location field in the condition field catalogue and in the condition tables.

   If required, you may maintain the field in the structures by appending the structure. Refer the note:   566002 - M/03: Can't use field PSTYP in the condition table

   Once the field is added to the structure, you may add the field from the field catalogue and then create the condition table with storage location.

   Now, check the access sequence assigned to the base price condition type in M/06. Go to M/07 and maintain the new condition table with a step number (say step num 1) less than the step number of the info record table 017. Now, maintain the condition record in MEK1. Test the scenario with a new PO.

Regards,

AKPT

[Former Member]

Hi

I am at SE11 at the Data Type ZZLGORT (SLOC Field).

After clicking on the Creation Icon, which one should I choose?

(a) Data Element?

(b) Structure?

(c) Table Type?

I think it should be Data Element as we need to append it back to the existing structure of KOMP.

Please advise.

[Prasoon]

Hi,

   Its data element only. You have to create a data type, say ZZLGORT. Choose LGORT as a domain.

   The complete procedure is well explained in the note mentioned in my previous comment. Please check the note and proceed.

Regards,

AKPT

[Former Member]

You could try customized the access sequence for your PIR price with SLOC as key.

Then maintain the price with MEK1.

[Former Member]

Hi Alan Love

In the access sequence, we cannot find SLOC as Key. Would you please advise?

Thanks

[Former Member]

Not sure where are you stuck? You have to configure your access sequence to include SLOC. And if you are referring to issuing sloc, you may need to add field to field catalog. Maintenance of condition record shall be in MEK1 instead of PIR.

[Former Member]

We are not using MEK1 and I believe if I maintain MEK1 and the values maintain will supercede PIR net price.

[former_member183424]

But as per your requirement, you want to maintain the condition record as per storage location.

As of my knowledge, you can't use storage location in condition record.

[former_member183424]

I don't think it is possible in standard.

We know the price can be determined automatically through condition record. But you can't add storage location field to condition table.