SAP ABAP IMG Activity SIMG_CGJB01JBLC35 (Transfer Category 035: Non-Interest Profit and Loss Item)
Hierarchy
☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-SA-ALM (Application Component) Asset/Liability Management
     ⤷ JBA_US (Package) Analytical Banking US
IMG Activity
ID SIMG_CGJB01JBLC35 Transfer Category 035: Non-Interest Profit and Loss Item  
Transaction Code S_ALN_01001741   (empty) 
Created on 20030306    
Customizing Attributes SIMG_CGJB01JBLC35   Transfer Category 035: Non-Interest Profit and Loss Item 
Customizing Activity    
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name SIMG_CGJB01JBLC35    

Receiver Structure

The receiver structure for the data transfer is JBDINIPL. The following tables are filled with data in the transfer process:

  • JBNIPL (header table for non-interest profit and loss items)
  • JBNIPL_DATA (item table for non-interest profit and loss items)
  • ONR00 (table for financial object numbers)
  • DI_MODE Mode (I = insert/create, U = update/change)

Header and item structure

  • External data transfer sequence
    • When non-interest profit and loss items are transferred, the header record is followed by the corresponding item records.

If headers and items have already been created, you can change them as long as both record types are included. Do not submit headers without items, and visa versa.

  • Identification of header/item records
    • SEM Banking identifies the transferred records based on the contents of selected fields in the receiver structure. Fields used for identification are marked with an "X" in the chart below.

Fields    Meaning    Header    Item

IDNUM    Key of non-interest profit and loss    X    X

BUKRS    Company code    X

WAERS    Currency   

OBJNR    Financial object key

SANLF    Product category

SFGTYP    Transaction category

SGSART    Product type

SFHAART    Transaction type

PERIOD_DATE    Period date for non-interest profit and loss        X

AMOUNT    Amount of non-interest profit and loss item        X

DI_MODE    Indicator for mode: insert, update or delete

SEGMENT    Indicator for segment (leave blank)

The system automatically determines a record to be an item if the record contains data in the field period date for non-interest profit and loss (PERIOD_DATE) or in the field amount of non-interest profit and loss item (AMOUNT). If both the date and amount are blank and the key of non-interest profit and loss (IDNUM) and company code (BUKRS) are populated, the record is considered a header record.
Also note that even though IDNUM and BUKRS are used to identify a header for direct input purposes, the actual key for non-interest profit and loss system objects is IDNUM by itself.
Important: This means that the same IDNUM key cannot be used with more than one company code.

  • Data relationship to header/item records
    • The above chart shows which fields are used to identify header and item records. However, the following chart shows which fields can be populated depending on the record type.

Field relation to type : ('R' = required field, 'O' = optional field, 'D' = dependant on mode)

Fields    Meaning    Header    Item

IDNUM    Key of non-interest profit and loss    R    R

BUKRS    Company code    R   

WAERS    Currency    R   

OBJNR    Financial object key    D   

SANLF    Product category    R   

SFGTYP    Transaction category    O   

SGSART    Product type    R   

SFHAART    Transaction type    R   

PERIOD_DATE    Period date for non-interest profit and loss        R

AMOUNT    Amount of non-interest profit and loss item        R

DI_MODE    Indicator for mode, insert, update or delete    R    R

SEGMENT    Indicator for segment (should leave blank)   

Note: The OBJNR is the key which ties a non-interest profit and loss to the financial object within SEM Banking. This field can be left blank for new records only. See special feature below for more details.

Check concept for a non-interest profit and loss data transfer

The system carries out different checks depending on the validation level you have specified:

  1. Check level O - No checks
  2. Check level 1 - Basic checks made, and if problems are found, errors are raised and processing stops. Check details are as follows:
    • Header record checks:
      • a) Check for missing data. Data must be provided in:
      IDNUM
      BUKRS
      WAERS
      SANLF
      SGSART
      SFHAART
      b) Check for correct data in fields:
      BUKRS
      SGSART
      SFHAART
    • Item record checks
      • a) Check for missing item key data
      b) Check that all amounts are positive
  3. Check level 2 - In addition to check level 1 checks, the header and item fields are examined for the correct mode. If problems are found, warnings are raised and modes are corrected. Correct mode depends on whether a record has already been saved in the system. For example, if records were previously uploaded, the header should be marked as an update record. If not correct, mode is overridden and a "U" (update) is placed into the mode field. Respectively for new records, an "I" (insert) is used.
  4. Check level 3 - The same check as in check level 2. However, instead of raising warnings, errors are raised, no corrections are made, and processing stops.

Special Features

  • Creation of financial object numbers
    • Newly created non-interest profit and loss header records do not require that the OBJNR field be populated for direct input. The system automatically creates the object number at runtime by concatenating the following:

  • Constant "PL" - Suffix for all non-interest profit and loss objects (Char 2)
  • BUKRS - Company code (Char 4)
  • IDNUM - The non-interest profit and loss unique key (Char 16)
    • Thus creating a char 22 unique key that will be updated into the ONR00.
    As creation of the object number is required before uploading related financial object data, you should therefore upload non-interest profit and loss records first using this transfer category (35) before using financial object category 001.
Business Attributes
ASAP Roadmap ID 308   Transfer Data to Live System 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 1   Critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG SIMG_CGJB01JBLC35 0 I070004706 External Data Transfer 
Maintenance Objects
Maintenance object type    
History
Last changed by/on SAP  20030618 
SAP Release Created in 200