Dear Experts,
I want to know the particular customers
consignment delivery documents only not other than that i do
not want the normal delivery how can we get only the
consignment stock of delivery docs created for the customer.
- 1 Answers
- 1891 Views
- I also Faced
- E-Mail Answers
Answer Posted / Satish Chadhary
To obtain the consignment delivery documents for a specific customer, you can filter the sales order (SD) documents in SAP SD module by customer. The SD_ORDER table contains all sales orders. You can use SELECT statement with appropriate filters to retrieve only the desired consignment stock of delivery docs.nn```sqlnSELECT * FROM SD_ORDER WHERE BUKRS = '<customer number>' AND TYPE IN ('CO', 'CS');n```nReplace '<customer number>' with the corresponding customer's account number. Type 'CO' refers to a sales order for immediate delivery, and type 'CS' stands for consignment sales orders.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the client no of SAND BOX.GOLDEN CLIENT, UNIT TESTING,ENDUSER TRAINNING AND PRODUCTION SERVER?????
Hi this is jitu here,I have 5 yrs experience in pharma sales,& i have done SAP-SD.I need 1 offer in IT sector,any one help me plz.If u want 2 suggest me then mail me jiturath80@gmail.com
Could anyone please share SAP SD Support Project's Priority tickets with detailed solutions ?
How many tickets you have solved till date? can you please elaborate it with solutions?
What are the basic types of information it (information structure) comprises of?
What is the latest release of sap transportation management? : transportation management
Dear Gurus, Can u please post some real time tickets with solutions and what are the different tools used in Support SD consultant and their team size
