Automate

 View Only

  • 1.  Characteristics Value Description not coming the right one.

    Posted 02-09-2021 09:21

    Hi,
    I am trying to populate "material characteristics" value and "characteristcs value description" through query and I am using MARA, AUSP and CAWNT tables to do so. The characteristics is pulled correct but the description is not. If i put Joins between ATHZL fields (Int Counter) between two tables it limits to one line output and yet the description is wrong and if i remove the join , it populates multiple lines of different descriptions for same Characteristics value. Can anyone suggest me what I could do get the correct value.
    Screenshots below.
    The value description does not come expected. value is correct output is only one line.

    and when i removed the join in ATZHL, output is like this.


    I would appreciate a lot.
    Thanks and regards,
    Manoj



    ------------------------------
    Manoj Adhikari | Pricing Analyst
    Metso Oy | +358440526010
    ------------------------------


  • 2.  RE: Characteristics Value Description not coming the right one.

    Employee
    Posted 02-09-2021 10:34
    Hi Manoj

    SAP does NOT make it easy to write a query for characteristics.  Attaching an example, which also returns description.

    HTH
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------



  • 3.  RE: Characteristics Value Description not coming the right one.

    Posted 02-11-2021 04:12

    Hi Sigrid,
    Thank you for the query and data file, it wasn't the exact output I wanted but I managed to get my problem solved. I was looking for ATWRT field and its description ATWTB for a object(Material).  All i needed to was to make proper relation between ATZHL fields.
    The same field (ATZHL) is also available in AUSP table but because length of String is not the same, it was not showing proper join (red in previous screenshot)
    So I added CAWN table also in the workspace and added the relation. Then it worked like charm.

    BR,
    Manoj



    ------------------------------
    Manoj Adhikari | Pricing Analyst
    Metso Oy | +358440526010
    ------------------------------

    Original Message


  • 4.  RE: Characteristics Value Description not coming the right one.

    Employee
    Posted 02-11-2021 08:26
    Glad you got it working, Manoj!   

    And yes, CAWN needs to be there for the CAWNT, just like you need CABN for info in CABNT.  Like I said, SAP does not make this easy for characteristics! 

    For some objects, there may be infosets or logical databases that work.  I know of one LDB for Equipment.  But when you don't have that, you have to deal with the tables.  

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 5.  RE: Characteristics Value Description not coming the right one.

    Posted 02-15-2021 04:45
    Hi Sigrid,
    Thanks for tip. I will see with that approach too :)
    BR,
    Manoj

    ------------------------------
    Manoj Adhikari | Pricing Analyst
    Metso Oy | +358440526010
    ------------------------------

    Original Message