Skip to Content
author's profile photo Former Member
Former Member

AS91: master table for cumulative values - Asset Value Fields

hi guys,

Asset master upload : tcode: AS91

I am able to upload the data with BAPI_FIXEDASSET_OVRTAKE_CREATE function module.

But my requirement is: one of the column for aseet value fields(AR = 10) in NON EDITABLE mode for Cumulative fields.

remaining two columns are AR=01 and AR15...WHICH ARE EDITABLE CS.

take over: cumulative table fields of BAPI (we can find the using code also)

when i provide the data for all the three columns, for third column,SAP is calculating itself (based on functional configuration, as it make non editable column) all the values.

when functional people enable the column by configuration, I am able to upload all the data properly.

But requirement is: functional people DONOT WANT to enable the column.(AR=10)

1)How can I upload the data to those non editable column fields. we have tried with BDC, LSMW, BAPI.

2)if want to update the DB table directly, as we could not find any option, what are the tables need to be uploaded?

I have gone thru ANLC Asset Value Fields. I can update this table.

are there any other tables, we need to update for legacy data upload ?

PLS HELP ME TO FIND THE TABLES, IF THERE IS NO SOLUTION AVAILABLE

TO THE ABOVE PROBLEM.

Edited by: puneindian on Jul 30, 2009 1:34 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 30, 2009 at 11:37 AM

    So functional requires

    - column must not be editable

    - column must be edited

    You are in trouble with this paradox, if you find a way to fulfil requirement, send an OSS message, you find a gap in system security.

    For database tables, look via SE36 at ADA logical database,

    But,

    If you update tables via open SQL statements, what will happen at first Depreciation Run, at first Year-End Closing, you wont be able to use Asset accounting in two years (previous year must be closed to open next year) , also there is a 99% chance that SAP reports will not care to your records, ANLC does not have records for derived depreciation area (there is nowhere to store this data...)

    So, go to functionnals and request two new depreciation areas, one for this legacy amount and another for the delta with the derived one, with a customizing if required to generate some postings in accounting....

    Go to forum to ask for this.

    Regards,

    Raymond

    Add a comment
    10|10000 characters needed characters exceeded

    • You must be very careful, as this can put the database in a state beyond repair

      (at least without new debug or open sql update executions...)

      First, do it in a sandbox with a handful of assets, execute at least two depreciation runs and some transfers, retirements and sales of assets with a "wild" change (before, between and after depreciation runs) - Check accounting documents generated, check depreciation area values.

      Then if all has good performed, execute a year end closing run to insure that you wont get a blocking error.

      Remember that if the field is locked (transaction and BDC as well as direct input or BAPI) SAP should better have a reason for that.

      Also "calculated" fields are not-input ready, cause they sometimes don't even exist in database and are dynamically generated by SAP program just before display takes place. (Most reports wont even try to read them in database, some will be "disturbed" by finding them)

      Expect long tests in qualification.

      Regards,

      Raymond

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2009 at 11:11 AM

    it is not possible to develop this thru programatically. Functionals should uncheck them and then only we can meet the requirement.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.