RE:[sap-log-sd] Account for credit memo

Posted by Roger Mou (SAP SD consultant)
on Jun 1 at 1:26 AM
Hi Waza,

I got it, thank you.

Best Regards

Roger

---------------Original Message---------------
From: wnash7658
Sent: Wednesday, June 01, 2011 12:21 AM
Subject: Account for credit memo

Just from a standard point of view. You could create a new table and add the "order reason" field and make it the first table in the access sequence. Maintain the return order reason in VKOA and then you can determine the alternate GL account when the CM posts to FI.

Regards


Waza

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Roger Mou
SAP Logistics Sales and Distribution Enthusiast

Contributed 100 posts in a group to earn a Bronze Achievement
Popular White Papers

In the Spotlight
Toolbox.com Marketplace: Take online training courses in SAP and other specialized areas of business and IT.
_.____.__

RE:[sap-log-sd] Sort order for printed messages in RV56ABST

Posted by wnash7658 (SAP Specialist and Project Leader)
on Jun 1 at 1:11 AM
Hello,

Please tell me if this helps. In the Ouput Type Definition, eg V/34 there is a tab called Sort Order.

Regards


Waza

---------------Original Message---------------
From: karlpe
Sent: Thursday, May 26, 2011 3:27 AM
Subject: Sort order for printed messages in RV56ABST

Dear Experts,

We are using the activity log for printing HU, delivery and shipment related messages to printers in the dispatch area, after the Shipment Completion status is set.

What are the possibilities (or best practices)

- to sort the printouts within one shipment (e.g. at first the Shipment documents, then the HU documents and then the deliveries)
- if 2 shipments are completed within a few seconds, to avoid that the printed outputs are mixed up (all documents belonging to one shipment should be in one compact package)

Thanks for your feedback
Karl

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
wnash7658
SAP Logistics Sales and Distribution Enthusiast

Contributed 500 posts in a group to earn a Silver Achievement
Popular White Papers

In the Spotlight
Which response to your Toolbox.com Groups post was the most helpful? Use 'Best Answer' to mark highest quality content.
_.____.__

RE:[sap-log-sd] How to join tables VBAK,VBAP,VBREVE,VBREVK,VEDA

Posted by rajivvarma (call center management)
on Jun 1 at 12:51 AM
Hi All,

My requirement is to create "license revenue report through SAP Query with following fields:

VBAK:
Sales Document,Sales Doc type,net value of sales order in document,sales org,distribution channel,division,sales office,business area,customer purchase order number,customer purchase order date,sold to party.
VBAP:
Sales document item,target quantity in sales units,target quantity in UOM,usage indicator,billing block for item,business area,plant(own or external),
origin of bill of material,net price,SD document currency,material pricing pgroup,account assignment group for this material,activity type,personnel number.
VEDA:
contracts start date,contract end date,date on which contract is assigned.,installation date,agreement acceptance date
VBREVK:
clearing account for accrued revenues,clearing accountkey(offsetting account),total accrued value,currency key,amount in document currency,posting year and posting period.
VBREVE:

revenue amount,currency key,accrual period,company code,country of destination,profit center,posting year and posting period,amount in document currency,gl account,account for deferred revenue,account for non billed receivable

Is there any standard logical data base which gives all the required fields mentioned above? since i am not SD consultant i am not sure whether i have to take only above tables exactly or not

there are certain logical databases like SD_ORDER,SD_SALES_DOCUMENT which has tables VBAK,VBAP,VEDA but i am unable to join remaining tables VBREVE and VBREVK with those logical data bases

Please throw some light on this.

Thanks&Regards

Rajiv.

---------------Original Message---------------
From: LCC352
Sent: Tuesday, May 31, 2011 9:24 AM
Subject: How to join tables VBAK,VBAP,VBREVE,VBREVK,VEDA

Rajiv,

Given the tables you say you need to join, there is no one way to join them so that you will not get duplicates. You have to attack the tables one at a time after the initial pull from VBAK/VBAP and figure out which records you really want based on the data you see coming from the database. Maybe you need a field on one of the other tables that is duplicating, but it's the same value in each row in the other table. If that's the case, you can take one value and throw the rest away.

I hope that helps. - Lou

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
_.____.__

RE:[sap-log-sd] Account for credit memo

Posted by wnash7658 (SAP Specialist and Project Leader)
on Jun 1 at 12:20 AM
Just from a standard point of view. You could create a new table and add the "order reason" field and make it the first table in the access sequence. Maintain the return order reason in VKOA and then you can determine the alternate GL account when the CM posts to FI.

Regards


Waza

---------------Original Message---------------
From: Roger Mou
Sent: Tuesday, May 31, 2011 11:16 PM
Subject: Account for credit memo

Greeting,

I remember if we create a credit memo in SAP, after billing be posted , the standard SAP always reverse the revenue account, could we assign another account? If yes, please share your knowledge to me.

Thanks & Best Regards

Roger

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
wnash7658
SAP Logistics Sales and Distribution Enthusiast

Contributed 500 posts in a group to earn a Silver Achievement
_.____.__

[sap-log-sd] Account for credit memo

Posted by Roger Mou (SAP SD consultant)
on May 31 at 11:15 PM
Greeting,

I remember if we create a credit memo in SAP, after billing be posted , the standard SAP always reverse the revenue account, could we assign another account? If yes, please share your knowledge to me.

Thanks & Best Regards

Roger
__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
View this online
  
Roger Mou
SAP Logistics Sales and Distribution Enthusiast

Contributed 100 posts in a group to earn a Bronze Achievement
Popular White Papers

In the Spotlight
Toolbox.com Marketplace: Take online training courses in SAP and other specialized areas of business and IT.
_.____.__

RE:[sap-log-sd] G/L account determined but account determine error

Posted by Roger Mou (SAP SD consultant)
on May 31 at 11:01 PM
Hi Typewriter ,

Sometimes, the standard tables created by SAP are not fit for particular request, therefore, we can create our owned table.

For question 2, SAP is going to warning you if there is a table with same fields.

Best Regards

Roger

---------------Original Message---------------
From: Roger Mou
Sent: Tuesday, May 31, 2011 2:47 AM
Subject: G/L account determined but account determine error

Greeting,

I've created a new condition for G/L account determination in IMG for billing document and setup necessary in VKOA, but the account determination always show account determine error when billing document be posted, I've checked into revenue account analysis, system show me G/L account determined from account determination type ZOEM; is there anything I need to notice? please share your knowledge to me if there is any experts know how to solve this issue.

Thanks & Best Regards

Roger

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Roger Mou
SAP Logistics Sales and Distribution Enthusiast

Contributed 100 posts in a group to earn a Bronze Achievement
_.____.__

RE:[sap-log-sd] EDI1 case

Posted by wnash7658 (SAP Specialist and Project Leader)
on May 31 at 10:46 PM
Don't understand your question.

Regards


waza

---------------Original Message---------------
From: sapsd
Sent: Monday, May 30, 2011 10:21 AM
Subject: EDI1 case

Hi guys,

In Sales Order type ZOR, message "Expected Price" is being issued whenever there is a difference between Net price and EDI1 price.
When EDI1 price is equal to Net price there is no "Expected Price" message.
This is being controlled by EDI1 pricing.
Validation performed by EDI1 needs to be suppressed to expect the requested changes to behave in the way it has been requested.
How can this be done? Any suggestions? your reply is highly appreciated.
Thank you in adavance.

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
wnash7658
SAP Logistics Sales and Distribution Enthusiast

Contributed 500 posts in a group to earn a Silver Achievement
_.____.__

Re: [sap-log-sd] Difference between Condition update and Rebate

Posted by jagannath_mohakhud (mr)
on May 31 at 9:57 PM
*Rebate*:an incentive to be given to a customer .clubbed with qty purchased
by a customer within the period specified (say one month)-conditional.

*Discount:unconditional* to be given to a customer on account of heavy
purchase by one single billing.-From the price List(Base price).

Regards

email@removed

---------------Original Message---------------
From: vivek chowdary
Sent: Tuesday, May 31, 2011 9:30 PM
Subject: Difference between Condition update and Rebate

Hi Guys,

When I see the functionality of condition update,it seems similar to Rebates,the only difference find is in Rebates the discounts are accrued but in condition update the discounts are applied when the sales orders are created.
So, please let me know if there any other differences in the two.

Thanks,
Vivek

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Popular White Papers

In the Spotlight
Which response to your Toolbox.com Groups post was the most helpful? Use 'Best Answer' to mark highest quality content.
_.____.__

[sap-log-sd] Difference between Condition update and Rebate

Posted by vivek chowdary
on May 31 at 9:30 PM
Hi Guys,

When I see the functionality of condition update,it seems similar to Rebates,the only difference find is in Rebates the discounts are accrued but in condition update the discounts are applied when the sales orders are created.
So, please let me know if there any other differences in the two.

Thanks,
Vivek
__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
View this online
  
Popular White Papers

In the Spotlight
Toolbox.com Marketplace: Take online training courses in SAP and other specialized areas of business and IT.
_.____.__

RE: [sap-log-sd] SD-credit card setup

Posted by ebushman (VP, Solutions Engineering)
on May 31 at 2:43 PM
Adoss,

I've participated in over 300 projects related to the Payment Card Processing functionality in various SAP products in the past 14 years. There are a variety of suggestions I could make, but let me keep my initial response limited. Here are some items I'd suggest you consider:

? Plan on a project to implement the Payment Card Processing functionality to last 2-4 months in duration. You won't have people spending 8 hours a day every day for that time working on the project, but the project duration tends to last that long.
? If you plan to accept B2B payments and Purchase Cards (Corporate Cards) expect the project to last 2-4 weeks longer because you'll be mapping data that SAP didn't include in the standard Cross Application Payment Card Interface (CA-PCI)
? Obtain the Merchant Account IDs from your processor partner(s) as soon as possible if you don't already have them. You'll need to have Treasury and Legal departments involved if you're setting up new accounts and I've seen delays in setting up accounts drag projects out for months.
? Learn as much as you can about what SAP designed the business logic to do. As with anything in SAP, the business logic likely won't be a 100% fit for your needs, but you'll be better off if you can conform as much as possible to how SAP designed the workflow.
? Decide in advance what card types you wish to accept. Which currencies you want to accept payments in. If you want to accept payments with just the standard SAP logic (card entered during Sales Order creation) or if you need the ability to process payments against open invoices in the FI module and need to use custom functionality from a third-party.
? Start reading up about PCI-DSS (https://www.pcisecuritystandards.org) if you haven't already. It WILL affect you in your project. Compare Tokenization to Encryption and understand the benefits that Tokenization has over Encryption.
? You should only consider using a third-party solution if it is SAP certified.
? The configuration of the business logic in SAP's products is the easiest part of a project. The harder parts are testing, end-user training and certification (either with your processor or middleware provider).
? Make certain you understand how to RECONCILE the deposits from your processor with the Settlement Batches submitted by SAP. And then RECONCILE the deposits EVERY DAY!!! Do NOT let a day go by without RECONCILING!
? Remember, the business logic is provided by SAP. SAP maintains it, patches it, enhances it, supports it. The middleware provider may understand it, enhance it and train you on it, but ultimately it is SAP's product.

That should be a good start. If you have any more specific questions I'm always happy to respond.


Regards,

Eric Bushman
www.paymetric.com

---------------Original Message---------------
From: adoss
Sent: Tuesday, May 31, 2011 11:05 AM
Subject: SD-credit card setup

Has someone done credit card payment setup in SAP, and woud like to share experience :
the steps to go throhgh,
pit falls to avoid, etc..

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
ebushman
SAP Logistics Sales and Distribution Enthusiast

Contributed 100 posts in a group to earn a Bronze Achievement
Popular White Papers

In the Spotlight
Toolbox.com for iPhone & Android: Ask Questions & Get Answers Anywhere. Download the Free App
_.____.__

RE:[sap-log-sd] G/L account determined but account determine error

Posted by Typewriter
on May 31 at 2:13 PM
Hi Experts, Roger,

2 questions -

1. Why does SAP permit multiple tables with the same fields?
One reason I can think of is - sames fields, but different arrangement. e.g. -
In VK11, header part = Customer, item part = Material
or item part = Customer, Material

2. SAP does give a warning message, during creation of a table, if a condition table with the same field already exists. Could it be prohibited to make duplicate condition tables via configuration?

Thank you,
Typewriter

---------------Original Message---------------
From: Roger Mou
Sent: Tuesday, May 31, 2011 2:47 AM
Subject: G/L account determined but account determine error

Greeting,

I've created a new condition for G/L account determination in IMG for billing document and setup necessary in VKOA, but the account determination always show account determine error when billing document be posted, I've checked into revenue account analysis, system show me G/L account determined from account determination type ZOEM; is there anything I need to notice? please share your knowledge to me if there is any experts know how to solve this issue.

Thanks & Best Regards

Roger

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Typewriter
SAP Logistics Sales and Distribution Helper

Posted helpful replies on 5 threads in a group to earn a Bronze Achievement
_.____.__