SAP ABAP Data Element FC_UPDMODE (Update mode)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ EC-CS (Application Component) Consolidation
     ⤷ FC00_UC (Package) Cons: General consolidation (cannot be assign.to FC01-FC09)

Basic Data

Data Element	FC_UPDMODE
Short Description	Update mode

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	FC_UPDMODE
Data Type	CHAR	Character String
Length	1
Decimal Places	0
Output Length	1
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Upd. mode
Medium	15	Update mode
Long	20	Update mode
Heading	3	Upd

Documentation

Use

Determines the manner in which data record values that have previously been uploaded are treated. One mainly distinguishes between uploaded data that consists of item-specific values with subassignments, in particular financial data, or data that consists of other data, such as master data or Customizing settings.

• Financial Data

  Data is uploaded in blocks. Each block consists of all data records that share the same values for the following characteristics: Ledger, cons chart of accounts, dimension, version, fiscal year, period and consolidation unit. You can choose from the following four update modes:

• Delete - all FS items, all subassignments
All existing records in a block are reset to zero.
• Delete - uploaded items, all subassignments
All existing records in a block for all uploaded items are reset to zero. Records with items not contained in the upload file remain untouched.
• Overwrite - uploaded items and subassignments
Only the uploaded records are written. Any existing records that share the same item and all of the same subassignments are overwritten.
• Apportion (like 'Overwrite' but total per item does not change)
The existing value of an item is apportioned among the uploaded subassignments, but the total value of the item remains unchanged. This is accomplished by posting an automatic offsetting entry to the respective default subassignment. (This function currently supports partner units only.)

Note:
In all of these modes, the uploaded records overwrite any existing records that share all of the same subassignments. New records are always written.

• Master Data, Customizing Settings and Additional Financial Data

  As with the item-specific data, the update modes for the "other data" also only concern one block of uploaded data records at a time. The block size is dependent on a superior criterion. For dependent characteristics, this is usually the associated independent characteristic. The following modes are supported:

• Delete all
All of the existing data records that belong to a block are deleted prior to writing the uploaded data records.
• Delete uploaded records
All records are deleted before being uploaded to a block.
• Overwrite
The uploaded records are written, thereby overwriting any existing entries. Other settings remain untouched.
• Do not modify
Records are only added. Existing settings are not modified.

In the following section, the characteristics for all available uploads are named, as well as the respective object, which the upload method refers to:

• Consolidation Groups
Block: dimension
Object: consolidation group
• Consolidation Units
Block: dimension
Object: consolidation unit
• FS Items
Block: cons chart of accounts
Object: Position
• Subitems
Block: subitem category
Object: subitem
• Breakdown Categories
Block: cons chart of accounts
Object: breakdown category
• Fair Value Adjustments (master data)
Block: dimension, consolidation unit
Object: fair value adjustments
• Product Groups
Block: -
Object: product group
• Custom Characteristic
Block: -
Object: custom characteristic
• Changes in Investment
Block: ledger, cons chart of accounts, dimension, version, fiscal year,
period, consolidation unit
Object: investee unit
• Changes in Investee Equity
Block: ledger, cons chart of accounts, dimension, version, fiscal year,
period, investee unit
Object: activity equity
• Equity Holdings Adjustments
Block: ledger, cons chart of accounts, dimension, version, fiscal year,
period, investee unit
Object: scope of reported data, equity method
• Goodwill / Negative Goodwill
Block: cons chart of accounts, dimension, version, fiscal year, period,
consolidation group, consolidation unit, investee unit
Object: activity consolidation of investments
• Fair Value Adjustments (reported values)
Block: ledger, cons chart of accounts, dimension, version, fiscal year,
investee unit
Object: fair value adjustments
• Inventory Data
Block: dimension, cons chart of accounts, version, fiscal year, period,
inventory managing consolidation unit
Object: supplying consolidation unit (partner unit)
• Supplier Data
Block: dimension, version, fiscal year, period, supplying consolidation
unit
Object: inventory managing consolidation unit (partner unit)

Examples

• Reported Data, Update Modes 1-3

  Say, the following records have already been written within a given block:

  Item    Partner    Value in Local Currency
  111111    A     100
  222222    B     200
  333333    C     300
  

  New records to be written are:

  Item    Partner    Value in Local Currency
  111111    A     400
  111111    B     500
  222222    A     600

  Applying the various update modes result in the following list of records:
  

• Delete (all FS items, all subassignments)

  Item    Partner    Value in Local Currency
  111111    A     400
  111111    B     500
  222222    A     600
  222222    B     0
  333333    C     0
  

• Delete (uploaded items, all subassignments)

  Item    Partner    Value in Local Currency
  111111    A     400
  111111    B     500
  222222    A     600
  222222    B     0
  333333    C     300
  

• Overwrite (uploaded items and subassignments)

  Item    Partner    Value in Local Currency
  111111    A     400
  111111    B     500
  222222    A     600
  222222    B     200
  333333    C     300

• Reported Data, Update Mode 4

  Say, the following record was already written within a given block: (The default partner unit is X.)

  Item    Partner    Value in Local Currency
  111111    X     1000
  

  New records to be written are:

  Item    Partner    Value in Local Currency
  111111    A     400
  111111    B     500
  

  Applying the update mode Apportion results in the following list of records:

  Item    Partner    Value in Local Currency
  111111    A     400
  111111    B     500
  111111    X     100
  

• Consolidation Units

  Say, a given dimension contains the following consolidation units (with respective settings):

  Cons Unit    Name    Version    Data TransferMethod

  C1000        Old_1000    100        M (Online entry)

  C2000        Old_2000    100        O (Rollup)

  C2000        Old_2000    200        P (Periodic extract)

  New records to be written are:

  Cons Unit    Name    Version    Data TransferMethod

  C2000        New_2000    200        R (Realtime update from FI)

  C2000        New_2000    300        U (Flexible upload)

  C3000        New_3000    100        X (Interactive Excel)

  Applying the varios update modes result in the following list of records:

  (Please note that the data transfer method is version-dependent - but not the name.)
  

• Delete all

  Cons Unit    Name    Version    Data TransferMethod

  C2000        New_2000    200        R

  C2000        New_2000    300        U

  C3000        New_3000    100        X
  

• Delete uploaded records

Cons Unit    Name    Version    Data TransferMethod

C1000        Old_1000    100        M

C2000        New_2000    200        R

C2000        New_2000    300        U

C3000        New_3000    100        X

• Overwrite

Cons Unit    Name    Version    Data TransferMethod

C1000        Old_1000    100        M

C2000        New_2000    100        O

C2000        New_2000    200        R

C2000        New_2000    300        U

C3000        New_3000    100&nb

History

Last changed by/on	SAP	19981210
SAP Release Created in