Sales Order Due for Deliveries Report

You can use transaction VL10A for creating delivery documents from sales orders that are due on certain dates. Here is how to use it:

1. Restrict the shipping point (for example I enter shipping point “1001”) and enter from-date and to-date in the windows of “Delivery Creation Date” field.
2. Leave “CalcRuleDefltDlvCrDt” field blank.
3. Leave all the other parameters blank (from tab “General Data” to “User Role”). By doing this, you are going to list the sales order within certain range of date from a certain shipping point that you can convert to delivery documents at once.

Initial Screen of Transaction VL10A

This work list will show which sales orders are late for delivery by giving red traffic light. Now, select one of the documents and click on the “Background” button. The system will automatically run the outbound delivery creation in background and will give you the new outbound delivery number.

List of Sales Orders Due for Shipping

A Delivery Document is Created

Now, select one of the Sales Order documents, but this time click on the “Dialog” button. This transaction allows you to proceed the document manually by calling VL02N to process the selected document.

SAP SD Standard Reports

 

VA15N	Inquiries List
VA25N	Quotations List
SDQ1	Expiring Quotations
SDQ2	Expired Quotations
SDQ3	Completed Quotations
VA05N	List of Sales Orders
SDO1	Orders Within Time Period
V.02	Incomplete Orders
VA35N	List of Scheduling Agreements
VA45N	List of Contracts
SDV1	Expiring Contracts
SDV2	Expired Contracts
SDV3	Completed Contracts
VA14L	Sales Documents Blocked for Delivery
V.23	Sales Documents Blocked for Billing
VL06O	Outbound Delivery Monitor
VF05N	List of Billing Documents
VB(8	List Rebate Agreements
S_ALR_87012218	Credit master sheet
F.31	Credit Management Overview
FCV3	Credit Management Early warning list
MCTA	SIS: Customer Analysis
MCTC	SIS: Material Analysis
MCTE	SIS: Sales organization
MCTK	SIS: Shipping point
MCTI	SIS: Sales employee
MCTG	SIS: Sales office
MC(A	SIS: Incoming orders
MC+A	SIS: Returns
MC+E	SIS: Customer Analysis: Invoiced Sales
MC+I	SIS: Customer Analysis: Credit memos
F.35	SIS: Credit master sheet
MC(E	SIS: Material Analysis: Incoming orders
MC+M	SIS: Material Analysis: Returns
MC+Q	SIS: Material Analysis: Invoiced Sales
MC+U	SIS: Material Analysis: Credit memos
MC(I	SIS: Sales Orgn Analysis: Incoming orders
MC+Y	SIS: Sales Orgn Analysis: Returns
MC+2	SIS: Sales Orgn Analysis: Sales
MC+6	SIS: Sales Orgn Analysis: Credit memos
MC(M	SIS: Sales Office Analysis: Incoming orders
MC-A	SIS: Sales Office Analysis: Returns
MC-E	SIS: Sales Office Analysis: Sales
MC-I	SIS: Sales Office Analysis: Credit memos
MC(Q	SIS: Sales Employee Analysis: Incoming orders
MC-M	SIS: Sales Employee Analysis: Returns
MC-Q	SIS: Sales Employee Analysis: Sales
MC-U	SIS: Sales Employee Analysis: Credit memos
VC/2	Sales Summary (Customer Fact Sheet)
V/LD	Pricing Reports
VD59	List Customer Material Info
VB35	Promotion List
VB25	List of Sales Deals
VC05	List of Sales Activities
VB25	List of Sales Deals
VCUST	Customer List
VA06	Sales order Monitor
SDD1	Duplicate Documents

SAP FTP CONNECTION

 

SAP FTP CONNECTION

I am writing this blog post for the FTP connection to the SAP ABAP system. While I was configuring the SAP FTP, I haven’t found complete information in a single blog post, So I am writing this blog post.

PRE-REQUISITES:

• FTP credentials.
• SAP GUI credentials with authorization.
• SAP OS access to check IP ports accessibility.
• Network basic understanding.

STEP TO CONFIGURE FTP FOR THE SAP ABAP SYSTEM.

• Check FTP server IP and network Port.
• Note down the FTP IP and port provided by FTP/OS team.
• Telnet FTP server IP on a specific port. The default port is 21.
• Telnet Syntax (Linux & windows): telnet <IP> <PORT>
• Check FTP is accessible from SAP system OS.
• telnet 123.12.21.20 21

·        

• Make sure it will connect.
•  

• Add FTP server entry in SAP Table.
• Maintain FTP entry in SAP table (SAPFTP_SERVERS_V) using tcode sm30
• SAPFTP_SERVER_V is a client dependent table. Add entry in those specific clients who are going to connect to FTP.

·        

• Click on the Maintain button & click on the New Entries button.

·        

• Add IP address, PORT and Description.

·        

• After maintaining entry click on the save button.

• Test FTP connection using SAP standard Program.
• Execute SAP program rsftp002 using tcode SA38.

·        

• Click on the execute button and enter details.

·        

•  

·        

• I am using RFC “SAPFTPA” as FTP is only accessible from the SAP server.

·        

• If the connection is not successful you get the error like below.

·        

• or like below.

 

 

 

·        

• If the connection is successful you will get the output like below.

All screenshots are captured by me.

• The above procedure will also work for the ABAP systems.
• Telnet is a very useful tool to check the service port and its accessibility from the target.
• Check on this link for more details about Telnet information
• SAPFTP_SERVERS_V Table is used to store the information about the allowed FTP server.
• Without entry in this table SAP will not able to establish the connection to the FTP server.
• If maintain * in this table all FTP servers will be accessible.
• FTP server by default runs on port 21, If the port is different so maintain that port in SAP_FTP_SERVER_V.
• Program RSFTP002 is used to test FTP connection and run execute FTP command.

• There are two RFC that we can use to access FTP.
• SAPFTP uses frontend/Local computer internet to access the FTP server.
• SAPFTPA uses backend/SAP server internet to access the FTP server.