Transaction to Update / Delete an entry from Database Table VTRDI

[Former Member]

Dear Experts,

Please let me know the SAP Transaction to update / delete an entry from Database Table VTRDI (Shipment Planning Index).

Thanks & Regards,

Ramesh M

[Former Member · Accepted solution]

Hi Ramesh,

You don't and it is not recommended to handle standard SAP tables directly..

your issue, I think is incorrect shipment index..

pls use report RVV05IVB to re-organize the sd document indices.

please refer to SAP "Note 128947 - Correction of SD document indexes with RVV05IVB" for further details.

Regards

Raghu.

[Former Member · Accepted solution]

Dear Rags,

Thanks for your immediate response.

For one of the Outbound Delivery, at Header level Transport Planning Status was blank.

But when the custom report was executed, fetching from Database Table VTRDI.

As per the user, the report should not have been displayed that particular Outbound Delivery

as the Transp. Planning Status was blank. But the Table has value A (Not processed) for that

corresponding delivery.

Could you clarify the above points?

Thanks in advance,

Regards,

Ramesh M

Edited by: ramesh.manoharan on Sep 14, 2011 5:22 PM

[Former Member · Accepted solution]

Hi Ramesh,

Yes that seems a valid point..if transportation planning status is blank it means that the doc is not relevant for any shipment or there is a shipment block? If there is no shipment in your system then its a problem with the table VTRDI.

If the document is shipment relevant, could you please check manual changes on the delivery document and check if there's a shipment block?

if there are none, then I believe you should run the report I mentioned earlier--it'll correct the table.

Regards

Raghu.

[krishnannarayanan_nampoot]

Hi,

Thanks for the inputs here.

I faced same issue and found that it was because delivery was having 'Transportation Planning Status' as blank. There can be multiple reasons for this.

SAP Help says '

• Blank - Not relevant
    Delivery is not to be processed in transportation
    planning. This is the case when:
    - the delivery type is not relevant for transportation, or
    - the route is not relevant for transportation (only for
    outbound deliveries; not required for
    inbound deliveries), or
    - a shipment block has been set in the delivery (only for
    outbound deliveries: not required for inbound deliveries)

'

In my case, the route was not entered in delivery and hence it was not getting listed in during shipment creation. Once I entered route, system changed status as 'Open for Transportation Planning' and then it was listed in during shipment creation.

Technically, once it is relevant for transportation, SAP adds the delivery to the table VTRDI which is the index table for transportation planning.

Just thought of sharing this, might be useful for someone facing same issue.

Thanks.

[Former Member]

Dear Raghu,

Thaks a lot for your inputs.

Rewarded points !!!

Regards,

Ramesh M

[Former Member]

HI Ramesh, thanks..but I hope it solved your issue?

Regards,

Raghu.