Vendor List based on Creation Date

Ideally, Vendor list can be displayed through T.Code - MKVZ where we can fetch vendor list either at Purchase Org or Account group or Generic.

Below is the list of fields we can fetch through this.

Name of vendor
Street
Country
Postal Code
City
Account group
Search term
Central purchasing block
Block function
Central deletion flag
One-time account
Purch. Organization
Purch. Org. Descr.
Terms of Payment
Incoterms
Incoterms (Part 2)
Purch. block for purchasing organization
Delete flag for purchasing organization
Minimum order value 0
Order currency
Salesperson
Telephone
Reference Purchasing Org.
Number of Purchasing Organizations 1

But at times business requires to fetch vendor list based on creation date. This cannot be accomplished through the above T.Code instead SAP has given T.Code S_ALR_87012086 to fetch the data.

Thank you.

Comments

[SAP EWM] Batch job to reprocess the failed queues in SMQ1 and SMQ2

Reports RSQOWKEX/RSQIWKEX can be scheduled as a periodic background job to reset the status of LUWs registered to outbound(SMQ1)/inbound(SMQ2) queues. RSQOWKEX for outbound queues (SMQS/SMQ1). RSQIWKEX for inbound queues (SMQR/SMQ2). The below parameters are to be maintained : Queue Name as '*' Select 'No Running Queues' Do not select 'No Retry queus' Queues running longer than < Time in Mins > ideally 20 mins No queues older than < Data > Note that this job will change the status of the failed queue to 'READY' status so that scheduler will process it. But for any queues struck in 'READY' status, th ese need to be processed manually.

[SAP SD] Mass deletion of deliveries in SAP

If there is the requirement for collective deletion of Outbound deliveries in standard, the following can be performed. Transaction VL10* with corresponding user role settings can meet this requirement. Go to VL10*, only flag indicator 'With Deliveries' in 'Data Selection' column in User Role After flagging above indicator, go into the following screen. Then flag indicator of 'Add to delivery', and fill the delivery numbers or other parameters into corresponding fields and then execute In the display screen, select the lines and click 'Delete' button

Stock Inconsistency Reports

Report: RM07KO01 - Stock consistency check between ML and IM Description : With the Stock Consistency Check report (RM07KO01), you can check the consistency of your stock data at company code level, valuation level, or material level. Possible errors in your stocks can thus be determined at an early stage before they cause major problems Transaction Code : CKMC - Consistency check between Material Master and Material Ledger

SAP Logistics

Search This Blog