on 08-30-2007 11:16 AM
Hello SD gurus,
Can u tell me
1. What documents are generated after saving Billing document?
2.While creating a Sales Order, Pricing procedure is not determined automatically, what could be the reason?
3.What is an ABAP Query? How is it different from ABAP reports?
4.How can we assign one credit limit to two customers?
5. How can we process outbound delivery without shipping point?
My id : raaj_sap@rediffmail.com
Appreciate your information and will definitely reward points.
Regards
Rajarshi
Hi Rajarshi,
<b>What documents are generated after saving Billing document?</b>
Accounting document is created by the system.
<b>While creating a Sales Order, Pricing procedure is not determined automatically, what could be the reason?</b>
Pricing Procedure is determined by Sales Area + Doc.Pric Proc + Cust Pric Proc.
The configuration can be done in [OVKK]. Check if you have an entry for the combination as explained below.
The Sales Area is picked from the Order Document that is being created. The Doc Prcing Proc is picked from the Sales Document Type [VOV8]. The Cust Pric Proc is picked from the cust master -> Sales Area View -> Sales Tab.
<b>What is an ABAP Query? How is it different from ABAP reports?</b>
ABAP query is used to create simple reports using simple joins and does not require programming knowledge. ABAP reports can be created using multiple tables and requires programming knowledge.
ABAP queries are created using [SQ01]. While ABAP reports are created using [SE38].
<b>How can we process outbound delivery without shipping point?</b>
It is not possible to create a delivery without a shipping point.
Regards
NP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For service item, i.e for statistical delivery, do we need specific shipping point?
One credit limit to two customer is not possible. if any specific scenario is there, just let us know we will try it.
For document genereted after billing, go to Help file, you will get the detail.
here is the documents get updated after billing
Customer accounts receivable
General ledger (for example, a cash clearing account)
Revenue
Sales deductions
Accruals (for rebate agreements)
Accrual account
Accrual clearing account
Reward
If it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajarshi,
1. After saving billing document, Accounting doument is generated in FI & customer accounts, sales acconts are updated.
2.Pricing procedure is determined by the following combination -
Sales areaDPPCPP+Pricing procedure.
Since a sales document is created wrt sales area, sales area triggers to determine the pricing procedure. If not the system proposes that...pricing procedure is not determined for the customer or sales area or for doument.
3. ABAP query is a program to generate a report based on the selected tables. ABAP reports are created if the requirment is to fetch the data of complicated logics. There will be no use of any logics in ABAP queyr. ABAP reports have the flexibility of generating reports with logics as per the requirement.
4.
5. Any delivery must have a shipping point to execute. Shipping point is the base fior processing a delivery. I a not sure if delivery is created without a shipping point.
Regards,
Praveen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
tell me in which scenorio you want to grant one credit limit to two customers.
At any time u r going to maintain credit limit on customer basis only.
If u want to do u have to change the original functionality of SAP.
Regards,
Sivalingeswara Rao.B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Difference between Reports and Queries
Reports:
Reports are completely generated with the help of codes that are written by ABAPers.
Normally you would find Z Reports. For Example: We have VFRB T-code for Retro Billing Standard SAP Report. When some changes are required in the input and the output of this report, we need to copy this in ZVFRB and then add / delete fields in the input selection screen as well as output of the report depending upon the customers requirement. So in this ABAPers will write the code and do the changes line by line. Same thing applies when customer comes up with a requirement of capturing data via report for which there is no standard SAP report available. In this case we need to design the input selection screen and then the output of the report and then ABAPers will write the code to accomplish this.
Query:
Query is an option available with both functional as well as technical consultants to generate reports:
We have t-codes:
SQ01
SQ02
SQ03
We use these t-codes to generate a query. For example: You have a requirement of merging two tables VBAK and VBAP in order to get an output that shows Sales doc, material number, sales Org, Dist Ch, Div and plant.
You can generate a user group and then assign to user id and then create an infoset and run a querry. Infoset is an option where you specify VBAK and VBAP tables and then the above mentioned fields will be available for selection. Later you give the input say sales document number and then execute this to get the output showing Sales doc, material number, sales Org, Dist Ch, Div and plant. So basically queries are standard options available in SAP to generate our own input selection and output of reports as per our convenience. When it is not possible for us to select / merge different tables and get the desired output, then we go for Z Report (code written by ABAPers)
<b>Reward if helpful.</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1CO PA
CUSTOMER REACIVABILE ACCOUNTS
REVENU ACCOUNTS
2.ASSING THE PRICING PROCEDURER TO SALES AREA
3.;
You can use the ABAP Query to create your own evaluations without any knowledge of the ABAP programming language or table and field names.
You can define three types of evaluations:
- Basic lists
- Statistics
- Ranked lists
You can also combine these three groups as desired.
ABAP Query Authorizations: To use an ABAP query, the user must have appropriate authorizations. Two ways of providing authorizations to the users are as follows:
- User groups
The user should be a part of at least one user group to run the corresponding ABAP query. This automatically restricts the access of the user to specific functional areas, and thus the corresponding underlying logical databases.
- Authorizations
The authorization object S_QUERY should be used to give proper authorizations to the user for a query. This authorization object has a field named ACTVT which can take values 02 for Change, 23 for Maintain and 67 for Translate.
4. NOT POSSIBILE
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.