Skip to Content
avatar image
Former Member

Listings/Exclusions - add fields in condition tables

Hi,

I need to create a condition table with ship to, and material. The shipto(kunwe) is available as a allowed field. However when i go to create a condition table, that field is not there to choose. Appreciate if someone can advise how i can get that field added to the list, so that i can create the condition table.

Thanks

Keshini

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 13, 2008 at 04:35 PM

    Since KUNWE already appears in the KOMKG, which is sufficient to be valid as the definition of access sequence. In this case, modification would be considered redundant. Utilizing access sequence is adequate to fulfill your req.

    When creating condition table, select field KUNNR.

    When defining access sequence, input the table as an access, double click the "fields", highlight "KUNNR" and press "field catalog"- the lower side pushbutton, then choose KUNWE.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks. If no other access exists, system checks sold to party and won't go further even you have maintained record of ship to/material . Since you added Ship to party in another access, it will be checked against this record.

  • avatar image
    Former Member
    Sep 15, 2008 at 04:07 AM

    Hi there,

    When creating the table, make sure that you double click on ship-to & material from the allowed fields in the right side. Then automatically they appeear in the selected fields on the left side. You need to select the fields in the same order that you need to check for eg if you want your condition table 999 basing on ship-to / material, then you should select ship-to 1st & material 2nd. Also check if on selected fields on left side has in the same order.

    Then maintain the access sequence giving 999 in the step 10. Check exclusive if you want the system to stop moving to the next step if it finds the relevant condition records in the step 10.

    Assign the access sequence to your condition type that you maintain in the procedure.

    If you just maintain table 999 in access sequence, then system will automatically propose ship-to / material in the condition records. If your access sequence has more than 1 table, only then system will give the popup asking what level to want to maintain the condition records.

    Regards,

    Sivanand

    Add comment
    10|10000 characters needed characters exceeded