среда, 11 марта 2015 г.

На новой системе проблема при загрузке файлов, с признаком Material

Если запрещённыые символы:
 t-Code RSKC = ALL_CAPITAL*



t-Code SPRO - SAP NetWeaver - Business Warehouse - Общие параметры настройки - Настройка представления номера материала

На новой системе ошибка загрузки текстов. rsdmd 194

Тема.

Включаем t-Code RSKC - ALL_CAPITAL_PLUS_HEX


А вообще-то:

Note 1580561:Error RSDMD194 when loading BW master data


Symptom
Your BW master data load fails with the following RSDMD 194 error, viewable in the Details tab of the load monitor:
  • <characteristic_name>: Data record <number> ('........'): Version '........ ' is not valid
    Message no. RSDMD194
There may be some additional errors mentioned in the monitor, such as:
  • Too many error records - update terminated
    Message no. RSM2706
  • Error occurred in UPDATE_INFOCUBE for data target <technical name>
    Message no. RSAU499

Environment
  • Business Warehouse BW
  • Business Intelligence BI

Reproducing the Issue
Run a BW masterdata load of records which contain characters that the BW system doesn't recognise.

Cause
  • The error message RSDMD 194 means that you tried to load non-permitted characters into the BW system. Control characters from HEX00 to HEX1F are forbidden characters as per SAP Note 1075403 & such characters are not allowed in BW.
  • Often this issue is due to the fact that lowercase characters are not allowed in BW by default.

Resolution
In general, to resolve this RSDMD 194 problem, you would either:
  • remove the non-permitted character(s) in the source system of the particular load,
  • or you should change/convert these values to something acceptable using an ABAP routine within the transfer rules/update rules/transformation for each affected master data load (refer to those relevant SDN threads which contain sample code).
For the lowercase characters restriction, you must permit such characters at characteristic/InfoObject level as follows:
  1. Goto tcode RSD1
  2. enter the relevant characteristic/InfoObject name
  3. click the Change button
  4. in the General tab of the resultant screen, tick on the "Lowercase Letters" checkbox (see below screenshot).
  5. Do likewise for all other characteristics mentioned in the RSDMD 194 error message of the failing request.
  6. Reactivate the relevant DataSource(s) before reloading the data.
char_lowercase_flag.bmp

Keywords
PSA, masterdata, error 4, RSAR 119, RSM2 704, RSM2 706, RSDMD 190, RSAU 499, BRAIN060, BRAIN 060, BRAIN60.

References
This document refers to:
CSS SAP Notes
1373402Issues with invalid characters or SID Generation
1075403Unallowed characters and ALL_CAPITAL
173241Allowed characters in the BW System

На новой системе не собирается поток до\после от объекта

Надо поставить галку для исходной системы (левый желтый значок - Присвоение исходных систем):

среда, 4 февраля 2015 г.

Dump ITAB_DUPLICATE_KEY

После копирования системы возникают ошибки с переносами и (как у меня с запуском цепочки). Один из способов лечения – проверить системную таблицу RSISOSMAP, ниже привожу выдержку из текста сап ноты (сама нота в pdf прилагается).
Reproducing the Issue
  1. Trigger the problematic DTP via transaction code RSA1
  2. Use the monitor function to view the DTP details/log
  3. Transaction code ST22 will contain the relevant ITAB_DUPLICATE_KEY dump.
Cause
This ABAP dump indicates that there may be duplicate transfer structure entries in the table RSISOSMAP.
This type of inconsistency normally happens only after system copies.
Resolution

In transaction code SE38, execute program RS_FIND_ISOSMAP_DUPREC to identify if there are any duplicate transfer structure names in table RSISOSMAP.
If there are duplicates, you can delete these by executing program RSAR_RSISOSMAP_REPAIR in Repair mode via SE38.

понедельник, 2 февраля 2015 г.

Чистаем основные данные в правилах (чтобы подсматривать)

*"----------------------------------------------------------------------
   
DATA : l_chavl   TYPE rsd_chavl.

    l_chavl
= source_fields-/bic/nccredit .


   
CALL FUNCTION 'RSAU_READ_MASTER_DATA'
     
EXPORTING
        i_iobjnm 
= 'NCCHCRKK'
        i_chavl  
= l_chavl
        i_attrnm 
= 'NCCRKK'
        i_date   
= l_date
     
IMPORTING
        e_attrval
= l_crkk
                   
EXCEPTIONS
                   
OTHERS.

*-----------------------------------------------------------------------


среда, 28 января 2015 г.

Как быстро описать тип с известной структурой + вызов OpenSQL (чтобы подсматривать)

    types begin of ty_source_package.
            include type _ty_s_sc_1.
    types summa type /bic/oinfrest.
    types end of ty_source_package.



          lt_source_package type standard table of ty_source_package,
          wa_source_package like line of lt_source_package, 



или
          wa_source_package type ty_source_package,