Creation of sales orders using BDC.

[Former Member]

Hello Eveyone,

I am SAP SD Consultant in retail.

I am attaching one requirement in a word doc.

Kindly suggest if I can help my company getting this requirement done without ABAP consultant.

Otherwise if there is any better solution for this requirement.

Thanks in advance.

Regards,

Yamini Bajpai

Requirement Mentioned below:

1. Creation of Sales Order (using BDC): The following data points are uploaded using the excel file:
2. Order Number
3. Order Date
4. Invoice Date
5. SKU Code
6. Product Title
7. Quantity
8. Payment Type (COD/ Pre-paid)
9. Customer Name
10. Contact Number Address
11. Zip- Code
12. City Name & Country
13. Supplying Site
14. Discount Amount / Freebie (free of cost) if any
15. n.      Courier Agency

• o.      Airway Bill Number

1. p.      Product Weight
2. q.      Packaging Dimension
3. r. Customer Routing Code (Code used by Courier Agency for customer pincode)
4. s.       RTO Routing Code (Code used by Courier Agency for Return/RTO pincode)
5. Releasing Invoice (warehouse level): At this stage, stock and financial entries are hit.  Double click on the invoice to be released (from the list of un-released invoices)
6. Invoice Cancellation: This functionality is used for taking Sales return (both stock and financial entries are hit). It is a combination of MIGO reverse and VF11 (Cancel billing document). Invoice details are shown as below; save to cancel invoice; Invoice cancellation number is generated.
7. To Generate PDF of Invoice: Generate a PDF of the Invoice (PDF of sample invoice is attached)
8. To generate PDF of Shipment Label: Shipment Label (pasted on the consignment; PDF of sample shipment label is attached). Shipment label has barcode for Airway Bill Number and Order Number and also Routing Codes for Customer Destination and Return/RTO Destination.

Note: With each consignment both invoice and shipment label is printed and dispatched.

1. 6.       Generate Dispatch Manifest (for Courier Partner): This is the document which includes the details of all the shipments shipped through a Courier partner on a particular day  from a particular site (PDF of sample dispatch manifest is attached)
2. 7.       View Invoice Details: To view the invoice details both Sales and Sales Return

[RaymondGiuseppi]

For the batch input of sales order creation take a look at transaction SHDB "batch input manager" (Programming Interface for Background Processing.)

But the last tasks may be difficult/impossible yo complete without an Abap developer

Regards,

Raymond

[Former Member]

Dear Raymond,

Thank you so much.

Could you suggest any other solution which would fufill the requirement.

Thanks

Yamini Bajpai

[former_member242092]

Hi,

Go to t-code SHDB and do the recording with VA01. Put all the parameters as per requirement and save.

Now Co-ordinate with your abaper and ask him to create a program for the same. Get the t-code and format from him and execute.

Regards,

RP Jaiswal

[Former Member]

Dear Rampreet,

As discussed,Is there any other solution you can suggest which would satisfy the requirement other than the BDC?

Thanks

Yamini Bajpai

[former_member242092]

You can also create LSMW. It don't need any abaper's help.

[Abhijit74]

Hello,

I think better solution will be the direct input LSMW and program RVINVB10. Or You can try for BAPI also in the lsmw process.

Thanks,

Abhijit