Gasser ERP Consulting

Customizing: Posting Period Variant per GAAP

2012-01-20T04:24:00.000-08:00

In NewGL one can assign a separate Posting Period Variant per ledger (usually representing different GAAP's). In customizing this setting is quite hidden:

It is in the setting for non-leading ledgers, accessible via customizing menu SPRO.

ABAP Tool: Great stuff

2011-08-01T08:45:00.000-07:00

Thanks to Frank.

*&-----------------------------------------------------------*
*& Report Z_UPLOAD_TOOL
*&
*&-----------------------------------------------------------*
*&
*& Loads every file up and down
*&-----------------------------------------------------------*

REPORT Z_UPLOAD_TOOL.
tYPE-POOLS: abap.

PARAMETERS: tabname TYPE tabname16,
download RADIOBUTTON GROUP radi,
upload RADIOBUTTON GROUP radi.

DATA l_tab TYPE TABLE OF sdokpath.
DATA l_wa_tab TYPE sdokpath.
DATA l_path TYPE string.
DATA l_wa_ref TYPE REF TO data.
DATA l_offset TYPE i.
DATA load(2) TYPE c.

FIELD-SYMBOLS: <l_string> TYPE ANY,
               <f1> TYPE abap_compdescr,
               <l_wa_tab> TYPE ANY.

DATA l_wa_data_tab(2000) TYPE c.
DATA l_data_tab LIKE TABLE OF l_wa_data_tab.

DATA l_descr_ref TYPE REF TO cl_abap_typedescr.
DATA l_struc_ref TYPE REF TO cl_abap_structdescr.

CONSTANTS: con_download(2) TYPE c VALUE 'DL',
           con_upload(2) TYPE c VALUE 'UL'.

START-OF-SELECTION.

IF download EQ 'X'.
    load = con_download.
ELSE.
    load = con_upload.
ENDIF.

CASE load.

    WHEN con_download.

      CREATE DATA l_wa_ref TYPE (tabname).
      ASSIGN l_wa_ref->* TO <l_wa_tab>.

      SELECT * FROM (tabname) INTO <l_wa_tab>.

        l_wa_data_tab = <l_wa_tab>.
        APPEND l_wa_data_tab TO l_data_tab.

      ENDSELECT.

      CALL FUNCTION 'TMP_GUI_FILE_OPEN_DIALOG'
        EXPORTING
          window_title = 'DOWNLOAD'
        TABLES
          file_table   = l_tab
        EXCEPTIONS
          cntl_error   = 1
          OTHERS       = 2.
      IF sy-subrc <> 0.
      ENDIF.

      READ TABLE l_tab INTO l_wa_tab INDEX 1.
      l_path = l_wa_tab.

      CALL FUNCTION 'GUI_DOWNLOAD'
        EXPORTING
          filename                = l_path
        TABLES
          data_tab                = l_data_tab
        EXCEPTIONS
          file_write_error        = 1
          no_batch                = 2
          gui_refuse_filetransfer = 3
          invalid_type            = 4
          no_authority            = 5
          unknown_error           = 6
          header_not_allowed      = 7
          separator_not_allowed   = 8
          filesize_not_allowed    = 9
          header_too_long         = 10
          dp_error_create         = 11
          dp_error_send           = 12
          dp_error_write          = 13
          unknown_dp_error        = 14
          access_denied           = 15
          dp_out_of_memory        = 16
          disk_full               = 17
          dp_timeout              = 18
          file_not_found          = 19
          dataprovider_exception = 20
          control_flush_error     = 21
          OTHERS                  = 22.

      IF sy-subrc <> 0.
        MESSAGE e063(5v).
*   No records down/uploaded
      ENDIF.

    WHEN con_upload.

      CALL FUNCTION 'TMP_GUI_FILE_OPEN_DIALOG'
        EXPORTING
          window_title = 'UPLOAD'
        TABLES
          file_table   = l_tab
        EXCEPTIONS
          cntl_error   = 1
          OTHERS       = 2.
      IF sy-subrc <> 0.
      ENDIF.

      READ TABLE l_tab INTO l_wa_tab INDEX 1.
      l_path = l_wa_tab.

      CALL FUNCTION 'GUI_UPLOAD'
        EXPORTING
          filename                = l_path
        TABLES
          data_tab                = l_data_tab
        EXCEPTIONS
          file_open_error         = 1
          file_read_error         = 2
          no_batch                = 3
          gui_refuse_filetransfer = 4
          invalid_type            = 5
          no_authority            = 6
          unknown_error           = 7
          bad_data_format         = 8
          header_not_allowed      = 9
          separator_not_allowed   = 10
          header_too_long         = 11
          unknown_dp_error        = 12
          access_denied           = 13
          dp_out_of_memory        = 14
          disk_full               = 15
          dp_timeout              = 16
          OTHERS                  = 17.

      IF sy-subrc <> 0.
        MESSAGE e063(5v).
*   No records down/uploaded
      ENDIF.

      CREATE DATA l_wa_ref TYPE (tabname).
      ASSIGN l_wa_ref->* TO <l_wa_tab>.

      CALL METHOD cl_abap_typedescr=>describe_by_name
        EXPORTING
          p_name         = tabname
        RECEIVING
          p_descr_ref    = l_descr_ref
        EXCEPTIONS
          type_not_found = 1
          OTHERS         = 2.
      IF sy-subrc <> 0.
        .
      ENDIF.

      l_struc_ref ?= l_descr_ref.

      LOOP AT l_data_tab ASSIGNING <l_string>.
        CLEAR l_offset.
        LOOP AT l_struc_ref->components ASSIGNING <f1>.
          <l_wa_tab>+l_offset(<f1>-length) =
                                <l_string>+l_offset(<f1>-length).

          l_offset = l_offset + <f1>-length.

        ENDLOOP.

        MODIFY (tabname) FROM <l_wa_tab>.

      ENDLOOP.

endcase.

Customizing: Variants for Real-Time Integration CO -> FI

2011-07-20T05:59:00.000-07:00

In individual RTI-Variants, Document Lines can be extendetd to i.e. Cross-Functional Area. Like this, FI line items are updated during Cost Centre/Internal Order assessment/settelment. Maintanance via SPRO.

Bilanzstrukturen - Tabellen und Transaktionen

2011-07-01T05:55:00.000-07:00

Tabellen

T011 - Financial Statement Versions
FAGL_011FC - Assignment FS Item - Funct. Areas
FAGL_011PC - Items in Fin. Statement Structure
FAGL_011QT - Text for Fin. Statement Items
FAGL_011SC - Assignment Fin. Stmnt Item: Setname
FAGL_011TC - Timestamp for Fin. Stmt Items
FAGL_011VC - Contra Items
FAGL_011ZC - Assignment FS Items - G/L Account

Transaktionen

OB58 - Change Financial Statement Versions
FSE2 - Change Financial Statement Versions

Erster Post

2011-07-01T02:21:00.001-07:00

Der initiale Post in diesem Blog

Important Tables

2011-01-01T05:59:00.000-08:00

GL

SKA1 GL Accounts A-Segment
SKB1 GL Accounts B-Segment
SKAT GL Accounts Text
BKPF Document Header
BSEG Document Item
BSEG_ADD Document Item (AAA)
BSIS GL Open Items
BSAS GL Cleared Items

AP

LFA1 Vendor A-Segment
ADRC Address Data
LFB1 Vendor B-Segment
LFM1 Vendor M-Segment
BSIK Vendor Open Items
BSAK Vendor Cleared Items

AR

KNA1 Vendor A-Segment
ADRC Address Data
KNB1 Vendor B-Segment
KNVV Vendor V-Segment
BSID Vendor Open Items
BSAD Vendor Cleared Items

AA

ANLA AA Master Data
ANLT AA Master Data Text
ANKA AA Class Master Data A-Segment
ANKB AA Class Master Data B-Segment
ANEK AA Document Header
ANEP AA Document Item
ANLC AA Value Fields

BK

BNKA Bank Master Data

CO

CSKA Cost Elements A-Segment
CSKB Cost Elements B-Segment
CSKU Cost Elements Text
CSKS Cost Center Master Data
CSKT Cost Center Master Data Text
AUFK Internal Order Master Data
CEPC Profit Center Master Data
COEP CO Documents (via period)
COEJ CO Documents (via year)
COSS Totals CO Documents (internal)
COSP Totals CO Documents external
COSR Totals CO Documents Stat. Figures

MM

MARA Material Master Data
MAKT Material Master Data Text
EBAN Purchase Requisition
EKKO Purchase Order Header
EKPO Purchase Order Item
MKPF Material Document Header
MSEG Material Document Item

SD

VBAK Sales Order Header
VBAP Sales Order Item
VBRK Billing Document Header
VBRP Billing Document Item

Important Transaction Codes

2011-01-01T03:06:00.000-08:00

Consolidation
CXCD - Data Collection Monitor

Accounting
GRR3 - Display Report Painter Reports
GS02 - Set Maintanance
GD12 - Display Total Records - General Ledger
GD13 - Display Total Records - Special Ledger
OB28 - Validations
OBBH - Substitutions
OBC4 - Display Field Statu Groups

Controlling

Generic

PFCG - Rollenpflege
SE16 - Data Browser
SE16n - New Data Browser
SE81 - Anzeigen Anwendungskomponenten
SE93 - Transactions
SU01 - User
SU01D - User Display
SU24 - Berechtigungsobjekte zu Transaktionen