Automatic generation of AAR on position indicator

[hein_nagel]

Hello

On securities 04I, 04x..... When i execute ts01 or ftr_create, i get warning NO AAR(Account assignment reference) found, i then manually create on envionment-position indicator, my AAR are defined by product type and portfolio. What can be wrong on my configuration. I have NCD'S which i defined only by product type under securities its pulling automatic the AAR, why is this?

Thanks in advance

Victor

Edited by: Hein Nagel on Jan 5, 2010 11:55 AM

[Former Member · Accepted solution]

Hi Victor,

You need to define Determination procedure for AAR in TPM30/TPM32 so that automatic AAR can be derived. While defining determination procedure Key figures are to be defined like Product TYpe, portfolio etc as in your case.

Regards

Prasad AV

[hein_nagel · Accepted solution]

Dertimination procedure has been defined on TPM30 (securities) and TPM32 (Money markets), but i still get error no AAR found, all money market instruments are generating automatic,its only some securities which are not generating automatic

[Former Member · Accepted solution]

Hi,

Try under

Securities

Position Indicator

Define Generation of Securities Account Position Indicator

Define Generation of Subledger Position Indicator

Select "Generate Position Indicator Automatically".

Manish

[hein_nagel · Accepted solution]

Hello

The settings below have been done

Securities

Position Indicator

Define Generation of Securities Account Position Indicator

Define Generation of Subledger Position Indicator

"Generate Position Indicator Automatically". is selected

i would like to find out under ORIGIN BT, what should i select is it "transaction management", or "transfer account assignment reference" etc

Victor

[Former Member · Accepted solution]

Hi,

It should be "Transaction Management"

Regards

Prasad AV

[hein_nagel · Accepted solution]

Hello

I have it as transaction management, still error "No AAR found", what else can be wrong.

Victor

[hein_nagel · Accepted solution]

Hello

I have it as transaction management, still error "No AAR found", what else can be wrong.

Victor

[Former Member · Accepted solution]

Hi,

Please test your derivation rule in TPM32 itself before getting derived at transaction level. if its tested in tpm32 there should not be any problem while creating trasaction. Else, check all other derivations and find whether the same product type combination is already defined with any other derivation rule or not?

Regards

Prasad AV

[hein_nagel · Accepted solution]

Hello Prasad

On testing on tpm30, everything seems to be fine, note that each product type say 04I, is used for more than 2 portflios, in other ways

04I_DMTN DMTN is the portfolio

04I_ISSU ISSU is the portfolio etc

Victor

[Former Member · Accepted solution]

Hi,

If your derivation is deriving AAR in TPM30, there should not be any problem while creating also.

You can check now at FTR_CREATE, Environment- try to get the AAR filled automatically by clicking the option available there. If it is getting derived automatically then your definition of derivation rule is OK, else needs to check at again in the TPM30/32 only.

Regards

Prasad AV

[hein_nagel · Accepted solution]

Hi Prasad

I made an enquiry at sapag and they requested that i define and assign differentiation portfolio, since i am using it to define AAR, I did that and started getting a dump error, i have since removed it, this is my settings is this the correct way;

under define differentition

PORTFOLIO

SEC ACCOUNT

Under assign terms

PORTFOLIO

SEC ACCOUNT

Under assign differentition

SEC ACCOUNT

Is this correct, will creating new class master and transaction after

changing setting now affect

secondly without having portfolio here there is noway to have position

indicator pulling automatic confirm this

Victor

[Former Member · Accepted solution]

Hi,

Your settings seems OK but you will not be able to generate position report based on Securitiy A/c basis which is more critical as Security A/c are mapped as Depository Account (Custodian A/c).

The dump you are getting becase, if you try to create transaction for Security ID which have already position with previous settings, system technically unable to support and ends with runtime.

I can suggest a option, instead of defining Portfolio as a differntiation critiera, you can design General Valuation class equal to Portfolio mapping and define AAR accordingly if you are not using General Valuation Calss already.

Regards

Prasad AV

[hein_nagel · Accepted solution]

Hi Prasad

Do you suggest that i leave the settings as they are, am not sure what you mean by that i am already using valuation class, valuation class 001 is used,how do i design General Valuation class equal to Portfolio mapping. AAR is defined by product type and portfolio, and we cannot change this definition

Victor

Edited by: Hein Nagel on Jan 27, 2010 2:22 PM

[Former Member · Accepted solution]

Hi,

I have suggested only an alternative, if you are not using Gen Val Class for any reporting purpose you can map it to same level like Portfolio and can use Gen Val Class as a field in derivation rule instead of using Portfolio.

Your problem is for deriving AAR automatically with criteria Portfolio or equal category, so try to achieve the reqmt by using some other key fields available in TPM30/32 for Securities transaction like Gen Val Class.

Regards

Prasad AV

[hein_nagel · Accepted solution]

Hi Prasad

My problem is the client's requirementS, their GL accounts are per portfolio, so i guess there is no other characteristic which i can use to achieve that, Gen Valauation class,is not unique all bonds which they will have similar if not same class. In other words when using portfolio as a determinant, there is no way it can pull automatic. Tell me whats the use of defining diifferentiation, should i still have portfolio and sec account there defined and assigned, can assign both or there has to be one

Victor

Edited by: Hein Nagel on Jan 27, 2010 3:24 PM

[Former Member · Accepted solution]

Hi,

I see from your earlier post that

+under define differentition

PORTFOLIO

SEC ACCOUNT

Under assign terms

PORTFOLIO

SEC ACCOUNT

Under assign differentition

SEC ACCOUNT

Is this correct, will creating new class master and transaction after

changing setting now affect

secondly without having portfolio here there is noway to have position

indicator pulling automatic confirm this+

Here what SAP has asked you to do is assign your Portfolio under assign differentiation for securities option for your val area and accounting code. But if you already have active transactions with earlier differentiation, then you will not be able to change here. This means that you manage your positions in the subledger at the portfolio level.

Regards,

Ravi

[hein_nagel · Accepted solution]

Hi Prasad,

i have decided to define determination procedure using product type and Securities Account,(this is because all my securieties accounts are named based on the portfolio) its seems this way it will pull on the position indicator automatically, do you think there might be negative implications.

Prasad, do you have knowledge on pricing index bonds on sap, i have posted various request on this but no one seems to respond.

Victor

[Former Member · Accepted solution]

Hi Victor,

This is the right one. Yesterday I was suggesting to use this kind of mapping. Now your problem will be solved.

Regards

Prasad AV

[Former Member · Accepted solution]

Hi,

You can have differentiation based on security account/portfolio. If you have it based on portfolio, then you can maintain AAR based on portfolio.

If you have differntiation based on security account, then you can maintain aar based on account.

You have not maintained differentiation as portfolio yet. It is not enough if you maintain a differentiation term. You have to assign that differentiation to securities. You can change that if you dont have any active security transaction based on this differentiation.

Regards,

Ravi

[hein_nagel · Accepted solution]

Hi Ravi

Diffrentiation is currently on sec account, if i change it to portfolio, i get a dump error but i have since created new sec accounts based on the portfolio, do you think i have change it now it will still created problems because transaction already created were based on previous sec accounts, so all new transactions will have a new sec account, but i created these while differentian was still on sec account, can i change to portfolio. Note that i am working on test client 100.

Victor

[Former Member · Accepted solution]

Hi Victor,

If you already have transactions which are based on the previous differntiation, then you cannot change the differntiation rule.

You can create different security account based on your portfolio.

But please note that the security account in SAP corresponds to the actual security account with the bank and the account in which the security is traded actually. But if your client is not going to use separate accounts for every portfolio, then you should not use this mapping.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Victor,

There is 1 way for your requirement.

In the configuration, securities -- master data -- specific class data -- interest bearing securities, there is an option to create classification for bonds and assign it to your product type.

Here you can create portfolios as classification and assign it to your product type.

So when you create the ID itself, you have the option to choose the classification for this product type.

This bond classification is one of the parameters that can be used while creating AAR.

Regards,

Ravi

Edited by: Ravishankar Ramamurthy on Jan 28, 2010 6:04 PM