Get top level refID in planned production orders explosion tab

Offline Wekey 5 months ago

Hello,

I have created a new field in between Number and reference type in the below screenshot and I am trying to display the topLevel reference itemId.

In order to achieve it, I am trying to get the top level refId. Please see the below screenshot for better understanding.

I tried with the following steps,

Created a new field in the table ReqTrans -> Created a display method with the following code to get the ToplevelRefID

public static display PoolId displayPool(ReqTrans _this)
    {
        PoolId           poolId;
        ReqPO            reqPO;

        switch (_this.RefType)
        {
            case ReqRefType::BOMLine :
            case ReqRefType::BOMPlannedOrder :
               
                poolId = ReqPO::find(_this.PlanVersion,_this.RefId).ItemId;

                break;
       
                   default:
        }
        return poolId;
    }

I have used switch case cos I have other scenarios also dont mind that.

Please help me to achieve this.

Thanks

Parents

0 Offline Kranthi 5 months ago

ReqTransCov has that relation between issue and receipt ReqTans. \Data Dictionary\Tables\ReqTrans\Methods\selectCov
Something like this, ReqTrans::findRecId(reqTransChild.selectCov().IssueRecId).RefId; // reqTransChild is your current reqTrans
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

0 Offline Wekey 5 months ago in reply to Kranthi

Hello Kranthi,

Thaks for your reply. I modified the code as you said but I am getting the same,

    public static display PoolId displayPool(ReqTrans _this)
    {
        PoolId           poolId;
        ReqPO            reqPO;
              
        switch (_this.RefType)
        {

            case ReqRefType::BOMLine :
            case ReqRefType::BOMPlannedOrder :
               
                //poolId = ReqPO::find(_this.PlanVersion,ProdTable::findTopLevelRef_this.RefId).ProdId).ItemId;
                poolId = ReqPO::find(_this.PlanVersion,ReqTrans::findRecId(_this.selectCov().IssueRecId).RefId).ItemId;
      

                break;
               
            default:
        }
        return poolId;

I am not getting the topmost level . Instead of getting the top reference. Please see the following image for your better understanding,